Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
depositnumber | Deposit Number |
String | 22 | View | |
CHEKBKID | Checkbook ID |
String | 16 | View | |
CURNCYID | Currency ID |
String | 16 | View | |
CMRECNUM | Record Number |
Currency | 10 | View | |
CURRNIDX | Currency Index |
Integer | 2 | View | |
RATETPID | Rate Type ID |
String | 16 | View | |
EXGTBLID | Exchange Table ID |
String | 16 | View | |
XCHGRATE | Exchange Rate |
Currency (Variable) | 10 | View | |
EXCHDATE | Exchange Date |
Date | 4 | View | |
TIME1 | Time |
Time | 4 | View | |
RTCLCMTD | Rate Calculation Method |
Integer | 2 | View | |
EXPNDATE | Expiration Date |
Date | 4 | View | |
DECPLCUR | Decimal Places Currency |
Integer | 2 | View | |
RCPTCOUNT | ReceiptCount |
Integer | 2 | View | |
ORCHKTTL | Originating Check Total |
Currency | 10 | View | |
Originating_Check_Count | Originating Check Count |
Integer | 2 | View | |
Orig_Credit_Card_Total | Originating Credit Card Total |
Currency | 10 | View | |
Originating_Credit_Card_ | Originating Credit Card Count |
Integer | 2 | View | |
Originating_Cash_Total | Originating Cash Total |
Currency | 10 | View | |
Originating_Cash_Count | Originating Cash Count |
Integer | 2 | View | |
Originating_Coin_Amount | Originating Coin Amount |
Currency | 10 | View | |
Originating_Deposit_Amou | Originating Deposit Amount |
Currency | 10 | View | |
Originating_Checkbook_Am | Originating Checkbook Amount |
Currency | 10 | View | |
DENXRATE | Denomination Exchange Rate |
Currency (Variable) | 10 | View | |
MCTRXSTT | MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. |
Integer | 2 | View |