BUSINESS_UNITINV_ITEM_IDDT_TIMESTAMPSEQ_NBRCOST_ELEMENT0=CM Only
A=VMI Return
D=Decrease
I=Increase
M=Misc Issue
R=Misc Return
S=Scrap
V=Scrap RTV
CM_REC_CANC_VW(SQL View) |
Index Back |
|---|
| SELECT a.business_unit , a.inv_item_id , a.dt_timestamp , a.seq_nbr , b.dt_timestamp , b.seq_nbr , a.transaction_group , b.cost_element , a.adjust_type , b.cm_unit_cost FROM PS_TRANSACTION_INV a , ps_cm_actual_cost b WHERE a.business_unit = b.business_unit AND a.inv_item_id = b.inv_item_id AND a.receiver_id = b.receiver_id AND a.recv_ln_nbr = b.recv_ln_nbr AND A.RECV_SHIP_SEQ_NBR = B.RECV_SHIP_SEQ_NBR AND a.transaction_group IN ('020' ,'010') AND a.adjust_type = 'D' AND b.dt_timestamp = ( SELECT (MIN(b1.dt_timestamp)) FROM ps_cm_actual_cost b1 WHERE a.business_unit = b1.business_unit AND a.inv_item_id = b1.inv_item_id AND a.receiver_id = b1.receiver_id AND a.recv_ln_nbr = b1.recv_ln_nbr AND a.transaction_group IN ('020' ,'010') AND a.adjust_type = 'D' ) |
| # | 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 | Date Timestamp |
| 4 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 5 | CM_DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Receipt dttm. |
| 6 | CM_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 7 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 8 | COST_ELEMENT |
Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 9 | 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 |
| 10 | CM_UNIT_COST | Signed Number(27,15) | DECIMAL(25,15) NOT NULL | 07/99 GMG CN800-9.0: |