Standard Customer Sales Code

DynamicsDocs.comStandard Customer Sales Code«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 170»Standard Sales CodeCode [PK,NN]DescriptionCurrency 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 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. MemosLast Modified Date TimeId«Table 1230»SEPA Direct Debit MandateID [PK]Customer No. [NN]Customer Bank Account Code [NN]Valid FromValid ToDate of Signature [NN]Type of Payment; [OneOff,Recurrent]BlockedExpected Number of DebitsDebit CounterNo. SeriesClosed<Customer No.><Code><Payment Method Code><Payment Terms Code><Direct Debit Mandate ID><Payment Terms Code><Cash Flow Payment Terms Code><Payment Terms Id><Bill-to Customer No.><Payment Method Code><Payment Method Id><Customer No.><Direct Debit Pmt. Terms Code>

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


# Name Type
1 Customer No. (Customer No.) Code20 NotBlank: Yes
2 Code (Code) Code10 NotBlank: Yes
3 Description (Description) Text50
4 Valid From Date (Valid From Date) Date
5 Valid To date (Valid To date) Date
6 Payment Method Code (Payment Method Code) Code10
7 Payment Terms Code (Payment Terms Code) Code10
8 Direct Debit Mandate ID (Direct Debit Mandate ID) Code35
9 Blocked (Blocked) Boolean


# Fields
0 Customer No.,Code (Customer No.,Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Customer No. (Customer No.) Customer No. (No.) 1..n
Payment Method Code (Payment Method Code) Payment Method Code (Code) 1..n
Payment Terms Code (Payment Terms Code) Payment Terms Code (Code) 1..n
Direct Debit Mandate ID (Direct Debit Mandate ID) SEPA Direct Debit Mandate () 1..n
Code (Code) Standard Sales Code Code (Code) 1..n

Table Relations From Other Tables

From Table From Field