CM_WC_OTHER_VW(SQL View) |
Index Back |
|---|---|
TRANSACTION_INV rows in error |
| SELECT A.BUSINESS_UNIT , A.CM_BOOK , A.TRANSACTION_DATE , A.INV_ITEM_ID , A.TRANSACTION_GROUP , A.DT_TIMESTAMP , A.DESCR50 , A.COSTED_FLAG , A.SEQ_NBR , A.CM_DT_TIMESTAMP_A , A.CM_SEQ_NBR_A , A.CM_DT_TIMESTAMP , A.CM_SEQ_NBR , A.CM_SEQ_VARIANCE , A.FROM_PRDN_ID , A.TO_PRDN_ID , A.BUSINESS_UNIT_RECV , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.DISTRIB_LINE_NUM , A.CM_SEQ_COST , A.MISC_CHARGE_CODE , A.RTV_ID , A.RTV_LN_NBR , A.RTV_DISTRIB_NUM , A.PROCESS_INSTANCE , A.MESSAGE_SET_NBR , 203 , A.MG_PROC_INSTANCE , A.PRODUCTION_ID , A.OP_SEQUENCE , A.COST_ELEMENT , A.TRANS_DATE , A.TRANS_TIME , A.CONVERSION_TYPE , A.REVALUE_FLAG FROM PS_CM_NP_TRAN1_VW A UNION SELECT B.BUSINESS_UNIT , B.CM_BOOK , B.TRANSACTION_DATE , B.INV_ITEM_ID , B.TRANSACTION_GROUP , B.DT_TIMESTAMP , B.DESCR50 , B.POSTED_FLAG , B.SEQ_NBR , B.CM_DT_TIMESTAMP_A , B.CM_SEQ_NBR_A , B.CM_DT_TIMESTAMP , B.CM_SEQ_NBR , B.CM_SEQ_VARIANCE , B.FROM_PRDN_ID , B.TO_PRDN_ID , B.BUSINESS_UNIT_RECV , B.RECEIVER_ID , B.RECV_LN_NBR , B.RECV_SHIP_SEQ_NBR , B.DISTRIB_LINE_NUM , B.CM_SEQ_COST , B.MISC_CHARGE_CODE , B.RTV_ID , B.RTV_LN_NBR , B.RTV_DISTRIB_NUM , B.PROCESS_INSTANCE , B.MESSAGE_SET_NBR , 186 , B.MG_PROC_INSTANCE , B.PRODUCTION_ID , B.OP_SEQUENCE , B.COST_ELEMENT , B.TRANS_DATE , B.TRANS_TIME , B.CONVERSION_TYPE , B.REVALUE_FLAG FROM PS_CM_NP_INTRAN_VW B UNION SELECT D.BUSINESS_UNIT , D.CM_BOOK , D.TRANSACTION_DATE , D.INV_ITEM_ID , D.TRANSACTION_GROUP , D.DT_TIMESTAMP , D.DESCR50 , D.POSTED_FLAG , D.SEQ_NBR , D.CM_DT_TIMESTAMP_A , D.CM_SEQ_NBR_A , D.CM_DT_TIMESTAMP , D.CM_SEQ_NBR , D.CM_SEQ_VARIANCE , D.FROM_PRDN_ID , D.TO_PRDN_ID , D.BUSINESS_UNIT_RECV , D.RECEIVER_ID , D.RECV_LN_NBR , D.RECV_SHIP_SEQ_NBR , D.DISTRIB_LINE_NUM , D.CM_SEQ_COST , D.MISC_CHARGE_CODE , D.RTV_ID , D.RTV_LN_NBR , D.RTV_DISTRIB_NUM , D.PROCESS_INSTANCE , D.MESSAGE_SET_NBR , 194 , D.MG_PROC_INSTANCE , D.PRODUCTION_ID , D.OP_SEQUENCE , D.COST_ELEMENT , D.TRANS_DATE , D.TRANS_TIME , D.CONVERSION_TYPE , D.REVALUE_FLAG FROM PS_CM_NP_REC_VW D UNION SELECT F.BUSINESS_UNIT , F.CM_BOOK , F.TRANSACTION_DATE , F.INV_ITEM_ID , F.TRANSACTION_GROUP , F.DT_TIMESTAMP , F.DESCR50 , F.POSTED_FLAG , F.SEQ_NBR , F.CM_DT_TIMESTAMP_A , F.CM_SEQ_NBR_A , F.CM_DT_TIMESTAMP , F.CM_SEQ_NBR , F.CM_SEQ_VARIANCE , F.FROM_PRDN_ID , F.TO_PRDN_ID , F.BUSINESS_UNIT_RECV , F.RECEIVER_ID , F.RECV_LN_NBR , F.RECV_SHIP_SEQ_NBR , F.DISTRIB_LINE_NUM , F.CM_SEQ_COST , F.MISC_CHARGE_CODE , F.RTV_ID , F.RTV_LN_NBR , F.RTV_DISTRIB_NUM , F.PROCESS_INSTANCE , F.MESSAGE_SET_NBR , 182 , F.MG_PROC_INSTANCE , F.PRODUCTION_ID , F.OP_SEQUENCE , F.COST_ELEMENT , F.TRANS_DATE , F.TRANS_TIME , F.CONVERSION_TYPE , F.REVALUE_FLAG FROM PS_CM_NP_DEP_VW F UNION SELECT G.BUSINESS_UNIT , G.CM_BOOK , G.TRANSACTION_DATE , G.INV_ITEM_ID , G.TRANSACTION_GROUP , G.DT_TIMESTAMP , G.DESCR50 , G.POSTED_FLAG , G.SEQ_NBR , G.CM_DT_TIMESTAMP_A , G.CM_SEQ_NBR_A , G.CM_DT_TIMESTAMP , G.CM_SEQ_NBR , G.CM_SEQ_VARIANCE , G.FROM_PRDN_ID , G.TO_PRDN_ID , G.BUSINESS_UNIT_RECV , G.RECEIVER_ID , G.RECV_LN_NBR , G.RECV_SHIP_SEQ_NBR , G.DISTRIB_LINE_NUM , G.CM_SEQ_COST , G.MISC_CHARGE_CODE , G.RTV_ID , G.RTV_LN_NBR , G.RTV_DISTRIB_NUM , G.PROCESS_INSTANCE , G.MESSAGE_SET_NBR , 204 , G.MG_PROC_INSTANCE , G.PRODUCTION_ID , G.OP_SEQUENCE , G.COST_ELEMENT , G.TRANS_DATE , G.TRANS_TIME , G.CONVERSION_TYPE , G.REVALUE_FLAG FROM PS_CM_NP_TVAR_VW G UNION SELECT H.BUSINESS_UNIT , H.CM_BOOK , H.TRANSACTION_DATE , H.INV_ITEM_ID , H.TRANSACTION_GROUP , H.DT_TIMESTAMP , H.DESCR50 , H.POSTED_FLAG , H.SEQ_NBR , H.CM_DT_TIMESTAMP_A , H.CM_SEQ_NBR_A , H.CM_DT_TIMESTAMP , H.CM_SEQ_NBR , H.CM_SEQ_VARIANCE , H.FROM_PRDN_ID , H.TO_PRDN_ID , H.BUSINESS_UNIT_RECV , H.RECEIVER_ID , H.RECV_LN_NBR , H.RECV_SHIP_SEQ_NBR , H.DISTRIB_LINE_NUM , H.CM_SEQ_COST , H.MISC_CHARGE_CODE , H.RTV_ID , H.RTV_LN_NBR , H.RTV_DISTRIB_NUM , H.PROCESS_INSTANCE , H.MESSAGE_SET_NBR , 201 , H.MG_PROC_INSTANCE , H.PRODUCTION_ID , H.OP_SEQUENCE , H.COST_ELEMENT , H.TRANS_DATE , H.TRANS_TIME , H.CONVERSION_TYPE , H.REVALUE_FLAG FROM PS_CM_NP_SHIPB_VW H UNION SELECT I.BUSINESS_UNIT , I.CM_BOOK , I.TRANSACTION_DATE , I.INV_ITEM_ID , I.TRANSACTION_GROUP , I.DT_TIMESTAMP , I.DESCR50 , I.COSTED_FLAG , I.SEQ_NBR , I.CM_DT_TIMESTAMP_A , I.CM_SEQ_NBR_A , I.CM_DT_TIMESTAMP , I.CM_SEQ_NBR , I.CM_SEQ_VARIANCE , I.FROM_PRDN_ID , I.TO_PRDN_ID , I.BUSINESS_UNIT_RECV , I.RECEIVER_ID , I.RECV_LN_NBR , I.RECV_SHIP_SEQ_NBR , I.DISTRIB_LINE_NUM , I.CM_SEQ_COST , I.MISC_CHARGE_CODE , I.RTV_ID , I.RTV_LN_NBR , I.RTV_DISTRIB_NUM , I.PROCESS_INSTANCE , I.MESSAGE_SET_NBR , 219 , I.MG_PROC_INSTANCE , I.PRODUCTION_ID , I.OP_SEQUENCE , I.COST_ELEMENT , I.TRANS_DATE , I.TRANS_TIME , I.CONVERSION_TYPE , I.REVALUE_FLAG FROM PS_CM_NP_RTOKIT_VW I UNION SELECT J.BUSINESS_UNIT , J.CM_BOOK , J.TRANSACTION_DATE , J.INV_ITEM_ID , J.TRANSACTION_GROUP , J.DT_TIMESTAMP , J.DESCR50 , J.POSTED_FLAG , J.SEQ_NBR , J.CM_DT_TIMESTAMP_A , J.CM_SEQ_NBR_A , J.CM_DT_TIMESTAMP , J.CM_SEQ_NBR , J.CM_SEQ_VARIANCE , J.FROM_PRDN_ID , J.TO_PRDN_ID , J.BUSINESS_UNIT_RECV , J.RECEIVER_ID , J.RECV_LN_NBR , J.RECV_SHIP_SEQ_NBR , J.DISTRIB_LINE_NUM , J.CM_SEQ_COST , J.MISC_CHARGE_CODE , J.RTV_ID , J.RTV_LN_NBR , J.RTV_DISTRIB_NUM , J.PROCESS_INSTANCE , J.MESSAGE_SET_NBR , 207 , J.MG_PROC_INSTANCE , J.PRODUCTION_ID , J.OP_SEQUENCE , J.COST_ELEMENT , J.TRANS_DATE , J.TRANS_TIME , J.CONVERSION_TYPE , J.REVALUE_FLAG FROM PS_CM_NP_VAR_VW J UNION SELECT K.BUSINESS_UNIT , K.CM_BOOK , K.TRANSACTION_DATE , K.INV_ITEM_ID , K.TRANSACTION_GROUP , K.DT_TIMESTAMP , K.DESCR50 , K.COSTED_FLAG , K.SEQ_NBR , K.CM_DT_TIMESTAMP_A , K.CM_SEQ_NBR_A , K.CM_DT_TIMESTAMP , K.CM_SEQ_NBR , K.CM_SEQ_VARIANCE , K.FROM_PRDN_ID , K.TO_PRDN_ID , K.BUSINESS_UNIT_RECV , K.RECEIVER_ID , K.RECV_LN_NBR , K.RECV_SHIP_SEQ_NBR , K.DISTRIB_LINE_NUM , K.CM_SEQ_COST , K.MISC_CHARGE_CODE , K.RTV_ID , K.RTV_LN_NBR , K.RTV_DISTRIB_NUM , K.PROCESS_INSTANCE , K.MESSAGE_SET_NBR , 190 , K.MG_PROC_INSTANCE , K.PRODUCTION_ID , K.OP_SEQUENCE , K.COST_ELEMENT , K.TRANS_DATE , K.TRANS_TIME , K.CONVERSION_TYPE , K.REVALUE_FLAG FROM PS_CM_NP_MATCH_VW K UNION SELECT L.BUSINESS_UNIT , L.CM_BOOK , L.TRANSACTION_DATE , L.INV_ITEM_ID , L.TRANSACTION_GROUP , L.DT_TIMESTAMP , L.DESCR50 , L.COSTED_FLAG , L.SEQ_NBR , L.CM_DT_TIMESTAMP_A , L.CM_SEQ_NBR_A , L.CM_DT_TIMESTAMP , L.CM_SEQ_NBR , L.CM_SEQ_VARIANCE , L.FROM_PRDN_ID , L.TO_PRDN_ID , L.BUSINESS_UNIT_RECV , L.RECEIVER_ID , L.RECV_LN_NBR , L.RECV_SHIP_SEQ_NBR , L.DISTRIB_LINE_NUM , L.CM_SEQ_COST , L.MISC_CHARGE_CODE , L.RTV_ID , L.RTV_LN_NBR , L.RTV_DISTRIB_NUM , L.PROCESS_INSTANCE , L.MESSAGE_SET_NBR , 196 , L.MG_PROC_INSTANCE , L.PRODUCTION_ID , L.OP_SEQUENCE , L.COST_ELEMENT , L.TRANS_DATE , L.TRANS_TIME , L.CONVERSION_TYPE , L.REVALUE_FLAG FROM PS_CM_NP_RMATCH_VW L UNION SELECT M.BUSINESS_UNIT , M.CM_BOOK , M.TRANSACTION_DATE , M.INV_ITEM_ID , M.TRANSACTION_GROUP , M.DT_TIMESTAMP , M.DESCR50 , M.COSTED_FLAG , M.SEQ_NBR , M.CM_DT_TIMESTAMP_A , M.CM_SEQ_NBR_A , M.CM_DT_TIMESTAMP , M.CM_SEQ_NBR , M.CM_SEQ_VARIANCE , M.FROM_PRDN_ID , M.TO_PRDN_ID , M.BUSINESS_UNIT_RECV , M.RECEIVER_ID , M.RECV_LN_NBR , M.RECV_SHIP_SEQ_NBR , M.DISTRIB_LINE_NUM , M.CM_SEQ_COST , M.MISC_CHARGE_CODE , M.RTV_ID , M.RTV_LN_NBR , M.RTV_DISTRIB_NUM , M.PROCESS_INSTANCE , M.MESSAGE_SET_NBR , 191 , M.MG_PROC_INSTANCE , M.PRODUCTION_ID , M.OP_SEQUENCE , M.COST_ELEMENT , M.TRANS_DATE , M.TRANS_TIME , M.CONVERSION_TYPE , M.REVALUE_FLAG FROM PS_CM_NP_MATCHB_VW M UNION SELECT S.BUSINESS_UNIT , S.CM_BOOK , S.TRANSACTION_DATE , S.INV_ITEM_ID , S.TRANSACTION_GROUP , S.DT_TIMESTAMP , S.DESCR50 , S.POSTED_FLAG , S.SEQ_NBR , S.CM_DT_TIMESTAMP_A , S.CM_SEQ_NBR_A , S.CM_DT_TIMESTAMP , S.CM_SEQ_NBR , S.CM_SEQ_VARIANCE , S.FROM_PRDN_ID , S.TO_PRDN_ID , S.BUSINESS_UNIT_RECV , S.RECEIVER_ID , S.RECV_LN_NBR , S.RECV_SHIP_SEQ_NBR , S.DISTRIB_LINE_NUM , S.CM_SEQ_COST , S.MISC_CHARGE_CODE , S.RTV_ID , S.RTV_LN_NBR , S.RTV_DISTRIB_NUM , S.PROCESS_INSTANCE , S.MESSAGE_SET_NBR , 207 , S.MG_PROC_INSTANCE , S.PRODUCTION_ID , S.OP_SEQUENCE , S.COST_ELEMENT , S.TRANS_DATE , S.TRANS_TIME , S.CONVERSION_TYPE , S.REVALUE_FLAG FROM PS_CM_NP_DVAR_VW S |
| # | 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 | TRANSACTION_DATE | Date(10) | DATE | Transaction Date |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 6 | DT_TIMESTAMP |
DateTime(26) | TIMESTAMP | Date Timestamp |
| 7 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 8 | COSTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Cost status of the transaction. Contains two values: 'N' cost have not been calculated for the transaction and 'Y' cost have been calculated for the transaction
E=Error; Cannot process N=Transaction is Not Costed P=Qualified for Purging X=Transaction Won't be Costed Y=Transaction is Costed |
| 9 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 10 | CM_DT_TIMESTAMP_A | DateTime(26) | TIMESTAMP | 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd. |
| 11 | CM_SEQ_NBR_A | Number(15,0) | DECIMAL(15) NOT NULL | 07/99 GMG CN800-9.0: |
| 12 | CM_DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Receipt dttm. |
| 13 | CM_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 14 | CM_SEQ_VARIANCE | Number(15,0) | DECIMAL(15) NOT NULL | 07/99 GMG CN800-9.0: |
| 15 | FROM_PRDN_ID | Character(10) | VARCHAR2(10) NOT NULL | From Production ID |
| 16 | TO_PRDN_ID | Character(10) | VARCHAR2(10) NOT NULL | To Production ID |
| 17 | BUSINESS_UNIT_RECV | Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 18 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 19 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 20 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 21 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 22 | CM_SEQ_COST | Number(15,0) | DECIMAL(15) NOT NULL | Cost Sequence Number. Incremented each time the actual cost is updated. |
| 23 | MISC_CHARGE_CODE | Character(10) | VARCHAR2(10) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 24 | RTV_ID | Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |
| 25 | RTV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Return To Vendor Line |
| 26 | RTV_DISTRIB_NUM | Number(5,0) | INTEGER NOT NULL | RTV Distribution Number |
| 27 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 28 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 29 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 30 | MG_PROC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 31 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 32 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 33 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 34 | TRANS_DATE | Date(10) | DATE | Transaction Date |
| 35 | TRANS_TIME | Time(15) | TIMESTAMP | Transaction Time |
| 36 | CONVERSION_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Conversion Type
1100=Lab Setup 1200=Lab Fixed 1300=Labor Run 1400=Lab PostPr 1500=Mach Setup 1600=Mach Fixed 1700=Mach Run 1800=MC PostPrd 2100=Ovhd 1 2200=Ovhd 2 2300=Ovhd 3 2400=Ovhd 4 |
| 37 | REVALUE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated. |