EX_BMXPNSTP_MAP(SQL Table) |
Index Back |
---|---|
Benchmark Expense Type mappingTemplate for expense type mapping. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: SP_SETID_NONVW.SETID Prompt Table: SP_SETID_NONVW |
2 | 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 |
3 | EXPENSE_TYPE | Character(7) | VARCHAR2(7) NOT NULL |
Expense Type
Prompt Table: EX_TYPES_TBL |
4 | BNCHMRK_EXPNS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
BenchMark Expenses Type used to map User defined Expense types
BRKF=Breakfast CCR=Compact Car rental DHTL=Deluxe Hotel DNR=Dinner EHTL=Economy Hotel FHTL=First Class Hotel HTL=Hotel/Lodging ICR=Intermediate Car Rental LIE=Local Incidental Expenses LNCH=Lunch NGVM=No Govt Meals PERD=Perdiem PRML=Proportional Meals SHTL=Airport Shuttle TAXI=Taxi |