CE_ITEMEXPD(SQL Table) |
Index Back |
|---|---|
Addtl Costs by Item Exp Seq/* 1/12/99 ebn CN#CM800-2.0 Changed business_unit.save edit to validate that the transaction group must be stocking if a landed cost element is being used. */ 8/4/99 lee - added activity id for abm overhead cost interface 9/14/99 lee - deleted activity id for abm overhead cost interface. may be added in the future. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: CE_ITEM_OWN_VW |
| 3 | CE_COST_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Cost Type
Prompt Table: CE_TYPE |
| 4 | COST_VERSION |
Character(10) | VARCHAR2(10) NOT NULL |
Cost Version
Prompt Table: CE_VERSION |
| 5 | SEQ_NUMBER |
Number(3,0) | SMALLINT NOT NULL | Expense Sequence Number |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | APP_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Application Method
%MT=% of Material Cost %TL=% of Total Costs UNT=Amount Per Unit |
| 8 | EXPENSE_RATE | Number(12,4) | DECIMAL(11,4) NOT NULL | Expense Rate |
| 9 | EXPENSE_PERCENT | Number(5,1) | DECIMAL(4,1) NOT NULL | Expense Percentage |
| 10 | CE_TRANS_GROUP | Character(3) | VARCHAR2(3) NOT NULL |
Defines the type of transaction.
020=020 Putaway 030=030 Usages & Shipments |
| 11 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table: CE_ELEMENT3_VW |