CE_ACT_CST_TEO2(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for CE_ACTUAL_COST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | 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 | CE_COST_CATEGORY | Character(4) | VARCHAR2(4) NOT NULL |
10/07/02 - LLR Added field CE_COST_CATEGORY for Debits to WIP.
%L=% Labor Overhead %M=% Material Overhead ADD=Additional Cost ADJ=Adjustments CO=Co Product LAB=Labor Cost MACH=Machine Cost MAT=Material Cost OTH=Other Cost OVHD=Standard Cost Overhead PL=Per Labor Overhead PM=Per Machine Overhead PO=Subcontracted PO-STD Cost PRIM=Primary Product PU=Per Unit Overhead RB=Recycle By-Products SCRP=Scrap Cost STD=Subcontracted Standard Cost SUBC=Subcontracted Cost VCHR=Subcontracted VCHR - PO Cost WB=Waste By-Products WO=Write-off no cost adj |
| 6 | CE_RESOURCE | Character(18) | VARCHAR2(18) NOT NULL | Resource |
| 7 | CM_BOOK | Character(10) | VARCHAR2(10) NOT NULL | Cost Book |
| 8 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
| 9 | CE_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 10 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 11 | CE_CODE | Character(4) | VARCHAR2(4) NOT NULL | Conversion Code |
| 12 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 13 | ADJUST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Type
0=CM Only A=VMI Return D=Decrease I=Increase M=Misc Issue R=Misc Return S=Scrap V=Scrap RTV |
| 14 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Distrib. Type |
| 15 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 16 | CE_COST_BASIS | Signed Number(32,15) | DECIMAL(30,15) NOT NULL | Calculation Basis |
| 17 | CE_BASIS_UOM | Character(4) | VARCHAR2(4) NOT NULL |
Type of basis amount
AMT=Extended Amount HRS=Hours QTY=Quantity |
| 18 | CE_UOM | Character(5) | VARCHAR2(5) NOT NULL | Uom |
| 19 | CE_RATE | Signed Number(32,15) | DECIMAL(30,15) NOT NULL | Rate |
| 20 | CE_EXTENDED_COST | Signed Number(32,15) | DECIMAL(30,15) NOT NULL | Extended Cost |
| 21 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 22 | TIME_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Time / Resource Type
0100=Planning Labor Setup 0200=Planning Labor Fixed Run 0300=Planning Labor Run 0400=Planning Labor Post Prod 0500=Planning Machine Setup 0600=Planning Machine Fixed Run 0700=Planning Machine Run 0800=Planning Machine Post Prod 1100=Costing Labor Setup 1200=Costing Labor Fixed Run 1300=Costing Labor Run 1400=Costing Labor Post Prod 1500=Costing Machine Setup 1600=Costing Machine Fixed Run 1700=Costing Machine Run 1800=Costing Machine Post Prod 2000=Queue Time 3000=Intransit Time |
| 23 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 24 | CM_DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Receipt dttm. |
| 25 | CM_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 26 | CM_DT_TIMESTAMP_A | DateTime(26) | TIMESTAMP | 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd. |
| 27 | CM_SEQ_NBR_A | Number(15,0) | DECIMAL(15) NOT NULL | 07/99 GMG CN800-9.0: |
| 28 | CM_SEQ_COST | Number(15,0) | DECIMAL(15) NOT NULL | Cost Sequence Number. Incremented each time the actual cost is updated. |
| 29 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 30 | 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 |
| 31 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 32 | CREW_CODE | Character(10) | VARCHAR2(10) NOT NULL | Crew Name |
| 33 | MACHINE_CODE | Character(10) | VARCHAR2(10) NOT NULL | Machine Code |
| 34 | SF_ENTRY_DATE | Date(10) | DATE | Entry Date |
| 35 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 36 | MG_OUTPUT_QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
01/28/98 (CN#EN800-6.0) LAJ...Created
Stores the quantity code for an output item on a Bill of Materials. It was created with the same values as qty_code, but by separating these two fields, it allows greater flexibility in the future.
ASY=Assembly ORD=Order Default Value: ASY |
| 37 | MG_PROC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 38 | TRANS_DATE | Date(10) | DATE | Transaction Date |
| 39 | TRANS_TIME | Time(15) | TIMESTAMP | Transaction Time |
| 40 | 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 |
| 41 | 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 |
| 42 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 43 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 44 | CE_COST_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Cost Type |
| 45 | COST_VERSION | Character(10) | VARCHAR2(10) NOT NULL |
Cost Version
Prompt Table: CE_VERSION5_VW |
| 46 | COST_SEQ | Number(15,0) | DECIMAL(15) NOT NULL | Cost Sequence Number |
| 47 | CE_SEQ_NBR_A | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 48 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 49 | VARIANCE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
9/9/02 CRC: added variance type '15' for Yield Variance
01=Configuration Variance 02=Usage Variance 03=Component Yield Variance 04=Labor Lot Size Variance 05=Process Routing Variance 06=Efficiency Variance 07=Rate Variance 08=Material Lot Size Variance 09=Rework Expense 10=Rework Labor Expense 11=Outside Processing PPV 12=Mix Variance 13=Teardown Material Expense 14=Teardown Conversion Expense 15=Yield Variance 16=Co-Product Rate Var 17=Material Rate Variance |
| 50 | BUSINESS_UNIT_RECV | Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 51 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 52 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 53 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 54 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 55 | MISC_CHARGE_CODE | Character(10) | VARCHAR2(10) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 56 | 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 Default Value: N |
| 57 | 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 |
| 58 | CE_POSTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Posted
6=Cost for 661 N=Cost Pending Calculation Y=Cost Calculated Default Value: N |
| 59 | POSTED_DATE | Date(10) | DATE |
Specifies the date that a journal entry is posted. This field is maintained by the posting program of PeopleSoft General Ledger.
Default Value: %date |
| 60 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |