| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TRAVEL_AUTH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.
|
| 2 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1
|
| 3 |
EX_LINE_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
The Line Status of an Expenses transaction (i.e. Expense Report, Cash Advance, Travel Authorization, Time Report)
ADJ=Adjusted
APR=Approved
APY=Approved for Payment
CLS=Closed
DEN=Denied
DNA=Denied by Approver
DNC=Denied
DNU=Denied by Auditor
ESC=Escheated Payment
HDA=Hold by Approver
HDU=Hold by Auditor
HLD=Hold
MFS=Marked For Submit
OPN=Open
PAR=Approvals in Process
PD=Paid
PND=Pending
PRO=In Process
RAP=Approved
STG=Staged
SUB=Submitted
XML=Submitted, Pending Validation
Default Value: PND
|
| 4 |
EXPENSE_TYPE |
Character(7) |
VARCHAR2(7) NOT NULL |
Expense Type
Prompt Table:
EX_TYPES_TBL
|
| 5 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 6 |
PREPAID_EXPENSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pre-Paid Expense
Y/N Table Edit
Default Value: N
|
| 7 |
REIMBURSEMENT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Deny
N=Nonreimburseable
P=Prepaid
R=Reimburseable
Default Value: R
|
| 8 |
REIMB_ACTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Reason
Prompt Table:
EX_ACTION_TBL
|
| 9 |
EXPEND_MTHD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Type
Prompt Table:
EX_EXP_MTHD_TBL
Set Control Field: BUSINESS_UNIT_GL
|
| 10 |
MONETARY_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
|
| 11 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 12 |
TXN_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 13 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 14 |
TXN_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Expense Location
Prompt Table:
EX_LOCATION_VW4
|
| 15 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
Default Value: 1
|
| 16 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1
|
| 17 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Default Value: BUS_UNIT_OPT_EX.RT_TYPE
Prompt Table:
RT_TYPE_TBL
|
| 18 |
AIRFARE_RCPT_NBR |
Character(16) |
VARCHAR2(16) NOT NULL |
Airfare Receipt Number
|
| 19 |
TRAVEL_FROM |
Character(5) |
VARCHAR2(5) NOT NULL |
Used to indicate the starting point of travel for a travel authorization for airline expenditures. Defined on the EX_TAUTH_LINE record and used on various travel auth line panels. Used in conjunction with the TRAVEL_TO field to track the cost of flights to and from various locals.
Prompt Table:
EX_LOCATION_VW5
|
| 20 |
TRAVEL_TO |
Character(5) |
VARCHAR2(5) NOT NULL |
Used to indicate the ending point of travel for a travel authorization for airline expenditures. Defined on the EX_TAUTH_LINE record and used on various travel auth line panels. Used in conjunction with the TRAVEL_FROM field to track the cost of flights to and from various locals.
Prompt Table:
EX_LOCATION_VW3
|
| 21 |
PREF_MRCHNT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Preferred Merchant
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 22 |
MERCHANT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Preferred Merchant
Prompt Table:
EX_MERCHANT_VW
|
| 23 |
MERCHANT |
Character(40) |
VARCHAR2(40) NOT NULL |
Merchant
|
| 24 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 25 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 26 |
DISTANCE |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Distance Traveled
|
| 27 |
DISTANCE_RT |
Number(9,4) |
DECIMAL(8,4) NOT NULL |
Standard Distance Rate
|
| 28 |
DISTANCE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Distance Type
3=Metres
K=Kilometers
M=Miles
|
| 29 |
NBR_NIGHTS |
Number(3,0) |
SMALLINT NOT NULL |
Number of Nights
Default Value: 1
|
| 30 |
NBR_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Used to specify the number of days associated with a particular expense type for Travel Authorizations, i.e. breakfast, lunch. Found on many of the Travel Auth line records and panels.
Default Value: 1
|
| 31 |
EE_LOCAMT_COMMENT |
Character(60) |
VARCHAR2(60) NOT NULL |
Location Amount Comment
|
| 32 |
NONPREFMERCH_JUST |
Character(10) |
VARCHAR2(10) NOT NULL |
Non-Preferred Justification
Prompt Table:
EX_NONPREFMERCH
|
| 33 |
EE_PRFMRC_COMMENT |
Character(60) |
VARCHAR2(60) NOT NULL |
Preferred Vendor Comment
|
| 34 |
OUT_OF_POLICY |
Character(1) |
VARCHAR2(1) NOT NULL |
Authorized Amount Exceeded
Y/N Table Edit
Default Value: N
|
| 35 |
TRANS_DT_JULIAN |
Number(3,0) |
SMALLINT NOT NULL |
Julian Transaction Date
|
| 36 |
BILL_CODE_EX |
Character(3) |
VARCHAR2(3) NOT NULL |
Expense Billing Code
Prompt Table:
EX_BILL_CD_TBL
|
| 37 |
BILLING_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Action
B=Billable
I=Internal
P=Personal
U=Nonbillable
|
| 38 |
OVRRIDE_SPLT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Accounting Split
Y/N Table Edit
Default Value: N
|
| 39 |
STARTTM_PERDIEM |
Time(15) |
TIMESTAMP |
Start Time (HH:MI)
|
| 40 |
ENDTM_PERDIEM |
Time(15) |
TIMESTAMP |
End Time (HH:MI)
|
| 41 |
NBR_PASSENGERS |
Number(2,0) |
SMALLINT NOT NULL |
Number of Passengers
|
| 42 |
TRANSPORT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Transportation Type
|
| 43 |
TRANSPORT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Transportation ID
Prompt Table:
EX_EE_TRNSPT_VW
|
| 44 |
RANGE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Per Diem Range
Prompt Table:
EX_DUR_VW
|
| 45 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 46 |
APPROVE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approve Flag
Default Value: Y
|
| 47 |
APPROVER_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Approver Oprid
|
| 48 |
APPROVER_ACTN_DT |
Date(10) |
DATE |
The Date on which the approver takes necessary action
|
| 49 |
APPROVER_ADD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
New Approver Add Flag
Default Value: N
|
| 50 |
UNDENY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Undeny Flag
|
| 51 |
ITINERARY_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Itinerary ID for Travel Reservations
|
| 52 |
RESERVATION_NBR |
Number(3,0) |
SMALLINT NOT NULL |
reservation sequence number
|
| 53 |
ISCHANGED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record has been changed
Y/N Table Edit
Default Value: N
|
| 54 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %datetime
|
| 55 |
PREF_MRCH_NOT_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
Non-Preferred Merchant
Y/N Table Edit
Default Value: N
|
| 56 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|