RECON_USG_TMP(SQL Table) |
Index Back |
|---|---|
Consumer Usage TableThis table identifies all of the materials used by a consumer for a service event. ________________________________________________________ 4/5/99 - DSB - Added Alternate Account chartfield |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 2 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 3 | CONSUMER_ID |
Character(20) | VARCHAR2(20) NOT NULL |
A unique identifier for an individual that consumes or uses materials.
Prompt Table: CONSUMER_INV |
| 4 | SERVICE_ID |
Character(20) | VARCHAR2(20) NOT NULL |
Service ID
Prompt Table: CONSMR_SRVC_INV |
| 5 | SERVICE_DT |
Date(10) | DATE NOT NULL | Service Date |
| 6 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MASTER_ITM_A_VW |
| 7 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 0 |
| 8 | CHARGE_CODE | Character(20) | VARCHAR2(20) NOT NULL |
Charge Code
Prompt Table: CHARGE_CODE_INV |
| 9 | QTY_USED | Number(16,4) | DECIMAL(15,4) NOT NULL |
The amount material consumed.
Default Value: 1 |
| 10 | LAST_PO_PRICE_PAID | Number(16,5) | DECIMAL(15,5) NOT NULL | Last PO Price Paid |