SOP10105 - Sales Taxes (Work & History)
Stores tax detail for sales transactions including tax amounts and tax schedule assignments.
SQL Query Builder
23 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| SOPTYPE | smallint 0 | ||||
SOP Document Type values (6) 1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order | |||||
| SOPNUMBE | char(21) '' | ||||
| LNITMSEQ | int 0 | ||||
| TAXDTLID | char(15) '' | ||||
| ACTINDX | Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | int 0 | |||
| BKOUTTAX | tinyint 0 | ||||
| TXABLETX | tinyint 0 | ||||
| STAXAMNT | numeric(19,5) 0.00 | ||||
| ORSLSTAX | numeric(19,5) 0.00 | ||||
| FRTTXAMT | numeric(19,5) 0.00 | ||||
| ORFRTTAX | numeric(19,5) 0.00 | ||||
| MSCTXAMT | numeric(19,5) 0.00 | ||||
| ORMSCTAX | numeric(19,5) 0.00 | ||||
| TAXDTSLS | numeric(19,5) 0.00 | ||||
| ORTOTSLS | numeric(19,5) 0.00 | ||||
| TDTTXSLS | numeric(19,5) 0.00 | ||||
| ORTXSLS | numeric(19,5) 0.00 | ||||
| TXDTOTTX | numeric(19,5) 0.00 | ||||
| OTTAXPON | numeric(19,5) 0.00 | ||||
| DELETE1 | tinyint 0 | ||||
| CURRNIDX | smallint 0 | ||||
| TRXSORCE | char(13) '' | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Reporting Tips
- - Join on SOPNUMBE and SOPTYPE
Related Tables
Tables that share columns with SOP10105. Click "Join" to add to your query.