Sales Organization

Entity Relationship Diagram

Tip:   

Right click the attachment to view Entity Relationship Diagram for Sales Organization in a new tab.

List of Objects

DB Object Name Object Business Name Object Description DB Attribute Name Attribute Business Name Ordinal Position Data Type Name Data Type Size Numeric Scale Is Identity Is Nullable Primary Key Mandatory
BUS_HRS_C Business Hours Business Hours BUS_HRS_SYS_KEY_C BUS HRS SYS KEY C 1 VARCHAR 20   NO NO TRUE TRUE
BUS_HRS_C Business Hours Business Hours BPA_SYS_KEY_C BPA SYS KEY C 2 VARCHAR 16777216   NO NO FALSE TRUE
BUS_HRS_C Business Hours Business Hours BP_SYS_KEY_C BP SYS KEY C 3 VARCHAR 16777216   NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours IS_ACTV_C IS ACTV C 4 VARCHAR 12   NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours DEF_BUS_HRS_C DEF BUS HRS C 5 VARCHAR 200   NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours BUS_HRS_NM_C BUS HRS NM C 6 VARCHAR 20   NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours MON_STRT_TM_C MON STRT TM C 7 TIMESTAMP_LTZ     NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours MON_END_TM_C MON END TM C 8 TIMESTAMP_LTZ     NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours TUE_STRT_TM_C TUE STRT TM C 9 TIMESTAMP_LTZ     NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours TUE_END_TM_C TUE END TM C 10 TIMESTAMP_LTZ     NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours WED_STRT_TM_C WED STRT TM C 11 TIMESTAMP_LTZ     NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours WED_END_TM_C WED END TM C 12 TIMESTAMP_LTZ     NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours THU_STRT_TM_C THU STRT TM C 13 TIMESTAMP_LTZ     NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours THU_END_TM_C THU END TM C 14 TIMESTAMP_LTZ     NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours FRI_STRT_TM_C FRI STRT TM C 15 TIMESTAMP_LTZ     NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours FRI_END_TM_C FRI END TM C 16 TIMESTAMP_LTZ     NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours SAT_STRT_TM_C SAT STRT TM C 17 TIMESTAMP_LTZ     NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours SAT_END_TM_C SAT END TM C 18 TIMESTAMP_LTZ     NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours SUN_STRT_TM_C SUN STRT TM C 19 TIMESTAMP_LTZ     NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours SUN_END_TM_C SUN END TM C 20 TIMESTAMP_LTZ     NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours TM_ZONE_SID_C TM ZONE SID C 21 VARCHAR 20   NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours SYS_CRT_BY_C SYS CRT BY C 22 VARCHAR 255   NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours SYS_CRT_DTT_C SYS CRT DTT C 23 DATE     NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours SYS_LAST_UPD_BY_C SYS LAST UPD BY C 24 VARCHAR 255   NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 25 DATE     NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours SYS_EFF_DTT_C SYS EFF DTT C 26 DATE     NO YES FALSE FALSE
BUS_HRS_C Business Hours Business Hours SYS_END_DTT_C SYS END DTT C 27 DATE     NO YES FALSE FALSE
EMP_SORG_ASSGN_C Employee Sales Org Assignment Employee Sales Org Assignment EMP_ASSGN_SYS_KEY_C EMP ASSGN SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
EMP_SORG_ASSGN_C Employee Sales Org Assignment Employee Sales Org Assignment EMP_ASSGN_BUS_KEY_C EMP ASSGN BUS KEY C 2 VARCHAR 16777216   NO NO FALSE TRUE
EMP_SORG_ASSGN_C Employee Sales Org Assignment Employee Sales Org Assignment EMP_SYS_KEY_C EMP SYS KEY C 3 VARCHAR 16777216   NO NO FALSE TRUE
EMP_SORG_ASSGN_C Employee Sales Org Assignment Employee Sales Org Assignment SORG_SYS_KEY_C SORG SYS KEY C 4 VARCHAR 16777216   NO NO FALSE TRUE
EMP_SORG_ASSGN_C Employee Sales Org Assignment Employee Sales Org Assignment PSET_SYS_KEY_C PSET SYS KEY C 5 VARCHAR 16777216   NO NO FALSE TRUE
EMP_SORG_ASSGN_C Employee Sales Org Assignment Employee Sales Org Assignment BP_SYS_KEY_C BP SYS KEY C 6 VARCHAR 16777216   NO YES FALSE FALSE
EMP_SORG_ASSGN_C Employee Sales Org Assignment Employee Sales Org Assignment EMP_ASSGN_TYPE_CD_C EMP ASSGN TYPE CD C 7 VARCHAR 20   NO YES FALSE FALSE
EMP_SORG_ASSGN_C Employee Sales Org Assignment Employee Sales Org Assignment EMP_ASSNG_SUB_TYPE_CD_C EMP ASSNG SUB TYPE CD C 8 VARCHAR 20   NO YES FALSE FALSE
EMP_SORG_ASSGN_C Employee Sales Org Assignment Employee Sales Org Assignment ACTV_IND_C ACTV IND C 9 VARCHAR 1   NO YES FALSE FALSE
EMP_SORG_ASSGN_C Employee Sales Org Assignment Employee Sales Org Assignment SYS_CRT_DTT_C SYS CRT DTT C 10 DATE     NO YES FALSE FALSE
EMP_SORG_ASSGN_C Employee Sales Org Assignment Employee Sales Org Assignment SYS_CRT_BY_C SYS CRT BY C 11 VARCHAR 255   NO YES FALSE FALSE
EMP_SORG_ASSGN_C Employee Sales Org Assignment Employee Sales Org Assignment SYS_EFF_DTT_C SYS EFF DTT C 12 DATE     NO YES FALSE FALSE
EMP_SORG_ASSGN_C Employee Sales Org Assignment Employee Sales Org Assignment SYS_UPDT_DTT_C SYS UPDT DTT C 13 DATE     NO YES FALSE FALSE
EMP_SORG_ASSGN_C Employee Sales Org Assignment Employee Sales Org Assignment SYS_UPDT_BY_C SYS UPDT BY C 14 VARCHAR 255   NO YES FALSE FALSE
EMP_SORG_ASSGN_C Employee Sales Org Assignment Employee Sales Org Assignment SYS_END_DTT_C SYS END DTT C 15 DATE     NO YES FALSE FALSE
SF_REF_C Sales Force Reference Sales Force Reference SF_SYS_KEY_C SF SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
SF_REF_C Sales Force Reference Sales Force Reference SF_BUS_KEY_C SF BUS KEY C 2 VARCHAR 16777216   NO NO FALSE TRUE
SF_REF_C Sales Force Reference Sales Force Reference SRC_SYS_CD_C SRC SYS CD C 3 VARCHAR 20   NO YES FALSE FALSE
SF_REF_C Sales Force Reference Sales Force Reference CTRY_CD_C CTRY CD C 4 VARCHAR 20   NO YES FALSE FALSE
SF_REF_C Sales Force Reference Sales Force Reference SF_CD_C SF CD C 5 VARCHAR 20   NO YES FALSE FALSE
SF_REF_C Sales Force Reference Sales Force Reference SF_NM_C SF NM C 6 VARCHAR 100   NO YES FALSE FALSE
SF_REF_C Sales Force Reference Sales Force Reference SF_ALT_NM_C SF ALT NM C 7 VARCHAR 100   NO YES FALSE FALSE
SF_REF_C Sales Force Reference Sales Force Reference SYS_CRT_DTT_C SYS CRT DTT C 8 DATE     NO YES FALSE FALSE
SF_REF_C Sales Force Reference Sales Force Reference SYS_CRT_BY_C SYS CRT BY C 9 VARCHAR 255   NO YES FALSE FALSE
SF_REF_C Sales Force Reference Sales Force Reference SYS_EFF_DTT_C SYS EFF DTT C 10 DATE     NO YES FALSE FALSE
SF_REF_C Sales Force Reference Sales Force Reference SYS_UPDT_DTT_C SYS UPDT DTT C 11 DATE     NO YES FALSE FALSE
SF_REF_C Sales Force Reference Sales Force Reference SYS_UPDT_BY_C SYS UPDT BY C 12 VARCHAR 255   NO YES FALSE FALSE
SF_REF_C Sales Force Reference Sales Force Reference SYS_END_DTT_C SYS END DTT C 13 DATE     NO YES FALSE FALSE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference SORG_BP_ALGN_SYS_KEY_C SORG BP ALGN SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference SORG_BP_ALGN_BUS_KEY_C SORG BP ALGN BUS KEY C 2 VARCHAR 16777216   NO NO FALSE TRUE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference SRC_SYS_CD_C SRC SYS CD C 3 VARCHAR 20   NO YES FALSE FALSE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference SRC_ALGN_ID_C SRC ALGN ID C 4 VARCHAR 20   NO YES FALSE FALSE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference SORG_BP_ALGN_TYPE_CD_C SORG BP ALGN TYPE CD C 5 VARCHAR 20   NO YES FALSE FALSE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference SORG_SYS_KEY_C SORG SYS KEY C 6 VARCHAR 16777216   NO NO FALSE TRUE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference CNTRY_CD_C CNTRY CD C 7 VARCHAR 20   NO YES FALSE FALSE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference BP_SYS_KEY_C BP SYS KEY C 8 VARCHAR 16777216   NO NO FALSE TRUE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference BP_TYPE_CD_C BP TYPE CD C 9 VARCHAR 20   NO YES FALSE FALSE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference TRGT_IND_C TRGT IND C 10 BOOLEAN     NO YES FALSE FALSE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference SRC_EFF_DTT_C SRC EFF DTT C 11 DATE     NO YES FALSE FALSE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference SRC_END_DTT_C SRC END DTT C 12 DATE     NO YES FALSE FALSE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference SRC_UPDT_DTT_C SRC UPDT DTT C 13 DATE     NO YES FALSE FALSE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference SYS_CRT_DTT_C SYS CRT DTT C 14 DATE     NO YES FALSE FALSE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference SYS_CRT_BY_C SYS CRT BY C 15 VARCHAR 255   NO YES FALSE FALSE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference SYS_EFF_DTT_C SYS EFF DTT C 16 DATE     NO YES FALSE FALSE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference SYS_UPDT_DTT_C SYS UPDT DTT C 17 DATE     NO YES FALSE FALSE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference SYS_UPDT_BY_C SYS UPDT BY C 18 VARCHAR 255   NO YES FALSE FALSE
SORG_BP_ALGN_REF_C Sales Organization Business Party Alignment Reference Sales Organization Business Party Alignment Reference SYS_END_DTT_C SYS END DTT C 19 DATE     NO YES FALSE FALSE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference SORG_GEO_ALGN_SYS_KEY_C SORG GEO ALGN SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference SORG_GEO_ALGN_BUS_KEY_C SORG GEO ALGN BUS KEY C 2 VARCHAR 16777216   NO NO FALSE TRUE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference SRC_SYS_CD_C SRC SYS CD C 3 VARCHAR 20   NO YES FALSE FALSE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference SRC_ALGN_ID_C SRC ALGN ID C 4 VARCHAR 20   NO YES FALSE FALSE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference SORG_GEO_ALGN_TYPE_CD_C SORG GEO ALGN TYPE CD C 5 VARCHAR 20   NO YES FALSE FALSE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference SORG_SYS_KEY_C SORG SYS KEY C 6 VARCHAR 16777216   NO NO FALSE TRUE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference CNTRY_CD_C CNTRY CD C 7 VARCHAR 20   NO YES FALSE FALSE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference GORG_SYS_KEY_C GORG SYS KEY C 8 VARCHAR 16777216   NO NO FALSE TRUE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference GORG_TYPE_CD_C GORG TYPE CD C 9 VARCHAR 20   NO YES FALSE FALSE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference SRC_EFF_DTT_C SRC EFF DTT C 10 DATE     NO YES FALSE FALSE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference SRC_END_DTT_C SRC END DTT C 11 DATE     NO YES FALSE FALSE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference SRC_UPDT_DTT_C SRC UPDT DTT C 12 DATE     NO YES FALSE FALSE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference SYS_CRT_DTT_C SYS CRT DTT C 13 DATE     NO YES FALSE FALSE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference SYS_CRT_BY_C SYS CRT BY C 14 VARCHAR 255   NO YES FALSE FALSE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference SYS_EFF_DTT_C SYS EFF DTT C 15 DATE     NO YES FALSE FALSE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference SYS_UPDT_DTT_C SYS UPDT DTT C 16 DATE     NO YES FALSE FALSE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference SYS_UPDT_BY_C SYS UPDT BY C 17 VARCHAR 255   NO YES FALSE FALSE
SORG_GEO_ALGN_REF_C Sales Organization Geography Alignment Reference Sales Organization Geography Alignment Reference SYS_END_DTT_C SYS END DTT C 18 DATE     NO YES FALSE FALSE
SORG_HIER_C Sales OrganizationHierarchy Sales OrganizationHierarchy SORG_HIER_SYS_KEY_C SORG HIER SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
SORG_HIER_C Sales OrganizationHierarchy Sales OrganizationHierarchy SORG_HIER_BUS_KEY_C SORG HIER BUS KEY C 2 VARCHAR 16777216   NO NO FALSE TRUE
SORG_HIER_C Sales OrganizationHierarchy Sales OrganizationHierarchy PRNT_SORG_SYS_KEY_C PRNT SORG SYS KEY C 3 VARCHAR 16777216   NO NO FALSE TRUE
SORG_HIER_C Sales OrganizationHierarchy Sales OrganizationHierarchy PRNT_SORG_TYPE_CD_C PRNT SORG TYPE CD C 4 VARCHAR 20   NO YES FALSE FALSE
SORG_HIER_C Sales OrganizationHierarchy Sales OrganizationHierarchy CHLD_SORG_SYS_KEY_C CHLD SORG SYS KEY C 5 VARCHAR 16777216   NO NO FALSE TRUE
SORG_HIER_C Sales OrganizationHierarchy Sales OrganizationHierarchy CHLD_SORG_TYPE_CD_C CHLD SORG TYPE CD C 6 VARCHAR 20   NO YES FALSE FALSE
SORG_HIER_C Sales OrganizationHierarchy Sales OrganizationHierarchy SORG_HIER_ROLE_TYPE_CD_C SORG HIER ROLE TYPE CD C 7 VARCHAR 20   NO YES FALSE FALSE
SORG_HIER_C Sales OrganizationHierarchy Sales OrganizationHierarchy CTRY_CD_C CTRY CD C 8 VARCHAR 20   NO YES FALSE FALSE
SORG_HIER_C Sales OrganizationHierarchy Sales OrganizationHierarchy SYS_CRT_DTT_C SYS CRT DTT C 9 DATE     NO YES FALSE FALSE
SORG_HIER_C Sales OrganizationHierarchy Sales OrganizationHierarchy SYS_CRT_BY_C SYS CRT BY C 10 VARCHAR 255   NO YES FALSE FALSE
SORG_HIER_C Sales OrganizationHierarchy Sales OrganizationHierarchy SYS_EFF_DTT_C SYS EFF DTT C 11 DATE     NO YES FALSE FALSE
SORG_HIER_C Sales OrganizationHierarchy Sales OrganizationHierarchy SYS_UPDT_DTT_C SYS UPDT DTT C 12 DATE     NO YES FALSE FALSE
SORG_HIER_C Sales OrganizationHierarchy Sales OrganizationHierarchy SYS_UPDT_BY_C SYS UPDT BY C 13 VARCHAR 255   NO YES FALSE FALSE
SORG_HIER_C Sales OrganizationHierarchy Sales OrganizationHierarchy SYS_END_DTT_C SYS END DTT C 14 DATE     NO YES FALSE FALSE
SORG_REF_C Sales Organization Reference Sales Organization Reference SORG_SYS_KEY_C SORG SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
SORG_REF_C Sales Organization Reference Sales Organization Reference SORG_BUS_KEY_C SORG BUS KEY C 2 VARCHAR 16777216   NO NO FALSE TRUE
SORG_REF_C Sales Organization Reference Sales Organization Reference SRC_SYS_CD_C SRC SYS CD C 3 VARCHAR 20   NO YES FALSE FALSE
SORG_REF_C Sales Organization Reference Sales Organization Reference CTRY_CD_C CTRY CD C 4 VARCHAR 20   NO YES FALSE FALSE
SORG_REF_C Sales Organization Reference Sales Organization Reference SF_SYS_KEY_C SF SYS KEY C 5 VARCHAR 16777216   NO NO FALSE TRUE
SORG_REF_C Sales Organization Reference Sales Organization Reference SORG_CD_C SORG CD C 6 VARCHAR 20   NO YES FALSE FALSE
SORG_REF_C Sales Organization Reference Sales Organization Reference SORG_TYPE_CD_C SORG TYPE CD C 7 VARCHAR 20   NO YES FALSE FALSE
SORG_REF_C Sales Organization Reference Sales Organization Reference SORG_NM_C SORG NM C 8 VARCHAR 100   NO YES FALSE FALSE
SORG_REF_C Sales Organization Reference Sales Organization Reference SORG_ALT_NM_C SORG ALT NM C 9 VARCHAR 100   NO YES FALSE FALSE
SORG_REF_C Sales Organization Reference Sales Organization Reference SYS_CRT_DTT_C SYS CRT DTT C 10 DATE     NO YES FALSE FALSE
SORG_REF_C Sales Organization Reference Sales Organization Reference SYS_CRT_BY_C SYS CRT BY C 11 VARCHAR 255   NO YES FALSE FALSE
SORG_REF_C Sales Organization Reference Sales Organization Reference SYS_EFF_DTT_C SYS EFF DTT C 12 DATE     NO YES FALSE FALSE
SORG_REF_C Sales Organization Reference Sales Organization Reference SYS_UPDT_DTT_C SYS UPDT DTT C 13 DATE     NO YES FALSE FALSE
SORG_REF_C Sales Organization Reference Sales Organization Reference SYS_UPDT_BY_C SYS UPDT BY C 14 VARCHAR 255   NO YES FALSE FALSE
SORG_REF_C Sales Organization Reference Sales Organization Reference SYS_END_DTT_C SYS END DTT C 15 DATE     NO YES FALSE FALSE
SORG_XREF_C Sales Organization Cross Reference Sales Organization Cross Reference SORG_XREF_SYS_KEY_C SORG XREF SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
SORG_XREF_C Sales Organization Cross Reference Sales Organization Cross Reference SORG_XREF_BUS_KEY_C SORG XREF BUS KEY C 2 VARCHAR 16777216   NO NO FALSE TRUE
SORG_XREF_C Sales Organization Cross Reference Sales Organization Cross Reference SORG_SYS_KEY_C SORG SYS KEY C 3 VARCHAR 16777216   NO NO FALSE TRUE
SORG_XREF_C Sales Organization Cross Reference Sales Organization Cross Reference SORG_XREF_SRC_NM_C SORG XREF SRC NM C 4 VARCHAR 100   NO YES FALSE FALSE
SORG_XREF_C Sales Organization Cross Reference Sales Organization Cross Reference SORG_XREF_SRC_CD_C SORG XREF SRC CD C 5 VARCHAR 20   NO YES FALSE FALSE
SORG_XREF_C Sales Organization Cross Reference Sales Organization Cross Reference SORG_XREF_SRC_VAL_C SORG XREF SRC VAL C 6 VARCHAR 20   NO YES FALSE FALSE
SORG_XREF_C Sales Organization Cross Reference Sales Organization Cross Reference SYS_CRT_DTT_C SYS CRT DTT C 7 DATE     NO YES FALSE FALSE
SORG_XREF_C Sales Organization Cross Reference Sales Organization Cross Reference SYS_CRT_BY_C SYS CRT BY C 8 VARCHAR 100   NO YES FALSE FALSE
SORG_XREF_C Sales Organization Cross Reference Sales Organization Cross Reference SYS_EFF_DTT_C SYS EFF DTT C 9 DATE     NO YES FALSE FALSE
SORG_XREF_C Sales Organization Cross Reference Sales Organization Cross Reference SYS_UPDT_DTT_C SYS UPDT DTT C 10 DATE     NO YES FALSE FALSE
SORG_XREF_C Sales Organization Cross Reference Sales Organization Cross Reference SYS_UPDT_BY_C SYS UPDT BY C 11 VARCHAR 100   NO YES FALSE FALSE
SORG_XREF_C Sales Organization Cross Reference Sales Organization Cross Reference SYS_END_DTT_C SYS END DTT C 12 DATE     NO YES FALSE FALSE
TOT_C Time Off Territory Time Off Territory TOT_SYS_KEY_C TOT SYS KEY C 1 VARCHAR 50   NO NO TRUE TRUE
TOT_C Time Off Territory Time Off Territory SORG_SYS_KEY_C SORG SYS KEY C 2 VARCHAR 16777216   NO NO FALSE TRUE
TOT_C Time Off Territory Time Off Territory TOT_NM_C TOT NM C 3 VARCHAR 100   NO YES FALSE FALSE
TOT_C Time Off Territory Time Off Territory EMP_SYS_KEY_C EMP SYS KEY C 4 VARCHAR 16777216   NO NO FALSE TRUE
TOT_C Time Off Territory Time Off Territory TOT_DUR_C TOT DUR C 5 NUMERIC 6 0 NO YES FALSE FALSE
TOT_C Time Off Territory Time Off Territory TOT_STRT_DTT_C TOT STRT DTT C 6 DATE     NO YES FALSE FALSE
TOT_C Time Off Territory Time Off Territory TOT_END_DTT_C TOT END DTT C 7 DATE     NO YES FALSE FALSE
TOT_C Time Off Territory Time Off Territory UNPAID_IND_C UNPAID IND C 8 VARCHAR 20   NO YES FALSE FALSE
TOT_C Time Off Territory Time Off Territory TOT_SRC_ENT_ID_C TOT SRC ENT ID C 9 VARCHAR 20   NO YES FALSE FALSE
TOT_C Time Off Territory Time Off Territory CTRY_CD_C CTRY CD C 10 VARCHAR 20   NO YES FALSE FALSE
TOT_C Time Off Territory Time Off Territory TOT_TYP_C TOT TYP C 11 VARCHAR 20   NO YES FALSE FALSE
TOT_C Time Off Territory Time Off Territory SYS_EFF_DTT_C SYS EFF DTT C 12 DATE     NO YES FALSE FALSE
TOT_C Time Off Territory Time Off Territory SYS_END_DTT_C SYS END DTT C 13 DATE     NO YES FALSE FALSE
TOT_C Time Off Territory Time Off Territory SYS_CRT_BY_C SYS CRT BY C 14 VARCHAR 255   NO YES FALSE FALSE
TOT_C Time Off Territory Time Off Territory SYS_CRT_DTT_C SYS CRT DTT C 15 DATE     NO YES FALSE FALSE
TOT_C Time Off Territory Time Off Territory SYS_LAST_UPD_BY_C SYS LAST UPD BY C 16 VARCHAR 255   NO YES FALSE FALSE
TOT_C Time Off Territory Time Off Territory SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 17 DATE     NO YES FALSE FALSE