X_Z_AOPUTLJE_ED3 |
Default Table Name | X_Z_AOPUTLJE_ED3 |
Definition |
X_Z_AOPUTLJE_ED3 Columns |
ColumnName | Domain | Datatype | NULL | Definition |
FISCAL_YEAR | VARCHAR2(6) | YES | ||
PERIOD | NUMBER(5, 0) | YES | ||
SUBPERIOD | NUMBER(5, 0) | YES | ||
JOURNAL_BATCH_ID | VARCHAR2(20) | YES | ||
ENTRY_USER_ID | VARCHAR2(20) | YES | ||
JOURNAL_ENTRY_NO | NUMBER(10, 0) | YES | ||
JOURNAL_ENTRY_DESC | VARCHAR2(30) | YES | ||
REVERSE_FLAG | VARCHAR2(1) | YES | ||
JOURNAL_TYPE | VARCHAR2(3) | YES | ||
JOURNAL_LINE_NO | NUMBER(10, 0) | YES | ||
JOURNAL_LINE_DESC | VARCHAR2(30) | YES | ||
ACCOUNT | VARCHAR2(15) | YES | ||
ACCOUNT_NAME | VARCHAR2(25) | YES | ||
ORGANIZATION | VARCHAR2(20) | YES | ||
ORGANIZATION_ABBRV | VARCHAR2(6) | YES | ||
ORGANIZATION_NAME | VARCHAR2(25) | YES | ||
PROJECT | VARCHAR2(30) | YES | ||
PROJECT_ABBRV | VARCHAR2(6) | YES | ||
PROJECT_NAME | VARCHAR2(25) | YES | ||
REFERENCE_1 | VARCHAR2(20) | YES | ||
REFERENCE_2 | VARCHAR2(20) | YES | ||
AMOUNT | NUMBER(17, 2) | YES | ||
NOTES | VARCHAR2(254) | YES | ||
EMPLOYEE_SEQUENCE | NUMBER(5, 0) | YES | ||
EMPL_LABOR_AMOUNT | NUMBER(17, 2) | YES | ||
EMPL_LABOR_HOURS | NUMBER(14, 2) | YES | ||
EMPL_GL_LAB_CAT | VARCHAR2(6) | YES | ||
EMPLOYEE_ID | VARCHAR2(12) | YES | ||
EMPL_BILL_LAB_CAT | VARCHAR2(6) | YES | ||
VEND_GL_LAB_CAT | VARCHAR2(6) | YES | ||
VEND_LABOR_HOURS | NUMBER(14, 2) | YES | ||
VEND_LABOR_AMOUNT | NUMBER(17, 2) | YES | ||
VENDOR | VARCHAR2(12) | YES | ||
VENDOR_SEQUENCE | NUMBER(5, 0) | YES | ||
VEND_BILL_LAB_CAT | VARCHAR2(6) | YES | ||
TRANSACTION_TYPE | VARCHAR2(3) | YES | ||
JE_HDR_KEY | NUMBER(10, 0) | YES | ||
JE_LN_KEY | NUMBER(10, 0) | YES | ||
PROJ_ACCT_ABBRV_CD | VARCHAR2(6) | YES | ||
UPDATE_OBD_FL | VARCHAR2(1) | YES | ||
OVR_BUD_FL | VARCHAR2(1) | YES | ||
VEND_EMPL_ID | VARCHAR2(12) | YES | ||
VEND_EMPL_NAME | VARCHAR2(25) | YES | ||
EMPL_EFFECT_BIL_DT | DATE | YES | ||
VEND_EFFECT_BIL_DT | DATE | YES | ||
APPRVD_FL | VARCHAR2(1) | YES |
X_Z_AOPUTLJE_ED3 Primary and Unique Keys |
Key Name | Key Type | Keys |
X_Z_AOPUTLJE_ED3 Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |