CSH_OFF_CASHIER(SQL Table) |
Index Back |
---|---|
Valid Cashiers for an Office |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
2 | CASHIER_OFFICE | Character(8) | VARCHAR2(8) NOT NULL |
Cashier's Office
Prompt Table: CSH_OFF_TBL |
3 | CASHIER | 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 |