Table 18 Customer

Base Application, Microsoft.Sales.Customer

174 fields

IdNameTypeVersions
1No.Code[20]17-29
2NameText[100]17-29
3Search NameCode[100]17-29
4Name 2Text[50]17-29
5AddressText[100]17-29
6Address 2Text[50]17-29
7CityText[30]17-29
8ContactText[100]17-29
9Phone No.Text[30]17-29
10Telex No.Text[20]17-29
11Document Sending ProfileCode[20]17-29
12Ship-to CodeCode[10]17-29
14Our Account No.Text[20]17-29
15Territory CodeCode[10]17-29
16Global Dimension 1 CodeCode[20]17-29
17Global Dimension 2 CodeCode[20]17-29
18Chain NameCode[10]17-29
19Budgeted AmountDecimal17-29
20Credit Limit (LCY)Decimal17-29
21Customer Posting GroupCode[20]17-29
22Currency CodeCode[10]17-29
23Customer Price GroupCode[10]17-29
24Language CodeCode[10]17-29
25Registration NumberText[50]new in 21
26Statistics GroupInteger17-29
27Payment Terms CodeCode[10]17-29
28Fin. Charge Terms CodeCode[10]17-29
29Salesperson CodeCode[20]17-29
30Shipment Method CodeCode[10]17-29
31Shipping Agent CodeCode[10]17-29
32Place of ExportCode[20]17-29
33Invoice Disc. CodeCode[20]17-29
34Customer Disc. GroupCode[20]17-29
35Country/Region CodeCode[10]17-29
36Collection MethodCode[20]17-29
37AmountDecimal17-29
38CommentBoolean17-29
39BlockedEnum "Customer Blocked"17-29
40Invoice CopiesInteger17-29
Pending, tag 27.0, obsolete since 27: This field is not used consequently and hence does not work as expected. It should be retired.
41Last Statement No.Integer17-29
42Print StatementsBoolean17-29
45Bill-to Customer No.Code[20]17-29
46PriorityInteger17-29
47Payment Method CodeCode[10]17-29
48Format RegionText[80]new in 23
52First Transaction DateDatenew in 27
53Last Modified Date TimeDateTime17-29
54Last Date ModifiedDate17-29
55Date FilterDate17-29
56Global Dimension 1 FilterCode[20]17-29
57Global Dimension 2 FilterCode[20]17-29
58BalanceDecimal17-29
59Balance (LCY)Decimal17-29
60Net ChangeDecimal17-29
61Net Change (LCY)Decimal17-29
62Sales (LCY)Decimal17-29
63Profit (LCY)Decimal17-29
64Inv. Discounts (LCY)Decimal17-29
65Pmt. Discounts (LCY)Decimal17-29
66Balance DueDecimal17-29
67Balance Due (LCY)Decimal17-29
69PaymentsDecimal17-29
70Invoice AmountsDecimal17-29
71Cr. Memo AmountsDecimal17-29
72Finance Charge Memo AmountsDecimal17-29
74Payments (LCY)Decimal17-29
75Inv. Amounts (LCY)Decimal17-29
76Cr. Memo Amounts (LCY)Decimal17-29
77Fin. Charge Memo Amounts (LCY)Decimal17-29
78Outstanding OrdersDecimal17-29
79Shipped Not InvoicedDecimal17-29
80Application MethodEnum "Application Method"17-29changed in 18
82Prices Including VATBoolean17-29
83Location CodeCode[10]17-29
84Fax No.Text[30]17-29
85Telex Answer BackText[20]17-29
86VAT Registration No.Text[20]17-29
87Combine ShipmentsBoolean17-29
88Gen. Bus. Posting GroupCode[20]17-29
89PictureBlobgone after 25
Removed, tag 19.0, obsolete since 17: Replaced by Image field
90GLNCode[13]17-29
91Post CodeCode[20]17-29
92CountyText[30]17-29
93EORI NumberText[40]17-29
95Use GLN in Electronic DocumentBoolean17-29
97Debit AmountDecimal17-29
98Credit AmountDecimal17-29
99Debit Amount (LCY)Decimal17-29
100Credit Amount (LCY)Decimal17-29
102E-MailText[80]17-29
103Home PageText[255]17-29changed in 27
104Reminder Terms CodeCode[10]17-29
105Reminder AmountsDecimal17-29
106Reminder Amounts (LCY)Decimal17-29
107No. SeriesCode[20]17-29
108Tax Area CodeCode[20]17-29
109Tax LiableBoolean17-29
110VAT Bus. Posting GroupCode[20]17-29
111Currency FilterCode[10]17-29
113Outstanding Orders (LCY)Decimal17-29
114Shipped Not Invoiced (LCY)Decimal17-29
115ReserveEnum "Reserve Method"17-29
116Block Payment ToleranceBoolean17-29
117Pmt. Disc. Tolerance (LCY)Decimal17-29
118Pmt. Tolerance (LCY)Decimal17-29
119IC Partner CodeCode[20]17-29
120RefundsDecimal17-29
121Refunds (LCY)Decimal17-29
122Other AmountsDecimal17-29
123Other Amounts (LCY)Decimal17-29
124Prepayment %Decimal17-29
125Outstanding Invoices (LCY)Decimal17-29
126Outstanding InvoicesDecimal17-29
130Bill-to No. Of Archived Doc.Integer17-29
131Sell-to No. Of Archived Doc.Integer17-29
132Partner TypeEnum "Partner Type"17-29
133Intrastat Partner TypeEnum "Partner Type"new in 20
134Exclude from Pmt. PracticesBooleannew in 22
140ImageMedia17-29
150Privacy BlockedBoolean17-29
160Disable Search by NameBoolean17-29
175Allow Multiple Posting GroupsBooleannew in 22
288Preferred Bank Account CodeCode[20]17-29
720Coupled to CRMBooleannew in 19
Removed, tag 26.0, obsolete since 22: Replaced by flow field Coupled to Dataverse
721Coupled to DataverseBooleannew in 22
840Cash Flow Payment Terms CodeCode[10]17-29
5049Primary Contact No.Code[20]17-29
5050Contact TypeEnum "Contact Type"17-29
5061Mobile Phone No.Text[30]17-29
5700Responsibility CenterCode[10]17-29
5750Shipping AdviceEnum "Sales Header Shipping Advice"17-29
5790Shipping TimeDateFormula17-29
5792Shipping Agent Service CodeCode[10]17-29
5900Service Zone CodeCode[10]gone after 24
5902Contract Gain/Loss AmountDecimalgone after 24
5903Ship-to FilterCode[10]gone after 24
5910Outstanding Serv. Orders (LCY)Decimalgone after 24
5911Serv Shipped Not Invoiced(LCY)Decimalgone after 24
5912Outstanding Serv.Invoices(LCY)Decimalgone after 24
7000Price Calculation MethodEnum "Price Calculation Method"17-29
7001Allow Line Disc.Boolean17-29
7171No. of QuotesInteger17-29
7172No. of Blanket OrdersInteger17-29
7173No. of OrdersInteger17-29
7174No. of InvoicesInteger17-29
7175No. of Return OrdersInteger17-29
7176No. of Credit MemosInteger17-29
7177No. of Pstd. ShipmentsInteger17-29
7178No. of Pstd. InvoicesInteger17-29
7179No. of Pstd. Return ReceiptsInteger17-29
7180No. of Pstd. Credit MemosInteger17-29
7181No. of Ship-to AddressesInteger17-29
7182Bill-To No. of QuotesInteger17-29
7183Bill-To No. of Blanket OrdersInteger17-29
7184Bill-To No. of OrdersInteger17-29
7185Bill-To No. of InvoicesInteger17-29
7186Bill-To No. of Return OrdersInteger17-29
7187Bill-To No. of Credit MemosInteger17-29
7188Bill-To No. of Pstd. ShipmentsInteger17-29
7189Bill-To No. of Pstd. InvoicesInteger17-29
7190Bill-To No. of Pstd. Return R.Integer17-29
7191Bill-To No. of Pstd. Cr. MemosInteger17-29
7600Base Calendar CodeCode[10]17-29
7601Copy Sell-to Addr. to Qte FromEnum "Contact Type"17-29
7602Validate EU Vat Reg. No.Boolean17-29
8000IdGuidgone after 25
Removed, tag 22.0, obsolete since 17: This functionality will be replaced by the systemID field
8001Currency IdGuid17-29
8002Payment Terms IdGuid17-29
8003Shipment Method IdGuid17-29
8004Payment Method IdGuid17-29
9003Tax Area IDGuid17-29
9004Tax Area Display NameText[100]gone after 25
Removed, tag 15.0, obsolete since 17: This field is not needed and it should not be used.
9005Contact IDGuid17-29
9006Contact Graph IdText[250]17-29