Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

Inbound Integrations refer to data imports that create or update Master Files and/or Transactions in NorthScope. Examples of Inbound Integrations include importing Customers, Items, and GL Accounts from Excel or from a third-party integration.

The purpose of this page is to show the details of a single record that is currently in the inbound queue that has not yet been successfully imported into NorthScope. From here users can Mass Update the status.

Page Header

Toolbar IconsDescription
SaveSaves the changes made to the record. 

(lightbulb) It is only necessary to click the Save button when a change is detected on the page. When a change has been made, a ‘ + ‘ character is displayed prior to the page name in the page title bar (light blue bar in the upper left corner of the page). Clicking Save reloads the page.

FieldsDescription
Created DateA non-editable text box to identify the Created Date & Time of the Transaction, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user.
DataDisplays the data of the record. This field is never editable.
ErrorDisplays the reason(s) that the file could not be successfully imported.  
Last ProcessedIdentifies the Date & Time that the file was last processed or attempted to be processed. This is a system assigned value and is never editable by a user.
Source IDIdentifies the unique identifier assigned by the source system for the file. This is a system assigned value but is editable.
Source SystemIdentifies the system or process that originated the files that is being imported. This is a system assigned value but is editable.
Status

Identifies the Status of the transaction. The Statuses that apply to transactions in this List View include:

  • New: The file has been submitted to the Inbound Queue, but no attempt has been made to import it. This is the first status assigned to all new files.
  • InProcess: A batch of records that contains this file is currently being processed. This is a temporary status, if any records are in this status for more than one minute contact NorthScope Support. 
  • Complete: The file was successfully processed. Successfully imported files are no longer visible in this list view. 
  • Error: The file contains one or more errors and cannot be imported. Files in this status must be manually updated to either 'Reprocess' or 'User Bypassed'.
  • Not Used: A manually set Status to indicate that the file should be removed. 
  • Reprocess: A manually set Status to indicate that the file should be re-evaluated the next time the Inbound Integration process runs. 
  • User Bypassed: A manually set Status to indicate that the file should no longer be evaluated (i.e., a subsequent file was imported so this one is no longer needed). 
TypeIdentifies the Transaction Type for each transaction. This displays the friendly name from the Inbound Supported Transactions table.

Related Topics

Inbound Integration List View

/wiki/spaces/HELP/pages/65276574

File Import User Guide


 Page Definitions

Page Definitions


 Technical Details

Technical Details


Table Names:
dbo.ERPx_INTEG_Inbound
Stored Procedures:
IQx_MFIntegInboundQueue
SPx_MFSEL_IntegInbound
SPx_MFSEL_IntegInboundHeader
SPx_MFUpdate_IntegInbound


  • No labels