Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM80950
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: PM Remittance Temp
Physical Name: PM80950
Technical Name: pmRemittanceTempSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BACHNUMB 
Batch Number String STR15_LBAU 15 2 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)
3 PMNTNMBR Payment Number String STR20_LBAU 20 4 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 5 DOCDATE Document Date Date DT 8 6 DOCNUMBR Document Number String STR20_Document_Number 20 7 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['PM Remittance Temp'].VENDORID AS 'PM Remittance Temp-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
PM80950 AS ['PM Remittance Temp']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PM Remittance Temp'].VENDORID = ['PM Vendor Master File'].VENDORID8 VENDNAME Vendor Name String STR64_Vendor_Name 64 9 VNDCHKNM Vendor Check Name String STR64_Vendor_Name 64 10 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PM Remittance Temp'].CURNCYID AS 'PM Remittance Temp-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PM80950 AS ['PM Remittance Temp']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PM Remittance Temp'].CURNCYID = ['Currency Setup'].CURNCYID11 VOIDED Voided Boolean CB 0 12 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 Memo13 CHKCOMNT Check Comment String STR60 60 14 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['PM Remittance Temp'].USERID AS 'PM Remittance Temp-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PM80950 AS ['PM Remittance Temp']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PM Remittance Temp'].USERID = ['Users Master'].USERID15 SEPRMTNC Seperate Remittance Boolean CB_Seperate_Remittance 0 16 ERROR Error Integer INT 0 17 Email_Type Email Type Integer INT 0 18 DOCAMNT Document Amount Currency DLR19_RBSO_UTR$ 19 19 PYMTTYPE Payment Type Integer DDL 0 20 Electronic Electronic Boolean CB_Electronic 0