DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..Reprint Transaction Batch Headers)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
TRXSORCEchar(13) Transactio...(more) Join Now
GP 9
POSTEDDTdatetime Posted Dat...(more) Join Now
GP 9
GLPOSTDTdatetime Date that ...(more) Join Now
GP 9
BCHSOURCchar(15) Batch Sour...(more) Join Now
GP 9
BACHNUMBchar(15) Batch Numb...(more) Join Now
GP 9
join SY00500 on SY00500.BACHNUMB = PM80100.BACHNUMB
CHEKBKIDchar(15) Checkbook ID Checkbook this transaction affects PAM22222.CHEKBKID
GP 9
join CM00100 on CM00100.CHEKBKID = PM80100.CHEKBKID
NUMOFTRXint Number Of ...(more) Join Now SY00500.NUMOFTRX
GP 9
RECPSTGSsmallint Recurring ...(more) Join Now SY00500.RECPSTGS
GP 9
MSCBDINCsmallint Misc Batch...(more) Join Now SY00500.MSCBDINC
GP 9
BACHFREQsmallint Batch Freq...(more) Join Now SY00500.BACHFREQ
GP 9
NOFPSTGSsmallint Number of ...(more) Join Now SY00500.NOFPSTGS
GP 9
BCHCOMNTchar(61) Batch Comm...(more) Join Now SY00500.BCHCOMNT
GP 9
USERIDchar(15) The user t...(more) Join Now
GP 9
join DYNAMICS..SY01400 on SY01400.USERID = PM80100.USERID
NOTEINDXnumeric(19,5) Note Index...(more) Join Now
GP 9
join SY03900 on SY03900.NOTEINDX = PM80100.NOTEINDX
RCDSRMVDtinyint
GP 9
BCHTOTALnumeric(19,5) Batch Tota...(more) Join Now SY00500.BCHTOTAL
GP 9
CNTRLTRXint Control TR...(more) Join Now SY00500.CNTRLTRX
GP 9
CNTRLTOTnumeric(19,5) Payables: ...(more) Join Now SY00500.CNTRLTOT
GP 9
APPROVLtinyint Approval: ...(more) Join Now SY00500.APPROVL
GP 9
APPRVLDTdatetime Approval D...(more) Join Now SY00500.APPRVLDT
GP 9
APRVLUSERIDchar(15) Approval U...(more) Join Now SY00500.APRVLUSERID
GP 9
Workflow_Approval_Statussmallint Time: Time...(more) Join Now SY00500.Workflow_Approval_Status
GP 10
Workflow_Prioritysmallint Workflow A...(more) Join Now SY00500.Workflow_Priority
GP 10
Workflow_Statussmallint
GP 2013
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9
CREATDDTdatetime SY01400.CREATDDT
GP 2013
TIME1datetime
GP 2013