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 Group Display Name: Payables Transaction Logical File
Physical Name: PM20100
Technical Name: PM_Apply_To_OPEN_OPEN
Group Technical Name: PM_Transaction_Logical_File
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | KEYSOURC  | Key Source | String | STR40_Source | 40 | |
| 2 | DOCDATE | Document Date | Date | DT | 8 | |
| 3 | TIME1 | Time | Time | TM6 | 6 | |
| 4 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['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 | ||||||
| 5 | POSTED | Posted | Boolean | True/False | 0 | |
| 6 | BCHSOURC | Batch Source | String | STR15 | 15 | |
Records whether the transaction was entered in a batch or not.Click to show/hide the Batch SourcesPM_Trxent Batch
XXPM_Trxent No batch (real-time)
| ||||||
| 7 | USERID | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
| 8 | APTVCHNM | Apply To Voucher Number | String | STR20_LBAU | 20 | |
| 9 | APTODCTY | Apply To Document Type | Integer | DDL_Document_Type | 0 | |
| 10 | APTODCDT | Apply To Document Date | Date | DT | 8 | |
| 11 | APTODCNM | Apply To Document Number | String | STR20_Document_Number | 20 | |
| 12 | APPLDAMT | Applied Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 13 | DISTKNAM | Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 14 | DISAVTKN | Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 15 | WROFAMNT | Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 16 | CURNCYID | Currency ID | String | STR15_Currency_ID | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['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 | ||||||
| 17 | CURRNIDX | Currency Index | Integer | INT3 | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['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 | ||||||
| 18 | ORAPPAMT | Originating Applied Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 19 | ORDISTKN | Originating Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 20 | ORDATKN | Originating Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 21 | ORWROFAM | Originating Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 22 | Apply_To_Document_Amount | Apply To Document Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 23 | Apply_To_Orig_Doc_Amount | Apply To Orig Doc Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 24 | Apply_To_Discount_Date | Apply To Discount Date | Date | DT | 8 | |
| 25 | Apply_To_Due_Date | Apply To Due Date | Date | DT | 8 | |
| 26 | Apply_To_Description | Apply To Description | String | STR30 | 30 | |
| 27 | Apply_To_IS_MC_Trx | Apply To IS MC Trx | Integer | INT | 0 | |
| 28 | ApplyToGLPostDate | Apply To GL Posting Date | Date | DT | 8 | |
| 29 | APTOEXRATE | Apply To Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 30 | APTODENRATE | Apply To Denomination Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 31 | APTORTCLCMETH | Apply To Rate Calc Method | Integer | INT | 0 | |
| 32 | APTOMCTRXSTT | Apply To MC Transaction State | Integer | INT | 0 | |
| 33 | ISMCTRX | IS MC Trx | Integer | INT | 0 | |
| 34 | VCHRNMBR | Voucher Number | String | STR20_LBAU | 20 | |
Partial key to the PM Key Master File (PM00400).
Click to show/hideSELECT
['PM Apply To OPEN OPEN Temporary File'].VCHRNMBR AS 'PM Apply To OPEN OPEN Temporary File-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
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'].CNTRLNUM
AND
['PM Apply To OPEN OPEN Temporary File'].DOCTYPE = ['PM Key Master File'].DOCTYPE | ||||||
| 35 | DOCTYPE | Document Type | Integer | DDL_Document_Type | 0 | |
Click to show/hide Document Types
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo | ||||||
| 36 | APFRDCNM | Apply From Document Number | String | STR20_Document_Number | 20 | |
| 37 | FROMCURR | Apply From Currency ID | String | STR15_Currency_ID | 15 | |
| 38 | Apply_From_Document_Amou | Apply From Document Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 39 | Apply_From_Orig_Doc_Amou | Apply From Orig Doc Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 40 | APFRMAPLYAMT | Apply From Apply Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 41 | APFRMDISCTAKEN | Apply From Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 42 | APFRMDISCAVAIL | Apply From Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 43 | APFRMWROFAMT | Apply From Write Off Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 44 | ActualApplyToAmount | Actual Apply To Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 45 | ActualDiscTakenAmount | Actual Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 46 | ActualDiscAvailTaken | Actual Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 47 | ActualWriteOffAmount | Actual Write Off Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 48 | APFRMEXRATE | Apply From Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 49 | APFRMDENRATE | Apply From Denomination Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 50 | APFRMRTCLCMETH | Apply From Rate Calc Method | Integer | INT | 0 | |
| 51 | APFRMMCTRXSTT | Apply From MC Transaction State | Integer | INT | 0 | |
| 52 | Apply_From_Description | Apply From Description | String | STR30 | 30 | |
| 53 | Apply_From_IS_MC_Trx | Apply From IS MC Trx | Integer | INT | 0 | |
| 54 | PPSAMDED | PPS Amount Deducted | Currency | DLR17_RBS0_UTR$ | 17 | |
| 55 | GSTDSAMT | GST Discount Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 56 | TAXDTLID | Tax Detail ID | String | STR15_Tax_Detail_ID | 15 | |
Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hideSELECT
['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 | ||||||
| 57 | UPDTKNAM | Unposted Discount Taken Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 58 | UPGSTDAM | Unposted GST Discount Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 59 | UNPPPSAD | Unposted PPS Amount Deducted | Currency | DLR17_RBS0_UTR$ | 17 | |
| 60 | UPWROFAM | Unposted Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 61 | PMDSTMSG | PM Distribution Messages | Long Integer | ML_PM_Distribution_Messages | 0 | |
| 62 | MODIFDT | Modified Date | Date | DT | 8 | |
| 63 | MDFUSRID | Modified User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
| 64 | POSTEDDT | Posted Date | Date | DATE | 6 | |
| 65 | PTDUSRID | Posted User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
| 66 | TEN99AMNT | 1099 Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 67 | RLGANLOS | Realized Gain-Loss Amount | Currency | DLR19_$S2 | 19 | |
| 68 | APYFRMRNDAMT | Apply From Round Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 69 | APYTORNDAMT | Apply To Round Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 70 | APYTORNDDISC | Apply To Round Discount | Currency | DLR17_RBS0_STR$ | 17 | |
| 71 | XCHGRATE | Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 72 | DECPLCUR | Decimal Places Currency | Integer | DDL_Decimal_Places_Dollars | 0 | |
Number of decimal places for the currency values, based on the item's settings.
Click to show/hide Decimal Places Currency7 0 decimals
8 1
9 2
10 3
11 4
12 5 | ||||||
| 73 | RATECALC | Rate Calc Method | Integer | INT | 0 | |
Rate Calc Method of the transaction. For non multi-currency transactions, this field will be blank.
Click to show/hide Rate Calc Methods0 Multiply
1 Divide | ||||||
| 74 | Payment_To_Print_On_Stub | Payment To Print On Stub | String | STR20_LBAU | 20 | |
| 75 | OAPYFRMRNDAMT | Originating Apply From Round Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 76 | OAPYTORNDAMT | Originating Apply To Round Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 77 | OAPYTORNDDISC | Originating Apply To Round Discount | Currency | DLR17_RBS0_STR$ | 17 | |
| 78 | Settled_Gain_CreditCurrT | Settled Gain CreditCurrTrx | Currency | DLR19_$S2 | 19 | |
| 79 | Settled_Loss_CreditCurrT | Settled Loss CreditCurrTrx | Currency | DLR19_$S2 | 19 | |
| 80 | Settled_Gain_DebitCurrTr | Settled Gain DebitCurrTrx | Currency | DLR19_$S2 | 19 | |
| 81 | Settled_Loss_DebitCurrTr | Settled Loss DebitCurrTrx | Currency | DLR19_$S2 | 19 | |
| 82 | Settled_Gain_DebitDiscAv | Settled Gain DebitDiscAvail | Currency | DLR19_$S2 | 19 | |
| 83 | Settled_Loss_DebitDiscAv | Settled Loss DebitDiscAvail | Currency | DLR19_$S2 | 19 | |
| 84 | VADCDTRO | Vendor Address Code - Remit To | String | STR15_Address_Code | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['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 | ||||||
| 85 | Credit1099Amount | Credit 1099 Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 86 | DEFTEN99TYPE | Default 1099 Type | Integer | 1099_Type | 0 | |
| 87 | DEFTEN99BOXNUMBER | Default 1099 Box Number | Integer | DDL_1099_Box | 0 | |