| Column | Datatype | For Use By Integrator | Required | Description | Example |
|---|
| InboundSK | BIGINT |
| | | | |
|
| Date/Time column used for timestamp of integration. |
| |
|
| 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. |
| | | | |
|
| CompanyID | VARCHAR(20) |
|
| NorthScope internal use |
| | LastUser | VARCHAR(110) |
|
| 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]
)