CM_COSTING_AET(SQL Table) |
Index Back |
|---|---|
Costing Process state record07/99 GMG CN800-9.0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | CM_BOOK | Character(10) | VARCHAR2(10) NOT NULL | Cost Book |
| 7 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 8 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
| 9 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 10 | CM_DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Receipt dttm. |
| 11 | CM_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 12 | CM_DT_TIMESTAMP_A | DateTime(26) | TIMESTAMP | 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd. |
| 13 | CM_SEQ_NBR_A | Number(15,0) | DECIMAL(15) NOT NULL | 07/99 GMG CN800-9.0: |
| 14 | CM_COST_RUN_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Costing Run Mode
0=Conversion 1=Regular 2=Mid Period 3=Simulate 4=Resimulate 5=Make Live |
| 15 | CM_COST_MODE | Character(1) | VARCHAR2(1) NOT NULL |
07/99 GMG CN800-9.0:
L=Live S=Simulated |
| 16 | CM_COMMIT_LIMIT | Number(10,0) | DECIMAL(10) NOT NULL | Commit Limit |
| 17 | RUN_PPV | Character(1) | VARCHAR2(1) NOT NULL |
Apply Perpetual Average Adjs
Y/N Table Edit |
| 18 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once |
| 19 | CM_LOCK_COUNT | Number(3,0) | SMALLINT NOT NULL | Lock Count |
| 20 | CM_LOCKBU_COUNT | Number(3,0) | SMALLINT NOT NULL | Lock Count |
| 21 | CM_COUNT1 | Number(15,0) | DECIMAL(15) NOT NULL | 07/99 GMG CN800-9.0: |
| 22 | CM_COUNT2 | Number(15,0) | DECIMAL(15) NOT NULL | 07/99 GMG CN800-9.0: |
| 23 | CM_COUNT3 | Number(15,0) | DECIMAL(15) NOT NULL | 07/99 GMG CN800-9.0: |
| 24 | CM_COUNT4 | Number(15,0) | DECIMAL(15) NOT NULL | 07/99 GMG CN800-9.0: |
| 25 | CM_COUNT5 | Number(15,0) | DECIMAL(15) NOT NULL | 07/99 GMG CN800-9.0: |
| 26 | CM_COUNT6 | Number(15,0) | DECIMAL(15) NOT NULL | 07/99 GMG CN800-9.0: |
| 27 | 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 |
| 28 | 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 |
| 29 | CM_SEQ_DEPLETE | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 30 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 31 | INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 32 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 33 | TRANSACTION_DATE | Date(10) | DATE | Transaction Date |
| 34 | CONSIGNED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Consigned Flag |
| 35 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Quantity |
| 36 | CM_ONHAND_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 08/30/99 RML Changed from "onhand" to "on hand" |
| 37 | CM_SEQ_COST | Number(15,0) | DECIMAL(15) NOT NULL | Cost Sequence Number. Incremented each time the actual cost is updated. |
| 38 | 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. |
| 39 | CM_COST_PROC_GROUP | Character(18) | VARCHAR2(18) NOT NULL | Cost Flow Record |
| 40 | DEFAULT_LEDGER_GRP | Character(1) | VARCHAR2(1) NOT NULL | Jrnl Generator Dflt Ledger Grp |
| 41 | PRIMARY_LEDGER | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group. |
| 42 | DUMMY_FIELD | Character(1) | VARCHAR2(1) NOT NULL | Dummy Field for Hiding Groups |
| 43 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 44 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 45 | CM_UPDATE_STATS | Character(1) | VARCHAR2(1) NOT NULL |
Generate Table Statistics
Y/N Table Edit Default Value: N |
| 46 | CM_UPDATE_STATS_DE | Character(1) | VARCHAR2(1) NOT NULL |
11/01 mxs
Y/N Table Edit Default Value: Y |
| 47 | CM_PARALLEL_OK | Character(1) | VARCHAR2(1) NOT NULL | CM_PARALLEL_OK |
| 48 | CM_QTY_DIRECTION | Signed Number(2,0) | DECIMAL(1) NOT NULL | This field shows the movement direction for the transactions in transaction_inv based on transaction group and adjust type. Positive for receipts of inventory and negative for depletions of inventory.s |
| 49 | CM_ACTUAL_COST | Signed Number(27,15) | DECIMAL(25,15) NOT NULL | 07/99 GMG CN800-9.0: |
| 50 | CM_UNIT_COST | Signed Number(27,15) | DECIMAL(25,15) NOT NULL | 07/99 GMG CN800-9.0: |
| 51 | CUMULATIVE_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Details |
| 52 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 53 | CE_LOOP | Character(1) | VARCHAR2(1) NOT NULL | Calculate Actual Prdn Costs |
| 54 | DT_TIMESTAMP_TR | DateTime(26) | TIMESTAMP | Date Timestamp |
| 55 | CM_RESOLVE_NEG_INV | Character(1) | VARCHAR2(1) NOT NULL | Resolve Negative Inventory |