CM_BU_BOOK_VW1

(SQL View)
Index Back

Books for Accounting Line Gen

06/04/99 ebn CN#CM800-9.0 : Added for LIFO/FIFO.

SELECT BUSINESS_UNIT, CM_BOOK FROM PS_CM_BU_BOOK_TBL WHERE CM_BOOK_STATUS = 'A' AND CREATE_ACCOUNTING = 'Y'

# 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