MAIL_STATE |
Default Table Name | MAIL_STATE |
Definition |
MAIL_STATE Columns |
ColumnName | Domain | Datatype | NULL | Definition |
COUNTRY_CD![]() |
VARCHAR2(8) | NO | ||
MAIL_STATE_DC![]() |
VARCHAR2(15) | NO | ||
MAIL_STATE_NAME | VARCHAR2(25) | NO | ||
DFLT_SALES_TAX_CD | VARCHAR2(6) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
MAIL_STATE Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0011 | PrimaryKey | COUNTRY_CD, MAIL_STATE_DC |
MAIL_STATE Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
COUNTRY | Identifying | One To Zero or More | F02370 | COUNTRY_CD | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
BRNCH_ADDR | Non-Identifying | One To Zero or More | F00370 | NO | NO | NO | |||
EMPL | Non-Identifying | One To Zero or More | F00570 | NO | NO | NO | |||
POSTAL_CD | Non-Identifying | One To Zero or More | F03120 | NO | NO | NO | |||
TAXBLE_ENTITY | Non-Identifying | One To Zero or More | F04720 | NO | NO | NO | |||
VEND_ADDR | Non-Identifying | One To Zero or More | F05140 | NO | NO | NO | |||
WHSE | Non-Identifying | One To Zero or More | F05470 | NO | NO | NO | |||
CUST_ADDR | Non-Identifying | One To Zero or More | F08106 | NO | NO | NO | |||
BILL_REMIT_ADDR | Non-Identifying | One To Zero or More | F09338 | NO | NO | NO | |||
BILL_PAYMENT_ADDR | Non-Identifying | One To Zero or More | F09339 | NO | NO | NO | |||
FA_LOCATION_GRP | Non-Identifying | One To Zero or More | F09533 | NO | NO | NO | |||
ASSET | Non-Identifying | One To Zero or More | F09601 | NO | NO | NO | |||
FA_TEMPLATE | Non-Identifying | One To Zero or More | F09605 | NO | NO | NO | |||
SURVEY_COMPANY | Non-Identifying | One To Zero or More | F09883 | NO | NO | NO | |||
ISSUE_BY_ADDR | Non-Identifying | One To Zero or More | F10051 | NO | NO | NO | |||
CONTR_ADDR | Non-Identifying | One To Zero or More | F10052 | NO | NO | NO | |||
H_EMPL_DEPENDENT | Non-Identifying | One To Zero or More | F20398 | NO | NO | NO | |||
H_SECT1_EMPL_EXIT | Non-Identifying | One To Zero or More | F20492 | NO | NO | NO | |||
TVL_PER_DIEM | Non-Identifying | One To Zero or More | F20559 | NO | NO | NO | |||
AUTOCR_ASSET_EDIT | Non-Identifying | One To Zero or More | F20581 | NO | NO | NO | |||
HB_PROVIDER | Non-Identifying | One To Zero or More | F20884 | NO | NO | NO | |||
HB_EMPL_DEP_BNFIC | Non-Identifying | One To Zero or More | F20926 | NO | NO | NO | |||
SUBC_LIEN | Non-Identifying | One To Zero or More | F20936 | NO | NO | NO | |||
SUBC_CARRIER | Non-Identifying | One To Zero or More | F20937 | NO | NO | NO | |||
COURT_REMIT | Non-Identifying | One To Zero or More | F21281 | NO | NO | NO | |||
EMPL_SUP_ADR | Non-Identifying | One To Zero or More | F21526 | NO | NO | NO | |||
LAB_LOCATION | Non-Identifying | One To Zero or More | FK_LAB_LOCATION_COMA_IDX | NO | NO | NO | |||
PO_LN_RESOURCE | Non-Identifying | One To Zero or More | FK_PO_LN_RESOURCE_CM_IDX | NO | NO | NO | |||
PO_LN_RESOURCE_HS | Non-Identifying | One To Zero or More | FK_PO_LN_RESOURCE_HS_COMA_IDX | NO | NO | NO | |||
QT_LN_RESOURCE | Non-Identifying | One To Zero or More | FK_QT_LN_RESOURCE_COMA_IDX | NO | NO | NO | |||
RFQ_LN_RESOURCE | Non-Identifying | One To Zero or More | FK_RFQ_LN_RESOURCE_COMA_IDX | NO | NO | NO | |||
RQ_HDR_PO_RSRCE | Non-Identifying | One To Zero or More | FK_RQ_HDR_PO_RSRCE_COMA_IDX | NO | NO | NO | |||
RQ_LN_PO_RSRCE | Non-Identifying | One To Zero or More | FK_RQ_LN_PO_RSRCE_COMA_IDX | NO | NO | NO | |||
RQ_LN_RESOURCE | Non-Identifying | One To Zero or More | FK_RQ_LN_RESOURCE_COMA_IDX | NO | NO | NO | |||
RQ_PO_RSRCE | Non-Identifying | One To Zero or More | FK_RQ_PO_RSRCE_COMA_IDX | NO | NO | NO | |||
VE_LAB_INFO | Non-Identifying | One To Zero or More | FK_VE_LAB_INFO_COMA_IDX | NO | NO | NO |