Reprint Transaction Batch Headers (PM80100)

azurecurveProductsMicrosoft Dynamics GP (0)PurchasingReprint Transaction Batch Headers (PM80100)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Reprint Transaction Batch Headers
Physical Name: PM80100
Technical Name: PM_Reprint_Batch_Headers

Group Display Name: Payables Reprint Journals Logical File
Group Technical Name: PM_Reprint_Journals_Logical_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1TRXSORCE SearchTRX SourceSTR13String1413
2POSTEDDT SearchPosted DateDATEDate46
3GLPOSTDT SearchGL Posting DateDTDate48
4BCHSOURC SearchBatch SourceSTR15String1615
Records whether the transaction was entered in a batch or not.

Click to show/hide the Batch Sources

PM_Trxent	Batch
XXPM_Trxent	No batch (real-time)
5BACHNUMB SearchBatch NumberSTR15_LBAUString1615
6CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Reprint Transaction Batch Headers'].CHEKBKID AS 'Reprint Transaction Batch Headers-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       PM80100 AS ['Reprint Transaction Batch Headers']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Reprint Transaction Batch Headers'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
7NUMOFTRX SearchNumber Of TRXLI6_U0Long Integer46
8RECPSTGS SearchRecurring PostingsINT3_U0Integer23
9MSCBDINC SearchMisc Batch Days To IncrementINT3_U0Integer23
10BACHFREQ SearchBatch FrequencyDDL_FrequencyInteger20
11NOFPSTGS SearchNumber of PostingsINT3_S0Integer23
12BCHCOMNT SearchBatch CommentSTR60String6260
13USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Reprint Transaction Batch Headers'].USERID AS 'Reprint Transaction Batch Headers-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PM80100 AS ['Reprint Transaction Batch Headers']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Reprint Transaction Batch Headers'].USERID = ['Users Master'].USERID
14NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Reprint Transaction Batch Headers'].NOTEINDX AS 'Reprint Transaction Batch Headers-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PM80100 AS ['Reprint Transaction Batch Headers']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Reprint Transaction Batch Headers'].NOTEINDX = ['Record Notes Master'].NOTEINDX
15RCDSRMVD SearchRecords RemovedBooleanBoolean20
16BCHTOTAL SearchBatch TotalDLR19_RBS0_STR$Currency1019
17CNTRLTRX SearchControl TRX CountLI6_U0Long Integer46
18CNTRLTOT SearchControl TotalDLR19_RBS0_UTR$Currency1019
19APPROVL SearchApprovalCB_ApprovalBoolean20
20APPRVLDT SearchApproval DateDATEDate46
21APRVLUSERID SearchApproval User IDSTR15_User_IDString1615
The key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Reprint Transaction Batch Headers'].APRVLUSERID AS 'Reprint Transaction Batch Headers-Approval User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PM80100 AS ['Reprint Transaction Batch Headers']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Reprint Transaction Batch Headers'].APRVLUSERID = ['Users Master'].USERID
22Workflow_Approval_Status SearchWorkflow Approval StatusDDL_WorkflowApprovalStatusInteger20
23Workflow_Priority SearchWorkflow PriorityDDL_WorkflowPriorityInteger20
24Workflow_Status SearchWorkflow StatusWorkflow StatusInteger20
25CREATDDT SearchCreated DateDTDate48
26TIME1 SearchTimeTM6Time46
27DEX_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)PurchasingReprint Transaction Batch Headers (PM80100)

Leave a Reply

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