EX_TRANS_TEO1(SQL Table) |
Index Back |
---|---|
CCU TEO temp tableCCU 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 |