Diagrams

Table

Payment Method

DynamicsDocs.comPayment Method«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 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 2103»O365 Sales DocumentDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Due DateCurrency CodeSell-to Customer NameSell-to ContactDocument DateLast Email Sent TimeLast Email Sent Status; [,In Process,F...Sent as EmailLast Email Notif ClearedPosted [PK]CanceledCurrency SymbolDocument Status; [Quote,Draft Invoice,...Sales AmountOutstanding AmountTotal Invoiced AmountOutstanding StatusDocument IconPayment MethodDisplay No.Quote Valid Until DateQuote AcceptedQuote Sent to CustomerQuote Accepted Date«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 466»Payment Method TranslationPayment Method Code [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 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc....«Table 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...«Table 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. MemosLast Modified Date TimeId«Table 1281»Bank Data Conversion Pmt. TypeCode [PK]Description<Bal. Account No.><Bal. Account No.><Direct Debit Pmt. Terms Code><Bank Data Conversion Pmt. Type><Payment Method Code><Payment Method Code><Payment Method Code><Payment Method Code><Payment Method Id><Payment Method><Default Payment Method Code><Payment Method Code><Payment Method Id><Payment Method Code><Payment Method Code><Payment Terms Code><Payment Terms Code><Invoice Disc. Code><Customer No.><Payment Terms Code><Payment Terms Code><Cash Flow Payment Terms Code><Payment Terms Id><Bill-to Customer No.><Sell-to Customer No.><Default Payment Terms Code><Payment Terms Code><Cash Flow Payment Terms Code><Payment Terms Id><Pay-to Vendor No.><Payment Terms Code>

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 Description (Description) Text50
3 Bal. Account Type (Bal. Account Type) Option
4 Bal. Account No. (Bal. Account No.) Code20
6 Direct Debit (Direct Debit) Boolean
7 Direct Debit Pmt. Terms Code (Direct Debit Pmt. Terms Code) Code10
8 Pmt. Export Line Definition (Pmt. Export Line Definition) Code20
9 Bank Data Conversion Pmt. Type (Bank Data Conversion Pmt. Type) Text50
10 Use for Invoicing (Use for Invoicing) Boolean
11 Last Modified Date Time (Last Modified Date Time) DateTime Editable: No
8000 Id (Id) GUID

Keys

# Fields
0 Code (Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Bal. Account No. (Bal. Account No.) Bank Account No. (No.) 1..n
Bank Data Conversion Pmt. Type (Bank Data Conversion Pmt. Type) Bank Data Conversion Pmt. Type Code (Code) 1..n
Bal. Account No. (Bal. Account No.) G/L Account No. (No.) 1..n
Direct Debit Pmt. Terms Code (Direct Debit Pmt. Terms Code) Payment Terms Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Cust. Ledger Entry Payment Method Code (Payment Method Code) 1..n
Customer Payment Method Id (Payment Method Id) 1..n
Customer Template Payment Method Code (Payment Method Code) 1..n
Employee Ledger Entry Payment Method Code (Payment Method Code) 1..n
Gen. Journal Line Payment Method Id (Payment Method Id) 1..n
Mini Customer Template Payment Method Code (Payment Method Code) 1..n
Mini Vendor Template Payment Method Code (Payment Method Code) 1..n
O365 Sales Document Payment Method (Payment Method) 1..n
O365 Sales Initial Setup Default Payment Method Code (Default Payment Method Code) 1..n
Payment Method Translation Payment Method Code (Payment Method Code) 1..n
Payment Registration Buffer Payment Method Code (Payment Method Code) 1..n
Purch. Cr. Memo Hdr. Payment Method Code (Payment Method Code) 1..n
Purch. Inv. Header Payment Method Code (Payment Method Code) 1..n
Purch. Rcpt. Header Payment Method Code (Payment Method Code) 1..n
Purchase Header Payment Method Code (Payment Method Code) 1..n
Purchase Header Archive Payment Method Code (Payment Method Code) 1..n
Return Receipt Header Payment Method Code (Payment Method Code) 1..n
Return Shipment Header Payment Method Code (Payment Method Code) 1..n
Sales Cr.Memo Header Payment Method Code (Payment Method Code) 1..n
Sales Header Payment Method Code (Payment Method Code) 1..n
Sales Header Archive Payment Method Code (Payment Method Code) 1..n
Sales Invoice Header Payment Method Code (Payment Method Code) 1..n
Sales Shipment Header Payment Method Code (Payment Method Code) 1..n
Service Cr.Memo Header Payment Method Code (Payment Method Code) 1..n
Service Header Payment Method Code (Payment Method Code) 1..n
Service Invoice Header Payment Method Code (Payment Method Code) 1..n
Service Shipment Header Payment Method Code (Payment Method Code) 1..n
Standard Customer Sales Code Payment Method Code (Payment Method Code) 1..n
Vendor Payment Method Id (Payment Method Id) 1..n
Vendor Ledger Entry Payment Method Code (Payment Method Code) 1..n