JMF_IN_LE_PARAMETERS

This table defines Intrastat setup parameters at Legal Reporting Unit level.

Details

• Schema: FUSION

• Object owner: JMF

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
JMF_IN_LE_PARAMETERS_PK	TERRITORY_CODE, ESTABLISHMENT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
TERRITORY_CODE	VARCHAR2	2		Yes	Country	Active
LEGAL_ENTITY_ID	NUMBER			Yes	Legal Entity identifier	Active
ESTABLISHMENT_ID	NUMBER			Yes	Legal Reporting Unit identifier	Active
GEOGRAPHY_ID	NUMBER			Yes	Economic Zone identifier	Active
PERIOD_SET_NAME	VARCHAR2	15			Period Set Name of Reporting Calendar	Active
PERIOD_TYPE	VARCHAR2	15			Period Type of Reporting Calendar	Active
START_PERIOD_NAME	VARCHAR2	15			Starting Period Name from Reporting Calendar	Active
END_PERIOD_NAME	VARCHAR2	15			End Period Name from Reporting Calendar	Active
VAT_REGISTRATION_NUMBER	VARCHAR2	70			VAT Registration Number of Legal Reporting Unit	Active
TAX_OFFICE_CODE	VARCHAR2	50			Office Code of Intrastat Reported Authority	Active
TAX_OFFICE_NAME	VARCHAR2	50			Office Name of Intrastat Reported Authority	Active
TAX_OFFICE_LOCATION_ID	NUMBER				Location identifier of Intrastat Reported Authority	Active
BRANCH_REFERENCE_TXT	VARCHAR2	240			Branch Code of Intrastat Reported Authority	Active
CONTACT_NAME	VARCHAR2	80			contact Person Name from Intrastat Reported Authority	Active
CONTACT_EMAIL	VARCHAR2	80			contact Email Id of Intrastat Reported Authority	Active
CONTACT_PHONE	VARCHAR2	50			Contact Phone of Intrastat Reported Authority	Active
EXCLUSION_RULE_SET_CODE	VARCHAR2	50			Exclusion Rule Set Code	Active
VALIDATION_RULE_SET_CODE	VARCHAR2	50			Attribute Validation Rule Set Code	Active
STATISTICAL_RULE_SET_CODE	VARCHAR2	50			Statical Procedure Rule Set Code	Active
FISCAL_REGIME_RULE_SET_CODE	VARCHAR2	50			Fiscal Regime Rule Set Code	Active
STAT_VAL_CALC_RULE_SET_CODE	VARCHAR2	50			Freight Factor Rule Set Code	Active
NOTC_RULE_SET_CODE	VARCHAR2	50			Nature of Transaction Rule Set Code	Active
SUPP_UOM_RULE_SET_CODE	VARCHAR2	50			Supplementary UOM Rule Set Code	Active
LRU_LOCATION_ID	NUMBER				Location identifier for Legal Reporting Unit	Active
LRU_PARTY_ID	NUMBER				Legal Reporting Unit Party identifier to get tax registration number	Active
EXCLUDE_DISPATCHES_FROM	VARCHAR2	30			Support exclusion of Intrastat transactions originating from this geography	Active
EXCLUDE_ARRIVALS_TO	VARCHAR2	30			Support exclusion of Intrastat transactions arriving to this geography	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.	Active

Foreign Keys

Table	Foreign Table	Foreign Key Column
JMF_IN_LE_PARAMETERS	jmf_in_country_chars	TERRITORY_CODE
jmf_in_statistics	jmf_in_le_parameters	TERRITORY_CODE, ESTABLISHMENT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
JMF_IN_LE_PARAMETERS_PK	Unique	FUSION_TS_TX_DATA	TERRITORY_CODE, ESTABLISHMENT_ID