WS Print Documents List (WSPRINT1)

azurecurveProductsWennSoft Products (131)PurchasingWS Print Documents List (WSPRINT1)

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

Product: WennSoft Products (131)
Series: Purchasing

Display Name: WS Print Documents List
Physical Name: WSPRINT1
Technical Name: WS_POP_PrintDocList_TEMP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PONUMBER SearchPO NumberSTR17_POP_NumberString1817
2DOCPRINTSEQ SearchDocument Print SequencelongLong Integer48
3VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['WS Print Documents List'].VENDORID AS 'WS Print Documents List-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       WSPRINT1 AS ['WS Print Documents List']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['WS Print Documents List'].VENDORID = ['PM Vendor Master File'].VENDORID
4PO_Status_Orig SearchPO Status OrigDDL_PO_StatusInteger20
5Change_Order_Flag SearchChange Order FlagINTInteger20
6PO_Field_Changes_Array_1 SearchPO Field Changes Array[1]BooleanBoolean20
7PO_Field_Changes_Array_2 SearchPO Field Changes Array[2]BooleanBoolean20
8PO_Field_Changes_Array_3 SearchPO Field Changes Array[3]BooleanBoolean20
9PO_Field_Changes_Array_4 SearchPO Field Changes Array[4]BooleanBoolean20
10PO_Field_Changes_Array_5 SearchPO Field Changes Array[5]BooleanBoolean20
11PO_Field_Changes_Array_6 SearchPO Field Changes Array[6]BooleanBoolean20
12PO_Field_Changes_Array_7 SearchPO Field Changes Array[7]BooleanBoolean20
13PO_Field_Changes_Array_8 SearchPO Field Changes Array[8]BooleanBoolean20
14PO_Field_Changes_Array_9 SearchPO Field Changes Array[9]BooleanBoolean20
15PO_Field_Changes_Array_10 SearchPO Field Changes Array[10]BooleanBoolean20
16PO_Field_Changes_Array_11 SearchPO Field Changes Array[11]BooleanBoolean20
17CMPNYNAM SearchCompany NameSTR64_Company_NameString6664
18CONTACT SearchContactSTR60String6260
19ADDRESS1 SearchAddress 1STR60String6260
20ADDRESS2 SearchAddress 2STR60String6260
21ADDRESS3 SearchAddress 3STR60String6260
22CITY SearchCitySTR35String3635
23STATE SearchStateSTR30_StateString3029
24ZIPCODE SearchZip CodeSTR10String1210
25COUNTRY SearchCountrySTR60String6260
26PRINTINGMULTIPLEPO SearchPrinting Multiple POSTR150String152150
27Email_Type SearchEmail TypeINTInteger20
28TXTFIELD SearchText FieldTX32000Text232000
azurecurveProductsWennSoft Products (131)PurchasingWS Print Documents List (WSPRINT1)

Leave a Reply

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