Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PO40202
Product: WennSoft Products (131)
Series: Purchasing
Display Name: PO_OPEN_LINE_Change_Order_File
Physical Name: PO40202
Technical Name: PO_OPEN_LINE_Change_Order_FileSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PURORDTYP 
Purchase_Order_Type_DDL DDL_Purchase_Order_Type Integer 0 2 INTLRSVBOOL1 INTL_RSV_BOOL_1 Boolean Boolean 0 3 INTLRSVBOOL2 INTL_RSV_BOOL_2 Boolean Boolean 0 4 INTLRSVDATE1 INTL_RSV_DATE_1 DATE Date 6 5 INTLRSVDATE2 INTL_RSV_DATE_2 DATE Date 6 6 INTLRSVDOL141 INTL_RSV_DOL14_1 DLR14 Currency 14 7 INTLRSVDOL142 INTL_RSV_DOL14_2 DLR14 Currency 14 8 INTLRSVINT61 INTL_RSV_INT6_1 LI6_S2 Long Integer 6 9 INTLRSVINT62 INTL_RSV_INT6_2 LI6_S2 Long Integer 6 10 INTLRSVSTR301 INTL_RSV_STR30_1 STR30 String 30 11 INTLRSVSTR302 INTL_RSV_STR30_2 STR30 String 30 12 REQNOSTR Requisition_Number_STR STR17_LBAU String 17 13 PONUMWRK Purchase_Order_Number_WORK_STR STR20_LBAU String 20 14 PURORDLINSEQ Purchase_Order_Line_Sequence_DOL DLR17_RBS0_STR Currency 17 15 DELTOID Delivery_To_ID_STR STR20_LBAU String 20 16 ITMNUM Item_Number_STR STR30_Item_Number String 30 17 POLT Purchase_Order_Line_Total_DOL DLR17_RBS0_UTR$ Currency 17 18 SLSTAXEXEMPSTAT Sales_Tax_Exemption_Status_CB CB_Sales_Tax_Exemption_Status Boolean 0 19 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 20 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 17 21 LOCNCODE Location Code STR10_Location_Code String 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['PO_OPEN_LINE_Change_Order_File'].LOCNCODE AS 'PO_OPEN_LINE_Change_Order_File-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
PO40202 AS ['PO_OPEN_LINE_Change_Order_File']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['PO_OPEN_LINE_Change_Order_File'].LOCNCODE = ['Site Setup'].LOCNCODE22 ITMDESC Item_Description_STR STR50 String 50 23 UOM Unit_Of_Measure_STR U_Of_M String 8 24 FFQ Factor_For_Quantity DLR19_QTY_RBS0_STR Currency 19 25 QYORD Quantity_Ordered_DOL DLR17_RBS0_STR Currency 17 26 QTYREQ Quantity_Requisitioned_DOL DLR17_RBS0_UTR$ Currency 17 27 QTYREL Quantity_Released_DOL DLR17_RBS0_STR Currency 17 28 QTYINV Quantity_Invoiced_DOL DLR17_RBS0_STR Currency 17 29 QTYREC Quantity_Received_DOL DLR17_RBS0_STR Currency 17 30 QTYACC Quantity_Accepted_DOL DLR17_RBS0_STR Currency 17 31 QTYREJ0 Quantity_Rejected_DOL DLR17_RBS0_STR Currency 17 32 QTYWO Quantity_Write_Off_DOL DLR17_RBS0_STR Currency 17 33 PRTDATE Print_Date_DATE DATE Date 6 34 FREQ Frequency_INT INT3 Integer 3 35 FREQTYP Frequency_Type_INT INT3 Integer 3 36 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['PO_OPEN_LINE_Change_Order_File'].VENDORID AS 'PO_OPEN_LINE_Change_Order_File-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
PO40202 AS ['PO_OPEN_LINE_Change_Order_File']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PO_OPEN_LINE_Change_Order_File'].VENDORID = ['PM Vendor Master File'].VENDORID37 VNDITMNUM Vendor_Item_Number_STR STR30_Item_Number String 30 38 PURACCACCT Purchase_Accruals_Account_Index_LI LI_14 Long Integer 14 39 POLINEITEMNUMBER PO_Line_Item_Number_INT LI_14 Long Integer 14 40 PURACCT Purchases_Account_Index_LI LI_14 Long Integer 14 41 ACCTPAYACCT Accounts_Payable_Account_Index_LI LI_14 Long Integer 14 42 EXPUNTCST Expected_Unit_Cost_DOL PO_Unit_Cost_VC Currency (Variable) 23 43 ACTUNTCST Actual_Unit_Cost_DOL PO_Unit_Cost_VC Currency (Variable) 23 44 AMTINV Amount_Invoiced_DOL DLR17_RBS0_STR$ Currency 17 45 ITMTYPE Item_Type_DDL Item_Type_DDL Integer 0 46 DATEREQ Date_Requested_DATE DATE Date 6 47 DATEPROM Date_Promised_DATE DATE Date 6 48 NOTE Note_Index_DOL DLR14 Currency 14 49 LOCLINSEQ Location_Line_Sequence_DOL DLR17_RBS0_STR Currency 17 50 COMMNTID Comment ID STR15_Comment_ID String 15 Key to the Comment Master (SY04200).
Click to show/hide
SELECT
['PO_OPEN_LINE_Change_Order_File'].COMMNTID AS 'PO_OPEN_LINE_Change_Order_File-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
PO40202 AS ['PO_OPEN_LINE_Change_Order_File']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['PO_OPEN_LINE_Change_Order_File'].COMMNTID = ['Comment Master'].COMMNTID51 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['PO_OPEN_LINE_Change_Order_File'].CUSTNMBR AS 'PO_OPEN_LINE_Change_Order_File-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
PO40202 AS ['PO_OPEN_LINE_Change_Order_File']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['PO_OPEN_LINE_Change_Order_File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR52 NONINVEN Non IV INT1 Integer 1 53 PCBJOBNUMBER PCB_Job_Number_STR STR10 String 10 54 PCBPNUM PCB_Phase_Number_STR STR10_Job String 10 55 PCBTASKNUM PCB_Task_Number_STR STR10_Job String 10 56 SOPNUMBE SOP Number STR20_SOP_Number String 17 57 POFCAMOUNT PO_FC_Amount_DOL DLR19_RBS0_STR$ Currency 19 58 POEXCHANERATE PO_Exchange_Rate DLR14_Exchange_Rate Currency (Variable) 14 59 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PO_OPEN_LINE_Change_Order_File'].CURNCYID AS 'PO_OPEN_LINE_Change_Order_File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PO40202 AS ['PO_OPEN_LINE_Change_Order_File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PO_OPEN_LINE_Change_Order_File'].CURNCYID = ['Currency Setup'].CURNCYID60 POREVEXPQTY PO_Revised_Expected_QTY DLR19_QTY_RBS0_UTR Currency 19 61 POREXPUNITCOST PO_Revised_Expected_Unit_Cost PO_Unit_Cost_VC Currency (Variable) 23 62 POREVEXPTOTAL PO_Revised_Expected_Total DLR19_RBSO_STR$ Currency 19 63 POREVISEDFREIGHT PO_Revised_Freight_Amount_DOL DLR19_RBSO_STR$ Currency 19 64 POREVTAX PO_Revised_Tax_Amount_DOL DLR19_RBSO_STR$ Currency 19 65 DATE1 Date DT6 Date 6 66 TIME1 Time TM6 Time 6 67 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['PO_OPEN_LINE_Change_Order_File'].USERID AS 'PO_OPEN_LINE_Change_Order_File-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PO40202 AS ['PO_OPEN_LINE_Change_Order_File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PO_OPEN_LINE_Change_Order_File'].USERID = ['Users Master'].USERID68 PriceGroup Price Group STR10_LBAU String 10