XPT / Schema / Customer

Customer #18

Sales table in Microsoft Dynamics 365 Business Central. 181 fields, 5 records in Cronus demo.

181
Fields
5
Records
1
Primary key
68
FlowFields
47
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: No..

All fields (181)

Customer — FIELDS
NO.FIELDTYPECLASSRELATION
1 No. PK Code Normal
2 Name Text Normal
3 Search Name Code Normal
4 Name 2 Text Normal
5 Address Text Normal
6 Address 2 Text Normal
7 City Text Normal
8 Contact Text Normal
9 Phone No. Text Normal
10 Telex No. Text Normal
11 Document Sending Profile Code Normal → Document Sending Profile #60
12 Ship-to Code Code Normal → Ship-to Address #222
14 Our Account No. Text Normal
15 Territory Code Code Normal → Territory #286
16 Global Dimension 1 Code Code Normal → Dimension Value #349
17 Global Dimension 2 Code Code Normal → Dimension Value #349
18 Chain Name Code Normal
19 Budgeted Amount Decimal Normal
20 Credit Limit (LCY) Decimal Normal
21 Customer Posting Group Code Normal → Customer Posting Group #92
22 Currency Code Code Normal → Currency #4
23 Customer Price Group Code Normal → Customer Price Group #6
24 Language Code Code Normal → Language #8
25 Registration No. Text Normal
26 Statistics Group Integer Normal
27 Payment Terms Code Code Normal → Payment Terms #3
28 Fin. Charge Terms Code Code Normal → Finance Charge Terms #5
29 Salesperson Code Code Normal → Salesperson/Purchaser #13
30 Shipment Method Code Code Normal → Shipment Method #10
31 Shipping Agent Code Code Normal → Shipping Agent #291
32 Place of Export Code Normal
33 Invoice Disc. Code Code Normal → Customer #18
34 Customer Disc. Group Code Normal → Customer Discount Group #340
35 Country/Region Code Code Normal → Country/Region #9
36 Collection Method Code Normal
37 Amount Decimal Normal
38 Comment ⚡ FLOW Boolean FlowField
39 Blocked Option Normal
40 Invoice Copies Integer Normal
41 Last Statement No. Integer Normal
42 Print Statements Boolean Normal
45 Bill-to Customer No. Code Normal → Customer #18
46 Priority Integer Normal
47 Payment Method Code Code Normal → Payment Method #289
48 Format Region Text Normal
52 Customer Since ⚡ FLOW Date FlowField
53 Last Modified Date Time DateTime Normal
54 Last Date Modified Date Normal
55 Date Filter Date FlowFilter
56 Global Dimension 1 Filter Code FlowFilter → Dimension Value #349
57 Global Dimension 2 Filter Code FlowFilter → Dimension Value #349
58 Balance ⚡ FLOW Decimal FlowField
59 Balance (LCY) ⚡ FLOW Decimal FlowField
60 Net Change ⚡ FLOW Decimal FlowField
61 Net Change (LCY) ⚡ FLOW Decimal FlowField
62 Sales (LCY) ⚡ FLOW Decimal FlowField
63 Profit (LCY) ⚡ FLOW Decimal FlowField
64 Inv. Discounts (LCY) ⚡ FLOW Decimal FlowField
65 Pmt. Discounts (LCY) ⚡ FLOW Decimal FlowField
66 Balance Due ⚡ FLOW Decimal FlowField
67 Overdue Balance (LCY) ⚡ FLOW Decimal FlowField
69 Payments ⚡ FLOW Decimal FlowField
70 Invoice Amounts ⚡ FLOW Decimal FlowField
71 Cr. Memo Amounts ⚡ FLOW Decimal FlowField
72 Finance Charge Memo Amounts ⚡ FLOW Decimal FlowField
74 Payments (LCY) ⚡ FLOW Decimal FlowField
75 Inv. Amounts (LCY) ⚡ FLOW Decimal FlowField
76 Cr. Memo Amounts (LCY) ⚡ FLOW Decimal FlowField
77 Fin. Charge Memo Amounts (LCY) ⚡ FLOW Decimal FlowField
78 Outstanding Orders ⚡ FLOW Decimal FlowField
79 Shipped Not Invoiced ⚡ FLOW Decimal FlowField
80 Application Method Option Normal
82 Prices Including VAT Boolean Normal
83 Location Code Code Normal → Location #14
84 Fax No. Text Normal
85 Telex Answer Back Text Normal
86 VAT Registration No. Text Normal
87 Combine Sales Shipments Boolean Normal
88 Gen. Bus. Posting Group Code Normal → Gen. Business Posting Group #250
90 GLN Code Normal
91 Post Code Code Normal
92 County Text Normal
93 EORI Number Text Normal
95 Use GLN in Electronic Documents Boolean Normal
97 Debit Amount ⚡ FLOW Decimal FlowField
98 Credit Amount ⚡ FLOW Decimal FlowField
99 Debit Amount (LCY) ⚡ FLOW Decimal FlowField
100 Credit Amount (LCY) ⚡ FLOW Decimal FlowField
102 Email Text Normal
103 Home Page Text Normal
104 Reminder Terms Code Code Normal → Reminder Terms #292
105 Reminder Amounts ⚡ FLOW Decimal FlowField
106 Reminder Amounts (LCY) ⚡ FLOW Decimal FlowField
107 No. Series Code Normal → No. Series #308
108 Tax Area Code Code Normal → Tax Area #318
109 Tax Liable Boolean Normal
110 VAT Bus. Posting Group Code Normal → VAT Business Posting Group #323
111 Currency Filter Code FlowFilter → Currency #4
113 Outstanding Orders (LCY) ⚡ FLOW Decimal FlowField
114 Shipped Not Invoiced (LCY) ⚡ FLOW Decimal FlowField
115 Reserve Option Normal
116 Block Payment Tolerance Boolean Normal
117 Pmt. Disc. Tolerance (LCY) ⚡ FLOW Decimal FlowField
118 Pmt. Tolerance (LCY) ⚡ FLOW Decimal FlowField
119 IC Partner Code Code Normal → IC Partner #413
120 Refunds ⚡ FLOW Decimal FlowField
121 Refunds (LCY) ⚡ FLOW Decimal FlowField
122 Other Amounts ⚡ FLOW Decimal FlowField
123 Other Amounts (LCY) ⚡ FLOW Decimal FlowField
124 Prepayment % Decimal Normal
125 Outstanding Invoices (LCY) ⚡ FLOW Decimal FlowField
126 Outstanding Invoices ⚡ FLOW Decimal FlowField
130 Bill-to No. Of Sales Archived Doc. ⚡ FLOW Integer FlowField
131 Sell-to No. Of Sales Archived Doc. ⚡ FLOW Integer FlowField
132 Partner Type Option Normal
133 Intrastat Partner Type Option Normal
134 Exclude from Payment Practices Boolean Normal
140 Image Media Normal
150 Privacy Blocked Boolean Normal
160 Disable Search by Name Boolean Normal
175 Allow Multiple Posting Groups Boolean Normal
288 Preferred Bank Account Code Code Normal → Customer Bank Account #287
721 Coupled to Dataverse ⚡ FLOW Boolean FlowField
840 Cash Flow Payment Terms Code Code Normal → Payment Terms #3
4810 Default Trans. Type Code Normal → Transaction Type #258
4811 Default Trans. Type - Returns Code Normal → Transaction Type #258
4812 Default Transport Method Code Normal → Transport Method #259
5049 Primary Contact No. Code Normal → Contact #5050
5050 Contact Type Option Normal
5061 Mobile Phone No. Text Normal
5700 Responsibility Center Code Normal → Responsibility Center #5714
5750 Shipping Advice Option Normal
5790 Shipping Time DateFormula Normal
5792 Shipping Agent Service Code Code Normal → Shipping Agent Services #5790
5900 Service Zone Code Code Normal → Service Zone #5957
5902 Contract Gain/Loss Amount ⚡ FLOW Decimal FlowField
5903 Ship-to Filter Code FlowFilter → Ship-to Address #222
5910 Outstanding Serv. Orders (LCY) ⚡ FLOW Decimal FlowField
5911 Serv Shipped Not Invoiced(LCY) ⚡ FLOW Decimal FlowField
5912 Outstanding Serv.Invoices(LCY) ⚡ FLOW Decimal FlowField
5930 Combine Service Shipments Boolean Normal
7000 Price Calculation Method Option Normal
7001 Allow Line Disc. Boolean Normal
7171 No. of Quotes ⚡ FLOW Integer FlowField
7172 No. of Blanket Orders ⚡ FLOW Integer FlowField
7173 No. of Orders ⚡ FLOW Integer FlowField
7174 No. of Invoices ⚡ FLOW Integer FlowField
7175 No. of Return Orders ⚡ FLOW Integer FlowField
7176 No. of Credit Memos ⚡ FLOW Integer FlowField
7177 No. of Pstd. Shipments ⚡ FLOW Integer FlowField
7178 No. of Pstd. Invoices ⚡ FLOW Integer FlowField
7179 No. of Pstd. Return Receipts ⚡ FLOW Integer FlowField
7180 No. of Pstd. Credit Memos ⚡ FLOW Integer FlowField
7181 No. of Ship-to Addresses ⚡ FLOW Integer FlowField
7182 Bill-To No. of Quotes ⚡ FLOW Integer FlowField
7183 Bill-To No. of Blanket Orders ⚡ FLOW Integer FlowField
7184 Bill-To No. of Orders ⚡ FLOW Integer FlowField
7185 Bill-To No. of Invoices ⚡ FLOW Integer FlowField
7186 Bill-To No. of Return Orders ⚡ FLOW Integer FlowField
7187 Bill-To No. of Credit Memos ⚡ FLOW Integer FlowField
7188 Bill-To No. of Pstd. Shipments ⚡ FLOW Integer FlowField
7189 Bill-To No. of Pstd. Invoices ⚡ FLOW Integer FlowField
7190 Bill-To No. of Pstd. Return R. ⚡ FLOW Integer FlowField
7191 Bill-To No. of Pstd. Cr. Memos ⚡ FLOW Integer FlowField
7600 Base Calendar Code Code Normal → Base Calendar #7600
7601 Copy Sell-to Addr. to Qte From Option Normal
7602 Validate EU VAT Reg. No. Boolean Normal
8001 Currency Id GUID Normal → Currency #4
8002 Payment Terms Id GUID Normal → Payment Terms #3
8003 Shipment Method Id GUID Normal → Shipment Method #10
8004 Payment Method Id GUID Normal → Payment Method #289
8010 Customer Subscription Contracts ⚡ FLOW Integer FlowField
8011 Subscriptions ⚡ FLOW Integer FlowField
9003 Tax Area ID GUID Normal
9005 Contact ID GUID Normal
9006 Contact Graph Id Text Normal
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (34)

Tables referenced by fields on the Customer table through TableRelation properties.

Document Sending Profile
#60 · Other · via Document Sending Profile
Ship-to Address
#222 · Other · via Ship-to Code, Ship-to Filter
Territory
#286 · Other · via Territory Code
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code, Global Dimension 1 Filter, Global Dimension 2 Filter
Customer Posting Group
#92 · Other · via Customer Posting Group
Currency
#4 · General Ledger · via Currency Code, Currency Filter, Currency Id
Customer Price Group
#6 · General Ledger · via Customer Price Group
Language
#8 · General Ledger · via Language Code
Payment Terms
#3 · General Ledger · via Payment Terms Code, Cash Flow Payment Terms Code, Payment Terms Id
Finance Charge Terms
#5 · General Ledger · via Fin. Charge Terms Code
Salesperson/Purchaser
#13 · General Ledger · via Salesperson Code
Shipment Method
#10 · General Ledger · via Shipment Method Code, Shipment Method Id
Shipping Agent
#291 · Other · via Shipping Agent Code
Customer
#18 · Sales · via Invoice Disc. Code, Bill-to Customer No.
Customer Discount Group
#340 · Other · via Customer Disc. Group
Country/Region
#9 · General Ledger · via Country/Region Code
Payment Method
#289 · Other · via Payment Method Code, Payment Method Id
Location
#14 · General Ledger · via Location Code
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Reminder Terms
#292 · Other · via Reminder Terms Code
No. Series
#308 · Other · via No. Series
Tax Area
#318 · Other · via Tax Area Code
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group
IC Partner
#413 · Other · via IC Partner Code
Customer Bank Account
#287 · Other · via Preferred Bank Account Code
Transaction Type
#258 · Other · via Default Trans. Type, Default Trans. Type - Returns
Transport Method
#259 · Other · via Default Transport Method
Contact
#5050 · Other · via Primary Contact No.
Responsibility Center
#5714 · Other · via Responsibility Center
Shipping Agent Services
#5790 · Other · via Shipping Agent Service Code
Service Zone
#5957 · Service · via Service Zone Code
Base Calendar
#7600 · Other · via Base Calendar Code

© 2026 Xpertly Ltd · Company No. 14753894 · VAT No. 452840787

HomeData ExplorerPricingPrivacyTerms