CM_INTRANS_TMP(SQL Table) |
Index Back |
|---|---|
Inventory In Transit temp07/99 GMG CN800-9.0; Created 08/10/01 DMW R-CMORSE-DQ7K6 / R-MSUBBA-3F5MV Performance Enhancement - add index A 08/04 8.8sp1: created for NegInv Enhancement |
| # | 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 | DT_TIMESTAMP |
DateTime(26) | TIMESTAMP NOT NULL | Date Timestamp |
| 4 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 5 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 6 | INTERUNIT_ID | Character(10) | VARCHAR2(10) NOT NULL | InterUnit Order ID |
| 7 | INTERUNIT_LINE | Number(5,0) | INTEGER NOT NULL | InterUnit Order Line |
| 8 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 9 | DESTIN_BU | Character(5) | VARCHAR2(5) NOT NULL | Destination Unit |
| 10 | OWNERSHIP_BU | Character(5) | VARCHAR2(5) NOT NULL | Business Unit Owning Inventory |
| 11 | IU_OWNERSHIP | Character(1) | VARCHAR2(1) NOT NULL |
Ownership Unit
D=Destination S=Source |
| 12 | INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 13 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 14 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 15 | CM_COST_PROC_GROUP | Character(18) | VARCHAR2(18) NOT NULL | Cost Flow Record |
| 16 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 17 | TRANSACTION_DATE | Date(10) | DATE | Transaction Date |
| 18 | CONSIGNED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Consigned Flag |
| 19 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Quantity |
| 20 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 21 | TRANSFER_COST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Transfer Price |
| 22 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 23 | CM_BU_SOURCE_GL | Character(5) | VARCHAR2(5) NOT NULL | 07/99 GMG CN800-9.0: |
| 24 | TRANSFER_COST_DEST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Transfer Price Dest |
| 25 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 26 | CM_BU_DESTIN_GL | Character(5) | VARCHAR2(5) NOT NULL | 07/99 GMG CN800-9.0: |
| 27 | 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 |
| 28 | CM_COST_MODE | Character(1) | VARCHAR2(1) NOT NULL |
07/99 GMG CN800-9.0:
L=Live S=Simulated |
| 29 | CM_PURGE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Purge Okay Flag
N=Doesn't Qualify for Purging Y=Qualifies for Purging Default Value: N |
| 30 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 31 | 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 |