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_TEMPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PONUMBER 
PO Number STR17_POP_Number String 17 2 DOCPRINTSEQ Document Print Sequence long Long Integer 8 3 VENDORID Vendor ID STR_15_Vendor_ID String 15 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'].VENDORID4 PO_Status_Orig PO Status Orig DDL_PO_Status Integer 0 5 Change_Order_Flag Change Order Flag INT Integer 0 6 PO_Field_Changes_Array_1 PO Field Changes Array[1] Boolean Boolean 0 7 PO_Field_Changes_Array_2 PO Field Changes Array[2] Boolean Boolean 0 8 PO_Field_Changes_Array_3 PO Field Changes Array[3] Boolean Boolean 0 9 PO_Field_Changes_Array_4 PO Field Changes Array[4] Boolean Boolean 0 10 PO_Field_Changes_Array_5 PO Field Changes Array[5] Boolean Boolean 0 11 PO_Field_Changes_Array_6 PO Field Changes Array[6] Boolean Boolean 0 12 PO_Field_Changes_Array_7 PO Field Changes Array[7] Boolean Boolean 0 13 PO_Field_Changes_Array_8 PO Field Changes Array[8] Boolean Boolean 0 14 PO_Field_Changes_Array_9 PO Field Changes Array[9] Boolean Boolean 0 15 PO_Field_Changes_Array_10 PO Field Changes Array[10] Boolean Boolean 0 16 PO_Field_Changes_Array_11 PO Field Changes Array[11] Boolean Boolean 0 17 CMPNYNAM Company Name STR64_Company_Name String 64 18 CONTACT Contact STR60 String 60 19 ADDRESS1 Address 1 STR60 String 60 20 ADDRESS2 Address 2 STR60 String 60 21 ADDRESS3 Address 3 STR60 String 60 22 CITY City STR35 String 35 23 STATE State STR30_State String 29 24 ZIPCODE Zip Code STR10 String 10 25 COUNTRY Country STR60 String 60 26 PRINTINGMULTIPLEPO Printing Multiple PO STR150 String 150 27 Email_Type Email Type INT Integer 0 28 TXTFIELD Text Field TX32000 Text 32000