Business Party Address
Entity Relationship Diagram
|
Tip: |
Right click the attachment to view Entity Relationship Diagram for Business Party Address 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BPA_COMM_MHSM_C | Business Party AddressMHSM Communication | Business Party AddressMHSM Communication | BPA_COMM_SYS_KEY_C | BPA COMM SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BPA_COMM_MHSM_C | Business Party AddressMHSM Communication | Business Party AddressMHSM Communication | BPA_COMM_BUS_KEY_C | BPA COMM BUS KEY C | 2 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| BPA_COMM_MHSM_C | Business Party AddressMHSM Communication | Business Party AddressMHSM Communication | BPA_SYS_KEY_C | BPA SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BPA_COMM_MHSM_C | Business Party AddressMHSM Communication | Business Party AddressMHSM Communication | COMM_TYPE_CD_C | COMM TYPE CD C | 4 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_COMM_MHSM_C | Business Party AddressMHSM Communication | Business Party AddressMHSM Communication | COMM_VAL_TXT_C | COMM VAL TXT C | 5 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_COMM_MHSM_C | Business Party AddressMHSM Communication | Business Party AddressMHSM Communication | COMM_RANK_C | COMM RANK C | 6 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| BPA_COMM_MHSM_C | Business Party AddressMHSM Communication | Business Party AddressMHSM Communication | ACTV_IND_C | ACTV IND C | 7 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| BPA_COMM_MHSM_C | Business Party AddressMHSM Communication | Business Party AddressMHSM Communication | SYS_CRT_DTT_C | SYS CRT DTT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_COMM_MHSM_C | Business Party AddressMHSM Communication | Business Party AddressMHSM Communication | SYS_CRT_BY_C | SYS CRT BY C | 9 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_COMM_MHSM_C | Business Party AddressMHSM Communication | Business Party AddressMHSM Communication | SYS_EFF_DTT_C | SYS EFF DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_COMM_MHSM_C | Business Party AddressMHSM Communication | Business Party AddressMHSM Communication | SYS_UPDT_DTT_C | SYS UPDT DTT C | 11 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_COMM_MHSM_C | Business Party AddressMHSM Communication | Business Party AddressMHSM Communication | SYS_UPDT_BY_C | SYS UPDT BY C | 12 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_COMM_MHSM_C | Business Party AddressMHSM Communication | Business Party AddressMHSM Communication | SYS_END_DTT_C | SYS END DTT C | 13 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_EXT_ATTR_C | Business Party AddressExternal Attribute | Business Party AddressExternal Attribute | BPA_EXT_ATTR_SYS_KEY_C | BPA EXT ATTR SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BPA_EXT_ATTR_C | Business Party AddressExternal Attribute | Business Party AddressExternal Attribute | BPA_EXT_ATTR_BUS_KEY_C | BPA EXT ATTR BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BPA_EXT_ATTR_C | Business Party AddressExternal Attribute | Business Party AddressExternal Attribute | BPA_SYS_KEY_C | BPA SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BPA_EXT_ATTR_C | Business Party AddressExternal Attribute | Business Party AddressExternal Attribute | EXT_ATTR_TYPE_TXT_C | EXT ATTR TYPE TXT C | 4 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_EXT_ATTR_C | Business Party AddressExternal Attribute | Business Party AddressExternal Attribute | EXT_ATTR_TYPE_VAL_C | EXT ATTR TYPE VAL C | 5 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_EXT_ATTR_C | Business Party AddressExternal Attribute | Business Party AddressExternal Attribute | ACTV_IND_C | ACTV IND C | 6 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| BPA_EXT_ATTR_C | Business Party AddressExternal Attribute | Business Party AddressExternal Attribute | SYS_CRT_DTT_C | SYS CRT DTT C | 7 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_EXT_ATTR_C | Business Party AddressExternal Attribute | Business Party AddressExternal Attribute | SYS_CRT_BY_C | SYS CRT BY C | 8 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_EXT_ATTR_C | Business Party AddressExternal Attribute | Business Party AddressExternal Attribute | SYS_EFF_DTT_C | SYS EFF DTT C | 9 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_EXT_ATTR_C | Business Party AddressExternal Attribute | Business Party AddressExternal Attribute | SYS_UPDT_DTT_C | SYS UPDT DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_EXT_ATTR_C | Business Party AddressExternal Attribute | Business Party AddressExternal Attribute | SYS_UPDT_BY_C | SYS UPDT BY C | 11 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_EXT_ATTR_C | Business Party AddressExternal Attribute | Business Party AddressExternal Attribute | SYS_END_DTT_C | SYS END DTT C | 12 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_GORG_C | Business Party Address Geography | Business Party Address Geography | BPA_BRIK_SYS_KEY_C | BPA BRIK SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BPA_GORG_C | Business Party Address Geography | Business Party Address Geography | BPA_BRIK_BUS_KEY_C | BPA BRIK BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BPA_GORG_C | Business Party Address Geography | Business Party Address Geography | BPA_SYS_KEY_C | BPA SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BPA_GORG_C | Business Party Address Geography | Business Party Address Geography | GORG_SYS_KEY_C | GORG SYS KEY C | 4 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BPA_GORG_C | Business Party Address Geography | Business Party Address Geography | ACTV_IND_C | ACTV IND C | 5 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| BPA_GORG_C | Business Party Address Geography | Business Party Address Geography | SYS_CRT_DTT_C | SYS CRT DTT C | 6 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_GORG_C | Business Party Address Geography | Business Party Address Geography | SYS_CRT_BY_C | SYS CRT BY C | 7 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_GORG_C | Business Party Address Geography | Business Party Address Geography | SYS_EFF_DTT_C | SYS EFF DTT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_GORG_C | Business Party Address Geography | Business Party Address Geography | SYS_UPDT_DTT_C | SYS UPDT DTT C | 9 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_GORG_C | Business Party Address Geography | Business Party Address Geography | SYS_UPDT_BY_C | SYS UPDT BY C | 10 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_GORG_C | Business Party Address Geography | Business Party Address Geography | SYS_END_DTT_C | SYS END DTT C | 11 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | BPA_LIC_DTL_SYS_KEY_C | BPA LIC DTL SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | BPA_LIC_DTL_BUS_KEY_C | BPA LIC DTL BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | BPA_SYS_KEY_C | BPA SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | LIC_CATG_CD_C | LIC CATG CD C | 4 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | LIC_TYPE_C | LIC TYPE C | 5 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | LIC_BOARD_NM_C | LIC BOARD NM C | 6 | VARCHAR | 250 | NO | YES | FALSE | FALSE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | LIC_STATE_NM_C | LIC STATE NM C | 7 | VARCHAR | 250 | NO | YES | FALSE | FALSE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | LIC_DEGR_NM_C | LIC DEGR NM C | 8 | VARCHAR | 250 | NO | YES | FALSE | FALSE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | LIC_PROF_NM_C | LIC PROF NM C | 9 | VARCHAR | 250 | NO | YES | FALSE | FALSE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | LIC_NUM_C | LIC NUM C | 10 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | LIC_NM_C | LIC NM C | 11 | VARCHAR | 250 | NO | YES | FALSE | FALSE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | ACTV_IND_C | ACTV IND C | 12 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | LIC_DACTV_RESN_CD_C | LIC DACTV RESN CD C | 13 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | LIC_RANK_NUM_C | LIC RANK NUM C | 14 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | LIC_EXP_DT_C | LIC EXP DT C | 15 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | DRUG_SCHED_C | DRUG SCHED C | 16 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | BUS_ACTVTY_CD_C | BUS ACTVTY CD C | 17 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | SUB_BUS_ACTVTY_CD_C | SUB BUS ACTVTY CD C | 18 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | LIC_CHG_RSN_CD_C | LIC CHG RSN CD C | 19 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | SYS_CRT_DTT_C | SYS CRT DTT C | 20 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | SYS_CRT_BY_C | SYS CRT BY C | 21 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | SYS_EFF_DTT_C | SYS EFF DTT C | 22 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | SYS_UPDT_DTT_C | SYS UPDT DTT C | 23 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | SYS_UPDT_BY_C | SYS UPDT BY C | 24 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BPA_LIC_DTL_C | Business Party Address License Detail | Business Party Address License Detail | SYS_END_DTT_C | SYS END DTT C | 25 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_PRVCY_C | Business Party Address Privacy | Business Party Address Privacy | BPA_PRVCY_SYS_KEY_C | BPA PRVCY SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BPA_PRVCY_C | Business Party Address Privacy | Business Party Address Privacy | BPA_PRVCY_BUS_KEY_C | BPA PRVCY BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BPA_PRVCY_C | Business Party Address Privacy | Business Party Address Privacy | BPA_SYS_KEY_C | BPA SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BPA_PRVCY_C | Business Party Address Privacy | Business Party Address Privacy | BPA_PRVC_TYPE_TXT_C | BPA PRVC TYPE TXT C | 4 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_PRVCY_C | Business Party Address Privacy | Business Party Address Privacy | CTRY_CD_C | CTRY CD C | 5 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_PRVCY_C | Business Party Address Privacy | Business Party Address Privacy | BPA_PRVC_IND_C | BPA PRVC IND C | 6 | BOOLEAN | NO | YES | FALSE | FALSE | ||
| BPA_PRVCY_C | Business Party Address Privacy | Business Party Address Privacy | BPA_PRVC_IND_DT_C | BPA PRVC IND DT C | 7 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_PRVCY_C | Business Party Address Privacy | Business Party Address Privacy | SYS_CRT_DTT_C | SYS CRT DTT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_PRVCY_C | Business Party Address Privacy | Business Party Address Privacy | SYS_CRT_BY_C | SYS CRT BY C | 9 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_PRVCY_C | Business Party Address Privacy | Business Party Address Privacy | SYS_EFF_DTT_C | SYS EFF DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_PRVCY_C | Business Party Address Privacy | Business Party Address Privacy | SYS_UPDT_DTT_C | SYS UPDT DTT C | 11 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_PRVCY_C | Business Party Address Privacy | Business Party Address Privacy | SYS_UPDT_BY_C | SYS UPDT BY C | 12 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_PRVCY_C | Business Party Address Privacy | Business Party Address Privacy | SYS_END_DTT_C | SYS END DTT C | 13 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | BPA_SYS_KEY_C | BPA SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | BPA_BUS_KEY_C | BPA BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | SRC_SYS_CD_C | SRC SYS CD C | 3 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | BPA_SRC_ENT_ID_C | BPA SRC ENT ID C | 4 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | SRC_LOCN_ENT_ID_C | SRC LOCN ENT ID C | 5 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | BP_SYS_KEY_C | BP SYS KEY C | 6 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | ADDR_TYPE_CD_C | ADDR TYPE CD C | 7 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | ADDR_LN1_TXT_C | ADDR LN1 TXT C | 8 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | ADDR_LN2_TXT_C | ADDR LN2 TXT C | 9 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | ADDR_LN3_TXT_C | ADDR LN3 TXT C | 10 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | STRT_NM_C | STRT NM C | 11 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | BLDG_NM_C | BLDG NM C | 12 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | SUB_BLDG_NM_C | SUB BLDG NM C | 13 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | POBX_NO_C | POBX NO C | 14 | VARCHAR | 50 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | CITY_NM_C | CITY NM C | 15 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | ST_PROV_CD_C | ST PROV CD C | 16 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | COUNTY_NM_CD_C | COUNTY NM CD C | 17 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | MSA_CD_C | MSA CD C | 18 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | CBSA_CD_C | CBSA CD C | 19 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | CTRY_CD_C | CTRY CD C | 20 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | PSTL_CD_C | PSTL CD C | 21 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | PSTL_EXTN_CD_C | PSTL EXTN CD C | 22 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | GEO_LAT_CD_C | GEO LAT CD C | 23 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | GEO_LNG_CD_C | GEO LNG CD C | 24 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | GEO_ACURCY_CD_C | GEO ACURCY CD C | 25 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | FRMT_ADDR_LN1_TXT_C | FRMT ADDR LN1 TXT C | 26 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | FRMT_ADDR_LN2_TXT_C | FRMT ADDR LN2 TXT C | 27 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | FRMT_LN3_TXT_C | FRMT LN3 TXT C | 28 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | FRMT_CITY_NM_C | FRMT CITY NM C | 29 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | FRMT_ST_PROV_CD_C | FRMT ST PROV CD C | 30 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | FRMT_PSTL_CD_C | FRMT PSTL CD C | 31 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | FRMT_PSTL_EXTN_CD_C | FRMT PSTL EXTN CD C | 32 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | BEST_PROV_ADDR_IND_C | BEST PROV ADDR IND C | 33 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | BEST_CUST_ADDR_IND_C | BEST CUST ADDR IND C | 34 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | BEST_CALL_ADDR_IND_C | BEST CALL ADDR IND C | 35 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | BEST_MAIL_ADDR_IND_C | BEST MAIL ADDR IND C | 36 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | BEST_SMPL_ADDR_IND_C | BEST SMPL ADDR IND C | 37 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | PRVD_ADDR_RANK_NUM_C | PRVD ADDR RANK NUM C | 38 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | CUST_ADDR_RANK_NUM_C | CUST ADDR RANK NUM C | 39 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | ADDR_AVC_CD_C | ADDR AVC CD C | 40 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | ADDR_VAL_STAT_CD_C | ADDR VAL STAT CD C | 41 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | ADDR_VRFYCATN_STAT_CD_C | ADDR VRFYCATN STAT CD C | 42 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | CNTL_SMPL_ELIG_STAT_C | CNTL SMPL ELIG STAT C | 43 | BOOLEAN | NO | YES | FALSE | FALSE | ||
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | SMPL_ELIG_STAT_C | SMPL ELIG STAT C | 44 | BOOLEAN | NO | YES | FALSE | FALSE | ||
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | ACTV_IND_C | ACTV IND C | 45 | BOOLEAN | NO | YES | FALSE | FALSE | ||
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | PRI_ADDR_IND_C | PRI ADDR IND C | 46 | BOOLEAN | NO | YES | FALSE | FALSE | ||
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | SRC_EFF_DTT_C | SRC EFF DTT C | 47 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | SRC_END_DTT_C | SRC END DTT C | 48 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | SRC_UPDT_DTT_C | SRC UPDT DTT C | 49 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | SYS_CRT_DTT_C | SYS CRT DTT C | 50 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | SYS_CRT_BY_C | SYS CRT BY C | 51 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | SYS_EFF_DTT_C | SYS EFF DTT C | 52 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | SYS_UPDT_DTT_C | SYS UPDT DTT C | 53 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | SYS_UPDT_BY_C | SYS UPDT BY C | 54 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_REF_C | Business Party Address Reference | Business Party Address Reference | SYS_END_DTT_C | SYS END DTT C | 55 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_XIDNTY_C | Business Party Address Cross Identity | Business Party Address Cross Identity | BPA_EXTL_IDNTY_SYS_KEY_C | BPA EXTL IDNTY SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BPA_XIDNTY_C | Business Party Address Cross Identity | Business Party Address Cross Identity | BPA_EXTL_IDNTY_BUS_KEY_C | BPA EXTL IDNTY BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BPA_XIDNTY_C | Business Party Address Cross Identity | Business Party Address Cross Identity | BPA_SYS_KEY_C | BPA SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BPA_XIDNTY_C | Business Party Address Cross Identity | Business Party Address Cross Identity | EXTL_IDNTY_TYPE_CD_C | EXTL IDNTY TYPE CD C | 4 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_XIDNTY_C | Business Party Address Cross Identity | Business Party Address Cross Identity | EXTL_IDNTY_VAL_C | EXTL IDNTY VAL C | 5 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_XIDNTY_C | Business Party Address Cross Identity | Business Party Address Cross Identity | SRC_STAT_CD_C | SRC STAT CD C | 6 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BPA_XIDNTY_C | Business Party Address Cross Identity | Business Party Address Cross Identity | SRC_EXPR_DT_C | SRC EXPR DT C | 7 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_XIDNTY_C | Business Party Address Cross Identity | Business Party Address Cross Identity | SYS_CRT_DTT_C | SYS CRT DTT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_XIDNTY_C | Business Party Address Cross Identity | Business Party Address Cross Identity | SYS_CRT_BY_C | SYS CRT BY C | 9 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_XIDNTY_C | Business Party Address Cross Identity | Business Party Address Cross Identity | SYS_EFF_DTT_C | SYS EFF DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_XIDNTY_C | Business Party Address Cross Identity | Business Party Address Cross Identity | SYS_UPDT_DTT_C | SYS UPDT DTT C | 11 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_XIDNTY_C | Business Party Address Cross Identity | Business Party Address Cross Identity | SYS_UPDT_BY_C | SYS UPDT BY C | 12 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_XIDNTY_C | Business Party Address Cross Identity | Business Party Address Cross Identity | SYS_END_DTT_C | SYS END DTT C | 13 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_XREF_C | Business Party Address Cross Reference | Business Party Address Cross Reference | BPA_XREF_SYS_KEY_C | BPA XREF SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BPA_XREF_C | Business Party Address Cross Reference | Business Party Address Cross Reference | BPA_XREF_BUS_KEY_C | BPA XREF BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BPA_XREF_C | Business Party Address Cross Reference | Business Party Address Cross Reference | BPA_SYS_KEY_C | BPA SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BPA_XREF_C | Business Party Address Cross Reference | Business Party Address Cross Reference | BPA_XREF_SRC_NM_C | BPA XREF SRC NM C | 4 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BPA_XREF_C | Business Party Address Cross Reference | Business Party Address Cross Reference | BPA_XREF_SRC_CD_C | BPA XREF SRC CD C | 5 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BPA_XREF_C | Business Party Address Cross Reference | Business Party Address Cross Reference | LOCN_XREF_SRC_VAL_C | LOCN XREF SRC VAL C | 6 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_XREF_C | Business Party Address Cross Reference | Business Party Address Cross Reference | SRC_EFF_DTT_C | SRC EFF DTT C | 7 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_XREF_C | Business Party Address Cross Reference | Business Party Address Cross Reference | SRC_END_DTT_C | SRC END DTT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_XREF_C | Business Party Address Cross Reference | Business Party Address Cross Reference | SRC_UPDT_DTT_C | SRC UPDT DTT C | 9 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_XREF_C | Business Party Address Cross Reference | Business Party Address Cross Reference | SYS_CRT_DTT_C | SYS CRT DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_XREF_C | Business Party Address Cross Reference | Business Party Address Cross Reference | SYS_CRT_BY_C | SYS CRT BY C | 11 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_XREF_C | Business Party Address Cross Reference | Business Party Address Cross Reference | SYS_EFF_DTT_C | SYS EFF DTT C | 12 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_XREF_C | Business Party Address Cross Reference | Business Party Address Cross Reference | SYS_UPDT_DTT_C | SYS UPDT DTT C | 13 | DATE | NO | YES | FALSE | FALSE | ||
| BPA_XREF_C | Business Party Address Cross Reference | Business Party Address Cross Reference | SYS_UPDT_BY_C | SYS UPDT BY C | 14 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BPA_XREF_C | Business Party Address Cross Reference | Business Party Address Cross Reference | SYS_END_DTT_C | SYS END DTT C | 15 | DATE | NO | YES | FALSE | FALSE |