| CMRECNUM |
numeric(19,5)
0.00
|
|
|
|
|
| sRecNum |
char(21)
''
|
Record Num...(more) Join Now
|
|
|
|
| CNTRLTYP |
smallint
0
|
Control Ty...(more) Join Now
|
|
|
|
| DEPOSITED |
tinyint
0
|
Deposited ...(more) Join Now
|
|
|
|
| MDFUSRID |
char(15)
''
|
User that ...(more) Join Now
|
|
|
join ... more text available
|
| MODIFDT |
datetime
'1/1/1900'
|
Date the r...(more) Join Now
|
|
|
|
| CHEKBKID |
char(15)
''
|
Checkbook ...(more) Join Now
|
|
|
join ... more text available
|
| depositnumber |
char(21)
''
|
DepositNum...(more) Join Now
|
|
|
|
| RCPTNMBR |
char(21)
''
|
Receipt Nu...(more) Join Now
|
|
|
|
| receiptdate |
datetime
'1/1/1900'
|
Receipt Da...(more) Join Now
|
|
|
|
| RCPTAMT |
numeric(19,5)
0.00
|
Receipt Am...(more) Join Now
|
|
|
|
| RcpType |
smallint
0
|
ReceiptTyp...(more) Join Now
|
|
|
|
| CARDNAME |
char(15)
''
|
Credit Car...(more) Join Now
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| BANKNAME |
char(31)
''
|
Bank Name ...(more) Join Now
|
|
|
|
| BNKBRNCH |
char(21)
''
|
Bank Branc...(more) Join Now
|
|
|
|
| GLPOSTDT |
datetime
'1/1/1900'
|
GL Posting...(more) Join Now
|
|
|
|
| POSTEDDT |
datetime
'1/1/1900'
|
Posted Dat...(more) Join Now
|
|
|
|
| PTDUSRID |
char(15)
''
|
Posted Use...(more) Join Now
|
|
|
|
| CMLinkID |
char(15)
''
|
|
|
|
|
| RcvdFrom |
char(31)
''
|
Recieved F...(more) Join Now
|
|
|
|
| DSCRIPTN |
char(31)
''
|
Descriptio...(more) Join Now
|
|
|
|
| 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
|
|
|
|
| USERDEF1 |
char(21)
''
|
UserDefine...(more) Join Now
|
|
|
|
| USERDEF2 |
char(21)
''
|
UserDefine...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| RCRDSTTS |
smallint
0
|
RecordStat...(more) Join Now
|
|
|
|
| SOURCDOC |
char(11)
''
|
SourceDocu...(more) Join Now
|
|
|
|
| SRCDOCNUM |
char(21)
''
|
|
|
|
|
| SRCDOCTYP |
smallint
0
|
|
|
|
|
| AUDITTRAIL |
char(13)
''
|
Audit Trai...(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
|
|
|
|
| RCVGRATETPID |
char(15)
''
|
|
|
|
|
| EXGTBLID |
char(15)
''
|
Exchange T...(more) Join Now
|
|
|
|
| XCHGRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
|
|
|
| Receiving_Exchange_Rate |
numeric(19,7)
0.00
|
Receiving ...(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
|
|
|
|
| RCVGRTCLCMTD |
smallint
0
|
|
|
|
|
| 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
|
|
|
|
| RLGANLOS |
numeric(19,5)
0.00
|
Realized G...(more) Join Now
|
|
|
|
| Cash_Account_Index |
int
0
|
Cash Accou...(more) Join Now
|
|
|
|
| Realized_GL_Account_Inde |
int
0
|
Realized G...(more) Join Now
|
|
|
|
| DENXRATE |
numeric(19,7)
0.00
|
Denominati...(more) Join Now
|
|
|
|
| MCTRXSTT |
smallint
0
|
MC Transac...(more) Join Now
|
|
|
|
| Receiving_DenomEXRate |
numeric(19,7)
0.00
|
Receiving ...(more) Join Now
|
|
|
|
| Receiving_MC_Transaction |
smallint
0
|
Receiving ...(more) Join Now
|
|
|
|
| PMNTNMBR |
char(21)
''
|
Payment Nu...(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
|
|
|
|