SALES_TAX |
Default Table Name | SALES_TAX |
Definition |
SALES_TAX Columns |
ColumnName | Domain | Datatype | NULL | Definition |
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
SALES_TAX_CD![]() |
VARCHAR2(6) | NO | ||
CERTIF_NO_ID | VARCHAR2(20) | NO | ||
EXMPT_FL | VARCHAR2(1) | NO | ||
SALES_TAX_DESC | VARCHAR2(30) | NO | ||
MAIL_STATE_DC | VARCHAR2(15) | YES | ||
COUNTRY_CD | VARCHAR2(8) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
SALES_TAX_RT | NUMBER(8, 6) | NO | ||
RECOV_PCT | NUMBER(5, 4) | YES | ||
VAT_CUSTOMS_FL | VARCHAR2(1) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
SALES_TAX Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0093 | PrimaryKey | SALES_TAX_CD, COMPANY_ID |
SALES_TAX 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 |
VEND_ADDR | Non-Identifying | One To Zero or More | F05290 | NO | NO | NO | |||
WHSE | Non-Identifying | One To Zero or More | F05480 | NO | NO | NO | |||
SALES_TAX_ACCT | Identifying | One To Zero or More | F06210 | NO | NO | NO | |||
CUST_ADDR | Non-Identifying | One To Zero or More | F08107 | NO | NO | NO | |||
MANUAL_BILL_EDIT | Non-Identifying | Zero or One to Zero or More | F08142 | NO | NO | NO | |||
VCHR_HDR | Non-Identifying | One To Zero or More | F08274 | NO | NO | NO | |||
BILL_SETTINGS | Non-Identifying | One To Zero or More | F08436 | NO | NO | NO | |||
UNITS_USAGE_LN | Non-Identifying | Zero or One to Zero or More | F09496 | NO | NO | NO | |||
UNITS_USAGE_LN_HS | Non-Identifying | One To Zero or More | F09508 | NO | NO | NO | |||
AR_SALES_TAX | Identifying | One To Zero or More | F09513 | NO | NO | NO | |||
CUST_PROD_INVC_LN | Non-Identifying | Zero or One to Zero or More | F09516 | NO | NO | NO | |||
PROJ_PROD_INVC_LN | Non-Identifying | One To Zero or More | F09517 | NO | NO | NO | |||
OPEN_BILLING_DETL | Non-Identifying | One To Zero or More | F09520 | NO | NO | NO | |||
SHIP_ID | Non-Identifying | One To Zero or More | F09766 | NO | NO | NO | |||
CO_EXP_HDR | Non-Identifying | One To Zero or More | F09938 | NO | NO | NO | |||
CO_EXP_HDR_HS | Non-Identifying | One To Zero or More | F09961 | NO | NO | NO | |||
BL_SALES_TAX_ACCT | Identifying | One To Zero or More | F10123 | NO | NO | NO | |||
BL_PROJ_TAX_CD | Non-Identifying | One To Zero or More | F10125 | NO | NO | NO | |||
AR_DETL_HS | Non-Identifying | One To Zero or More | F21192 | NO | NO | NO |