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 |