PO_OPEN_LINE_Change_Order_File (PO40202)

azurecurveProductsWennSoft Products (131)PurchasingPO_OPEN_LINE_Change_Order_File (PO40202)

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_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PURORDTYP SearchPurchase_Order_Type_DDLDDL_Purchase_Order_TypeInteger20
2INTLRSVBOOL1 SearchINTL_RSV_BOOL_1BooleanBoolean20
3INTLRSVBOOL2 SearchINTL_RSV_BOOL_2BooleanBoolean20
4INTLRSVDATE1 SearchINTL_RSV_DATE_1DATEDate46
5INTLRSVDATE2 SearchINTL_RSV_DATE_2DATEDate46
6INTLRSVDOL141 SearchINTL_RSV_DOL14_1DLR14Currency1014
7INTLRSVDOL142 SearchINTL_RSV_DOL14_2DLR14Currency1014
8INTLRSVINT61 SearchINTL_RSV_INT6_1LI6_S2Long Integer46
9INTLRSVINT62 SearchINTL_RSV_INT6_2LI6_S2Long Integer46
10INTLRSVSTR301 SearchINTL_RSV_STR30_1STR30String3230
11INTLRSVSTR302 SearchINTL_RSV_STR30_2STR30String3230
12REQNOSTR SearchRequisition_Number_STRSTR17_LBAUString1817
13PONUMWRK SearchPurchase_Order_Number_WORK_STRSTR20_LBAUString2220
14PURORDLINSEQ SearchPurchase_Order_Line_Sequence_DOLDLR17_RBS0_STRCurrency1017
15DELTOID SearchDelivery_To_ID_STRSTR20_LBAUString2220
16ITMNUM SearchItem_Number_STRSTR30_Item_NumberString3230
17POLT SearchPurchase_Order_Line_Total_DOLDLR17_RBS0_UTR$Currency1017
18SLSTAXEXEMPSTAT SearchSales_Tax_Exemption_Status_CBCB_Sales_Tax_Exemption_StatusBoolean20
19TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
20FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
21LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
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'].LOCNCODE
22ITMDESC SearchItem_Description_STRSTR50String5250
23UOM SearchUnit_Of_Measure_STRU_Of_MString108
24FFQ SearchFactor_For_QuantityDLR19_QTY_RBS0_STRCurrency1019
25QYORD SearchQuantity_Ordered_DOLDLR17_RBS0_STRCurrency1017
26QTYREQ SearchQuantity_Requisitioned_DOLDLR17_RBS0_UTR$Currency1017
27QTYREL SearchQuantity_Released_DOLDLR17_RBS0_STRCurrency1017
28QTYINV SearchQuantity_Invoiced_DOLDLR17_RBS0_STRCurrency1017
29QTYREC SearchQuantity_Received_DOLDLR17_RBS0_STRCurrency1017
30QTYACC SearchQuantity_Accepted_DOLDLR17_RBS0_STRCurrency1017
31QTYREJ0 SearchQuantity_Rejected_DOLDLR17_RBS0_STRCurrency1017
32QTYWO SearchQuantity_Write_Off_DOLDLR17_RBS0_STRCurrency1017
33PRTDATE SearchPrint_Date_DATEDATEDate46
34FREQ SearchFrequency_INTINT3Integer23
35FREQTYP SearchFrequency_Type_INTINT3Integer23
36VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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'].VENDORID
37VNDITMNUM SearchVendor_Item_Number_STRSTR30_Item_NumberString3230
38PURACCACCT SearchPurchase_Accruals_Account_Index_LILI_14Long Integer414
39POLINEITEMNUMBER SearchPO_Line_Item_Number_INTLI_14Long Integer414
40PURACCT SearchPurchases_Account_Index_LILI_14Long Integer414
41ACCTPAYACCT SearchAccounts_Payable_Account_Index_LILI_14Long Integer414
42EXPUNTCST SearchExpected_Unit_Cost_DOLPO_Unit_Cost_VCCurrency (Variable)1223
43ACTUNTCST SearchActual_Unit_Cost_DOLPO_Unit_Cost_VCCurrency (Variable)1223
44AMTINV SearchAmount_Invoiced_DOLDLR17_RBS0_STR$Currency1017
45ITMTYPE SearchItem_Type_DDLItem_Type_DDLInteger20
46DATEREQ SearchDate_Requested_DATEDATEDate46
47DATEPROM SearchDate_Promised_DATEDATEDate46
48NOTE SearchNote_Index_DOLDLR14Currency1014
49LOCLINSEQ SearchLocation_Line_Sequence_DOLDLR17_RBS0_STRCurrency1017
50COMMNTID SearchComment IDSTR15_Comment_IDString1615
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'].COMMNTID
51CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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'].CUSTNMBR
52NONINVEN SearchNon IVINT1Integer21
53PCBJOBNUMBER SearchPCB_Job_Number_STRSTR10String1210
54PCBPNUM SearchPCB_Phase_Number_STRSTR10_JobString1210
55PCBTASKNUM SearchPCB_Task_Number_STRSTR10_JobString1210
56SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString2217
57POFCAMOUNT SearchPO_FC_Amount_DOLDLR19_RBS0_STR$Currency1019
58POEXCHANERATE SearchPO_Exchange_RateDLR14_Exchange_RateCurrency (Variable)1014
59CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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'].CURNCYID
60POREVEXPQTY SearchPO_Revised_Expected_QTYDLR19_QTY_RBS0_UTRCurrency1019
61POREXPUNITCOST SearchPO_Revised_Expected_Unit_CostPO_Unit_Cost_VCCurrency (Variable)1223
62POREVEXPTOTAL SearchPO_Revised_Expected_TotalDLR19_RBSO_STR$Currency1019
63POREVISEDFREIGHT SearchPO_Revised_Freight_Amount_DOLDLR19_RBSO_STR$Currency1019
64POREVTAX SearchPO_Revised_Tax_Amount_DOLDLR19_RBSO_STR$Currency1019
65DATE1 SearchDateDT6Date46
66TIME1 SearchTimeTM6Time46
67USERID SearchUser IDSTR15_User_IDString1615
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'].USERID
68PriceGroup SearchPrice GroupSTR10_LBAUString1210
azurecurveProductsWennSoft Products (131)PurchasingPO_OPEN_LINE_Change_Order_File (PO40202)

Leave a Reply

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