PO_OPEN_HDR_File (PO20201)

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

Product: WennSoft Products (131)
Series: Purchasing

Display Name: PO_OPEN_HDR_File
Physical Name: PO20201
Technical Name: PO_OPEN_HDR_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PURORDNUM SearchPurchase_Order_Number_STRSTR17_LBAUString17
2PONUMWRK SearchPurchase_Order_Number_WORK_STRSTR20_LBAUString20
3BACHNUMB SearchBatch NumberSTR15_LBAUString15
4BCHSOURC SearchBatch SourceSTR15String15
5PURORDLINSEQ SearchPurchase_Order_Line_Sequence_DOLDLR17_RBS0_STRCurrency17
6DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency19
7FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
8DTECHG SearchDate_ChangedDATEDate6
9POTMP SearchPO_TempSTR1String1
10TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
11VNDID SearchVendor_ID_STRSTR15_Vendor_IDString15
12PAYMNTTRMID SearchPayment_Terms_ID_STRSTR20_Payment_Terms_IDString20
13SHPTOID SearchShipment_To_ID_STRSTR20_LBAUString20
14SHIPMTHID SearchShipping_Method_ID_STRSTR20_LBAUString20
15DELTOID SearchDelivery_To_ID_STRSTR20_LBAUString20
16ORDBY SearchOrdered_By_STRSTR15_LBUString15
17PURORDDAT SearchPurchase_Order_Date_DATEDATEDate6
18PURORDTYP SearchPurchase_Order_Type_DDLDDL_Purchase_Order_TypeInteger0
19SLSTAXEXEMPSTAT SearchSales_Tax_Exemption_Status_CBCB_Sales_Tax_Exemption_StatusBoolean0
20COMMID SearchComment_ID_STRSTR10_LBUString10
21CONFIRMSTAT SearchConfirmation_Status_CBCB_Confirmation_StatusBoolean0
22ACKNOWSTAT SearchAcknowledgement_Status_CBCB_Acknowledgement_StatusBoolean0
23SUPPRICSTAT SearchSuppress_Prices_Status_CBCB_Suppress_Price_PrintBoolean0
24USRDEFFLD1 SearchUser_Defined_Field_1_STRSTR15String15
25USRDEFFLD2 SearchUser_Defined_Field_2_STRSTR15String15
26USRDEFFLD3 SearchUser_Defined_Field_3_STRSTR15String15
27USRDEFFLD4 SearchUser_Defined_Field_4_STRSTR15String15
28NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PO_OPEN_HDR_File'].NOTEINDX AS 'PO_OPEN_HDR_File-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PO20201 AS ['PO_OPEN_HDR_File']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PO_OPEN_HDR_File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
29VADCDTRO SearchVendor Address Code - Remit ToSTR15_Address_CodeString15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['PO_OPEN_HDR_File'].VADCDTRO AS 'PO_OPEN_HDR_File-Vendor Address Code - Remit To'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       PO20201 AS ['PO_OPEN_HDR_File']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['PO_OPEN_HDR_File'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
              AND
                     ['PO_OPEN_HDR_File'].VENDORID = ['PM Address MSTR'].VENDORID
30REQNUMWRK SearchRequisition_Number_WORK_STRSTR20_LBAU_REQString20
31POFCAMOUNT SearchPO_FC_Amount_DOLDLR19_RBS0_STR$Currency19
32POEXCHANERATE SearchPO_Exchange_RateDLR14_Exchange_RateCurrency (Variable)14
33CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PO_OPEN_HDR_File'].CURNCYID AS 'PO_OPEN_HDR_File-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PO20201 AS ['PO_OPEN_HDR_File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PO_OPEN_HDR_File'].CURNCYID = ['Currency Setup'].CURNCYID
34POREVISEDFREIGHT SearchPO_Revised_Freight_Amount_DOLDLR19_RBSO_STR$Currency19
35POREVTAX SearchPO_Revised_Tax_Amount_DOLDLR19_RBSO_STR$Currency19
36POREVEXPTOTAL SearchPO_Revised_Expected_TotalDLR19_RBSO_STR$Currency19
37LCEXPTOTAL SearchLC_Expected_Total_DOLDLR17_RBS0_STR$Currency17
38APPROVL SearchApprovalCB_ApprovalBoolean0
39APRVLUSERID SearchApproval User IDSTR15_User_IDString15
40APPRVLDT SearchApproval DateDATEDate6
41Approval_Time SearchApproval TimeTM6Time6
42FCFreight SearchPO_FC_Freight_Amount_DOLDLR19_RBS0_STR$Currency19
43fctax SearchPO_FC_Tax_Amount_DOLDLR19_RBS0_STR$Currency19
44PO_FC_Revised_Amount_DOL SearchPO_FC_Revised_Amount_DOLDLR19_RBSO_STR$Currency19
45PO_FC_Revised_Expected SearchPO_FC_Revised_Expected_Unit_Cost_DOLPO_Unit_Cost_VCCurrency (Variable)23
46PO_FC_Revised_Freight_Am SearchPO_FC_Revised_Freight_Amount_DOLDLR19_RBSO_STR$Currency19
47PO_FC_Revised_Tax_Amount SearchPO_FC_Revised_Tax_Amount_DOLDLR19_RBSO_STR$Currency19
48EXCHDATE SearchExchange DateDT_DateDate6
49TIME1 SearchTimeTM6Time6
50RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['PO_OPEN_HDR_File'].RATETPID AS 'PO_OPEN_HDR_File-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       PO20201 AS ['PO_OPEN_HDR_File']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['PO_OPEN_HDR_File'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
51EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['PO_OPEN_HDR_File'].EXGTBLID AS 'PO_OPEN_HDR_File-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       PO20201 AS ['PO_OPEN_HDR_File']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['PO_OPEN_HDR_File'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID

Leave a Reply

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