BUSINESS_UNITCM_BOOKINV_ITEM_IDDT_TIMESTAMPSEQ_NBRN=Not Posted
X=Don't Post
Y=Posted
CM_UNDEPL_TMP(SQL Table) |
Index Back |
|---|---|
Net Deplete Temp TableTemp table holding net deplete qty after reverse component consumption or reverse component kit qty has been fully cancelled by depletions not depleted due to not enough onhand. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | CM_BOOK |
Character(10) | VARCHAR2(10) NOT NULL | Cost Book |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | DT_TIMESTAMP |
DateTime(26) | TIMESTAMP | Date Timestamp |
| 5 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 6 | INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 7 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 8 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 9 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 10 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 11 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Quantity |
| 12 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 13 | CONSIGNED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Consigned Flag |
| 14 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 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 |