| 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. |
| | | | | | | | |
Example Insert Statement:
INSERT INTO dbo.ERPx_INTEG_Inbound
([Created], [SourceSystem], [SourceTransID], [InboundStatusEN], [TransactionType], [Format], [Data])
Select Statement:
SELECT GETDATEVALUES( GETDATE(),
ABC[Your System Name' Here],
[Your Transaction Number 'XFR123587'Here],
1,
[Corresponding NorthScope Transaction 'IMTransfer'Type],
'XML',
[Your XML Data Here]
)