PO_Voided_LINE_File (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 TypeLength
1PONUMWRK SearchPurchase_Order_Number_WORK_STRSTR20_LBAUString20
2PURORDLINSEQ SearchPurchase_Order_Line_Sequence_DOLDLR17_RBS0_STRCurrency17
3DELTOID SearchDelivery_To_ID_STRSTR20_LBAUString20
4ITMNUM SearchItem_Number_STRSTR30_Item_NumberString30
5POLT SearchPurchase_Order_Line_Total_DOLDLR17_RBS0_UTR$Currency17
6SLSTAXEXEMPSTAT SearchSales_Tax_Exemption_Status_CBCB_Sales_Tax_Exemption_StatusBoolean0
7TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
8PRICSHED SearchPrice ScheduleSTR10_ScheduleString10
9LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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_STRSTR50String50
11UOM SearchUnit_Of_Measure_STRU_Of_MString8
12FFQ SearchFactor_For_QuantityDLR19_QTY_RBS0_STRCurrency19
13QYORD SearchQuantity_Ordered_DOLDLR17_RBS0_STRCurrency17
14QTYREQ SearchQuantity_Requisitioned_DOLDLR17_RBS0_UTR$Currency17
15QTYINV SearchQuantity_Invoiced_DOLDLR17_RBS0_STRCurrency17
16QTYREL SearchQuantity_Released_DOLDLR17_RBS0_STRCurrency17
17QTYREC SearchQuantity_Received_DOLDLR17_RBS0_STRCurrency17
18QTYACC SearchQuantity_Accepted_DOLDLR17_RBS0_STRCurrency17
19QTYREJ0 SearchQuantity_Rejected_DOLDLR17_RBS0_STRCurrency17
20QTYWO SearchQuantity_Write_Off_DOLDLR17_RBS0_STRCurrency17
21QTYVOID SearchQuantity_Voided_DOLDLR17_RBS0_STRCurrency17
22FREQ SearchFrequency_INTINT3Integer3
23PRTDATE SearchPrint_Date_DATEDATEDate6
24FREQTYP SearchFrequency_Type_INTINT3Integer3
25VNDITMNUM SearchVendor_Item_Number_STRSTR30_Item_NumberString30
26PURACCACCT SearchPurchase_Accruals_Account_Index_LILI_14Long Integer14
27ACCTPAYACCACCT SearchAccounts_Payable_Accrual_Account_Index_LILI_14Long Integer14
28PURACCT SearchPurchases_Account_Index_LILI_14Long Integer14
29ACCTPAYACCT SearchAccounts_Payable_Account_Index_LILI_14Long Integer14
30EXPUNTCST SearchExpected_Unit_Cost_DOLPO_Unit_Cost_VCCurrency (Variable)23
31Expected_Unit_Cost_DOL SearchTemp_Expected_Unit_Cost_DOLDLR17_RBS0_STR$Currency17
32ACTUNTCST SearchActual_Unit_Cost_DOLPO_Unit_Cost_VCCurrency (Variable)23
33Temp_Actual_Unit_Cost_DO SearchTemp_Actual_Unit_Cost_DOLDLR17_RBS0_STR$Currency17
34ITMTYPE SearchItem_Type_DDLItem_Type_DDLInteger0
35AMTINV SearchAmount_Invoiced_DOLDLR17_RBS0_STR$Currency17
36DATEREQ SearchDate_Requested_DATEDATEDate6
37DATEPROM SearchDate_Promised_DATEDATEDate6
38NOTE SearchNote_Index_DOLDLR14Currency14
39LOCLINSEQ SearchLocation_Line_Sequence_DOLDLR17_RBS0_STRCurrency17
40PriceGroup SearchPrice GroupSTR10_LBAUString10

Leave a Reply

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