PM00400 - PM Key Master File
Dynamics GP table PM00400 (PM Key Master File) contains 13 columns including CNTRLNUM, CNTRLTYP, DCSTATUS....
SQL Query Builder
13 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| CNTRLNUM | Control Number | String | 22 | ||
| CNTRLTYP | Control Type | Integer | 2 | ||
Control Type values (3) 0 = Voucher types1 = Payment types2 = Printed alignment forms | |||||
| DCSTATUS | Document Status1 = Work2 = Open3 = History | Integer | 2 | ||
Document Status values (4) 0 = Reserved1 = Work (unposted)2 = Open (posted, not fully applied)3 = History (fully applied/paid) | |||||
| DOCTYPE | Document Type | Integer | 2 | ||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| VENDORID | Vendor ID | String | 16 | ||
| DOCNUMBR | Document Number | String | 22 | ||
| TRXSORCE | TRX Source | String | 14 | ||
| CHEKBKID | Checkbook ID | String | 16 | ||
| DUEDATE | Due Date | Date | 4 | ||
| DISCDATE | Discount Date | Date | 4 | ||
| BCHSOURC | Batch Source | String | 16 | ||
| DOCDATE | Document Date | Date | 4 | ||
| USERID | User ID | String | 16 | ||
Related Tables
Tables that share columns with PM00400. Click "Join" to add to your query.