DynDeveloper.com

DynDeveloper.com

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

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..PM10400 Table Definition

(COMPANY..PM Manual Payment WORK File)

The PM_Manual_Payment_WORK table is the primary storage area for manual payments. It contains fields linking it to the Batch_Headers table where batch information is stored, to the PM_Keys_MSTR table where used payment numbers are stored, and to the CM_Checkbook_MSTR table where Document Numbers are stored. All of these tables must be maintained as to ensure unique control ID values. If Multicurrency is registered and the Currency ID of the payment does not match the functional currency then the MC_PM_Transactions table will also contain a record for this payment.


4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
BACHNUMBchar(15) Batch Numb...(more) Join Now
GP 9
join SY00500 on SY00500.BACHNUMB = PM10400.BACHNUMB
BCHSOURCchar(15) Batch Sour...(more) Join Now
GP 9
PMNTNMBRchar(21) Payment Nu...(more) Join Now
GP 9
VENDORIDchar(15) Vendor ID:...(more) Join Now
GP 9
join PM00200 on PM00200.VENDORID = PM10400.VENDORID
DOCNUMBRchar(21) Document N...(more) Join Now
GP 9
DOCTYPEsmallint Document T...(more) Join Now
GP 9
DOCAMNTnumeric(19,5) Document A...(more) Join Now
GP 9
DOCDATEdatetime Document D...(more) Join Now
GP 9
PSTGDATEdatetime Posting Da...(more) Join Now
GP 9
PYENTTYPsmallint Payment En...(more) Join Now
GP 9
CHEKAMNTnumeric(19,5) Check Amou...(more) Join Now
GP 9
CARDNAMEchar(15) Card Name:...(more) Join Now
GP 9
CURNCYIDchar(15) Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURNCYID = PM10400.CURNCYID
CHEKBKIDchar(15) Checkbook ID Checkbook this transaction affects PAM22222.CHEKBKID
GP 9
join CM00100 on CM00100.CHEKBKID = PM10400.CHEKBKID
TRXDSCRNchar(31) Transactio...(more) Join Now
GP 9
DISAMTAVnumeric(19,5) Discount A...(more) Join Now
GP 9
DISTKNAMnumeric(19,5) Discount T...(more) Join Now
GP 9
WROFAMNTnumeric(19,5) Writeoff A...(more) Join Now
GP 9
CURTRXAMnumeric(19,5) Current Tr...(more) Join Now
GP 9
APPLDAMTnumeric(19,5) Applied Am...(more) Join Now
GP 9
PMWRKMSGbinary(4) PM WORK Me...(more) Join Now
GP 9
PMWRKMS2binary(4) PM WORK Me...(more) Join Now
GP 9
PMDSTMSGbinary(4) PM Distrib...(more) Join Now
GP 9
GSTDSAMTnumeric(19,5) GST Discou...(more) Join Now
GP 9
PPSAMDEDnumeric(19,5) PPS Amount...(more) Join Now
GP 9
PPSTAXRTsmallint PPS Tax Ra...(more) Join Now
GP 9
PGRAMSBJsmallint Percent Of...(more) Join Now
GP 9
NOTEINDXnumeric(19,5) Note Index...(more) Join Now
GP 9
join SY03900 on SY03900.NOTEINDX = PM10400.NOTEINDX
VCHRNMBRchar(21) Voucher Nu...(more) Join Now
GP 9
CNTRLTYPsmallint Control Ty...(more) Join Now
GP 9
MODIFDTdatetime Date the r...(more) Join Now
GP 9
MDFUSRIDchar(15) User that ...(more) Join Now
GP 9
join DYNAMICS..SY01400 on SY01400.USERID = PM10400.MDFUSRID
POSTEDDTdatetime Posted Dat...(more) Join Now
GP 9
PTDUSRIDchar(15) Posted Use...(more) Join Now
GP 9
RETNAGAMnumeric(19,5) Retainage ...(more) Join Now
GP 9
Electronictinyint Electronic...(more) Join Now
GP 9
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9
PONUMBERchar PAM_VMS_MAPPINGS.PONumber
GP 2013