PACONTNUMBER

string

11

Y

Not applicable

PA contract number

PACHGORDNO

string

17

Y

Not applicable

PA change order number

PAPROJNUMBER

string

15

Y

Not applicable

PA project number

PAFeeID

string

15

Y

Not applicable

PA fee ID

PAFeeAmount

number

21

N

0

Fee amount

PAFeePercent

number

21

N

0

Fee percent

PAFeeToUse

i4

2

Y

Not applicable

PA fee to use

PASales_Tax_Options

i4

2

N

0

PA sales tax options:

1=Taxable;

2=Nontaxable;

3=Based on customer

PAbilltaxscheduleid

string

15

N

<blank>

PA billing tax schedule ID

PAFrequency

i4

2

Y

Not applicable

PA frequency:

1=Scheduled;

2=Per invoice;

3=At project completion

PALineItemSeq

i4

4

N

0

PA line item sequence

PAbegindate

datetime

16

N

<blank>

PA begin date

PAEnDate

datetime

16

N

<blank>

PA end date

PARenew

i4

2

N

0

PA renew

PARenewal_Date

datetime

16

N

<blank>

PA renewal date

PA_Renew_Day

i4

4

N

0

PA renewal day

PA_Renew_Month

i4

4

N

0

PA renewal month

PAtotcbts

i4

1

N

0

Include transaction-type timesheets

PAtotcbEL

i4

1

N

0

Include transaction-type equipment logs

PAtotcbML

i4

1

N

0

Include transaction-type miscellaneous logs

PAtotcbvi

i4

1

N

0

Include transaction-type purchasing inventory

PAtotcber

i4

1

N

0

Include transaction-type employee expense

PAtotcbinv

i4

1

N

0

Include transaction-type inventory

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