CM_DEPLOT_VW(SQL View) |
Index Back |
|---|---|
Deplete Lot ID View06/03 dmw : use cm_depletion_vw for neg inventory cost option 01/04 dmw : 8.9 add cm_type |
| SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.CM_BOOK , A.DT_TIMESTAMP , A.SEQ_NBR , A.TRANSACTION_DATE , A.STORAGE_AREA , A.INV_LOT_ID , A.SERIAL_ID , A.CM_COST_PROC_GROUP , A.TRANSACTION_GROUP , A.PRODUCTION_ID , A.OP_SEQUENCE , A.CM_QTY_TO_PROC , A.UNIT_MEASURE_STD , A.CONSIGNED_FLAG , A.TO_CONSIGNED_FLG , A.CM_DTTM_IN_EFFECT , A.CM_DTTM_STAMP , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.PROCESS_INSTANCE , A.POSTED_FLAG , B.CM_FLOW , B.CM_METHOD , B.CM_STOR_AREA_CNTRL , B.CM_COST_NEG , B.CM_TYPE FROM PS_CM_DEPLETION_VW A , PS_CM_ITEM_METH_VW B WHERE %Join(COMMON_KEYS, CM_DEPLETION_VW A, CM_ITEM_METH_VW B) AND B.CM_FLOW = '2' AND A.POSTED_FLAG = 'N' |
| # | 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 | DT_TIMESTAMP |
DateTime(26) | TIMESTAMP | Date Timestamp |
| 5 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 6 | TRANSACTION_DATE | Date(10) | DATE | Transaction Date |
| 7 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 8 | INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 9 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 10 | CM_COST_PROC_GROUP | Character(18) | VARCHAR2(18) NOT NULL | Cost Flow Record |
| 11 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 12 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 13 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 14 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Quantity |
| 15 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 16 | CONSIGNED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Consigned Flag |
| 17 | TO_CONSIGNED_FLG | Character(1) | VARCHAR2(1) NOT NULL | To Consigned Flag |
| 18 | CM_DTTM_IN_EFFECT | DateTime(26) | TIMESTAMP | Date Timestamp |
| 19 | CM_DTTM_STAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
| 20 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 21 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 22 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 23 | POSTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted X=Don't Post Y=Posted |
| 24 | 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 |
| 25 | 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 |
| 26 | 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. |
| 27 | CM_COST_NEG | Character(1) | VARCHAR2(1) NOT NULL |
Insufficient Qty Cost Option
0=Don't cost if insufficient qty 1=Cost to point of zero quantity 2=Cost in Regular Mode Only 3=Always cost insufficient qty |
| 28 | CM_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
07/99 GMG CN800-9.0:
0=Non Cost 1=Actual 2=Std Cost |