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: Microsoft Dynamics GP (0)
Series: Company

Display Name: Posting Definitions Master
Physical Name: SY00500
Technical Name: Batch_Headers

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1GLPOSTDT SearchGL Posting DateDateDT8
2BCHSOURC SearchBatch SourceStringSTR1515
3BACHNUMB SearchBatch NumberStringSTR15_LBAU15
4SERIES SearchSeriesIntegerDDL_Series0
5MKDTOPST SearchMarked To PostBooleanCB0
6NUMOFTRX SearchNumber Of TRXLong IntegerLI6_U06
7RECPSTGS SearchRecurring PostingsIntegerINT3_U03
8DELBACH SearchDelete BatchBooleanYN0
9MSCBDINC SearchMisc Batch Days To IncrementIntegerINT3_U03
10BACHFREQ SearchBatch FrequencyIntegerDDL_Frequency0
11RCLPSTDT SearchRecurring Last Posted DateDateDT8
12NOFPSTGS SearchNumber of PostingsIntegerINT3_S03
13BCHCOMNT SearchBatch CommentStringSTR6060
14BRKDNALL SearchBreak Down AllocBooleanCB_Break_Down_Alloc0
15CHKSPRTD SearchChecks PrintedBooleanTrue/False0
16RVRSBACH SearchReverse BatchBooleanCB0
17USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

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

Click to show/hide

SELECT
       ['Posting Definitions Master'].CHEKBKID AS 'Posting Definitions Master-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       SY00500 AS ['Posting Definitions Master']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Posting Definitions Master'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
19BCHTOTAL SearchBatch TotalCurrencyDLR19_RBS0_STR$19
20BCHEMSG1 SearchBatch Error Messages 1Long IntegerML_Batch_Error_Messages_10
21BCHEMSG2 SearchBatch Error Messages 2Long IntegerML_Batch_Error_Messages_20
22BACHDATE SearchBatch DateDateDT8
23BCHSTRG1 SearchBatch String 1StringSTR2020
24BCHSTRG2 SearchBatch String 2StringSTR2020
25POSTTOGL SearchPost To GLBooleanCB0
26MODIFDT SearchModified DateDateDT8
27CREATDDT SearchCreated DateDateDT8
28NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

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

Click to show/hide

SELECT
       ['Posting Definitions Master'].CURNCYID AS 'Posting Definitions Master-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       SY00500 AS ['Posting Definitions Master']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Posting Definitions Master'].CURNCYID = ['Currency Setup'].CURNCYID
30BCHSTTUS SearchBatch StatusIntegerINT0
31CNTRLTRX SearchControl TRX CountLong IntegerLI6_U06
32CNTRLTOT SearchControl TotalCurrencyDLR19_RBS0_UTR$19
33PETRXCNT SearchPosting Error TRX CountIntegerINT5_U05
34APPROVL SearchApprovalBooleanCB_Approval0
35APPRVLDT SearchApproval DateDateDATE6
36APRVLUSERID SearchApproval User IDStringSTR15_User_ID15
The key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Posting Definitions Master'].APRVLUSERID AS 'Posting Definitions Master-Approval User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SY00500 AS ['Posting Definitions Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Posting Definitions Master'].APRVLUSERID = ['Users Master'].USERID
37ORIGIN SearchOriginIntegerDDL0
38ERRSTATE SearchError StateLong IntegerLong Int8
39GLBCHVAL SearchGL Batch ValidLong IntegerML_GL_Batch_Valid0
40Computer_Check_Doc_Date SearchComputer Check Document DateDateDT8
41Sort_Checks_By SearchSort Checks ByIntegerINT0
42SEPRMTNC SearchSeperate RemittanceBooleanCB_Seperate_Remittance0
43REPRNTED SearchReprintedIntegerINT22
44CHKFRMTS SearchCheck FormatsIntegerDDL_Check_Formats0
45TRXSORCE SearchTRX SourceStringSTR1313
46PmtMethod SearchPayment MethodIntegerGB0
47EFTFileFormat SearchEFT File FormatIntegerDDL_EFTFileFormat0
48Workflow_Approval_Status SearchWorkflow Approval StatusIntegerDDL_WorkflowApprovalStatus0
49Workflow_Priority SearchWorkflow PriorityIntegerDDL_WorkflowPriority0
50Workflow_Status SearchWorkflow StatusIntegerWorkflow Status0
51TIME1 SearchTimeTimeTM66
52ClearRecAmts SearchClear Recurring AmountsBooleanCB0
53PurchasingPrepaymentBch SearchPurchasing Prepayment BatchBooleanCB_PurchasingPrepaymentBatch0
54CARDNAME SearchCard NameStringSTR15_Card_Name15
55UseLastDayOfMonth SearchUse last day of the monthBooleanUseLastDayoftheMonth0
56Post_Deposit SearchPost DepositIntegerDDL_Post_Deposit0
azurecurveProductsMicrosoft Dynamics GP (0)CompanyPosting Definitions Master Dup (SY00500)

Leave a Reply

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