CM_INQ_BOOK_VW

(SQL View)
 Index Back

Item Cost Inquiry Primary Book


SELECT E.BUSINESS_UNIT , E.CM_BOOK , F.BUSINESS_UNIT_GL , E.LEDGER_GROUP , I.LEDGER , E.CM_BOOK_STATUS , G.DEFAULT_LEDGER_GRP , I.PRIMARY_LEDGER , G.ALTACCT_OPTN , G.COMMITMENT_CNTL , J.AFFILIATE_USE FROM PS_CM_BU_BOOK_TBL E , PS_BUS_UNIT_TBL_IN F , PS_BU_LED_GRP_TBL G , PS_SET_CNTRL_REC H , PS_LED_GRP_LED_TBL I , PS_LED_GRP_FLD_TBL J WHERE E.BUSINESS_UNIT = F.BUSINESS_UNIT AND F.BUSINESS_UNIT_GL = G.BUSINESS_UNIT AND E.LEDGER_GROUP = G.LEDGER_GROUP AND H.RECNAME = 'LED_GRP_LED_TBL' AND H.SETCNTRLVALUE = F.BUSINESS_UNIT_GL AND I.SETID = H.SETID AND I.LEDGER_GROUP = G.LEDGER_GROUP AND (E.LEDGER = ' ' OR I.LEDGER = E.LEDGER) AND I.SETID = J.SETID AND I.LEDGER_GROUP = J.LEDGER_GROUP AND J.CHARTFIELD = 'BUSINESS_UNIT' AND G.DEFAULT_LEDGER_GRP = 'Y' AND I.PRIMARY_LEDGER = '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
3 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
4 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
5 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
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
7 DEFAULT_LEDGER_GRP Character(1) VARCHAR2(1) NOT NULL Jrnl Generator Dflt Ledger Grp
8 PRIMARY_LEDGER Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.
9 ALTACCT_OPTN Character(1) VARCHAR2(1) NOT NULL Enable Alternate Account
10 COMMITMENT_CNTL Character(1) VARCHAR2(1) NOT NULL Enable Commitment Control
11 AFFILIATE_USE Character(1) VARCHAR2(1) NOT NULL Use Affiliate