PO_ER_IBLIN_EVW(SQL View) |
Index Back |
---|---|
Purchase Order Line ItemPurchase Order Line Item |
SELECT BUSINESS_UNIT_IN ,PROCESS_INSTANCE ,BUSINESS_UNIT ,PO_ID ,LINE_NBR ,CANCEL_STATUS ,ITM_SETID ,INV_ITEM_ID ,ITM_ID_VNDR ,VNDR_CATALOG_ID ,UNIT_OF_MEASURE ,UNIT_MEASURE_STD ,CNTRCT_SETID ,CNTRCT_ID ,CNTRCT_LINE_NBR ,RELEASE_NBR ,MILESTONE_NBR ,RFQ_ID ,RFQ_LINE_NBR ,INSPECT_CD ,ROUTING_ID ,QTY_PO ,CONVERSION_RATE ,QTY_PO_STD ,IN_PROCESS_FLG ,AUDIT_ACTN FROM PS_PO_ER_LINE WHERE MSG_TYPE = 'IBU' AND PUBLISH <> 'N' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
2 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
4 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
5 | LINE_NBR | Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
6 | CANCEL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Cancel Status
A=Active C=Closed D=Denied H=Hold O=Open P=Pending Approval X=Canceled |
7 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
8 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
%EDIT_ITEM_ID
|
9 | ITM_ID_VNDR | Character(50) | VARCHAR2(50) NOT NULL | Vendor Item ID |
10 | VNDR_CATALOG_ID | Character(20) | VARCHAR2(20) NOT NULL | Vendor's Catalog Number |
11 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: %EDIT_UOM |
12 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
13 | CNTRCT_SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: PO_CNTRCT_SET |
14 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL |
Buying Agreement ID
Prompt Table: PO_CNTRCT_SRCH |
15 | CNTRCT_LINE_NBR | Number(5,0) | INTEGER NOT NULL |
Buying Agreement Line Nbr
Prompt Table: %EDIT_CNTRCT_LN |
16 | RELEASE_NBR | Number(5,0) | INTEGER NOT NULL | Release Number |
17 | MILESTONE_NBR | Number(5,0) | INTEGER NOT NULL | Milestone Line Number |
18 | RFQ_ID | Character(10) | VARCHAR2(10) NOT NULL | RFQ ID |
19 | RFQ_LINE_NBR | Number(5,0) | INTEGER NOT NULL | RFQ Line |
20 | INSPECT_CD | Character(1) | VARCHAR2(1) NOT NULL |
Inspection Required
N=No Y=Yes Y/N Table Edit Default Value: N |
21 | ROUTING_ID | Character(10) | VARCHAR2(10) NOT NULL |
Inspection Routing ID
Prompt Table: ROUTING_HDR |
22 | QTY_PO | Number(16,4) | DECIMAL(15,4) NOT NULL | Purchase Order Quantity |
23 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
24 | QTY_PO_STD | Number(16,4) | DECIMAL(15,4) NOT NULL | PO Quantity Standard |
25 | IN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL | In process flag |
26 | AUDIT_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values |