EX_ENHC_DTAMX_H(SQL Table) |
Index Back |
---|---|
Enhc Data Details Amex HistoryHistory 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 |