CUSTNMBR

string

15

Y

Not applicable

Customer number

PAcontid

string

15

Y

Not applicable

PA contract ID

PAcontname

string

31

Y

Not applicable

PA contract name

PACONTNUMBER

string

11

Y

Not applicable

PA contract number

PAcontclassid

string

15

N

Default from setup

PA contract class ID

PAProjectType

i4

2

Y

Not applicable

PA project type:

1=Time and materials;

2=Cost plus;

3=Fixed price

PAAcctgMethod

i4

2

Y

Not applicable

PA accounting method:

1=When performed;

2=When billed;

3=Cost to cost;

4=Effort expended;

5=Completed;

6=Effort expended labor only

PAMCCURNCYID

string

15

N

<blank>

PA MC currency ID

PASTAT

i4

2

N

Default from setup

PA status:

1=Open;

2=On hold;

3=Closed;

4=Estimate;

5=Completed

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

PAUD1_Cont

string

51

N

Default from setup

PA user defined 1

PAUD2_Cont

string

51

N

Default from setup

PA user defined 2

PAContMgrID

string

15

N

Default from setup

PA contract manager ID

PABusMgrID

string

15

N

Default from setup

PA business manager ID

ADRSCODE

string

15

N

Default from setup

Address code

SLPRSNID

string

15

N

Default from setup

Sales person ID

SALSTERR

string

15

N

Default from setup

Sales territory ID

COMPRCNT

i4

4

N

Default from setup

Sales commission percent

COMAPPTO

i4

2

N

Default from setup

Sales commission applied to

PABILLFORMAT

string

15

N

Default from setup

PA billing format

PRBTADCD

string

15

N

Default from setup

Primary bill to address ID

PA_RestrictCustomerList

i4

2

N

Default from setup

PA restrict to customer list

DSCPCTAM

number

21

N

Default from setup

Discount percent amount

PASegmentCB

i4

2

N

Default from setup

PA account segment check box

PABILLCYCLEID1

string

15

N

Default from setup

PA billing cycle 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

PAbillnoteTS

string

1000

N

<blank>

PA billing note—timesheets

PAbillnoteEL

string

1000

N

<blank>

PA billing note—equipment logs

PAbillnoteML

string

1000

N

<blank>

PA billing note—miscellaneous logs

PAbillnoteVI

string

1000

N

<blank>

PA billing note—VI

PAbillnoteEE

string

1000

N

<blank>

PA billing note—employee expense

PAbillnoteINV

string

1000

N

<blank>

PA billing note—inventory

PAbillnoteFEE

string

1000

N

<blank>

PA billing note—fee

UpdateExisting

i4

1

N

0

Update functionality does not exist at this time. This element will be used for future releases.

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