PATSTYP

i4

2

Y

Not applicable

PA timesheet transaction type:

1=Standard;

2=Referenced

PATSNO

string

17

Y

Not applicable

PA timesheet number

PADOCDT

datetime

16

Y

Not applicable

PA document date

BACHNUMB

string

15

Y

Not applicable

Batch number

EMPLOYID

string

15

Y

Not applicable

Employee ID

PAREPD

i4

4

Y

Not applicable

PA reporting period

PAREPDT

datetime

16

Y

Not applicable

PA reporting period begin date

CURNCYID

string

15

Y

Not applicable

Currency ID

PAREFNO

string

17

N

<blank>

PA reference document number

PAreptsuff

string

5

N

<blank>

PA reporting suffix

PACOMM

string

51

N

<blank>

PA comment

PATQTY

number

21

N

0

PA total quantity

PAtotcosts

number

21

N

0

PA total costs

PATACRV

number

21

N

0

PA total accrued revenues

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 limits

DATELMTS

i4

2

N

0

Date limits:

0=Unlimited;

1=Limited

TIME1

datetime

16

N

<blank>

Time 1

USERID

string

15

N

<blank>

User ID

PDK_TS_No

string

31

N

<blank>

PDK timesheet number

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