CM_BU_BOOK_TBL

(SQL Table)
 Index Back

Book in Business Unit

01/18/99 RML CM800-9.0: Created new record to keep book per business unit 06/01/99 RML CM800-9.0 Added field CREATE_ACCOUNTING 06/02/99 RML Added code to validate base currency; business_unit.RIn and business_unit.SEd; display warning message if create accounting entries checkbox is unchecked (FEd) 06/08/99 RML Added new field cm_book_start_dt and changed peoplecode; replaced cm_cost_wrk.date_wrk with cm_book_start_dt. 08/23/99 RML Changed cm_book_start_dt to Required; cm_book_start to non-required. 10/19/99 RML Make both date fields non-required; write PC to check to make sure it has a date. 09/22/00 TW default changed to 'Y' for create_accounting. 11/30/2001 8.4 change prompt tables for LEDGER & LEDGER_GROUP to secured views.

  • Parent record: BUS_UNIT_TBL_IN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book

    Prompt Table: CM_BOOK_DEFN

    3 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

    Prompt Table: SP_CMLGRP_NONVW

    4 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

    Prompt Table: SP_CMLEDG_NONVW

    5 CM_BOOK_START DateTime(26) TIMESTAMP 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
    6 CM_BOOK_STATUS Character(1) VARCHAR2(1) NOT NULL 06/30/99 RML Changed Long Name
    A=Active
    C=Cancel
    I=Inactive
    P=Pending
    S=Stopped

    Default Value: P

    7 CREATE_ACCOUNTING Character(1) VARCHAR2(1) NOT NULL Create Accounting Entries

    Y/N Table Edit

    Default Value: Y

    8 CM_BOOK_START_DT Date(10) DATE Created on 06/08/99 RML CM800-9.0 To compare Mfg tables with transaction dates (per Ed Nowak)
    9 CM_FUNCLIB Character(1) VARCHAR2(1) NOT NULL Functions
    10 CE_COST_TYPE Character(4) VARCHAR2(4) NOT NULL Cost Type

    Prompt Table: CE_TYPE_VW