GP RM00101 #40114

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

108
Fields
0
Records
1
Primary key
0
FlowFields
2
Relations
Open in Data Explorer →

Primary key

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

All fields (108)

GP RM00101 — FIELDS
NO.FIELDTYPECLASSRELATION
1 CUSTNMBR PK Text Normal
2 CUSTNAME Text Normal
3 CUSTCLAS Text Normal
4 CPRCSTNM Text Normal
5 CNTCPRSN Text Normal
6 STMTNAME Text Normal
7 SHRTNAME Text Normal
8 ADRSCODE Text Normal
9 UPSZONE Text Normal
10 SHIPMTHD Text Normal
11 TAXSCHID Text Normal
12 ADDRESS1 Text Normal
13 ADDRESS2 Text Normal
14 ADDRESS3 Text Normal
15 COUNTRY Text Normal
16 CITY Text Normal
17 STATE Text Normal
18 ZIP Text Normal
19 PHONE1 Text Normal
20 PHONE2 Text Normal
21 PHONE3 Text Normal
22 FAX Text Normal
23 PRBTADCD Text Normal
24 PRSTADCD Text Normal
25 STADDRCD Text Normal
26 SLPRSNID Text Normal
27 CHEKBKID Text Normal
28 PYMTRMID Text Normal
29 CRLMTTYP Integer Normal
30 CRLMTAMT Decimal Normal
31 CRLMTPER Integer Normal
32 CRLMTPAM Decimal Normal
33 CURNCYID Text Normal
34 RATETPID Text Normal
35 CUSTDISC Integer Normal
36 PRCLEVEL Text Normal
37 MINPYTYP Integer Normal
38 MINPYDLR Decimal Normal
39 MINPYPCT Integer Normal
40 FNCHATYP Integer Normal
41 FNCHPCNT Integer Normal
42 FINCHDLR Decimal Normal
43 MXWOFTYP Integer Normal
44 MXWROFAM Decimal Normal
45 COMMENT1 Text Normal
46 COMMENT2 Text Normal
47 USERDEF1 Text Normal
48 USERDEF2 Text Normal
49 TAXEXMT1 Text Normal
50 TAXEXMT2 Text Normal
51 TXRGNNUM Text Normal
52 BALNCTYP Integer Normal
53 STMTCYCL Integer Normal
54 BANKNAME Text Normal
55 BNKBRNCH Text Normal
56 SALSTERR Text Normal
57 DEFCACTY Integer Normal
58 RMCSHACC Integer Normal
59 RMARACC Integer Normal
60 RMSLSACC Integer Normal
61 RMIVACC Integer Normal
62 RMCOSACC Integer Normal
63 RMTAKACC Integer Normal
64 RMAVACC Integer Normal
65 RMFCGACC Integer Normal
66 RMWRACC Integer Normal
67 RMSORACC Integer Normal
68 FRSTINDT DateTime Normal
69 INACTIVE Boolean Normal
70 HOLD Boolean Normal
71 CRCARDID Text Normal
72 CRCRDNUM Text Normal
73 CCRDXPDT DateTime Normal
74 KPDSTHST Boolean Normal
75 KPCALHST Boolean Normal
76 KPERHIST Boolean Normal
77 KPTRXHST Boolean Normal
78 NOTEINDX Decimal Normal
79 CREATDDT DateTime Normal
80 MODIFDT DateTime Normal
81 Revalue_Customer Boolean Normal
82 Post_Results_To Integer Normal
83 FINCHID Text Normal
84 GOVCRPID Text Normal
85 GOVINDID Text Normal
86 DISGRPER Integer Normal
87 DUEGRPER Integer Normal
88 DOCFMTID Text Normal
89 Send_Email_Statements Boolean Normal
90 USERLANG Integer Normal
91 GPSFOINTEGRATIONID Text Normal
92 INTEGRATIONSOURCE Integer Normal
93 INTEGRATIONID Text Normal
94 ORDERFULFILLDEFAULT Integer Normal
95 CUSTPRIORITY Integer Normal
96 CCode Text Normal
97 DECLID Text Normal
98 RMOvrpymtWrtoffAcctIdx Integer Normal
99 SHIPCOMPLETE Boolean Normal
100 CBVAT Boolean Normal
101 INCLUDEINDP Boolean Normal
102 DEX_ROW_TS DateTime Normal
103 DEX_ROW_ID 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