PAPROJNUMBER

string

15

Y

Not applicable

PA project number

PACOSTCATID

string

15

Y

Not applicable

PA cost category ID

PASTAT

i4

2

N

Default from setup

PA status:

1=Open;

2=On hold;

3=Closed*;

4=Estimate;

5=Completed

(*note the closed status is not supported in this release)

PAProfitType

i4

2

N

Default from setup

PA profit type:

1=Billing rate;

2=Markup percentage;

3=Price unit fixed;

4=Price unit variable;

5=Total profit;

6=Percent of baseline;

7=Percent of actual;

8=None;

9=Price level

PAbllngtype

i4

2

N

Default from setup

PA billing type:

1=Standard;

2=No charge;

3=No billing

PABBeginDate

datetime

16

N

Default from setup

PA begin date

PABEndDate

datetime

16

N

Default from setup

PA end date

LNITMSEQ

i4

4

N

Default from setup

Line item sequence

PALineItemSeq

i4

4

N

Default from setup

PA line item sequence

PABQuantity

number

21

N

Default from setup

PA baseline quantity

PABUnitCost

number

21

N

Default from setup

PA baseline cost

PABProfitAmt

number

21

N

Default from setup

PA baseline profit amount

PABProfitPcnt

number

21

N

Default from setup

PA baseline profit percent

PABTotalCost

number

21

N

Default from setup

PA baseline total cost

PABaselineOvhdAmtPerUnit

number

21

N

Default from setup

PA baseline overhead amount per unit

PABaselineOvrhdPct

number

21

N

Default from setup

PA baseline overhead percent

PABaselinePTaxOptions

i4

2

N

Default from setup

PA baseline purchase tax options

PABaselineCTaxSchedID

string

15

N

Default from setup

PA baseline cost tax schedule ID

PABaselineSTaxOptions

i4

2

N

Default from setup

PA baseline sales tax options

PABaselineBTaxSchedID

string

15

N

Default from setup

PA baseline billings tax schedule ID

PAFQuantity

number

21

N

Default from setup

PA forecast quantity

PAFUnitCost

number

21

N

Default from setup

PA forecast cost

PAFTotalCost

number

21

N

Default from setup

PA forecast total cost

PAFProfitAmt

number

21

N

Default from setup

PA forecast profit amount

PAFProfitPcnt

number

21

N

Default from setup

PA forecast profit percent

PAForecastOvrhdAmtPerUnt

number

21

N

Default from setup

PA forecast overhead amount per unit

PAForecastOvrhdPct

number

21

N

Default from setup

PA forecast overhead percent

PAForecastPTaxOptions

i4

2

N

Default from setup

PA forecast purchase tax options

PAForecastCTaxSchedID

string

15

N

Default from setup

PA forecast cost tax schedule ID

PAForecastSTaxOptions

i4

2

N

Default from setup

PA forecast sales tax options

PAForecastBTaxSchedID

string

15

N

Default from setup

PA forecast billings tax schedule ID

PAFBeginDate

datetime

16

N

Default from setup

PA forecast begin date

PAFEndDate

datetime

16

N

Default from setup

PA forecast end date

PAUnit_of_Measure

string

9

N

Default from setup

PA unit of measure

UOMSCHDL

string

11

N

Default from setup

Unit of measure schedule

PAPay_Code_Hourly

string

7

N

Default from setup

PA pay code hourly

PAPay_Code_Salary

string

7

N

Default from setup

PA pay code salary

UpdateExisting

i4

1

N

Default from setup

Update functionality does not exist at this time; this will be used for future release

RollUpEst_to_Forecast

i4

1

N

Default from setup

Flag that determines whether or not changes made in estimate status roll up to forecast values:

0=No rollup;

1=Roll up to forecast values

RequesterTrx

i4

2

N

0

Requester transaction:

0=False;

1=True

(if True, it 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