PAertrxtype

i4

2

Y

Not applicable

PA employee expense transaction type:

1=Standard

2=Referenced

PAerdocnumber

string

17

Y

Not applicable

PA employee expense document number

EMPLOYID

string

15

Y

Not applicable

Employee ID

PADT

datetime

16

Y

Not applicable

PA date

PAPROJNUMBER

string

15

Y

Not applicable

PA project number

PACOSTCATID

string

15

Y

Not applicable

PA cost category ID

CURNCYID

string

15

Y

Not applicable

Currency ID

LNITMSEQ

i4

4

N

0

Line item sequence

PAitemnumber

string

31

N

<blank>

PA item number

PAREFNO

string

17

N

<blank>

PA reference document number

PAQtyQ

number

21

N

0

PA quantity

PAUnit_of_Measure

string

9

N

<blank>

PA unit of measure

UOMSCHDL

string

11

N

<blank>

Unit of measure schedule

PAUNITCOST

number

21

N

0

PA unit cost

PAPurchase_Tax_Options

i4

2

N

3

PA purchase tax options:

1=Taxable;

2=Nontaxable;

3=Based on vendor

ITMTSHID

string

15

N

<blank>

Item tax schedule ID

TAXAMNT

number

21

N

0

Tax amount

BCKTXAMT

number

21

N

0

Back out tax amount

PAPaymentMethod

i4

2

N

3

PA payment method: 1=Cash; 2=Company credit card; 3=Personal credit card

PAExpenseType

i4

2

N

1

PA expense type:

1=Reimbursable;

2=Personal expense

PAReference_Line_Seq_N

i4

4

N

0

PA reference line sequence number

PAbllngtype

i4

2

N

1

PA billing type:

1=Standard;

2=No charge;

3=No billing

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