| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
|
| POSTEDDT |
datetime
'1/1/1900'
|
Posted Dat...(more) Join Now
|
|
|
|
| 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
|
|
|
join ... more text available
|
| CHEKBKID |
char(15)
''
|
Checkbook ID Checkbook this transaction affects
|
SY30500.CHEKBKID
|
|
join ... more text available
|
| NUMOFTRX |
int
0
|
Number Of ...(more) Join Now
|
SY00500.NUMOFTRX
|
|
|
| RECPSTGS |
smallint
0
|
Recurring ...(more) Join Now
|
SY00500.RECPSTGS
|
|
|
| MSCBDINC |
smallint
0
|
Misc Batch...(more) Join Now
|
SY00500.MSCBDINC
|
|
|
| BACHFREQ |
smallint
0
|
Batch Freq...(more) Join Now
|
SY00500.BACHFREQ
|
|
|
| NOFPSTGS |
smallint
0
|
Number of ...(more) Join Now
|
SY00500.NOFPSTGS
|
|
|
| BCHCOMNT |
char(61)
''
|
Batch Comm...(more) Join Now
|
SY00500.BCHCOMNT
|
|
|
| USERID |
char(15)
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| RCDSRMVD |
tinyint
0
|
|
|
|
|
| BCHTOTAL |
numeric(19,5)
0.00
|
Batch Tota...(more) Join Now
|
SY00500.BCHTOTAL
|
|
|
| CNTRLTRX |
int
0
|
Control TR...(more) Join Now
|
SY00500.CNTRLTRX
|
|
|
| CNTRLTOT |
numeric(19,5)
0.00
|
Payables:
...(more) Join Now
|
SY00500.CNTRLTOT
|
|
|
| APPROVL |
tinyint
0
|
Approval: ...(more) Join Now
|
SY00500.APPROVL
|
|
|
| APPRVLDT |
datetime
'1/1/1900'
|
Approval D...(more) Join Now
|
SY00500.APPRVLDT
|
|
|
| APRVLUSERID |
char(15)
''
|
Approval U...(more) Join Now
|
SY00500.APRVLUSERID
|
|
|
| Workflow_Approval_Status |
smallint
0
|
Time: Time...(more) Join Now
|
SY00500.Workflow_Approval_Status
|
|
|
| Workflow_Priority |
smallint
0
|
Workflow A...(more) Join Now
|
SY00500.Workflow_Priority
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| Workflow_Status |
smallint
0
|
|
|
|
|
| CREATDDT |
datetime
'1/1/1900'
|
Date this ...(more) Join Now
|
RM00102.CREATDDT
|
|
|
| TIME1 |
datetime
'1/1/1900'
|
Time Time...(more) Join Now
|
WO010213.TIME1
|
|
|