Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
DOCTYPE | Document Type |
Integer | 2 | View | |
INVCNMBR | Invoice Number |
String | 22 | View | |
SEQNUMBR | Sequence Number |
Long Integer | 4 | View | |
SLPRSNID | Salesperson ID |
String | 16 | View | |
SALSTERR | Sales Territory |
String | 16 | View | |
COMPRCNT | Commission Percent |
Integer | 2 | View | |
COMDLRAM | Commission Dollar Amount |
Currency | 10 | View | |
NCOMAMNT | Non-Commissioned Amount |
Currency | 10 | View | |
PRCTOSAL | Percent of Sale |
Integer | 2 | View | |
SLSAMNT | Sales Amount |
Currency | 10 | View | |
COMMCODE | Commission Code |
String | 16 | View | |
TRXSORCE | TRX Source |
String | 14 | View | |
COMMFLAG | Commission Flag |
Integer | 2 | View | |
ACTVTYPE | Activity Type |
Integer | 2 | View |