PAertrxtype

i4

2

Y

Not applicable

PA employee expense transaction type:

1=Standard;

2=Referenced

PAerdocnumber

string

17

Y

Not applicable

PA employee expense document number

PADOCDT

datetime

16

Y

Not applicable

PA document date

BACHNUMB

string

15

Y

Not applicable

Batch number

EMPLOYID

string

15

Y

Not applicable

Employee ID

PAVENADDRESSID

string

15

Y

Not applicable

PA vendor address ID

PAStartDate

datetime

16

Y

Not applicable

PA start date

PAEnDate

datetime

16

Y

Not applicable

PA end date

CURNCYID

string

15

Y

Not applicable

Currency ID

USERID

string

15

N

<blank>

User ID

PAREFNO

string

17

N

<blank>

PA reference document number

SHIPMTHD

string

15

N

<blank>

Shipping method

PAUD1

string

21

N

<blank>

PA user defined 1

PAUD2

string

21

N

<blank>

PA user defined 2

PAreptsuff

string

5

N

<blank>

PA reporting suffix

If an employee has multiple expense transactions that have the same start and end dates, add a sequence number that uniquely identifies each transaction.

PACOMM

string

51

N

<blank>

PA comment

PATQTY

number

21

N

0

PA total quantity

PAREIMBURSTAXAMT

number

21

N

0

PA reimbursable tax amount

BKTPURAM

number

21

N

0

Back out purchases amount

PATACRV

number

21

N

0

PA total accrued revenues

TRDISAMT

number

21

N

0

Trade discount amount

PAFreight_Taxable_P

i4

2

N

0

PA freight taxable: purchase:

1=Taxable;

2=Nontaxable;

3=Based on vendor

FRTSCHID

string

15

N

<blank>

Freight schedule ID

FRTAMNT

number

21

N

0

Freight amount

FRTTXAMT

number

21

N

0

Freight tax amount

PAMisc_Taxable_P

i4

2

N

0

PA miscellaneous taxable: purchase:

1=Taxable;

2=Nontaxable;

3=Based on vendor

MSCSCHID

string

15

N

<blank>

Miscellaneous schedule ID

MSCCHAMT

number

21

N

0

Miscellaneous charges amount

MSCTXAMT

number

21

N

0

Miscellaneous tax amount

DOCAMNT

number

21

N

0

Document amount

TEN99AMNT

number

21

N

0

1099 amount

UN1099AM

number

21

N

0

Unapplied 1099 amount

CASHAMNT

number

21

N

0

Cash amount

CAMCBKID

string

15

N

<blank>

Cash amount checkbook ID

CDOCNMBR

string

21

N

<blank>

Cash document number

CAMTDATE

datetime

16

N

<blank>

Cash amount date

CAMPMTNM

string

21

N

<blank>

Cash amount payment number

CHRGAMNT

number

21

N

0

Charge amount

CHEKAMNT

number

21

N

0

Check amount

CHEKNMBR

string

21

N

<blank>

Check number

CHEKDATE

datetime

16

N

<blank>

Check date

CAMPYNBR

string

21

N

<blank>

Check amount payment number

CHAMCBID

string

15

N

<blank>

Check amount checkbook ID

CARDNAME

string

15

N

<blank>

Card name

CRCRDAMT

number

21

N

0

Credit card amount

CRCARDDT

datetime

16

N

<blank>

Credit card date

CCAMPYNM

string

21

N

<blank>

Credit card payment number

CCRCTNUM

string

21

N

<blank>

Credit card receipt number

TAXSCHID

string

15

N

<blank>

Tax schedule ID

TAXAMNT

number

21

N

0

Tax amount

BCKTXAMNT

number

21

N

0

Back out tax amount

PAReimbursableAmount

number

21

N

0

PA reimbursable amount

PAPD

datetime

16

N

<blank>

PA post date

PApostoDynPM

i4

1

N

1

PA post to dynamic payables management: 1=Post to payable management

Tax_Date

datetime

16

N

<blank>

Tax date

TaxInvRecvd

i4

1

N

0

1=Tax invoice received

TaxInvReqd

i4

1

N

0

1=Tax invoice received

USINGHEADERLEVELTAXES

i4

2

N

0

Using header level taxes

XCHGRATE

number

21

N

0

Exchange rate

RATETPID

string

15

N

<blank>

Rate type ID

EXPNDATE

datetime

16

N

<blank>

Expiration date

EXCHDATE

datetime

16

N

<blank>

Exchange date

EXGTBDSC

string

30

N

<blank>

Exchange ID description

EXTBLSRC

string

50

N

<blank>

Exchange rate source

RATEEXPR

i4

2

N

Default is from setup

Rate expiration:

0=None

1=Daily;

2=Weekly;

3=Biweekly;

4=Semimonthly;

5=Monthly;

6=Quarterly;

7=Annually;

8=Miscellaneous;

9=None;

DYSTINCR

i4

2

N

Default is from setup

Days to increment—used only when RATEEXPR=8

RATEVARC

number

21

N

0

Rate variance

TRXDTDEF

i4

2

N

Default is from setup

Transaction date default:

0=Exact date;

1=Next date;

2=Previous date

RTCLCMTD

i4

2

N

Default is from setup

Rate calculation method:

0=Multiply;

1=Divide

PRVDSLMT

i4

2

N

0

Previous day's limits

DATELMTS

i4

2

N

0

Date limits:

0=Unlimited;

1=Limited

TIME1

datetime

16

N

<blank>

Time 1

PDK_EE_No

string

31

N

<blank>

PDK employee expense number

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