CM_ITEM_LED_VW

(SQL View)
 Index Back

Primary book profiles

07/99 GMG CN800-9.0: Ties items' profiles, in books, in business units to ledgers and ledger groups where the item's transactions will be posted.

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.CM_BOOK , F.BUSINESS_UNIT_GL , E.LEDGER_GROUP , I.LEDGER , E.CM_BOOK_STATUS , G.DEFAULT_LEDGER_GRP , I.PRIMARY_LEDGER , A.CM_PROFILE_ID , B.CM_TYPE , B.CM_FLOW , B.CM_METHOD , B.CM_MATERIAL_METHOD , B.CM_LABOR_METHOD , B.CM_MACHINE_METHOD , B.CM_STOR_AREA_CNTRL , B.CM_WAIT_FINAL_COST FROM PS_CM_ITEM_METHOD A , PS_CM_PROFILE_DEFN B , PS_SET_CNTRL_REC C , PS_CM_PROFILES D , 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 WHERE C.RECNAME = 'CM_PROFILE_DEFN' AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.SETID = C.SETID AND B.CM_PROFILE_ID = A.CM_PROFILE_ID AND B.CM_TYPE = D.CM_TYPE AND B.CM_FLOW = D.CM_FLOW AND B.CM_METHOD = D.CM_METHOD AND B.CM_MATERIAL_METHOD = D.CM_MATERIAL_METHOD AND B.CM_LABOR_METHOD = D.CM_LABOR_METHOD AND B.CM_MACHINE_METHOD = D.CM_MACHINE_METHOD AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND A.CM_BOOK = E.CM_BOOK AND A.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)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
4 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
5 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
6 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
7 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
8 DEFAULT_LEDGER_GRP Character(1) VARCHAR2(1) NOT NULL Jrnl Generator Dflt Ledger Grp
9 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.
10 CM_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
11 CM_TYPE Character(2) VARCHAR2(2) NOT NULL 07/99 GMG CN800-9.0:
0=Non Cost
1=Actual
2=Std Cost
12 CM_FLOW Character(2) VARCHAR2(2) NOT NULL 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
0=Non Cost
2=Lot ID
3=Serial ID
4=FIFO
5=LIFO
13 CM_METHOD Character(2) VARCHAR2(2) NOT NULL 8/20/02 lee: added xlate 9 for retroactive perp average 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
0=Non Cost
1=Actual Cost
6=Perpetual Weighted Average
7=Periodic Weighted Average
8=Value at Current Standard
9=Retroactive Perpetual Average
14 CM_MATERIAL_METHOD Character(2) VARCHAR2(2) NOT NULL Material Cost Method
0=Not Applicable
1=Production ID Level
2=Serialized Assembly Level
15 CM_LABOR_METHOD Character(2) VARCHAR2(2) NOT NULL Labor Cost Method
0=Not Applicable
11=Standard Time-Conversion Rate
12=Standard Time-Crew Rate
21=Actual Time-Conversion Rate
22=Actual Time-Crew Rate
16 CM_MACHINE_METHOD Character(2) VARCHAR2(2) NOT NULL Machine Cost Method
0=Not Applicable
11=Standard Time-Conversion Rate
21=Actual Time-Conversion Rate
17 CM_STOR_AREA_CNTRL Character(1) VARCHAR2(1) NOT NULL CN# CM800-9.0 GMG Storage Area Control for Costing. If this flag is on (Y) depletions will only deplete receipts in the storage area from which the depletion was made. If it is off (N), depletions will not consider the storage area when selecting qualifying receipts to deplete.
18 CM_WAIT_FINAL_COST Character(1) VARCHAR2(1) NOT NULL 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements