IVC10400 - Invoicing Commissions
Dynamics GP table IVC10400 (Invoicing Commissions) contains 14 columns including DOCTYPE, INVCNMBR, SEQNUMBR....
SQL Query Builder
14 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 | ||
| SLPRSNID | Salesperson ID | String | 16 | ||
| SALSTERR | Sales Territory | String | 16 | ||
| COMPRCNT | Commission Percent | Integer | 2 | ||
| COMDLRAM | Commission Dollar Amount | Currency | 10 | ||
| NCOMAMNT | Non-Commissioned Amount | Currency | 10 | ||
| PRCTOSAL | Percent of Sale | Integer | 2 | ||
| SLSAMNT | Sales Amount | Currency | 10 | ||
| COMMCODE | Commission Code | String | 16 | ||
| TRXSORCE | TRX Source | String | 14 | ||
| COMMFLAG | Commission Flag | Integer | 2 | ||
| ACTVTYPE | Activity Type | Integer | 2 | ||
Related Tables
Tables that share columns with IVC10400. Click "Join" to add to your query.