PSMISCLTRXTYPE

i4

2

Y

Not applicable

PA miscellaneous transaction type:

1=Standard;

2=Referenced

PAMISCLDOCNO

string

17

Y

Not applicable

PA miscellaneous log number

PADOCDT

datetime

16

Y

Not applicable

PA document date

PSMISCID

string

15

Y

Not applicable

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

LNITMSEQ

i4

4

N

0

Line item sequence

PADT

datetime

16

Y

Not applicable

PA date

PAPROJNUMBER

string

15

Y

Not applicable

PA project number

PACOSTCATID

string

15

Y

Not applicable

Cost category ID

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

0

PA unit cost

PATOTCST

number

21

N

0

PA total cost

Patx500

string

256

N

<blank>

PA billing note text

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