1. Tables and Views for SCM
  2. JMF_IN_STATISTICS

JMF_IN_STATISTICS

This table contains Intrastat Statistics collected by Intrastat Processor.

Details

  • Schema: FUSION

  • Object owner: JMF

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

JMF_IN_STATISTICS_PK

MOVEMENT_ID

Columns

Name Datatype Length Precision Not-null Comments Status
MOVEMENT_ID NUMBER 18 Yes Intrastat transaction identifier
MOVEMENT_STATUS VARCHAR2 1 Intrastat transaction status like Open, Pending, Verified etc Active
ESTABLISHMENT_ID NUMBER 18 Yes Legal Reporting Unit identifier Active
GEOGRAPHY_ID NUMBER 18 Yes Economic Zone identifier Active
LEGAL_ENTITY_ID NUMBER 18 Legal Entity identifier Active
TERRITORY_CODE VARCHAR2 2 Country Active
TERRITORY_NAME VARCHAR2 80 Territory Name Active
LRU_NAME VARCHAR2 240 Legal reporting unit name Active
VAT_REGISTRATION_NUMBER VARCHAR2 150 VAT Registration number of Legal Reporting Unit Active
PARENT_MOVEMENT_ID NUMBER Parent Intrastat transaction identifier Active
DOCUMENT_SOURCE_TYPE VARCHAR2 30 Source Document type Active
PERIOD_NAME VARCHAR2 15 Intrastat Period as per transaction date Active
SET_OF_BOOKS_PERIOD VARCHAR2 15 GL Period as per transaction date
TRANSACTION_DATE DATE Yes Transaction Date Active
MOVEMENT_TYPE VARCHAR2 3 Yes Movement Type like Arrival or Dispatch Active
DISPATCH_TERRITORY_CODE VARCHAR2 2 Dispatch country Active
DESTINATION_TERRITORY_CODE VARCHAR2 2 Destination country Active
TRIANGULATION_COUNTRY_CODE VARCHAR2 2 Triangulation initiating country Active
ORGANIZATION_ID NUMBER 18 Inventory Organization identifier Active
INVENTORY_ITEM_ID NUMBER 18 ivnentory Item identifier Active
ITEM_CODE VARCHAR2 300 Any part, material, product or service that is unique as compared with other items by nature of its attributes in product data hub. Active
ITEM_DESCRIPTION VARCHAR2 240 Item Description Active
CATEGORY_ID NUMBER Category identifier Active
CATEGORY_SET_ID NUMBER Category set identifier
COMMODITY_CODE VARCHAR2 240 Category Code Active
COMMODITY_DESCRIPTION VARCHAR2 240 Category Description Active
ORIGIN_TERRITORY_CODE VARCHAR2 2 Origin country Active
REPORTED_ORIG_TERRITORY_CODE VARCHAR2 2 Origin country that is displayed in Intrastat report.
TRANSACTION_VALUE NUMBER Transaction amount Active
INVOICE_VALUE NUMBER Invoice amount Active
CURRENCY_CODE VARCHAR2 15 Transaction currency code Active
CURRENCY_CONVERSION_RATE NUMBER Currency conversion rate between transaction and reporting currency Active
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Currency conversion type to get conversion rate Active
CURRENCY_CONVERSION_DATE DATE Currency conversion date Active
OUTSIDE_PROCESS_VALUE NUMBER Outside process value Active
STATISTICAL_VALUE NUMBER Statistical amount
ADJ_STATISTICAL_VALUE NUMBER Adjusted statistical amount Active
UNIT_WEIGHT NUMBER Unit weight in weight UOM as per Country Characteristics setup Active
TOTAL_WEIGHT NUMBER Total weight in weight UOM as per Country Characteristics setup Active
TOTAL_WEIGHT_UOM_CODE VARCHAR2 3 Weight UOM as per Country Characteristics setup Active
TRANSACTION_QUANTITY NUMBER Transaction quantity Active
TRANSACTION_QTY_UOM_CODE VARCHAR2 3 Transaction quantity UOM Active
PRIMARY_QUANTITY NUMBER Transaction quantity in primary UOM Active
ALTERNATE_QUANTITY NUMBER Supplementary quantity Active
ALTERNATE_UOM_CODE VARCHAR2 3 Supplementary quantity UOM Active
DELIVERY_TERM_CODE VARCHAR2 30 Delivery Term Active
TRANSACTION_NATURE_CODE VARCHAR2 10 Transaction Nature Code Active
TRANSPORT_MODE_CODE VARCHAR2 80 Transport Mode Active
TRANSPORT_MODE_DESC VARCHAR2 240 Transport mode description Active
STATISTICAL_CODE VARCHAR2 10 Statistical code
ORIGIN_REGION_CODE VARCHAR2 30 Region of origin Active
DESTINATION_REGION_CODE VARCHAR2 30 Region of destination Active
ITEM_COST NUMBER Item cost Active
TARIC_CODE VARCHAR2 30 Taric code Active
PREFERENCE_CODE VARCHAR2 30 Preference code Active
FLOW_INDICATOR_CODE VARCHAR2 30 Flow indicator code Active
SUPPLY_REFERENCE_CODE VARCHAR2 30 Supply reference code
AFFILIATION_REFERENCE_CODE VARCHAR2 30 Affiliation reference code Active
OIL_REFERENCE_CODE VARCHAR2 30 Oil reference code Active
CONTAINER_TYPE_CODE VARCHAR2 30 Container type code Active
CSA_CODE VARCHAR2 30 CSA code Active
PORT VARCHAR2 30 Port of locading/unloading Active
COMMENTS VARCHAR2 240 User comments Active
RCV_TRANSACTION_ID NUMBER Receiving transaction identifier Active
PO_HEADER_ID NUMBER Purchase order identifier Active
PO_LINE_ID NUMBER Purchase order line identifier Active
PO_LINE_LOCATION_ID NUMBER Purchase order shipment identifier Active
SHIPMENT_HEADER_ID NUMBER Shipment identifier
SHIPMENT_LINE_ID NUMBER Shipment line identifier
PICKING_LINE_DETAIL_ID NUMBER Picking line detail identifier Active
PICKING_LINE_ID NUMBER Picking line identifier Active
ORDER_HEADER_ID NUMBER Sales order identifier Active
ORDER_LINE_ID NUMBER Sales order line identifier Active
MTL_TRANSACTION_ID NUMBER Material transaction identifier Active
MTL_SHIPMENT_TXN_ID NUMBER Material transaction identifier against shipment
REQUISITION_HEADER_ID NUMBER Requisition identifier Active
REQUISITION_LINE_ID NUMBER Requisition line identifier Active
SHIP_TO_CUSTOMER_ID NUMBER Ship to customer identifier
SHIP_TO_SITE_USE_ID NUMBER Ship to customer site
BILL_TO_CUSTOMER_ID NUMBER Bill to customer Active
BILL_TO_SITE_USE_ID NUMBER Bill to customer site Active
FROM_ORGANIZATION_ID NUMBER Movement from organization Active
TO_ORGANIZATION_ID NUMBER Movement to organization Active
DOCUMENT_UNIT_PRICE NUMBER Transaction unit price Active
DOCUMENT_REFERENCE VARCHAR2 150 Source Document Number
DOCUMENT_LINE_REFERENCE VARCHAR2 150 Source Document Line Number
RECEIPT_REFERENCE VARCHAR2 50 Receiving transaction identifier Active
SHIPMENT_REFERENCE VARCHAR2 50 shipment reference
SHIPMENT_LINE_REFERENCE VARCHAR2 30 Shipment line reference
PICK_SLIP_REFERENCE VARCHAR2 50 Pick slop reference Active
DISTRIBUTION_LINE_NUMBER NUMBER Distribution line number Active
TRANSACTING_FROM_ORG VARCHAR2 50 Transacting from organization Active
TRANSACTING_TO_ORG VARCHAR2 50 Transaction to organizaiton Active
INVOICE_BATCH_ID NUMBER Invoice batch identifier Active
INVOICE_ID NUMBER Invoice identifier Active
INVOICE_LINE_ID NUMBER Invoice line identifier Active
INVOICE_BATCH_NAME VARCHAR2 50 Invoice batch name Active
INVOICE_NUMBER VARCHAR2 50 Invoice number Active
INVOICE_LINE_NUMBER VARCHAR2 30 Invoice line number Active
INVOICE_DATE_REFERENCE DATE Invoice date Active
INVOICE_QUANTITY NUMBER Invoice quantity Active
INVOICE_UNIT_PRICE NUMBER Invoice unit price Active
REPORT_REFERENCE VARCHAR2 200 report reference code Active
REPORT_DATE DATE report date Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ORIGINAL_TRANSACTION_DATE DATE Actual Transaction Date of movement Active
INVOICE_QUANTITY_UOM_CODE VARCHAR2 3 Invoice Quantity Unit of Measure Active
DOCUMENT_NUMBER VARCHAR2 50 Document Number Active
DOCUMENT_LINE_NUMBER VARCHAR2 50 Document Line Number Active
AUTOMATIC_CREATION_FLAG VARCHAR2 1 Flag to identify if record is created by processor or manually Active
PRIMARY_UOM_CODE VARCHAR2 3 Primary Unit of Measure Active
RECEIPT_NUMBER VARCHAR2 30 Receipt Number Active
DROPSHIP_TRANSACTION_FLAG VARCHAR2 1 Flag to identify if it is dropship transatcion Active
FISCAL_REGIME_CODE VARCHAR2 10 Fiscal Regime code Active
TRADING_PARTNER_ID NUMBER 18 Trading Partner identifier Active
TRADING_PARTNER_TYPE VARCHAR2 1 Trading Partner type Active
TRADING_PARTNER_VAT_NUMBER VARCHAR2 150 Trading Partner VAT Number Active
TRADING_PARTNER_NAME VARCHAR2 360 Trading Partner name Active
TRADING_PARTNER_SITE_ID NUMBER Trading Partner Site identifier Active
TRADING_PARTNER_SITE_NAME VARCHAR2 250 Trading Partner Site Name Active
TRADING_PARTNER_NUMBER VARCHAR2 20 Trading Partner Number Active
TRADING_PARTNER_PARTY_ID NUMBER Trading Partner party identifier Active
TRADING_PARTNER_SITE_PARTY_ID VARCHAR2 20 Trading Partner Site party identifier Active
FROM_LOCATION_ID NUMBER 18 Dispatch location identifier Active
TO_LOCATION_ID NUMBER 18 Destination location identifier Active
ORIGIN_POSTAL_CODE VARCHAR2 60 Postal code where Intrastat transaction originated Active
DESTINATION_POSTAL_CODE VARCHAR2 60 Postal code where Intrastat transaction is destined Active
FREIGHT_CHARGES NUMBER Freight charges Active
FREIGHT_FACTOR NUMBER Freight % Active
REPORTING_CURRENCY_CODE VARCHAR2 15 Reporting Currency Code Active
FLOW_INSTANCE_ID NUMBER Flow instance id from supply chain financial orchestration to identify payable and receivable intercompany invoices.
INVOICE_NEEDED_FLAG VARCHAR2 1 Flag to identify is invoice is required for Intrastat transaction Active
INVOICE_CURRENCY_CODE VARCHAR2 15 Invoice value currency
SELLING_LEGAL_ENTITY_ID NUMBER Selling legal entity identifier
SHIPPING_REC_LEGAL_ENTITY_ID NUMBER Shipping or receiving legal entity identifier
INVOICE_VALUE_IN_REP_CURR NUMBER Invoice value in reporting currency
DOO_FULFILLMENT_ID NUMBER Fullfillment Id from DOO for document source SO
IS_KIT_ITEM_FLAG VARCHAR2 1 KIT item flag
IS_CST_DOO_UPDATE_FLAG VARCHAR2 1 A flag used by batch program to identify that item cost and doo attributes have been updated through web services in current run.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
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_STATISTICS jmf_in_le_parameters TERRITORY_CODE, ESTABLISHMENT_ID

Indexes

Index Uniqueness Tablespace Columns
JMF_IN_STATISTICS_PK Unique FUSION_TS_TX_DATA MOVEMENT_ID