Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM30300
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: PM Apply To History File Group Display Name: Payables History Logical Files
Physical Name: PM30300
Technical Name: PM_Apply_To_HIST
Group Technical Name: PM_History_Logical_Files
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | VENDORID  | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['PM Apply To History File'].VENDORID AS 'PM Apply To History File-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
PM30300 AS ['PM Apply To History File']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PM Apply To History File'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
| 2 | DOCDATE | Document Date | Date | DT | 8 | |
| 3 | DATE1 | Date | Date | DT6 | 6 | |
| 4 | GLPOSTDT | GL Posting Date | Date | DT | 8 | |
| 5 | TIME1 | Time | Time | TM6 | 6 | |
| 6 | VCHRNMBR | Voucher Number | String | STR20_LBAU | 20 | |
Partial key to the PM Key Master File (PM00400).
Click to show/hideSELECT
['PM Apply To History File'].VCHRNMBR AS 'PM Apply To History File-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
PM30300 AS ['PM Apply To History File']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['PM Apply To History File'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['PM Apply To History File'].DOCTYPE = ['PM Key Master File'].DOCTYPE | ||||||
| 7 | 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 | ||||||
| 8 | APFRDCNM | Apply From Document Number | String | STR20_Document_Number | 20 | |
| 9 | ApplyFromGLPostDate | Apply From GL Posting Date | Date | DT | 8 | |
| 10 | FROMCURR | Apply From Currency ID | String | STR15_Currency_ID | 15 | |
| 11 | APFRMAPLYAMT | Apply From Apply Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 12 | APFRMDISCTAKEN | Apply From Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 13 | APFRMDISCAVAIL | Apply From Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 14 | APFRMWROFAMT | Apply From Write Off Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 15 | ActualApplyToAmount | Actual Apply To Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 16 | ActualDiscTakenAmount | Actual Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 17 | ActualDiscAvailTaken | Actual Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 18 | ActualWriteOffAmount | Actual Write Off Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 19 | APFRMEXRATE | Apply From Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 20 | APFRMDENRATE | Apply From Denomination Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 21 | APFRMRTCLCMETH | Apply From Rate Calc Method | Integer | INT | 0 | |
| 22 | APFRMMCTRXSTT | Apply From MC Transaction State | Integer | INT | 0 | |
| 23 | APTVCHNM | Apply To Voucher Number | String | STR20_LBAU | 20 | |
| 24 | APTODCTY | Apply To Document Type | Integer | DDL_Document_Type | 0 | |
| 25 | APTODCNM | Apply To Document Number | String | STR20_Document_Number | 20 | |
| 26 | APTODCDT | Apply To Document Date | Date | DT | 8 | |
| 27 | ApplyToGLPostDate | Apply To GL Posting Date | Date | DT | 8 | |
| 28 | CURNCYID | Currency ID | String | STR15_Currency_ID | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['PM Apply To History File'].CURNCYID AS 'PM Apply To History File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PM30300 AS ['PM Apply To History File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PM Apply To History File'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
| 29 | CURRNIDX | Currency Index | Integer | INT3 | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['PM Apply To History File'].CURRNIDX AS 'PM Apply To History File-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
PM30300 AS ['PM Apply To History File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PM Apply To History File'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||
| 30 | APPLDAMT | Applied Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 31 | DISTKNAM | Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 32 | DISAVTKN | Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 33 | WROFAMNT | Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 34 | ORAPPAMT | Originating Applied Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 35 | ORDISTKN | Originating Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 36 | ORDATKN | Originating Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 37 | ORWROFAM | Originating Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 38 | APTOEXRATE | Apply To Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 39 | APTODENRATE | Apply To Denomination Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 40 | APTORTCLCMETH | Apply To Rate Calc Method | Integer | INT | 0 | |
| 41 | APTOMCTRXSTT | Apply To MC Transaction State | Integer | INT | 0 | |
| 42 | PPSAMDED | PPS Amount Deducted | Currency | DLR17_RBS0_UTR$ | 17 | |
| 43 | GSTDSAMT | GST Discount Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 44 | 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 History File'].TAXDTLID AS 'PM Apply To History File-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
PM30300 AS ['PM Apply To History File']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['PM Apply To History File'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID | ||||||
| 45 | POSTED | Posted | Boolean | True/False | 0 | |
| 46 | TEN99AMNT | 1099 Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 47 | RLGANLOS | Realized Gain-Loss Amount | Currency | DLR19_$S2 | 19 | |
| 48 | APYFRMRNDAMT | Apply From Round Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 49 | APYTORNDAMT | Apply To Round Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 50 | APYTORNDDISC | Apply To Round Discount | Currency | DLR17_RBS0_STR$ | 17 | |
| 51 | OAPYFRMRNDAMT | Originating Apply From Round Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 52 | OAPYTORNDAMT | Originating Apply To Round Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 53 | OAPYTORNDDISC | Originating Apply To Round Discount | Currency | DLR17_RBS0_STR$ | 17 | |
| 54 | Settled_Gain_CreditCurrT | Settled Gain CreditCurrTrx | Currency | DLR19_$S2 | 19 | |
| 55 | Settled_Loss_CreditCurrT | Settled Loss CreditCurrTrx | Currency | DLR19_$S2 | 19 | |
| 56 | Settled_Gain_DebitCurrTr | Settled Gain DebitCurrTrx | Currency | DLR19_$S2 | 19 | |
| 57 | Settled_Loss_DebitCurrTr | Settled Loss DebitCurrTrx | Currency | DLR19_$S2 | 19 | |
| 58 | Settled_Gain_DebitDiscAv | Settled Gain DebitDiscAvail | Currency | DLR19_$S2 | 19 | |
| 59 | Settled_Loss_DebitDiscAv | Settled Loss DebitDiscAvail | Currency | DLR19_$S2 | 19 | |
| 60 | Revaluation_Status | Revaluation Status | Integer | INT | 0 | |
| 61 | Credit1099Amount | Credit 1099 Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 62 | DEFTEN99TYPE | Default 1099 Type | Integer | 1099_Type | 0 | |
| 63 | DEFTEN99BOXNUMBER | Default 1099 Box Number | Integer | DDL_1099_Box | 0 | |