CM_RESFIFO_VW(SQL View) |
Index Back |
|---|---|
FIFO neg trans to be resolved |
| SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.CM_BOOK , A.DT_TIMESTAMP , A.SEQ_NBR , C.CM_DT_TIMESTAMP , C.CM_SEQ_NBR , A.CM_DT_TIMESTAMP_A , A.CM_SEQ_NBR_A , C.CM_DT_TIMESTAMP_P , C.CM_SEQ_NBR_P , C.TRANSACTION_DATE , A.STORAGE_AREA , A.INV_LOT_ID , A.SERIAL_ID , C.TRANSACTION_GROUP , A.PRODUCTION_ID , C.OP_SEQUENCE , A.CM_ONHAND_QTY , B.CM_FLOW , B.CM_METHOD , B.CM_STOR_AREA_CNTRL , B.CM_COST_NEG , C.CM_COST_PROC_GROUP , C.CONSIGNED_FLAG , C.TO_CONSIGNED_FLG , C.UNIT_MEASURE_STD , C.CM_DTTM_IN_EFFECT , C.CM_DTTM_STAMP FROM PS_CM_ONHAND_VW A , PS_CM_ITEM_METH_VW B , PS_CM_DEPLETE C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.CM_BOOK = B.CM_BOOK AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.INV_ITEM_ID = C.INV_ITEM_ID AND A.CM_BOOK = C.CM_BOOK AND A.DT_TIMESTAMP = C.CM_DT_TIMESTAMP AND A.SEQ_NBR = C.CM_SEQ_NBR AND C.CM_DUMMY_FLG = 'N' AND B.CM_FLOW = '4' AND A.CM_ONHAND_QTY < 0 |
| # | 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 | CM_DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Receipt dttm. |
| 7 | CM_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 8 | CM_DT_TIMESTAMP_A | DateTime(26) | TIMESTAMP | 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd. |
| 9 | CM_SEQ_NBR_A | Number(15,0) | DECIMAL(15) NOT NULL | 07/99 GMG CN800-9.0: |
| 10 | CM_DT_TIMESTAMP_P | DateTime(26) | TIMESTAMP | 07/99 GMG CN800-9.0: |
| 11 | CM_SEQ_NBR_P | Number(15,0) | DECIMAL(15) NOT NULL | 07/99 GMG CN800-9.0: |
| 12 | TRANSACTION_DATE | Date(10) | DATE | Transaction Date |
| 13 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 14 | INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 15 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 16 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 17 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 18 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 19 | CM_ONHAND_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 08/30/99 RML Changed from "onhand" to "on hand" |
| 20 | 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 |
| 21 | 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 |
| 22 | 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. |
| 23 | 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 |
| 24 | CM_COST_PROC_GROUP | Character(18) | VARCHAR2(18) NOT NULL | Cost Flow Record |
| 25 | CONSIGNED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Consigned Flag |
| 26 | TO_CONSIGNED_FLG | Character(1) | VARCHAR2(1) NOT NULL | To Consigned Flag |
| 27 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 28 | CM_DTTM_IN_EFFECT | DateTime(26) | TIMESTAMP | Date Timestamp |
| 29 | CM_DTTM_STAMP | DateTime(26) | TIMESTAMP | Date Timestamp |