Imports TI ORDER

There are many Import types – this guide covers the complete CSV Order Import TI_ORDER.

Creating Import Formats

The Import functionality will be used to upload selective master data into C-TMS during the initial implementation. It will also be used to upload Manifests from Suppliers. Each import is defined by a template created in the Imports section. More details on creation of imports can be found in the Imports page.

Each template defines each data field and its position within the uploaded data file. Fixed common values can be specified rather than including all the mandatory fields within the data file.

In order to conform to the CSV upload process in use by C-TMS, the initial line of each order must be configured with a line type of "ORDER_AND_LINE", and each subsequent line for the order configured with a line type of "LINE".

It is expected that there will be a CSV import template created for each customer, with certain defaults set against it, such as the customer itself and the location from which the product is to be collected.

Further Configuration

There are C-TMS configuration elements that control functionality within the Import itself:

• SCH_SCHED_ORD_IMP_TI_ORDER_SCHED_DATE_OVERRIDE - When Importing TI_ORDER data, can the sched_date be over-written by the SCH_SCHED_ORD_DERIVE rule?
• IMP_TI_ORDER_GEN_LOC - CSV Import - Location Name generation by Post Code
• IMP_TI_ORDER_DEFAULT_DU - CSV Import - Default DU Type Method
• IMP_TI_ORDER_CALC_WEIGHTS - CSV Import - Calculate weights from dims(Y=X*Y*Z/6000)
• IMP_TI_ORDER_REVENUE_LIMIT - CSV Import -Pre-call above revenue limit (Numeric Limit).0 means no pre-call
• IMP_TI_ORDER_CHECK_SMS - CSV Import - Check contact numbers can be used as SMS numbers
• IMP_TI_ORDER_QTY_ADD - CSV Import - Add line qty
• IMP_TI_ORDER_GEN_ITEMS - CSV Import - Generate order items from Qty
• IMP_TI_ORDER_REVENUE_LIMIT - CSV Import -Pre-call above revenue limit (Numeric Limit).0 means no pre-call

Note: Orders can only be added or deleted through this interface, not modified.

The format allows the following to be specified:

Line Types, one of:

• ORDER_AND_LINE - the first line
• LINE - subsequent lines for the same order

For ORDER_AND_LINE types, the following fields may be specified:

• SPECIAL_INSTR
• BOOKING_REF
• ACTION
• EXT_REF
• SCHED_DATE
• CUSTOMER
• COST_CENTRE
• DEL_TYPE
• FRLOC_NAME
• FRLOC_TYPE
• FRLOC_ADDR1
• FRLOC_ADDR2
• FRLOC_ADDR3
• FRLOC_TOWN
• FRLOC_CNTY
• FRLOC_CNTRY
• FRLOC_C_CODE
• FRLOC_PCODE
• FROM_LOC
• TOLOC_NAME
• TOLOC_TYPE
• TOLOC_ADDR1
• TOLOC_ADDR2
• TOLOC_ADDR3
• TOLOC_TOWN
• TOLOC_CNTY
• TOLOC_CNTRY
• TOLOC_PCODE
• TOLOC_C_CODE
• TO_LOC
• EARLY_AVAIL
• LATE_AVAIL
• EARLY_DEL
• LATE_DEL
• SHIP_REF
• GROUP_NAME
• PRODUCT
• DU_TYPE
• QTY
• WEIGHT_KG
• VOL_CU_M
• FINAL_TO
• ORIG_FROM
• ORD_COMMENTS
• REC_TYPE
• QTY_IN_CASES
• DEL_POINT_REF
• ITEM_ID
• WMS_ORD_REF
• MSG_MEDIUM
• RECIPIENT_SMS
• RECIPIENT_SMS2
• RECIPIENT_SMS3
• RECIPIENT_SMS4
• RECIPIENT_EMAIL
• UN_NUMBER
• HAZARD_DESC
• HAZARD_QTY
• SERVICE_LEVEL
• CARRIER_ID
• LOC_FROM_ADDRESSEE
• LOC_TO_ADDRESSEE
• LOC_FROM_ADDRESSEE
• LOC_TO_ADDRESSEE
• LIFTS
• OVERSIZE
• FROM_LOC_CHILD
• TO_LOC_CHILD
• CONTAINER_NO
• DEL_PRIORITY
• ORD_ROUTE_CODE
• LN_HEIGHT
• LN_WIDTH
• LN_LENGTH
• LN_ITEM_DESCRIPTION
• LN_ITEM_AKA_CODE
• LN_ITEM_PACK_COUNT

For LINE types, the following fields may be specified:

• LINE_DU_TYPE
• LINE_PRODUCT
• LINE_QTY
• LINE_WEIGHT_KG
• LINE_VOL_CU_M
• LINE_QTY_IN_CASES
• LINE_ITEM_ID
• LINE_UN_NUMBER
• LINE_HAZARD_DESC
• LINE_HAZARD_QTY
• LINE_LIFTS
• LINE_HEIGHT
• LINE_WIDTH
• LINE_LENGTH
• ITEM_DESCRIPTION
• ITEM_AKA_CODE
• ITEM_PACK_COUNT