BACHNUMB

string

15

Y

Not applicable

Batch number

JRNENTRY

i4

4

Y

Not applicable

Journal entry number

SQNCLINE

number

21

N

0

Sequence line

ACTINDX

i4

4

N

0

Account index

CRDTAMNT

number

21

Y

Not applicable

Credit amount

DEBITAMT

number

21

Y

Not applicable

Debit amount

ACTNUMST

string

75

N

<blank>

Account string

DSCRIPTN

string

30

N

<blank>

Description

ORCTRNUM

string

20

N

<blank>

Originating control number

ORDOCNUM

string

20

N

<blank>

Originating document number

ORMSTRID

string

30

N

<blank>

Originating master ID

ORMSTRNM

string

64

N

<blank>

Originating master name

ORTRXTYP

i4

2

N

0

Originating transaction type

OrigSeqNum

i4

4

N

0

Originating sequence number

ORTRXDESC

string

30

N

<blank>

Originating transaction description

TAXDTLID

string

15

N

<blank>

Tax detail ID

TAXAMNT

number

21

N

0

Tax amount

TAXACTNUMST

string

75

N

<blank>

Tax account string

DOCDATE

datetime

16

N

<blank>

Document date

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=Bi-weekly;

4=Semiweekly;

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 days limits

DATELMTS

i4

2

N

0

Date limits:

0=Unlimited;

1=Limited

TIME1

datetime

16

N

<blank>

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