CSH_OFF_TBL

(SQL Table)
 Index Back

Cashiering Office Table

  • Related Language Record: CSH_OFF_LNG

  • Parent Record Of CSH_BUS_DT_TBL CSH_CC_RCPT_VW CSH_DP_RCPT_VW CSH_ID_RCPT_VW CSH_MSG_BD CSH_MSG_TG CSH_MSG_TN CSH_OFF_CASHIER CSH_OFF_CSHR_VW CSH_OFF_POST_VW CSH_OFF_RCL_NVW CSH_OFF_RCL_PVW CSH_OFF_RECEIPT CSH_OFF_RECP_VW CSH_OFF_REC_VW CSH_OFF_REC_VW2 CSH_OFF_REGISTR CSH_OFF_REGS_VW CSH_OR_RCPT_VW CSH_OR_RCPT_VW2 CSH_PM_RCPT_VW CSH_PM_RCPT_VW2 CSH_RPL_RCPT_VW

    • # 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
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: CSH_OFF_TBL.DESCR

    5 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description

    Default Value: CSH_OFF_TBL.DESCR

    6 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL

    7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: CAMPUS_LOC_TBL

    8 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL Base Currency

    Default Value: BUS_UNIT_TBL_SF.BASE_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    9 CHK_CASH_TARGET Character(10) VARCHAR2(10) NOT NULL Check Cashing Target

    Prompt Table: TARGET_KEY_TBL

    10 CHECK_CASHING_FEE Number(6,2) DECIMAL(5,2) NOT NULL Check Cashing Fee
    11 CURRENT_BUS_DT Date(10) DATE Current Business Date
    12 BALANCE_BY Character(1) VARCHAR2(1) NOT NULL Balance By
    C=Balance by Cashier
    R=Balance by Register

    Default Value: C

    13 APPROVAL_FLAG Character(1) VARCHAR2(1) NOT NULL Approval Flag

    Y/N Table Edit

    Default Value: N

    14 CSH_APPR_ROLE Character(30) VARCHAR2(30) NOT NULL Cashier Approval Role

    Prompt Table: ROLE_DEFN_VW

    15 GL_INTERFACE_REQ Character(1) VARCHAR2(1) NOT NULL GL Interface Required

    Y/N Table Edit

    Default Value: N

    16 TENDER_KEY Character(10) VARCHAR2(10) NOT NULL Tender Key

    Prompt Table: TENDER_KEY_TBL

    17 CLOSE_OFFICE_LIMIT Number(3,0) SMALLINT NOT NULL Open/Close Office Retrieval
    18 OVER_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Over Business Unit

    Prompt Table: BUS_UNIT_TBL_FS

    19 OVER_LEDGER Character(10) VARCHAR2(10) NOT NULL Over Ledger

    Prompt Table: LED_DEFN_TBL
    Set Control Field: OVER_BUS_UNIT

    20 OVER_ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCOUNT_TBL
    Set Control Field: OVER_BUS_UNIT

    21 OVER_DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: %EDITTABLE14
    Set Control Field: OVER_BUS_UNIT

    22 OVER_PROJ_ID Character(15) VARCHAR2(15) NOT NULL Project ID

    Prompt Table: %EDITTABLE13
    Set Control Field: OVER_BUS_UNIT

    23 OVER_PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
    24 OVER_FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

    Prompt Table: FUND_TBL
    Set Control Field: OVER_BUS_UNIT

    25 OVER_PROG_CODE Character(5) VARCHAR2(5) NOT NULL Program Code

    Prompt Table: PROGRAM_TBL
    Set Control Field: OVER_BUS_UNIT

    26 OVER_CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.

    Prompt Table: CLASS_CF_TBL
    Set Control Field: OVER_BUS_UNIT

    27 OVER_AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field

    Prompt Table: AFFILIATE_VW

    28 OVER_OP_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit
    29 OVER_ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    30 OVER_BUD_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield

    Prompt Table: BUD_REF_TBL
    Set Control Field: OVER_BUS_UNIT

    31 OVER_CF1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1

    Prompt Table: CHARTFIELD1_TBL
    Set Control Field: OVER_BUS_UNIT

    32 OVER_CF2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 2

    Prompt Table: CHARTFIELD2_TBL
    Set Control Field: OVER_BUS_UNIT

    33 OVER_CF3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 3

    Prompt Table: CHARTFIELD3_TBL
    Set Control Field: OVER_BUS_UNIT

    34 OVER_AFF_INT1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
    35 OVER_AFF_INT2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
    36 OVER_EXT_CHRT Character(50) VARCHAR2(50) NOT NULL External GL Chart Field
    37 WRITEOFF_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_FS

    38 WRITEOFF_LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

    Prompt Table: LED_DEFN_TBL
    Set Control Field: WRITEOFF_BUS_UNIT

    39 WRITEOFF_ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCOUNT_TBL
    Set Control Field: WRITEOFF_BUS_UNIT

    40 WRITEOFF_DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: %EDITTABLE14
    Set Control Field: WRITEOFF_BUS_UNIT

    41 WRITEOFF_PROJ_ID Character(15) VARCHAR2(15) NOT NULL Project ID

    Prompt Table: %EDITTABLE18
    Set Control Field: WRITEOFF_BUS_UNIT

    42 WRITEOFF_PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
    43 WRITEOFF_FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

    Prompt Table: FUND_TBL
    Set Control Field: WRITEOFF_BUS_UNIT

    44 WRITEOFF_PROG_CODE Character(5) VARCHAR2(5) NOT NULL Program Code

    Prompt Table: PROGRAM_TBL
    Set Control Field: WRITEOFF_BUS_UNIT

    45 WRITEOFF_CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.

    Prompt Table: CLASS_CF_TBL
    Set Control Field: WRITEOFF_BUS_UNIT

    46 WRITEOFF_AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field

    Prompt Table: SF_AFFILIATE_VW

    47 WRITEOFF_OP_UNIT Character(8) VARCHAR2(8) NOT NULL Writeoff Operating Unit
    48 WRITEOFF_ALTACCT Character(10) VARCHAR2(10) NOT NULL Writeoff Alternate Account
    49 WRITEOFF_BUD_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield

    Prompt Table: BUD_REF_TBL
    Set Control Field: WRITEOFF_BUS_UNIT

    50 WRITEOFF_CF1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1

    Prompt Table: CHARTFIELD1_TBL
    Set Control Field: WRITEOFF_BUS_UNIT

    51 WRITEOFF_CF2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 2

    Prompt Table: CHARTFIELD2_TBL
    Set Control Field: WRITEOFF_BUS_UNIT

    52 WRITEOFF_CF3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 3

    Prompt Table: CHARTFIELD3_TBL
    Set Control Field: WRITEOFF_BUS_UNIT

    53 WRITEOFF_AFF_INT1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
    54 WRITEOFF_AFF_INT2 Character(10) VARCHAR2(10) NOT NULL Writeoff Operating Unit Affiliate
    55 WRITEOFF_EXT_CHRT Character(50) VARCHAR2(50) NOT NULL External GL Chart Field
    56 SUPERVISOR_DIR_RPT Character(1) VARCHAR2(1) NOT NULL This field is used by Cashiering to determine where to retrieve a Supervisor's direct reports. This is used by the Void Receipts panel when retrieving receipts for all cashiers assigned to a particular Supervisor.
    C=Student Financials Data
    H=Human Resources Data

    Default Value: C

    57 TRANSFER_ON_VOID Character(1) VARCHAR2(1) NOT NULL Transfer after void

    Y/N Table Edit

    Default Value: N

    58 DELAY_RECEIPT_POST Character(1) VARCHAR2(1) NOT NULL Delay Receipt Posting
    G=Group Post
    N=No posting delay
    Y=Delay posting

    Default Value: N

    59 ALLOW_UNPOST_CLOSE Character(1) VARCHAR2(1) NOT NULL Posted Close Required

    Y/N Table Edit

    Default Value: N

    60 GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Group Type

    Prompt Table: GROUP_TYPE_TBL

    61 ORIGIN_ID Character(5) VARCHAR2(5) NOT NULL Origin ID

    Prompt Table: ORIGIN_SF_VW

    62 ALLOW_UNAPPR_CLOSE Character(1) VARCHAR2(1) NOT NULL Approved Close Required

    Y/N Table Edit

    Default Value: N

    63 MAX_CASH_CHECK_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Check Cashing Maximum
    64 RECEIPT_PRINT_PROD Character(1) VARCHAR2(1) NOT NULL Receipt Print Product
    B=BI Publisher
    C=Crystal
    J=JetForm

    Default Value: B

    65 SF_MERCHANT_ID Character(12) VARCHAR2(12) NOT NULL SF Merchant ID

    Prompt Table: MERCHANT_TBL

    66 CR_CARD_RT_OVRRIDE Character(1) VARCHAR2(1) NOT NULL Realtime Transaction Override

    Y/N Table Edit

    Default Value: N

    67 SF_POST_AUTH Character(1) VARCHAR2(1) NOT NULL Post Unprocessed Authorization

    Y/N Table Edit

    Default Value: N

    68 USE_FORMS_ENGINE Character(1) VARCHAR2(1) NOT NULL Indicator of whether Forms Engine is being used.

    Y/N Table Edit

    Default Value: N