CE_ITEMCVAR_PSB(SQL Table) |
Index Back |
|---|---|
Posted Item Cst Variance Books07/21/99 ebn CN#CM800-9.0 Added for LIFO/FIFO Enhancement. This table tracks all the cost books for which accounting lines should be generated for each CE_ITEMCVAR_PST record. |
| # | 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
Prompt Table: BUS_UNIT_TBL_IN |
| 3 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MASTER_ITEM_TBL |
| 5 | STORAGE_AREA |
Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 6 | CONFIG_CODE |
Character(50) | VARCHAR2(50) NOT NULL |
Product Configurator
Prompt Table: CP_CONFIG_VW |
| 7 | COST_ELEMENT |
Character(4) | VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table: CM_ELEMENT |
| 8 | REVALUE_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
1/25/99 - CRC EN800-6.0 : added revalue type = '05' for co/by product
01=Inventory 02=Inspection 03=WIP - Comp 04=WIP - Assy 05=WIP - Waste |
| 9 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 10 | CM_BOOK |
Character(10) | VARCHAR2(10) NOT NULL | Cost Book |
| 11 | REVALUE_DATE | Date(10) | DATE |
Creation Date
Default Value: %date |
| 12 | CM_COST_MODE | Character(1) | VARCHAR2(1) NOT NULL |
07/99 GMG CN800-9.0:
L=Live S=Simulated |
| 13 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 14 | PROCESS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Process Flag
A=Purge All S=Only purge items with at least Y/N Table Edit |
| 15 | 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 Y/N Table Edit Default Value: N |