CN100201 - Collections - Build Letter Invoices
Dynamics GP table CN100201 (Collections - Build Letter Invoices) contains 24 columns including USERID, CUSTNMBR, CPRCSTNM....
SQL Query Builder
24 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| USERID | User ID | String | 16 | |
| CUSTNMBR | Customer Number | String | 16 | |
| CPRCSTNM | Corporate Customer Number | String | 16 | |
| CN_Credit_Level | CN Credit Level | Integer | 2 | |
| CreditLevelFee | CN Credit Level Fee | Currency | 10 | |
| 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 | |
| UpdateCreditLevel | CN Update Credit Level | Boolean | 2 | |
| NOTEINDX | Note Index | Currency | 10 | |
| ActionType | Action Type | Integer | 2 | |
| ActionAmount | Action Amount | Currency | 10 | |
| ORTRXAMT | Original Trx Amount | Currency | 10 | |
| CURTRXAM | Current Trx Amount | Currency | 10 | |
| ORORGTRX | Originating Original Trx Amount | Currency | 10 | |
| ORCTRXAM | Originating Current Trx Amount | Currency | 10 | |
| DOCDATE | Document Date | Date | 4 | |
| DUEDATE | Due Date | Date | 4 | |
| CN_Letter_Date | CN Letter Date | Date | 4 | |
| AGNGBUKT | Aging Bucket | Integer | 2 | |
| 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 | |
| CN_New_Credit_Level | CN New Credit Level | Integer | 2 | |
| CN_New_Credit_Level_Fee | CN New Credit Level Fee | Currency | 10 | |
| ADRSCODE | Address Code | String | 16 |
Related Tables
Tables that share columns with CN100201. Click "Join" to add to your query.