BUSINESS_UNITDefault Value: REQ_HDR.BUSINESS_UNIT
REQ_IDDefault Value: NEXT
LINE_NBRDefault Value: 1
UNIT_OF_MEASUREMHR=Muti Hourly
PER=Percentage
SQF=Square Footage
ITEM_UOM_WS(SQL Table) |
Index Back |
|---|---|
Item/Supplier UOM Work Scrol/* 08-22-02 ssn 504075002 REQ UOM Fix*/ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: REQ_HDR.BUSINESS_UNIT |
| 2 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Requisition ID
Default Value: NEXT |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
| 4 | UNIT_OF_MEASURE |
Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 5 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 6 | UNIT_PRICE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Unit Price |
| 7 | PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This is price per unit for calculating the service charge. |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |