My Project Contracts Table Descriptions hand book (I have big hands)

Project Contracts - OKE_SEARCH_CRITERIA	Table to store user defined search criteria for Authoring filter
Column Name	Descritpion
SEARCH_ID	Unique identifier of search criteria
LAST_UPDATE_DATE	Standard Who column
NAME	Search criteria name
USER_ID	Unique identifier of user who owns the record
FORM_ID	Unique identifier of form against which this search criteria is saved
WHERE_CLAUSE	SQL where clause representing the current search criteria
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Project Contracts - OKE_CHG_LOGS	stores information about contract change statuses history
Column Name	Descritpion
CHG_LOG_ID	Contract change request status change history unique identifier
WF_PROCESS	Contract change request status change workflow process
WF_ITEM_KEY	Contract change request status change workflow item key
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CHG_REQUEST_ID	Contract change request unique identifier
CHG_STATUS_CODE	Contract change request status code
WF_ITEM_TYPE	Contract change request status change workflow item type

Project Contracts - OKE_CHG_REQUESTS	stores information about contract change requests
Column Name	Descritpion
CHG_REQUEST_ID	Contract change request unique identifier
CHG_STATUS_CODE	Contract change request status code
CHG_REASON_CODE	Contract change request reason code
IMPACT_FUNDING_FLAG	Flag indicator whether change request impacts funding information
EFFECTIVE_DATE	Date contract change request becomes effective
REQUESTED_BY_PERSON_ID	Identifier of person who owns this change request
REQUESTED_DATE	Date when this change request is requested
RECEIVE_DATE	Date when this change request is received
APPROVE_DATE	Date when this change request is approved
IMPLEMENT_DATE	Date when this change request is implemented
PREV_VERSION	Version of contract prior to implementation of this change request
CREATION_DATE	Standard Who column
NEW_VERSION	Version of contract after implementation of this change request
DESCRIPTION	Description of change request
CHG_TEXT	Contract change request text
LAST_CHG_LOG_ID	Unique identifier of the most recent status change history record for the current change request
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
CREATED_BY	Standard Who column
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
K_HEADER_ID	Contract document unique identifier
CHG_REQUEST_NUM	Contract change request number
CHG_TYPE_CODE	Contract change reqeust type code

Project Contracts - OKE_CHG_STATUSES_B	Stores information about change statuses
Column Name	Descritpion
CHG_STATUS_CODE	Contract change request status code
START_DATE_ACTIVE	Date this change request status becomes active
END_DATE_ACTIVE	Date this change request status becomes inactive
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
CREATION_DATE	Standard Who column
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CHG_STATUS_TYPE_CODE	Internal code for contract change request status type
DEFAULT_STATUS	Flag indicating whether the change status is a default change status for the status type
WF_ITEM_TYPE	Contract change request status change workflow item type
WF_PROCESS	Contract change request status change workflow process

Project Contracts - OKE_CHG_STATUSES_TL	Contract change request status multi-lingual information
Column Name	Descritpion
CHG_STATUS_CODE	Contract change request status code
DESCRIPTION	Description of change request status
LANGUAGE	Language code of current data
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SOURCE_LANG	Source language code of current data
CHG_STATUS_NAME	Contract change request status name

Project Contracts - OKE_COMM_ACTIONS_B	Stores information about communication actions
Column Name	Descritpion
COMM_ACTION_CODE	Internal code for communication action
START_DATE_ACTIVE	Date this communication action becomes active
END_DATE_ACTIVE	Date this communication action becomes inactive
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
CREATION_DATE	Standard Who column
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OWNER_ID	Unqiue identifier of default owner for this communication action (Change to Optional after 11.5.8)
WF_ITEM_TYPE	Contract communication action workflow item type
WF_PROCESS	Contract communication action workflow process

Project Contracts - OKE_COMM_ACTIONS_TL	Contract communication actions multi-lingual information
Column Name	Descritpion
COMM_ACTION_CODE	Internal code for communication action
SOURCE_LANG	Source language code of current data
LANGUAGE	Language code of current data
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
COMM_ACTION_NAME	Displayed name for communcation action
DESCRIPTION	Description of communication action

Project Contracts - OKE_K_COMMUNICATIONS	COmmunication Definition
Column Name	Descritpion
K_HEADER_ID	Contract document unique identifier
TYPE	Communications type
K_PARTY_ID	Unique identifier for contract party
PARTY_LOCATION	Location of party against which the communication is logged
PARTY_ROLE	Role of party against which the communication is logged
PARTY_CONTACT	Party contact for the communication
ACTION_CODE	Contract communication action code
PRIORITY_CODE	Priority rating code
OWNER	Communication owner
WF_ITEM_TYPE	Contract communication action workflow item type
WF_PROCESS	Contract communication action workflow process
COMMUNICATION_NUM	User-entered number of contract communication
WF_ITEM_KEY	Contract communication action workflow item key
K_LINE_ID	Contract document line item unique identifier
DELIVERABLE_ID	Contract deliverable unique identifier
FUNDING_SOURCE_ID	Funding source unique identifier
FUNDING_REF1	Funding reference
FUNDING_REF2	Funding reference
FUNDING_REF3	Funding reference
CHG_REQUEST_ID	Contract change request unique identifier
PROJECT_ID	System generated project unique identifier
TASK_ID	System generated task unique identifier
CREATION_DATE	Standard Who column
DELETE_IND	reserved for future use
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
CREATED_BY	Standard Who column
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
TEXT	Communications text
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
COMMUNICATION_DATE	Date of communication
REASON_CODE	Internal code for communication reason

Project Contracts - OKE_K_BILLING_METHODS	Billing Methods
Column Name	Descritpion
K_HEADER_ID	Contract document unique identifier
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
BILLING_METHOD_CODE	Billing method code
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DEFAULT_FLAG	Flag indicating whether this billing method is the default for the contract document
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context

Project Contracts - OKE_K_BILLING_METHODS_H	Billing Methods (History)
Column Name	Descritpion
K_HEADER_ID	Contract document unique identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
BILLING_METHOD_CODE	Billing method code
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
MAJOR_VERSION	Major version number of contract document
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DEFAULT_FLAG	Flag indicating whether this billing method is the default for the contract document

Project Contracts - OKE_K_HEADERS	Project contract extended header information
Column Name	Descritpion
K_HEADER_ID	Contract document unique identifier
K_TYPE_CODE	Internal identifier for contract document type
PRIORITY_CODE	Priority rating of contract document
PRIME_K_ALIAS	Prime Contract Alias
PRIME_K_NUMBER	Prime Contract Number
AUTHORIZE_DATE	Authorize Date
AUTHORIZING_REASON	Authorizing Reason
AWARD_CANCEL_DATE	Award Cancel Date
AWARD_DATE	Contract Award Date
DATE_DEFINITIZED	Date Definitized
DATE_ISSUED	Date Issued
CREATION_DATE	Standard Who column
DATE_NEGOTIATED	Date Negotiated
DATE_RECEIVED	Date Received
DATE_SIGN_BY_CONTRACTOR	Date Signed by Contracter
DATE_SIGN_BY_CUSTOMER	Date Signed by Customer
FAA_APPROVE_DATE	First Article Approve Date
FAA_REJECT_DATE	First Article Reject Date
BOOKED_FLAG	Booked indicator
OPEN_FLAG	Open indicator
CFE_FLAG	Customer Furnished Equipment Required indicator
VAT_CODE	VAT Code
CREATED_BY	Standard Who column
COUNTRY_OF_ORIGIN_CODE	Country of origin
EXPORT_FLAG	Export indicator
HUMAN_SUBJECT_FLAG	Human Subject Applies indicator
CQA_FLAG	Customer Quality Acceptance Required indicator
INTERIM_RPT_REQ_FLAG	Interim report required indicator
NO_COMPETITION_AUTHORIZE	Non-competition justification
PENALTY_CLAUSE_FLAG	Penalty Clause Applies indicator
PRODUCT_LINE_CODE	Product Line Code
REPORTING_FLAG	Reporting Required indicator
SB_PLAN_REQ_FLAG	Small Business Plan Required indicator
LAST_UPDATE_DATE	Standard Who column
SB_REPORT_FLAG	Small Business Report Required indicator
NTE_AMOUNT	Not To Exceed Amount
NTE_WARNING_FLAG	Not To Exceed Warning indicator
BILL_WITHOUT_DEF_FLAG	Bill Without Definitized indicator
CAS_FLAG	Cost Accounting Standards Applies indicator
CLASSIFIED_FLAG	Classified indicator
CLIENT_APPROVE_REQ_FLAG	Client Approval Required indicator
COST_OF_MONEY	Cost of Money Applies indicator
DCAA_AUDIT_REQ_FLAG	DCAA Audit Required indicator
LAST_UPDATED_BY	Standard Who column
COST_SHARE_FLAG	Cost Share indicator
OH_RATES_FINAL_FLAG	Overhead Rates Finalized indicator
PROP_DELIVERY_LOCATION	Proposal Delivery Location
PROP_DUE_DATE_TIME	Proposal Due Date
PROP_DUE_TIME	Proposal Due
PROP_EXPIRE_DATE	Proposal Expiry Date
COPIES_REQUIRED	Copies of Reponse Required
SIC_CODE	Industry Classification
TECH_DATA_WH_RATE	Technical Data Withholding Rate
PROGRESS_PAYMENT_FLAG	Progress Payment Applies indicator
PROGRESS_PAYMENT_LIQ_RATE	Progress Payment Liquidation Rate
LAST_UPDATE_LOGIN	Standard Who column
PROGRESS_PAYMENT_RATE	Progress Payment Rate
ALTERNATE_LIQUIDATION_RATE	Alternate Liquidation Rate
DEFINITIZED_FLAG	Definitized indicator
FINANCIAL_CTRL_VERIFIED_FLAG	Financial Control Verified indicator
COST_OF_SALE_RATE	Cost of Sale Rate
LINE_VALUE_TOTAL	Line Value Total
UNDEF_LINE_VALUE_TOTAL	Undefinitized Line Value Total
OWNING_ORGANIZATION_ID	Owning Organization ID
PROGRAM_ID	Program unique identifier
PROJECT_ID	System generated project unique identifier
BOA_ID	Basic Order Agreement unique identifier
K_NUMBER_DISP	Contract document number for display purpose

Project Contracts - OKE_K_HEADERS_H	Project contract extended header historical information
Column Name	Descritpion
K_HEADER_ID	Contract document unique identifier
BOA_ID	Basic Order Agreement unique identifier
K_NUMBER_DISP	Contract document number for display purpose
K_TYPE_CODE	Internal identifier for contract document type
PRIORITY_CODE	Priority rating of contract document
PRIME_K_ALIAS	Prime Contract Alias
PRIME_K_NUMBER	Prime Contract Number
AUTHORIZE_DATE	Authorize Date
AUTHORIZING_REASON	Authorizing Reason
AWARD_CANCEL_DATE	Award Cancel Date
AWARD_DATE	Contract Award Date
DATE_DEFINITIZED	Date Definitized
MAJOR_VERSION	Major version number of contract document
DATE_ISSUED	Date Issued
DATE_NEGOTIATED	Date Negotiated
DATE_RECEIVED	Date Received
DATE_SIGN_BY_CONTRACTOR	Date Signed by Contracter
DATE_SIGN_BY_CUSTOMER	Date Signed by Customer
FAA_APPROVE_DATE	First Article Approve Date
FAA_REJECT_DATE	First Article Reject Date
BOOKED_FLAG	Booked indicator
OPEN_FLAG	Open indicator
CFE_FLAG	Customer Furnished Equipment Required indicator
CREATION_DATE	Standard Who column
VAT_CODE	VAT Code
COUNTRY_OF_ORIGIN_CODE	Country of origin
EXPORT_FLAG	Export indicator
HUMAN_SUBJECT_FLAG	Human Subject Applies indicator
CQA_FLAG	Customer Quality Acceptance Required indicator
INTERIM_RPT_REQ_FLAG	Interim report required indicator
NO_COMPETITION_AUTHORIZE	Non-competition justification
PENALTY_CLAUSE_FLAG	Penalty Clause Applies indicator
PRODUCT_LINE_CODE	Product Line Code
REPORTING_FLAG	Reporting Required indicator
CREATED_BY	Standard Who column
SB_PLAN_REQ_FLAG	Small Business Plan Required indicator
SB_REPORT_FLAG	Small Business Report Required indicator
NTE_AMOUNT	Not To Exceed Amount
NTE_WARNING_FLAG	Not To Exceed Warning indicator
BILL_WITHOUT_DEF_FLAG	Bill Without Definitized indicator
CAS_FLAG	Cost Accounting Standards Applies indicator
CLASSIFIED_FLAG	Classified indicator
CLIENT_APPROVE_REQ_FLAG	Client Approval Required indicator
COST_OF_MONEY	Cost of Money Applies indicator
LAST_UPDATE_DATE	Standard Who column
DCAA_AUDIT_REQ_FLAG	DCAA Audit Required indicator
COST_SHARE_FLAG	Cost Share indicator
OH_RATES_FINAL_FLAG	Overhead Rates Finalized indicator
PROP_DELIVERY_LOCATION	Proposal Delivery Location
PROP_DUE_DATE_TIME	Proposal Due Date
PROP_DUE_TIME	Proposal Due
PROP_EXPIRE_DATE	Proposal Expiry Date
COPIES_REQUIRED	Copies of Reponse Required
SIC_CODE	Industry Classification
TECH_DATA_WH_RATE	Technical Data Withholding Rate
PROGRESS_PAYMENT_FLAG	Progress Payment Applies indicator
LAST_UPDATED_BY	Standard Who column
PROGRESS_PAYMENT_LIQ_RATE	Progress Payment Liquidation Rate
PROGRESS_PAYMENT_RATE	Progress Payment Rate
ALTERNATE_LIQUIDATION_RATE	Alternate Liquidation Rate
DEFINITIZED_FLAG	Definitized indicator
FINANCIAL_CTRL_VERIFIED_FLAG	Financial Control Verified indicator
COST_OF_SALE_RATE	Cost of Sale Rate
LINE_VALUE_TOTAL	Line Value Total
UNDEF_LINE_VALUE_TOTAL	Undefinitized Line Value Total
OWNING_ORGANIZATION_ID	Owning Organization ID
LAST_UPDATE_LOGIN	Standard Who column
PROGRAM_ID	Program unique identifier
PROJECT_ID	System generated project unique identifier

Project Contracts - OKE_K_LINES	Project contract extended line information
Column Name	Descritpion
K_LINE_ID	Contract document line item unique identifier
BILLING_METHOD_CODE	Billing method code
UNDEF_LINE_VALUE_TOTAL	Undefinitized Line Value Total
END_DATE	Line End Date
CUSTOMER_ITEM_NUMBER	Customer Item Number
SCHEDULED_DELV_DEFAULT	Scheduled For Deliverable Default
INVENTORY_ITEM_ID	Inventory item unique identifier
PRIORITY_CODE	Oracle Internal use only - reserved for future use
CUSTOMER_ITEM_ID	Customer Item unique identifier
LINE_VALUE	Contract line value
LINE_QUANTITY	Line Quantity
DELIVERY_DATE	Delivery date
PROPOSAL_DUE_DATE	Proposal Due
UNIT_PRICE	Unit price
UOM_CODE	Unit of measure
CREATION_DATE	Standard Who column
DELIVERY_ORDER_FLAG	Delivery Order indicator
SPLITED_FLAG	Splited indicator
BILLABLE_FLAG	Billable flag
SHIPPABLE_FLAG	Shippable indicator
SUBCONTRACTED_FLAG	Subcontracted indicator
COMPLETED_FLAG	Completed indicator
NSP_FLAG	Not Seperately Priced indicator
APP_CODE	Approval Code
AS_OF_DATE	As of date
AUTHORITY	Authority
CREATED_BY	Standard Who column
COUNTRY_OF_ORIGIN_CODE	Country of origin
DROP_SHIPPED_FLAG	Drop shipped indicator
CUSTOMER_APPROVAL_REQ_FLAG	Customer approval required indicator
DATE_MATERIAL_REQ	Date Material Requested
INSPECTION_REQ_FLAG	Inspection required indicator
INTERIM_RPT_REQ_FLAG	Interim report required indicator
SUBJ_A133_FLAG	Subject A133 Applies indicator
EXPORT_FLAG	Export indicator
CFE_REQ_FLAG	Customer Furnised Equipment Required indicator
COP_REQUIRED_FLAG	Certificate of Performance Required indicator
LAST_UPDATE_DATE	Standard Who column
EXPORT_LICENSE_NUM	Export License Number
EXPORT_LICENSE_RES	Export License Res
COPIES_REQUIRED	Copies of Data Item Required
CDRL_CATEGORY	Data Item Category
DATA_ITEM_NAME	Data Item Name
DATA_ITEM_SUBTITLE	Data Item Subtitle
DATE_OF_FIRST_SUBMISSION	Data item first submission date
FREQUENCY	Data Item Frequency
REQUIRING_OFFICE	Requiring Office
DCAA_AUDIT_REQ_FLAG	DCAA Audit Required indicator
LAST_UPDATED_BY	Standard Who column
DEFINITIZED_FLAG	Definitized indicator
COST_OF_MONEY	Cost of Money Applies indicator
BILL_UNDEFINITIZED_FLAG	Bill Without Definitized indicator
NSN_NUMBER	National Stock Number
NTE_WARNING_FLAG	Not To Exceed Warning indicator
DISCOUNT_FOR_PAYMENT	Discount for Payment
FINANCIAL_CTRL_FLAG	Financial Control Verified indicator
C_SCS_FLAG	Cost Schedule Control System Criteria Applies Flag
C_SSR_FLAG	Cost Schedule Status Report Applies indicator
PREPAYMENT_AMOUNT	Prepayment Amount
LAST_UPDATE_LOGIN	Standard Who column
PREPAYMENT_PERCENTAGE	Prepayment Percentage
PROGRESS_PAYMENT_FLAG	Progress Payment Applies indicator
PROGRESS_PAYMENT_LIQ_RATE	Progress Payment Liquidation Rate
PROGRESS_PAYMENT_RATE	Progress Payment Rate
AWARD_FEE	Award Fee
AWARD_FEE_POOL_AMOUNT	Award Fee Pool Amount
BASE_FEE	Base Fee
CEILING_PRICE	Ceiling Price
CEILING_COST	Ceiling Cost
LABOR_COST_INDEX	Labor Cost Index
PARENT_LINE_ID	Parent Line unique identifier
MATERIAL_COST_INDEX	Material Cost Index
COST_OVERRUN_SHARE_RATIO	Cost Overrun Share Ratio
COST_UNDERRUN_SHARE_RATIO	Cost Underrun Share Ratio
CUSTOMERS_PERCENT_IN_ORDER	Cost share customer percentage
DATE_OF_PRICE_REDETERMIN	Date of Price Redetermination
ESTIMATED_TOTAL_QUANTITY	Estimated Total Quantity
FEE_AJT_FORMULA	Fee Adjustment Formula
FINAL_FEE	Final Fee
FINAL_PFT_AJT_FORMULA	Final Profit Adjustment Formula
FIXED_FEE	Fixed Fee
PROJECT_ID	System generated project unique identifier
FIXED_QUANTITY	Fixed Quantity
INITIAL_FEE	Initial Fee
INITIAL_PRICE	Initial Price
LEVEL_OF_EFFORT_HOURS	Level of Effort Hours
LINE_LIQUIDATION_RATE	Line Liquidation Rate
MAXIMUM_FEE	Maximum Fee
MAXIMUM_QUANTITY	Maximum Quantity
MINIMUM_FEE	Minimum Fee
MINIMUM_QUANTITY	Minimum Quantity
NUMBER_OF_OPTIONS	Number of Options
TASK_ID	System generated task unique identifier
REVISED_PRICE	Revised Price
TARGET_COST	Target Cost
TARGET_DATE_DEFINITIZE	Target Date of Definitization
TARGET_FEE	Target Fee
TARGET_PRICE	Target Price
TOTAL_ESTIMATED_COST	Total Estimated Cost
COST_OF_SALE_RATE	Cost of Sale Rate
LINE_VALUE_TOTAL	Line Value Total
UNDEF_UNIT_PRICE	Undefinitized Unit Price
UNDEF_LINE_VALUE	Undefinitized Line Value

Project Contracts - OKE_K_LINES_H	Project contract extended line historical information
Column Name	Descritpion
K_LINE_ID	Contract document line item unique identifier
TASK_ID	System generated task unique identifier
UNDEF_LINE_VALUE	Undefinitized Line Value
UNDEF_LINE_VALUE_TOTAL	Undefinitized Line Value Total
END_DATE	Line End Date
CUSTOMER_ITEM_NUMBER	Customer Item Number
SCHEDULED_DELV_DEFAULT	Scheduled For Deliverable Default
BILLING_METHOD_CODE	Billing method code
INVENTORY_ITEM_ID	Inventory item unique identifier
PRIORITY_CODE	Oracle Internal use only - reserved for future use
CUSTOMER_ITEM_ID	Customer Item unique identifier
DELIVERY_ORDER_FLAG	Delivery Order indicator
SPLITED_FLAG	Splited indicator
LINE_VALUE	Contract line value
LINE_QUANTITY	Line Quantity
DELIVERY_DATE	Delivery date
MAJOR_VERSION	Major version number of contract document
PROPOSAL_DUE_DATE	Proposal Due
UNIT_PRICE	Unit price
UOM_CODE	Unit of measure
BILLABLE_FLAG	Billable flag
SHIPPABLE_FLAG	Shippable indicator
SUBCONTRACTED_FLAG	Subcontracted indicator
COMPLETED_FLAG	Completed indicator
NSP_FLAG	Not Seperately Priced indicator
APP_CODE	Approval Code
AS_OF_DATE	As of date
CREATION_DATE	Standard Who column
AUTHORITY	Authority
COUNTRY_OF_ORIGIN_CODE	Country of origin
DROP_SHIPPED_FLAG	Drop shipped indicator
CUSTOMER_APPROVAL_REQ_FLAG	Customer approval required indicator
DATE_MATERIAL_REQ	Date Material Requested
INSPECTION_REQ_FLAG	Inspection required indicator
INTERIM_RPT_REQ_FLAG	Interim report required indicator
SUBJ_A133_FLAG	Subject A133 Applies indicator
EXPORT_FLAG	Export indicator
CFE_REQ_FLAG	Customer Furnised Equipment Required indicator
CREATED_BY	Standard Who column
COP_REQUIRED_FLAG	Certificate of Performance Required indicator
EXPORT_LICENSE_NUM	Export License Number
EXPORT_LICENSE_RES	Export License Res
COPIES_REQUIRED	Copies of Data Item Required
CDRL_CATEGORY	Data Item Category
DATA_ITEM_NAME	Data Item Name
DATA_ITEM_SUBTITLE	Data Item Subtitle
DATE_OF_FIRST_SUBMISSION	Data item first submission date
FREQUENCY	Data Item Frequency
REQUIRING_OFFICE	Requiring Office
LAST_UPDATE_DATE	Standard Who column
DCAA_AUDIT_REQ_FLAG	DCAA Audit Required indicator
DEFINITIZED_FLAG	Definitized indicator
COST_OF_MONEY	Cost of Money Applies indicator
BILL_UNDEFINITIZED_FLAG	Bill Without Definitized indicator
NSN_NUMBER	National Stock Number
NTE_WARNING_FLAG	Not To Exceed Warning indicator
DISCOUNT_FOR_PAYMENT	Discount for Payment
FINANCIAL_CTRL_FLAG	Financial Control Verified indicator
C_SCS_FLAG	Cost Schedule Control System Criteria Applies Flag
C_SSR_FLAG	Cost Schedule Status Report Applies indicator
LAST_UPDATED_BY	Standard Who column
PREPAYMENT_AMOUNT	Prepayment Amount
PREPAYMENT_PERCENTAGE	Prepayment Percentage
PROGRESS_PAYMENT_FLAG	Progress Payment Applies indicator
PROGRESS_PAYMENT_LIQ_RATE	Progress Payment Liquidation Rate
PROGRESS_PAYMENT_RATE	Progress Payment Rate
AWARD_FEE	Award Fee
AWARD_FEE_POOL_AMOUNT	Award Fee Pool Amount
BASE_FEE	Base Fee
CEILING_PRICE	Ceiling Price
CEILING_COST	Ceiling Cost
LAST_UPDATE_LOGIN	Standard Who column
MATERIAL_COST_INDEX	Material Cost Index
LABOR_COST_INDEX	Labor Cost Index
COST_OVERRUN_SHARE_RATIO	Cost Overrun Share Ratio
COST_UNDERRUN_SHARE_RATIO	Cost Underrun Share Ratio
CUSTOMERS_PERCENT_IN_ORDER	Cost share customer percentage
DATE_OF_PRICE_REDETERMIN	Date of Price Redetermination
ESTIMATED_TOTAL_QUANTITY	Estimated Total Quantity
FEE_AJT_FORMULA	Fee Adjustment Formula
FINAL_FEE	Final Fee
FINAL_PFT_AJT_FORMULA	Final Profit Adjustment Formula
PARENT_LINE_ID	Parent Line unique identifier
FIXED_FEE	Fixed Fee
FIXED_QUANTITY	Fixed Quantity
INITIAL_FEE	Initial Fee
INITIAL_PRICE	Initial Price
LEVEL_OF_EFFORT_HOURS	Level of Effort Hours
LINE_LIQUIDATION_RATE	Line Liquidation Rate
MAXIMUM_FEE	Maximum Fee
MAXIMUM_QUANTITY	Maximum Quantity
MINIMUM_FEE	Minimum Fee
MINIMUM_QUANTITY	Minimum Quantity
PROJECT_ID	System generated project unique identifier
NUMBER_OF_OPTIONS	Number of Options
REVISED_PRICE	Revised Price
TARGET_COST	Target Cost
TARGET_DATE_DEFINITIZE	Target Date of Definitization
TARGET_FEE	Target Fee
TARGET_PRICE	Target Price
TOTAL_ESTIMATED_COST	Total Estimated Cost
COST_OF_SALE_RATE	Cost of Sale Rate
LINE_VALUE_TOTAL	Line Value Total
UNDEF_UNIT_PRICE	Undefinitized Unit Price

Project Contracts - OKE_K_RELATED_ENTITIES	Related Entity Table
Column Name	Descritpion
K_HEADER_ID	Contract document unique identifier
CHG_REQUEST_ID	Contract change request unique identifier
RELATED_ENTITY_ID	Related document entity unique identifier
RELATED_ENTITY_VERSION	Related document entity version
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Project Contracts - OKE_K_STANDARD_NOTES_B	Contract standard notes information
Column Name	Descritpion
STANDARD_NOTES_ID	Contract standard notes unique identifier
TYPE_CODE	Internal identifier for standard notes type
DEFAULT_FLAG	Flag indicating whether this contract standard note should be defaulted down to lines and sublines
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
CREATION_DATE	Standard Who column
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
K_HEADER_ID	Contract document unique identifier
K_LINE_ID	Contract document line item unique identifier
DELIVERABLE_ID	Contract deliverable unique identifier

Project Contracts - OKE_K_STANDARD_NOTES_BH	Contract standard notes historical information
Column Name	Descritpion
STANDARD_NOTES_ID	Contract standard notes unique identifier
DELIVERABLE_ID	Contract deliverable unique identifier
TYPE_CODE	Internal identifier for standard notes type
DEFAULT_FLAG	Flag indicating whether this contract standard note should be defaulted down to lines and sublines
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
MAJOR_VERSION	Major version number of contract document
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
K_HEADER_ID	Contract document unique identifier
K_LINE_ID	Contract document line item unique identifier

Project Contracts - OKE_K_STANDARD_NOTES_TL	Contract standard notes multi-lingual information
Column Name	Descritpion
STANDARD_NOTES_ID	Contract standard notes unique identifier
DESCRIPTION	Description of standard notes
NAME	User-entered contract standard notes name
TEXT	Contract standard notes text
LANGUAGE	Language code of current data
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SOURCE_LANG	Source language code of current data
SFWT_FLAG	Multi-lingual indicator (not currently used)

Project Contracts - OKE_K_STANDARD_NOTES_TLH	Contract standard notes multi-lingual historical information
Column Name	Descritpion
STANDARD_NOTES_ID	Contract standard notes unique identifier
SFWT_FLAG	Multi-lingual indicator (not currently used)
DESCRIPTION	Description of standard notes
NAME	User-entered contract standard notes name
TEXT	Contract standard notes text
LANGUAGE	Language code of current data
MAJOR_VERSION	Major version number of contract document
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SOURCE_LANG	Source language code of current data

Project Contracts - OKE_K_TERMS	Terms & Conditions
Column Name	Descritpion
K_HEADER_ID	Contract document unique identifier
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
K_LINE_ID	Contract document line item unique identifier
TERM_CODE	Internal identifier for terms
TERM_VALUE_PK1	First primary key value for the term value
TERM_VALUE_PK2	Second primary key value, if needed, for the term value
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Project Contracts - OKE_K_TERMS_H	Terms & Conditions (History)
Column Name	Descritpion
K_HEADER_ID	Contract document unique identifier
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
MAJOR_VERSION	Major version number of contract document
K_LINE_ID	Contract document line item unique identifier
TERM_CODE	Internal identifier for terms
TERM_VALUE_PK1	First primary key value for the term value
TERM_VALUE_PK2	Second primary key value, if needed, for the term value
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Project Contracts - OKE_K_USER_ATTRIBUTES	User Attributes Header and Lines
Column Name	Descritpion
K_USER_ATTRIBUTE_ID	Unique identifier for extensive contract attribute record
USER_ATTRIBUTE01	Extensible contract attribute
USER_ATTRIBUTE02	Extensible contract attribute
USER_ATTRIBUTE03	Extensible contract attribute
USER_ATTRIBUTE04	Extensible contract attribute
USER_ATTRIBUTE05	Extensible contract attribute
USER_ATTRIBUTE06	Extensible contract attribute
USER_ATTRIBUTE07	Extensible contract attribute
USER_ATTRIBUTE08	Extensible contract attribute
USER_ATTRIBUTE09	Extensible contract attribute
USER_ATTRIBUTE10	Extensible contract attribute
CREATION_DATE	Standard Who column
USER_ATTRIBUTE11	Extensible contract attribute
USER_ATTRIBUTE12	Extensible contract attribute
USER_ATTRIBUTE13	Extensible contract attribute
USER_ATTRIBUTE14	Extensible contract attribute
USER_ATTRIBUTE15	Extensible contract attribute
USER_ATTRIBUTE16	Extensible contract attribute
USER_ATTRIBUTE17	Extensible contract attribute
USER_ATTRIBUTE18	Extensible contract attribute
USER_ATTRIBUTE19	Extensible contract attribute
USER_ATTRIBUTE20	Extensible contract attribute
CREATED_BY	Standard Who column
USER_ATTRIBUTE21	Extensible contract attribute
USER_ATTRIBUTE22	Extensible contract attribute
USER_ATTRIBUTE23	Extensible contract attribute
USER_ATTRIBUTE24	Extensible contract attribute
USER_ATTRIBUTE25	Extensible contract attribute
USER_ATTRIBUTE26	Extensible contract attribute
USER_ATTRIBUTE27	Extensible contract attribute
USER_ATTRIBUTE28	Extensible contract attribute
USER_ATTRIBUTE29	Extensible contract attribute
USER_ATTRIBUTE30	Extensible contract attribute
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
RECORD_VERSION_NUMBER	Locking sequence number for the record
K_HEADER_ID	Contract document unique identifier
K_LINE_ID	Contract document line item unique identifier
USER_ATTRIBUTE_CONTEXT	Extensible contract attribute group

Project Contracts - OKE_K_USER_ATTRIBUTES_H	User Attributes Header and Lines (History)
Column Name	Descritpion
K_USER_ATTRIBUTE_ID	Unique identifier for extensive contract attribute record
USER_ATTRIBUTE_CONTEXT	Extensible contract attribute group
USER_ATTRIBUTE01	Extensible contract attribute
USER_ATTRIBUTE02	Extensible contract attribute
USER_ATTRIBUTE03	Extensible contract attribute
USER_ATTRIBUTE04	Extensible contract attribute
USER_ATTRIBUTE05	Extensible contract attribute
USER_ATTRIBUTE06	Extensible contract attribute
USER_ATTRIBUTE07	Extensible contract attribute
USER_ATTRIBUTE08	Extensible contract attribute
USER_ATTRIBUTE09	Extensible contract attribute
MAJOR_VERSION	Major version number of contract document
USER_ATTRIBUTE10	Extensible contract attribute
USER_ATTRIBUTE11	Extensible contract attribute
USER_ATTRIBUTE12	Extensible contract attribute
USER_ATTRIBUTE13	Extensible contract attribute
USER_ATTRIBUTE14	Extensible contract attribute
USER_ATTRIBUTE15	Extensible contract attribute
USER_ATTRIBUTE16	Extensible contract attribute
USER_ATTRIBUTE17	Extensible contract attribute
USER_ATTRIBUTE18	Extensible contract attribute
USER_ATTRIBUTE19	Extensible contract attribute
CREATION_DATE	Standard Who column
USER_ATTRIBUTE20	Extensible contract attribute
USER_ATTRIBUTE21	Extensible contract attribute
USER_ATTRIBUTE22	Extensible contract attribute
USER_ATTRIBUTE23	Extensible contract attribute
USER_ATTRIBUTE24	Extensible contract attribute
USER_ATTRIBUTE25	Extensible contract attribute
USER_ATTRIBUTE26	Extensible contract attribute
USER_ATTRIBUTE27	Extensible contract attribute
USER_ATTRIBUTE28	Extensible contract attribute
USER_ATTRIBUTE29	Extensible contract attribute
CREATED_BY	Standard Who column
USER_ATTRIBUTE30	Extensible contract attribute
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
RECORD_VERSION_NUMBER	Locking sequence number for the record
K_HEADER_ID	Contract document unique identifier
K_LINE_ID	Contract document line item unique identifier

Project Contracts - OKE_K_VERS_NUMBERS_H	Version Information
Column Name	Descritpion
K_HEADER_ID	Contract document unique identifier
MAJOR_VERSION	Major version number of contract document
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_REASON_CODE	Internal code for versioning reason
CHG_REQUEST_ID	Contract change request that triggers this version of the contract

Project Contracts - OKE_PROGRAMS	Stores information about programs
Column Name	Descritpion
PROGRAM_ID	Program unique identifier
DESCRIPTION	Description of program
START_DATE_ACTIVE
END_DATE_ACTIVE
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
CREATION_DATE	Standard Who column
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
RECORD_VERSION_NUMBER	Locking sequence number for the record
PROGRAM_NUMBER	Program number
PROGRAM_NAME	Program name

Project Contracts - OKE_DEPENDENCIES	Table to store dependencies related to contract deliverables.
Column Name	Descritpion
DELIVERABLE_ID	Contract deliverable unique identifier
DEPENDENT_ID	Unique identifier of successor deliverable
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Description of dependency

Project Contracts - OKE_K_DELIVERABLES_B	This table stores all deliverable information for Project Contracts
Column Name	Descritpion
DELIVERABLE_ID	Contract deliverable unique identifier
LAST_UPDATE_LOGIN	Standard Who column
BILL_QUANTITY	Obsolete - no longer used
BILL_UNIT_PRICE	Obsolete - no longer used
REVENUE_AMOUNT	Obsolete - no longer used
RATE_TYPE	Foreign currency exchange rate type
RATE_DATE	Foreign currency exchange rate date
EXCHANGE_RATE	Foreign currency exchange rate, used primarily for requisition creation
DELIVERABLE_NUM	Deliverable Number
PROJECT_ID	System generated project unique identifier
TASK_ID	System generated task unique identifier
ITEM_ID	Inventory item unique identifier
K_HEADER_ID	Contract document unique identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
K_LINE_ID	Contract document line item unique identifier
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
DELIVERY_DATE	Delivery date
STATUS_CODE	Oracle Internal use only - reserved for future use
STATUS_DATE	Oracle Internal use only - reserved for future use
PARENT_DELIVERABLE_ID	Oracle Internal use only - reserved for future use
DIRECTION	Direction of deliverable, either inbound or outbound
SHIP_TO_ORG_ID	Ship to organization unique identifier
SHIP_TO_LOCATION_ID	Ship to location unique identifier
SHIP_FROM_ORG_ID	Ship from organization unique identifier
SHIP_FROM_LOCATION_ID	Ship from location unique identifier
INVENTORY_ORG_ID	Inventory organization unique identifier. Depending on direction, it is either the ship-from or ship-to location
DEFAULTED_FLAG	Flag indicating whether deliverable is defaulted
IN_PROCESS_FLAG	Flag indicating deliverable is currently in integration process
WF_ITEM_KEY	Deliverable process workflow item key
SUB_REF_ID	Linked subcontract deliverable unique identifier
START_DATE	Start date of deliverable
END_DATE	Deliverable end date
NEED_BY_DATE	Need by date for the deliverable
PRIORITY_CODE	Oracle Internal use only - reserved for future use
CURRENCY_CODE	Currency
UNIT_PRICE	Unit price
UOM_CODE	Unit of measure
QUANTITY	Deliverable quantity
COUNTRY_OF_ORIGIN_CODE	Country of origin
SUBCONTRACTED_FLAG	Subcontracted indicator
DEPENDENCY_FLAG	Flag indicating dependencies exist for this deliverable
BILLABLE_FLAG	Billable flag
DROP_SHIPPED_FLAG	Drop shipped indicator
COMPLETED_FLAG	Completed indicator
AVAILABLE_FOR_SHIP_FLAG	Flag indicating deliverable eligible for shipping
CREATE_DEMAND	Flag indicator whether planning demand should be created or not
READY_TO_BILL	Flag indicating deliverable is ready for initiating billing action
READY_TO_PROCURE	Flag indicating deliverable is ready for initiating procurement action
SHIPPABLE_FLAG	Shippable indicator
CFE_REQ_FLAG	Customer Furnised Equipment Required indicator
INSPECTION_REQ_FLAG	Inspection required indicator
INTERIM_RPT_REQ_FLAG	Interim report required indicator
LOT_APPLIES_FLAG	Oracle Internal use only - reserved for future use
CUSTOMER_APPROVAL_REQ_FLAG	Customer approval required indicator
EXPECTED_SHIPMENT_DATE	Expected shipment date
INITIATE_SHIPMENT_DATE	Date on which shipment request should be initiated
PROMISED_SHIPMENT_DATE	Date on which shipment is promised
AS_OF_DATE	As of date
DATE_OF_FIRST_SUBMISSION	Data item first submission date
CREATION_DATE	Standard Who column
FREQUENCY	Frequency
ACQ_DOC_NUMBER	Oracle Internal use only - reserved for future use
SUBMISSION_FLAG	Oracle Internal use only - reserved for future use
DATA_ITEM_SUBTITLE	Data item subtitle
TOTAL_NUM_OF_COPIES	Total number of copies required for data item submission
CDRL_CATEGORY	Data Item Category
DATA_ITEM_NAME	Data item name
EXPORT_FLAG	Export indicator
EXPORT_LICENSE_NUM	Export License Number
EXPORT_LICENSE_RES	Party responsible for obtaining export license
CREATED_BY	Standard Who column
SHIPPING_REQUEST_ID	Unique identifier of shipping request initiated from this deliverable
MPS_TRANSACTION_ID	Unique identifier of MDS entry associated with the deliverable
PO_REF_1	Requisition Interface batch identifier
PO_REF_2	Oracle Internal use only - reserved for future use
PO_REF_3	Oracle Internal use only - reserved for future use
UNIT_NUMBER	End item model/unit number
NDB_SCHEDULE_DESIGNATOR	MRP plan name
VOLUME	Volume
VOLUME_UOM_CODE	Volume UOM code
WEIGHT	Weight
WEIGHT_UOM_CODE	Weight UOM code
EXPENDITURE_ORGANIZATION_ID	Expenditure organization unique identifier
EXPENDITURE_TYPE	Expenditure type
EXPENDITURE_ITEM_DATE	Expenditure item date
LAST_UPDATE_DATE	Standard Who column
DESTINATION_TYPE_CODE	Destination type code for requisition creation
BILLING_EVENT_ID	Obsolete - no longer used
BILL_EVENT_TYPE	Obsolete - no longer used
BILL_EVENT_DATE	Obsolete - no longer used
BILL_ITEM_ID	Obsolete - no longer used
BILL_LINE_ID	Obsolete - no longer used
BILL_CHG_REQ_ID	Obsolete - no longer used
BILL_PROJECT_ID	Obsolete - no longer used
BILL_TASK_ID	Obsolete - no longer used
BILL_ORGANIZATION_ID	Obsolete - no longer used
LAST_UPDATED_BY	Standard Who column
BILL_FUND_REF1	Obsolete - no longer used
BILL_FUND_REF2	Obsolete - no longer used
BILL_FUND_REF3	Obsolete - no longer used
BILL_BILL_OF_LADING	Obsolete - no longer used
BILL_SERIAL_NUM	Obsolete - no longer used
BILL_CURRENCY_CODE	Obsolete - no longer used
BILL_RATE_TYPE	Obsolete - no longer used
BILL_RATE_DATE	Obsolete - no longer used
BILL_EXCHANGE_RATE	Obsolete - no longer used
BILL_DESCRIPTION	Obsolete - no longer used

Project Contracts - OKE_K_DELIVERABLES_BH	Historical Contract Deliverable information
Column Name	Descritpion
DELIVERABLE_ID	Contract deliverable unique identifier
TASK_ID	System generated task unique identifier
BILL_DESCRIPTION	Obsolete - no longer used
BILL_QUANTITY	Obsolete - no longer used
BILL_UNIT_PRICE	Obsolete - no longer used
REVENUE_AMOUNT	Obsolete - no longer used
RATE_DATE	Foreign currency exchange rate date
RATE_TYPE	Foreign currency exchange rate type
EXCHANGE_RATE	Foreign currency exchange rate, used primarily for requisition creation
ITEM_ID	Inventory item unique identifier
K_HEADER_ID	Contract document unique identifier
K_LINE_ID	Contract document line item unique identifier
DELIVERY_DATE	Delivery date
STATUS_CODE	Oracle Internal use only - reserved for future use
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
STATUS_DATE	Oracle Internal use only - reserved for future use
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
PARENT_DELIVERABLE_ID	Oracle Internal use only - reserved for future use
DIRECTION	Direction of deliverable, either inbound or outbound
SHIP_TO_ORG_ID	Ship to organization unique identifier
MAJOR_VERSION	Major version number of contract document
SHIP_TO_LOCATION_ID	Ship to location unique identifier
SHIP_FROM_ORG_ID	Ship from organization unique identifier
SHIP_FROM_LOCATION_ID	Ship from location unique identifier
INVENTORY_ORG_ID	Inventory organization unique identifier. Depending on direction, it is either the ship-from or ship-to location
DEFAULTED_FLAG	Flag indicating whether deliverable is defaulted
IN_PROCESS_FLAG	Flag indicating deliverable is currently in integration process
WF_ITEM_KEY	Deliverable process workflow item key
SUB_REF_ID	Linked subcontract deliverable unique identifier
START_DATE	Start date of deliverable
END_DATE	Deliverable end date
CREATION_DATE	Standard Who column
NEED_BY_DATE	Need by date for the deliverable
PRIORITY_CODE	Oracle Internal use only - reserved for future use
CURRENCY_CODE	Currency
UNIT_PRICE	Unit price
UOM_CODE	Unit of measure
QUANTITY	Deliverable quantity
COUNTRY_OF_ORIGIN_CODE	Country of origin
SUBCONTRACTED_FLAG	Subcontracted indicator
DEPENDENCY_FLAG	Flag indicating dependencies exist for this deliverable
BILLABLE_FLAG	Billable flag
CREATED_BY	Standard Who column
DROP_SHIPPED_FLAG	Drop shipped indicator
COMPLETED_FLAG	Completed indicator
AVAILABLE_FOR_SHIP_FLAG	Flag indicating deliverable eligible for shipping
CREATE_DEMAND	Flag indicator whether planning demand should be created or not
READY_TO_BILL	Flag indicating deliverable is ready for initiating billing action
READY_TO_PROCURE	Flag indicating deliverable is ready for initiating procurement action
SHIPPABLE_FLAG	Shippable indicator
CFE_REQ_FLAG	Customer Furnised Equipment Required indicator
INSPECTION_REQ_FLAG	Inspection required indicator
INTERIM_RPT_REQ_FLAG	Interim report required indicator
LAST_UPDATE_DATE	Standard Who column
LOT_APPLIES_FLAG	Oracle Internal use only - reserved for future use
CUSTOMER_APPROVAL_REQ_FLAG	Customer approval required indicator
EXPECTED_SHIPMENT_DATE	Expected shipment date
INITIATE_SHIPMENT_DATE	Date on which shipment request should be initiated
PROMISED_SHIPMENT_DATE	Date on which shipment is promised
AS_OF_DATE	As of date
DATE_OF_FIRST_SUBMISSION	Data item first submission date
FREQUENCY	Frequency
ACQ_DOC_NUMBER	Oracle Internal use only - reserved for future use
SUBMISSION_FLAG	Oracle Internal use only - reserved for future use
LAST_UPDATED_BY	Standard Who column
DATA_ITEM_SUBTITLE	Data item subtitle
TOTAL_NUM_OF_COPIES	Total number of copies required for data item submission
CDRL_CATEGORY	Data Item Category
DATA_ITEM_NAME	Data item name
EXPORT_FLAG	Export indicator
EXPORT_LICENSE_NUM	Export License Number
EXPORT_LICENSE_RES	Party responsible for obtaining export license
SHIPPING_REQUEST_ID	Unique identifier of shipping request initiated from this deliverable
MPS_TRANSACTION_ID	Unique identifier of MDS entry associated with the deliverable
PO_REF_1	Requisition Interface batch identifier
LAST_UPDATE_LOGIN	Standard Who column
PO_REF_2	Oracle Internal use only - reserved for future use
PO_REF_3	Oracle Internal use only - reserved for future use
UNIT_NUMBER	End item model/unit number
NDB_SCHEDULE_DESIGNATOR	MRP plan name
VOLUME	Volume
VOLUME_UOM_CODE	Volume UOM code
WEIGHT	Weight
WEIGHT_UOM_CODE	Weight UOM code
EXPENDITURE_ORGANIZATION_ID	Expenditure organization unique identifier
EXPENDITURE_TYPE	Expenditure type
DELIVERABLE_NUM	Deliverable Number
EXPENDITURE_ITEM_DATE	Expenditure item date
DESTINATION_TYPE_CODE	Destination type code for requisition creation
BILLING_EVENT_ID	Obsolete - no longer used
BILL_EVENT_TYPE	Obsolete - no longer used
BILL_EVENT_DATE	Obsolete - no longer used
BILL_ITEM_ID	Obsolete - no longer used
BILL_LINE_ID	Obsolete - no longer used
BILL_CHG_REQ_ID	Obsolete - no longer used
BILL_PROJECT_ID	Obsolete - no longer used
BILL_TASK_ID	Obsolete - no longer used
PROJECT_ID	System generated project unique identifier
BILL_ORGANIZATION_ID	Obsolete - no longer used
BILL_FUND_REF1	Obsolete - no longer used
BILL_FUND_REF2	Obsolete - no longer used
BILL_FUND_REF3	Obsolete - no longer used
BILL_BILL_OF_LADING	Obsolete - no longer used
BILL_SERIAL_NUM	Obsolete - no longer used
BILL_CURRENCY_CODE	Obsolete - no longer used
BILL_RATE_TYPE	Obsolete - no longer used
BILL_RATE_DATE	Obsolete - no longer used
BILL_EXCHANGE_RATE	Obsolete - no longer used

Project Contracts - OKE_K_DELIVERABLES_TL	Contract deliverable multi-lingual information
Column Name	Descritpion
DELIVERABLE_ID	Contract deliverable unique identifier
SOURCE_LANG	Source language code of current data
SFWT_FLAG	Multi-lingual indicator (not currently used)
DESCRIPTION	Description of deliverable
COMMENTS	User-entered comments
LANGUAGE	Language code of current data
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
K_HEADER_ID	Contract document unique identifier
K_LINE_ID	Contract document line item unique identifier

Project Contracts - OKE_K_DELIVERABLES_TLH	Contract deliverable multi-lingual historical information
Column Name	Descritpion
DELIVERABLE_ID	Contract deliverable unique identifier
K_LINE_ID	Contract document line item unique identifier
SOURCE_LANG	Source language code of current data
SFWT_FLAG	Multi-lingual indicator (not currently used)
DESCRIPTION	Description of deliverable
COMMENTS	User-entered comments
LANGUAGE	Language code of current data
MAJOR_VERSION	Major version number of contract document
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
K_HEADER_ID	Contract document unique identifier

Project Contracts - OKE_SUBMISSIONS	Table to store subsequent submissions for data item contract deliverables
Column Name	Descritpion
DELIVERABLE_ID	Contract deliverable unique identifier
REASON	Reason for subsequent submission
SUBMISSION_DATE	Submission date
DATE_EXTENDED	Date extended
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Project Contracts - OKE_ARTICLE_FLOWDOWNS	holds flowdown setting for the articles by the article subjects
Column Name	Descritpion
BUSINESS_AREA_CODE	Flowdown business area code
ARTICLE_SUBJECT_CODE	Contract article subject code
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Project Contracts - OKE_ATTRIBUTE_FLOWDOWNS	stores the mappings between the contract attributes and business areas
Column Name	Descritpion
BUSINESS_AREA_CODE	Flowdown business area code
ATTRIBUTE_GROUP_CODE	Attribute group code
ATTRIBUTE_GROUP_TYPE	Attribute group type, either system or user
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Project Contracts - OKE_DOCUMENT_FLOWDOWNS	holds flowdown setting for the attachments by the document categories
Column Name	Descritpion
BUSINESS_AREA_CODE	Flowdown business area code
DOCUMENT_CATEGORY_ID	Unique identifier for attachment document category
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Project Contracts - OKE_STD_NOTE_FLOWDOWNS	holds flowdown setting for the standard notes by the standard note types
Column Name	Descritpion
BUSINESS_AREA_CODE	Flowdown business area code
STD_NOTE_CODE	Internal code for uniquely identifying standard note
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Project Contracts - OKE_TERMCOND_FLOWDOWNS	holds flowdown setting for the terms & conditions by the term types
Column Name	Descritpion
BUSINESS_AREA_CODE	Flowdown business area code
TERM_TYPE_CODE	Internal identifier for terms and conditions type
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Project Contracts - OKE_OBJECT_ATTRIBUTES_B	Contract attributes
Column Name	Descritpion
DATABASE_OBJECT_NAME	Identifier for the object to which this attribute belongs
QUERYABLE_FLAG	Flag indicating whether attribute is queryable
VIEW_COLUMN_FLAG	Flag indicating whether attribute is a view column
FORM_ITEM_FLAG	Flag indicating whether attribute is a form item
ATTRIBUTE_GROUP_CODE	Attribute group code
PARENT_ATTRIBUTE_CODE	Internal code of the parent attribute
ATTRIBUTE_CODE	Attribute code
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DATATYPE	Data type of attribute
SECURABLE_FLAG	Flag indicating whether attribute is securable

Project Contracts - OKE_OBJECT_ATTRIBUTES_TL	Contract attributes multi-lingual information
Column Name	Descritpion
DATABASE_OBJECT_NAME	Identifier for the object to which this attribute belongs
ATTRIBUTE_NAME	Attribute name
DESCRIPTION	Description of attribute
ATTRIBUTE_CODE	Attribute code
LANGUAGE	Language code of current data
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SOURCE_LANG	Source language code of current data

Project Contracts - OKE_FUNDING_POOLS	Funding Pool Definition
Column Name	Descritpion
FUNDING_POOL_ID	Funding pool unique identifier
CONTACT_PERSON_ID	Unique identifier of contact person for this funding pool
PROGRAM_ID	Program unique identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
CREATION_DATE	Standard Who column
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
NAME	Funding pool name
DESCRIPTION	Description of funding pool
CURRENCY_CODE	Currency of funding pool

Project Contracts - OKE_K_FUNDING_SOURCES	Contract Funding Sources
Column Name	Descritpion
FUNDING_SOURCE_ID	System generated unique identifier for funding source
K_PARTY_ID	Unique identifier for contract party
AGREEMENT_NUMBER	Project agreement number that corresponds to this funding source
AGREEMENT_ORG_ID	Unique identifier of agreement owning organization
AMOUNT	Contract funding source amount
INITIAL_AMOUNT	Initial funding source amount
PREVIOUS_AMOUNT	Amount from the previous version of the funding source
FUNDING_STATUS	Funding status
HARD_LIMIT	Invoice hard limit
REVENUE_HARD_LIMIT	Revenue hard limit
CURRENCY_CODE	Currency
CREATION_DATE	Standard Who column
K_CONVERSION_TYPE	Exchange rate type for conversion to contract currency
K_CONVERSION_DATE	Date of currency exchange rate to contract currency
K_CONVERSION_RATE	Currency exchange rate to contract currency
START_DATE_ACTIVE	Date this funding source becomes active
END_DATE_ACTIVE	Date this funding source becomes inactive
AGREEMENT_FLAG	Flag indicating whether this funding is converted from Oracle Projects
FUNDING_ACROSS_OU	Indicator to show the funding source is orginally from Oracle Projects and with funded projects from different operating units
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
CREATED_BY	Standard Who column
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
PA_ATTRIBUTE_CATEGORY	Project agreement descriptive flexfield attribute category
PA_ATTRIBUTE1	Project agreement descriptive flexfield attribute
PA_ATTRIBUTE2	Project agreement descriptive flexfield attribute
PA_ATTRIBUTE3	Project agreement descriptive flexfield attribute
PA_ATTRIBUTE4	Project agreement descriptive flexfield attribute
PA_ATTRIBUTE5	Project agreement descriptive flexfield attribute
PA_ATTRIBUTE6	Project agreement descriptive flexfield attribute
PA_ATTRIBUTE7	Project agreement descriptive flexfield attribute
LAST_UPDATED_BY	Standard Who column
PA_ATTRIBUTE8	Project agreement descriptive flexfield attribute
PA_ATTRIBUTE9	Project agreement descriptive flexfield attribute
PA_ATTRIBUTE10	Project agreement descriptive flexfield attribute
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_TYPE	Internal identifier of the type of object. Currently only valid value is OKE_K_HEADER
OBJECT_ID	Contract document unique identifier
POOL_PARTY_ID	Unique identifier of funding pool party that is funding this contract document

Project Contracts - OKE_K_FUNDING_SOURCES_H	Contract Funding Sources History
Column Name	Descritpion
FUNDING_SOURCE_ID	System generated unique identifier for funding source
POOL_PARTY_ID	Unique identifier of funding pool party that is funding this contract document
K_PARTY_ID	Unique identifier for contract party
AGREEMENT_NUMBER	Project agreement number that corresponds to this funding source
AGREEMENT_ORG_ID	Unique identifier of agreement owning organization
AMOUNT	Contract funding source amount
INITIAL_AMOUNT	Initial funding source amount
PREVIOUS_AMOUNT	Amount from the previous version of the funding source
FUNDING_STATUS	Funding status
HARD_LIMIT	Invoice hard limit
REVENUE_HARD_LIMIT	Revenue hard limit
MAJOR_VERSION	Major version number of contract document
CURRENCY_CODE	Currency
K_CONVERSION_TYPE	Exchange rate type for conversion to contract currency
K_CONVERSION_DATE	Date of currency exchange rate to contract currency
K_CONVERSION_RATE	Currency exchange rate to contract currency
START_DATE_ACTIVE	Date this funding source becomes active
END_DATE_ACTIVE	Date this funding source becomes inactive
AGREEMENT_FLAG	Flag indicating whether this funding is converted from Oracle Projects
FUNDING_ACROSS_OU	Indicator to show the funding source is orginally from Oracle Projects and with funded projects from different operating units
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
CREATION_DATE	Standard Who column
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
CREATED_BY	Standard Who column
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
PA_ATTRIBUTE_CATEGORY	Project agreement descriptive flexfield attribute category
PA_ATTRIBUTE1	Project agreement descriptive flexfield attribute
PA_ATTRIBUTE2	Project agreement descriptive flexfield attribute
PA_ATTRIBUTE3	Project agreement descriptive flexfield attribute
PA_ATTRIBUTE4	Project agreement descriptive flexfield attribute
PA_ATTRIBUTE5	Project agreement descriptive flexfield attribute
PA_ATTRIBUTE6	Project agreement descriptive flexfield attribute
LAST_UPDATE_DATE	Standard Who column
PA_ATTRIBUTE7	Project agreement descriptive flexfield attribute
PA_ATTRIBUTE8	Project agreement descriptive flexfield attribute
PA_ATTRIBUTE9	Project agreement descriptive flexfield attribute
PA_ATTRIBUTE10	Project agreement descriptive flexfield attribute
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_TYPE	Internal identifier of the type of object. Currently only valid value is OKE_K_HEADER
OBJECT_ID	Contract document unique identifier

Project Contracts - OKE_K_FUND_ALLOCATIONS	Contract Funding Allocations
Column Name	Descritpion
FUND_ALLOCATION_ID	System generated unique identifier for funding allocation
PROJECT_ID	System generated project unique identifier
TASK_ID	System generated task unique identifier
AMOUNT	Contract funding allocation amount
PREVIOUS_AMOUNT	Amount from the previous version of the funding allocation
HARD_LIMIT	Invoice hard limit
REVENUE_HARD_LIMIT	Revenue hard limit
PA_CONVERSION_TYPE	Exchange rate type from funding currency to project functional currency
PA_CONVERSION_DATE	Exchange rate date from funding currency to project functional currency
PA_CONVERSION_RATE	Exchange rate from funding currency to project functional currency
FUND_TYPE	User-defined funding type using lookup FUND_TYPE
CREATION_DATE	Standard Who column
FUNDING_STATUS	Funding status
START_DATE_ACTIVE	Date this funding allocation becomes active
END_DATE_ACTIVE	Date this funding allocation becomes inactive
FISCAL_YEAR	Fiscal year that corresponds to this funding allocation
REFERENCE1	Funding reference
REFERENCE2	Funding reference
REFERENCE3	Funding reference
AGREEMENT_VERSION	Count of how many times this allocation has been interfaced with Oracle Projects
INSERT_UPDATE_FLAG	Flag indicating whether this allocation is created or updated after its last interface with Oracle Projects
CREATED_IN_VERSION	Version of the contract document when this funding allocation was first created
CREATED_BY	Standard Who column
UPDATED_IN_VERSION	Version of the contract document when this funding allocation was last updated
PA_FLAG	Flag indicating whether this allocation has been interfaced with Oracle Projects
FUNDING_CATEGORY	Funding category using lookup FUNDING CATEGORY TYPE
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
PA_ATTRIBUTE_CATEGORY	Project funding descriptive flexfield attribute category
PA_ATTRIBUTE1	Project funding descriptive flexfield attribute
LAST_UPDATED_BY	Standard Who column
PA_ATTRIBUTE2	Project funding descriptive flexfield attribute
PA_ATTRIBUTE3	Project funding descriptive flexfield attribute
PA_ATTRIBUTE4	Project funding descriptive flexfield attribute
PA_ATTRIBUTE5	Project funding descriptive flexfield attribute
PA_ATTRIBUTE6	Project funding descriptive flexfield attribute
PA_ATTRIBUTE7	Project funding descriptive flexfield attribute
PA_ATTRIBUTE8	Project funding descriptive flexfield attribute
PA_ATTRIBUTE9	Project funding descriptive flexfield attribute
PA_ATTRIBUTE10	Project funding descriptive flexfield attribute
LAST_UPDATE_LOGIN	Standard Who column
FUNDING_SOURCE_ID	Unique identifier of the funding source for this allocation
OBJECT_ID	Contract document unique identifier
K_LINE_ID	Contract document line item unique identifier

Project Contracts - OKE_K_FUND_ALLOCATIONS_H	Contract Funding Allocations History
Column Name	Descritpion
FUND_ALLOCATION_ID	System generated unique identifier for funding allocation
K_LINE_ID	Contract document line item unique identifier
PROJECT_ID	System generated project unique identifier
TASK_ID	System generated task unique identifier
AMOUNT	Contract funding allocation amount
PREVIOUS_AMOUNT	Amount from the previous version of the funding allocation
HARD_LIMIT	Invoice hard limit
REVENUE_HARD_LIMIT	Revenue hard limit
PA_CONVERSION_TYPE	Exchange rate type from funding currency to project functional currency
PA_CONVERSION_DATE	Exchange rate date from funding currency to project functional currency
PA_CONVERSION_RATE	Exchange rate from funding currency to project functional currency
MAJOR_VERSION	Major version number of contract document
FUND_TYPE	User-defined funding type using lookup FUND_TYPE
FUNDING_STATUS	Funding status
START_DATE_ACTIVE	Date this funding allocation becomes active
END_DATE_ACTIVE	Date this funding allocation becomes inactive
FISCAL_YEAR	Fiscal year that corresponds to this funding allocation
REFERENCE1	Funding reference
REFERENCE2	Funding reference
REFERENCE3	Funding reference
AGREEMENT_VERSION	Count of how many times this allocation has been interfaced with Oracle Projects
INSERT_UPDATE_FLAG	Flag indicating whether this allocation is created or updated after its last interface with Oracle Projects
CREATION_DATE	Standard Who column
CREATED_IN_VERSION	Version of the contract document when this funding allocation was first created
UPDATED_IN_VERSION	Version of the contract document when this funding allocation was last updated
PA_FLAG	Flag indicating whether this allocation has been interfaced with Oracle Projects
FUNDING_CATEGORY	Funding category using lookup FUNDING CATEGORY TYPE
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
CREATED_BY	Standard Who column
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
PA_ATTRIBUTE_CATEGORY	Project funding descriptive flexfield attribute category
LAST_UPDATE_DATE	Standard Who column
PA_ATTRIBUTE1	Project funding descriptive flexfield attribute
PA_ATTRIBUTE2	Project funding descriptive flexfield attribute
PA_ATTRIBUTE3	Project funding descriptive flexfield attribute
PA_ATTRIBUTE4	Project funding descriptive flexfield attribute
PA_ATTRIBUTE5	Project funding descriptive flexfield attribute
PA_ATTRIBUTE6	Project funding descriptive flexfield attribute
PA_ATTRIBUTE7	Project funding descriptive flexfield attribute
PA_ATTRIBUTE8	Project funding descriptive flexfield attribute
PA_ATTRIBUTE9	Project funding descriptive flexfield attribute
PA_ATTRIBUTE10	Project funding descriptive flexfield attribute
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FUNDING_SOURCE_ID	Unique identifier of the funding source for this allocation
OBJECT_ID	Contract document unique identifier

Project Contracts - OKE_POOL_PARTIES	Funding Pool Parties
Column Name	Descritpion
POOL_PARTY_ID	Funding pool party unique identifier
CONVERSION_TYPE	Exchange rate type for conversion to funding pool currency
CONVERSION_DATE	Date of currency exchange rate to funding pool currency
CONVERSION_RATE	Currency exchange rate to funding pool currency
INITIAL_AMOUNT	Initial funding pool amount
AMOUNT	Funding pool amount
AVAILABLE_AMOUNT	Available, unallocated amount
START_DATE_ACTIVE	Date this funding pool party becomes active
END_DATE_ACTIVE	Date this funding pool party becomes inactive
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
CREATION_DATE	Standard Who column
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
CREATED_BY	Standard Who column
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FUNDING_POOL_ID	Funding pool unique identifier
PARTY_ID	Party associated to this funding pool
CURRENCY_CODE	Currency

Project Contracts - OKE_HOLD_STATUSES_B	Stores information about hold statuses
Column Name	Descritpion
HOLD_STATUS_CODE	Hold Status Code
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
CREATION_DATE	Standard Who column
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
WF_ITEM_TYPE	Workflow item type for contract hold status change
WF_PROCESS	Workflow process for contract hold status change
START_DATE_ACTIVE	Date this hold status becomes active
END_DATE_ACTIVE	Date this hold status becomes inactive

Project Contracts - OKE_HOLD_STATUSES_TL	Contract hold status multi-lingual information
Column Name	Descritpion
HOLD_STATUS_CODE	Hold Status Code
DESCRIPTION	Description of hold status
LANGUAGE	Language code of current data
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SOURCE_LANG	Source language code of current data
HOLD_STATUS_NAME	Displayed name for hold status

Project Contracts - OKE_K_HOLDS	Contract hold application and removal information
Column Name	Descritpion
HOLD_ID	System generated unique identifier for contract hold
DELIVERABLE_ID	Contract deliverable unique identifier
HOLD_TYPE_CODE	Internal code for contract hold type
HOLD_REASON_CODE	Reason code for contract hold
HOLD_STATUS_CODE	Hold Status Code
HOLD_COMMENT	Comment for contract hold
APPLY_DATE	Date the hold is applied
SCHEDULE_REMOVE_DATE	Date the hold is scheduled to be removed
REMOVE_DATE	Date the hold is removed
REMOVE_REASON_CODE	Reason code for hold removal
CREATION_DATE	Standard Who column
REMOVE_COMMENT	Comment for hold removal
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
CREATED_BY	Standard Who column
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
WF_ITEM_TYPE	Workflow item type for contract hold status change
WF_PROCESS	Workflow process for contract hold status change
WF_ITEM_KEY	Workflow item key for contract hold status change
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
K_HEADER_ID	Contract document unique identifier
K_LINE_ID	Contract document line item unique identifier

Project Contracts - OKE_K_FIFO_LOGS	User Contract Document Access FIFO Log
Column Name	Descritpion
USER_LOG_ID	Recent document list unique identifier
OBJECT_NAME	Object name identifying the document list
K_HEADER_ID	Contract document unique identifier
SEQUENCE	Recent document sequence
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Project Contracts - OKE_K_FORM_HEADERS	Print form header information
Column Name	Descritpion
FORM_HEADER_ID	System generated unique identifier for print form header
STATUS_CODE	Print form status
TEXT01	Generic print form textual data column
TEXT02	Generic print form textual data column
TEXT03	Generic print form textual data column
TEXT04	Generic print form textual data column
TEXT05	Generic print form textual data column
TEXT06	Generic print form textual data column
TEXT07	Generic print form textual data column
TEXT08	Generic print form textual data column
TEXT09	Generic print form textual data column
K_HEADER_ID	Contract document unique identifier
TEXT10	Generic print form textual data column
TEXT11	Generic print form textual data column
TEXT12	Generic print form textual data column
TEXT13	Generic print form textual data column
TEXT14	Generic print form textual data column
TEXT15	Generic print form textual data column
TEXT16	Generic print form textual data column
TEXT17	Generic print form textual data column
TEXT18	Generic print form textual data column
TEXT19	Generic print form textual data column
K_LINE_ID	Contract document line item unique identifier
TEXT20	Generic print form textual data column
TEXT21	Generic print form textual data column
TEXT22	Generic print form textual data column
TEXT23	Generic print form textual data column
TEXT24	Generic print form textual data column
TEXT25	Generic print form textual data column
TEXT26	Generic print form textual data column
TEXT27	Generic print form textual data column
TEXT28	Generic print form textual data column
TEXT29	Generic print form textual data column
DELIVERABLE_ID	Contract deliverable unique identifier
TEXT30	Generic print form textual data column
TEXT31	Generic print form textual data column
TEXT32	Generic print form textual data column
TEXT33	Generic print form textual data column
TEXT34	Generic print form textual data column
TEXT35	Generic print form textual data column
TEXT36	Generic print form textual data column
TEXT37	Generic print form textual data column
TEXT38	Generic print form textual data column
TEXT39	Generic print form textual data column
REFERENCE1	Generic print form reference column
TEXT40	Generic print form textual data column
TEXT41	Generic print form textual data column
TEXT42	Generic print form textual data column
TEXT43	Generic print form textual data column
TEXT44	Generic print form textual data column
TEXT45	Generic print form textual data column
TEXT46	Generic print form textual data column
TEXT47	Generic print form textual data column
TEXT48	Generic print form textual data column
TEXT49	Generic print form textual data column
REFERENCE2	Generic print form reference column
TEXT50	Generic print form textual data column
NUMBER01	Generic print form number data column
NUMBER02	Generic print form number data column
NUMBER03	Generic print form number data column
NUMBER04	Generic print form number data column
NUMBER05	Generic print form number data column
NUMBER06	Generic print form number data column
NUMBER07	Generic print form number data column
NUMBER08	Generic print form number data column
NUMBER09	Generic print form number data column
REFERENCE3	Generic print form reference column
NUMBER10	Generic print form number data column
NUMBER11	Generic print form number data column
NUMBER12	Generic print form number data column
NUMBER13	Generic print form number data column
NUMBER14	Generic print form number data column
NUMBER15	Generic print form number data column
NUMBER16	Generic print form number data column
NUMBER17	Generic print form number data column
NUMBER18	Generic print form number data column
NUMBER19	Generic print form number data column
REFERENCE4	Generic print form reference column
NUMBER20	Generic print form number data column
NUMBER21	Generic print form number data column
NUMBER22	Generic print form number data column
NUMBER23	Generic print form number data column
NUMBER24	Generic print form number data column
NUMBER25	Generic print form number data column
NUMBER26	Generic print form number data column
NUMBER27	Generic print form number data column
NUMBER28	Generic print form number data column
NUMBER29	Generic print form number data column
NUMBER30	Generic print form number data column
NUMBER31	Generic print form number data column
NUMBER32	Generic print form number data column
NUMBER33	Generic print form number data column
NUMBER34	Generic print form number data column
NUMBER35	Generic print form number data column
NUMBER36	Generic print form number data column
NUMBER37	Generic print form number data column
NUMBER38	Generic print form number data column
NUMBER39	Generic print form number data column
REFERENCE5	Generic print form reference column
NUMBER40	Generic print form number data column
NUMBER41	Generic print form number data column
NUMBER42	Generic print form number data column
NUMBER43	Generic print form number data column
NUMBER44	Generic print form number data column
NUMBER45	Generic print form number data column
NUMBER46	Generic print form number data column
NUMBER47	Generic print form number data column
NUMBER48	Generic print form number data column
NUMBER49	Generic print form number data column
CREATION_DATE	Standard Who column
NUMBER50	Generic print form number data column
DATE01	Generic print form date data column
DATE02	Generic print form date data column
DATE03	Generic print form date data column
DATE04	Generic print form date data column
DATE05	Generic print form date data column
DATE06	Generic print form date data column
DATE07	Generic print form date data column
DATE08	Generic print form date data column
DATE09	Generic print form date data column
DATE10	Generic print form date data column
DATE11	Generic print form date data column
DATE12	Generic print form date data column
DATE13	Generic print form date data column
DATE14	Generic print form date data column
DATE15	Generic print form date data column
DATE16	Generic print form date data column
DATE17	Generic print form date data column
DATE18	Generic print form date data column
DATE19	Generic print form date data column
DATE20	Generic print form date data column
DATE21	Generic print form date data column
DATE22	Generic print form date data column
DATE23	Generic print form date data column
DATE24	Generic print form date data column
DATE25	Generic print form date data column
DATE26	Generic print form date data column
DATE27	Generic print form date data column
DATE28	Generic print form date data column
DATE29	Generic print form date data column
DATE30	Generic print form date data column
DATE31	Generic print form date data column
DATE32	Generic print form date data column
DATE33	Generic print form date data column
DATE34	Generic print form date data column
DATE35	Generic print form date data column
DATE36	Generic print form date data column
DATE37	Generic print form date data column
DATE38	Generic print form date data column
DATE39	Generic print form date data column
DATE40	Generic print form date data column
DATE41	Generic print form date data column
DATE42	Generic print form date data column
DATE43	Generic print form date data column
DATE44	Generic print form date data column
DATE45	Generic print form date data column
DATE46	Generic print form date data column
DATE47	Generic print form date data column
DATE48	Generic print form date data column
DATE49	Generic print form date data column
DATE50	Generic print form date data column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PRINT_FORM_CODE	Print form code
FORM_HEADER_NUMBER	Print form header number
FORM_DATE	Print form date

Project Contracts - OKE_K_FORM_LINES	Print form line information
Column Name	Descritpion
FORM_HEADER_ID	System generated unique identifier for print form header
DELIVERABLE_ID	Contract deliverable unique identifier
TEXT01	Generic print form textual data column
TEXT02	Generic print form textual data column
TEXT03	Generic print form textual data column
TEXT04	Generic print form textual data column
TEXT05	Generic print form textual data column
TEXT06	Generic print form textual data column
TEXT07	Generic print form textual data column
TEXT08	Generic print form textual data column
TEXT09	Generic print form textual data column
REFERENCE1	Generic print form reference column
TEXT10	Generic print form textual data column
TEXT11	Generic print form textual data column
TEXT12	Generic print form textual data column
TEXT13	Generic print form textual data column
TEXT14	Generic print form textual data column
TEXT15	Generic print form textual data column
TEXT16	Generic print form textual data column
TEXT17	Generic print form textual data column
TEXT18	Generic print form textual data column
TEXT19	Generic print form textual data column
REFERENCE2	Generic print form reference column
TEXT20	Generic print form textual data column
TEXT21	Generic print form textual data column
TEXT22	Generic print form textual data column
TEXT23	Generic print form textual data column
TEXT24	Generic print form textual data column
TEXT25	Generic print form textual data column
TEXT26	Generic print form textual data column
TEXT27	Generic print form textual data column
TEXT28	Generic print form textual data column
TEXT29	Generic print form textual data column
REFERENCE3	Generic print form reference column
TEXT30	Generic print form textual data column
TEXT31	Generic print form textual data column
TEXT32	Generic print form textual data column
TEXT33	Generic print form textual data column
TEXT34	Generic print form textual data column
TEXT35	Generic print form textual data column
TEXT36	Generic print form textual data column
TEXT37	Generic print form textual data column
TEXT38	Generic print form textual data column
TEXT39	Generic print form textual data column
REFERENCE4	Generic print form reference column
TEXT40	Generic print form textual data column
TEXT41	Generic print form textual data column
TEXT42	Generic print form textual data column
TEXT43	Generic print form textual data column
TEXT44	Generic print form textual data column
TEXT45	Generic print form textual data column
TEXT46	Generic print form textual data column
TEXT47	Generic print form textual data column
TEXT48	Generic print form textual data column
TEXT49	Generic print form textual data column
REFERENCE5	Generic print form reference column
TEXT50	Generic print form textual data column
NUMBER01	Generic print form number data column
NUMBER02	Generic print form number data column
NUMBER03	Generic print form number data column
NUMBER04	Generic print form number data column
NUMBER05	Generic print form number data column
NUMBER06	Generic print form number data column
NUMBER07	Generic print form number data column
NUMBER08	Generic print form number data column
NUMBER09	Generic print form number data column
NUMBER10	Generic print form number data column
NUMBER11	Generic print form number data column
NUMBER12	Generic print form number data column
NUMBER13	Generic print form number data column
NUMBER14	Generic print form number data column
NUMBER15	Generic print form number data column
NUMBER16	Generic print form number data column
NUMBER17	Generic print form number data column
NUMBER18	Generic print form number data column
NUMBER19	Generic print form number data column
NUMBER20	Generic print form number data column
NUMBER21	Generic print form number data column
NUMBER22	Generic print form number data column
NUMBER23	Generic print form number data column
NUMBER24	Generic print form number data column
NUMBER25	Generic print form number data column
NUMBER26	Generic print form number data column
NUMBER27	Generic print form number data column
NUMBER28	Generic print form number data column
NUMBER29	Generic print form number data column
NUMBER30	Generic print form number data column
NUMBER31	Generic print form number data column
NUMBER32	Generic print form number data column
NUMBER33	Generic print form number data column
NUMBER34	Generic print form number data column
NUMBER35	Generic print form number data column
NUMBER36	Generic print form number data column
NUMBER37	Generic print form number data column
NUMBER38	Generic print form number data column
NUMBER39	Generic print form number data column
NUMBER40	Generic print form number data column
NUMBER41	Generic print form number data column
NUMBER42	Generic print form number data column
NUMBER43	Generic print form number data column
NUMBER44	Generic print form number data column
NUMBER45	Generic print form number data column
NUMBER46	Generic print form number data column
NUMBER47	Generic print form number data column
NUMBER48	Generic print form number data column
NUMBER49	Generic print form number data column
CREATION_DATE	Standard Who column
NUMBER50	Generic print form number data column
DATE01	Generic print form date data column
DATE02	Generic print form date data column
DATE03	Generic print form date data column
DATE04	Generic print form date data column
DATE05	Generic print form date data column
DATE06	Generic print form date data column
DATE07	Generic print form date data column
DATE08	Generic print form date data column
DATE09	Generic print form date data column
DATE10	Generic print form date data column
DATE11	Generic print form date data column
DATE12	Generic print form date data column
DATE13	Generic print form date data column
DATE14	Generic print form date data column
DATE15	Generic print form date data column
DATE16	Generic print form date data column
DATE17	Generic print form date data column
DATE18	Generic print form date data column
DATE19	Generic print form date data column
DATE20	Generic print form date data column
DATE21	Generic print form date data column
DATE22	Generic print form date data column
DATE23	Generic print form date data column
DATE24	Generic print form date data column
DATE25	Generic print form date data column
DATE26	Generic print form date data column
DATE27	Generic print form date data column
DATE28	Generic print form date data column
DATE29	Generic print form date data column
DATE30	Generic print form date data column
DATE31	Generic print form date data column
DATE32	Generic print form date data column
DATE33	Generic print form date data column
DATE34	Generic print form date data column
DATE35	Generic print form date data column
DATE36	Generic print form date data column
DATE37	Generic print form date data column
DATE38	Generic print form date data column
DATE39	Generic print form date data column
DATE40	Generic print form date data column
DATE41	Generic print form date data column
DATE42	Generic print form date data column
DATE43	Generic print form date data column
DATE44	Generic print form date data column
DATE45	Generic print form date data column
DATE46	Generic print form date data column
DATE47	Generic print form date data column
DATE48	Generic print form date data column
DATE49	Generic print form date data column
DATE50	Generic print form date data column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FORM_LINE_NUMBER	Print form line number
K_HEADER_ID	Contract document unique identifier
K_LINE_ID	Contract document line item unique identifier

Project Contracts - OKE_K_PRINT_FORMS	Contract Print Forms
Column Name	Descritpion
K_HEADER_ID	Contract document unique identifier
CUSTOMER_FURNISHED_FLAG	Flag indicating whether the form is funished by the customer
COMPLETED_FLAG	Completed indicator
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
K_LINE_ID	Contract document line item unique identifier
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
PRINT_FORM_CODE	Print form code
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUIRED_FLAG	Flag indicating whether the form is required by the contract, line or deliverable

Project Contracts - OKE_PRINT_FORMS_B	Stores information about print forms
Column Name	Descritpion
PRINT_FORM_CODE	Print form code
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
PRINT_FORM_TYPE_CODE	Print form type code
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
START_DATE_ACTIVE	Date this print form becomes active
END_DATE_ACTIVE	Date this print form becomes inactive
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Project Contracts - OKE_PRINT_FORMS_TL	Print form multi-lingual information
Column Name	Descritpion
PRINT_FORM_CODE	Print form code
DESCRIPTION	Description of print form
LANGUAGE	Language code of current data
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SOURCE_LANG	Source language code of current data
PRINT_FORM_NAME	Print form name

Project Contracts - OKE_COMPILED_ACCESS_RULES	Stores compiled access rules information
Column Name	Descritpion
ROLE_ID	Contract role unique identifier
LAST_UPDATE_LOGIN	Standard Who column
ACCESS_LEVEL	Access level
ACCESS_RULE_ID	Contract attribute access rule unique identifier
FORM_ITEM_FLAG	Flag indicating whether attribute is a form item
SECURED_OBJECT_NAME	Identifier for the object against which this access rule is defined
ATTRIBUTE_GROUP_TYPE	Attribute group type, either system or user
ATTRIBUTE_GROUP_CODE	Attribute group code
ATTRIBUTE_CODE	Attribute code
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Project Contracts - OKE_K_ACCESS_RULES	Stores access rules for contract roles
Column Name	Descritpion
ACCESS_RULE_ID	Contract attribute access rule unique identifier
ATTRIBUTE_GROUP_TYPE	Attribute group type, either system or user
ATTRIBUTE_GROUP_CODE	Attribute group code
ATTRIBUTE_CODE	Attribute code
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ROLE_ID	Contract role unique identifier
ACCESS_LEVEL	Access level
SECURED_OBJECT_NAME	Identifier for the object against which this access rule is defined

Project Contracts - OKE_BILLING_METHODS_B	Stores information about billing methods
Column Name	Descritpion
BILLING_METHOD_CODE	Billing method code
START_DATE_ACTIVE	Date this billing method becomes active
END_DATE_ACTIVE	Date this billing method becomes inactive
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
CREATION_DATE	Standard Who column
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
INCLUDE_PRICE_FLAG	Oracle Internal use only - reserved for future use
INCLUDE_COST_FLAG	Oracle Internal use only - reserved for future use
INCLUDE_FEE_FLAG	Oracle Internal use only - reserved for future use

Project Contracts - OKE_BILLING_METHODS_TL	Contract billing method multi-lingual information
Column Name	Descritpion
BILLING_METHOD_CODE	Billing method code
DESCRIPTION	Description of billing method
LANGUAGE	Language code of current data
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SOURCE_LANG	Source language code of current data
BILLING_METHOD_NAME	Billing method name

Project Contracts - OKE_K_TYPES_B	Stores information about contract document types
Column Name	Descritpion
K_TYPE_CODE	Internal identifier for contract document type
END_DATE_ACTIVE	Date this contract document type becomes inactive
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
CREATION_DATE	Standard Who column
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
TYPE_CLASS_CODE	Contract document type class code
INTENT	Contract intent
APPROVAL_PATH_ID	Unique identifier of approval hierarchy associate to this contract document type
START_DATE_ACTIVE	Date this contract document type becomes active

Project Contracts - OKE_K_TYPES_TL	Contract document types multi-lingual information
Column Name	Descritpion
K_TYPE_CODE	Internal identifier for contract document type
SOURCE_LANG	Source language code of current data
LANGUAGE	Language code of current data
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
K_TYPE_NAME	Displayed name for contract document type
DESCRIPTION	Description of contract document type

Project Contracts - OKE_NUMBER_OPTIONS	stores contract document type numbering options
Column Name	Descritpion
K_TYPE_CODE	Internal identifier for contract document type
NEXT_CONTRACT_NUM	Next number for this contract document type and intent
CONTRACT_NUM_INCREMENT	Contract document number numeric increment for automatic numbering
CONTRACT_NUM_WIDTH	Contract document number numeric width for automatic numbering
CHGREQ_NUM_MODE	Contract change request numbering mode
MANUAL_CHGREQ_NUM_TYPE	Contract change request number type for manual entry
CHGREQ_NUM_START_NUMBER	Contract change request starting number for automatic numbering
CHGREQ_NUM_INCREMENT	Contract change request number numeric increment for automatic numbering
CHGREQ_NUM_WIDTH	Contract change request number numeric width for automatic numbering
LINE_NUM_START_NUMBER	Line number starting number for automatic numbering
LINE_NUM_INCREMENT	Line number numeric increment for automatic numbering
BUY_OR_SELL	Contract intent
LINE_NUM_WIDTH	Line number numeric width for automatic numbering
SUBLINE_NUM_START_NUMBER	Subline number starting number for automatic numbering
SUBLINE_NUM_INCREMENT	Subline number numeric increment for automatic numbering
SUBLINE_NUM_WIDTH	Subline number numeric width for automatic numbering
DELV_NUM_START_NUMBER	Deliverable number starting number for automatic numbering
DELV_NUM_INCREMENT	Deliverable number numeric increment for automatic numbering
DELV_NUM_WIDTH	Deliverable number numeric width for automatic numbering
CREATION_DATE	Standard Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
CREATED_BY	Standard Who column
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CONTRACT_NUM_MODE	Contract document numbering mode
MANUAL_CONTRACT_NUM_TYPE	Contract document number type for manual entry

Project Contracts - OKE_PRIORITY_CODES_B	Stores information about priority codes
Column Name	Descritpion
PRIORITY_CODE	Priority rating code
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
START_DATE_ACTIVE	Date this priority code becomes active
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
END_DATE_ACTIVE	Date this priority code becomes inactive
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PRIORITY_TYPE_CODE	Internal code of priority rating type

Project Contracts - OKE_PRIORITY_CODES_TL	Contract priority rating multi-lingual information
Column Name	Descritpion
PRIORITY_CODE	Priority rating code
DESCRIPTION	Description of priority code
LANGUAGE	Language code of current data
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SOURCE_LANG	Source language code of current data
PRIORITY_NAME	Displayed name for priority rating

Project Contracts - OKE_TERMS_B	Stores information about contract terms
Column Name	Descritpion
TERM_CODE	Internal identifier for terms
LOOKUP_TYPE	Lookup type representing the list of valid term values
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
TERM_TYPE_CODE	Internal identifier for terms and conditions type
USER_DEFINED_FLAG	Flag indicating whether the term is user-defined
VIEW_APPLICATION_ID	Application identifier of lookup representing the list of valid term values

Project Contracts - OKE_TERMS_TL	Contract terms and conditions multi-lingual information
Column Name	Descritpion
TERM_CODE	Internal identifier for terms
SOURCE_LANG	Source language code of current data
LANGUAGE	Language code of current data
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
TERM_NAME	Name of terms
DESCRIPTION	Description of term

Project Contracts - OKE_K_BILLING_EVENTS	Deliverable-based billing events
Column Name	Descritpion
BILLING_EVENT_ID	Contract billing event unique identifier
BILL_EVENT_DATE	Billing event date
BILL_EVENT_TYPE	Billing event type
PA_EVENT_ID	Unique identifier of project billing event that corresponds to this contract billing event
BILL_ITEM_ID	Item unique identifier related to this billing event
BILL_LINE_ID	Contract line unique identifer related to billing event
BILL_CHG_REQ_ID	Change request unique identifier related to billing event
BILL_PROJECT_ID	Bill against project
BILL_TASK_ID	Bill against task
BILL_ORGANIZATION_ID	Billing organization unique identifier
BILL_FUND_REF1	Funding reference related to billing event
CREATION_DATE	Standard Who column
BILL_FUND_REF2	Funding reference related to billing event
BILL_FUND_REF3	Funding reference related to billing event
BILL_BILL_OF_LADING	Bill of lading number related to billing event
BILL_SERIAL_NUM	Serial numbers related to billing event
BILL_CURRENCY_CODE	Billing currency
BILL_RATE_TYPE	Exchange rate type for conversion to functional currency
BILL_RATE_DATE	Date of Exchange rate date to functional currency
BILL_EXCHANGE_RATE	Currency exchange rate to functional currency
BILL_DESCRIPTION	Billing description
BILL_QUANTITY	Billing quantity
CREATED_BY	Standard Who column
BILL_UNIT_PRICE	Billing unit price
REVENUE_AMOUNT	Amount of revenue to accrue for the billing event upon event completion
ATTRIBUTE_CATEGORY	Descriptive flexfield attribute context
ATTRIBUTE1	Descriptive flexfield attribute
ATTRIBUTE2	Descriptive flexfield attribute
ATTRIBUTE3	Descriptive flexfield attribute
ATTRIBUTE4	Descriptive flexfield attribute
ATTRIBUTE5	Descriptive flexfield attribute
ATTRIBUTE6	Descriptive flexfield attribute
ATTRIBUTE7	Descriptive flexfield attribute
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE8	Descriptive flexfield attribute
ATTRIBUTE9	Descriptive flexfield attribute
ATTRIBUTE10	Descriptive flexfield attribute
ATTRIBUTE11	Descriptive flexfield attribute
ATTRIBUTE12	Descriptive flexfield attribute
ATTRIBUTE13	Descriptive flexfield attribute
ATTRIBUTE14	Descriptive flexfield attribute
ATTRIBUTE15	Descriptive flexfield attribute
INITIATED_FLAG	Flag to inidicate if the event has been initiated
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
K_HEADER_ID	Contract document unique identifier
K_LINE_ID	Contract document line item unique identifier
DELIVERABLE_ID	Contract deliverable unique identifier

Project Contracts - OKE_CHG_STS_TYPE_FLOWS	Not in use
Column Name	Descritpion
CHG_STATUS_TYPE_CODE	Internal code for contract change request status type
TO_CHG_STATUS_TYPE_CODE
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CREATE_NEW_VERSION_FLAG

Project Contracts - OKE_APPROVAL_PATHS	Contract document approval hierarchy
Column Name	Descritpion
APPROVAL_PATH_ID	Approval hiearchy unique identifier
SIGNATURE_REQUIRED_FLAG	Flag indicating whether signature is required upon contract approval
SIGNATORY_ROLE_ID	Contract role from whom a signature is required upon contract approval
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
RECORD_VERSION_NUMBER	Sequence number for locking
START_DATE_ACTIVE	Date when this approval hierarchy becomes valid
END_DATE_ACTIVE	Date after which this approval hierarchy becomes invalid

Project Contracts - OKE_APPROVAL_PATHS_TL	Language specific information for contract document approval hierarchy
Column Name	Descritpion
APPROVAL_PATH_ID	Approval hiearchy unique identifier
SOURCE_LANG	Source language
LANGUAGE	Language
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
NAME	Name of the approval hierarchy
DESCRIPTION	User-entered description of the approval hierarchy

Project Contracts - OKE_APPROVAL_HISTORY	Contract document approval history
Column Name	Descritpion
K_HEADER_ID	Contract document unique identifier
APPROVAL_SEQUENCE	Numeric sequence in the approval hierarchy
ACTION_CODE	Internal code for the specific action taken that was captured
ACTION_DATE	Date of action
PERFORMER	Performer of action
APPROVER_ROLE_ID	Approver contract role unique identifier
NOTE	Approval note
CHG_REQUEST_ID	Contract change request unique identifier - not currently used
ACTION_SEQUENCE	Numeric value denoting chronological sequence of action
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
APPROVAL_PATH_ID	Approval hiearchy unique identifier

Project Contracts - OKE_APPROVAL_STEPS	Contract document approval hierarchy steps
Column Name	Descritpion
APPROVAL_PATH_ID	Approval hiearchy unique identifier
REQUIRED_FLAG	Not currently used
APPROVAL_SEQUENCE	Sequence number of the current step in the approval hierarchy
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
RECORD_VERSION_NUMBER	Sequence number for locking
APPROVER_ROLE_ID	Contract role from which approval is needed in this step

Project Contracts - OKE_VERSION_COMPARE_RESULTS	This table stores the version comparison results.
Column Name	Descritpion
VERSION1	First version number of the contract
VERSION2	Second version number of contract
OBJECT_TYPE	Type of object
OBJECT_NAME	Display name of object
OBJECT_ID	ID of the object
SEQUENCE	Sequence number of display
PROMPT	The prompt to display
V1DATA	Data in the first version
K_HEADER_ID	ID of the contract compared
V2DATA	Data in the second version
CURRENT_FLAG	'Y' if version comparison involves a current version and not in history.
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Project Contracts - OKE_ROLE_FUNCTIONS	Allowable functions by role
Column Name	Descritpion
ROLE_ID	Contract role unique identifier
FUNCTION_ID	Function unique identifier
CREATION_DATE	Standard Who columns
CREATED_BY	Standard Who columns
LAST_UPDATE_DATE	Standard Who columns
LAST_UPDATED_BY	Standard Who columns
LAST_UPDATE_LOGIN	Standard Who columns