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 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.
Physical Name: PM50100
Technical Name: pmHistRemovalTempSeq No Physical Name Display Name Dexterity Data Type SQL Data Type SQL DB Length Keyable Length 1 VCHRNMBR 
Voucher Number STR20_LBAU String 22 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'].VCHRNMBR AS
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'].VCHRNMBR
AND
['PM History Removal Tempoary File'].DOCTYPE = ['PM Key Master File'].DOCTYPE
AND
['PM Key Master File'].CNTRLTYP = 02 VENDORID Vendor ID STR_15_Vendor_ID String 16 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 DDL_Document_Type Integer 2 0 Click to show/hide Document Types
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo4 DOCDATE Document Date DT Date 4 8 5 DOCNUMBR Document Number STR20_Document_Number String 22 20 6 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 10 19 7 CURTRXAM Current Trx Amount DLR17_RBS0_UTR$ Currency 10 17 8 DISTKNAM Discount Taken Amount DLR17_RBS0_UTR$ Currency 10 17 9 DISCAMNT Discount Amount DLR17_RBS0_STR$ Currency 10 17 10 DSCDLRAM Discount Dollar Amount DLR11_RBS0_UTR$ Currency 10 11 11 BACHNUMB Batch Number STR15_LBAU String 16 15 12 TRXSORCE TRX Source STR13 String 14 13 13 BCHSOURC Batch Source STR15 String 16 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 DT Date 4 8 15 DUEDATE Due Date DT Date 4 8 16 PORDNMBR Purchase Order Number Purchase Order Number String 22 20 17 TEN99AMNT 1099 Amount DLR17_RBS0_UTR$ Currency 10 17 18 WROFAMNT Write Off Amount DLR17_RBS0_STR$ Currency 10 17 19 DISAMTAV Discount Amount Available DLR17_RBS0_UTR$ Currency 10 17 20 TRXDSCRN Transaction Description STR30 String 32 30 21 UN1099AM Unapplied 1099 Amount DLR17_RBS0_UTR$ Currency 10 17 22 BKTPURAM Backout Purchases Amount DLR19_RBS0_UTR$ Currency 10 19 23 BKTFRTAM Backout Freight Amount DLR19_RBS0_UTR$ Currency 10 19 24 BKTMSCAM Backout Misc Amount DLR19_RBS0_UTR$ Currency 10 19 25 VOIDED Voided CB Boolean 2 0 26 HOLD Hold CB_Hold Boolean 2 0 27 CHEKBKID Checkbook ID STR15_Checkbook_ID String 16 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 DT Date 4 8 29 PPSAMDED PPS Amount Deducted DLR17_RBS0_UTR$ Currency 10 17 30 PPSTAXRT PPS Tax Rate INT5_%2 Integer 2 5 31 PGRAMSBJ Percent Of Gross Amount Subject INT5_RBS2_U% Integer 2 5 32 GSTDSAMT GST Discount Amount DLR17_RBS0_STR$ Currency 10 17 33 POSTEDDT Posted Date DATE Date 4 6 34 PTDUSRID Posted User ID STR15 String 16 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 DT Date 4 8 36 MDFUSRID Modified User ID STR15 String 16 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 GB Integer 2 0 Click to show/hide Payment Entry Type
0 Check
1 Cash
2 Credit Card38 CARDNAME Card Name STR15_Card_Name String 16 15 39 PRCHAMNT Purchases Amount DLR17_RBS0_UTR$ Currency 10 17 40 TRDISAMT Trade Discount Amount DLR17_RBS0_UTR$ Currency 10 17 41 MSCCHAMT Misc Charges Amount DLR17_RBS0_UTR$ Currency 10 17 42 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 10 17 43 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 10 17 44 TTLPYMTS Total Payments DLR19_RBS0_UTR$ Currency 10 19 45 CURNCYID Currency ID STR15_Currency_ID String 16 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 STR20_Payment_Terms_ID String 22 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 STR15_Shipping_Method String 16 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 STR15_Tax_Schedule_ID String 16 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 STR15_LBAU String 16 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 STR15_LBAU String 16 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 STR15_LBAU String 16 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 DT Date 4 8 53 DISAVTKN Discount Available Taken DLR17_RBS0_UTR$ Currency 10 17 54 CNTRLTYP Control Type INT1 Integer 2 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 DLR14 Currency 10 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 INT5_%2 Integer 2 5 57 RETNAGAM Retainage Amount DLR17_RBS0_UTR$ Currency 10 17 58 VOIDPDATE Void GL Posting Date DT Date 4 8 59 ICTRX IC TRX CB_IC_TRX Boolean 2 0 Click to show/hide Intercompany flag
0 Not intercompany.
1 Intercompany60 Tax_Date Tax Date DT Date 4 8 61 PRCHDATE Purchase Date DT Date 4 8 62 CORRCTN Correction CB_Correction Boolean 2 0 63 SIMPLIFD Simplified CB_Simplified Boolean 2 0 64 USERID User ID STR15_User_ID String 16 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 INT Integer 2 0 66 Status Status INT Integer 2 0 67 STR1 STR1 STR1 String 2 1 68 DEX_ROW_ID int int 10 10