1. Tables and Views for SCM
  2. JMF_IN_COUNTRY_CHARS

JMF_IN_COUNTRY_CHARS

Intrastat setup table to define country level parameters.

Details

  • Schema: FUSION

  • Object owner: JMF

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

JMF_IN_COUNTRY_CHARS_PK

TERRITORY_CODE

Columns

Name Datatype Length Precision Not-null Comments Status
TERRITORY_CODE VARCHAR2 2 Yes Country Active
CATEGORY_SET_ID NUMBER Category Set identifier Active
REFERENCE_PERIOD_RULE VARCHAR2 15 Reference Period Rule to identify Transaction Date Active
PENDING_INVOICE_DAYS NUMBER Number of days, processor should look for invoice in next period of transaction date Active
PRIOR_INVOICE_DAYS NUMBER Number of days, processor should look for an advance invoice Active
REPORTING_CURRENCY_CODE VARCHAR2 15 Intrastat Reporting Currency Active
CURRENCY_PRECISION NUMBER Precision for all currency fields Active
CONVERSION_TYPE VARCHAR2 30 Currency Conversion Type Active
CURRENCY_ROUNDING_METHOD VARCHAR2 30 Rounding Method of currency fields Active
WEIGHT_UOM_CODE VARCHAR2 3 Unit of Measure for weight fields Active
WEIGHT_PRECISION NUMBER Precision for weight fields Active
WEIGHT_ROUNDING_METHOD VARCHAR2 30 Rounding Method for weight fields Active
TRIANGULATION_MODE VARCHAR2 15 Mode of Triangulation, Invoice & Shipment Active
RETURNS_PROCESSING VARCHAR2 30 Rule to process Returns Active
KIT_METHOD VARCHAR2 30 Rule to handle KIT dispatches Active
INCLUDE_QTY_INVOICE_FLAG VARCHAR2 1 Flag to identify weather quantities to be included in movement record in case of Invoice based triangulation Active
SELLER_DECLARES_FOR_SHIP_FLAG VARCHAR2 1 Flag to identify weather Seller has to declare Intrastat records on behalf of shipper in case of Shipment based triangulation Active
SELLER_DECLARES_FOR_CUST_FLAG VARCHAR2 1 Flag to identify weather Seller has to declare Intrastat records on behalf of customer in case of Shipment based triangulation Active
ARR_DESCRIPTION_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Item Description for Arrival Active
ARR_DELIVERY_TERM_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Deliver Terms for Arrival Active
ARR_TRANSPORT_MODE_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Transport Mode for Arrival Active
ARR_REGION_OF_DEST_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Region of Destination for Arrival Active
ARR_COUNTRY_OF_ORIGIN_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Country of Origin for Arrival Active
ARR_STATISTICAL_CODE_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Statistical Code for Arrival Active
ARR_FISCAL_REGIME_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Fiscal Regime Code for Arrival Active
ARR_NET_MASS_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Net Mass for Arrival Active
ARR_TRANSACTION_CODE_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Nature of Transaction Code for Arrival Active
ARR_INVOICE_AMOUNT_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Invoice Value for Arrival Active
DIS_DESCRIPTION_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Item Description for dispatch Active
DIS_DELIVERY_TERM_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Delivery Terms for dispatch Active
DIS_TRANSPORT_MODE_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Transport Mode for dispatch Active
DIS_REGION_OF_ORIGIN_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Regin of Origin for dispatch Active
DIS_COUNTRY_OF_ORIGIN_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Country of Origin for dispatch Active
DIS_STATISTICAL_CODE_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Statistical Code for dispatch Active
DIS_FISCAL_REGIME_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Fiscal Regime Code for dispatch Active
DIS_NET_MASS_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Net Mass for dispatch Active
DIS_TRANSACTION_CODE_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Nature of Transaction Code for dispatch Active
DIS_INVOICE_AMOUNT_REQ_FLAG VARCHAR2 1 Flag to identify weather to collect Invoice Value for dispatch 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
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table Foreign Table Foreign Key Column
jmf_in_le_parameters jmf_in_country_chars TERRITORY_CODE

Indexes

Index Uniqueness Tablespace Columns
JMF_IN_COUNTRY_CHARS_PK Unique FUSION_TS_TX_DATA TERRITORY_CODE, ORA_SEED_SET1
JMF_IN_COUNTRY_CHARS_PK1 Unique FUSION_TS_TX_DATA TERRITORY_CODE, ORA_SEED_SET2