BUSINESS_UNITASSET_IDMETER_TYPEWM_FISCAL_PERIODDefault Value: %Datetime
WM_AM_MTR_READ(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | METER_TYPE |
Character(30) | VARCHAR2(30) NOT NULL | Meter Type |
| 4 | WM_FISCAL_PERIOD |
Character(20) | VARCHAR2(20) NOT NULL | Period |
| 5 | TOTAL_USAGE | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Usage Quantity |
| 6 | UNIT_OF_USAGE | Character(3) | VARCHAR2(3) NOT NULL | Unit of Usage |
| 7 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 8 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 9 | LASTUPDDTTM | 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.
Default Value: %Datetime |