Diagrams


Table

Payment Terms

DynamicsDocs.comPayment Terms«Table 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. MemosLast Modified Date TimeId«Table 1300»Mini Customer TemplateKey [PK]Code [NN]Template Name [NN]CityDocument Sending ProfileCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodePayment Terms CodeFin. Charge Terms CodeCustomer Disc. GroupCountry/Region CodePrint StatementsPayment Method CodeApplication Method; [Manual,Apply to O...Prices Including VATGen. Bus. Posting GroupPost CodeCountyReminder Terms CodeVAT Bus. Posting GroupBlock Payment ToleranceAllow Line Disc.Validate EU Vat Reg. No.«Table 1303»Mini Vendor TemplateKey [PK]Code [NN]Template Name [NN]CityVendor Posting GroupCurrency CodeLanguage CodePayment Terms CodeFin. Charge Terms CodeInvoice Disc. CodeCountry/Region CodePayment Method CodeApplication Method; [Manual,Apply to O...Prices Including VATGen. Bus. Posting GroupPost CodeCountyVAT Bus. Posting GroupBlock Payment ToleranceValidate EU Vat Reg. No.«Table 172»Standard Customer Sales CodeCustomer No. [PK,NN]Code [PK,NN]DescriptionValid From DateValid To datePayment Method CodePayment Terms CodeDirect Debit Mandate IDBlocked«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 2110»O365 Sales Initial SetupPrimary Key [PK]Payment Reg. Template NamePayment Reg. Batch NameIs initializedDefault Customer TemplateDefault Item TemplateDefault Payment Terms CodeDefault Payment Method CodeSales Invoice No. SeriesPosted Sales Inv. No. SeriesTax Type; [VAT,Sales Tax]Default VAT Bus. Posting GroupNormal VAT Prod. Posting Gr.Reduced VAT Prod. Posting Gr.Zero VAT Prod. Posting Gr.C2Graph EndpointSales Quote No. SeriesEngage EndpointCoupons Integration EnabledGraph Enablement Reminder«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 289»Payment MethodCode [PK,NN]DescriptionBal. Account Type; [G/L Account,Bank A...Bal. Account No.Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. TypeUse for InvoicingLast Modified Date TimeId«Table 462»Payment Term TranslationPayment Term [PK]Language Code [PK]Description«Table 5105»Customer TemplateCode [PK,NN]DescriptionTerritory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeCustomer Posting GroupCurrency CodeCustomer Price GroupPayment Terms CodeShipment Method CodeInvoice Disc. CodeCustomer Disc. GroupCountry/Region CodePayment Method CodePrices Including VATGen. Bus. Posting GroupVAT Bus. Posting GroupContact Type; [Company,Person]Allow Line Disc.«Table 5475»Sales Invoice Entity AggregateDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No. [NN]No. [PK]Your ReferencePosting DatePayment Terms CodeDue DateShipment Method CodeCustomer Posting GroupCurrency CodePrices Including VATSalesperson CodeOrder No.Recalculate Invoice Disc.AmountAmount Including VATVAT Registration No.Sell-to Customer NameSell-to AddressSell-to Address 2Sell-to CitySell-to ContactSell-to Post CodeSell-to CountySell-to Country/Region CodeDocument DateExternal Document No.Tax Area CodeTax LiableVAT Bus. Posting GroupInvoice Discount Calculation; [None,%,......«Table 5477»Purch. Inv. Entity AggregateDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No. [NN]No. [PK]Your ReferencePayment Terms CodeDue DateShipment Method CodeVendor Posting GroupCurrency CodePrices Including VATPurchaser CodeOrder No.Recalculate Invoice Disc.AmountAmount Including VATVendor Invoice No.Buy-from Vendor NameBuy-from AddressBuy-from Address 2Buy-from CityBuy-from ContactBuy-from Post CodeBuy-from CountyBuy-from Country/Region CodeDocument DateVendor Ledger Entry No.Invoice Discount AmountBuy-from Contact No.IdTotal Tax AmountStatus; [,Draft,In Review,Open,Paid,Ca......<Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Cash Flow Payment Terms Code><Payment Terms Id><Default Payment Terms Code><Payment Terms Code><Cash Flow Payment Terms Code><Payment Terms Id><Direct Debit Pmt. Terms Code><Payment Term><Payment Terms Code><Payment Terms Code><Payment Terms Id><Payment Terms Code><Payment Method Code><Invoice Disc. Code><Payment Method Code><Customer No.><Payment Method Code><Bill-to Customer No.><Payment Method Code><Payment Method Id><Sell-to Customer No.><Customer Id><Default Payment Method Code><Pay-to Vendor No.><Payment Method Code><Payment Method Id><Buy-from Vendor No.><Vendor Id><Payment Method Code>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Code Code10 NotBlank: Yes
2 Due Date Calculation DateFormula
3 Discount Date Calculation DateFormula
4 Discount % Decimal (0:5)
5 Description Text50
6 Calc. Pmt. Disc. on Cr. Memos Boolean
8 Last Modified Date Time DateTime Editable: No
8000 Id GUID

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Cash Flow Worksheet Line Payment Terms Code 1..n
Customer Payment Terms Id 1..n
Customer Template Payment Terms Code 1..n
Filed Service Contract Header Payment Terms Code 1..n
Gen. Journal Line Payment Terms Code 1..n
Mini Customer Template Payment Terms Code 1..n
Mini Vendor Template Payment Terms Code 1..n
O365 Sales Initial Setup Default Payment Terms Code 1..n
Payment Method Direct Debit Pmt. Terms Code 1..n
Payment Term Translation Payment Term 1..n
Purch. Cr. Memo Hdr. Payment Terms Code 1..n
Purch. Inv. Entity Aggregate Payment Terms Code 1..n
Purch. Inv. Header Payment Terms Code 1..n
Purch. Rcpt. Header Payment Terms Code 1..n
Purchase Header Prepmt. Payment Terms Code 1..n
Purchase Header Archive Prepmt. Payment Terms Code 1..n
Return Receipt Header Payment Terms Code 1..n
Return Shipment Header Payment Terms Code 1..n
Sales Cr. Memo Entity Buffer Payment Terms Id 1..n
Sales Cr.Memo Header Payment Terms Code 1..n
Sales Header Prepmt. Payment Terms Code 1..n
Sales Header Archive Prepmt. Payment Terms Code 1..n
Sales Invoice Entity Aggregate Payment Terms Id 1..n
Sales Invoice Header Payment Terms Code 1..n
Sales Order Entity Buffer Payment Terms Id 1..n
Sales Quote Entity Buffer Payment Terms Id 1..n
Sales Shipment Header Payment Terms Code 1..n
Service Contract Header Payment Terms Code 1..n
Service Cr.Memo Header Payment Terms Code 1..n
Service Header Payment Terms Code 1..n
Service Invoice Header Payment Terms Code 1..n
Service Shipment Header Payment Terms Code 1..n
Standard Customer Sales Code Payment Terms Code 1..n
Standard General Journal Line Payment Terms Code 1..n
Vendor Payment Terms Id 1..n