Imports Details - Revision history

Anw: Patch 48 SCR-CTMS-03557646-21 Non-working Days

2025-04-14T09:03:21Z

Patch 48 SCR-CTMS-03557646-21 Non-working Days

← Older revision		Revision as of 11:03, 14 April 2025
Line 457:		Line 457:
	** SCHED_ENG_ROUTE - optional - must be Y', 'N'		** SCHED_ENG_ROUTE - optional - must be Y', 'N'
	** PAR_RUN - optional - Inserts or updates the run number for Paragon for the route. Uses decodes "PAR_RUN"		** PAR_RUN - optional - Inserts or updates the run number for Paragon for the route. Uses decodes "PAR_RUN"
	** TRANSPORT_MODES - optional - delimited transport ~~mored~~ - superseded by record type TRANSPORT_MODE below		** TRANSPORT_MODES - optional - delimited transport mode - superseded by record type TRANSPORT_MODE below
			** BANK_HOLIDAY - optional - whether the route is considered a bank holiday route, which is not managed by external processes such as Paragon Strategic Planning for Fixed Drop Scheduling Engine. Values Y or N.

	* STOP - optional section		* STOP - optional section

Anw: Added BOOKING

2024-06-10T09:59:59Z

Added BOOKING

← Older revision		Revision as of 11:59, 10 June 2024
Line 61:		Line 61:
	== ASSET ==		== ASSET ==
	{{:Imports_ASSET}}		{{:Imports_ASSET}}


			== BOOKING ==
			This import can be used to create bookings in the system.

			The following record types may be specified:
			* BOOKING - the route header, the main import type.
			* BOOKINGS_ASN
			* BOOKINGS_MDD


			The following fields may be specified per record type:
			* BOOKING
			** BOOKING_REF
			** SOURCE_ID
			** DEST_ID
			** SCHED_NAME
			** PRODUCT
			** DU_TYPE
			** QUANTITY
			** CUSTOMER
			** COST_CENTRE
			** WEIGHT
			** VOLUME
			** SPECIAL_INSTRUCTIONS

			* BOOKINGS_ASN
			** ACTION
			** DU_QTY
			** ORIGINAL_QTY
			** WEIGHT
			** VOLUME
			** IDENTIFIER
			** SOURCE_SYSTEM
			** DEL_DATE
			** BOOKING_REF
			** PRODUCT_ITEM
			** DU_TYPE

			* BOOKINGS_MDD
			** ACTION
			** TO_LOC
			** BOOKING_REF
			** PRODUCT_ITEM
			** PRODUCT_DESCRIPTION
			** UOM
			** ORIGINAL_QTY
			** DEL_PRIORITY
			** HANDLING_CODE1
			** HANDLING_CODE2
			** HANDLING_CODE3
			** CARRIER_CODE
			** INSPECTION_REQ
			** TESTING_REQ
			** DU_TYPE
			** DU_QTY
			** IDENTIFIER
			** SOURCE_SYSTEM
			** DEL_DATE
			** COST_CENTRE_NAME
			** CUSTOMER
			** FROM_LOC

Anw: Added DRIVERS

2024-06-04T08:18:26Z

Added DRIVERS

← Older revision		Revision as of 10:18, 4 June 2024
Line 300:		Line 300:
	** If DECODE_NAME is CIST_CENTRE, then the target value must be a cost centre set up on the system.		** If DECODE_NAME is CIST_CENTRE, then the target value must be a cost centre set up on the system.
	* CUSTOMER_ID - optional - if provided, then this must be a customer set up on the system.		* CUSTOMER_ID - optional - if provided, then this must be a customer set up on the system.


			== DRIVERS ==
			This import allows users to upload basic drivers data into C-TMS. This import supports adding, modifying and deleting drivers. {{Note}} This has been superseded by the PERSON upload, which is more functional.

			The following fields may be specified:
			* ACTION - required - one of 'A'dd (default), 'M'odify, 'D'elete
			* ID - required - must exist for modifying and deleting, must not exist for adding.
			* SURNAME - required - must be less than 50 characters
			* FORENAME - required - must be less than 50 characters
			* JOB_TITLE - required - must be less than 50 characters, must exist as a person type in the system.
			* LOCATION_ID - required - must be less than 12 characters
			* CONTACT_NO - optional - must be less than 50 characters
			* INACTIVE - optional - one of 'Y', 'N'
			* AGENCY - optional - one of 'Y', 'N'
			* SMARTPHONE_ENABLED - optional - one of 'SMARTPHONE','MICROLISE','TOMTOM','EPOD'
			* EPOD_USERNAME - optional - must be less than 10 characters
			* TOMTOM_ENABLED - optional - one of 'Y', 'N'

Anw: Undo revision 7269 by Anw (Talk)

2024-06-04T08:12:46Z

Undo revision 7269 by Anw (Talk)

← Older revision		Revision as of 10:12, 4 June 2024
Line 1:		Line 1:
	The following is a summary of the usage of some imports configurable in the system.		The following is a summary of the usage of some imports configurable in the system.


	~~== Notes ==~~
	On length restrictions: The import fields have strict restrictions noted against them, such as particular values, formats, lengths, etc. As any field can be decoded through a decode table entry, this restriction applies to the ''decoded'' value. If there is no decode, then the data you attempt to upload ''must'' abide by the stated restrictions, otherwise the system will reject the data.

	~~Similarly, data can be modified through formulae, amending the data supplied. Any fields which apply formulas will have the restrictions applied to the ''transformed'' data.~~

Anw: Added details of data validation wrt decode and formulae.

2024-06-04T08:08:59Z

Added details of data validation wrt decode and formulae.

← Older revision		Revision as of 10:08, 4 June 2024
Line 1:		Line 1:
	The following is a summary of the usage of some imports configurable in the system.		The following is a summary of the usage of some imports configurable in the system.


			== Notes ==
			On length restrictions: The import fields have strict restrictions noted against them, such as particular values, formats, lengths, etc. As any field can be decoded through a decode table entry, this restriction applies to the ''decoded'' value. If there is no decode, then the data you attempt to upload ''must'' abide by the stated restrictions, otherwise the system will reject the data.

			Similarly, data can be modified through formulae, amending the data supplied. Any fields which apply formulas will have the restrictions applied to the ''transformed'' data.

Anw: Added SCHED_RULES

2024-06-04T07:47:39Z

Added SCHED_RULES

← Older revision		Revision as of 09:47, 4 June 2024
Line 649:		Line 649:
	* ORIGIN_PORT - optional - if provided, must be 20 characters or less		* ORIGIN_PORT - optional - if provided, must be 20 characters or less
	* COST_CENTRE_NAME - optional - if provided, must be 20 characters or less, must exist in the system		* COST_CENTRE_NAME - optional - if provided, must be 20 characters or less, must exist in the system


			== SCHED_RULES ==
			This import allows users to upload Scheduling rules data into C-TMS. This import supports adding and updating schedule rules.

			The following fields may be specified:
			* COST_CENTRE - required - must be present as a cost centre in the system.
			* CUSTOMER - required - must be present as a customer in the system.
			* RULE_NAME - required - must be less than 40 characters.
			* CUTOFF - required - time format.
			* OFFSET - required - numeric
			* EARLY_TIME - required - time format.
			* LATE_TIME - required - time format.
			* SERVICE_LEVEL - required - must be a valid service level in the system.
			* OFFSET_COLLECTION - required - numeric
			* FROM_ZONE - required - must be a valid zone in the system.
			* TO_ZONE - required - must be a valid zone in the system.
			* TRANSPORT_MODE - required - must be a valid transport mode in the system.
			* EXC_SCHED_ENG - required - one of 'Y', 'N'


			Further configuration:
			{\| class="wikitable" border="1"
			\|- bgcolor="silver"
			!Parameter !! Description !! Level
			\|-
			\| ALLOW_SAME_DAY_DELIVERY \|\| Customer flag. Controls whether the cutoff is updated on the schedule rule (if Y, then not updated) \|\|ORG_CUSTOMER
			\|}

Anw: Added WMS_PRODUCT

2024-06-03T16:26:45Z

Added WMS_PRODUCT

← Older revision		Revision as of 18:26, 3 June 2024
Line 757:		Line 757:
	** CARRIER_ID - required - must exist as a carrier in the system.		** CARRIER_ID - required - must exist as a carrier in the system.
	** CARRIER_INACTIVE - 'Y','N'		** CARRIER_INACTIVE - 'Y','N'


			== WMS_PRODUCT ==
			This import allows users to upload WMS Product cross-reference data into C-TMS. Note that this is bespoke and used for Brexit export processes only.

			The following fields may be specified:
			* PRODUCT_ID - required
			* CATEGORY
			* COO_CODE
			* TARIFF_EU
			* TARIFF_UK
			* UNITS_PER_CASE
			* PACKAGING_TYPE
			* PACKAGE_COST
			* VAT_RATE
			* CURRENCY
			* MEURSING_CODE
			* GROSS_UNIT_WEIGHT
			* EXCISE_CODE
			* NET_CASE_WEIGHT
			* DGN_PRODUCT_CODE
			* QUOTA_NUMBER
			* PHARMACEUTICAL_ANNEX
			* DESCRIPTION

Anw: Added TYRES

2024-06-03T16:24:12Z

Added TYRES

← Older revision		Revision as of 18:24, 3 June 2024
Line 709:		Line 709:
	* TRACKING_ENABLED - one of 'ISOTRAK', 'TOMTOM', 'MICROLISE'		* TRACKING_ENABLED - one of 'ISOTRAK', 'TOMTOM', 'MICROLISE'
	* COST_CENTRE_NAME		* COST_CENTRE_NAME


			== TYRES ==
			This import allows users to upload Tyres cross-reference data into C-TMS. This import supports adding and updating tyre details. Note that this is bespoke for Fleet Maintenance processes only.

			The following fields may be specified:
			* PRODUCT_ID - required
			* CATEGORY - required - one of NON-TYRE, RETAIL, VEH_SERV, REM_SERV, TYRE, SERV_ITEMS, CHARGE
			* DESCRIPTION - optional
			* MANUFACTURER - optional
			* BRAND - optional
			* MODEL - one of AGRI, TRAILER, TRUCK, VAN, RIGID, TRACTOR, CAR
			* PRODUCT_SIZE - tyre size, minus slash and R e.g. 38565225
			* RADIUS - the diameter of the tyre
			* PLY - optional
			* PATTERN - optional
			* SPEED_RATING - optional
			* LOAD_INDEX - optional
			* PROD_TYPE_ID - required - must be configured as a product type in the system.
			* CLASSIFICATION - one of AGRI, TRAILER, TRUCK, VAN, RIGID, TRACTOR, CAR

Anw: Added CUST_FLEET

2024-06-03T16:14:33Z

Added CUST_FLEET

← Older revision		Revision as of 18:14, 3 June 2024
Line 231:		Line 231:
	* MU_ID - optional - must be 50 characters or less		* MU_ID - optional - must be 50 characters or less
	* FACILITY_ID - optional - must be 50 characters or less		* FACILITY_ID - optional - must be 50 characters or less


			== CUST_FLEET ==
			This import allows users to upload Customer Fleets into C-TMS. This allows creation of updating of details. Note that this is specific to Fleet Maintenance users (Bespoke)

			The following fields may be specified:
			* CUSTOMER_ID - required - must exist as a customer
			* REG_FLEET_NUMBER - required
			* CURRENT_LOCATION_ID - required - must be a location for the customer, must be type BRANCH or INV, must be active
			* INACTIVE - required - one of 'Y', 'N'
			* VEHICLE_TYPE - required - one of 'TRACTOR', 'TRAILER', 'RIGID', 'CAR', 'VAN', 'AGRICULTURAL'
			* AXLE_CONFIG - required - must be a valid axle config in the system.
			* MAKE - optional
			* MODEL - optional
			* LAST_INSPECTION_DATE - optional
			* ODO - optional
			* LAST_POSITION - optional
			* LAST_POSITION_DATE - optional
			* LAST_POS_TIME - optional
			* LAST_POSITION_TIME - optional
			* AXLE_1_SIZE - optional
			* AXLE_2_SIZE - optional
			* AXLE_3_SIZE - optional
			* AXLE_4_SIZE - optional
			* AXLE_5_SIZE - optional
			* AXLE_1_PSI - optional
			* AXLE_2_PSI - optional
			* AXLE_3_PSI - optional
			* AXLE_4_PSI - optional
			* AXLE_5_PSI - optional
			* AXLE_1_PRODUCT_ID - optional
			* AXLE_2_PRODUCT_ID - optional
			* AXLE_3_PRODUCT_ID - optional
			* AXLE_4_PRODUCT_ID - optional
			* AXLE_5_PRODUCT_ID - optional
			* AXLE_1_TREAD_DEPTH - optional
			* AXLE_2_TREAD_DEPTH - optional
			* AXLE_3_TREAD_DEPTH - optional
			* AXLE_4_TREAD_DEPTH - optional
			* AXLE_5_TREAD_DEPTH - optional

Anw: Added CUSTOMER

2024-06-03T16:01:35Z

Added CUSTOMER

← Older revision		Revision as of 18:01, 3 June 2024
Line 154:		Line 154:
	* USAGE_VALUE - required, must be 12 characters or less, must be valid data in the system matching the usage type provided.		* USAGE_VALUE - required, must be 12 characters or less, must be valid data in the system matching the usage type provided.
	* CCY_CODE - required, must be 3 characters or less, must be a valid currency in the system.		* CCY_CODE - required, must be 3 characters or less, must be a valid currency in the system.


			== CUSTOMER ==
			This import allows addition, modification or deletion of customers data in the system.

			The following fields may be specified:
			* ACTION - required - one of 'A'dd (default), 'M'odify, 'D'elete
			* CUSTOMER_ID - required - must be 12 characters or less
			* CUSTOMER_NAME - optional - must be 50 characters or less
			* CONTACT_NAME - optional - must be 50 characters or less
			* LOCATION_ID - optional - must be 12 characters or less, must exist as a location in the system.
			* MTM_CUST_CODE - optional - must be 2 characters or less
			* CUST_GROUP - optional - must be 12 characters or less, must exist as a customer group in the system
			* COST_CENTRE_NAME - optional - must be 12 characters or less, must exist as a cost centre in the system
			* VAT_COUNTRY - optional - must be 3 characters or less, must exist as a country in the system
			* VAT_REG_NO - optional - must be 50 characters or less
			* COUNTRY - optional - must be 3 characters or less, must exist as a country in the system
			* TYPE - optional - one of 'CUSTOMER', 'BILLING_UNIT', 'BUYER', 'SUPPLIER'
			* LATE_ORDER_DAYS_THLD, optional - numeric
			* INT_ORD_TO_LOGNET - optional - one of 'Y', 'N'
			* UNISON_IF_VALUE - optional - must be 3 characters or less
			* TOK_POD_AVAIL - optional - one of 'Y', 'N'
			* CONSOLIDATE_ORDERS - optional - one of 'Y', 'N'
			* CONSOL_ALLOC_METHOD - optional - one of 'WEIGHT','RPE'
			* ORD_REV_CHRG_TYPE_ID - optional - numeric, must exist in the system as a charging mechanism.
			* LOTS_INSTALLED - optional - must be 12 characters or less
			* LATE_DEL_MINS_THRLD - optional - numeric
			* ORDER_LINE_CONTRACT - optional - one of 'Y', 'N'
			* SEND_ORD_MSG - optional - one of 'Y', 'N'
			* HIDE_ALL_ACTUALS - optional - one of 'Y', 'N'
			* ALLOW_MANUAL_RPE - optional - one of 'Y', 'N'
			* UPDATE_TO_DELIVER - optional - one of 'Y', 'N'
			* ORDER_REASON_CODE - optional - one of 'Y', 'N'
			* ITEM_REASON_CODE - optional - one of 'Y', 'N'
			* LATE_REASON_CODE - optional - one of 'Y', 'N'
			* USE_ALTERNATIVE_ITEM - optional - one of 'Y', 'N'
			* TRIP_DEBRIEF_LEVEL - optional - one of 'Off', 'Items Only', 'Line Only', 'Line and Items'
			* EARLY_DEL_MINS_THRLD - optional - numeric
			* TRIP_CONF_VALIDATION - optional - one of 'Y', 'N'
			* NO_MIN_COLLECTION - optional - one of 'Y', 'N'
			* VALIDATE_PROD - optional - one of 'Y', 'N'
			* EFX_SITE - optional - must be 40 characters or less
			* AUTO_SCHED_EXCLUDE - optional - one of 'Y', 'N'
			* AUTO_PLANNING - optional - one of 'Y', 'N'
			* CALC_RPE - optional - one of 'Y', 'N'
			* ENABLE_EPOD - optional - one of 'Y', 'N'
			* PROCESS_SCAN_ITEMS - optional - one of 'Y', 'N'
			* AIR_MODE - optional - numeric less than 99999
			* ROAD_MODE - optional - numeric less than 99999
			* LABEL_FORMAT - optional - one of 'Z','P'
			* ORDER_HDR_CONTRACT - optional - one of 'Y', 'N'
			* DEDICATED_CARRIER - optional - if provided, must be a carrier in the system.
			* AR_ITEM_CONTENT_TYPE - optional - one of 'ITEM','CLAIM'
			* AR_LABEL_REQ - optional - one of 'Y', 'N'
			* AR_LABEL_FORMAT - optional - one of 'AAM','BMW'
			* AR_ITEM_LABEL_REQ - optional - one of 'Y', 'N'
			* AR_ITEM_LABEL_FORMAT - optional - one of 'AAM','BMW'
			* AR_MANIFEST_REQ - optional - one of 'Y', 'N'
			* AR_MANIFEST_FORMAT - optional - one of 'AAM','BMW'
			* PICK_QTY_REQ - optional - one of 'Y', 'N'
			* SUPP_DOC_FORMAT - optional - one of 'SD1','SD2','SD3','SD4','SD5','SD6'
			* MIN_OWN_DRY_ICE - optional - numeric
			* MIN_DRY_ICE - optional - numeric
			* MIN_TAILGATE - optional - numeric
			* MIN_LABOUR - optional - numeric
			* CHG_PACKAGE - optional - one of 'Y', 'N'
			* CHG_DRYICE - optional - one of 'Y', 'N'
			* CHG_WETICE - optional - one of 'Y', 'N'
			* SEND_ALC_MSG - optional - one of 'Y', 'N'
			* SEND_MAR_MSG - optional - one of 'Y', 'N'
			* SEND_LOA_MSG - optional - one of 'Y', 'N'
			* SEND_WMS_LOAD_MSG - optional - one of 'Y', 'N'
			* SEND_WMS_DESP_MSG - optional - one of 'Y', 'N'
			* SEND_WMS_UNLOAD_MSG - optional - one of 'Y', 'N'
			* SHIPMENT_CUST_ID - optional - must be 50 characters or less
			* MU_ID - optional - must be 50 characters or less
			* FACILITY_ID - optional - must be 50 characters or less