PACHGORDNO

string

17

Y

Not applicable

PA change order number

PACONTNUMBER

string

11

Y

Not applicable

PA contract number

PAPROJNUMBER

string

15

Y

Not applicable

PA project number

PACOSTCATID

string

15

Y

Not applicable

PA cost category ID

LNITMSEQ

i4

4

N

0

Line item sequence

PAbegindate

datetime

16

N

<blank>

PA begin date

PAEnDate

datetime

16

N

<blank>

PA end date

PAVarianceQty

number

21

N

0

PA variance quantity

PAQtyQ

number

21

N

0

PA quantity

PAVarianceCosts

number

21

N

0

PA variance costs

PAUNITCOST

number

21

N

0

PA unit costs

PAVARMUPRCNT

number

21

N

0

PA variance mark up percent

PAProfitPercent

number

21

N

0

PA profit percent

PAVARPROFAMT

number

21

N

0

PA variance profit amount

PAProfitAmount

number

21

N

0

PA profit amount

PAOvhdAmtPerUnit

number

21

N

0

PA overhead amount per unit

PAOverheaPercentage

number

21

N

0

PA overhead percentage

PAVAROVRHDUNIT

number

21

N

0

PA variance overhead amount per unit

PAVAROVERHDPRCNT

number

21

N

0

PA variance overhead percentage

PACOSTATUS

i4

2

N

0

PA change order status:

1=Pending;

2=Unapproved;

3=Approved;

4=Canceled;

5=Completed

PAGBTRKCHG

i4

21

Y

Not applicable

Track changes:

0=Baseline;

1=Forecast

PASales_Tax_Options

i4

2

N

0

PA sales tax options:

1=Taxable;

2=Based on customer;

3=Nontaxable

PAbilltaxscheduleid

string

15

N

<blank>

PA billing tax schedule ID

PAPurchase_Tax_Options

number

21

N

0

PA purchase tax options:

1=Taxable;

2=Based on customer;

3=Nontaxable

PAPURCHTAXSCHED

number

21

N

0

PA purchase tax schedule ID

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