Share via


<taPAEquipLogHdrInsert>

Element name

Data type

Length

Required

Default

Description

PAEQLTRX

i4

2

Y

Not applicable

PA Equipment Log Transaction Type 1=Standard 2=Referenced

PAEQLOGNO

string

17

Y

Not applicable

PA Equipment Log Document Number

PADOCDT

datetime

8 bytes

(19 to 23 chars)

Y

Not applicable

PA Document Date

BACHNUMB

string

15

Y

Not applicable

Batch Number

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

PAreptsuff

string

5

N

<blank>

PA Reporting Suffix - used to create a unique record if a record already exists with this PAEQUIPTID,PAREPD combination.

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

8 bytes

(19 to 23 chars)

N

<blank>

Expiration Date

EXCHDATE

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Exchange Date

EXGTBDSC

string

30

N

<blank>

Exchange ID Desc.

EXTBLSRC

string

50

N

<blank>

Exchange Rate Source

RATEEXPR

i4

2

N

<blank>

Rate Expiration

The breakdown is:

1=Daily,

2=Weekly,

3=Bi-Weekly,

4=Semi-Monthly,

5=Monthly,

6=Quarterly,

7=Annually,

8=Miscellaneous,

9=None,

0=None

DYSTINCR

i4

2

N

<blank>

Days to Increment

Only used when RATEEXPR = 8

RATEVARC

number

21

N

0

Rate Variance

TRXDTDEF

i4

2

N

0

Trx Date Default

0=Exact Date,

1=Next Date,

2=Previous Date

RTCLCMTD

i4

2

N

<blank>

Rate Calc. Method

0=Multiply,

1= Divide

PRVDSLMT

i4

2

N

0

Previous Days Limits

DATELMTS

i4

2

N

0

Date Limits

0=Unlimited,

1=Limited

TIME1

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Time 1

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.