EX_ENHC_DTAMX_H

(SQL Table)
Index Back

Enhc Data Details Amex History

History table for Detail level Enhanced Data for Hotel Folio for Amex

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

4 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
5 TRANS_NBR Character(24) VARCHAR2(24) NOT NULL Transaction Number
6 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
7 ITEM_SEQ_NBR Number(5,0) INTEGER NOT NULL Item Sequence Number
8 EX_ENHNC_DATA Character(1) VARCHAR2(1) NOT NULL Enhanced Data Type
A=Air Travel Enhanced Data
C=Car Rental Enhanced Data
D=Hotel Folio Enhc Data Visa 4.4
H=Hotel Folio Enhanced Data
N=No Enhanced Data
9 EX_ENHC_DATE Date(10) DATE Enhanced Data Date
10 AMX_ITEM_CD Character(6) VARCHAR2(6) NOT NULL Amex Item Code
11 AMX_ITEM_CD_DESC Character(40) VARCHAR2(40) NOT NULL Enhanced Item
12 AMX_ITM_CATCD Character(2) VARCHAR2(2) NOT NULL Amex Item Category Code
13 AMX_ITM_CATCD_DESC Character(40) VARCHAR2(40) NOT NULL Enhanced Category
14 AMX_ITEM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
15 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency