CM_ITEM_MTH_TMP(SQL Table) |
Index Back |
|---|---|
Item Cost Profiles01/18/99 RML CN800-9.0: Created new view to show profile for a given item, BU, and book. 10/01 dmw R-DWEAVE-6L6YJ added field CFG_COST_OPT 01/03 tw This table is no longer used and can be deleted. A dedicated temporary table (CM_ITEM_MTH_T) was implemented as of release 8.4. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | CM_BOOK |
Character(10) | VARCHAR2(10) NOT NULL | Cost Book |
| 4 | CM_BOOK_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
06/30/99 RML Changed Long Name
A=Active C=Cancel I=Inactive P=Pending S=Stopped |
| 5 | CM_PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements |
| 6 | CM_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
07/99 GMG CN800-9.0:
0=Non Cost 1=Actual 2=Std Cost |
| 7 | CM_FLOW | Character(2) | VARCHAR2(2) NOT NULL |
01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
0=Non Cost 2=Lot ID 3=Serial ID 4=FIFO 5=LIFO |
| 8 | CM_METHOD | Character(2) | VARCHAR2(2) NOT NULL |
8/20/02 lee: added xlate 9 for retroactive perp average
01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
0=Non Cost 1=Actual Cost 6=Perpetual Weighted Average 7=Periodic Weighted Average 8=Value at Current Standard 9=Retroactive Perpetual Average |
| 9 | CM_STOR_AREA_CNTRL | Character(1) | VARCHAR2(1) NOT NULL | CN# CM800-9.0 GMG Storage Area Control for Costing. If this flag is on (Y) depletions will only deplete receipts in the storage area from which the depletion was made. If it is off (N), depletions will not consider the storage area when selecting qualifying receipts to deplete. |
| 10 | CM_WAIT_FINAL_COST | Character(1) | VARCHAR2(1) NOT NULL | 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements |
| 11 | CM_MFG_ITEM_FLG | Number(3,0) | SMALLINT NOT NULL | 02/23/99 Created for Release 8 - CM800-9.0 by RML |
| 12 | CM_PERPAVG_FLAG | Number(1,0) | SMALLINT NOT NULL | Maintain Perpetual Average Flg |
| 13 | CM_STDCOST_FLAG | Number(1,0) | SMALLINT NOT NULL | 07/99 GMG CN800-9.0: |
| 14 | CM_NONCOST_FLAG | Number(1,0) | SMALLINT NOT NULL | 07/99 GMG CN800-9.0: |
| 15 | CFG_COST_OPT | Character(1) | VARCHAR2(1) NOT NULL | Configuration Costing |