PROCESS_INSTANCEBUSINESS_UNITVENDOR_SETIDVENDOR_IDVNDR_LOCPO_ITM_STG_HDV2(SQL View) |
Index Back |
|---|---|
View with Header level infoThis view is used by POVNDSEL to get header level info for consolidated lines. |
| SELECT DISTINCT PROCESS_INSTANCE, BUSINESS_UNIT, VENDOR_SETID, VENDOR_ID, VNDR_LOC, CNTRCT_SETID, CURRENCY_CD, CURRENCY_CD_BASE, DECIMAL_POS_BSE, DECIMAL_POSITIONS, PO_BUILD_CD, PO_DT, PO_ID, RATE_DATE, RATE_DIV, RATE_MULT, RT_TYPE FROM PS_PO_ITM_STG_HDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 4 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 6 | CNTRCT_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 8 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 9 | DECIMAL_POS_BSE | Number(2,0) | SMALLINT NOT NULL | Base Cur Decimal Positions |
| 10 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 11 | PO_BUILD_CD | Character(1) | VARCHAR2(1) NOT NULL | PO Build Code |
| 12 | PO_DT | Date(10) | DATE | Date |
| 13 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 14 | RATE_DATE | Date(10) | DATE | Exchange Rate Date |
| 15 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 16 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 17 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |