CM_PROFILES_VW(SQL View) |
Index Back |
|---|---|
Profiles for Inventory Items08/23/02 dmw View of the valid CM_TYPE,CM_FLOW and CM_METHOD used to grid on the profiles page. |
| SELECT CM_TYPE , CM_FLOW , CM_METHOD , CM_MFG_ITEM_FLG , CM_PERPAVG_FLAG , CM_PERRAVG_FLAG , CM_STDCOST_FLAG , CM_NONCOST_FLAG FROM PS_CM_PROFILES WHERE CM_MATERIAL_METHOD = '0' AND CM_LABOR_METHOD = '0' AND CM_MACHINE_METHOD = '0' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CM_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
07/99 GMG CN800-9.0:
0=Non Cost 1=Actual 2=Std Cost |
| 2 | 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 |
| 3 | 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 |
| 4 | CM_MFG_ITEM_FLG | Number(3,0) | SMALLINT NOT NULL |
02/23/99 Created for Release 8 - CM800-9.0 by RML
Default Value: 0 |
| 5 | CM_PERPAVG_FLAG | Number(1,0) | SMALLINT NOT NULL | Maintain Perpetual Average Flg |
| 6 | CM_PERRAVG_FLAG | Number(1,0) | SMALLINT NOT NULL | RetroActive Per Avg Costed Flg |
| 7 | CM_STDCOST_FLAG | Number(1,0) | SMALLINT NOT NULL | 07/99 GMG CN800-9.0: |
| 8 | CM_NONCOST_FLAG | Number(1,0) | SMALLINT NOT NULL | 07/99 GMG CN800-9.0: |