PAY_TYPE_LOC_TXBL |
Default Table Name | PAY_TYPE_LOC_TXBL |
Definition |
PAY_TYPE_LOC_TXBL Columns |
ColumnName | Domain | Datatype | NULL | Definition |
PAY_TYPE![]() |
VARCHAR2(3) | NO | ||
LOCAL_CD![]() |
VARCHAR2(6) | NO | ||
S_LOC_INCM_TXBL_CD | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
PAY_TYPE_LOC_TXBL Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0549 | PrimaryKey | PAY_TYPE, LOCAL_CD |
PAY_TYPE_LOC_TXBL Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
LOCALITY | Identifying | One To Zero or More | F08570 | LOCAL_CD | NO | NO | NO | ||
PAY_TYPE_TXBL | Identifying | One To Zero or More | F08571 | PAY_TYPE | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |