CM_CST_PSCRP_VW(SQL View) |
Index Back |
|---|---|
Costed Assy Scrap ViewGMG CN# CM750-8.0 Changes for SEQ_NBR field; value assigned by Accounting to achieve unique rows. GMG CN# CM750-10 Added condition where revalue_flag = 'N' to exclude WIP revalue rows from set. Add revalue_flag to keys 07/21/99 ebn CN#CM800-9.0 Changed keys to reflect changes made to sf_scrapcost keys. Incorporated table SF_SCRAPCOSTB into view. |
| SELECT A.MG_PROC_INSTANCE , A.BUSINESS_UNIT , A.PRODUCTION_ID , A.OP_SEQUENCE , A.COST_ELEMENT , A.TRANS_DATE , A.TRANS_TIME , A.SEQ_NBR , A.REVALUE_FLAG , A.CM_BOOK , B.INV_ITEM_ID , B.UNIT_MEASURE_STD , B.PRDN_AREA_CODE , B.PRODUCTION_TYPE , B.SCRAPPED_QTY , B.QTY_BASE , (B.TL_SCRAP_AMT + B.LL_SCRAP_AMT) , B.DISTRIB_TYPE , A.POSTED_FLAG , A.PROCESS_INSTANCE , B.TL_SCRAP_AMT , B.LL_SCRAP_AMT , B.PERCENT_COMP , B.REASON_CD , A.PROCESS_FLAG , B.OPRID , '250' , G.BUSINESS_UNIT_GL , G.BASE_CURRENCY , G.BASE_CURRENCY , G.APPL_JRNL_ID , A.TRANS_DATE FROM PS_CM_CST_PSCPU_VW A , PS_SF_SCRAPCOST B , PS_BUS_UNIT_TBL_IN G WHERE A.MG_PROC_INSTANCE = B.MG_PROC_INSTANCE AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PRODUCTION_ID = B.PRODUCTION_ID AND A.OP_SEQUENCE = B.OP_SEQUENCE AND A.COST_ELEMENT = B.COST_ELEMENT AND A.TRANS_DATE = B.TRANS_DATE AND A.TRANS_TIME = B.TRANS_TIME AND A.SEQ_NBR = B.SEQ_NBR AND A.REVALUE_FLAG = B.REVALUE_FLAG AND %Join(COMMON_KEYS, SF_SCRAPCOST B, BUS_UNIT_TBL_IN G) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  MG_PROC_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 4 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 5 | COST_ELEMENT |
Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 6 | TRANS_DATE |
Date(10) | DATE NOT NULL | Transaction Date |
| 7 | TRANS_TIME |
Time(15) | TIMESTAMP NOT NULL | Transaction Time |
| 8 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 9 | 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.
Y/N Table Edit |
| 10 | CM_BOOK |
Character(10) | VARCHAR2(10) NOT NULL | Cost Book |
| 11 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 12 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 13 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 14 | PRODUCTION_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production RW=Rework SV=Service TD=Teardown |
| 15 | SCRAPPED_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Scrapped Qty |
| 16 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL |
Base Quantity
Default Value: 1 |
| 17 | CE_EXTENDED_COST | Signed Number(32,15) | DECIMAL(30,15) NOT NULL | Extended Cost |
| 18 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Distrib. Type |
| 19 | 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 |
| 20 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 21 | TL_SCRAP_AMT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This Level Scrap Amount |
| 22 | LL_SCRAP_AMT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Lower Level Scrap Amount |
| 23 | PERCENT_COMP | Number(6,2) | DECIMAL(5,2) NOT NULL | Scrap Prdn Pct |
| 24 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
| 25 | PROCESS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Process Flag
A=Purge All S=Only purge items with at least |
| 26 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 27 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 28 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 29 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 30 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 31 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 32 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |