<taPAEquipLogLineInsert>

Element name

Data type

Length

Required

Default

Description

PAEQLTRX

i4

2

Y

Not applicable

PA Equipment Transaction Type 1=Standard

2=Referenced

PAEQLOGNO

string

17

Y

Not applicable

PA Equipment Document Number

PADOCDT

datetime

8 bytes

(19 to 23 chars)

Y

Not applicable

PA Document Date

PAEQUIPTID

string

15

Y

Not applicable

PA Equipment ID

PAREPD

i4

4

Y

Not applicable

PA Reporting Period

PAREPDT

datetime

8 bytes

(19 to 23 chars)

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

8 bytes

(19 to 23 chars)

Y

Not applicable

PA Date

PAPROJNUMBER

string

15

Y

Not applicable

Project ID

PACOSTCATID

string

15

Y

Not applicable

Cost Category ID

PATB

datetime

8 bytes

(19 to 23 chars)

N

<blank>

PA Time Begin

PATE

datetime

8 bytes

(19 to 23 chars)

N

<blank>

PA Time End

PAQtyQ

number

21

N

0

PA Quantity

PAbllngtype

i4

2

N

1

PA Billing Type

1=STD,

2=N/C,

3=N/B

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 than populates 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

This node uses document exchange for updates. All existing values are overwritten with the value specified by the update document. If a field in the update is blank, the existing value is changed to be blank.