Diagrams

Table

Payment Terms

DynamicsDocs.comPayment Terms«Table 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. Memos«Table 110»Sales Shipment HeaderSell-to Customer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«Table 112»Sales Invoice HeaderSell-to Customer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«Table 114»Sales Cr.Memo HeaderSell-to Customer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactPosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency Factor...«Table 120»Purch. Rcpt. HeaderBuy-from Vendor No. [NN]No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting GroupCurrency Code...«Table 122»Purch. Inv. HeaderBuy-from Vendor No. [NN]No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting GroupCurrency Code...«Table 124»Purch. Cr. Memo Hdr.Buy-from Vendor No. [NN]No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactPosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting GroupCurrency CodeCurrency Factor...«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.«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 Tolerance«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. Series«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. Type«Table 36»Sales HeaderDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 38»Purchase HeaderDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting Group...«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 CodeGen. Bus. Posting GroupVAT Bus. Posting GroupAllow Line Disc.«Table 5107»Sales Header ArchiveDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 5109»Purchase Header ArchiveDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting Group...«Table 5900»Service HeaderDocument Type; [Quote,Order,Invoice,Cr...Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder Date [NN]Posting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«Table 5965»Service Contract HeaderContract No. [PK]Contract Type; [Quote,Contract] [PK]DescriptionDescription 2Status; [,Signed,Canceled]Change Status; [Open,Locked]Customer No. [NN]NameAddressAddress 2Post CodeCityContact NameYour ReferenceSalesperson CodeBill-to Customer No.Bill-to NameBill-to AddressBill-to Address 2Bill-to Post CodeBill-to CityShip-to CodeShip-to NameShip-to AddressShip-to Address 2Ship-to Post CodeShip-to CityServ. Contract Acc. Gr. CodeInvoice Period; [Month,Two Months,Quar...Last Invoice DateNext Invoice Date...«Table 5970»Filed Service Contract HeaderContract No.Contract Type; [Quote,Contract]DescriptionDescription 2Status; [,Signed,Canceled]Change Status; [Open,Locked]Customer No. [NN]NameAddressAddress 2Post CodeCityContact NameYour ReferenceSalesperson CodeBill-to Customer No.Bill-to NameBill-to AddressBill-to Address 2Bill-to Post CodeBill-to CityShip-to CodeShip-to NameShip-to AddressShip-to Address 2Ship-to Post CodeShip-to CityServ. Contract Acc. Gr. CodeInvoice Period; [Month,Two Months,Quar...Last Invoice DateNext Invoice Date...«Table 5990»Service Shipment HeaderCustomer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder Date [NN]Posting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency FactorCustomer Price Group...«Table 5992»Service Invoice HeaderCustomer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder Date [NN]Posting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency FactorCustomer Price Group...«Table 5994»Service Cr.Memo HeaderCustomer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactPosting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency FactorCustomer Price GroupPrices Including VAT...«Table 6650»Return Shipment HeaderBuy-from Vendor No. [NN]No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactPosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting GroupCurrency CodeCurrency Factor...«Table 6660»Return Receipt HeaderSell-to Customer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«Table 751»Standard General Journal LineJournal Template Name [PK,NN]Line No. [PK,NN]Account Type; [G/L Account,Customer,Ve...Account No.Document Type; [,Payment,Invoice,Credi...DescriptionVAT %Bal. Account No.Currency CodeAmountDebit AmountCredit AmountAmount [LCY]Balance [LCY]Currency FactorSales/Purch. [LCY]Profit [LCY]Inv. Discount [LCY]Bill-to/Pay-to No.Posting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeSalespers./Purch. CodeSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Payment Discount %Job No.QuantityVAT AmountPayment Terms Code...«Table 81»Gen. Journal LineJournal Template Name [PK]Line No. [PK]Account Type; [G/L Account,Customer,Ve...Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionVAT %Bal. Account No.Currency CodeAmountDebit AmountCredit AmountAmount [LCY]Balance [LCY]Currency FactorSales/Purch. [LCY]Profit [LCY]Inv. Discount [LCY]Bill-to/Pay-to No.Posting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeSalespers./Purch. CodeSource CodeSystem-Created EntryOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.Due Date...«Table 846»Cash Flow Worksheet LineLine No. [PK]Cash Flow Forecast No.Cash Flow DateDocument No.Cash Flow Account No.Source Type; [,Receivables,Payables,Li...DescriptionDocument Type; [,Payment,Invoice,Credi...Document DatePmt. Discount DatePmt. Disc. Tolerance DatePayment Terms CodePayment DiscountAssociated Entry No.OverdueShortcut Dimension 2 CodeShortcut Dimension 1 CodeAmount [LCY]Source No.G/L Budget NameDimension Set ID<Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Cash Flow Payment Terms Code><Default Payment Terms Code><Payment Terms Code><Cash Flow Payment Terms Code><Direct Debit Pmt. Terms Code><Payment Terms Code><Prepmt. Payment Terms Code><Payment Terms Code><Prepmt. Payment Terms Code><Payment Term><Payment Terms Code><Payment Terms Code><Prepmt. Payment Terms Code><Payment Terms Code><Prepmt. Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Sell-to Customer No.><Bill-to Customer No.><Payment Method Code><Last Shipping No.><Last Shipping No.><Last Shipping No.><Sell-to Customer No.><Bill-to Customer No.><Payment Method Code><Last Posting No.><Last Prepayment No.><Last Posting No.><Last Prepayment No.><Last Prepmt. Cr. Memo No.><Last Prepayment No.><Last Prepmt. Cr. Memo No.><Last Posting No.><Sell-to Customer No.><Bill-to Customer No.><Payment Method Code><Last Prepmt. Cr. Memo No.><Buy-from Vendor No.><Pay-to Vendor No.><Sell-to Customer No.><Payment Method Code><Last Receiving No.><Last Receiving No.><Buy-from Vendor No.><Pay-to Vendor No.><Sell-to Customer No.><Payment Method Code><Last Posting No.><Last Prepayment No.><Last Posting No.><Buy-from Vendor No.><Pay-to Vendor No.><Sell-to Customer No.><Payment Method Code><Last Prepmt. Cr. Memo No.><Payment Method Code><Invoice Disc. Code><Payment Method Code><Customer No.><Payment Method Code><Bill-to Customer No.><Payment Method Code><Sell-to Customer No.><Bill-to Customer No.><Sell-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Sell-to Customer No.><Customer No.><Bill-to Customer No.><Customer Filter><Customer No.><Bill-to Customer No.><Customer No.><Bill-to Customer No.><Customer No.><Bill-to Customer No.><Customer Filter><Customer No.><Bill-to Customer No.><Customer Filter><Customer No.><Bill-to Customer No.><Customer Filter><Sell-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Default Payment Method Code><Pay-to Vendor No.><Payment Method Code><Buy-from Vendor No.><Pay-to Vendor No.><Buy-from Vendor No.><Pay-to Vendor No.><Buy-from Vendor No.><Pay-to Vendor No.><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Payment Method Code><Payment Method Code><Payment Method Code><Payment Method Code><Payment Method Code><Payment Method Code><Payment Method Code><Payment Method Code><Payment Method Code><Payment Method Code><Payment Method Code><Payment Method Code><Sell-to Customer Template Code><Bill-to Customer Template Code><Last Return Receipt No.><Last Return Shipment No.><Sell-to Customer Template Code><Last Return Receipt No.><Last Return Shipment No.><Last Shipping No.><Last Posting No.><Contract No.><Contract Filter><Posted Service Order Filter><Contract No.><Contract Filter><Contract No. Relation><Contract No.><Contract Filter><Contract No.><Contract Filter>

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

Fields

# Name Type
1 Code (Code) Code10 NotBlank: Yes
2 Due Date Calculation (Due Date Calculation) DateFormula
3 Discount Date Calculation (Discount Date Calculation) DateFormula
4 Discount % (Discount %) Decimal (0:5)
5 Description (Description) Text50
6 Calc. Pmt. Disc. on Cr. Memos (Calc. Pmt. Disc. on Cr. Memos) Boolean

Keys

# Fields
0 Code (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 (Payment Terms Code) 1..n
Customer Cash Flow Payment Terms Code (Cash Flow Payment Terms Code) 1..n
Customer Template Payment Terms Code (Payment Terms Code) 1..n
Filed Service Contract Header Payment Terms Code (Payment Terms Code) 1..n
Gen. Journal Line Payment Terms Code (Payment Terms Code) 1..n
Mini Customer Template Payment Terms Code (Payment Terms Code) 1..n
Mini Vendor Template Payment Terms Code (Payment Terms Code) 1..n
O365 Sales Initial Setup Default Payment Terms Code (Default Payment Terms Code) 1..n
Payment Method Direct Debit Pmt. Terms Code (Direct Debit Pmt. Terms Code) 1..n
Payment Term Translation Payment Term (Payment Term) 1..n
Purch. Cr. Memo Hdr. Payment Terms Code (Payment Terms Code) 1..n
Purch. Inv. Header Payment Terms Code (Payment Terms Code) 1..n
Purch. Rcpt. Header Payment Terms Code (Payment Terms Code) 1..n
Purchase Header Prepmt. Payment Terms Code (Prepmt. Payment Terms Code) 1..n
Purchase Header Archive Prepmt. Payment Terms Code (Prepmt. Payment Terms Code) 1..n
Return Receipt Header Payment Terms Code (Payment Terms Code) 1..n
Return Shipment Header Payment Terms Code (Payment Terms Code) 1..n
Sales Cr.Memo Header Payment Terms Code (Payment Terms Code) 1..n
Sales Header Prepmt. Payment Terms Code (Prepmt. Payment Terms Code) 1..n
Sales Header Archive Prepmt. Payment Terms Code (Prepmt. Payment Terms Code) 1..n
Sales Invoice Header Payment Terms Code (Payment Terms Code) 1..n
Sales Shipment Header Payment Terms Code (Payment Terms Code) 1..n
Service Contract Header Payment Terms Code (Payment Terms Code) 1..n
Service Cr.Memo Header Payment Terms Code (Payment Terms Code) 1..n
Service Header Payment Terms Code (Payment Terms Code) 1..n
Service Invoice Header Payment Terms Code (Payment Terms Code) 1..n
Service Shipment Header Payment Terms Code (Payment Terms Code) 1..n
Standard Customer Sales Code Payment Terms Code (Payment Terms Code) 1..n
Standard General Journal Line Payment Terms Code (Payment Terms Code) 1..n
Vendor Cash Flow Payment Terms Code (Cash Flow Payment Terms Code) 1..n