Payment Terms
In ScopeTechnical: PaymentTerm | ID: D365FO-FND-PAYMENTTERM-PAYMENT_TERMS
See how this object fits into Foundation Shared Setup
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Low
- Sequencing
- Stage 1 - Master Data
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- PaymentTerm
Field Definitions(5)
Sample Load Data(4)
| _scenario | TERMDAYSR | DESCRIPTIONR | PAYMENTTERMCODERPK | CutoffDay | PaymentDay | PaymentTermType | CashDiscountDays | PaymentDueOffsetDays | CashDiscountPercentage | CashDiscountCalculation | CashDiscountGracePeriod | CashDiscountAccountSelection |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 30 | Net 30 days | NET30 | 0 | 0 | Net | 0 | 0 | 0.0 | InvoiceAmount | 0 | TotalInvoice |
| 2% 10 Net 30 days | 30 | 2% discount if paid in 10 days, otherwise Net 30 days | 2_10_NET30 | 0 | 0 | Net | 10 | 0 | 0.02 | InvoiceAmount | 0 | TotalInvoice |
| End of Month (EOM) with 25th cutoff | 0 | Payment due end of current month if invoiced by 25th, otherwise end of next month | EOM25 | 25 | 0 | CurrentMonth | 0 | 0 | 0 | InvoiceAmount | 0 | TotalInvoice |
Example values from field definitions
- TERMDAYSR
- 30
- DESCRIPTIONR
- Net 30 days
- PAYMENTTERMCODERPK
- NET30
- CutoffDay
- 0
- PaymentDay
- 0
- PaymentTermType
- Net
- CashDiscountDays
- 0
- PaymentDueOffsetDays
- 0
- CashDiscountPercentage
- 0.0
- CashDiscountCalculation
- InvoiceAmount
- CashDiscountGracePeriod
- 0
- CashDiscountAccountSelection
- TotalInvoice
2% 10 Net 30 days
- TERMDAYSR
- 30
- DESCRIPTIONR
- 2% discount if paid in 10 days, otherwise Net 30 days
- PAYMENTTERMCODERPK
- 2_10_NET30
- CutoffDay
- 0
- PaymentDay
- 0
- PaymentTermType
- Net
- CashDiscountDays
- 10
- PaymentDueOffsetDays
- 0
- CashDiscountPercentage
- 0.02
- CashDiscountCalculation
- InvoiceAmount
- CashDiscountGracePeriod
- 0
- CashDiscountAccountSelection
- TotalInvoice
End of Month (EOM) with 25th cutoff
- TERMDAYSR
- 0
- DESCRIPTIONR
- Payment due end of current month if invoiced by 25th, otherwise end of next month
- PAYMENTTERMCODERPK
- EOM25
- CutoffDay
- 25
- PaymentDay
- 0
- PaymentTermType
- CurrentMonth
- CashDiscountDays
- 0
- PaymentDueOffsetDays
- 0
- CashDiscountPercentage
- 0
- CashDiscountCalculation
- InvoiceAmount
- CashDiscountGracePeriod
- 0
- CashDiscountAccountSelection
- TotalInvoice
Rule Validation Summary
- Source Rule Count
- 12
- Governed Rule Count
- 12