CS
Terms
PX.Objects.CSView API Entity: Terms
/entity/Default/24.200.001/Terms26 of 26 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
TermsID | nvarchar(10) | Terms ID | - | |
Description:Key field. Unique identifier of the Credit Terms record. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
DayDisc | smallint | Discount 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 | smallint | Due 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 | smallint | Due Day 2 | - | |
Description:The second Due Date used with Custom (""C"") DueType (see DayFrom01 and DayTo01). Corresponds to a day of the month. | ||||
DayFrom00 | smallint | Day 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 | smallint | Day 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 | smallint | Day 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 | smallint | Day 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 | smallint | Number 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""). | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
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 | bit | Prepayment 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. | ||||