| 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
|
|
|
|