Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM80800
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: PM Reprint Transaction Check Register File Group Display Name: Payables Reprint Journals Logical File
Physical Name: PM80800
Technical Name: PM_Reprint_Transaction_Check
Group Technical Name: PM_Reprint_Journals_Logical_File
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | TRXSORCE  | TRX Source | String | STR13 | 13 | |
| 2 | VCHRNMBR | Voucher Number | String | STR20_LBAU | 20 | |
Partial key to the PM Key Master File (PM00400).
Click to show/hideSELECT
['PM Reprint Transaction Check Register File'].VCHRNMBR AS 'PM Reprint Transaction Check Register File-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
PM80800 AS ['PM Reprint Transaction Check Register File']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['PM Reprint Transaction Check Register File'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['PM Reprint Transaction Check Register File'].DOCTYPE = ['PM Key Master File'].DOCTYPE | ||||||
| 3 | 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 | ||||||
| 4 | CAMPYNBR | Check Amount Payment Number | String | STR20_LBAU | 20 | |
| 5 | CHEKDATE | Check Date | Date | DATE | 6 | |
| 6 | CHEKNMBR | Check Number | String | STR20_Document_Number | 20 | |
| 7 | CHAMCBID | Check Amount Checkbook ID | String | STR15_Checkbook_ID | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['PM Reprint Transaction Check Register File'].CHAMCBID AS 'PM Reprint Transaction Check Register File-Check Amount Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
PM80800 AS ['PM Reprint Transaction Check Register File']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['PM Reprint Transaction Check Register File'].CHAMCBID = ['CM Checkbook Master'].CHEKBKID | ||||||
| 8 | CHEKAMNT | Check Amount | Currency | DLR19_RBS0_UTR$ | 19 | |