BUSINESS_UNITINV_ITEM_IDCM_BOOKDT_TIMESTAMPSEQ_NBRCM_SEQ_COSTN=Not Posted
X=Don't Post
Y=Posted
CM_UNDEPL_HST(SQL Table) |
Index Back |
|---|---|
Canceled Unsuccessful DepletesHistory of reverse component consumptions and reverse component kits cancelling depletions not depleted due to not enough onhand. This table contains the original row with the original qty from CM_DEPLETION. Rows that are found here means that the Transaction Costing process had to sum the undepleted depletions and the reverse depletions to cancel each other out so that rows can be depleted. This scenario occurs when depletions cannot be depleted due to not enough on-hand quantity and there is a reverse component consumption. |
| # | 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 | DT_TIMESTAMP |
DateTime(26) | TIMESTAMP | Date Timestamp |
| 5 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 6 | CM_SEQ_COST |
Number(15,0) | DECIMAL(15) NOT NULL | Cost Sequence Number. Incremented each time the actual cost is updated. |
| 7 | TRANSACTION_DATE | Date(10) | DATE | Transaction Date |
| 8 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 9 | INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 10 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 11 | CM_COST_PROC_GROUP | Character(18) | VARCHAR2(18) NOT NULL | Cost Flow Record |
| 12 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 13 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 14 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 15 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Quantity |
| 16 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 17 | CONSIGNED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Consigned Flag |
| 18 | TO_CONSIGNED_FLG | Character(1) | VARCHAR2(1) NOT NULL | To Consigned Flag |
| 19 | CM_DTTM_IN_EFFECT | DateTime(26) | TIMESTAMP | Date Timestamp |
| 20 | CM_DTTM_STAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
| 21 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 22 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 23 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 24 | 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 |