| DCSTATUS |
smallint
0
|
Document S...(more) Join Now
|
|
|
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
|
|
|
| VCHRNMBR |
char(21)
''
|
Voucher Nu...(more) Join Now
|
|
|
|
| PMNTNMBR |
char(21)
''
|
Payment Nu...(more) Join Now
|
|
|
|
| DOCDATE |
datetime
'1/1/1900'
|
Document D...(more) Join Now
|
|
|
|
| VENDORID |
char(15)
''
|
Vendor ID:...(more) Join Now
|
|
|
join ... more text available
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| 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: The ...(more) Join Now
|
|
|
|
| RTCLCMTD |
smallint
0
|
Rate calcu...(more) Join Now
|
|
|
|
| ORCTRXAM |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| OPURAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORFRTAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| OMISCAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORTAXAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORCASAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORCHKAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORCHKTTL |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORCCDAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORAPPAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORDISTKN |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORDATKN |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORDDLRAT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORTDISAM |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORWROFAM |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| OBKPURAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORBKTFRT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORBKTMSC |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| UNGANLOS |
numeric(19,5)
0.00
|
Unrealized...(more) Join Now
|
|
|
|
| RMMCERRS |
binary(4)
0
|
RM MC Post...(more) Join Now
|
|
|
|
| OCHGAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORDOCAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ODISAMTAV |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORGAPDISCTKN |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| OTOTPAY |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| OR1099AM |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| DENXRATE |
numeric(19,7)
0.00
|
Denominati...(more) Join Now
|
|
|
|
| MCTRXSTT |
smallint
0
|
MC Transac...(more) Join Now
|
|
|
|
| OrigBackoutTradeDisc |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|