Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM10200
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: PM Apply To WORK OPEN File Group Display Name: Payables Transaction Logical File
Physical Name: PM10200
Technical Name: PM_Apply_To_WORK_OPEN
Group Technical Name: PM_Transaction_Logical_File
| 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 WORK OPEN File'].VENDORID AS 'PM Apply To WORK OPEN File-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
PM10200 AS ['PM Apply To WORK OPEN File']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PM Apply To WORK OPEN 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 | APTVCHNM | Apply To Voucher Number | String | STR20_LBAU | 20 | |
| 7 | APTODCTY | Apply To Document Type | Integer | DDL_Document_Type | 0 | |
| 8 | APTODCNM | Apply To Document Number | String | STR20_Document_Number | 20 | |
| 9 | APTODCDT | Apply To Document Date | Date | DT | 8 | |
| 10 | ApplyToGLPostDate | Apply To GL Posting Date | Date | DT | 8 | |
| 11 | CURNCYID | Currency ID | String | STR15_Currency_ID | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['PM Apply To WORK OPEN File'].CURNCYID AS 'PM Apply To WORK OPEN File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PM10200 AS ['PM Apply To WORK OPEN File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PM Apply To WORK OPEN File'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
| 12 | CURRNIDX | Currency Index | Integer | INT3 | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['PM Apply To WORK OPEN File'].CURRNIDX AS 'PM Apply To WORK OPEN File-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
PM10200 AS ['PM Apply To WORK OPEN File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PM Apply To WORK OPEN File'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||
| 13 | APPLDAMT | Applied Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 14 | DISTKNAM | Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 15 | DISAVTKN | Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 16 | WROFAMNT | Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 17 | ORAPPAMT | Originating Applied Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 18 | ORDISTKN | Originating Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 19 | ORDATKN | Originating Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 20 | ORWROFAM | Originating Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 21 | APTOEXRATE | Apply To Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 22 | APTODENRATE | Apply To Denomination Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 23 | APTORTCLCMETH | Apply To Rate Calc Method | Integer | INT | 0 | |
| 24 | APTOMCTRXSTT | Apply To MC Transaction State | Integer | INT | 0 | |
| 25 | VCHRNMBR | Voucher Number | String | STR20_LBAU | 20 | |
Partial key to the PM Key Master File (PM00400).
Click to show/hideSELECT
['PM Apply To WORK OPEN File'].VCHRNMBR AS 'PM Apply To WORK OPEN File-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
PM10200 AS ['PM Apply To WORK OPEN File']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['PM Apply To WORK OPEN File'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['PM Apply To WORK OPEN File'].DOCTYPE = ['PM Key Master File'].DOCTYPE | ||||||
| 26 | 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 | ||||||
| 27 | APFRDCNM | Apply From Document Number | String | STR20_Document_Number | 20 | |
| 28 | ApplyFromGLPostDate | Apply From GL Posting Date | Date | DT | 8 | |
| 29 | FROMCURR | Apply From Currency ID | String | STR15_Currency_ID | 15 | |
| 30 | APFRMAPLYAMT | Apply From Apply Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 31 | APFRMDISCTAKEN | Apply From Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 32 | APFRMDISCAVAIL | Apply From Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 33 | APFRMWROFAMT | Apply From Write Off Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 34 | ActualApplyToAmount | Actual Apply To Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 35 | ActualDiscTakenAmount | Actual Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 36 | ActualDiscAvailTaken | Actual Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 37 | ActualWriteOffAmount | Actual Write Off Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 38 | APFRMEXRATE | Apply From Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 39 | APFRMDENRATE | Apply From Denomination Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 40 | APFRMRTCLCMETH | Apply From Rate Calc Method | Integer | INT | 0 | |
| 41 | APFRMMCTRXSTT | Apply From 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 WORK OPEN File'].TAXDTLID AS 'PM Apply To WORK OPEN File-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
PM10200 AS ['PM Apply To WORK OPEN File']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['PM Apply To WORK OPEN 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 | |