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