Skip to main content
CS

Terms

PX.Objects.CS
Field NameTypeDisplay NameForeign Key
TermsIDDefault Navigation
nvarchar(10)Terms ID-
Description:Key field. Unique identifier of the Credit Terms record.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
DayDisc
smallintDiscount Day-
Description:The number of days or a particular day of the month (depending on the value of DiscType), during/before which the Cash Discount is applicable for the document.
DayDue00
smallintDue Day 1-
Description:Defines the first Due Date for the terms. The meaning of this field varies depending on the value of the DueType field. For Fixed Number of Days, this field is interpreted as the number of days between the document date and its Due Date; for Day of the Month and Day of Next Month the field holds the day of the month; for Custom DueType, this field is interpreted as the first Due Date (see DayFrom00 and DayTo00).
DayDue01
smallintDue Day 2-
Description:The second Due Date used with Custom (""C"") DueType (see DayFrom01 and DayTo01). Corresponds to a day of the month.
DayFrom00
smallintDay From 1-
Description:The start day of the range, for which the Due Date of the document is set to the first due date. This field is relevant only for the Terms with Custom (""C"") DueType. Corresponds to a day of the month.
DayFrom01
smallintDay From 2-
Description:The start day of the range, for which the Due Date of the document is set to the second due date. This field is relevant only for the Terms with Custom (""C"") DueType. Corresponds to a day of the month.
DayTo00
smallintDay To 1-
Description:The end day of the range, for which the Due Date of the document is set to the first due date. This field is relevant only for the Terms with Custom (""C"") DueType. Corresponds to a day of the month.
DayTo01
smallintDay To 2-
Description:The end day of the range, for which the Due Date of the document is set to the second due date. This field is relevant only for the Terms with Custom (""C"") DueType. Corresponds to a day of the month.
Descr
nvarchar(60)Description-
Description:The description of the Credit Terms.
DiscPercent
decimal(9, 6)Discount %-
Description:The percent of the Cash Discount under these Terms.
DiscType
char(1)Discount Type-
Description:Defines how the system determines whether Cash Discount is applicable for a document under these Terms on a particular date . Allowed values are: ""N"" - Fixed Number of Days, ""D"" - Day of Next Month, ""E"" - End of Month, ""M"" - End of Next Month, ""T"" - Day of the Month, ""P"" - Fixed Number of Days starting Next Month. Defaults to Fixed Number of Days (""N"").
DueType
char(1)Due Date Type-
Description:Determines the way the Due Date is calucalated for documents under these Terms. Allowed values are: ""N"" - Fixed Number of Days, ""D"" - Day of Next Month, ""E"" - End of Month, ""M"" - End of Next Month, ""T"" - Day of the Month, ""P"" - Fixed Number of Days starting Next Month, ""C"" - Custom. Defaults to ""N"" - Fixed Number of Days.
InstallmentCntr
smallintNumber of Installments-
Description:The number of Installments for these Terms. The field is relevant only if the InstallmentType is Multiple (""M"").
InstallmentFreq
char(1)Installment Frequency-
Description:The frequency of Installments for these Terms. The field is relevant only if the InstallmentType is Multiple (""M"") and the InstallmentMthd is not Split by Percents in Table (""S""). Allowed values are: ""W"" - Weekly, ""M"" - Monthly, ""B"" - Semi-monthly (the second installment comes a half a month after the first one, and so on).
InstallmentMthd
char(1)Installment Method-
Description:The method, according to which the amounts of installments are calculated. The field is relevant only if the InstallmentType is Multiple (""M""). Allowed values are: ""E"" - Equal Parts, ""A"" - All Tax in First Installment (the total amount before tax is split equally between installments and the entire amount of tax is added to the first installment), ""S"" - Split by Percents in Table (the days and amounts of installments are defined by the related TermsInstallments records).
InstallmentType
char(1)Installment Type-
Description:The type of installment. Allowed values are: ""S"" - Single, ""M"" - Multiple. Defaults to Single (""S"").
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
NoteID
uniqueidentifier-
Description:No description available
PrepaymentPct
decimal(9, 6)Prepayment Percent-
Description:The percent of the Sales Order's Prepayment.
PrepaymentRequired
bitPrepayment Required-
Description:Indicates that percent of the Sales Order's Prepayment is more than zero.
VisibleTo
char(2)Visible To-
Description:Determines the categories of Business Accounts, for whom these terms can be used. Allowed values are: ""AL"" - All, ""VE"" - Vendors only, ""CU"" - Customers only, ""DS"" - Disabled (can't be selected for Business Accounts or documents of any module). Defaults to ""AL"" - All.