Imports TI ORDER - Revision history

Anw: Minor formatting change

2024-06-03T12:59:51Z

Minor formatting change

@@ Line 1: / Line 1: @@
 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.
@@ Line 12: / Line 8: @@
 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.
 {{Note}} Orders can only be added or deleted through this interface, not modified.
@@ Line 29: / Line 14: @@
 The format allows the following to be specified:
-Line Types, one of:
+The following record types can be specified:
 *	ORDER_AND_LINE - the first line
 *	LINE - subsequent lines for the same order
@@ Line 132: / Line 117: @@
 *	ITEM_AKA_CODE
 *	ITEM_PACK_COUNT

Anw: Minor formatting change

2024-05-17T10:23:24Z

Minor formatting change

← Older revision		Revision as of 12:23, 17 May 2024
Line 32:		Line 32:
	* ORDER_AND_LINE - the first line		* ORDER_AND_LINE - the first line
	* LINE - subsequent lines for the same order		* LINE - subsequent lines for the same order


	For ORDER_AND_LINE types, the following fields may be specified:		For ORDER_AND_LINE types, the following fields may be specified:
Line 111:		Line 112:
	* LN_ITEM_AKA_CODE		* LN_ITEM_AKA_CODE
	* LN_ITEM_PACK_COUNT		* LN_ITEM_PACK_COUNT


	For LINE types, the following fields may be specified:		For LINE types, the following fields may be specified:

Anw: Minor correction

2024-05-17T10:22:50Z

Minor correction

← Older revision		Revision as of 12:22, 17 May 2024
Line 23:		Line 23:
	* IMP_TI_ORDER_GEN_ITEMS - CSV Import - Generate order items from 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		* 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:		The format allows the following to be specified:

Anw: Initial Creation

2024-05-17T10:20:33Z

Initial Creation

New page

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

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