<taBRBankDepositsLine>
Element name |
Data type |
Length |
Required |
Default |
Description |
|---|---|---|---|---|---|
depositnumber |
string |
20 |
Y |
Not applicable |
Deposit number |
RCPTNMBR |
string |
20 |
N |
Default from setup |
Receipt number; used to find receipt in CM20300 table |
CHEKBKID |
string |
15 |
N |
Default from setup |
Checkbook ID; used to find receipt in CM20300 table |
RcpType |
i4 |
2 |
N |
Default from setup |
Receipt type: 1=Check; 2=Cash; 3=Credit Card |
CMRECNUM |
number |
21 |
N |
Default from setup |
Receipt number; use only if RCPTNMBR plus CHEKBKID plus RcpType are not unique |
DEPDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Deposit date; needs to match the taBRBankDepositsHeader if a multi currency transaction |
BANKNAME |
string |
30 |
N |
Default from setup |
Bank name |
BNKBRNCH |
string |
20 |
N |
Default from setup |
Bank branch |
CURRENCYTOTAL |
i4 |
4 |
N |
0 |
Originating currency total |
COINTOTAL |
number |
21 |
N |
0 |
Originating coin total |
XCHGRATE |
number |
21 |
N |
0 |
Exchange rate |
RATETPID |
string |
15 |
N |
<blank> |
Rate type ID |
EXPNDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Expiration date |
EXCHDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Exchange date |
EXGTBDSC |
string |
30 |
N |
<blank> |
Exchange ID description |
EXTBLSRC |
string |
50 |
N |
<blank> |
Exchange rate source |
RATEEXPR |
i4 |
2 |
N |
Default from setup |
Rate expiration: 0=None 1=Daily; 2=Weekly; 3=Biweekly; 4=Semimonthly; 5=Monthly; 6=Quarterly; 7=Annually; 8=Miscellaneous; 9=None; |
DYSTINCR |
i4 |
2 |
N |
Default from setup |
Days to increment; used only when RATEEXPR=8 |
RATEVARC |
number |
21 |
N |
0 |
Rate variance |
TRXDTDEF |
i4 |
2 |
N |
Default from setup |
Transaction date default: 0=Exact date; 1=Next date; 2=Previous date |
RTCLCMTD |
i4 |
2 |
N |
Default from setup |
Rate calculation method: 0=Multiply; 1=Divide |
PRVDSLMT |
i4 |
2 |
N |
0 |
Previous day's limit |
DATELMTS |
i4 |
2 |
N |
0 |
Date limits: 0=Unlimited; 1=Limited |
TIME1 |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
MC exchange time=Time 1 |
RequesterTrx |
i4 |
2 |
N |
0 |
Requester transaction: 0=False; 1=True (if true it populates the Requester shadow table) |
USRDEFND1 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND2 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND3 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND4 |
string |
8000 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND5 |
string |
8000 |
N |
<blank> |
User-defined field--developer use only |
This node uses document exchange for updates. All existing values are overwritten with the value specified by the update document. If a field in the update is blank, the existing value is changed to be blank.