DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..PM Payment WORK)

PM10300 unposted APPLY header. On line per PAYMENT

A payment record will be created only when a check is printed from the transaction entry window. The sole purpose of this record will be to store the check information for Report Writer. If you do not print any checks from the transaction entry window, you will not need to create any records for this table.

 

If an alignment form is printed, Dynamics will set values only for fields needed for keys and other required fields. All other fields will be filled with maximum values for amount fields or strings of X's for string fields.


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 = PM10300.BACHNUMB
BCHSOURCchar(15) Batch Sour...(more) Join Now
GP 9
PMNTNMBRchar(21) Payment Nu...(more) Join Now
GP 9
CHEKBKIDchar(15) Checkbook ID Checkbook this transaction affects PAM22222.CHEKBKID
GP 9
join CM00100 on CM00100.CHEKBKID = PM10300.CHEKBKID
DOCDATEdatetime Document D...(more) Join Now
GP 9
DOCNUMBRchar(21) Document N...(more) Join Now
GP 9
APPLDAMTnumeric(19,5) Applied Am...(more) Join Now
GP 9
CURTRXAMnumeric(19,5) Current Tr...(more) Join Now
GP 9
CHEKTOTLnumeric(19,5) Check Tota...(more) Join Now
GP 9
VENDORIDchar(15) Vendor ID:...(more) Join Now
GP 9
join PM00200 on PM00200.VENDORID = PM10300.VENDORID
VENDNAMEchar(65) Vendor Nam...(more) Join Now
GP 9
COMMENT1char(31) Comment1: ...(more) Join Now
GP 9
ADDRESS1char(61) Address 1:...(more) Join Now
GP 9
ADDRESS2char(61) Address 2:...(more) Join Now
GP 9
ADDRESS3char(61) Address 3:...(more) Join Now
GP 9
CITYchar(35) City: Chec...(more) Join Now
GP 9
STATEchar(29) State: Che...(more) Join Now
GP 9
ZIPCODEchar(11) Zip Code: ...(more) Join Now
GP 9
COUNTRYchar(61) Country: ...(more) Join Now
GP 9
VNDCHKNMchar(65) Vendor Che...(more) Join Now
GP 9
SOURCDOCchar(11) Source Doc...(more) Join Now
GP 9
DISTKNAMnumeric(19,5) Discount T...(more) Join Now
GP 9
DISAMTAVnumeric(19,5) Discount A...(more) Join Now
GP 9
WROFAMNTnumeric(19,5) Write Off ...(more) Join Now
GP 9
CURNCYIDchar(15) Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURNCYID = PM10300.CURNCYID
VOIDEDtinyint Voided: C...(more) Join Now
GP 9
REPRNTEDsmallint Reprinted:...(more) Join Now
GP 9
GSTDSAMTnumeric(19,5) GST Discou...(more) Join Now
GP 9
PGRAMSBJsmallint Percent Of...(more) Join Now
GP 9
PPSTAXRTsmallint PPS Tax Ra...(more) Join Now
GP 9
PPSAMDEDnumeric(19,5) PPS Amount...(more) Join Now
GP 9
LDOCRMTCsmallint List Docum...(more) Join Now
GP 9
SDORMBYsmallint Sort Docum...(more) Join Now
GP 9
KEYFIELDchar(21) Key Field:...(more) Join Now
GP 9
AMWDSNBRchar(61) Amount in ...(more) Join Now
GP 9
NOTEINDXnumeric(19,5) Note Index...(more) Join Now
GP 9
join SY03900 on SY03900.NOTEINDX = PM10300.NOTEINDX
VCHRNMBRchar(21) Voucher Nu...(more) Join Now
GP 9
CNTRLTYPsmallint Control Ty...(more) Join Now
GP 9
DOCTYPEsmallint Document T...(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 = PM10300.MDFUSRID
PSTGSTUSsmallint Posting St...(more) Join Now
GP 9
POSTEDDTdatetime Posted Dat...(more) Join Now
GP 9
PTDUSRIDchar(15) Posted Use...(more) Join Now
GP 9
PMWRKMSGbinary(4) PM WORK Me...(more) Join Now
GP 9
PMWRKMS2binary(4) PM WORK M...(more) Join Now
GP 9
PMDSTMSGbinary(4) PM Distrib...(more) Join Now
GP 9
CHKCOMNTchar(61) Check Comm...(more) Join Now
GP 9
PSTGDATEdatetime Posting Da...(more) Join Now
GP 9
STRGA255char(255) String A 2...(more) Join Now
GP 9
STRGB255char(255) String B 2...(more) Join Now
GP 9
SEPRMTNCtinyint Separate R...(more) Join Now
GP 9
STBOVRFLtinyint Stub Overf...(more) Join Now
GP 9
CTYSTZIPchar(47) City-State...(more) Join Now
GP 9
TotDocAmtnumeric(19,5) Total Docu...(more) Join Now
GP 9
TotAmtPaidnumeric(19,5) Total Amou...(more) Join Now
GP 9
TotCrdAmtnumeric(19,5) Total Cred...(more) Join Now
GP 9
TotalPaidTotnumeric(19,5) Total Paid...(more) Join Now
GP 9
TotNegTotnumeric(19,5) Total Nega...(more) Join Now
GP 9
TotCrdDocAmtnumeric(19,5) Total Cred...(more) Join Now
GP 9
TotTotDocAmtnumeric(19,5) Total Tota...(more) Join Now
GP 9
TotDiscTknAmtnumeric(19,5) Total Disc...(more) Join Now
GP 9
TotWOAmtnumeric(19,5) Total Writ...(more) Join Now
GP 9
TotPPSAmtDednumeric(19,5) Total PPS ...(more) Join Now
GP 9
TotGSTDiscAmtnumeric(19,5) Total GST ...(more) Join Now
GP 9
TotDiscTknTotnumeric(19,5) Total Disc...(more) Join Now
GP 9
TotWOTotnumeric(19,5) Total Writ...(more) Join Now
GP 9
Outstanding_Amountnumeric(19,5) Outstandin...(more) Join Now
GP 9
Net_Paid_Amountnumeric(19,5) Net Amount...(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
CARDNAMEchar
GP 2016
AMTINWDStext Amount in ...(more) Join Now
GP 9
PYENTTYPsmallint
GP 2016