AR_SETTINGS |
Default Table Name | AR_SETTINGS |
Definition |
AR_SETTINGS Columns |
ColumnName | Domain | Datatype | NULL | Definition |
FIN_CHG_FL | VARCHAR2(1) | NO | ||
GRACE_DAYS_NO | NUMBER(5, 0) | NO | ||
MTH_FIN_RT | NUMBER(5, 4) | NO | ||
ANNL_FIN_RT | NUMBER(5, 4) | NO | ||
MIN_FIN_CHG_AMT | NUMBER(17, 2) | NO | ||
MIN_PYMT_PCT_RT | NUMBER(5, 4) | NO | ||
INTRST_FIN_CHG_FL | VARCHAR2(1) | 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 | ||
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_STMT_DESC | VARCHAR2(60) | NO | ||
AGE2_STMT_DESC | VARCHAR2(60) | NO | ||
AGE3_STMT_DESC | VARCHAR2(60) | NO | ||
AGE4_STMT_DESC | VARCHAR2(60) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
USER_DEF1_LBL | VARCHAR2(15) | YES | ||
USER_DEF2_LBL | VARCHAR2(15) | YES | ||
LAST_UNKNW_INVC_ID | VARCHAR2(15) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
AR_SETTINGS Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0406 | PrimaryKey | COMPANY_ID |
AR_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 |