Module List > Module PA tables PA30000
You are currently viewing the COMPANY database.
Change

COMPANY..PA30000 Table Definition

(COMPANY..PA Posting Definitions Master History)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
GLPOSTDT datetime
'1/1/1900'
Date that ...(more) Join Now
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
BACHNUMB char(15)
''
Batch Numb...(more) Join Now UPR10304.BACHNUMB
join ... more text available
SERIES smallint
0
Series: I...(more) Join Now SY00500.SERIES
MKDTOPST tinyint
0

NUMOFTRX int
0
Number Of ...(more) Join Now SY00500.NUMOFTRX
RECPSTGS smallint
0
Recurring ...(more) Join Now SY00500.RECPSTGS
DELBACH tinyint
0
Delete Bat...(more) Join Now SY00500.DELBACH
MSCBDINC smallint
0
Misc Batch...(more) Join Now SY00500.MSCBDINC
BACHFREQ smallint
0
Batch Freq...(more) Join Now SY00500.BACHFREQ
RCLPSTDT datetime
'1/1/1900'
Recurring ...(more) Join Now SY00500.RCLPSTDT
NOFPSTGS smallint
0
Number of ...(more) Join Now SY00500.NOFPSTGS
BCHCOMNT char(61)
''
Batch Comm...(more) Join Now SY00500.BCHCOMNT
BRKDNALL tinyint
0
Break Down...(more) Join Now SY00500.BRKDNALL
CHKSPRTD tinyint
0
Payables: ...(more) Join Now SY00500.CHKSPRTD
RVRSBACH tinyint
0
Payables: ...(more) Join Now SY00500.RVRSBACH
USERID char(15)
''
The user t...(more) Join Now WRS10001.USERID
join ... more text available
CHEKBKID char(15)
''
Checkbook ID Checkbook this transaction affects SY30500.CHEKBKID
join ... more text available
BCHTOTAL numeric(19,5)
0.00
Batch Tota...(more) Join Now SY00500.BCHTOTAL
BCHEMSG1 binary(4)
0
Batch Erro...(more) Join Now SY00500.BCHEMSG1
BCHEMSG2 binary(4)
0
Batch Erro...(more) Join Now SY00500.BCHEMSG2
BACHDATE datetime
'1/1/1900'

BCHSTRG1 char(21)
''
Payables ...(more) Join Now SY00500.BCHSTRG1
BCHSTRG2 char(21)
''
Batch Stri...(more) Join Now SY00500.BCHSTRG2
POSTTOGL tinyint
0
Post To GL...(more) Join Now SY00500.POSTTOGL
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now WDC41400.MODIFDT
CREATDDT datetime
'1/1/1900'
Date this ...(more) Join Now RM00102.CREATDDT
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
CURNCYID char(15)
''
Currency I...(more) Join Now MC40200.CURNCYID
join ... more text available
BCHSTTUS smallint
0
Batch Stat...(more) Join Now SY00500.BCHSTTUS
CNTRLTRX int
0
Control TR...(more) Join Now SY00500.CNTRLTRX
CNTRLTOT numeric(19,5)
0.00
Payables: ...(more) Join Now SY00500.CNTRLTOT
PETRXCNT smallint
0
Posting Er...(more) Join Now SY00500.PETRXCNT
APPROVL tinyint
0
Approval: ...(more) Join Now SY30500.APPROVL
APPRVLDT datetime
'1/1/1900'
Approval D...(more) Join Now
APRVLUSERID char(15)
''
Approval U...(more) Join Now SY30500.APRVLUSERID
ORIGIN smallint
0
Payables: ...(more) Join Now SY00500.ORIGIN
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3