JC_Production_Batch_Headers (JC01301)

azurecurveProductsWennSoft Products (131)3rd PartyJC_Production_Batch_Headers (JC01301)

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

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: JC_Production_Batch_Headers
Physical Name: JC01301
Technical Name: JC_Production_Batch_Headers

Group Display Name: Job Cost
Group Technical Name: Job Cost

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1GLPOSTDT SearchGL Posting DateDTDate8
2BCHSOURC SearchBatch SourceSTR15String15
3BACHNUMB SearchBatch NumberSTR15_LBAUString15
4SERIES SearchSeriesDDL_SeriesInteger0
5MKDTOPST SearchMarked To PostCBBoolean0
6NUMOFTRX SearchNumber Of TRXLI6_U0Long Integer6
7RECPSTGS SearchRecurring PostingsINT3_U0Integer3
8DELBACH SearchDelete BatchYNBoolean0
9MSCBDINC SearchMisc Batch Days To IncrementINT3_U0Integer3
10BACHFREQ SearchBatch FrequencyDDL_FrequencyInteger0
11RCLPSTDT SearchRecurring Last Posted DateDTDate8
12NOFPSTGS SearchNumber of PostingsINT3_S0Integer3
13BCHCOMNT SearchBatch CommentSTR60String60
14BRKDNALL SearchBreak Down AllocCB_Break_Down_AllocBoolean0
15CHKSPRTD SearchChecks PrintedTrue/FalseBoolean0
16RVRSBACH SearchReverse BatchCBBoolean0
17USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

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

Click to show/hide

SELECT
       ['JC_Production_Batch_Headers'].CHEKBKID AS 'JC_Production_Batch_Headers-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       JC01301 AS ['JC_Production_Batch_Headers']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['JC_Production_Batch_Headers'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
19BCHTOTAL SearchBatch TotalDLR19_RBS0_STR$Currency19
20BCHEMSG1 SearchBatch Error Messages 1ML_Batch_Error_Messages_1Long Integer0
21BCHEMSG2 SearchBatch Error Messages 2ML_Batch_Error_Messages_2Long Integer0
22BACHDATE SearchBatch DateDTDate8
23BCHSTRG1 SearchBatch String 1STR20String20
24BCHSTRG2 SearchBatch String 2STR20String20
25POSTTOGL SearchPost To GLCBBoolean0
26MODIFDT SearchModified DateDTDate8
27CREATDDT SearchCreated DateDTDate8
28NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

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

Click to show/hide

SELECT
       ['JC_Production_Batch_Headers'].CURNCYID AS 'JC_Production_Batch_Headers-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       JC01301 AS ['JC_Production_Batch_Headers']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['JC_Production_Batch_Headers'].CURNCYID = ['Currency Setup'].CURNCYID
30BCHSTTUS SearchBatch StatusINTInteger0
31CNTRLTRX SearchControl TRX CountLI6_U0Long Integer6
32CNTRLTOT SearchControl TotalDLR19_RBS0_UTR$Currency19
33Production_Control_Total SearchProduction Control TotalDLR14_TSCurrency14
34PETRXCNT SearchPosting Error TRX CountINT5_U0Integer5
35APPROVL SearchApprovalCB_ApprovalBoolean0
36APPRVLDT SearchApproval DateDATEDate6
37APRVLUSERID SearchApproval User IDSTR15_User_IDString15
38ORIGIN SearchOriginDDLInteger0
azurecurveProductsWennSoft Products (131)3rd PartyJC_Production_Batch_Headers (JC01301)

Leave a Reply

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