Oracle Fusion · Data dictionary
OKC_K_LINES_B
SharedUsed in 9 subject areas38 reporting columns
Contracts (OKC), base table, language-neutral data (paired with _TL labels and the _VL view).
Likely primary key: K_HEADER_ID, LINE_NUMBER (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): K_HEADER_ID → OKC_K_HEADERS_VL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AGREED_AMT | ● | Agreed amount. | |
| AGREED_QTY | ● | Agreed quantity. | |
| AGREEMENT_AMT_LIMIT | ● | Agreement amount limit. | |
| AGREEMENT_PRICE_LIMIT | ● | Agreement price limit. | |
| AGREEMENT_QTY_LIMIT | ● | Agreement quantity limit. | |
| AGREEMENT_UNIT_PRICE | ● | Agreement unit price. | |
| AT_RISK_YN | ● | At risk yn. | |
| COMMIT_LEVEL_CODE | ● | Code identifying the commit level. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CUST_PO_NUMBER | ● | Customer purchase order number. | |
| DATE_CANCELLED | ● | Date cancelled. | |
| DATE_TERMINATED | ● | Date terminated. | |
| EXEMPT_CERTIFICATE_NUMBER | ● | Exempt certificate number. | |
| EXEMPT_REASON_CODE | ● | Code identifying the exempt reason. | |
| HOLD_REASON_CODE | ● | Code identifying the hold reason. | |
| HOLD_UNTIL_DATE | ● | Hold until date. | |
| ID | ● | Id. | |
| JTOT_OBJECT1_CODE | ● | Code identifying the jtot object1. | |
| K_HEADER_ID | PK? | ○ | Identifier for the k header. |
| 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. | |
| LINE_AMOUNT | ● | Line amount. | |
| LINE_NUMBER | PK? | ● | Line number. |
| MAJOR_VERSION | ● | Major version. | |
| MIN_RELEASE_AMT | ● | Min release amount. | |
| MIN_RELEASE_QTY | ● | Min release quantity. | |
| NUM_OF_ITEM | ● | Number of item. | |
| OBJECT1_ID1 | ● | Object1 id1. | |
| OUTPUT_TAX_CLASSIFICATION_CODE | ● | Code identifying the output tax classification. | |
| PRICE_UNIT | ● | Price unit. | |
| PURCHASING_CATEGORY_ID | ● | Identifier for the purchasing category. | |
| SOURCE_CODE_CLASS | ● | Source code class. | |
| START_DATE | ● | Start date. | |
| STS_CODE | ● | Code identifying the status. | |
| TAX_EXEMPTION_CONTROL | ● | Tax exemption control. | |
| TRN_CODE | ● | Code identifying the trn. | |
| UOM_CODE | ● | Code identifying the unit of measure. |
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.
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Enterprise Contracts - Contracts Real Time
- Project Billing - Funding Real Time
- Project Billing - Invoices Real Time
- Project Billing - Revenue Real Time
- Project Costing - Actual Costs Real Time
- Project Costing - Expenditure Item Performance - Real Time
- Projects - Cross Subject Area Analysis - Real Time
- Projects - Grants Management - Award Funding Real Time
Need the extract + dbt staging for OKC_K_LINES_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table