| 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 |
General
Content
Integrations