PO_RC_WB_SCR_LN(SQL View) |
Index Back |
|---|
| SELECT BUSINESS_UNIT , PO_ID , LINE_NBR , CANCEL_STATUS , ITM_SETID , INV_ITEM_ID , UNIT_OF_MEASURE , CATEGORY_ID , RECV_REQ , DESCR254_MIXED , RFQ_ID , RFQ_LINE_NBR , CNTRCT_SETID , CNTRCT_ID , VERSION_NBR , CNTRCT_LINE_NBR , RELEASE_NBR , MILESTONE_NBR , GPO_ID , GPO_CNTRCT_NBR FROM PS_PO_LINE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
| 4 | 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 Default Value: A |
| 5 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 6 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
%EDIT_ITEM_ID
|
| 7 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 8 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL |
Category ID
Prompt Table: ITM_CAT_TBL |
| 9 | RECV_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Receiving Required
N=Optional X=Do Not Y=Required Y/N Table Edit Default Value: N |
| 10 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 11 | RFQ_ID | Character(10) | VARCHAR2(10) NOT NULL | RFQ ID |
| 12 | RFQ_LINE_NBR | Number(5,0) | INTEGER NOT NULL | RFQ Line |
| 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 | VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Contract Version number |
| 16 | CNTRCT_LINE_NBR | Number(5,0) | INTEGER NOT NULL |
Buying Agreement Line Nbr
Prompt Table: %EDIT_CNTRCT_LN |
| 17 | RELEASE_NBR | Number(5,0) | INTEGER NOT NULL | Release Number |
| 18 | MILESTONE_NBR | Number(5,0) | INTEGER NOT NULL | Milestone Line Number |
| 19 | GPO_ID | Character(18) | VARCHAR2(18) NOT NULL | GPO ID |
| 20 | GPO_CNTRCT_NBR | Character(25) | VARCHAR2(25) NOT NULL | GPO Contract Number |