Receivings_WORK_HDR_File (PO10301)

azurecurveProductsWennSoft Products (131)PurchasingReceivings_WORK_HDR_File (PO10301)

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

Product: WennSoft Products (131)
Series: Purchasing

Display Name: Receivings_WORK_HDR_File
Physical Name: PO10301
Technical Name: Receivings_WORK_HDR_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1RECNUM SearchReceivings_Number_STRSTR17_LBAUString17
2Receivings_Type_DDL SearchReceivings_Type_DDLReceivings_Type_DDLInteger0
3BACHNUMB SearchBatch NumberSTR15_LBAUString15
4BCHSOURC SearchBatch SourceSTR15String15
5RECLINSEQ SearchReceivings_Line_Sequence_DOLDLR17_RBS0_STRCurrency17
6DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency19
7FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
8TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
9VNDID SearchVendor_ID_STRSTR15_Vendor_IDString15
10DLC SearchDefault Location CodeSTR10_Location_CodeString10
11DDN SearchDefault Document NumberSTR20_Document_NumberString20
12RECBY SearchReceived_By_STRSTR15_LBUString15
13AMTMATCH SearchAmount_Matched_DOLDLR17_RBS0_STR$Currency17
14GRNDATE SearchReceivings_Date_DATEDATEDate6
15NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Receivings_WORK_HDR_File'].NOTEINDX AS 'Receivings_WORK_HDR_File-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PO10301 AS ['Receivings_WORK_HDR_File']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Receivings_WORK_HDR_File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
16LCACTTOTAL SearchLC_Actual_Total_DOLDLR17_RBS0_STR$Currency17
17CRTDDSTR SearchCreated DistributionsCBBoolean0
18Approved_By_STR SearchApproved_By_STRSTR15_User_IDString15
19Expense_Claim_CB SearchExpense_Claim_CBCBBoolean0
20Intellisol_Reserved_10 SearchIntellisol_Reserved_10STR10String10
21CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Receivings_WORK_HDR_File'].CURNCYID AS 'Receivings_WORK_HDR_File-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PO10301 AS ['Receivings_WORK_HDR_File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Receivings_WORK_HDR_File'].CURNCYID = ['Currency Setup'].CURNCYID
22POEXCHANERATE SearchPO_Exchange_RateDLR14_Exchange_RateCurrency (Variable)14
23POFCAMOUNT SearchPO_FC_Amount_DOLDLR19_RBS0_STR$Currency19
24FCFreight SearchPO_FC_Freight_Amount_DOLDLR19_RBS0_STR$Currency19
25fctax SearchPO_FC_Tax_Amount_DOLDLR19_RBS0_STR$Currency19
26EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['Receivings_WORK_HDR_File'].EXGTBLID AS 'Receivings_WORK_HDR_File-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       PO10301 AS ['Receivings_WORK_HDR_File']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Receivings_WORK_HDR_File'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
27RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['Receivings_WORK_HDR_File'].RATETPID AS 'Receivings_WORK_HDR_File-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       PO10301 AS ['Receivings_WORK_HDR_File']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Receivings_WORK_HDR_File'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
28EXCHDATE SearchExchange DateDT_DateDate6
29TIME1 SearchTimeTM6Time6
azurecurveProductsWennSoft Products (131)PurchasingReceivings_WORK_HDR_File (PO10301)

Leave a Reply

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