PO_WORK_LINE_File (PO10202)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PO10202

Product: WennSoft Products (131)
Series: Purchasing

Display Name: PO_WORK_LINE_File
Physical Name: PO10202
Technical Name: PO_WORK_LINE_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PURORDTYP SearchPurchase_Order_Type_DDLDDL_Purchase_Order_TypeInteger0
2Cost_Per_Unit_UFM_DOL SearchCost_Per_Unit_UFM_DOLDLR17_RBS0_STR$Currency17
3Cost_Per_Unit_UFM_DOL_FC SearchCost_Per_Unit_UFM_DOL_FCDLR17_RBS0_STR$Currency17
4PURORDNUM SearchPurchase_Order_Number_STRSTR17_LBAUString17
5PURORDLINSEQ SearchPurchase_Order_Line_Sequence_DOLDLR17_RBS0_STRCurrency17
6DELTOID SearchDelivery_To_ID_STRSTR20_LBAUString20
7ITMNUM SearchItem_Number_STRSTR30_Item_NumberString30
8LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['PO_WORK_LINE_File'].LOCNCODE AS 'PO_WORK_LINE_File-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       PO10202 AS ['PO_WORK_LINE_File']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['PO_WORK_LINE_File'].LOCNCODE = ['Site Setup'].LOCNCODE
9BLC SearchBackout Location CodeSTR10_Location_CodeString10
10BVID SearchBackout Vendor IDSTR_15_Vendor_IDString15
11ITMDESC SearchItem_Description_STRSTR50String50
12UOM SearchUnit_Of_Measure_STRU_Of_MString8
13FFQ SearchFactor_For_QuantityDLR19_QTY_RBS0_STRCurrency19
14POLT SearchPurchase_Order_Line_Total_DOLDLR17_RBS0_UTR$Currency17
15SLSTAXEXEMPSTAT SearchSales_Tax_Exemption_Status_CBCB_Sales_Tax_Exemption_StatusBoolean0
16TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
17FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
18REQNUMWRK SearchRequisition_Number_WORK_STRSTR20_LBAU_REQString20
19QYORD SearchQuantity_Ordered_DOLDLR17_RBS0_STRCurrency17
20QTYREQ SearchQuantity_Requisitioned_DOLDLR17_RBS0_UTR$Currency17
21QTYREL SearchQuantity_Released_DOLDLR17_RBS0_STRCurrency17
22QTYINV SearchQuantity_Invoiced_DOLDLR17_RBS0_STRCurrency17
23QTYREC SearchQuantity_Received_DOLDLR17_RBS0_STRCurrency17
24QTYACC SearchQuantity_Accepted_DOLDLR17_RBS0_STRCurrency17
25QTYREJ0 SearchQuantity_Rejected_DOLDLR17_RBS0_STRCurrency17
26QTYWO SearchQuantity_Write_Off_DOLDLR17_RBS0_STRCurrency17
27PRTDATE SearchPrint_Date_DATEDATEDate6
28FREQ SearchFrequency_INTINT3Integer3
29FREQTYP SearchFrequency_Type_INTINT3Integer3
30VNDITMNUM SearchVendor_Item_Number_STRSTR30_Item_NumberString30
31PURACCACCT SearchPurchase_Accruals_Account_Index_LILI_14Long Integer14
32ACCTPAYACCACCT SearchAccounts_Payable_Accrual_Account_Index_LILI_14Long Integer14
33PURACCT SearchPurchases_Account_Index_LILI_14Long Integer14
34Cost_Element SearchCost ElementINT3_RB0_UInteger3
35MISC1 SearchMisc_1_CBCBBoolean0
36EXPUNTCST SearchExpected_Unit_Cost_DOLPO_Unit_Cost_VCCurrency (Variable)23
37ACTUNTCST SearchActual_Unit_Cost_DOLPO_Unit_Cost_VCCurrency (Variable)23
38AMTINV SearchAmount_Invoiced_DOLDLR17_RBS0_STR$Currency17
39ITMTYPE SearchItem_Type_DDLItem_Type_DDLInteger0
40DATEREQ SearchDate_Requested_DATEDATEDate6
41DATEPROM SearchDate_Promised_DATEDATEDate6
42LOCLINSEQ SearchLocation_Line_Sequence_DOLDLR17_RBS0_STRCurrency17
43COMMNTID SearchComment IDSTR15_Comment_IDString15
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['PO_WORK_LINE_File'].COMMNTID AS 'PO_WORK_LINE_File-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       PO10202 AS ['PO_WORK_LINE_File']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['PO_WORK_LINE_File'].COMMNTID = ['Comment Master'].COMMNTID
44CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['PO_WORK_LINE_File'].CUSTNMBR AS 'PO_WORK_LINE_File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       PO10202 AS ['PO_WORK_LINE_File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['PO_WORK_LINE_File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
45NONINVEN SearchNon IVINT1Integer1
46PCBJOBNUMBER SearchPCB_Job_Number_STRSTR10String10
47PCBPNUM SearchPCB_Phase_Number_STRSTR10_JobString10
48PCBTASKNUM SearchPCB_Task_Number_STRSTR10_JobString10
49PCB_Cost_ClassDDL SearchPCB_Cost_Classification_DDLPCB_Cost_Classification_DDLInteger0
50SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString17
51POFCAMOUNT SearchPO_FC_Amount_DOLDLR19_RBS0_STR$Currency19
52POEXCHANERATE SearchPO_Exchange_RateDLR14_Exchange_RateCurrency (Variable)14
53CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PO_WORK_LINE_File'].CURNCYID AS 'PO_WORK_LINE_File-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PO10202 AS ['PO_WORK_LINE_File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PO_WORK_LINE_File'].CURNCYID = ['Currency Setup'].CURNCYID
54LCSCHEDULE SearchLC_Schedule_ID_STRLC_STR15_LBUString15
55LCEXPVALUE SearchLC_Expected_Value_DOLDLR17_RBS0_STR$Currency17
56WS_Job_Number SearchWS Job NumberSTR17_LBAUString17
57Cost_Code_Number_1 SearchCost Code Number:CC_PhaseSTR6_CC_PhaseString6
58Cost_Code_Number_2 SearchCost Code Number:CC_StepSTR6_CC_StepsString6
59Cost_Code_Number_3 SearchCost Code Number:CC_DetailSTR6_CC_DetailString6
60Cost_Code_Number_4 SearchCost Code Number:CC_ComponentSTR6_CC_ComponentString6
61PO_FC_Actual_Unit_Cost_D SearchPO_FC_Actual_Unit_Cost_DOLPO_Unit_Cost_VCCurrency (Variable)23
62PO_FC_Amount_Invoiced SearchPO_FC_Amount_Invoiced_DOLDLR19_RBS0_STR$Currency19
63PO_FC_Expected_Unit_Cost SearchPO_FC_Expected_Unit_Cost_DOLPO_Unit_Cost_VCCurrency (Variable)23
64FCFreight SearchPO_FC_Freight_Amount_DOLDLR19_RBS0_STR$Currency19
65fctax SearchPO_FC_Tax_Amount_DOLDLR19_RBS0_STR$Currency19
66PCB_Job_Line_Sequence SearchPCB_Job_Line_Sequence_DOLSequence_NumberCurrency19
67INTLRSVBOOL1 SearchINTL_RSV_BOOL_1BooleanBoolean0
68INTLRSVBOOL2 SearchINTL_RSV_BOOL_2BooleanBoolean0
69INTLRSVDATE1 SearchINTL_RSV_DATE_1DATEDate6
70INTLRSVDATE2 SearchINTL_RSV_DATE_2DATEDate6
71INTLRSVDOL141 SearchINTL_RSV_DOL14_1DLR14Currency14
72INTLRSVDOL142 SearchINTL_RSV_DOL14_2DLR14Currency14
73INTLRSVINT61 SearchINTL_RSV_INT6_1LI6_S2Long Integer6
74INTLRSVINT62 SearchINTL_RSV_INT6_2LI6_S2Long Integer6
75INTLRSVSTR301 SearchINTL_RSV_STR30_1STR30String30
76INTLRSVSTR302 SearchINTL_RSV_STR30_2STR30String30
77Requisition_Posted SearchRequisition_PostedBooleanBoolean0
78PriceGroup SearchPrice GroupSTR10_LBAUString10

Leave a Reply

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