Oracle Fusion · Data dictionary
OKC_K_HEADERS_ALL_B
SharedUsed in 34 subject areas39 reporting columns
Contracts (OKC), base table, language-neutral data (paired with _TL labels and the _VL view).
Primary key: not yet catalogued for OKC_K_HEADERS_ALL_B, reference Oracle Tables & Views guide.
Joins (inferred from key columns): LEGAL_ENTITY_ID → XLE_ENTITY_PROFILES
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AGREED_AMOUNT | ● | Agreed amount. | |
| AMENDMENT_EFFECTIVE_DATE | ● | Amendment effective date. | |
| ASSIGNEE_TYPE | ● | Type of assignee. | |
| BUY_OR_SELL | ● | Buy or sell. | |
| CONTRACT_ID | ● | Identifier for the contract. | |
| CONTRACT_NUMBER | ● | Contract number. | |
| CONTRACT_TYPE_ID | ● | Identifier for the contract type. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| CUST_PO_NUMBER | ● | Customer purchase order number. | |
| DATETIME_CANCELLED | ● | Datetime cancelled. | |
| DATE_APPROVED | ● | Date approved. | |
| DATE_SIGNED | ● | Date signed. | |
| DATE_TERMINATED | ● | Date terminated. | |
| END_DATE | ● | End date. | |
| ESTIMATED_AMOUNT | ● | Estimated amount. | |
| EXEMPT_CERTIFICATE_NUMBER | ● | Exempt certificate number. | |
| EXEMPT_REASON_CODE | ● | Code identifying the exempt reason. | |
| HOLD_REASON_CODE | ● | Code identifying the hold reason. | |
| HOLD_REASON_CODE_SET_ID | ● | Identifier for the hold reason code set. | |
| HOLD_UNTIL_DATE | ● | Hold until date. | |
| ID | ● | Id. | |
| LAST_REV_RECOG_DATE | ● | Last rev recog date. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| LEGAL_ENTITY_ID | ● | Identifier of the legal entity. | |
| MAJOR_VERSION | ● | Major version. | |
| NET_INVOICE_FLAG | ● | Indicator (Y/N) for the net invoice. | |
| OUTPUT_TAX_CLASSIFICATION_CODE | ● | Code identifying the output tax classification. | |
| OVERALL_RISK_CODE | ● | Code identifying the overall risk. | |
| SHARE_WITH_EXTERNAL_PARTY_YN | ● | Share with external party yn. | |
| START_DATE | ● | Start date. | |
| STS_CODE | ● | Code identifying the status. | |
| TAX_EXEMPTION_CONTROL | ● | Tax exemption control. | |
| TEMPLATE_YN | ● | Template yn. | |
| TRN_CODE | ● | Code identifying the trn. | |
| VERSION_TYPE | ● | Type of version. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Costing - Cost Accounting Real Time
- Costing - Receipt Accounting Real Time
- Costing - Work Order Costs Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Distributed Order Orchestration - Order Headers Real Time
- Enterprise Contracts - Contracts Real Time
- Inventory - Inventory Transactions Real Time
- Inventory - Inventory Transfer Order Real Time
- Maintenance Management - Material Usage Real Time
- Maintenance Management - Purchased Item Usage Real Time
- Maintenance Management - Resource Usage Real Time
- Maintenance Management - Work Order Performance Real Time
- Manufacturing - Actual Production Real Time
- Manufacturing - Material Usage Real Time
- Manufacturing - Purchased Item Usage Real Time
- Manufacturing - Resource Usage Real Time
- Manufacturing - Work Order Performance Real Time
- Procurement - Procure To Pay Real Time
- Procurement - Purchasing Agreements Real Time
- Procurement - Purchasing Real Time
Need the extract + dbt staging for OKC_K_HEADERS_ALL_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table