DESCRIPTION | CHAR VARYING (2000) | , |
DOCUMENT_DATE | DATE | , |
DURATION | FLOAT | , |
DURATION_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM), |
EFFECTIVE_DATE | TIMESTAMP | , |
EFFECTIVE_DATE_CD | CHAR (1) | , |
EFFECTIVE_DATE_DY | INTEGER | , |
EFFECTIVE_DATE_HR | INTEGER | , |
EFFECTIVE_DATE_MT | INTEGER | , |
EFFECTIVE_DATE_OF | FLOAT | , |
EFFECTIVE_DATE_ST | FLOAT | , |
EFFECTIVE_DATE_YP | INTEGER | , |
EFFECTIVE_DATE_YR | FLOAT | , |
ENTITY_TYPE_NM | CHAR VARYING (30) | NOT NULL CHECK (ENTITY_TYPE_NM IN ('CONTRACT_AMENDMENT', 'CO_AND_O_AGREEMENT', 'JOINT_VENTURE_AGREEMENT', 'LICENSE_AGREEMENT', 'MARKETING_AGREEMENT', 'SERVICE_AGREEMENT', 'TITLE_AGREEMENT', 'UNITIZATION_AGREEMENT', 'WELL_OPERATING_AGREEMENT')), |
EXECUTION_DATE | TIMESTAMP | , |
EXECUTION_DATE_CD | CHAR (1) | , |
EXECUTION_DATE_DY | INTEGER | , |
EXECUTION_DATE_HR | INTEGER | , |
EXECUTION_DATE_MT | INTEGER | , |
EXECUTION_DATE_OF | FLOAT | , |
EXECUTION_DATE_ST | FLOAT | , |
EXECUTION_DATE_YP | INTEGER | , |
EXECUTION_DATE_YR | FLOAT | , |
EXPIRY_DATE | TIMESTAMP | , |
EXPIRY_DATE_CD | CHAR (1) | , |
EXPIRY_DATE_DY | INTEGER | , |
EXPIRY_DATE_HR | INTEGER | , |
EXPIRY_DATE_MT | INTEGER | , |
EXPIRY_DATE_OF | FLOAT | , |
EXPIRY_DATE_ST | FLOAT | , |
EXPIRY_DATE_YP | INTEGER | , |
EXPIRY_DATE_YR | FLOAT | , |
IDENTIFIER | CHAR VARYING (80) | NOT NULL, |
INSTANCE_CREATE_DATE | TIMESTAMP | , |
INSTANCE_CREATOR | CHAR VARYING (80) | , |
INSTANCE_S | CHAR VARYING (19) | NOT NULL PRIMARY KEY, |
KIND_S | CHAR VARYING (19) | REFERENCES DOCUMENT_SPECIFICATION_CLASS (INSTANCE_S), |
LAST_UPDATED | TIMESTAMP | , |
LAST_UPDATED_BY | CHAR VARYING (80) | , |
NAMING_SYSTEM | CHAR VARYING (80) | REFERENCES NAMING_SYSTEM (IDENTIFIER), |
ORIGINAL_EXPIRY_DATE | TIMESTAMP | , |
ORIGINAL_EXPIRY_DATE_CD | CHAR (1) | , |
ORIGINAL_EXPIRY_DATE_DY | INTEGER | , |
ORIGINAL_EXPIRY_DATE_HR | INTEGER | , |
ORIGINAL_EXPIRY_DATE_MT | INTEGER | , |
ORIGINAL_EXPIRY_DATE_OF | FLOAT | , |
ORIGINAL_EXPIRY_DATE_ST | FLOAT | , |
ORIGINAL_EXPIRY_DATE_YP | INTEGER | , |
ORIGINAL_EXPIRY_DATE_YR | FLOAT | , |
RECORDED_DATE | TIMESTAMP | , |
RECORDED_DATE_CD | CHAR (1) | , |
RECORDED_DATE_DY | INTEGER | , |
RECORDED_DATE_HR | INTEGER | , |
RECORDED_DATE_MT | INTEGER | , |
RECORDED_DATE_OF | FLOAT | , |
RECORDED_DATE_ST | FLOAT | , |
RECORDED_DATE_YP | INTEGER | , |
RECORDED_DATE_YR | FLOAT | , |
RECORDED_LINE | CHAR VARYING (40) | , |
RECORDED_PAGE | CHAR VARYING (40) | , |
RECORDED_VOLUME | CHAR VARYING (40) | , |
SOURCE | CHAR VARYING (80) | , |
TOTAL_COST | FLOAT | , |
TOTAL_COST_U | CHAR VARYING (15) | REFERENCES R_CURRENCY_UNIT (ACRONYM) |
)