SETIDDefault Value: OPR_DEF_TBL_FS.SETID
WIZARD_TYPELDY=Laundry
MSC=Misc Charges
PHN=Telephone
PRK=Parking
RC=Room Charge
RS=Room Service
RS1=Room Service 1
RS2=Room Service 2
RS3=Room Service 3
RT=Room Tax
Prompt Table: EX_TYPES_TBL
EX_WIZARD_TBL(SQL Table) |
Index Back |
|---|---|
Expenses Wizard Mapping TableWizard Types can be configured here to dynamically prompt the user in the hotel wizard. They are mapped to an expense type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID |
| 2 | WIZARD_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Wizard Type Definition
LDY=Laundry MSC=Misc Charges PHN=Telephone PRK=Parking RC=Room Charge RS=Room Service RS1=Room Service 1 RS2=Room Service 2 RS3=Room Service 3 RT=Room Tax |
| 3 | EXPENSE_TYPE | Character(7) | VARCHAR2(7) NOT NULL |
Expense Type
Prompt Table: EX_TYPES_TBL |