Diagrams


Table

Customer

DynamicsDocs.comCustomer«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 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«Table 1293»Payment Application ProposalBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Statement Type; [Bank Reconciliation,P...Account Type; [G/L Account,Customer,Ve...Account No. [PK]Applies-to Entry No. [PK]Applied AmountAppliedApplied Pmt. DiscountQualityPosting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeDue DateExternal Document No.Match Confidence; [None,Low,Medium,Hig...Pmt. Disc. Due DateRemaining Pmt. Disc. PossiblePmt. Disc. Tolerance DateApplied Amt. Incl. DiscountRemaining AmountRemaining Amt. Incl. DiscountSorting OrderStmt To Rem. Amount Difference«Table 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Order,Complete...Person ResponsibleGlobal Dimension 1 CodeGlobal Dimension 2 CodeJob Posting GroupBlocked; [,Posting,All]Last Date ModifiedCommentCustomer Disc. GroupCustomer Price GroupLanguage CodeScheduled Res. Qty.Resource FilterPosting Date FilterResource Gr. FilterScheduled Res. Gr. Qty.PictureBill-to NameBill-to AddressBill-to Address 2Bill-to CityBill-to CountyBill-to Post 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 222»Ship-to AddressCustomer No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Shipment Method CodeShipping Agent CodePlace of ExportCountry/Region CodeLast Date ModifiedLocation CodeFax No.Telex Answer BackPost CodeCountyE-MailHome PageTax Area CodeTax LiableShipping Agent Service CodeService Zone Code«Table 249»VAT Registration LogEntry No. [PK]VAT Registration No. [NN]Account Type; [Customer,Vendor,Contact...Account No.Country/Region Code [NN]User IDStatus; [Not Verified,Valid,Invalid]Verified NameVerified AddressVerified Date«Table 266»Customer AmountCustomer No. [PK]Amount [LCY] [PK]Amount 2 [LCY] [PK]«Table 287»Customer Bank AccountCustomer No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityPost CodeContactPhone No.Telex No.Bank Branch No.Bank Account No.Transit No.Currency CodeCountry/Region CodeCountyFax No.Telex Answer BackLanguage CodeE-MailHome PageIBANSWIFT CodeBank Clearing CodeBank Clearing Standard«Table 413»IC PartnerCode [PK,NN]NameCurrency CodeInbox Type; [File Location,Database,E-...Inbox DetailsReceivables AccountPayables AccountBlockedCommentCustomer No.Vendor No.Outbound Sales Item No. Type; [Interna...Outbound Purch. Item No. Type; [Intern...Cost Distribution in LCY«Table 459»Sales Prepayment %Item No. [PK,NN]Sales Type; [Customer,Customer Price G...Sales Code [PK]Starting Date [PK]Ending DatePrepayment %«Table 5054»Contact Business RelationContact No. [PK,NN]Business Relation Code [PK,NN]Link to Table; [,Customer,Vendor,Bank...No.Business Relation DescriptionContact Name«Table 5717»Item Cross ReferenceItem No. [PK]Variant Code [PK]Unit of Measure [PK]Cross-Reference Type; [,Customer,Vendo...Cross-Reference Type No. [PK]Cross-Reference No. [PK,NN]DescriptionDiscontinue Bar Code«Table 5765»Warehouse RequestSource Type [PK]Source Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No. [PK]Source Document; [,Sales Order,,,Sales...Document Status; [Open,Released]Location Code [PK]Shipment Method CodeShipping Agent CodeShipping Advice; [Partial,Complete]Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Expected Receipt DateShipment DateType; [Inbound,Outbound] [PK]Put-away / Pick No.Completely Handled«Table 5940»Service ItemNo. [PK]Serial No.Service Item Group CodeDescriptionDescription 2Status; [,Own Service Item,Installed,T...Priority; [Low,Medium,High]Customer No.Ship-to CodeItem No.Unit of Measure CodeLocation of Service ItemSales Unit PriceSales Unit CostWarranty Starting Date [Labor]Warranty Ending Date [Labor]Warranty Starting Date [Parts]Warranty Ending Date [Parts]Warranty % [Parts]Warranty % [Labor]Response Time [Hours]Installation DateSales DateLast Service DateDefault Contract ValueDefault Contract Discount %No. of Active ContractsVendor No.Vendor Item No.No. SeriesItem Description...«Table 7002»Sales PriceItem No. [PK,NN]Sales Code [PK]Currency Code [PK]Starting Date [PK]Unit PricePrice Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]Sales Type; [Customer,Customer Price G...Minimum Quantity [PK]Ending DateUnit of Measure Code [PK]Variant Code [PK]Allow Line Disc.«Table 7023»Sales Price WorksheetItem No. [PK,NN]Sales Code [PK]Currency Code [PK]Starting Date [PK]Current Unit PriceNew Unit PricePrice Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]Sales Type; [Customer,Customer Price G...Minimum Quantity [PK]Ending Date [PK]Item DescriptionSales DescriptionUnit of Measure Code [PK]Variant Code [PK]Allow Line Disc.«Table 7030»Campaign Target GroupType; [Customer,Contact] [PK]No. [PK]Campaign No. [PK]«Table 827»DO Payment Credit CardNo. [PK]Type [NN]Credit Card NumberExpiry Date [NN]Card Holder Name [NN]Customer No. [NN]Contact No. [NN]Cvc No.No. Series«Table 871»Social Listening Search TopicSource Type; [,Item,Vendor,Customer] [...Source No. [PK]Search Topic«Table 9150»My CustomerUser ID [PK]Customer No. [PK,NN]«Table 9657»Custom Report SelectionSource Type [PK]Source No. [PK]Usage; [S.Quote,S.Order,S.Invoice,S.Cr...Sequence [PK]Report IDReport CaptionCustom Report Layout IDCustom Report DescriptionSend To Email«Table 99000853»Inventory ProfileLine No. [PK]Attribute PriorityOrder PriorityItem No.Variant CodeLocation CodeBin CodeIsSupplyOrder Relation; [Normal,Safety Stock,R...Source TypeSource Order StatusSource IDSource Batch NameSource Ref. No.Source Prod. Order LinePrimary Order StatusPrimary Order No.Primary Order LinePrimary Order TypeOriginal QuantityRemaining Quantity [Base]Untracked QuantityOriginal Due DateDue DatePlanning Flexibility; [Unlimited,None,...Fixed DateAction Message; [,New,Change Qty.,Resc...Binding; [,Order-to-Order]Quantity [Base]Min. QuantityStarting Date...«Table 60»Document Sending ProfileCode [PK,NN]DescriptionPrinter; [No,Yes <Prompt for Settings>...E-Mail; [No,Yes <Prompt for Settings>,...E-Mail Attachment; [PDF,Electronic Doc...E-Mail FormatDisk; [No,PDF,Electronic Document,PDF...Disk FormatElectronic Document; [No,Through Docum...Electronic FormatDefaultSend To; [Disk,E-Mail,Print,Electronic...Usage; [Sales Invoice,Sales Credit Mem...One Related Party Selected«Table 92»Customer Posting GroupCode [PK,NN]Receivables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountAdditional Fee AccountInterest AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.Add. Fee per Line Account«Table 6»Customer Price GroupCode [PK,NN]Price Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]DescriptionAllow Line Disc.«Table 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. Memos«Table 5»Finance Charge TermsCode [PK,NN]Interest RateMinimum Amount [LCY]Additional Fee [LCY]DescriptionInterest Calculation Method; [Average...Interest Period [Days]Grace PeriodDue Date CalculationInterest Calculation; [Open Entries,Cl...Post InterestPost Additional FeeLine DescriptionAdd. Line Fee in Interest«Table 10»Shipment MethodCode [PK,NN]Description«Table 291»Shipping AgentCode [PK,NN]NameInternet AddressAccount No.«Table 340»Customer Discount GroupCode [PK,NN]Description«Table 289»Payment MethodCode [PK,NN]DescriptionBal. Account Type; [G/L Account,Bank A...Bal. Account No.Payment Processor; [,Dynamics Online]Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. Type«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 292»Reminder TermsCode [PK,NN]DescriptionPost InterestPost Additional FeeMax. No. of RemindersMinimum Amount [LCY]Post Add. Fee per LineNote About Line Fee on Report«Table 318»Tax AreaCode [PK,NN]Description«Table 323»VAT Business Posting GroupCode [PK,NN]Description«Table 5050»ContactNo. [PK]NameSearch NameName 2AddressAddress 2CityPhone No.Telex No.Territory CodeCurrency CodeLanguage CodeSalesperson CodeCountry/Region CodeCommentLast Date ModifiedFax No.Telex Answer BackVAT Registration No.PicturePost CodeCountyE-MailHome PageNo. SeriesType; [Company,Person]Company No.Company NameLookup Contact No.First NameMiddle Name...«Table 5714»Responsibility CenterCode [PK,NN]NameAddressAddress 2CityPost CodeCountry/Region CodePhone No.Fax No.Name 2ContactGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeCountyE-MailHome PageDate FilterContract Gain/Loss Amount«Table 5790»Shipping Agent ServicesShipping Agent Code [PK,NN]Code [PK,NN]DescriptionShipping TimeBase Calendar Code«Table 5957»Service ZoneCode [PK,NN]Description«Table 7600»Base CalendarCode [PK,NN]NameCustomized Changes Exist<Document Sending Profile><Customer Posting Group><Customer Price Group><Payment Terms Code><Cash Flow Payment Terms Code><Fin. Charge Terms Code><Shipment Method Code><Shipping Agent Code><Customer Disc. Group><Bill-to Customer No.><Payment Method Code><Location Code><Gen. Bus. Posting Group><Reminder Terms Code><Tax Area Code><VAT Bus. Posting Group><IC Partner Code><Customer No.><Preferred Bank Account><Customer No.><Primary Contact No.><Responsibility Center><Shipping Agent Service Code><Service Zone Code><Ship-to Filter><Customer No.><Base Calendar Code><Customer No.><Account No.><Bill-to Customer No.><Customer No.><Account No.><Customer No.><Sales Code><No.><Cross-Reference Type No.><Destination No.><Customer No.><Sales Code><Sales Code><No.><Customer No.><Source No.><Customer No.><Source No.><Sell-to Customer No.><Customer Bank Account Code><Direct Debit Mandate ID><Account No.><Customer Disc. Group><Customer Price Group><Payment Method Code><Payment Terms Code><Shipment Method Code><Shipping Agent Code><Location Code><Tax Area Code><Shipping Agent Service Code><Service Zone Code><Ship-to Code><Sales Code><Contact No.><Location Code><Destination No.><Shipment Method Code><Shipping Agent Code><Sales Code><VAT Bus. Posting Gr. (Price)><Sales Code><VAT Bus. Posting Gr. (Price)><No.><Location Code><VAT Bus. Posting Gr. (Price)><Direct Debit Pmt. Terms Code><Shipping Agent Code><Base Calendar Code><Location Code><Def. VAT Bus. Posting Group><Company No.><Lookup Contact No.><Base Calendar Code>

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

Fields

# Name Type
1 No. (No.) Code20
2 Name (Name) Text50
3 Search Name (Search Name) Code50
4 Name 2 (Name 2) Text50
5 Address (Address) Text50
6 Address 2 (Address 2) Text50
7 City (City) Text30
8 Contact (Contact) Text50
9 Phone No. (Phone No.) Text30 [Phone No.]
10 Telex No. (Telex No.) Text20
11 Document Sending Profile (Document Sending Profile) Code20
14 Our Account No. (Our Account No.) Text20
15 Territory Code (Territory Code) Code10
16 Global Dimension 1 Code (Global Dimension 1 Code) Code20
17 Global Dimension 2 Code (Global Dimension 2 Code) Code20
18 Chain Name (Chain Name) Code10
19 Budgeted Amount (Budgeted Amount) Decimal
20 Credit Limit (LCY) (Credit Limit (LCY)) Decimal
21 Customer Posting Group (Customer Posting Group) Code10
22 Currency Code (Currency Code) Code10
23 Customer Price Group (Customer Price Group) Code10
24 Language Code (Language Code) Code10
26 Statistics Group (Statistics Group) Integer
27 Payment Terms Code (Payment Terms Code) Code10
28 Fin. Charge Terms Code (Fin. Charge Terms Code) Code10
29 Salesperson Code (Salesperson Code) Code10
30 Shipment Method Code (Shipment Method Code) Code10
31 Shipping Agent Code (Shipping Agent Code) Code10
32 Place of Export (Place of Export) Code20
33 Invoice Disc. Code (Invoice Disc. Code) Code20
34 Customer Disc. Group (Customer Disc. Group) Code20
35 Country/Region Code (Country/Region Code) Code10
36 Collection Method (Collection Method) Code20
37 Amount (Amount) Decimal
38 Comment (Comment) Boolean Editable: No
FlowField
39 Blocked (Blocked) Option
40 Invoice Copies (Invoice Copies) Integer
41 Last Statement No. (Last Statement No.) Integer
42 Print Statements (Print Statements) Boolean
45 Bill-to Customer No. (Bill-to Customer No.) Code20
46 Priority (Priority) Integer
47 Payment Method Code (Payment Method Code) Code10
54 Last Date Modified (Last Date Modified) Date Editable: No
55 Date Filter (Date Filter) Date FlowFilter
56 Global Dimension 1 Filter (Global Dimension 1 Filter) Code20 FlowFilter
57 Global Dimension 2 Filter (Global Dimension 2 Filter) Code20 FlowFilter
58 Balance (Balance) Decimal Editable: No
FlowField
59 Balance (LCY) (Balance (LCY)) Decimal Editable: No
FlowField
60 Net Change (Net Change) Decimal Editable: No
FlowField
61 Net Change (LCY) (Net Change (LCY)) Decimal Editable: No
FlowField
62 Sales (LCY) (Sales (LCY)) Decimal Editable: No
FlowField
63 Profit (LCY) (Profit (LCY)) Decimal Editable: No
FlowField
64 Inv. Discounts (LCY) (Inv. Discounts (LCY)) Decimal Editable: No
FlowField
65 Pmt. Discounts (LCY) (Pmt. Discounts (LCY)) Decimal Editable: No
FlowField
66 Balance Due (Balance Due) Decimal Editable: No
FlowField
67 Balance Due (LCY) (Balance Due (LCY)) Decimal Editable: No
FlowField
69 Payments (Payments) Decimal Editable: No
FlowField
70 Invoice Amounts (Invoice Amounts) Decimal Editable: No
FlowField
71 Cr. Memo Amounts (Cr. Memo Amounts) Decimal Editable: No
FlowField
72 Finance Charge Memo Amounts (Finance Charge Memo Amounts) Decimal Editable: No
FlowField
74 Payments (LCY) (Payments (LCY)) Decimal Editable: No
FlowField
75 Inv. Amounts (LCY) (Inv. Amounts (LCY)) Decimal Editable: No
FlowField
76 Cr. Memo Amounts (LCY) (Cr. Memo Amounts (LCY)) Decimal Editable: No
FlowField
77 Fin. Charge Memo Amounts (LCY) (Fin. Charge Memo Amounts (LCY)) Decimal Editable: No
FlowField
78 Outstanding Orders (Outstanding Orders) Decimal Editable: No
FlowField
79 Shipped Not Invoiced (Shipped Not Invoiced) Decimal Editable: No
FlowField
80 Application Method (Application Method) Option
82 Prices Including VAT (Prices Including VAT) Boolean
83 Location Code (Location Code) Code10
84 Fax No. (Fax No.) Text30
85 Telex Answer Back (Telex Answer Back) Text20
86 VAT Registration No. (VAT Registration No.) Text20
87 Combine Shipments (Combine Shipments) Boolean
88 Gen. Bus. Posting Group (Gen. Bus. Posting Group) Code10
89 Picture (Picture) BLOB [Bitmap]
90 GLN (GLN) Code13 [Numeric:Yes]
91 Post Code (Post Code) Code20
92 County (County) Text30
97 Debit Amount (Debit Amount) Decimal BlankZero: Yes
Editable: No
FlowField
98 Credit Amount (Credit Amount) Decimal BlankZero: Yes
Editable: No
FlowField
99 Debit Amount (LCY) (Debit Amount (LCY)) Decimal BlankZero: Yes
Editable: No
FlowField
100 Credit Amount (LCY) (Credit Amount (LCY)) Decimal BlankZero: Yes
Editable: No
FlowField
102 E-Mail (E-Mail) Text80 [E-Mail]
103 Home Page (Home Page) Text80 [URL]
104 Reminder Terms Code (Reminder Terms Code) Code10
105 Reminder Amounts (Reminder Amounts) Decimal Editable: No
FlowField
106 Reminder Amounts (LCY) (Reminder Amounts (LCY)) Decimal Editable: No
FlowField
107 No. Series (No. Series) Code10 Editable: No
108 Tax Area Code (Tax Area Code) Code20
109 Tax Liable (Tax Liable) Boolean
110 VAT Bus. Posting Group (VAT Bus. Posting Group) Code10
111 Currency Filter (Currency Filter) Code10 FlowFilter
113 Outstanding Orders (LCY) (Outstanding Orders (LCY)) Decimal Editable: No
FlowField
114 Shipped Not Invoiced (LCY) (Shipped Not Invoiced (LCY)) Decimal Editable: No
FlowField
115 Reserve (Reserve) Option
116 Block Payment Tolerance (Block Payment Tolerance) Boolean
117 Pmt. Disc. Tolerance (LCY) (Pmt. Disc. Tolerance (LCY)) Decimal Editable: No
FlowField
118 Pmt. Tolerance (LCY) (Pmt. Tolerance (LCY)) Decimal Editable: No
FlowField
119 IC Partner Code (IC Partner Code) Code20
120 Refunds (Refunds) Decimal FlowField
121 Refunds (LCY) (Refunds (LCY)) Decimal FlowField
122 Other Amounts (Other Amounts) Decimal FlowField
123 Other Amounts (LCY) (Other Amounts (LCY)) Decimal FlowField
124 Prepayment % (Prepayment %) Decimal (0:5)
125 Outstanding Invoices (LCY) (Outstanding Invoices (LCY)) Decimal Editable: No
FlowField
126 Outstanding Invoices (Outstanding Invoices) Decimal Editable: No
FlowField
130 Bill-to No. Of Archived Doc. (Bill-to No. Of Archived Doc.) Integer FlowField
131 Sell-to No. Of Archived Doc. (Sell-to No. Of Archived Doc.) Integer FlowField
132 Partner Type (Partner Type) Option
288 Preferred Bank Account (Preferred Bank Account) Code10
840 Cash Flow Payment Terms Code (Cash Flow Payment Terms Code) Code10
5049 Primary Contact No. (Primary Contact No.) Code20
5700 Responsibility Center (Responsibility Center) Code10
5750 Shipping Advice (Shipping Advice) Option
5790 Shipping Time (Shipping Time) DateFormula
5792 Shipping Agent Service Code (Shipping Agent Service Code) Code10
5900 Service Zone Code (Service Zone Code) Code10
5902 Contract Gain/Loss Amount (Contract Gain/Loss Amount) Decimal Editable: No
FlowField
5903 Ship-to Filter (Ship-to Filter) Code10 FlowFilter
5910 Outstanding Serv. Orders (LCY) (Outstanding Serv. Orders (LCY)) Decimal Editable: No
FlowField
5911 Serv Shipped Not Invoiced(LCY) (Serv Shipped Not Invoiced(LCY)) Decimal Editable: No
FlowField
5912 Outstanding Serv.Invoices(LCY) (Outstanding Serv.Invoices(LCY)) Decimal Editable: No
FlowField
7001 Allow Line Disc. (Allow Line Disc.) Boolean
7171 No. of Quotes (No. of Quotes) Integer Editable: No
FlowField
7172 No. of Blanket Orders (No. of Blanket Orders) Integer Editable: No
FlowField
7173 No. of Orders (No. of Orders) Integer Editable: No
FlowField
7174 No. of Invoices (No. of Invoices) Integer Editable: No
FlowField
7175 No. of Return Orders (No. of Return Orders) Integer Editable: No
FlowField
7176 No. of Credit Memos (No. of Credit Memos) Integer Editable: No
FlowField
7177 No. of Pstd. Shipments (No. of Pstd. Shipments) Integer Editable: No
FlowField
7178 No. of Pstd. Invoices (No. of Pstd. Invoices) Integer Editable: No
FlowField
7179 No. of Pstd. Return Receipts (No. of Pstd. Return Receipts) Integer Editable: No
FlowField
7180 No. of Pstd. Credit Memos (No. of Pstd. Credit Memos) Integer Editable: No
FlowField
7181 No. of Ship-to Addresses (No. of Ship-to Addresses) Integer Editable: No
FlowField
7182 Bill-To No. of Quotes (Bill-To No. of Quotes) Integer Editable: No
FlowField
7183 Bill-To No. of Blanket Orders (Bill-To No. of Blanket Orders) Integer Editable: No
FlowField
7184 Bill-To No. of Orders (Bill-To No. of Orders) Integer Editable: No
FlowField
7185 Bill-To No. of Invoices (Bill-To No. of Invoices) Integer Editable: No
FlowField
7186 Bill-To No. of Return Orders (Bill-To No. of Return Orders) Integer Editable: No
FlowField
7187 Bill-To No. of Credit Memos (Bill-To No. of Credit Memos) Integer Editable: No
FlowField
7188 Bill-To No. of Pstd. Shipments (Bill-To No. of Pstd. Shipments) Integer Editable: No
FlowField
7189 Bill-To No. of Pstd. Invoices (Bill-To No. of Pstd. Invoices) Integer Editable: No
FlowField
7190 Bill-To No. of Pstd. Return R. (Bill-To No. of Pstd. Return R.) Integer Editable: No
FlowField
7191 Bill-To No. of Pstd. Cr. Memos (Bill-To No. of Pstd. Cr. Memos) Integer Editable: No
FlowField
7600 Base Calendar Code (Base Calendar Code) Code10
7601 Copy Sell-to Addr. to Qte From (Copy Sell-to Addr. to Qte From) Option

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Search Name (Search Name)
2 Customer Posting Group (Customer Posting Group)
3 Currency Code (Currency Code)
4 Country/Region Code (Country/Region Code)
5 Gen. Bus. Posting Group (Gen. Bus. Posting Group)
6 Name,Address,City (Name,Address,City)
7 VAT Registration No. (VAT Registration No.)
8 Name (Name)
9 City (City)
10 Post Code (Post Code)
11 Phone No. (Phone No.)
12 Contact (Contact)

Table Relations To Other Tables

Field Related Table Related Field
Base Calendar Code (Base Calendar Code) Base Calendar Code (Code) 1..n
Primary Contact No. (Primary Contact No.) Contact No. (No.) 1..n
Country/Region Code (Country/Region Code) Country/Region Code (Code) 1..n
Currency Filter (Currency Filter) Currency Code (Code) 1..n
Bill-to Customer No. (Bill-to Customer No.) Customer No. (No.) 1..n
Preferred Bank Account (Preferred Bank Account) Customer Bank Account Code (Code) 1..n
Customer Disc. Group (Customer Disc. Group) Customer Discount Group Code (Code) 1..n
Customer Posting Group (Customer Posting Group) Customer Posting Group Code (Code) 1..n
Customer Price Group (Customer Price Group) Customer Price Group Code (Code) 1..n
Global Dimension 2 Filter (Global Dimension 2 Filter) Dimension Value Code (Code) 1..n
Document Sending Profile (Document Sending Profile) Document Sending Profile Code (Code) 1..n
Fin. Charge Terms Code (Fin. Charge Terms Code) Finance Charge Terms Code (Code) 1..n
Gen. Bus. Posting Group (Gen. Bus. Posting Group) Gen. Business Posting Group Code (Code) 1..n
IC Partner Code (IC Partner Code) IC Partner Code (Code) 1..n
Language Code (Language Code) Language Code (Code) 1..n
Location Code (Location Code) Location () 1..n
No. Series (No. Series) No. Series Code (Code) 1..n
Payment Method Code (Payment Method Code) Payment Method Code (Code) 1..n
Cash Flow Payment Terms Code (Cash Flow Payment Terms Code) Payment Terms Code (Code) 1..n
Reminder Terms Code (Reminder Terms Code) Reminder Terms Code (Code) 1..n
Responsibility Center (Responsibility Center) Responsibility Center Code (Code) 1..n
Salesperson Code (Salesperson Code) Salesperson/Purchaser Code (Code) 1..n
Service Zone Code (Service Zone Code) Service Zone Code (Code) 1..n
Ship-to Filter (Ship-to Filter) Ship-to Address Code (Code) 1..n
Shipment Method Code (Shipment Method Code) Shipment Method Code (Code) 1..n
Shipping Agent Code (Shipping Agent Code) Shipping Agent Code (Code) 1..n
Shipping Agent Service Code (Shipping Agent Service Code) Shipping Agent Services Code (Code) 1..n
Tax Area Code (Tax Area Code) Tax Area Code (Code) 1..n
Territory Code (Territory Code) Territory Code (Code) 1..n
VAT Bus. Posting Group (VAT Bus. Posting Group) VAT Business Posting Group Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Analysis Line Source No. Filter (Source No. Filter) 1..n
Applied Payment Entry Account No. (Account No.) 1..n
Bank Acc. Reconciliation Line Account No. (Account No.) 1..n
Bank Account Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
CV Ledger Entry Buffer Bal. Account No. (Bal. Account No.) 1..n
Campaign Target Group No. (No.) 1..n
Cash Flow Forecast Entry Source No. (Source No.) 1..n
Check Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
Comment Line No. (No.) 1..n
Contact Business Relation No. (No.) 1..n
Contract Gain/Loss Entry Customer No. (Customer No.) 1..n
Credit Transfer Entry Account No. (Account No.) 1..n
Currency Customer Filter (Customer Filter) 1..n
Cust. Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
Custom Report Selection Source No. (Source No.) 1..n
Customer Bill-to Customer No. (Bill-to Customer No.) 1..n
Customer Amount Customer No. (Customer No.) 1..n
Customer Bank Account Customer No. (Customer No.) 1..n
DO Payment Credit Card Customer No. (Customer No.) 1..n
DO Payment Trans. Log Entry Customer No. (Customer No.) 1..n
Default Dimension No. (No.) 1..n
Detailed Cust. Ledg. Entry Customer No. (Customer No.) 1..n
Direct Debit Collection Entry Customer No. (Customer No.) 1..n
FA Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
Filed Contract Line Customer No. (Customer No.) 1..n
Filed Service Contract Header Bill-to Customer No. (Bill-to Customer No.) 1..n
Finance Charge Memo Header Customer No. (Customer No.) 1..n
G/L Entry Source No. (Source No.) 1..n
Gen. Journal Batch Bal. Account No. (Bal. Account No.) 1..n
Gen. Journal Line Sell-to/Buy-from No. (Sell-to/Buy-from No.) 1..n
Gen. Journal Template Bal. Account No. (Bal. Account No.) 1..n
Handled IC Inbox Jnl. Line Account No. (Account No.) 1..n
Handled IC Inbox Sales Header Bill-to Customer No. (Bill-to Customer No.) 1..n
Handled IC Outbox Jnl. Line Account No. (Account No.) 1..n
Handled IC Outbox Sales Header Bill-to Customer No. (Bill-to Customer No.) 1..n
IC Inbox Jnl. Line Account No. (Account No.) 1..n
IC Inbox Sales Header Bill-to Customer No. (Bill-to Customer No.) 1..n
IC Outbox Jnl. Line Account No. (Account No.) 1..n
IC Outbox Sales Header Bill-to Customer No. (Bill-to Customer No.) 1..n
IC Partner Customer No. (Customer No.) 1..n
Inventory Profile Sell-to Customer No. (Sell-to Customer No.) 1..n
Issued Fin. Charge Memo Header Customer No. (Customer No.) 1..n
Issued Reminder Header Customer No. (Customer No.) 1..n
Item Analysis View Budg. Entry Source No. (Source No.) 1..n
Item Analysis View Entry Source No. (Source No.) 1..n
Item Budget Buffer Source No. (Source No.) 1..n
Item Budget Entry Source No. (Source No.) 1..n
Item Cross Reference Cross-Reference Type No. (Cross-Reference Type No.) 1..n
Item Journal Line Invoice-to Source No. (Invoice-to Source No.) 1..n
Item Ledger Entry Source No. (Source No.) 1..n
Item Tracing Buffer Source No. (Source No.) 1..n
Job Bill-to Customer No. (Bill-to Customer No.) 1..n
Loaner Entry Customer No. (Customer No.) 1..n
Maintenance Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
My Customer Customer No. (Customer No.) 1..n
Payment Application Proposal Account No. (Account No.) 1..n
Posted Invt. Pick Header Destination No. (Destination No.) 1..n
Posted Invt. Pick Line Destination No. (Destination No.) 1..n
Posted Invt. Put-away Header Destination No. (Destination No.) 1..n
Posted Invt. Put-away Line Destination No. (Destination No.) 1..n
Posted Payment Recon. Line Account No. (Account No.) 1..n
Posted Whse. Shipment Line Destination No. (Destination No.) 1..n
Purch. Cr. Memo Hdr. Sell-to Customer No. (Sell-to Customer No.) 1..n
Purch. Inv. Header Sell-to Customer No. (Sell-to Customer No.) 1..n
Purch. Rcpt. Header Sell-to Customer No. (Sell-to Customer No.) 1..n
Purchase Header Sell-to Customer No. (Sell-to Customer No.) 1..n
Purchase Header Archive Sell-to Customer No. (Sell-to Customer No.) 1..n
Registered Invt. Movement Hdr. Destination No. (Destination No.) 1..n
Registered Invt. Movement Line Destination No. (Destination No.) 1..n
Registered Whse. Activity Line Destination No. (Destination No.) 1..n
Reminder Header Customer No. (Customer No.) 1..n
Reminder/Fin. Charge Entry Customer No. (Customer No.) 1..n
Requisition Line Sell-to Customer No. (Sell-to Customer No.) 1..n
Res. Journal Line Source No. (Source No.) 1..n
Res. Ledger Entry Source No. (Source No.) 1..n
Return Receipt Header Bill-to Customer No. (Bill-to Customer No.) 1..n
Return Receipt Line Bill-to Customer No. (Bill-to Customer No.) 1..n
Return Shipment Header Sell-to Customer No. (Sell-to Customer No.) 1..n
Reversal Entry Bal. Account No. (Bal. Account No.) 1..n
SEPA Direct Debit Mandate Customer No. (Customer No.) 1..n
Sales Cr.Memo Header Bill-to Customer No. (Bill-to Customer No.) 1..n
Sales Cr.Memo Line Bill-to Customer No. (Bill-to Customer No.) 1..n
Sales Header Bill-to Customer No. (Bill-to Customer No.) 1..n
Sales Header Archive Bill-to Customer No. (Bill-to Customer No.) 1..n
Sales Invoice Header Bill-to Customer No. (Bill-to Customer No.) 1..n
Sales Invoice Line Bill-to Customer No. (Bill-to Customer No.) 1..n
Sales Line Bill-to Customer No. (Bill-to Customer No.) 1..n
Sales Line Archive Bill-to Customer No. (Bill-to Customer No.) 1..n
Sales Line Discount Sales Code (Sales Code) 1..n
Sales Prepayment % Sales Code (Sales Code) 1..n
Sales Price Sales Code (Sales Code) 1..n
Sales Price Worksheet Sales Code (Sales Code) 1..n
Sales Price and Line Disc Buff Sales Code (Sales Code) 1..n
Sales Shipment Header Bill-to Customer No. (Bill-to Customer No.) 1..n
Sales Shipment Line Bill-to Customer No. (Bill-to Customer No.) 1..n
Service Contract Header Bill-to Customer No. (Bill-to Customer No.) 1..n
Service Contract Line Customer No. (Customer No.) 1..n
Service Cr.Memo Header Customer Filter (Customer Filter) 1..n
Service Cr.Memo Line Bill-to Customer No. (Bill-to Customer No.) 1..n
Service Header Customer Filter (Customer Filter) 1..n
Service Invoice Header Customer Filter (Customer Filter) 1..n
Service Invoice Line Bill-to Customer No. (Bill-to Customer No.) 1..n
Service Item Customer No. (Customer No.) 1..n
Service Item Line Customer No. (Customer No.) 1..n
Service Ledger Entry Bill-to Customer No. (Bill-to Customer No.) 1..n
Service Line Bill-to Customer No. (Bill-to Customer No.) 1..n
Service Shipment Header Customer Filter (Customer Filter) 1..n
Service Shipment Item Line Customer No. (Customer No.) 1..n
Service Shipment Line Bill-to Customer No. (Bill-to Customer No.) 1..n
Ship-to Address Customer No. (Customer No.) 1..n
Social Listening Search Topic Source No. (Source No.) 1..n
Standard Customer Sales Code Customer No. (Customer No.) 1..n
Standard General Journal Line Sell-to/Buy-from No. (Sell-to/Buy-from No.) 1..n
Text-to-Account Mapping Bal. Source No. (Bal. Source No.) 1..n
VAT Entry Bill-to/Pay-to No. (Bill-to/Pay-to No.) 1..n
VAT Registration Log Account No. (Account No.) 1..n
VAT Report Line Bill-to/Pay-to No. (Bill-to/Pay-to No.) 1..n
Value Entry Source No. (Source No.) 1..n
Vendor Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
Warehouse Activity Header Destination No. (Destination No.) 1..n
Warehouse Activity Line Destination No. (Destination No.) 1..n
Warehouse Request Destination No. (Destination No.) 1..n
Warehouse Shipment Line Destination No. (Destination No.) 1..n
Warranty Ledger Entry Bill-to Customer No. (Bill-to Customer No.) 1..n
Whse. Worksheet Line Destination No. (Destination No.) 1..n