IN_SUBITEM_RPTC(SQL View) |
Index Back |
|---|---|
Inv item substitution reportInventory item substitution report - Operation class security view |
| SELECT A.BUSINESS_UNIT , A.REQUEST_DATE , A.FISCAL_YEAR , A.YEAR_PERIOD , A.ORDER_NO , A.INV_ITEM_ID , A.SUB_ITEM_ID , A.UNIT_MEASURE_STD , A.VENDOR_ID , A.QTY_SUB_ITEM , A.TOTAL_QTY , A.RATE_SUB , B.OPRCLASS FROM PS_IN_SUBITEM_RPT A , PS_SEC_BU_CLS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | REQUEST_DATE | Date(10) | DATE | Requested |
| 3 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 4 | YEAR_PERIOD | Character(10) | VARCHAR2(10) NOT NULL | Combination Field of ChartField year and period |
| 5 | ORDER_NO | Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 6 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 7 | SUB_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | 11/02/05 EGS: Created |
| 8 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 9 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 10 | QTY_SUB_ITEM | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Substituted |
| 11 | TOTAL_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Quantity |
| 12 | RATE_SUB | Signed Number(11,2) | DECIMAL(9,2) NOT NULL | Substituted Rate (100%) |
| 13 | OPRCLASS | Character(30) | VARCHAR2(30) NOT NULL | Operator Class |