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] )