Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To check the system details of import the Status Report should be used.


CHECKIN CHECKOUT HEADERS and FIELDS

Table below Provides an overview of ICXE the transaction headers and a description on each field.

...

FieldTypeMaxRequiredNotes
Transaction TypeVarchar2YMust be set to CO for CHECKOUT
Item Number or BarcodeVarchar20YRequired either ItemNumber or Barcode
QuantityInteger15YRequired integer only
UOMVarchar10NDefaults to inventory quantity - future use
BRN / Batch-Serial#Varchar50NIf left blank the UNTRACKED code is used (~)
LOT #Integer5NIf left blank 0 is used
ExpiryDatetime15NIf left blank no expiry date is applied1
LocationIDVarchar50YLocation CardID (exact name of Location) to desptach from.
BinIDVarchar50NBin CardID (exact name of Bin) goods to be despatch from.
DstLocationIDVarchar50IIgnored, used for Transfers Only
DstBinIDVarchar50IIgnored, used for Transfers Only
ReferenceVarchar15NIf left blank CO-XXXX-XXXX format code is substituted
CheckInDateDatetime15NIf left blank the current date is used1
ContactIDVarchar20NIf left blank Location CardID is used
UsernameVarchar20YUser login identification
CommentVarchar100N 

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 2019 is acceptable. 


ERRORS and EXCEPTIONS

  1. If a Required field is missing the transaction group is skipped - an error log is written to SYSTEM STATUS REPORTER
  2. If a Duplicate Serial / Batch Number is scanned with incorrect EXPIRY DATE - an error log is written and EXPIRY DATE IGNORE
  3. If a field exceeds the specified CHAR WIDTH it will be truncated
  4. If CONTACT ID or LOCATION ID not found the transaction group is skipped.
  5. If ITEMCODE not found the transaction group is skipped.

View file
nameCheckOutTransactions.txt
height250

Related Information

None

...

hiddentrue

...

Importing Data Files