CN20100 - Collections - Invoice Notes Open
Dynamics GP table CN20100 (Collections - Invoice Notes Open) contains 11 columns including CUSTNMBR, CPRCSTNM, RMDTYPAL....
SQL Query Builder
11 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| CUSTNMBR | Customer Number | String | 16 | |
| CPRCSTNM | Corporate Customer Number | String | 16 | |
| RMDTYPAL | RM Document Type-All0 = Reserved for balance carried forward records1 = Sales / Invoice2 = Reserved for schedule payments3 = Debit Memos4 = Finance Charges5 = Service Repairs6= Warranties7 = Credit Memos8 = Returns9 = Payments | Integer | 2 | |
| DOCNUMBR | Document Number | String | 22 | |
| NOTEINDX | Note Index | Currency | 10 | |
| ActionType | Action Type | Integer | 2 | |
| ActionAmount | Action Amount | Currency | 10 | |
| CURTRXAM | Current Trx Amount | Currency | 10 | |
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | |
| CURRNIDX | Currency Index | Integer | 2 | |
| AGNGBUKT | Aging Bucket | Integer | 2 |
Related Tables
Tables that share columns with CN20100. Click "Join" to add to your query.