Other table in Microsoft Dynamics 365 Business Central. 108 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: CUSTNMBR.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 |