DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..PM Payment Stub Duplicate)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
PMNTNMBRchar(21) Payment Nu...(more) Join Now CM20300.PMNTNMBR
GP 9
SEQNUMBRint Sequence N...(more) Join Now DTA10200.SEQNUMBR
GP 9
DSTSQNUMint Distributi...(more) Join Now CM20400.DSTSQNUM
GP 9
DiscTknTotnumeric(19,5)
GP 9
NetCkAmtnumeric(19,5)
GP 9
PdTotnumeric(19,5)
GP 9
NegTotnumeric(19,5)
GP 9
CrdDocAmtnumeric(19,5)
GP 9
TotDocAmtnumeric(19,5)
GP 9
WrOffTotnumeric(19,5)
GP 9
CrdtDescchar(31) PAM50101.CrdtDesc
GP 9
TRXDSCRNchar(31) Transactio...(more) Join Now
GP 9
PrtOnStbtinyint
GP 9
APTVCHNMchar(21)
GP 9
DOCNUMBRchar(21) Document N...(more) Join Now PM10000.DOCNUMBR
GP 9
DOCDATEdatetime The date a...(more) Join Now
GP 9
AMNTPAIDnumeric(19,5) Amount Pai...(more) Join Now SOP10103.AMNTPAID
GP 9
CRDTAMNTnumeric(19,5) Credit Amo...(more) Join Now GL10001.CRDTAMNT
GP 9
DocDueDatedatetime
GP 9
DOCAMNTnumeric(19,5) Source Doc...(more) Join Now PM10000.DOCAMNT
GP 9
DISCDATEdatetime Discount D...(more) Join Now PM10000.DISCDATE
GP 9
DISTKNAMnumeric(19,5) Discount T...(more) Join Now
GP 9
WROFAMNTnumeric(19,5) Write Off ...(more) Join Now
GP 9
PPSAMDEDnumeric(19,5) PPS Amount...(more) Join Now
GP 9
GSTDSAMTnumeric(19,5) GST Discou...(more) Join Now
GP 9
APFVCHNMchar(21)
GP 9
APFRDCTYsmallint RM20201.APFRDCTY
GP 9
APTODCTYsmallint
GP 9
CURNCYIDchar(15) Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURNCYID = PM10801.CURNCYID
Outstanding_Amountnumeric(19,5)
GP 9
Net_Paid_Amountnumeric(19,5)
GP 9
VCHRNMBRchar(21) Voucher Nu...(more) Join Now
GP 9
PONUMBERchar PAM_VMS_MAPPINGS.PONumber
GP 2013
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9