| GLPOSTDT |
datetime
|
GLPostingDate GL Date that posts distributions when the transaction was posted
|
PAM30900.GLPOSTDT
|
|
|
| BCHSOURC |
char(15)
|
Batch Sour...(more) Join Now
|
|
|
|
| BACHNUMB |
char(15)
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| SERIES |
smallint
|
Series: I...(more) Join Now
|
SY00500.SERIES
|
|
|
| MKDTOPST |
tinyint
|
Marked To ...(more) Join Now
|
SY00500.MKDTOPST
|
|
|
| NUMOFTRX |
int
|
Number Of ...(more) Join Now
|
SY00500.NUMOFTRX
|
|
|
| RECPSTGS |
smallint
|
Recurring ...(more) Join Now
|
SY00500.RECPSTGS
|
|
|
| DELBACH |
tinyint
|
Delete Bat...(more) Join Now
|
SY00500.DELBACH
|
|
|
| MSCBDINC |
smallint
|
Misc Batch...(more) Join Now
|
SY00500.MSCBDINC
|
|
|
| BACHFREQ |
smallint
|
Batch Freq...(more) Join Now
|
SY00500.BACHFREQ
|
|
|
| RCLPSTDT |
datetime
|
Recurring ...(more) Join Now
|
SY00500.RCLPSTDT
|
|
|
| NOFPSTGS |
smallint
|
Number of ...(more) Join Now
|
SY00500.NOFPSTGS
|
|
|
| BCHCOMNT |
char(61)
|
Batch Comm...(more) Join Now
|
SY00500.BCHCOMNT
|
|
|
| BRKDNALL |
tinyint
|
Break Down...(more) Join Now
|
SY00500.BRKDNALL
|
|
|
| CHKSPRTD |
tinyint
|
Payables:
...(more) Join Now
|
SY00500.CHKSPRTD
|
|
|
| RVRSBACH |
tinyint
|
Payables:
...(more) Join Now
|
SY00500.RVRSBACH
|
|
|
| USERID |
char(15)
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| CHEKBKID |
char(15)
|
Checkbook ID Checkbook this transaction affects
|
SY30500.CHEKBKID
|
|
join ... more text available
|
| BCHTOTAL |
numeric(19,5)
|
Batch Tota...(more) Join Now
|
SY00500.BCHTOTAL
|
|
|
| BCHEMSG1 |
binary(4)
|
Batch Erro...(more) Join Now
|
SY00500.BCHEMSG1
|
|
|
| BCHEMSG2 |
binary(4)
|
Batch Erro...(more) Join Now
|
SY00500.BCHEMSG2
|
|
|
| BACHDATE |
datetime
|
Payables:
...(more) Join Now
|
SY00500.BACHDATE
|
|
|
| BCHSTRG1 |
char(21)
|
Payables
...(more) Join Now
|
SY00500.BCHSTRG1
|
|
|
| BCHSTRG2 |
char(21)
|
Batch Stri...(more) Join Now
|
SY00500.BCHSTRG2
|
|
|
| POSTTOGL |
tinyint
|
Post To GL...(more) Join Now
|
SY00500.POSTTOGL
|
|
|
| MODIFDT |
datetime
|
Date the r...(more) Join Now
|
|
|
|
| CREATDDT |
datetime
|
Created Da...(more) Join Now
|
RM00101.CREATDDT
|
|
|
| NOTEINDX |
numeric(19,5)
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| CURNCYID |
char(15)
|
Currency I...(more) Join Now
|
CM20000
|
|
join ... more text available
|
| BCHSTTUS |
smallint
|
Batch Stat...(more) Join Now
|
SY00500.BCHSTTUS
|
|
|
| CNTRLTRX |
int
|
Control TR...(more) Join Now
|
SY00500.CNTRLTRX
|
|
|
| CNTRLTOT |
numeric(19,5)
|
Payables:
...(more) Join Now
|
SY00500.CNTRLTOT
|
|
|
| Production_Control_Total |
numeric(19,5)
|
|
|
|
|
| PETRXCNT |
smallint
|
Posting Er...(more) Join Now
|
SY00500.PETRXCNT
|
|
|
| APPROVL |
tinyint
|
Approval: ...(more) Join Now
|
SY00500.APPROVL
|
|
|
| APPRVLDT |
datetime
|
Approval D...(more) Join Now
|
SY00500.APPRVLDT
|
|
|
| APRVLUSERID |
char(15)
|
Approval U...(more) Join Now
|
SY00500.APRVLUSERID
|
|
|
| ORIGIN |
smallint
|
Payables:
...(more) Join Now
|
SY00500.ORIGIN
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|