CM_TRANSACTION(SQL Table) |
Index Back |
|---|---|
Transaction Inv books06/21/99 GMG CN800-9.0. Added. Record explodes TRANSACTION_INV into books; used to manage process flag at book level. 08/10/2001 dmw R-CMORSE-DQ7K6 / R-MSUBBA-3F5MV Performance Enhancement - add index A |
| # | 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_COST_PROC_GROUP | Character(18) | VARCHAR2(18) NOT NULL | Cost Flow Record |
| 7 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 8 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 9 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 10 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Quantity |
| 11 | ADJUST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Type
0=CM Only A=VMI Return D=Decrease I=Increase M=Misc Issue R=Misc Return S=Scrap V=Scrap RTV |
| 12 | LOC_ACCTG_REQ | Character(1) | VARCHAR2(1) NOT NULL | Location Accounting Required |
| 13 | 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. |
| 14 | 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 |
| 15 | TRANSACTION_DATE | Date(10) | DATE | Transaction Date |
| 16 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 17 | TO_STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 18 | INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 19 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 20 | TRANSACTION_SOURCE | Character(2) | VARCHAR2(2) NOT NULL | Transaction Source |
| 21 | CONSIGNED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Consigned Flag |
| 22 | TO_CONSIGNED_FLG | Character(1) | VARCHAR2(1) NOT NULL | To Consigned Flag |
| 23 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 24 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 25 | 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 |