SOP10102 - Sales GL Distributions (Work & History)
Stores GL account distribution details for sales transactions.
SQL Query Builder
15 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) '' | ||||
| SEQNUMBR | int 0 | ||||
| DISTTYPE | smallint 0 | ||||
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 | char(31) '' | ||||
| 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 | |||
| DEBITAMT | numeric(19,5) 0.00 | ||||
| ORDBTAMT | numeric(19,5) 0.00 | ||||
| CRDTAMNT | numeric(19,5) 0.00 | ||||
| ORCRDAMT | numeric(19,5) 0.00 | ||||
| CURRNIDX | smallint 0 | ||||
| TRXSORCE | char(13) '' | ||||
| POSTED | tinyint 0 | ||||
| Contract_Exchange_Rate | numeric(19,7) 0.00 | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Reporting Tips
- - Use DISTTYPE to identify the distribution category (Sales, COGS, Freight, etc.)
- - ACTINDX links to GL00105
Related Tables
Tables that share columns with SOP10102. Click "Join" to add to your query.