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 | SQL DB Length | Keyable Length |
|---|---|---|---|---|---|---|
| 1 | TRXSORCE  | TRX Source | STR13 | String | 14 | 13 |
| 2 | VCHRNMBR | Voucher Number | STR20_LBAU | String | 22 | 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 | DDL_Document_Type | Integer | 2 | 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 | STR20_LBAU | String | 22 | 20 |
| 5 | CHEKDATE | Check Date | DATE | Date | 4 | 6 |
| 6 | CHEKNMBR | Check Number | STR20_Document_Number | String | 22 | 20 |
| 7 | CHAMCBID | Check Amount Checkbook ID | STR15_Checkbook_ID | String | 16 | 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 | DLR19_RBS0_UTR$ | Currency | 10 | 19 |
| 9 | DEX_ROW_ID | int | int | 10 | 10 | |
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. | ||||||