<taBRBankDepositsLine>


[spacer]

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

16

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

16

N

<blank>

Expiration date

EXCHDATE

datetime

16

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

16

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



Documentation Feedback