Payment Terms
The payment terms view object contains information about payment terms, including reference set, name, description, billing cycle, base amount, discount basis, discount basis date, from date, to date, print lead days, and installment option. Payment terms are used to calculate payment due dates and discounts given for early payment.
Data Store Key : FscmTopModelAM.FinExtractAM.ArBiccExtractAM.PaymentTermExtractPVO
Primary Keys : RaTermBTermId
Initial Extract Date : RaTermBCreationDate
Incremental Extract Date : RaTermBLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
RaTermBAttribute1 | A segment of the Payment Terms descriptive flexfield 1. |
RaTermBAttribute10 | A segment of the Payment Terms descriptive flexfield 10. |
RaTermBAttribute11 | A segment of the Payment Terms descriptive flexfield 11. |
RaTermBAttribute12 | A segment of the Payment Terms descriptive flexfield 12. |
RaTermBAttribute13 | A segment of the Payment Terms descriptive flexfield 13. |
RaTermBAttribute14 | A segment of the Payment Terms descriptive flexfield 14. |
RaTermBAttribute15 | A segment of the Payment Terms descriptive flexfield 15. |
RaTermBAttribute2 | A segment of the Payment Terms descriptive flexfield 2. |
RaTermBAttribute3 | A segment of the Payment Terms descriptive flexfield 3. |
RaTermBAttribute4 | A segment of the Payment Terms descriptive flexfield 4. |
RaTermBAttribute5 | A segment of the Payment Terms descriptive flexfield 5. |
RaTermBAttribute6 | A segment of the Payment Terms descriptive flexfield 6. |
RaTermBAttribute7 | A segment of the Payment Terms descriptive flexfield 7. |
RaTermBAttribute8 | A segment of the Payment Terms descriptive flexfield 8. |
RaTermBAttribute9 | A segment of the Payment Terms descriptive flexfield 9. |
RaTermBAttributeCategory | The descriptive flexfield context name of the Payment Terms descriptive flexfield. |
RaTermBBaseAmount | The sum of all of the relative amounts due in the installments of a split payment terms payment schedule. |
RaTermBBillingCycleId | The identifier of the payment terms billing cycle. |
RaTermBCalcDiscountOnLinesFlag | The discount basis amount to use amount to calculate discounts for the payment terms. Valid values are: Invoice Amount, Lines Only, Lines and Tax not Fright Items and Tax, and Lines, Freight Items, and Tax. |
RaTermBCreatedBy | The user who created the payment terms. |
RaTermBCreationDate | The date and time the payment terms were created. |
RaTermBCreditCheckFlag | The option that indicates whether the bill-to customer with the payment terms is included in credit checking. |
RaTermBDescription | The description of the payment terms. |
RaTermBDiscountBasisDateType | The date to use to calculate discounts on payments received for transactions with the payment terms. Valid values are: Receipt Date, Receipt Application Date, and Deposit Date. |
RaTermBDueCutoffDay | The cutoff day with payment terms when the due date is extended one month. |
RaTermBEndDateActive | The end date of the payment terms. |
RaTermBFirstInstallmentCode | The option that indicates whether to include tax and freight in the first installment or to allocate tax and freight across all installments of the payment terms payment schedule. |
RaTermBInUse | The option that indicates whether the payment terms are referenced in a transaction. |
RaTermBLastUpdateDate | The date and time the payment terms were last updated. |
RaTermBLastUpdateLogin | The session login of the user who last updated the payment terms. |
RaTermBLastUpdatedBy | The user who last updated the payment terms. |
RaTermBModuleId | Seed Data Framework: indicates the module that owns the payment terms row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row isn't specified, then the Seed Data Framework won't extract the row as seed data. |
RaTermBName | The name of the payment terms. |
RaTermBObjectVersionNumber | The number used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a payment terms to detect whether another session has updated the row since it was queried. |
RaTermBPartialDiscountFlag | The option that indicates whether customers can take discounts for partial payments on items associated with the payment terms. |
RaTermBPrepaymentFlag | The option to enable in order to create prepayment payment terms. Transactions assigned prepayment payment terms require prepayment for goods and services. |
RaTermBPrintingLeadDays | The number of days before the due date that transactions with the payment terms are eligible for printing. |
RaTermBSeedDataSource | The source of the payment terms seed data record. A value of BULK_SEED_DATA_SCRIPT indicates that the record was uploaded in bulk. Otherwise, it specifies the name of the seed data file. |
RaTermBSetId | The identifier of the payment terms reference set. |
RaTermBStartDateActive | The start date of the payment terms. |
RaTermBTermId | The identifier of the payment terms. |
RaTermTLCreatedBy | The user who created the payment terms translation. |
RaTermTLCreationDate | The date and time the payment terms translation was created. |
RaTermTLDescription | The description of the payment terms translation. |
RaTermTLLanguage | The code of the target language for the payment terms translation. |
RaTermTLLastUpdateDate | The date and time the payment terms translation was last updated. |
RaTermTLLastUpdateLogin | The session login of the user who last updated the payment terms translation. |
RaTermTLLastUpdatedBy | The user who last updated the payment terms translation. |
RaTermTLName | The name of the payment terms translation. |
RaTermTLObjectVersionNumber | The number used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a payment terms translation to detect whether another session has updated the row since it was queried. |
RaTermTLSeedDataSource | The source of the translated payment terms seed data record. A value of BULK_SEED_DATA_SCRIPT indicates that the record was uploaded in bulk. Otherwise, it specifies the name of the seed data file. |
RaTermTLSetId | The payment terms translation reference set. |
RaTermTLSourceLang | The code of the original language for the payment terms translation. |
RaTermTLTermId | The identifier of the payment terms for the payment terms translation. |