UPG_CP_AERULE(SQL Table) |
Index Back |
|---|---|
CP Upgrade RuleCP Upgrade Rule AE State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CP_AREA | Character(1) | VARCHAR2(1) NOT NULL |
Functional Area Field
0=Distribution 1=Production |
| 3 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 4 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | DIST_GROUP | Character(4) | VARCHAR2(4) NOT NULL | Distribution Group |
| 6 | DIST_SUBGROUP | Character(4) | VARCHAR2(4) NOT NULL | Distribution Subgroup |
| 7 | RULE_AR | Character(254) | VARCHAR2(254) NOT NULL | Rule AR |