WS Sales Transaction Amounts Work (WSS10200)

azurecurveProductsWennSoft Products (131)3rd PartyWS Sales Transaction Amounts Work (WSS10200)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WSS10200

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: WS Sales Transaction Amounts Work
Physical Name: WSS10200
Technical Name: WS_SOP_LINE_WORK

Group Display Name: WS Shared
Group Technical Name: WS Shared

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1SOPTYPE SearchSOP TypeDDL_SOP_TypeInteger20
2SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString2217
3LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
4CMPNTSEQ SearchComponent SequenceLI_Sequence_NumberLong Integer410
5Product_Indicator SearchProduct IndicatorDDL_Product_IndicatorInteger20
6DOCDATE SearchDocument DateDTDate48
7WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
8WS_Cost_Code SearchWS Cost CodeLI8_U0Long Integer48
9WS_Other_Cost_Sub_Code SearchWS Other Cost Sub CodeLI8_U0Long Integer48
10Cost_Code_Number_1 SearchCost Code Number:CC_PhaseSTR6_CC_PhaseString86
11Cost_Code_Number_2 SearchCost Code Number:CC_StepSTR6_CC_StepsString86
12Cost_Code_Number_3 SearchCost Code Number:CC_DetailSTR6_CC_DetailString86
13Cost_Code_Number_4 SearchCost Code Number:CC_ComponentSTR6_CC_ComponentString86
14Cost_Element SearchCost ElementINT3_RB0_UInteger23
15Cost_Code_Description SearchCost Code DescriptionSTR30String3230
16ITEMDESC SearchItem DescriptionSTR100String102100
17LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['WS Sales Transaction Amounts Work'].LOCNCODE AS 'WS Sales Transaction Amounts Work-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       WSS10200 AS ['WS Sales Transaction Amounts Work']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['WS Sales Transaction Amounts Work'].LOCNCODE = ['Site Setup'].LOCNCODE
18ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['WS Sales Transaction Amounts Work'].ITEMNMBR AS 'WS Sales Transaction Amounts Work-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       WSS10200 AS ['WS Sales Transaction Amounts Work']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['WS Sales Transaction Amounts Work'].ITEMNMBR = ['Item Master'].ITEMNMBR
19UOFM SearchU Of MU_Of_MString108
20TRXQTY SearchTRX QTYDLR17_QTY_RBS0_STRCurrency1017
21UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency1017
22EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency1017
23XTNDPRCE SearchExtended PriceDLR17_RBS0_STR$Currency1017
24NONINVEN SearchNon IVINT1Integer21
25TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
26Equipment_ID SearchEquipment IDSTR30String3230
27Equipment_Type SearchEquipment TypeSTR30String3230
28VOIDED SearchVoidedCBBoolean20
29Divisions SearchDivisionsSTR15_LBAUString1615
30Contract_Valid SearchContract ValidINT2Integer22
31COMPTRNM SearchComputer TRX NumberLI8_U0Long Integer48
32TRXDSCRN SearchTransaction DescriptionSTR30String3230
33MRKDNAMT SearchMarkdown AmountDLR17_RBS0_UTR$Currency1017
34Account_Index_Array_2_1 SearchAccount Index Array 2[1]LI_14Long Integer414
35Account_Index_Array_2_2 SearchAccount Index Array 2[2]LI_14Long Integer414
36Account_Index_Array_2_3 SearchAccount Index Array 2[3]LI_14Long Integer414
37Account_Index_Array_2_4 SearchAccount Index Array 2[4]LI_14Long Integer414
38Account_Index_Array_2_5 SearchAccount Index Array 2[5]LI_14Long Integer414
39Profit_Type_Number SearchProfit Type NumberINT2Integer22
40Profit_Amount SearchProfit AmountDLR14_TSCurrency1014
41Record_Notes SearchRecord NotesTX32000Text232000
azurecurveProductsWennSoft Products (131)3rd PartyWS Sales Transaction Amounts Work (WSS10200)

Leave a Reply

Your email address will not be published. Required fields are marked *