Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PO00900
Product: WennSoft Products (131)
Series: Purchasing
Display Name: PO_Voided_LINE_File
Physical Name: PO00900
Technical Name: PO_Voided_LINE_FileSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PONUMWRK 
Purchase_Order_Number_WORK_STR STR20_LBAU String 20 2 PURORDLINSEQ Purchase_Order_Line_Sequence_DOL DLR17_RBS0_STR Currency 17 3 DELTOID Delivery_To_ID_STR STR20_LBAU String 20 4 ITMNUM Item_Number_STR STR30_Item_Number String 30 5 POLT Purchase_Order_Line_Total_DOL DLR17_RBS0_UTR$ Currency 17 6 SLSTAXEXEMPSTAT Sales_Tax_Exemption_Status_CB CB_Sales_Tax_Exemption_Status Boolean 0 7 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 8 PRICSHED Price Schedule STR10_Schedule String 10 9 LOCNCODE Location Code STR10_Location_Code String 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['PO_Voided_LINE_File'].LOCNCODE AS 'PO_Voided_LINE_File-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
PO00900 AS ['PO_Voided_LINE_File']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['PO_Voided_LINE_File'].LOCNCODE = ['Site Setup'].LOCNCODE10 UOM Unit_Of_Measure_STR U_Of_M String 8 11 ITMDESC Item_Description_STR STR50 String 50 12 FFQ Factor_For_Quantity DLR19_QTY_RBS0_STR Currency 19 13 QYORD Quantity_Ordered_DOL DLR17_RBS0_STR Currency 17 14 QTYREQ Quantity_Requisitioned_DOL DLR17_RBS0_UTR$ Currency 17 15 QTYREL Quantity_Released_DOL DLR17_RBS0_STR Currency 17 16 QTYINV Quantity_Invoiced_DOL DLR17_RBS0_STR Currency 17 17 QTYREC Quantity_Received_DOL DLR17_RBS0_STR Currency 17 18 QTYACC Quantity_Accepted_DOL DLR17_RBS0_STR Currency 17 19 QTYREJ0 Quantity_Rejected_DOL DLR17_RBS0_STR Currency 17 20 QTYWO Quantity_Write_Off_DOL DLR17_RBS0_STR Currency 17 21 QTYVOID Quantity_Voided_DOL DLR17_RBS0_STR Currency 17 22 PRTDATE Print_Date_DATE DATE Date 6 23 FREQ Frequency_INT INT3 Integer 3 24 FREQTYP Frequency_Type_INT INT3 Integer 3 25 VNDITMNUM Vendor_Item_Number_STR STR30_Item_Number String 30 26 PURACCACCT Purchase_Accruals_Account_Index_LI LI_14 Long Integer 14 27 ACCTPAYACCACCT Accounts_Payable_Accrual_Account_Index_LI LI_14 Long Integer 14 28 PURACCT Purchases_Account_Index_LI LI_14 Long Integer 14 29 ACCTPAYACCT Accounts_Payable_Account_Index_LI LI_14 Long Integer 14 30 EXPUNTCST Expected_Unit_Cost_DOL PO_Unit_Cost_VC Currency (Variable) 23 31 ACTUNTCST Actual_Unit_Cost_DOL PO_Unit_Cost_VC Currency (Variable) 23 32 Expected_Unit_Cost_DOL Temp_Expected_Unit_Cost_DOL DLR17_RBS0_STR$ Currency 17 33 Temp_Actual_Unit_Cost_DO Temp_Actual_Unit_Cost_DOL DLR17_RBS0_STR$ Currency 17 34 AMTINV Amount_Invoiced_DOL DLR17_RBS0_STR$ Currency 17 35 ITMTYPE Item_Type_DDL Item_Type_DDL Integer 0 36 DATEREQ Date_Requested_DATE DATE Date 6 37 DATEPROM Date_Promised_DATE DATE Date 6 38 NOTE Note_Index_DOL DLR14 Currency 14 39 LOCLINSEQ Location_Line_Sequence_DOL DLR17_RBS0_STR Currency 17 40 PriceGroup Price Group STR10_LBAU String 10