...
Attached is an .txt sample file of a Check In Transactions Import File.
| Field | Type | Max | Required | Notes |
| Transaction Type | Varchar | 2 | Y | Must be set to CI for CHECKIN |
| Item Number or Barcode | Varchar | 20 | Y | Required either ItemNumber or Barcode |
| Quantity | Integer | 15 | Y | Required integer only |
| UOM | Varchar | 10 | N | Defaults to inventory quantity - future use |
| BRN / Batch-Serial# | Varchar | 50 | N | If left blank the UNTRACKED code is used (~) |
| LOT # | Integer | 5 | N | If left blank 0 is used |
| Expiry | Datetime | 15 | N | If left blank no expiry date is applied1 |
| LocationID | Varchar | 50 | Y | Location CardID (exact name of Location) to receive into |
| BinID | Varchar | 50 | N | If left blank the default Bin code is used (*) |
| DstLocationID | Varchar | 50 | I | Ignored, used for Transfers Only |
| DstBinID | Varchar | 50 | I | Ignored, used for Transfers Only |
| Reference | Varchar | 15 | N | If left blank CI-XXXX-XXXX format code is substituted |
| CheckInDate | Datetime | 15 | N | If left blank the current date is used1 |
| ContactID | Varchar | 20 | N | If left blank Location CardID is used |
| Username | Varchar | 20 | Y | User login identification |
| Comment | Varchar | 100 | N | |
1 Datetime format is dependent on your Regional settings either DD/MM/YYYY or MM/DD/YYYY e.g. 23/12/2010 or 12/23/2010 is acceptable.
...
| Page Properties |
|---|
|
| View file |
|---|
| name | ICXE-Integrator-Import-Specifications.pdf |
|---|
| height | 250 |
|---|
|
|
