PM Transaction WORK File (PM10000)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: PM Transaction WORK File
Physical Name: PM10000
Technical Name: PM_Transaction_WORK

Group Display Name: Payables Transaction Logical File
Group Technical Name: PM_Transaction_Logical_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1BACHNUMB SearchBatch NumberSTR15_LBAUString1615
Partial key to the PA Report Posting Definitions Master (SY00500).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].BACHNUMB AS 'PM Transaction WORK File-Batch Number'
       ,['PA Report Posting Definitions Master'].BACHNUMB AS 'PA Report Posting Definitions Master-Batch Number'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       SY00500 AS ['PA Report Posting Definitions Master']
              ON
                     ['PM Transaction WORK File'].BACHNUMB = ['PA Report Posting Definitions Master'].BACHNUMB
              AND
                     ['PM Transaction WORK File'].BCHSOURC = ['PA Report Posting Definitions Master'].BCHSOURC
2BCHSOURC 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)
3VCHNUMWK SearchVoucher Number - WORKSTR17_LBAUString1817
4VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].VENDORID AS 'PM Transaction WORK File-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['PM Transaction WORK File'].VENDORID = ['PM Vendor Master File'].VENDORID
5DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
6DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20

Click to show/hide Document Types


1	Invoice
2	Finance Charge
3	Miscellaneous Charges
4	Return
5	Credit Memo
7SOURCDOC SearchSource DocumentSTR10_Source_DocumentString1210
Key to the Source Document Master (SY00900).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].SOURCDOC AS 'PM Transaction WORK File-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['PM Transaction WORK File'].SOURCDOC = ['Source Document Master'].SOURCDOC
8DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency1019
9DOCDATE SearchDocument DateDTDate48
10PSTGDATE SearchPosting DateDTDate48
11VADDCDPR SearchVendor Address Code - PrimarySTR15_Address_CodeString1615
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].VADDCDPR AS 'PM Transaction WORK File-Vendor Address Code - Primary'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['PM Transaction WORK File'].VADDCDPR = ['PM Address MSTR'].ADRSCODE
              AND
                     ['PM Transaction WORK File'].VENDORID = ['PM Address MSTR'].VENDORID
12VADCDTRO SearchVendor Address Code - Remit ToSTR15_Address_CodeString1615
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].VADCDTRO AS 'PM Transaction WORK File-Vendor Address Code - Remit To'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['PM Transaction WORK File'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
              AND
                     ['PM Transaction WORK File'].VENDORID = ['PM Address MSTR'].VENDORID
13PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].PYMTRMID AS 'PM Transaction WORK File-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['PM Transaction WORK File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
14TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].TAXSCHID AS 'PM Transaction WORK File-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM Transaction WORK File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
15DUEDATE SearchDue DateDTDate48
16DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency1011
17DISCDATE SearchDiscount DateDTDate48
18PRCHAMNT SearchPurchases AmountDLR17_RBS0_UTR$Currency1017
19CHRGAMNT SearchCharge AmountDLR19_RBSO_UTR$Currency1019
20CASHAMNT SearchCash AmountDLR19_RBS0_UTR$Currency1019
21CAMCBKID SearchCash Amount Checkbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].CAMCBKID AS 'PM Transaction WORK File-Cash Amount Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PM Transaction WORK File'].CAMCBKID = ['CM Checkbook Master'].CHEKBKID
22CDOCNMBR SearchCash Document NumberSTR20_Document_NumberString2220
23CAMTDATE SearchCash Amount DateDTDate48
24CAMPMTNM SearchCash Amount Payment NumberSTR20_LBAUString2220
25CHEKAMNT SearchCheck AmountDLR19_RBS0_UTR$Currency1019
26CHAMCBID SearchCheck Amount Checkbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].CHAMCBID AS 'PM Transaction WORK File-Check Amount Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PM Transaction WORK File'].CHAMCBID = ['CM Checkbook Master'].CHEKBKID
27CHEKDATE SearchCheck DateDATEDate46
28CAMPYNBR SearchCheck Amount Payment NumberSTR20_LBAUString2220
29CRCRDAMT SearchCredit Card AmountDLR19_RBS0_UTR$Currency1019
30CCAMPYNM SearchCredit Card Amount Payment NumberSTR20_LBAUString2220
31CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
32CARDNAME SearchCard NameSTR15_Card_NameString1615
33CCRCTNUM SearchCredit Card Receipt NumberSTR20_Document_NumberString2220
34CRCARDDT SearchCredit Card DateDATEDate46
35CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].CURNCYID AS 'PM Transaction WORK File-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PM Transaction WORK File'].CURNCYID = ['Currency Setup'].CURNCYID
36CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].CHEKBKID AS 'PM Transaction WORK File-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PM Transaction WORK File'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
37TRXDSCRN SearchTransaction DescriptionSTR30String3230
38UN1099AM SearchUnapplied 1099 AmountDLR17_RBS0_UTR$Currency1017
39TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
40TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
41FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
42TEN99AMNT Search1099 AmountDLR17_RBS0_UTR$Currency1017
43MSCCHAMT SearchMisc Charges AmountDLR17_RBS0_UTR$Currency1017
44PORDNMBR SearchPurchase Order NumberPurchase Order NumberString2220
45SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].SHIPMTHD AS 'PM Transaction WORK File-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['PM Transaction WORK File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
46DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency1017
47DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
48APDSTKAM SearchApplied Discount Taken AmountDLR17_RBS0_UTR$Currency1017
49WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
50CURTRXAM SearchCurrent Trx AmountDLR17_RBS0_UTR$Currency1017
51TXENGCLD SearchTax Engine CalledYNBoolean20
52PMWRKMSG SearchPM WORK MessagesML_PM_WORK_MessagesLong Integer40
53PMDSTMSG SearchPM Distribution MessagesML_PM_Distribution_MessagesLong Integer40
54GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency1017
55PGRAMSBJ SearchPercent Of Gross Amount SubjectINT5_RBS2_U%Integer25
56PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency1017
57PPSTAXRT SearchPPS Tax RateINT5_%2Integer25
58PSTGSTUS SearchPosting StatusINTInteger20

Click to show/hide Posting Status


10	A transaction being entered for the first time, before it has been saved by the used.
20	A saved but unposted transaction.
30	A transaction that is currently realtime posting.
40	A posted transaction.
50	A transactions that has encountered an error during posting.
60	A transaction that has been saved previously and has a status of 20 is now being edited by the user.
70	A transaction that has been posted previously in a recurring batch that still contains unposted transactions is now being edited by the user.
59POSTED SearchPostedTrue/FalseBoolean20
60APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency1017
61VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
Partial key to the PM Key Master File (PM00400).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].VCHRNMBR AS 'PM Transaction WORK File-Voucher Number'
       ,['PM Key Master File'].VCHRNMBR AS 
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       PM00400 AS ['PM Key Master File']
              ON
                     ['PM Transaction WORK File'].VCHRNMBR = ['PM Key Master File'].VCHRNMBR
              AND
                     ['PM Transaction WORK File'].DOCTYPE = ['PM Key Master File'].DOCTYPE
              AND
                     ['PM Key Master File'].CNTRLTYP = 0
62CNTRLTYP SearchControl TypeINT1Integer21
The Control Type records the type of transaction.

Click to show/hide Control Types

0	Voucher types
1	Payment types
2	Printed alignment forms
63MODIFDT SearchModified DateDTDate48
64MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].MDFUSRID AS 'PM Transaction WORK File-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PM Transaction WORK File'].MDFUSRID = ['Users Master'].USERID
65POSTEDDT SearchPosted DateDATEDate46
66PTDUSRID SearchPosted User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].PTDUSRID AS 'PM Transaction WORK File-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PM Transaction WORK File'].PTDUSRID = ['Users Master'].USERID
67NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].NOTEINDX AS 'PM Transaction WORK File-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PM Transaction WORK File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
68BKTFRTAM SearchBackout Freight AmountDLR19_RBS0_UTR$Currency1019
69BKTMSCAM SearchBackout Misc AmountDLR19_RBS0_UTR$Currency1019
70BKTPURAM SearchBackout Purchases AmountDLR19_RBS0_UTR$Currency1019
71PCHSCHID SearchPurchase Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].PCHSCHID AS 'PM Transaction WORK File-Purchase Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM Transaction WORK File'].PCHSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
72FRTSCHID SearchFreight Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].FRTSCHID AS 'PM Transaction WORK File-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM Transaction WORK File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
73MSCSCHID SearchMisc Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].MSCSCHID AS 'PM Transaction WORK File-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PM10000 AS ['PM Transaction WORK File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM Transaction WORK File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
74PRINTED SearchPrintedCBBoolean20

Click to show/hide Printed flag


0	Record has not been printed.
1	Record has been printed.
75PRCTDISC SearchPercent DiscountINT5_%2Integer25
76RETNAGAM SearchRetainage AmountDLR17_RBS0_UTR$Currency1017
77ICTRX SearchIC TRXCB_IC_TRXBoolean20

Click to show/hide Intercompany flag


0	Not intercompany.
1	Intercompany
78ICDISTS SearchICDistsBooleanBoolean20

Click to show/hide Intercompany distirubtions


0	Not intercompany.
1	Intercompany distributions present.
79PMICMSGS SearchICMessagesML_IC_Post_MessagesLong Integer40
Error messages from posting an Intercompany Transaction.

Click to show/hide Intercompany posting error messages


1	The currency ID is missing.
2	A destination company does not have access to this currency ID.
3	The currency ID is inactive for a destination company. 
4	A rate type ID is missing for a destination company. 
5	Rate type ID is not associated with the currency ID for a destination
   company.
6	An exchange table ID is missing for a destination company. 
7	A destination company does not have access to an exchange table ID. 
8	An exchange table ID is inactive for a destination company. 
9	An exchange rate does not exist for a destination company. 
10	An exchange rate has expired for a destination company. 
11	Cannot post intercompany multicurrency transactions to a recurring batch. 
12	A rounding account missing for a destination company.
13	A distribution type is invalid for a destination company distribution.
14	A destination company distribution contains MDA information.
15	A destination company ID does not exist; please select another company ID.
16	The user does not have access to a destination company.
17	A destination company does not have a functional currency set up.
18	Destination functional currency doesn't match originating functional currency.
19	No relationship exists between originating company and a destination company.
20	Due To / Due From account not specified.
21	The rounding account does not exist for the originating company.
22	Unknown SQL error occurred.
23	Intrastat information is missing or invalid.
24	The goods value for Intrastat exceeds the document total.
25	Transaction has successfully posted.
80Tax_Date SearchTax DateDTDate48
81PRCHDATE SearchPurchase DateDTDate48
82CORRCTN SearchCorrectionCB_CorrectionBoolean20
83SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean20
84CORRNXST SearchCorrection to Nonexisting TransactionBooleanBoolean20
85VCHRNCOR SearchVoucher Number CorrectedSTR20_LBAUString2220
86PMWRKMS2 SearchPM WORK Messages 2ML_PM_WORK_Messages_2Long Integer40
87BNKRCAMT SearchBank Receipts AmountDLR17_RBS0_STR$Currency1017
88APLYWITH SearchApply WithholdingBooleanBoolean20
89Electronic SearchElectronicCB_ElectronicBoolean20
90ECTRX SearchEC TransactionCB_EC_TransactionBoolean20
The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.

Click to show/hide Document Printed flag


0	Not an EU Transaction.
1	EU Transaction.
91DocPrinted SearchDocPrintedCB_DocPrintedBoolean20

Click to show/hide Document Printed flag


0	Record has not been printed.
1	Record has been printed.
92TaxInvReqd SearchTax Invoice RequiredCB_Tax_Invoice_RequiredBoolean20
93BackoutTradeDisc SearchBackout Trade Discount AmountDLR19_RBS0_UTR$Currency1019
94CBVAT SearchCash Based VATCB_CashBasedVATBoolean20
95TEN99TYPE Search1099 Type1099_TypeInteger20
96TEN99BOXNUMBER Search1099 Box NumberDDL_1099_BoxInteger20
97Workflow_Status SearchWorkflow StatusWorkflow StatusInteger20
98InvoiceReceiptDate SearchInvoice Receipt DateDTDate48
Invoice Receipt Date is only available in a UK install of Microsoft Dynamics GP. It was introduced due to changes in UK legislation which came into force on 1st April 2017 for business of a certain size which now have duty to report on their payment practices, policies and performance. This new requirement was introduced to protect smaller businesses that suffer from late payments, which can adversely affect their cash flow and jeopardise their ability to trade.
99DEX_ROW_TS Searchdatetimedatetime33
DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised.
100DEX_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.

Leave a Reply

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