DFLT_TMPEXPORTTS |
Default Table Name | DFLT_TMPEXPORTTS |
Definition |
DFLT_TMPEXPORTTS Columns |
ColumnName | Domain | Datatype | NULL | Definition |
TS_TYPE | VARCHAR2(30) | NO | ||
SUBC_EXPORT_FL | VARCHAR2(1) | NO | ||
CP_COMPANY_CD | VARCHAR2(10) | YES | ||
CP_COMPANY_NAME | VARCHAR2(30) | YES | ||
EXPORT_WORKSCHEDULES_FL | VARCHAR2(1) | NO | ||
SET_NEXT_PERIOD_CURRENT_FL | VARCHAR2(1) | NO | ||
EXPORT_TO_CP_FL | VARCHAR2(1) | NO | ||
LABOR_REPORT_FL | VARCHAR2(1) | NO | ||
PAYROLL_REPORT_FL | VARCHAR2(1) | NO | ||
INCLUDE_LABOR_DETAIL_RPT_FL | VARCHAR2(1) | NO | ||
INCLUDE_PAYROLL_DETAIL_RPT_FL | VARCHAR2(1) | NO | ||
AUTO_ADJ_HRLY_FL | VARCHAR2(1) | NO | ||
AUTO_ADJ_SAL_FL | VARCHAR2(1) | NO | ||
X_RLLUP_DT_FL | VARCHAR2(1) | NO | ||
X_RLLUP_TS_FL | VARCHAR2(1) | NO | ||
PRORATE_FL | VARCHAR2(1) | NO | ||
GEN_UNION_FR | VARCHAR2(1) | NO | ||
AUTO_ADJ_PCT_RT | NUMBER(10, 8) | YES | ||
ALL_GROUP_CLASS_FL | VARCHAR2(1) | NO |
DFLT_TMPEXPORTTS Primary and Unique Keys |
Key Name | Key Type | Keys |
DFLT_TMPEXPORTTS 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 |