BUSINESS_UNITUTILIZ_GROUPCYCL=Cycle Count
UTILIZ_CDPrompt Table: UTILIZ_TYPE_INV
COUNT_UTIL_INV(SQL Table) |
Index Back |
|---|---|
Physical/Cycle Count Utiliz |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | UTILIZ_GROUP |
Character(4) | VARCHAR2(4) NOT NULL |
Utilization Group
CYCL=Cycle Count |
| 3 | UTILIZ_CD |
Character(4) | VARCHAR2(4) NOT NULL |
Utilization Type
Prompt Table: UTILIZ_TYPE_INV |
| 4 | INTERVAL_PERIOD | Number(3,0) | SMALLINT NOT NULL | Cyc Interval (days) |
| 5 | UTIL_CD_PCT | Number(3,0) | SMALLINT NOT NULL | Utiliz Pct |
| 6 | REVIEW_PERIOD | Number(3,0) | SMALLINT NOT NULL | Review Period (days) |