<taPAProjects>


[spacer]

Element name

Data type

Length

Required

Default

Description

CUSTNMBR

string

15

Y

Not applicable

Customer number

PACONTNUMBER

string

11

Y

Not applicable

PA contract number

PAprojid

string

15

Y

Not applicable

PA project ID

PAprojname

string

31

Y

Not applicable

PA project name

PAPROJNUMBER

string

15

Y

Not applicable

PA project number

PAProjectType

i4

2

N

Default from setup

PA project type:

1=Time and materials;

2=Cost plus;

3=Fixed price

PAAcctgMethod

i4

2

N

Default from setup

PA account method:

1=When performed;

2=When billed;

3=Cost to cost;

4=Effort expended;

5=Completed;

6=Effort expended labor only

PASTAT

i4

2

N

Default from setup

PA status:

1=Open;

2=On hold;

3=Closed;

4=Estimate;

5=Completed

PABBeginDate

datetime

16

N

Default from setup

PA baseline begin date

PABEndDate

datetime

16

N

Default from setup

PA baseline end date

PAprjclsid

string

15

N

Default from setup

PA project class ID

PApurordnum

string

17

N

Default from setup

PA purchase order number

PAcloseProjcosts

i4

2

N

Default from setup

PA close to project costs

PAclosetobillings

i4

2

N

Default from setup

PA close to billings

PADepartment

string

7

N

Default from setup

PA department

PAEstimatorID

string

15

N

Default from setup

PA estimator ID

PAprojmngrid

string

15

N

Default from setup

PA project manager ID

PABusMgrID

string

15

N

Default from setup

PA business manager ID

PALabor_Rate_Table_ID

string

31

N

Default from setup

PA labor rate table ID

PALabor_RateTable_Type

i4

2

N

Default from setup

PA labor rate table type

PALabor_Rate_Table_Acc

i4

2

N

Default from setup

PA labor rate table accept replacements

PAEquip_Rate_Table_ID

string

31

N

Default from setup

PA equipment rate table ID

PAEquip_Rate_Table_Acc

i4

2

N

Default from setup

PA equipment rate table accept replacements

PAbllngtype

i4

2

N

Default from setup

PA billing type:

1=Standard;

2=No charge;

3=No billing

PABILLFORMAT

string

15

N

Default from setup

PA billing format

DSCPCTAM

i4

2

N

Default from setup

Discount percent amount

PA_Retention_Percent

number

21

N

Default from setup

PA retention percent

PAUD1Proj

string

51

N

Default from setup

PA user defined 1

PAUD2_Proj

string

51

N

Default from setup

PA user defined 2

PASegmentCB

i4

2

N

Default from setup

PA segment check box

PRBTADCD

string

15

N

Default from setup

Primary bill to address code

PAbillnoteDefault

string

1000

N

Default from setup

PA billing note— default

PAbillnoteTS

string

1000

N

Default from setup

PA billing note—timesheets

PAbillnoteEL

string

1000

N

Default from setup

PA billing note—equipment logs

PAbillnoteML

string

1000

N

Default from setup

PA billing note—miscellaneous logs

PAbillnoteVI

string

1000

N

Default from setup

PA billing note—VI

PAbillnoteEE

string

1000

N

Default from setup

PA billing note—employee expense

PAbillnoteINV

string

1000

N

Default from setup

PA billing note—inventory

PAbillnoteFEE

string

1000

N

Default from setup

PA billing note—fee

PABILLCYCLEID1

string

15

N

Default from setup

PA billing cycle ID

PA_RestrictCustomerList

i4

2

N

Default from setup

PA restrict customer list

WRKRCOMP

string

7

N

Default from setup

Workers' compensation ID

SUTASTAT

string

3

N

Default from setup

SUTA state ID

PATRKCHGORDS

i4

2

N

Default from setup

PA track change orders

PATRKCOBDGADDFLY

i4

2

N

Default from setup

PA track change orders for new budget on the fly

UpdateExisting

i4

1

N

0

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

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



Documentation Feedback