| CMRECNUM |
numeric(19,5)
0.00
|
|
|
|
|
| sRecNum |
char(21)
''
|
Record Num...(more) Join Now
|
|
|
|
| RCRDSTTS |
smallint
0
|
RecordStat...(more) Join Now
|
|
|
|
| CHEKBKID |
char(15)
''
|
Checkbook ...(more) Join Now
|
|
|
join ... more text available
|
| CMTrxNum |
char(21)
''
|
CMTrxNumbe...(more) Join Now
|
|
|
|
| CMTrxType |
smallint
0
|
p>CMTrxTyp...(more) Join Now
|
|
|
|
| TRXDATE |
datetime
'1/1/1900'
|
|
|
|
|
| GLPOSTDT |
datetime
'1/1/1900'
|
GL Posting...(more) Join Now
|
|
|
|
| TRXAMNT |
numeric(19,5)
0.00
|
TrxAmount ...(more) Join Now
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| CMLinkID |
char(15)
''
|
|
|
|
|
| paidtorcvdfrom |
char(65)
''
|
Paid ToRcv...(more) Join Now
|
|
|
|
| DSCRIPTN |
char(31)
''
|
Descriptio...(more) Join Now
|
|
|
|
| Recond |
tinyint
0
|
Reconciled...(more) Join Now
|
|
|
|
| RECONUM |
numeric(19,5)
0.00
|
|
|
|
|
| ClrdAmt |
numeric(19,5)
0.00
|
|
|
|
|
| clearedate |
datetime
'1/1/1900'
|
|
|
|
|
| VOIDED |
tinyint
0
|
Voided Tru...(more) Join Now
|
|
|
|
| VOIDDATE |
datetime
'1/1/1900'
|
Void Date ...(more) Join Now
|
|
|
|
| VOIDPDATE |
datetime
'1/1/1900'
|
Void GL Po...(more) Join Now
|
|
|
|
| VOIDDESC |
char(31)
''
|
Void Descr...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| AUDITTRAIL |
char(13)
''
|
Audit Trai...(more) Join Now
|
|
|
|
| DEPTYPE |
smallint
0
|
|
|
|
|
| SOURCDOC |
char(11)
''
|
SourceDocu...(more) Join Now
|
|
|
|
| SRCDOCTYP |
smallint
0
|
|
|
|
|
| SRCDOCNUM |
char(21)
''
|
|
|
|
|
| POSTEDDT |
datetime
'1/1/1900'
|
Posted Dat...(more) Join Now
|
|
|
|
| PTDUSRID |
char(15)
''
|
Posted Use...(more) Join Now
|
|
|
|
| MODIFDT |
datetime
'1/1/1900'
|
Date the r...(more) Join Now
|
|
|
|
| MDFUSRID |
char(15)
''
|
User that ...(more) Join Now
|
|
|
join ... more text available
|
| USERDEF1 |
char(21)
''
|
UserDefine...(more) Join Now
|
|
|
|
| USERDEF2 |
char(21)
''
|
UserDefine...(more) Join Now
|
|
|
|
| ORIGAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| Checkbook_Amount |
numeric(19,5)
0.00
|
Checkbook ...(more) Join Now
|
|
|
|
| RATETPID |
char(15)
''
|
Rate Type ...(more) Join Now
|
|
|
|
| EXGTBLID |
char(15)
''
|
Exchange T...(more) Join Now
|
|
|
|
| XCHGRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
|
|
|
| EXCHDATE |
datetime
'1/1/1900'
|
Exchange D...(more) Join Now
|
|
|
|
| TIME1 |
datetime
'1/1/1900'
|
Time see ...(more) Join Now
|
|
|
|
| RTCLCMTD |
smallint
0
|
Rate Calcu...(more) Join Now
|
|
|
|
| EXPNDATE |
datetime
'1/1/1900'
|
Expiration...(more) Join Now
|
|
|
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| DECPLCUR |
smallint
0
|
Number of ...(more) Join Now
|
|
|
|
| DENXRATE |
numeric(19,7)
0.00
|
Denominati...(more) Join Now
|
|
|
|
| MCTRXSTT |
smallint
0
|
MC Transac...(more) Join Now
|
|
|
|
| Xfr_Record_Number |
numeric(19,5)
0.00
|
Xfr Record...(more) Join Now
|
|
|
|
| EFTFLAG |
tinyint
0
|
EFT Flag T...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|