PA Miscellaneous Log Header File (PA10200)

azurecurveProductsProject Accounting (258)ProjectPA Miscellaneous Log Header File (PA10200)

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

Product: Project Accounting (258)
Series:

Display Name: PA Miscellaneous Log Header File
Physical Name: PA10200
Technical Name: PA_Miscellaneous_Log_WORK_HDR

Group Display Name: PA Miscellaneous Transactions
Group Technical Name: PA Miscellaneous Transactions

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PSMISCLTRXTYPE SearchPA Miscellaneous Log TRX TypeIntegerPA_DDL_ML_Trx_Typ0
2PAMISCLDOCNO SearchPA Miscellaneous Log No.StringSTR17_LBAU17
3PADOCDT SearchPA Document DateDatePA_Date8
4PAYR SearchPA YearIntegerINT44
5USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PA Miscellaneous Log Header File'].USERID AS 'PA Miscellaneous Log Header File-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PA10200 AS ['PA Miscellaneous Log Header File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PA Miscellaneous Log Header File'].USERID = ['Users Master'].USERID
6BACHNUMB SearchBatch NumberStringSTR15_LBAU15
7BCHSOURC SearchBatch SourceStringSTR1515
8TRXSORCE SearchTRX SourceStringSTR1313
9PAREFNO SearchPA Reference Document No.StringSTR17_LBAU17
10PSMISCID SearchPA Miscellaneous IDStringSTR15_Equipment_ID15
11PAREPD SearchPA Reporting PeriodIntegerINT33
12PAREPDT SearchPA Reporting DateDatePA_Date8
13PAPeriodEndDate SearchPA Period End DateDateDATE6
14PACOMM SearchPA CommentStringSTR5050
15PAUD1 SearchPA User Defined 1StringSTR2020
16PAUD2 SearchPA User Defined 2StringSTR2020
17PATQTY SearchPA Total QuantityCurrencyDLR17_QTY_RBS0_UTR17
18PAtotcosts SearchPA Total CostsCurrencyPA_DLR17_RBS0_STR$17
19PATACRV SearchPA Total Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
20NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PA Miscellaneous Log Header File'].NOTEINDX AS 'PA Miscellaneous Log Header File-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PA10200 AS ['PA Miscellaneous Log Header File']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PA Miscellaneous Log Header File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
21PAreptsuff SearchPA Reporting SuffixStringPA_STR55
22PAPD SearchPA Post DateDatePA_Date8
23LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
24PAML_HDR_Errors SearchPA ML HDR ErrorsLong IntegerPA_ML_ML_Header_Errors0
25PAML_Dist_Errors SearchPA ML Distribution ErrorsLong IntegerPA_ML_Distribution_Error0
26CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PA Miscellaneous Log Header File'].CURNCYID AS 'PA Miscellaneous Log Header File-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PA10200 AS ['PA Miscellaneous Log Header File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PA Miscellaneous Log Header File'].CURNCYID = ['Currency Setup'].CURNCYID
27CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PA Miscellaneous Log Header File'].CURRNIDX AS 'PA Miscellaneous Log Header File-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       PA10200 AS ['PA Miscellaneous Log Header File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PA Miscellaneous Log Header File'].CURRNIDX = ['Currency Setup'].CURRNIDX
28RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['PA Miscellaneous Log Header File'].RATETPID AS 'PA Miscellaneous Log Header File-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       PA10200 AS ['PA Miscellaneous Log Header File']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['PA Miscellaneous Log Header File'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
29EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['PA Miscellaneous Log Header File'].EXGTBLID AS 'PA Miscellaneous Log Header File-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       PA10200 AS ['PA Miscellaneous Log Header File']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['PA Miscellaneous Log Header File'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
30XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
31EXCHDATE SearchExchange DateDateDT_Date6
32TIME1 SearchTimeTimeTM66
33RTCLCMTD SearchRate Calculation MethodIntegerGB0
34DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
35MCTRXSTT SearchMC Transaction StateIntegerINT11
36PAORIGTOTCOSTS SearchPA Originating Total CostsCurrencyDLR17_RBS0_UTR$17
37PAORIACCRREV SearchPA Originating Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
38Correcting_Trx_Type SearchCorrecting Trx TypeIntegerINT0
39PAORIGINLDOCNUM SearchPA Original Document NumberStringSTR17_LBAU17
40CREATDDT SearchCreated DateDateDT8
41CRUSRID SearchCreated User IDStringSTR15_User_ID15
azurecurveProductsProject Accounting (258)ProjectPA Miscellaneous Log Header File (PA10200)

Leave a Reply

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