EM_BANNER_SEQ_IDDefault Value: NEXT
Default Value: %date
Default Value: 5
Y/N Table Edit
Default Value: N
EM_BANNER_TBL(SQL Table) |
Index Back |
|---|---|
MP - Banner TableMP - Banner Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EM_BANNER_SEQ_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Banner Seq ID
Default Value: NEXT |
| 2 | EM_BANNER_URL | Character(254) | VARCHAR2(254) NOT NULL | Banner Image URL |
| 3 | EM_REDIRECT_URL | Character(254) | VARCHAR2(254) NOT NULL | Banner Redirect URL |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | FROM_DT | Date(10) | DATE |
From Date
Default Value: %date |
| 6 | TO_DT | Date(10) | DATE | To Date |
| 7 | PERIOD | Number(3,0) | SMALLINT NOT NULL |
Period
Default Value: 5 |
| 8 | DEFAULT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Default
Y/N Table Edit Default Value: N |
| 9 | EM_BILL_TO | Character(50) | VARCHAR2(50) NOT NULL | Bill To |
| 10 | EM_COMPANY_NAME | Character(50) | VARCHAR2(50) NOT NULL | Company Name |