IVC10300 - Invoicing Distributions
Dynamics GP table IVC10300 (Invoicing Distributions) contains 10 columns including DOCTYPE, INVCNMBR, SEQNUMBR....
SQL Query Builder
10 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 | ||
| DISTTYPE | Distribution Type1 = Cash2 = Payable3 = Discount Available4 = Discount Taken5 = Finance Charge6 = Purchase8 = Misc. Charge9 = Freight10 = Taxes11 = Writeoffs12 = Other13 = GST Disc | Integer | 2 | ||
Distribution Type (Payables) values (19) 1 = Cash2 = Payable3 = Discount Available4 = Discount Taken5 = Finance Charge6 = Purchase7 = Trade Discount8 = Miscellaneous Charge9 = Freight10 = Taxes11 = Writeoffs12 = Other13 = GST Discount14 = PPS Amount16 = Rounding17 = Realized Gain18 = Realized Loss19 = Due To20 = Due From | |||||
| DistRef | Distribution Reference | String | 32 | ||
| ACTINDX | Account Index Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | Long Integer | 4 | ||
| DEBITAMT | Debit Amount | Currency | 10 | ||
| CRDTAMNT | Credit Amount | Currency | 10 | ||
| TRXSORCE | TRX Source | String | 14 | ||
| POSTED | Posted | Boolean | 2 | ||
Related Tables
Tables that share columns with IVC10300. Click "Join" to add to your query.