Posting Definitions Master Dup (SY00500)

azurecurveProductsMicrosoft Dynamics GP (0)CompanyPosting Definitions Master Dup (SY00500)

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

Product: Project Accounting (258)
Series: Company

Display Name: PA Report Posting Definitions Master
Physical Name: SY00500
Technical Name: Batch_Headers_DUP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1GLPOSTDT SearchGL Posting DateDTDate48
2BCHSOURC SearchBatch SourceSTR15String1615
3BACHNUMB SearchBatch NumberSTR15_LBAUString1615
4SERIES SearchSeriesDDL_SeriesInteger20
5MKDTOPST SearchMarked To PostCBBoolean20
6NUMOFTRX SearchNumber Of TRXLI6_U0Long Integer46
7RECPSTGS SearchRecurring PostingsINT3_U0Integer23
8DELBACH SearchDelete BatchYNBoolean20
9MSCBDINC SearchMisc Batch Days To IncrementINT3_U0Integer23
10BACHFREQ SearchBatch FrequencyDDL_FrequencyInteger20
11RCLPSTDT SearchRecurring Last Posted DateDTDate48
12NOFPSTGS SearchNumber of PostingsINT3_S0Integer23
13BCHCOMNT SearchBatch CommentSTR60String6260
14BRKDNALL SearchBreak Down AllocCB_Break_Down_AllocBoolean20
15CHKSPRTD SearchChecks PrintedTrue/FalseBoolean20
16RVRSBACH SearchReverse BatchCBBoolean20
17USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

SELECT
       ['PA Report Posting Definitions Master'].CURNCYID AS 'PA Report Posting Definitions Master-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       SY00500 AS ['PA Report Posting Definitions Master']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PA Report Posting Definitions Master'].CURNCYID = ['Currency Setup'].CURNCYID
30BCHSTTUS SearchBatch StatusINTInteger20
31CNTRLTRX SearchControl TRX CountLI6_U0Long Integer46
32CNTRLTOT SearchControl TotalDLR19_RBS0_UTR$Currency1019
33PETRXCNT SearchPosting Error TRX CountINT5_U0Integer25
34APPROVL SearchApprovalCB_ApprovalBoolean20
35APPRVLDT SearchApproval DateDATEDate46
36APRVLUSERID SearchApproval User IDSTR15_User_IDString1615
37ORIGIN SearchOriginDDLInteger20
38ERRSTATE SearchError StateLong IntLong Integer48
39GLBCHVAL SearchGL Batch ValidML_GL_Batch_ValidLong Integer40
40Computer_Check_Doc_Date SearchComputer Check Document DateDTDate48
41Sort_Checks_By SearchSort Checks ByINTInteger20
42SEPRMTNC SearchSeperate RemittanceCB_Seperate_RemittanceBoolean20
43REPRNTED SearchReprintedINT2Integer22
44CHKFRMTS SearchCheck FormatsDDL_Check_FormatsInteger20
45TRXSORCE SearchTRX SourceSTR13String1413
46PmtMethod SearchPayment MethodGBInteger20
47EFTFileFormat SearchEFT File FormatDDL_EFTFileFormatInteger20
48Workflow_Approval_Status SearchWorkflow Approval StatusDDL_WorkflowApprovalStatusInteger20
49Workflow_Priority SearchWorkflow PriorityDDL_WorkflowPriorityInteger20
50Workflow_Status SearchWorkflow StatusWorkflow StatusInteger20
51TIME1 SearchTimeTM6Time46
52ClearRecAmts SearchClear Recurring AmountsCBBoolean20
53PurchasingPrepaymentBch SearchPurchasing Prepayment BatchCB_PurchasingPrepaymentBatchBoolean20
54CARDNAME SearchCard NameSTR15_Card_NameString1615
55DEX_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.

azurecurveProductsMicrosoft Dynamics GP (0)CompanyPosting Definitions Master Dup (SY00500)

Leave a Reply

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