GP Customer #4093

Other table in Microsoft Dynamics 365 Business Central. 31 fields, 0 records in Cronus demo.

The GP Customer table (ID 4093) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 31 fields, with a primary key of Customer Number. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

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

All fields (31)

GP Customer — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Customer Number PK	Text	Normal	→ Customer #18
2	Customer Name	Text	Normal
3	STMTNAME	Text	Normal
4	Address	Text	Normal
5	Address 2	Text	Normal
6	City	Text	Normal
7	Contact	Text	Normal
8	Phone No.	Text	Normal
9	Sales Territory	Text	Normal
10	Credit Limit Amount	Decimal	Normal
11	Payment Terms ID	Text	Normal
12	Salesperson Code	Text	Normal
13	Shipment Method Code	Text	Normal
14	Country	Text	Normal
15	Amount	Decimal	Normal
16	Statement Cycle	Boolean	Normal
17	Fax Number	Text	Normal
18	ZIP Code	Text	Normal
19	State	Text	Normal
20	Internet Information 1	Text	Normal
21	Internet Information 2	Text	Normal
22	Tax Schedule ID	Text	Normal
23	UPS Zone	Text	Normal
24	Tax Exempt 1	Text	Normal
25	CUSTCLAS	Text	Normal
26	RMSLSACC	Integer	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 (2)

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

Customer

#18 · Sales · via Customer Number