BUSINESS_UNITINV_ITEM_IDDT_TIMESTAMPSEQ_NBRCOST_ELEMENTCM_REC_RTV_VW(SQL View) |
Index Back |
|---|
| SELECT X.BUSINESS_UNIT , X.INV_ITEM_ID , X.DT_TIMESTAMP , X.SEQ_NBR , Y.COST_ELEMENT , Y.DT_TIMESTAMP , Y.SEQ_NBR , X.TRANSACTION_GROUP , Y.CM_UNIT_COST FROM PS_CM_TRINV_RTV_VW X , PS_CM_ACTUAL_COST Y WHERE X.BUSINESS_UNIT = Y.BUSINESS_UNIT AND X.INV_ITEM_ID = Y.INV_ITEM_ID AND X.RECEIVER_ID = Y.RECEIVER_ID AND X.RECV_LN_NBR = Y.RECV_LN_NBR AND X.RECV_SHIP_SEQ_NBR = Y.RECV_SHIP_SEQ_NBR AND X.TRANSACTION_GROUP IN ('012','013') AND Y.DT_TIMESTAMP = ( SELECT (MIN(Z.DT_TIMESTAMP)) FROM PS_CM_ACTUAL_COST Z WHERE X.BUSINESS_UNIT = Z.BUSINESS_UNIT AND X.INV_ITEM_ID = Z.INV_ITEM_ID AND X.RECEIVER_ID = Z.RECEIVER_ID AND X.RECV_LN_NBR = Z.RECV_LN_NBR AND X.TRANSACTION_GROUP IN ('012','013')) |
| # | 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 | CM_DT_TIMESTAMP | DateTime(26) | TIMESTAMP NOT NULL | Receipt dttm. |
| 7 | CM_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 8 | TRANSACTION_GROUP | Character(3) | VARCHAR2(3) NOT NULL | 11/7/02 LLR - Added the new (600's) transactions groups for 8.8. |
| 9 | CM_UNIT_COST | Signed Number(27,15) | DECIMAL(25,15) NOT NULL | 07/99 GMG CN800-9.0: |