EOEP_ARB_SEQ(SQL Table) |
Index Back |
|---|---|
Price Arbitration AttributesA Price Arbitration Plan is made up of one or more Price Arbitration Sequences. It defines the order in which Price Rules should be applied to the transaction. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table: EOEP_ARB_ID_VW |
| 2 | EOEP_APP_CD |
Character(4) | VARCHAR2(4) NOT NULL |
Transaction Code
Prompt Table: EOEP_APPCD_VW |
| 3 | EOEP_ARB_ID |
Character(10) | VARCHAR2(10) NOT NULL | Arbitration Plan |
| 4 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 1 |
| 5 | EOEP_ARB_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Arbitration Type
1=Action Type 2=Price Type 3=Decision 4=Pricing Key 5=Price Rule 6=Cascading/Summed 7=Date Range 8=Price Rule Source 9=Price Rule Type F=[Folder] |
| 6 | EOEP_ARB_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Arbitration Value |
| 7 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
| 8 | START_DT | Date(10) | DATE | Start date field to store start date value. |
| 9 | END_DT | Date(10) | DATE | This field stores the end date values. |
| 10 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 11 | EOEP_ADJST_CNT | Number(3,0) | SMALLINT NOT NULL | Adjustment Count |
| 12 | EOEP_STOP_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Stop Processing
N=No Y=Yes Default Value: N |