PON_NEG_ABSTRACT_CONFIG
PON_NEG_ABSTRACT_CONFIG stores Abstract configuration values that external users view on Abstract listing page, such as company name, company logo, language, time zone, date format, time format and number format. Buyer could also specify the header/footer content to be shown on Abstract.
Details
-
Schema: FUSION
-
Object owner: PON
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PON_NEG_ABSTRACT_CONFIG_PK |
PRC_BU_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PRC_BU_ID | NUMBER | 18 | Yes | Procurement business unit unique identifier. | |
| ONLY_SHOW_NEG_FROM_BU_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether external user is able to view Abstracts only from a specific BU or across BUs. | ||
| LANGUAGE_CODE | VARCHAR2 | 4 | Language Code | ||
| TIMEZONE_CODE | VARCHAR2 | 50 | Time zone code | ||
| DATE_FORMAT_CODE | VARCHAR2 | 30 | Date format code | ||
| TIME_FORMAT_CODE | VARCHAR2 | 30 | Time format code | ||
| NUMBER_FORMAT_CODE | VARCHAR2 | 30 | Number format code | ||
| HEADER_CONTENT_TEXT | CLOB | Content that could be inserted as Abstract header. | |||
| FOOTER_CONTENT_TEXT | CLOB | Content that could be inserted as Abstract footer. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| COMPANY_NAME | VARCHAR2 | 100 | Name of the organization | ||
| LOGO_LOCATION | VARCHAR2 | 240 | The URL of the logo which to be placed on Procurement Abstract Listing page. | ||
| LOGO_WIDTH | NUMBER | Width of the logo | |||
| LOGO_HEIGHT | NUMBER | Height of the logo | |||
| DISPLAY_LOGO_FLAG | VARCHAR2 | 1 | Y/N flag to indicate whether company logo will be displayed on Procurement Abstract Listing Redwood page. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PON_NEG_ABSTRACT_CONFIG | po_system_parameters_all | PRC_BU_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PON_NEG_ABSTRACT_CONFIG_U1 | Unique | Default | PRC_BU_ID |