CSH_OFF_CASHIER(SQL Table) |
Index Back |
|---|---|
Valid Cashiers for an Office |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
|
| 2 | Character(8) | VARCHAR2(8) NOT NULL |
Cashier's Office
Prompt Table: CSH_OFF_TBL |
|
| 3 | Character(30) | VARCHAR2(30) NOT NULL |
Cashier
Prompt Table: OPRIDDESC_VW |
|
| 4 | SUPERVISOR | Character(1) | VARCHAR2(1) NOT NULL |
Supervisor
Y/N Table Edit Default Value: N |
| 5 | CURRENT_REGISTER | Character(5) | VARCHAR2(5) NOT NULL | Current Cash Register |
| 6 | APPR_REQ_SW | Character(1) | VARCHAR2(1) NOT NULL |
Approval Required Switch
Y/N Table Edit Default Value: N |
| 7 | DEPT_ONLY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Department Only Cashier Flag
Y/N Table Edit Default Value: N |
| 8 | SUPERVISOR_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Supervisor Operator ID
Prompt Table: OPRIDDESC_VW |
| 9 | STUDENT_PAY_PRT | Character(1) | VARCHAR2(1) NOT NULL |
Student Payment Print
A=Automatic P=Pushbutton Default Value: P |
| 10 | CORP_PAY_PRT | Character(1) | VARCHAR2(1) NOT NULL |
Corporate Payment Print
A=Automatic P=Pushbutton Default Value: P |
| 11 | DEPT_RCPT_PRT | Character(1) | VARCHAR2(1) NOT NULL |
Department Receipt Print
A=Automatic P=Pushbutton Default Value: P |
| 12 | CASH_CHECK_PRT | Character(1) | VARCHAR2(1) NOT NULL |
Cash Check Print
A=Automatic P=Pushbutton Default Value: P |