Wennsoft PO Integration Temp (WSPRINT2)

azurecurveProductsWennSoft Products (131)3rd PartyWennsoft PO Integration Temp (WSPRINT2)

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

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

Display Name: Wennsoft PO Integration Temp
Physical Name: WSPRINT2
Technical Name: WS_POLineMemTEMP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PONUMBER SearchPO NumberSTR17_POP_NumberString1817
2DOCPRINTSEQ SearchDocument Print SequencelongLong Integer48
3ORD SearchOrdLI_Sequence_NumberLong Integer410
4BRKFLD1 SearchBreak Field 1INT1Integer21
5BRKFLD2 SearchBreak Field 2INT1Integer21
6BRKFLD3 SearchBreak Field 3INT1Integer21
7Product_Indicator SearchProduct IndicatorDDL_Product_IndicatorInteger20
8JOBNUMBR SearchJob NumberSTR17_LBAUString1817
9WS_Job_Name SearchWS Job NameSTR30String3230
10COSTTYPE SearchCost Code TypeINT3_RB0_UInteger23
11COSTCODE SearchCost CodeSTR27String2827
12Cost_Code_Description SearchCost Code DescriptionSTR30String3230
13POLNESTA SearchPO Line StatusDDL_PO_Line_StatusInteger20
14POSTATUS SearchPO StatusDDL_PO_StatusInteger20
15QTYORDER SearchQTY OrderedDLR17_QTY_RBS0_UTRCurrency1017
16QTYCOMTD SearchQTY CommittedDLR17_QTY_RBS0_UTRCurrency1017
17QTYINVCD SearchQTY InvoicedDLR17_QTY_RBS0_UTRCurrency1017
18QTYCANCE SearchQTY CanceledDLR17_QTY_RBS0_UTRCurrency1017
19QTYREJ SearchQTY RejectedDLR17_QTY_RBS0_UTRCurrency1017
20QTY_Actual SearchQTY ActualDLR17_QTY_RBS0_UTRCurrency1017
21UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency1017
22Retention_Pct SearchRetention %DLR14_TSCurrency1014
23Retention_Amount_TTD SearchRetention Amount TTDDLR14_TSCurrency1014
24TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
25FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
26Committed_Cost SearchCommitted CostDLR19_TSCurrency1019
27Actual_Total_Cost SearchActual Total CostDLR14_RBS0_STR$Currency1014
28WSPOText SearchWSPOTextSTR15_LBAUString1615
29Line_Number SearchLine NumberLI_Sequence_NumberLong Integer410
30ADDRSEQ SearchAddress SequencelongLong Integer48
31SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Wennsoft PO Integration Temp'].SHIPMTHD AS 'Wennsoft PO Integration Temp-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       WSPRINT2 AS ['Wennsoft PO Integration Temp']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Wennsoft PO Integration Temp'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
32ADDRPROMPT SearchAddress PromptSTR20_LBString2220
33CMPNYNAM SearchCompany NameSTR64_Company_NameString6664
34CONTACT SearchContactSTR60String6260
35ADDRESS1 SearchAddress 1STR60String6260
36ADDRESS2 SearchAddress 2STR60String6260
37ADDRESS3 SearchAddress 3STR60String6260
38CITY SearchCitySTR35String3635
39STATE SearchStateSTR30_StateString3029
40ZIPCODE SearchZip CodeSTR10String1210
41COUNTRY SearchCountrySTR60String6260
42Project_Number SearchWS Project NumberSTR170String1817
43TXTFIELD SearchText FieldTX32000Text232000
azurecurveProductsWennSoft Products (131)3rd PartyWennsoft PO Integration Temp (WSPRINT2)

Leave a Reply

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