BU_OPT_AR(SQL Table) |
Index Back |
|---|---|
AR Customer Trend Options |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: BUS_UNIT_OPT_AR.SETID Prompt Table:
SP_SETID_NONVW
|
| 2 | TR1_HIST1 | Character(10) | VARCHAR2(10) NOT NULL |
Trend 1 History ID 1
Prompt Table: CUST_HIST_TBL |
| 3 | TR1_HIST2 | Character(10) | VARCHAR2(10) NOT NULL |
Trend 1 History ID 2
Prompt Table: CUST_HIST_TBL |
| 4 | TR1_HIST3 | Character(10) | VARCHAR2(10) NOT NULL |
Trend 1 History ID 3
Prompt Table: CUST_HIST_TBL |
| 5 | TR1_HDR1 | Character(30) | VARCHAR2(30) NOT NULL | Trend 1 Header 1 |
| 6 | TR1_HDR2 | Character(30) | VARCHAR2(30) NOT NULL | Trend 1 Header 2 |
| 7 | TR1_HDR3 | Character(30) | VARCHAR2(30) NOT NULL | Trend 1 Header 3 |
| 8 | TCNT1_HIST1 | Character(10) | VARCHAR2(10) NOT NULL |
Trend 2 History ID 1
Prompt Table: CUST_HIST_TBL |
| 9 | TCNT1_HIST2 | Character(10) | VARCHAR2(10) NOT NULL |
Trend 2 History ID 2
Prompt Table: CUST_HIST_TBL |
| 10 | TCNT1_HIST3 | Character(10) | VARCHAR2(10) NOT NULL |
Trend 2 History ID 3
Prompt Table: CUST_HIST_TBL |
| 11 | TCNT1_HIST4 | Character(10) | VARCHAR2(10) NOT NULL |
Trend 2 History ID 4
Prompt Table: CUST_HIST_TBL |
| 12 | TCNT1_HIST5 | Character(10) | VARCHAR2(10) NOT NULL |
Trend 2 History ID 5
Prompt Table: CUST_HIST_TBL |
| 13 | TCNT1_HIST6 | Character(10) | VARCHAR2(10) NOT NULL |
Trend 2 History ID 6
Prompt Table: CUST_HIST_TBL |
| 14 | TCNT1_HDR1 | Character(30) | VARCHAR2(30) NOT NULL | Trend 2 Header 1 |
| 15 | TCNT1_HDR2 | Character(30) | VARCHAR2(30) NOT NULL | Trend 2 Header 2 |
| 16 | TCNT1_HDR3 | Character(30) | VARCHAR2(30) NOT NULL | Trend 2 Header 3 |
| 17 | TCNT1_HDR4 | Character(30) | VARCHAR2(30) NOT NULL | Trend 2 Header 4 |
| 18 | TCNT1_HDR5 | Character(30) | VARCHAR2(30) NOT NULL | Trend 2 Header 5 |
| 19 | TCNT1_HDR6 | Character(30) | VARCHAR2(30) NOT NULL | Trend 2 Header 6 |
| 20 | TR2_HIST1 | Character(10) | VARCHAR2(10) NOT NULL |
Trend 2 History ID 1
Prompt Table: CUST_HIST_TBL |
| 21 | TR2_HIST2 | Character(10) | VARCHAR2(10) NOT NULL |
Trend 3 History ID 2
Prompt Table: CUST_HIST_TBL |
| 22 | TR2_HIST3 | Character(10) | VARCHAR2(10) NOT NULL |
Trend 2 History ID 3
Prompt Table: CUST_HIST_TBL |
| 23 | TR2_HDR1 | Character(30) | VARCHAR2(30) NOT NULL | Trend 2 Header 1 |
| 24 | TR2_HDR2 | Character(30) | VARCHAR2(30) NOT NULL | Trend 3 Header 2 |
| 25 | TR2_HDR3 | Character(30) | VARCHAR2(30) NOT NULL | Trend 2 Header 3 |