CUSTNMBR

string

15

Y

Not applicable

Customer number

DOCNUMBR

string

20

Y

Not applicable

Document number

DOCDATE

datetime

16

Y

Not applicable

Document date

ORTRXAMT

number

21

Y

Not applicable

Transaction amount

GLPOSTDT

datetime

16

Y

Not applicable

GL posting date

BACHNUMB

string

15

Y

Not applicable

Batch number

CSHRCTYP

i4

2

Y

Not applicable

Cash receipt type

0=Check

1=Cash

2=Credit card

CHEKBKID

string

15

N

<blank>

Checkbook ID

CHEKNMBR

string

20

N

<blank>

Check number or credit card number

CRCARDID

string

15

N

<blank>

Credit card ID

TRXDSCRN

string

30

N

<blank>

Transaction description

LSTUSRED

string

15

N

<blank>

Last user to edit

BatchCHEKBKID

string

15

N

<blank>

Checkbook ID for the batch

CURNCYID

string

15

N

<blank>

Currency ID

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—only used 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 limits

DATELMTS

i4

2

N

0

Date limits:

0=Unlimited;

1=Limited

TIME1

datetime

16

N

<blank>

Time 1

CREATEDIST

i4

2

N

1

Flag to automatically create distributions:

0=Manual;

1=Automatic

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