EX_TRANS_TEO1

(SQL Table)
Index Back

CCU TEO temp table

CCU temporary table for EX_TRANS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

3 DATA_SOURCE_EX Character(3) VARCHAR2(3) NOT NULL External Data Sources for PS Expenses
AIR=Airline Ticket
AMA=American Express
AMG=American Express
AMH=American Express-Hotel Folio
AMM=American Express - Member List
AMX=American Express
CNS=CONUS
DC=Diners Club
IPH=iReceipts
MC=MasterCard CDFv2
MCX=MasterCard CDFv3
MSG=Text Message
NAP=PS NA Payroll
PDA=PDA
RNZ=Runzheimer
SAB=Sabre
UBT=User Chatbot
USB=US Bank
USR=User Input
VI4=Visa
VIS=Visa
4 TRANS_NBR Character(24) VARCHAR2(24) NOT NULL Transaction Number
5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
6 ITEM_SEQ_NBR Number(5,0) INTEGER NOT NULL Item Sequence Number
7 EX_TRANS_TYPE Character(4) VARCHAR2(4) NOT NULL Expenses Transaction Type, used to categorize external data that is loaded into the expense product, for example corporate card expenses/credits, ATM advances and travel bookings.
ALL=All Transaction Types
ATMA=ATM Advance
CCCR=Credit
CCEX=Expense
TRBK=Travel Reservation
8 CCTRANS_TYPE_CD Character(2) VARCHAR2(2) NOT NULL Credit Card Transaction Code
9 EX_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies Expenses Document Type
A=Cash Advance
C=Time Report
J=Time Adjustment
M=Accrual - My Wallet
R=Accrual - Expense Report
S=Expense Report
T=Travel Authorization
10 ADVANCE_ID Character(10) VARCHAR2(10) NOT NULL Advance ID
11 ADVANCE_NAME Character(30) VARCHAR2(30) NOT NULL Advance Description
12 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
13 SHEET_NAME Character(30) VARCHAR2(30) NOT NULL Report Description
14 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
15 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type
16 RECEIPT_VERIFIED Character(1) VARCHAR2(1) NOT NULL Receipt Verified

Y/N Table Edit

17 TRANS_DT Date(10) DATE Transaction Date
18 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
19 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

Prompt Table: CURRENCY_CD_TBL

20 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.
21 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

22 CUR_EXCHNG_RT Number(16,8) DECIMAL(15,8) NOT NULL Currency Exchange Rate
23 RATE_USR_DFN Character(1) VARCHAR2(1) NOT NULL The field indicates the type of Exchange rate to be used. User defined or system default
D=Custom - Direct
I=Custom - Indirect
S=System Default
24 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
25 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
26 CITY Character(30) VARCHAR2(30) NOT NULL City
27 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
28 TXN_LOCATION Character(5) VARCHAR2(5) NOT NULL Expense Location
29 EXPEND_MTHD Character(3) VARCHAR2(3) NOT NULL Payment Type
30 PREF_MRCHNT_FLG Character(1) VARCHAR2(1) NOT NULL Preferred Merchant
N=No
Y=Yes
31 MERCHANT_CD Character(10) VARCHAR2(10) NOT NULL Preferred Merchant
32 MERCHANT Character(40) VARCHAR2(40) NOT NULL Merchant
33 NBR_NIGHTS Number(3,0) SMALLINT NOT NULL Number of Nights
34 AIRFARE_RCPT_NBR Character(16) VARCHAR2(16) NOT NULL Airfare Receipt Number
35 AIR_TKT_RECON_STAT Character(1) VARCHAR2(1) NOT NULL Airline Ticket Reconciliation Status
C=Cancelled
N=Not Reconciled
R=Reconciled
36 DAYS_OUTSTANDING Number(4,0) SMALLINT NOT NULL Days Outstanding
37 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
38 CORP_ACCT_NBR Character(20) VARCHAR2(20) NOT NULL Corporate Number
39 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number
40 SUPPLIER_NBR Character(11) VARCHAR2(11) NOT NULL Supplier Reference Nbr
41 ADVANCE_SOURCE Character(4) VARCHAR2(4) NOT NULL Advance Source
42 TXN_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
A=Assigned
D=Marked for Delete
R=Rejected
T=All Transaction Statuses
U=Unassigned

Default Value: R

43 TXN_LOAD_DATE Date(10) DATE Transaction Load Date
44 DESCR_LN1 Character(50) VARCHAR2(50) NOT NULL Description Line 1
45 DESCR_LN2 Character(50) VARCHAR2(50) NOT NULL Description Line 2
46 DESCR_LN3 Character(50) VARCHAR2(50) NOT NULL Description Line 3
47 DESCR_LN4 Character(50) VARCHAR2(50) NOT NULL Description Line 4
48 EMP_NOTIFY_SW Character(1) VARCHAR2(1) NOT NULL Employee Notified
49 MOBILE_DWNLD_FLG Character(1) VARCHAR2(1) NOT NULL Picked Up By Mobile
N=No
Y=Yes
50 DTTM_STAMP 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.
51 DISTANCE Number(8,2) DECIMAL(7,2) NOT NULL Distance Traveled
52 DISTANCE_TYPE Character(1) VARCHAR2(1) NOT NULL Distance Type
3=Metres
K=Kilometers
M=Miles
53 MOBILE_SYNC_STATUS Character(1) VARCHAR2(1) NOT NULL Marks the synchronization status of a mobile transaction
A=Assigned
N=New
R=Repeat
S=Synchronized
54 MOBILE_POPWKEY Character(50) VARCHAR2(50) NOT NULL Mobile Id
55 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Documentation ID
56 PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Processing Flag
57 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
58 PERSONAL_EXPENSE Character(1) VARCHAR2(1) NOT NULL Personal Expense
N=No
Y=Yes
59 EX_TYPE_FLAG Character(1) VARCHAR2(1) NOT NULL Expense Type Flag
60 ENHC_DATA_LOADED Character(1) VARCHAR2(1) NOT NULL Enhanced Data Loaded
61 CC_POSTING_DT Date(10) DATE Credit Card Posting Date
62 EX_AMX_TRANSNBR Character(50) VARCHAR2(50) NOT NULL Amex Global Transaction Nbr
63 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code