BUSINESS_UNITLOCATIONCONSUMER_IDSERVICE_IDSERVICE_DTINV_ITEM_IDMHR=Muti Hourly
PER=Percentage
SQF=Square Footage
01=None
02=Billing
03=Costing
USAGE_INQ_IN_VW(SQL View) |
Index Back |
|---|---|
Consumer Usage Inquiry ViewThis view is used for displaying usage on the Consumer Usage Inquiry panel. |
| SELECT BUSINESS_UNIT , LOCATION , CONSUMER_ID , SERVICE_ID , SERVICE_DT , INV_ITEM_ID , SEQ_NBR , CHARGE_CODE , QTY_USED , UNIT_OF_MEASURE , LAST_OPRID , LAST_DTTM_UPDATE , LAST_PO_PRICE_PAID , USG_TRCKNG_METHOD FROM PS_USAGE_INV |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 3 | CONSUMER_ID |
Character(20) | VARCHAR2(20) NOT NULL | A unique identifier for an individual that consumes or uses materials. |
| 4 | SERVICE_ID |
Character(20) | VARCHAR2(20) NOT NULL | Service ID |
| 5 | SERVICE_DT |
Date(10) | DATE | Service Date |
| 6 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 7 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 8 | CHARGE_CODE | Character(20) | VARCHAR2(20) NOT NULL | Charge Code |
| 9 | QTY_USED | Number(16,4) | DECIMAL(15,4) NOT NULL | The amount material consumed. |
| 10 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 11 | LAST_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Response Operator |
| 12 | LAST_DTTM_UPDATE | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 13 | LAST_PO_PRICE_PAID | Number(16,5) | DECIMAL(15,5) NOT NULL | Last PO Price Paid |
| 14 | USG_TRCKNG_METHOD | Character(2) | VARCHAR2(2) NOT NULL |
Usage Tracking Method
01=None 02=Billing 03=Costing |