AP_SETTINGS |
Default Table Name | AP_SETTINGS |
Definition |
AP_SETTINGS Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CUR_CAL_YR_NO | NUMBER(5, 0) | NO | ||
AGE2_DAYS_TO_NO | NUMBER(5, 0) | NO | ||
AGE3_DAYS_TO_NO | NUMBER(5, 0) | NO | ||
AGE4_DAYS_TO_NO | NUMBER(5, 0) | NO | ||
AGE1_HDG_FLD | VARCHAR2(10) | NO | ||
AGE2_HDG_FLD | VARCHAR2(10) | NO | ||
AGE3_HDG_FLD | VARCHAR2(10) | NO | ||
AGE4_HDG_FLD | VARCHAR2(10) | NO | ||
AGE5_HDG_FLD | VARCHAR2(10) | NO | ||
CHK_LIMIT_FL | VARCHAR2(1) | NO | ||
CHK_LIMIT_AMT | NUMBER(14, 2) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
S_AP_CHK_FRMT_CD | VARCHAR2(1) | NO | ||
EFT_SECURE_FL | VARCHAR2(1) | YES | ||
CHK_SIG_LIMIT | NUMBER(14, 2) | YES | ||
PRIM_SIG_FL | VARCHAR2(1) | YES | ||
SECOND_SIG_FL | VARCHAR2(1) | YES | ||
SIG_REQD_MESSAGE | VARCHAR2(60) | YES | ||
ADDR_ORDER_CD | VARCHAR2(1) | NO | ||
SIG1_FILE_NAME | VARCHAR2(254) | YES | ||
SIG2_FILE_NAME | VARCHAR2(254) | YES | ||
LOGO_FILE_NAME | VARCHAR2(254) | YES | ||
VEND_INF_UPD_FL | VARCHAR2(1) | YES | ||
EFT_FILE_CREAT_FL | VARCHAR2(1) | YES | ||
VEND_UPD_PWD_NAME | VARCHAR2(6) | YES | ||
PRNT_CHKS_FL | VARCHAR2(1) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
VEND_APPRVL_FL | VARCHAR2(1) | NO | ||
DFLT_RPT_RES_CD | VARCHAR2(1) | YES | ||
AP_CHK_FRMT_P3_CD | VARCHAR2(1) | YES | ||
PRNT_ARIAL_FL | VARCHAR2(1) | YES | ||
ADDR_ELIM_CD | VARCHAR2(2) | YES | ||
DATE_FIELD_CD | VARCHAR2(10) | YES | ||
ARIAL_LINE_CD | VARCHAR2(1) | YES |
AP_SETTINGS Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0369 | PrimaryKey | COMPANY_ID |
AP_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 |