WSS30300 - WS Sales Transaction Amounts History
SQL Query Builder
42 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| SOPTYPE | smallint | ||||
SOP Document Type values (6) 1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order | |||||
| SOPNUMBE | char(21) | ||||
| LNITMSEQ | int | ||||
| CMPNTSEQ | int | ||||
| Product_Indicator | smallint | ||||
| DOCDATE | datetime | ||||
| WS_Job_Number | char(17) | ||||
| WS_Cost_Code | int | ||||
| WS_Other_Cost_Sub_Code | int | ||||
| Cost_Code_Number_1 | char(7) | ||||
| Cost_Code_Number_2 | char(7) | ||||
| Cost_Code_Number_3 | char(7) | ||||
| Cost_Code_Number_4 | char(7) | ||||
| Cost_Element | smallint | ||||
| Cost_Code_Description | char(31) | ||||
| ITEMDESC | char(101) | ||||
| LOCNCODE | char(11) | ||||
| ITEMNMBR | char(31) | ||||
| UOFM | char(9) | ||||
| TRXQTY | numeric(19,5) | ||||
| UNITCOST | numeric(19,5) | ||||
| EXTDCOST | numeric(19,5) | ||||
| XTNDPRCE | numeric(19,5) | ||||
| NONINVEN | smallint | ||||
| Equipment_ID | char(31) | ||||
| Equipment_Type | char(31) | ||||
| TAXAMNT | numeric(19,5) | ||||
| VOIDED | tinyint | ||||
| Divisions | char(15) | ||||
| Contract_Valid | smallint | ||||
| COMPTRNM | int | ||||
| TRXDSCRN | char(31) | ||||
| MRKDNAMT | numeric(19,5) | ||||
| Account_Index_Array_2_1 | int | ||||
| Account_Index_Array_2_2 | int | ||||
| Account_Index_Array_2_3 | int | ||||
| Account_Index_Array_2_4 | int | ||||
| Account_Index_Array_2_5 | int | ||||
| Profit_Type_Number | smallint | ||||
| Profit_Amount | numeric(19,5) | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
| Record_Notes | text | ||||
Related Tables
Tables that share columns with WSS30300. Click "Join" to add to your query.