PO_DOC_STYLE_HEADERS
PO_DOC_STYLE_HEADERS contains information about the document style you use in your business. Document style defines the procurement style across the different stages of the procurement process. It is used to control the display of the document and document usages. Within Purchasing, users can define a single document style setting for the following type of documents: Standard Purchase Order, Global Agreement and Global Contract.
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
PO_DOC_STYLE_HEADERS_PK |
STYLE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STYLE_ID | NUMBER | 18 | Yes | Identifier | |
| OUTSIDE_PROCESSING_FLAG | VARCHAR2 | 1 | Yes | Document style definition that allows users to indicate if the blanket purchase agreement and the purchase order are for outside processing. Values: Y/N | |
| CONSIGNED_ITEMS_FLAG | VARCHAR2 | 1 | Yes | Document style definition that allows users to indicate if the blanket purchase agreement and the purchase order will include consignment lines. Values: Y/N | |
| STYLE_NAME | VARCHAR2 | 240 | Yes | The name for the style. | |
| STYLE_DESCRIPTION | VARCHAR2 | 240 | The description of the style. | ||
| STYLE_TYPE | VARCHAR2 | 30 | Type of the Style. The valid values are: DEFAULT/STANDARD | ||
| STATUS | VARCHAR2 | 30 | Yes | Status of the Style. The valid values are: ACTIVE / INACTIVE from the PO_LOOKUP_CODES table. | |
| ADVANCES_FLAG | VARCHAR2 | 1 | Indicate if Advances enabled for this Style. | ||
| RETAINAGE_FLAG | VARCHAR2 | 1 | Yes | Indicate if Retainage enabled for this Style. | |
| PRICE_BREAKS_FLAG | VARCHAR2 | 1 | Indicate if Price Breaks enabled for this Style. | ||
| PRICE_DIFFERENTIALS_FLAG | VARCHAR2 | 1 | Indicate if Price Differentials enabled for this Style. | ||
| PROGRESS_PAYMENT_FLAG | VARCHAR2 | 1 | Yes | Indicate if Progress Payment enabled for this Style. | |
| CONTRACT_FINANCING_FLAG | VARCHAR2 | 1 | Indicate if Contract Financing enabled for this Style. | ||
| CONFIGURED_ITEM_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate whether document should support model items and options. | |
| LINE_TYPE_ALLOWED | VARCHAR2 | 30 | Yes | Indicate if Line Type is restricted for this Style. The valid values are: ALL / SPECIFIED from the PO_LOOKUP_CODES table. | |
| WC_ENABLED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether a document style supports work confirmation terms. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to 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. | ||
| 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. | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. | |
| ENABLE_CREDIT_LINE_TYPES | VARCHAR2 | 1 | Indicates whether credit line types are available for this style. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| po_doc_style_values | po_doc_style_headers | STYLE_ID |
| pon_auction_headers_all | po_doc_style_headers | PO_STYLE_ID |
| po_doc_style_lines_b | po_doc_style_headers | STYLE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PO_DOC_STYLE_HEADERS_N2 | Non Unique | Default | STYLE_DESCRIPTION |
| PO_DOC_STYLE_HEADERS_U1 | Unique | Default | STYLE_ID, ORA_SEED_SET1 |
| PO_DOC_STYLE_HEADERS_U11 | Unique | Default | STYLE_ID, ORA_SEED_SET2 |
| PO_DOC_STYLE_HEADERS_U2 | Unique | Default | STYLE_NAME, ORA_SEED_SET1 |
| PO_DOC_STYLE_HEADERS_U21 | Unique | Default | STYLE_NAME, ORA_SEED_SET2 |