TVL_SETTINGS |
Default Table Name | TVL_SETTINGS |
Definition |
TVL_SETTINGS Columns |
ColumnName | Domain | Datatype | NULL | Definition |
TRIP_NO_BY_COMP_FL | VARCHAR2(1) | NO | ||
LAST_ADV_ID | VARCHAR2(10) | NO | ||
LAST_TRIP_ID | VARCHAR2(10) | NO | ||
LAST_EXP_RPT_ID | VARCHAR2(10) | NO | ||
ADV_CEIL_AMT | NUMBER(14, 2) | NO | ||
OVR_CEIL_AS_RCV_FL | VARCHAR2(1) | NO | ||
PARTL_PER_DIEM_FL | VARCHAR2(1) | NO | ||
BATCH_CNTL_FL | VARCHAR2(1) | NO | ||
S_OVER_CEIL_ADV_CD | VARCHAR2(1) | NO | ||
ADV_APPRVL_REQD_FL | VARCHAR2(1) | NO | ||
S_ADV_APPR_MTHD_CD | VARCHAR2(1) | NO | ||
ADV_APPRVL_LMT_AMT | NUMBER(14, 2) | NO | ||
EXP_APPRVL_REQD_FL | VARCHAR2(1) | NO | ||
S_EXP_APPR_MTHD_CD | VARCHAR2(1) | NO | ||
EXP_APPRVL_LMT_AMT | NUMBER(14, 2) | NO | ||
AGE1_HDG_LBL | VARCHAR2(10) | NO | ||
AGE2_HDG_LBL | VARCHAR2(10) | NO | ||
AGE3_HDG_LBL | VARCHAR2(10) | NO | ||
AGE4_HDG_LBL | VARCHAR2(10) | NO | ||
AGE1_DAYS_TO_NO | NUMBER(5, 0) | NO | ||
AGE2_DAYS_TO_NO | NUMBER(5, 0) | NO | ||
AGE3_DAYS_TO_NO | NUMBER(5, 0) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
RECOM_MATCH_NO | NUMBER(10, 0) | NO | ||
S_AUTO_APPL_ADV_CD | VARCHAR2(1) | NO | ||
TRP_SCH_CMT_TRK | VARCHAR2(1) | NO | ||
CR_ADV_TRIP | VARCHAR2(1) | NO | ||
ADV_RT | NUMBER(5, 4) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
TVL_SETTINGS Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6621 | PrimaryKey | COMPANY_ID |
TVL_SETTINGS 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 |