PM Apply To OPEN OPEN Temporary File (PM20100)

azurecurveProductsMicrosoft Dynamics GP (0)PurchasingPM Apply To OPEN OPEN Temporary File (PM20100)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: PM Apply To OPEN OPEN Temporary File
Physical Name: PM20100
Technical Name: PM_Apply_To_OPEN_OPEN

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
1KEYSOURC SearchKey SourceSTR40_SourceString4240
2DOCDATE SearchDocument DateDTDate48
3TIME1 SearchTimeTM6Time46
4VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['PM Apply To OPEN OPEN Temporary File'].VENDORID AS 'PM Apply To OPEN OPEN Temporary File-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       PM20100 AS ['PM Apply To OPEN OPEN Temporary File']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['PM Apply To OPEN OPEN Temporary File'].VENDORID = ['PM Vendor Master File'].VENDORID
5POSTED SearchPostedTrue/FalseBoolean20
6BCHSOURC 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)
7USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PM Apply To OPEN OPEN Temporary File'].USERID AS 'PM Apply To OPEN OPEN Temporary File-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PM20100 AS ['PM Apply To OPEN OPEN Temporary File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PM Apply To OPEN OPEN Temporary File'].USERID = ['Users Master'].USERID
8APTVCHNM SearchApply To Voucher NumberSTR20_LBAUString2220
9APTODCTY SearchApply To Document TypeDDL_Document_TypeInteger20
10APTODCDT SearchApply To Document DateDTDate48
11APTODCNM SearchApply To Document NumberSTR20_Document_NumberString2220
12APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency1017
13DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
14DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency1017
15WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
16CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PM Apply To OPEN OPEN Temporary File'].CURNCYID AS 'PM Apply To OPEN OPEN Temporary File-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PM20100 AS ['PM Apply To OPEN OPEN Temporary File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PM Apply To OPEN OPEN Temporary File'].CURNCYID = ['Currency Setup'].CURNCYID
17CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PM Apply To OPEN OPEN Temporary File'].CURRNIDX AS 'PM Apply To OPEN OPEN Temporary File-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       PM20100 AS ['PM Apply To OPEN OPEN Temporary File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PM Apply To OPEN OPEN Temporary File'].CURRNIDX = ['Currency Setup'].CURRNIDX
18ORAPPAMT SearchOriginating Applied AmountDLR17_RBS0_STR$Currency1017
19ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency1017
20ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency1017
21ORWROFAM SearchOriginating Write Off AmountDLR17_RBS0_STR$Currency1017
22Apply_To_Document_Amount SearchApply To Document AmountDLR19_RBS0_UTR$Currency1019
23Apply_To_Orig_Doc_Amount SearchApply To Orig Doc AmountDLR19_RBS0_UTR$Currency1019
24Apply_To_Discount_Date SearchApply To Discount DateDTDate48
25Apply_To_Due_Date SearchApply To Due DateDTDate48
26Apply_To_Description SearchApply To DescriptionSTR30String3230
27Apply_To_IS_MC_Trx SearchApply To IS MC TrxINTInteger20
28ApplyToGLPostDate SearchApply To GL Posting DateDTDate48
29APTOEXRATE SearchApply To Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
30APTODENRATE SearchApply To Denomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
31APTORTCLCMETH SearchApply To Rate Calc MethodINTInteger20
32APTOMCTRXSTT SearchApply To MC Transaction StateINTInteger20
33ISMCTRX SearchIS MC TrxINTInteger20
34VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
Partial key to the PM Key Master File (PM00400).

Click to show/hide

SELECT
       ['PM Apply To OPEN OPEN Temporary File'].VCHRNMBR AS 'PM Apply To OPEN OPEN Temporary File-Voucher Number'
       ,['PM Key Master File'].VCHRNMBR AS 
FROM
       PM20100 AS ['PM Apply To OPEN OPEN Temporary File']
INNER JOIN
       PM00400 AS ['PM Key Master File']
              ON
                     ['PM Apply To OPEN OPEN Temporary File'].VCHRNMBR = ['PM Key Master File'].VCHRNMBR
              AND
                     ['PM Apply To OPEN OPEN Temporary File'].DOCTYPE = ['PM Key Master File'].DOCTYPE
              AND
                     ['PM Key Master File'].CNTRLTYP = 0
35DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20

Click to show/hide Document Types


1	Invoice
2	Finance Charge
3	Miscellaneous Charges
4	Return
5	Credit Memo
36APFRDCNM SearchApply From Document NumberSTR20_Document_NumberString2220
37FROMCURR SearchApply From Currency IDSTR15_Currency_IDString1615
38Apply_From_Document_Amou SearchApply From Document AmountDLR19_RBS0_UTR$Currency1019
39Apply_From_Orig_Doc_Amou SearchApply From Orig Doc AmountDLR19_RBS0_UTR$Currency1019
40APFRMAPLYAMT SearchApply From Apply AmountDLR17_RBS0_UTR$Currency1017
41APFRMDISCTAKEN SearchApply From Discount Taken AmountDLR17_RBS0_UTR$Currency1017
42APFRMDISCAVAIL SearchApply From Discount Available TakenDLR17_RBS0_UTR$Currency1017
43APFRMWROFAMT SearchApply From Write Off AmountDLR17_RBS0_UTR$Currency1017
44ActualApplyToAmount SearchActual Apply To AmountDLR17_RBS0_UTR$Currency1017
45ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_RBS0_UTR$Currency1017
46ActualDiscAvailTaken SearchActual Discount Available TakenDLR17_RBS0_UTR$Currency1017
47ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency1017
48APFRMEXRATE SearchApply From Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
49APFRMDENRATE SearchApply From Denomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
50APFRMRTCLCMETH SearchApply From Rate Calc MethodINTInteger20
51APFRMMCTRXSTT SearchApply From MC Transaction StateINTInteger20
52Apply_From_Description SearchApply From DescriptionSTR30String3230
53Apply_From_IS_MC_Trx SearchApply From IS MC TrxINTInteger20
54PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency1017
55GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency1017
56TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString1615
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

SELECT
       ['PM Apply To OPEN OPEN Temporary File'].TAXDTLID AS 'PM Apply To OPEN OPEN Temporary File-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
       PM20100 AS ['PM Apply To OPEN OPEN Temporary File']
INNER JOIN
       TX00201 AS ['Sales/Purchases Tax Master']
              ON
                     ['PM Apply To OPEN OPEN Temporary File'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
57UPDTKNAM SearchUnposted Discount Taken AmountDLR17_RBS0_STR$Currency1017
58UPGSTDAM SearchUnposted GST Discount AmountDLR17_RBS0_STR$Currency1017
59UNPPPSAD SearchUnposted PPS Amount DeductedDLR17_RBS0_UTR$Currency1017
60UPWROFAM SearchUnposted Write Off AmountDLR17_RBS0_STR$Currency1017
61PMDSTMSG SearchPM Distribution MessagesML_PM_Distribution_MessagesLong Integer40
62MODIFDT SearchModified DateDTDate48
63MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PM Apply To OPEN OPEN Temporary File'].MDFUSRID AS 'PM Apply To OPEN OPEN Temporary File-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PM20100 AS ['PM Apply To OPEN OPEN Temporary File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PM Apply To OPEN OPEN Temporary File'].MDFUSRID = ['Users Master'].USERID
64POSTEDDT SearchPosted DateDATEDate46
65PTDUSRID SearchPosted User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PM Apply To OPEN OPEN Temporary File'].PTDUSRID AS 'PM Apply To OPEN OPEN Temporary File-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PM20100 AS ['PM Apply To OPEN OPEN Temporary File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PM Apply To OPEN OPEN Temporary File'].PTDUSRID = ['Users Master'].USERID
66TEN99AMNT Search1099 AmountDLR17_RBS0_UTR$Currency1017
67RLGANLOS SearchRealized Gain-Loss AmountDLR19_$S2Currency1019
68APYFRMRNDAMT SearchApply From Round AmountDLR17_RBS0_STR$Currency1017
69APYTORNDAMT SearchApply To Round AmountDLR17_RBS0_STR$Currency1017
70APYTORNDDISC SearchApply To Round DiscountDLR17_RBS0_STR$Currency1017
71XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
72DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
Number of decimal places for the currency values, based on the item's settings.

Click to show/hide Decimal Places Currency

7	0 decimals
8	1
9	2
10	3
11	4
12	5
73RATECALC SearchRate Calc MethodINTInteger20
Rate Calc Method of the transaction. For non multi-currency transactions, this field will be blank.

Click to show/hide Rate Calc Methods

0	Multiply
1	Divide
74Payment_To_Print_On_Stub SearchPayment To Print On StubSTR20_LBAUString2220
75OAPYFRMRNDAMT SearchOriginating Apply From Round AmountDLR17_RBS0_STR$Currency1017
76OAPYTORNDAMT SearchOriginating Apply To Round AmountDLR17_RBS0_STR$Currency1017
77OAPYTORNDDISC SearchOriginating Apply To Round DiscountDLR17_RBS0_STR$Currency1017
78Settled_Gain_CreditCurrT SearchSettled Gain CreditCurrTrxDLR19_$S2Currency1019
79Settled_Loss_CreditCurrT SearchSettled Loss CreditCurrTrxDLR19_$S2Currency1019
80Settled_Gain_DebitCurrTr SearchSettled Gain DebitCurrTrxDLR19_$S2Currency1019
81Settled_Loss_DebitCurrTr SearchSettled Loss DebitCurrTrxDLR19_$S2Currency1019
82Settled_Gain_DebitDiscAv SearchSettled Gain DebitDiscAvailDLR19_$S2Currency1019
83Settled_Loss_DebitDiscAv SearchSettled Loss DebitDiscAvailDLR19_$S2Currency1019
84VADCDTRO SearchVendor Address Code - Remit ToSTR15_Address_CodeString1615
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['PM Apply To OPEN OPEN Temporary File'].VADCDTRO AS 'PM Apply To OPEN OPEN Temporary File-Vendor Address Code - Remit To'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       PM20100 AS ['PM Apply To OPEN OPEN Temporary File']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['PM Apply To OPEN OPEN Temporary File'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
              AND
                     ['PM Apply To OPEN OPEN Temporary File'].VENDORID = ['PM Address MSTR'].VENDORID
85Credit1099Amount SearchCredit 1099 AmountDLR17_RBS0_UTR$Currency1017
86DEFTEN99TYPE SearchDefault 1099 Type1099_TypeInteger20
87DEFTEN99BOXNUMBER SearchDefault 1099 Box NumberDDL_1099_BoxInteger20
88DEX_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)PurchasingPM Apply To OPEN OPEN Temporary File (PM20100)

Leave a Reply

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