IVC10500 - Invoicing Taxes
Dynamics GP table IVC10500 (Invoicing Taxes) contains 15 columns including DOCTYPE, INVCNMBR, LNITMSEQ....
SQL Query Builder
15 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 | ||
| LNITMSEQ | Line Item Sequence | Long Integer | 4 | ||
| TAXDTLID | Tax Detail ID | String | 16 | ||
| 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 | ||
| BKOUTTAX | Backout Tax | Boolean | 2 | ||
| TXABLETX | Taxable Tax | Boolean | 2 | ||
| STAXAMNT | Sales Tax Amount | Currency | 10 | ||
| FRTTXAMT | Freight Tax Amount | Currency | 10 | ||
| MSCTXAMT | Misc Tax Amount | Currency | 10 | ||
| TAXDTSLS | Tax Detail Total Sales | Currency | 10 | ||
| TDTTXSLS | Tax Detail Total Taxable Sales | Currency | 10 | ||
| TXDTOTTX | Tax Detail Total Tax Potential | Currency | 10 | ||
| DELETE1 | Delete | Boolean | 2 | ||
| TRXSORCE | TRX Source | String | 14 | ||
Related Tables
Tables that share columns with IVC10500. Click "Join" to add to your query.
BKOUTTAX