Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AME20000
Product: MIS-AMS Extensions (3459)
Series: Purchasing
Display Name: AME PM Transactions
Physical Name: AME20000
Technical Name: AME_PM_TransactionsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DOCTYPE 
Document Type DDL_Document_Type Integer 0 Click to show/hide Document Types
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo2 VCHRNMBR Voucher Number STR20_LBAU String 20 Partial key to the PM Key Master File (PM00400).
Click to show/hide
SELECT
['AME PM Transactions'].VCHRNMBR AS 'AME PM Transactions-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
AME20000 AS ['AME PM Transactions']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['AME PM Transactions'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['AME PM Transactions'].DOCTYPE = ['PM Key Master File'].DOCTYPE3 VCHNUMWK Voucher Number - WORK STR17_LBAU String 17 4 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['AME PM Transactions'].VENDORID AS 'AME PM Transactions-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
AME20000 AS ['AME PM Transactions']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['AME PM Transactions'].VENDORID = ['PM Vendor Master File'].VENDORID5 DOCDATE Document Date DT Date 8 6 DOCNUMBR Document Number STR20_Document_Number String 20 7 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 19 8 CURTRXAM Current Trx Amount DLR17_RBS0_UTR$ Currency 17 9 DISCAMNT Discount Amount DLR17_RBS0_STR$ Currency 17 10 DISTKNAM Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 11 DSCDLRAM Discount Dollar Amount DLR11_RBS0_UTR$ Currency 11 12 BACHNUMB Batch Number STR15_LBAU String 15 13 TRXSORCE TRX Source STR13 String 13 14 BCHSOURC Batch Source STR15 String 15 15 DISCDATE Discount Date DT Date 8 16 DUEDATE Due Date DT Date 8 17 PORDNMBR Purchase Order Number Purchase Order Number String 20 18 DISAMTAV Discount Amount Available DLR17_RBS0_UTR$ Currency 17 19 TRXDSCRN Transaction Description STR30 String 30 20 VOIDED Voided CB Boolean 0 21 HOLD Hold CB_Hold Boolean 0 22 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['AME PM Transactions'].CHEKBKID AS 'AME PM Transactions-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
AME20000 AS ['AME PM Transactions']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['AME PM Transactions'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID23 DINVPDOF Date Invoice Paid Off DT Date 8 24 POSTEDDT Posted Date DATE Date 6 25 PTDUSRID Posted User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['AME PM Transactions'].PTDUSRID AS 'AME PM Transactions-Posted User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
AME20000 AS ['AME PM Transactions']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['AME PM Transactions'].PTDUSRID = ['Users Master'].USERID26 MODIFDT Modified Date DT Date 8 27 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['AME PM Transactions'].MDFUSRID AS 'AME PM Transactions-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
AME20000 AS ['AME PM Transactions']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['AME PM Transactions'].MDFUSRID = ['Users Master'].USERID28 PYENTTYP Payment Entry Type GB Integer 0 Click to show/hide Payment Entry Type
0 Check
1 Cash
2 Credit Card29 PRCHAMNT Purchases Amount DLR17_RBS0_UTR$ Currency 17 30 TRDISAMT Trade Discount Amount DLR17_RBS0_UTR$ Currency 17 31 MSCCHAMT Misc Charges Amount DLR17_RBS0_UTR$ Currency 17 32 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 17 33 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 34 TTLPYMTS Total Payments DLR19_RBS0_UTR$ Currency 19 35 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['AME PM Transactions'].CURNCYID AS 'AME PM Transactions-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
AME20000 AS ['AME PM Transactions']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['AME PM Transactions'].CURNCYID = ['Currency Setup'].CURNCYID36 PYMTRMID Payment Terms ID STR20_Payment_Terms_ID String 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['AME PM Transactions'].PYMTRMID AS 'AME PM Transactions-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
AME20000 AS ['AME PM Transactions']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['AME PM Transactions'].PYMTRMID = ['Payment Terms Master'].PYMTRMID37 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['AME PM Transactions'].NOTEINDX AS 'AME PM Transactions-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
AME20000 AS ['AME PM Transactions']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['AME PM Transactions'].NOTEINDX = ['Record Notes Master'].NOTEINDX38 PSTGDATE Posting Date DT Date 8 39 PRCHDATE Purchase Date DT Date 8 40 CISDOC CIS Document Type DDL_CIS_Verification Status Integer 0 41 CISIRVOU CIS IR Voucher Number STR30_LBAU String 30 42 Status Status INT Integer 0 43 CISSCOPE CIS In Scope CB_CIS_In_Scope Boolean 0 44 CISNONTAX CIS Non-taxable Amount DLR17_RBS0_UTR$ Currency 17 45 ORIGNONTAX CIS Original Non-taxable Amount DLR17_RBS0_UTR$ Currency 17 46 CISDEDUCT CIS Deducted DLR17_RBS0_STR$ Currency 17 47 NONREC MAV Non_Recoverable Amount DLR17_RBS0_UTR$ Currency 17 48 POPRCTNM POP Receipt Number STR17_POP_Number String 17 49 POPTYPE POP Type DDL_POP_Type Integer 0 50 JRNENTRY Journal Entry LI8_U0 Long Integer 8 51 Tax_Date Tax Date DT Date 8 52 CISVerificationStatus CISVerificationStatus DDL_CIS_Verification_Status Integer 0