Updated: 2009-09-21
Version: Control 4.4
Table Purpose, Usage, and Notes
This table is …
Information on Table Data
- ClassTypeIDs Stores in Table:
- 16000 - Payment Terms
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| PaymentTerms.AllowEarlyPaymentDiscount | bit | ||||||
| PaymentTerms.ClassTypeID | int | Identifier for the Type of Object | |||||
| PaymentTerms.CompoundInterest | bit | ||||||
| PaymentTerms.EarlyPaymentDays | int | ||||||
| PaymentTerms.EarlyPaymentDiscount | float | ||||||
| PaymentTerms.FeesBasedOnSaleDate | bit | ||||||
| PaymentTerms.GracePeriod | int | ||||||
| PaymentTerms.ID | int | Primary Key for the Table | |||||
| PaymentTerms.interestRate | decimal(18, 4) | ||||||
| PaymentTerms.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
| PaymentTerms.IsSystem | bit | Used to Mark Required Records | |||||
| PaymentTerms.MessageText | Text | ||||||
| PaymentTerms.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||
| PaymentTerms.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||
| PaymentTerms.ModifiedDate | datetime | DateTime this Record was last modified | |||||
| PaymentTerms.PromptOnOrderSave | bit | ||||||
| PaymentTerms.SeqID | int | ||||||
| PaymentTerms.StartGraceAtMonthsEnd | bit | ||||||
| PaymentTerms.StatementText0To30 | text | ||||||
| PaymentTerms.StatementText31To60 | text | ||||||
| PaymentTerms.StatementText61To90 | text | ||||||
| PaymentTerms.StatementTextOver90 | text | ||||||
| PaymentTerms.StoreID | int | Not Used. | |||||
| PaymentTerms.TermsName | nvarchar(25) | ||||||
| PaymentTerms.TermsType | int |
Related Tables
You could leave a comment if you were logged in.