IVC10200 - Invoicing Payments Work
Dynamics GP table IVC10200 (Invoicing Payments Work) contains 17 columns including DOCTYPE, INVCNMBR, SEQNUMBR....
SQL Query Builder
17 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| DOCTYPE | Document Type | Integer | 2 | ||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| INVCNMBR | Invoice Number | String | 22 | ||
| SEQNUMBR | Sequence Number | Long Integer | 4 | ||
| PYMTTYPE | Payment Type | Integer | 2 | ||
Payment Type (SOP) values (6) 1 = Cash Deposit2 = Check Deposit3 = Credit Card Deposit4 = Cash Payment5 = Check Payment6 = Credit Card Payment | |||||
| 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 | ||
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | ||
| CHEKBKID | Checkbook ID | String | 16 | ||
| CARDNAME | Card Name | String | 16 | ||
| RCTNCCRD | Receipt Number Credit Card | String | 22 | ||
| CHEKNMBR | Check Number | String | 22 | ||
| AMNTPAID | Amount Paid | Currency | 10 | ||
| DOCDATE | Document Date | Date | 4 | ||
| EXPNDATE | Expiration Date | Date | 4 | ||
| AUTHCODE | Authorization Code | String | 16 | ||
| TRXSORCE | TRX Source | String | 14 | ||
| EFTFLAG | EFT Flag | Boolean | 2 | ||
Related Tables
Tables that share columns with IVC10200. Click "Join" to add to your query.