...
| 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:
...