PO_Voided_LINE_File_550 (PO00900)

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_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PONUMWRK SearchPurchase_Order_Number_WORK_STRSTR20_LBAUString2220
2PURORDLINSEQ SearchPurchase_Order_Line_Sequence_DOLDLR17_RBS0_STRCurrency1017
3DELTOID SearchDelivery_To_ID_STRSTR20_LBAUString2220
4ITMNUM SearchItem_Number_STRSTR30_Item_NumberString3230
5POLT SearchPurchase_Order_Line_Total_DOLDLR17_RBS0_UTR$Currency1017
6SLSTAXEXEMPSTAT SearchSales_Tax_Exemption_Status_CBCB_Sales_Tax_Exemption_StatusBoolean20
7TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
8PRICSHED SearchPrice ScheduleSTR10_ScheduleString1210
9LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
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'].LOCNCODE
10ITMDESC SearchItem_Description_STRSTR50String5250
11UOM SearchUnit_Of_Measure_STRU_Of_MString108
12FFQ SearchFactor_For_QuantityDLR19_QTY_RBS0_STRCurrency1019
13QYORD SearchQuantity_Ordered_DOLDLR17_RBS0_STRCurrency1017
14QTYREQ SearchQuantity_Requisitioned_DOLDLR17_RBS0_UTR$Currency1017
15QTYINV SearchQuantity_Invoiced_DOLDLR17_RBS0_STRCurrency1017
16QTYREL SearchQuantity_Released_DOLDLR17_RBS0_STRCurrency1017
17QTYREC SearchQuantity_Received_DOLDLR17_RBS0_STRCurrency1017
18QTYACC SearchQuantity_Accepted_DOLDLR17_RBS0_STRCurrency1017
19QTYREJ0 SearchQuantity_Rejected_DOLDLR17_RBS0_STRCurrency1017
20QTYWO SearchQuantity_Write_Off_DOLDLR17_RBS0_STRCurrency1017
21QTYVOID SearchQuantity_Voided_DOLDLR17_RBS0_STRCurrency1017
22FREQ SearchFrequency_INTINT3Integer23
23PRTDATE SearchPrint_Date_DATEDATEDate46
24FREQTYP SearchFrequency_Type_INTINT3Integer23
25VNDITMNUM SearchVendor_Item_Number_STRSTR30_Item_NumberString3230
26PURACCACCT SearchPurchase_Accruals_Account_Index_LILI_14Long Integer414
27ACCTPAYACCACCT SearchAccounts_Payable_Accrual_Account_Index_LILI_14Long Integer414
28PURACCT SearchPurchases_Account_Index_LILI_14Long Integer414
29ACCTPAYACCT SearchAccounts_Payable_Account_Index_LILI_14Long Integer414
30EXPUNTCST SearchExpected_Unit_Cost_DOLPO_Unit_Cost_VCCurrency (Variable)1223
31Expected_Unit_Cost_DOL SearchTemp_Expected_Unit_Cost_DOLDLR17_RBS0_STR$Currency1017
32ACTUNTCST SearchActual_Unit_Cost_DOLPO_Unit_Cost_VCCurrency (Variable)1223
33Temp_Actual_Unit_Cost_DO SearchTemp_Actual_Unit_Cost_DOLDLR17_RBS0_STR$Currency1017
34ITMTYPE SearchItem_Type_DDLItem_Type_DDLInteger20
35AMTINV SearchAmount_Invoiced_DOLDLR17_RBS0_STR$Currency1017
36DATEREQ SearchDate_Requested_DATEDATEDate46
37DATEPROM SearchDate_Promised_DATEDATEDate46
38NOTE SearchNote_Index_DOLDLR14Currency1014
39LOCLINSEQ SearchLocation_Line_Sequence_DOLDLR17_RBS0_STRCurrency1017
40PriceGroup SearchPrice GroupSTR10_LBAUString1210

Leave a Reply

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