SF_SCRAPCOST(SQL Table) |
Index Back |
|---|---|
Assembly Scrap CostsPSG 10/9/97: If fields are added or deleted from sf_scrapcost, then a new copy of sf_scrapcost2 should be saved from sf_scrapcost. sf_scrapcost2 is used by Accounting COBOL and must always contain the exact same fields as sf_scrapcost. EBN 7/20/99 Key fields on sf_scrapcostb must be the keys on sf_scrapcost + cm_book. GMG CN# CM750-8.0 Changes for SEQ_NBR field; value assigned by Accounting to achieve unique rows. GMG 3/23/97: Add revalue_flag to keys. Used by acctg line generation process to differentiate between transaction groups. 07/21/99 ebn CN#CM800-9.0 Made table uniquely keyed. Added MG_PROC_INSTANCE. Made COST_ELEMENT, TRANS_DATE, and TRANS_TIME keys. 01/07/03 PWF Incident 535929000 Altered order of keys to allow processes that do not include process_instance to avoid a full table scan |
| # | 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 | Transaction Date |
| 7 | TRANS_TIME |
Time(15) | TIMESTAMP | 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 Default Value: N |
| 10 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 11 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 12 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 13 | 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 |
| 14 | SCRAPPED_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Scrapped Qty |
| 15 | TL_SCRAP_AMT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This Level Scrap Amount |
| 16 | LL_SCRAP_AMT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Lower Level Scrap Amount |
| 17 | PERCENT_COMP | Number(6,2) | DECIMAL(5,2) NOT NULL | Scrap Prdn Pct |
| 18 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
| 19 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL |
Base Quantity
Default Value: 1 |
| 20 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Distrib. Type |
| 21 | 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 Default Value: N |
| 22 | PROCESS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Process Flag
A=Purge All S=Only purge items with at least Y/N Table Edit Default Value: N |
| 23 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 24 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |