WS Sales Transaction Amounts History (WSS30300)

azurecurve Products WennSoft Products (131)3rd PartyWS Sales Transaction Amounts History (WSS30300)

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
Physical Name: WSS30300
Technical Name: WS_SOP_LINE_HIST

Group Display Name: WS Shared
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/hide SELECT ['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/hide SELECT ['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

azurecurve Products WennSoft Products (131)3rd PartyWS Sales Transaction Amounts History (WSS30300)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply