<taPAEmpExpenseHdrInsert>
Element name |
Datatype |
Length |
Required |
Default |
Description |
|---|---|---|---|---|---|
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 |
8 bytes (19 to 23 chars) |
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 |
8 bytes (19 to 23 chars) |
Y |
Not applicable |
PA start date |
PAEnDate |
datetime |
8 bytes (19 to 23 chars) |
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 |
8 bytes (19 to 23 chars) |
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 |
8 bytes (19 to 23 chars) |
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 |
8 bytes (19 to 23 chars) |
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 |
8 bytes (19 to 23 chars) |
N |
<blank> |
PA post date |
PApostoDynPM |
i4 |
1 |
N |
1 |
PA post to dynamic payables management: 1=Post to payable management |
Tax_Date |
datetime |
8 bytes (19 to 23 chars) |
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 |
8 bytes (19 to 23 chars) |
N |
<blank> |
Expiration date |
EXCHDATE |
datetime |
8 bytes (19 to 23 chars) |
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 |
8 bytes (19 to 23 chars) |
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 |
This node uses document exchange for updates. All existing values are overwritten with the value specified by the update document. If a field in the update is blank, the existing value is changed to be blank.