Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WSS30300
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: WS Sales Transaction Amounts History Group Display Name: WS Shared
Physical Name: WSS30300
Technical Name: WS_SOP_LINE_HIST
Group Technical Name: WS Shared
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | SOPTYPE ![]() | SOP Type | DDL_SOP_Type | Integer | 0 | |
2 | SOPNUMBE ![]() | SOP Number | STR20_SOP_Number | String | 17 | |
3 | LNITMSEQ ![]() | Line Item Sequence | LI_Sequence_Number | Long Integer | 10 | |
4 | CMPNTSEQ ![]() | Component Sequence | LI_Sequence_Number | Long Integer | 10 | |
5 | Product_Indicator ![]() | Product Indicator | DDL_Product_Indicator | Integer | 0 | |
6 | DOCDATE ![]() | Document Date | DT | Date | 8 | |
7 | WS_Job_Number ![]() | WS Job Number | STR17_LBAU | String | 17 | |
8 | WS_Cost_Code ![]() | WS Cost Code | LI8_U0 | Long Integer | 8 | |
9 | WS_Other_Cost_Sub_Code ![]() | WS Other Cost Sub Code | LI8_U0 | Long Integer | 8 | |
10 | Cost_Code_Number_1 ![]() | Cost Code Number:CC_Phase | STR6_CC_Phase | String | 6 | |
11 | Cost_Code_Number_2 ![]() | Cost Code Number:CC_Step | STR6_CC_Steps | String | 6 | |
12 | Cost_Code_Number_3 ![]() | Cost Code Number:CC_Detail | STR6_CC_Detail | String | 6 | |
13 | Cost_Code_Number_4 ![]() | Cost Code Number:CC_Component | STR6_CC_Component | String | 6 | |
14 | Cost_Element ![]() | Cost Element | INT3_RB0_U | Integer | 3 | |
15 | Cost_Code_Description ![]() | Cost Code Description | STR30 | String | 30 | |
16 | ITEMDESC ![]() | Item Description | STR100 | String | 100 | |
17 | LOCNCODE ![]() | Location Code | STR10_Location_Code | String | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['WS Sales Transaction Amounts History'].LOCNCODE AS 'WS Sales Transaction Amounts History-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
WSS30300 AS ['WS Sales Transaction Amounts History']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['WS Sales Transaction Amounts History'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
18 | ITEMNMBR ![]() | Item Number | STR30_Item_Number | String | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['WS Sales Transaction Amounts History'].ITEMNMBR AS 'WS Sales Transaction Amounts History-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
WSS30300 AS ['WS Sales Transaction Amounts History']
INNER JOIN
IV00101 AS ['Item Master']
ON
['WS Sales Transaction Amounts History'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
19 | UOFM ![]() | U Of M | U_Of_M | String | 8 | |
20 | TRXQTY ![]() | TRX QTY | DLR17_QTY_RBS0_STR | Currency | 17 | |
21 | UNITCOST ![]() | Unit Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
22 | EXTDCOST ![]() | Extended Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
23 | XTNDPRCE ![]() | Extended Price | DLR17_RBS0_STR$ | Currency | 17 | |
24 | NONINVEN ![]() | Non IV | INT1 | Integer | 1 | |
25 | Equipment_ID ![]() | Equipment ID | STR30 | String | 30 | |
26 | Equipment_Type ![]() | Equipment Type | STR30 | String | 30 | |
27 | TAXAMNT ![]() | Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
28 | VOIDED ![]() | Voided | CB | Boolean | 0 | |
29 | Divisions ![]() | Divisions | STR15_LBAU | String | 15 | |
30 | Contract_Valid ![]() | Contract Valid | INT2 | Integer | 2 | |
31 | COMPTRNM ![]() | Computer TRX Number | LI8_U0 | Long Integer | 8 | |
32 | TRXDSCRN ![]() | Transaction Description | STR30 | String | 30 | |
33 | MRKDNAMT ![]() | Markdown Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
34 | Account_Index_Array_2_1 ![]() | Account Index Array 2[1] | LI_14 | Long Integer | 14 | |
35 | Account_Index_Array_2_2 ![]() | Account Index Array 2[2] | LI_14 | Long Integer | 14 | |
36 | Account_Index_Array_2_3 ![]() | Account Index Array 2[3] | LI_14 | Long Integer | 14 | |
37 | Account_Index_Array_2_4 ![]() | Account Index Array 2[4] | LI_14 | Long Integer | 14 | |
38 | Account_Index_Array_2_5 ![]() | Account Index Array 2[5] | LI_14 | Long Integer | 14 | |
39 | Profit_Type_Number ![]() | Profit Type Number | INT2 | Integer | 2 | |
40 | Profit_Amount ![]() | Profit Amount | DLR14_TS | Currency | 14 | |
41 | Record_Notes ![]() | Record Notes | TX32000 | Text | 32000 |