CSH_OFF_CASHIER

(SQL Table)
Index Back

Valid Cashiers for an Office

  • Parent record: CSH_OFF_TBL
  • # 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