Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM50100
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: PM History Removal Tempoary File
Physical Name: PM50100
Technical Name: pmHistRemovalTempSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VCHRNMBR 
Voucher Number String STR20_LBAU 20 Partial key to the PM Key Master File (PM00400).
Click to show/hide
SELECT
['PM History Removal Tempoary File'].VCHRNMBR AS 'PM History Removal Tempoary File-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
PM50100 AS ['PM History Removal Tempoary File']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['PM History Removal Tempoary File'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['PM History Removal Tempoary File'].DOCTYPE = ['PM Key Master File'].DOCTYPE2 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['PM History Removal Tempoary File'].VENDORID AS 'PM History Removal Tempoary File-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
PM50100 AS ['PM History Removal Tempoary File']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PM History Removal Tempoary File'].VENDORID = ['PM Vendor Master File'].VENDORID3 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 Memo4 DOCDATE Document Date Date DT 8 5 DOCNUMBR Document Number String STR20_Document_Number 20 6 DOCAMNT Document Amount Currency DLR19_RBSO_UTR$ 19 7 CURTRXAM Current Trx Amount Currency DLR17_RBS0_UTR$ 17 8 DISTKNAM Discount Taken Amount Currency DLR17_RBS0_UTR$ 17 9 DISCAMNT Discount Amount Currency DLR17_RBS0_STR$ 17 10 DSCDLRAM Discount Dollar Amount Currency DLR11_RBS0_UTR$ 11 11 BACHNUMB Batch Number String STR15_LBAU 15 12 TRXSORCE TRX Source String STR13 13 13 BCHSOURC Batch Source String STR15 15 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)
14 DISCDATE Discount Date Date DT 8 15 DUEDATE Due Date Date DT 8 16 PORDNMBR Purchase Order Number String Purchase Order Number 20 17 TEN99AMNT 1099 Amount Currency DLR17_RBS0_UTR$ 17 18 WROFAMNT Write Off Amount Currency DLR17_RBS0_STR$ 17 19 DISAMTAV Discount Amount Available Currency DLR17_RBS0_UTR$ 17 20 TRXDSCRN Transaction Description String STR30 30 21 UN1099AM Unapplied 1099 Amount Currency DLR17_RBS0_UTR$ 17 22 BKTPURAM Backout Purchases Amount Currency DLR19_RBS0_UTR$ 19 23 BKTFRTAM Backout Freight Amount Currency DLR19_RBS0_UTR$ 19 24 BKTMSCAM Backout Misc Amount Currency DLR19_RBS0_UTR$ 19 25 VOIDED Voided Boolean CB 0 26 HOLD Hold Boolean CB_Hold 0 27 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['PM History Removal Tempoary File'].CHEKBKID AS 'PM History Removal Tempoary File-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
PM50100 AS ['PM History Removal Tempoary File']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['PM History Removal Tempoary File'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID28 DINVPDOF Date Invoice Paid Off Date DT 8 29 PPSAMDED PPS Amount Deducted Currency DLR17_RBS0_UTR$ 17 30 PPSTAXRT PPS Tax Rate Integer INT5_%2 5 31 PGRAMSBJ Percent Of Gross Amount Subject Integer INT5_RBS2_U% 5 32 GSTDSAMT GST Discount Amount Currency DLR17_RBS0_STR$ 17 33 POSTEDDT Posted Date Date DATE 6 34 PTDUSRID Posted User ID String STR15 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['PM History Removal Tempoary File'].PTDUSRID AS 'PM History Removal Tempoary File-Posted User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PM50100 AS ['PM History Removal Tempoary File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PM History Removal Tempoary File'].PTDUSRID = ['Users Master'].USERID35 MODIFDT Modified Date Date DT 8 36 MDFUSRID Modified User ID String STR15 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['PM History Removal Tempoary File'].MDFUSRID AS 'PM History Removal Tempoary File-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PM50100 AS ['PM History Removal Tempoary File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PM History Removal Tempoary File'].MDFUSRID = ['Users Master'].USERID37 PYENTTYP Payment Entry Type Integer GB 0 Click to show/hide Payment Entry Type
0 Check
1 Cash
2 Credit Card38 CARDNAME Card Name String STR15_Card_Name 15 39 PRCHAMNT Purchases Amount Currency DLR17_RBS0_UTR$ 17 40 TRDISAMT Trade Discount Amount Currency DLR17_RBS0_UTR$ 17 41 MSCCHAMT Misc Charges Amount Currency DLR17_RBS0_UTR$ 17 42 FRTAMNT Freight Amount Currency DLR17_RBS0_UTR$ 17 43 TAXAMNT Tax Amount Currency DLR17_RBS0_UTR$ 17 44 TTLPYMTS Total Payments Currency DLR19_RBS0_UTR$ 19 45 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PM History Removal Tempoary File'].CURNCYID AS 'PM History Removal Tempoary File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PM50100 AS ['PM History Removal Tempoary File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PM History Removal Tempoary File'].CURNCYID = ['Currency Setup'].CURNCYID46 PYMTRMID Payment Terms ID String STR20_Payment_Terms_ID 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['PM History Removal Tempoary File'].PYMTRMID AS 'PM History Removal Tempoary File-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
PM50100 AS ['PM History Removal Tempoary File']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['PM History Removal Tempoary File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID47 SHIPMTHD Shipping Method String STR15_Shipping_Method 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['PM History Removal Tempoary File'].SHIPMTHD AS 'PM History Removal Tempoary File-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
PM50100 AS ['PM History Removal Tempoary File']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['PM History Removal Tempoary File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD48 TAXSCHID Tax Schedule ID String STR15_Tax_Schedule_ID 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['PM History Removal Tempoary File'].TAXSCHID AS 'PM History Removal Tempoary File-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PM50100 AS ['PM History Removal Tempoary File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PM History Removal Tempoary File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID49 PCHSCHID Purchase Schedule ID String STR15_LBAU 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['PM History Removal Tempoary File'].PCHSCHID AS 'PM History Removal Tempoary File-Purchase Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PM50100 AS ['PM History Removal Tempoary File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PM History Removal Tempoary File'].PCHSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID50 FRTSCHID Freight Schedule ID String STR15_LBAU 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['PM History Removal Tempoary File'].FRTSCHID AS 'PM History Removal Tempoary File-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PM50100 AS ['PM History Removal Tempoary File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PM History Removal Tempoary File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID51 MSCSCHID Misc Schedule ID String STR15_LBAU 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['PM History Removal Tempoary File'].MSCSCHID AS 'PM History Removal Tempoary File-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PM50100 AS ['PM History Removal Tempoary File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PM History Removal Tempoary File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID52 PSTGDATE Posting Date Date DT 8 53 DISAVTKN Discount Available Taken Currency DLR17_RBS0_UTR$ 17 54 CNTRLTYP Control Type Integer INT1 1 The Control Type records the type of transaction.
Click to show/hide Control Types
0 Voucher types
1 Payment types
2 Printed alignment forms55 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['PM History Removal Tempoary File'].NOTEINDX AS 'PM History Removal Tempoary File-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PM50100 AS ['PM History Removal Tempoary File']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PM History Removal Tempoary File'].NOTEINDX = ['Record Notes Master'].NOTEINDX56 PRCTDISC Percent Discount Integer INT5_%2 5 57 RETNAGAM Retainage Amount Currency DLR17_RBS0_UTR$ 17 58 VOIDPDATE Void GL Posting Date Date DT 8 59 ICTRX IC TRX Boolean CB_IC_TRX 0 Click to show/hide Intercompany flag
0 Not intercompany.
1 Intercompany60 Tax_Date Tax Date Date DT 8 61 PRCHDATE Purchase Date Date DT 8 62 CORRCTN Correction Boolean CB_Correction 0 63 SIMPLIFD Simplified Boolean CB_Simplified 0 64 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['PM History Removal Tempoary File'].USERID AS 'PM History Removal Tempoary File-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PM50100 AS ['PM History Removal Tempoary File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PM History Removal Tempoary File'].USERID = ['Users Master'].USERID65 PRCSSQNC Process Sequence Integer INT 0 66 Status Status Integer INT 0 67 STR1 STR1 String STR1 1