BACHNUMB

string

15

Y

Not applicable

Batch number

JRNENTRY

i4

4

Y

Not applicable

Journal entry number

REFRENCE

string

30

Y

Not applicable

Reference

TRXDATE

datetime

16

Y

Not applicable

Transaction date

RVRSNGDT

datetime

16

N

<blank>

Reversing date

TRXTYPE

i4

2

Y

Not applicable

Transaction type:

0=Regular;

1=Reversing

SQNCLINE

number

21

N

0

Sequence line

SERIES

i4

2

N

2

Series:

1=All;

2=Financial;

3=Sales;

4=Purchasing;

5=Inventory;

6=Payroll;

7=Project

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 day's 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)

SOURCDOC

string

11

N

<blank>

Source document

Ledger_ID

i4

2

N

1

Ledger ID

1=Base,

2=IFRS,

3=Local

USERID

string

15

N

<blank>

User ID

NOTETEXT

string

8000

N

<blank>

Note text

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