Inbound Integration (XML)

Column	Datatype	For Use By Integrator	Required	Description	Example
InboundSK	BIGINT			NorthScope internal use
Created	DATETIME			Date/Time column used for timestamp of integration.
LastProcessed	DATETIME			NorthScope internal use
SourceSystem	VARCHAR(25)	Yes	Yes	Character field used to identify the integrator. Must be a valid value.	ABC System Name
SourceTransID	VARCHAR(25)	Yes	No	Character field that the integrator can use to identify their transaction.	XFR123587
InboundStatusEN	INT			Enumeration field used to track the status of the record. (Defaults to 1 which is New)
TransactionType	VARCHAR(25)	Yes	Yes	Character field used to identify the transaction type of the record.	IMTransfer
Format	VARCHAR(10)	Yes	Yes	Character field used to identify the format of the incoming data.	XML
Data	VARCHAR(MAX)	Yes	Yes	Character field to hold the actual data sent across.
ErrorText	VARCHAR(MAX)			NorthScope internal use
OutputText	VARCHAR(MAX)			NorthScope internal use
CompanyID	VARCHAR(20)			NorthScope internal use
LastUser	VARCHAR(110)			NorthScope internal use

Example Insert Statement:

INSERT INTO dbo.ERPx_INTEG_Inbound
([Created], [SourceSystem], [SourceTransID], [InboundStatusEN], [TransactionType], [Format], [Data])

VALUES( GETDATE(),
       [Your System Name Here],
       [Your Transaction Number Here],
       1,
       [Corresponding NorthScope Transaction Type],
       'XML',
       [Your XML Data Here]
      )