BUSINESS_UNITCM_BOOKPrompt Table: CM_BOOK_DEFN
A=Active
C=Cancel
I=Inactive
P=Pending
S=Stopped
CM_BU_BOOK_VW(SQL View) |
Index Back |
|---|---|
Book in Business Unit View |
| SELECT BUSINESS_UNIT , CM_BOOK , cm_book_status FROM PS_CM_BU_BOOK_TBL WHERE CM_BOOK_STATUS = 'A' OR CM_BOOK_STATUS='P' |
| # | 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 | 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 |