PA Posting Definitions Master History (PA30000)

azurecurveProductsProject Accounting (258)ProjectPA Posting Definitions Master History (PA30000)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Posting Definitions Master History
Physical Name: PA30000
Technical Name: PA_Batch_HIST

Group Display Name: PA Posting Definitions Master History
Group Technical Name: PA Posting Definitions Master History

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1GLPOSTDT SearchGL Posting DateDTDate48
2INTERID SearchIntercompany IDSTR5_IC_IDString65
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['PA Posting Definitions Master History'].INTERID AS 'PA Posting Definitions Master History-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       PA30000 AS ['PA Posting Definitions Master History']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['PA Posting Definitions Master History'].INTERID = ['Company Master'].INTERID
3BCHSOURC SearchBatch SourceSTR15String1615
4HSTYEAR SearchHistory YearINT4_S0Integer24
5JRNENTRY SearchJournal EntryLI8_U0Long Integer48
6BACHNUMB SearchBatch NumberSTR15_LBAUString1615
7SERIES SearchSeriesDDL_SeriesInteger20
8MKDTOPST SearchMarked To PostCBBoolean20
9NUMOFTRX SearchNumber Of TRXLI6_U0Long Integer46
10RECPSTGS SearchRecurring PostingsINT3_U0Integer23
11DELBACH SearchDelete BatchYNBoolean20
12MSCBDINC SearchMisc Batch Days To IncrementINT3_U0Integer23
13BACHFREQ SearchBatch FrequencyDDL_FrequencyInteger20
14RCLPSTDT SearchRecurring Last Posted DateDTDate48
15NOFPSTGS SearchNumber of PostingsINT3_S0Integer23
16BCHCOMNT SearchBatch CommentSTR60String6260
17BRKDNALL SearchBreak Down AllocCB_Break_Down_AllocBoolean20
18CHKSPRTD SearchChecks PrintedTrue/FalseBoolean20
19RVRSBACH SearchReverse BatchCBBoolean20
20USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PA Posting Definitions Master History'].USERID AS 'PA Posting Definitions Master History-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PA30000 AS ['PA Posting Definitions Master History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PA Posting Definitions Master History'].USERID = ['Users Master'].USERID
21CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['PA Posting Definitions Master History'].CHEKBKID AS 'PA Posting Definitions Master History-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       PA30000 AS ['PA Posting Definitions Master History']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PA Posting Definitions Master History'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
22BCHTOTAL SearchBatch TotalDLR19_RBS0_STR$Currency1019
23BCHEMSG1 SearchBatch Error Messages 1ML_Batch_Error_Messages_1Long Integer40
24BCHEMSG2 SearchBatch Error Messages 2ML_Batch_Error_Messages_2Long Integer40
25BACHDATE SearchBatch DateDTDate48
26BCHSTRG1 SearchBatch String 1STR20String2220
27BCHSTRG2 SearchBatch String 2STR20String2220
28POSTTOGL SearchPost To GLCBBoolean20
29MODIFDT SearchModified DateDTDate48
30CREATDDT SearchCreated DateDTDate48
31NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PA Posting Definitions Master History'].NOTEINDX AS 'PA Posting Definitions Master History-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PA30000 AS ['PA Posting Definitions Master History']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PA Posting Definitions Master History'].NOTEINDX = ['Record Notes Master'].NOTEINDX
32CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PA Posting Definitions Master History'].CURNCYID AS 'PA Posting Definitions Master History-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PA30000 AS ['PA Posting Definitions Master History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PA Posting Definitions Master History'].CURNCYID = ['Currency Setup'].CURNCYID
33BCHSTTUS SearchBatch StatusINTInteger20
34CNTRLTRX SearchControl TRX CountLI6_U0Long Integer46
35CNTRLTOT SearchControl TotalDLR19_RBS0_UTR$Currency1019
36PETRXCNT SearchPosting Error TRX CountINT5_U0Integer25
37APPROVL SearchApprovalCB_ApprovalBoolean20
38APPRVLDT SearchApproval DateDATEDate46
39APRVLUSERID SearchApproval User IDSTR15_User_IDString1615
40ORIGIN SearchOriginDDLInteger20
41DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsProject Accounting (258)ProjectPA Posting Definitions Master History (PA30000)

Leave a Reply

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