PATSTYP

i4

2

Y

Not applicable

PA timesheet transaction type:

1=Standard;

2=Referenced

PATSNO

string

17

Y

Not applicable

PA timesheet number

EMPLOYID

string

15

Y

Not applicable

Employee ID

CURNCYID

string

15

Y

Not applicable

Currency ID

PAREFNO

string

17

N

<blank>

PA reference document number

LNITMSEQ

i4

4

N

0

Line item sequence

PADT

datetime

16

Y

Not applicable

PA date

PAPROJNUMBER

number

21

Y

Not applicable

Project ID

PACOSTCATID

string

15

Y

Not applicable

Cost category ID

PATB

datetime

16

N

<blank>

PA time begin

PATE

datetime

16

N

<blank>

PA time end

PAQtyQ

number

21

N

0

PA quantity

PAbllngtype

i4

2

N

1

PA billing type:

1=Standard;

2=No charge;

3=No billing

PAUnit_of_Measure

string

9

N

<blank>

PA unit of measure

PAUNITCOST

number

21

N

Default from setup

PA unit cost

PAPayCode

string

7

N

<blank>

PA pay code

PADepartment

string

7

N

<blank>

PA department

PAJob_Title

string

7

N

<blank>

PA job title

PATOTCST

number

21

N

0

PA total cost

PASalary_Posting_Type

i4

2

N

0

PA salary posting type:

0=No post;

1=Reallocate dollars;

2=Reallocate hours;

3=Additional amount

RequesterTrx

i4

2

N

0

Requester transaction:

0=False;

1=True (if True, it populates the requester shadow table)

PAtx500

string

8000

N

<blank>

PA billing 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