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 TypeLength
1PONUMBER SearchPO NumberSTR17_POP_NumberString17
2DOCPRINTSEQ SearchDocument Print SequencelongLong Integer8
3ORD SearchOrdLI_Sequence_NumberLong Integer10
4BRKFLD1 SearchBreak Field 1INT1Integer1
5BRKFLD2 SearchBreak Field 2INT1Integer1
6BRKFLD3 SearchBreak Field 3INT1Integer1
7Product_Indicator SearchProduct IndicatorDDL_Product_IndicatorInteger0
8JOBNUMBR SearchJob NumberSTR17_LBAUString17
9WS_Job_Name SearchWS Job NameSTR30String30
10COSTTYPE SearchCost Code TypeINT3_RB0_UInteger3
11COSTCODE SearchCost CodeSTR27String27
12Cost_Code_Description SearchCost Code DescriptionSTR30String30
13POLNESTA SearchPO Line StatusDDL_PO_Line_StatusInteger0
14POSTATUS SearchPO StatusDDL_PO_StatusInteger0
15QTYORDER SearchQTY OrderedDLR17_QTY_RBS0_UTRCurrency17
16QTYCOMTD SearchQTY CommittedDLR17_QTY_RBS0_UTRCurrency17
17QTYINVCD SearchQTY InvoicedDLR17_QTY_RBS0_UTRCurrency17
18QTYCANCE SearchQTY CanceledDLR17_QTY_RBS0_UTRCurrency17
19QTYREJ SearchQTY RejectedDLR17_QTY_RBS0_UTRCurrency17
20QTY_Actual SearchQTY ActualDLR17_QTY_RBS0_UTRCurrency17
21UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency17
22Retention_Pct SearchRetention %DLR14_TSCurrency14
23Retention_Amount_TTD SearchRetention Amount TTDDLR14_TSCurrency14
24TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
25FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
26Committed_Cost SearchCommitted CostDLR19_TSCurrency19
27Actual_Total_Cost SearchActual Total CostDLR14_RBS0_STR$Currency14
28WSPOText SearchWSPOTextSTR15_LBAUString15
29Line_Number SearchLine NumberLI_Sequence_NumberLong Integer10
30ADDRSEQ SearchAddress SequencelongLong Integer8
31SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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_LBString20
33CMPNYNAM SearchCompany NameSTR64_Company_NameString64
34CONTACT SearchContactSTR60String60
35ADDRESS1 SearchAddress 1STR60String60
36ADDRESS2 SearchAddress 2STR60String60
37ADDRESS3 SearchAddress 3STR60String60
38CITY SearchCitySTR35String35
39STATE SearchStateSTR30_StateString29
40ZIPCODE SearchZip CodeSTR10String10
41COUNTRY SearchCountrySTR60String60
42Project_Number SearchWS Project NumberSTR170String17
43TXTFIELD SearchText FieldTX32000Text32000
azurecurveProductsWennSoft Products (131)3rd PartyWennsoft PO Integration Temp (WSPRINT2)

Leave a Reply

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