DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
Module List > Module PM tables > PM00400

DynDeveloper Table Reference is now in Wiki format! Registered users have the ability to improve the table reference, add comments, and make the world a better place
You are currently viewing the COMPANY database.
Change

COMPANY..PM00400 Table Definition

(COMPANY..PM Key Master File)

The PM_Key_MSTR table is used to validate the uniqueness of control numbers in the system. A combination of the control number and control type ensure uniqueness. The control numbers used with transaction entry are Voucher Number - Work, Cash Amount Payment Number, Check Amount Payment Number, and Credit Card Amount Payment Number. The PM_Key_MSTR table also is used to ensure uniqueness for the Document Number and Check Number. The PM_Key_MSTR table will contain a record for the numbers it is tracking, no matter if they reside in work, open or history tables. A record will remain in the PM_Key_MSTR table until all transaction data for the control number it is tracking has been deleted (i.e. the transaction record, all distributions, all taxes).

 When a control number is initially entered, a PM_Key_MSTR table record is saved with the control number to prevent another user from using the same control number. This keys record will be given a Document Status of 0. This means the control number is reserved for use by an unsaved work record. When the transaction record is actually saved, this status will be changed to 1. As the transaction moves through the system, this status changes to reflect the current location. The other Document Status settings are 1 for work, 2 for open, and 3 for history.

In lieu of importing into the PM Key Master table, transactions can be imported into the Payables Transaction Work table, with an associated control number, and checklinks run on the Payables Transaction Logical table.  This will create the corresponding record in the PM Key Master table.

Display Name:              PM Key Master File

Physical Name:            PM00400

A keys record for the Voucher Number - WORK should be created first.  This record is also used to track Document Number uniqueness if Allow Duplicate Invoices of table PM_SETP is set to false.


4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
CNTRLNUMchar(21) Control Nu...(more) Join Now
GP 9
CNTRLTYPsmallint Control Ty...(more) Join Now
GP 9
DCSTATUSsmallint Document S...(more) Join Now
GP 9
DOCTYPEsmallint Document T...(more) Join Now
GP 9
VENDORIDchar(15) Vendor ID:...(more) Join Now
GP 9
join PM00200 on PM00200.VENDORID = PM00400.VENDORID
DOCNUMBRchar(21) Document N...(more) Join Now
GP 9
TRXSORCEchar(13) Transactio...(more) Join Now
GP 9
CHEKBKIDchar(15) Checkbook ID Checkbook this transaction affects PAM22222.CHEKBKID
GP 9
join CM00100 on CM00100.CHEKBKID = PM00400.CHEKBKID
DUEDATEdatetime Due Date: ...(more) Join Now
GP 9
DISCDATEdatetime Discount D...(more) Join Now
GP 9
BCHSOURCchar(15) Batch Sour...(more) Join Now
GP 9
DOCDATEdatetime Document D...(more) Join Now
GP 9
USERIDchar(15) The user t...(more) Join Now
GP 9
join DYNAMICS..SY01400 on SY01400.USERID = PM00400.USERID
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9