BUSINESS_UNITLINE_NBRDefault Value: 1
A=Approved
C=Closed
D=Denied
H=Hold
O=Open
P=Pending
X=Canceled
Prompt Table:
%EDIT_ITEM_ID
Set Control Field: ITM_SETID
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: ITM_CAT_TBL
REQ_RC_WB_SCR_L(SQL View) |
Index Back |
|---|
| SELECT BUSINESS_UNIT , REQ_ID , LINE_NBR , CURR_STATUS , ITM_SETID , INV_ITEM_ID , UNIT_OF_MEASURE , CATEGORY_ID , DESCR254_MIXED , VENDOR_ID , VENDOR_SETID FROM PS_REQ_LINE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
| 4 | CURR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Current Status
A=Approved C=Closed D=Denied H=Hold O=Open P=Pending X=Canceled |
| 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 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 10 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 11 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |