XFM0012

This screen is used to dictate which package is called for each flow. The package id field is user definable, but the ‘Package SQL Code’ is predetermined by the package format.

Once you have entered the package id and the package SQL code, you must then specify whether it is an inbound or outbound flow.

Field Name	Description	Options	Generic Value
Package Id **	The unique identifier for this message type – note, you will need to remember this for further setup	10 character free text field	Defined by the client
Inbound/Outbound/Local **	Specifies whether the message is an inbound or an outbound flow (note, ‘local’ is not used for current WMS implementations)	Check box	Defined by the message type
Package SQL Code **	The programming instruction to determine which package the EDI will call	Defined by the hard coding of the program	Defined by the message type

Command Values

Below is a table of the current commands

NB these will increase as new messages are added to the system as required

Package Id (User Definable)	Inbound or Outbound	Package SQL Statement
Standard Client Message Types
Despatch Message	Outbound	dp_edigen_out_pdp_conf.write_flat_file
Stock Master Upload	Inbound	dp_edigen_product_master_load.read_file_format
Sales Order Upload	Inbound	dp_edigen_sales_order_load.read_sales_order_file
GRMK – Receipt Message	Outbound	dp_edigen_out_receipt_confirm.process_out_recp_confirm
Pre Advice or ASN Message	Inbound	dp_edigen_pre_advice_load.read_file_format
Hold or Release Message	Inbound	dp_edigen_hold_load.read_file_format
Acknowledgement of Hold Release Message	Outbound	dp_edigen_out_ack.write_flat_file
Purchase Ordering	Outbound	dp_edigen_out_pop.write_flat_file
Courier Returns and Collection	Outbound	dp_edigen_retcoll.write_file
Standard Stock Inventory Balance (Requires two packages to be run)	Outbound	dp_edigen_out_st_bal.generate_data (populates temporary tables) -dp_edigen_out_st_bal.write_flat_file (writes the file)
Stock inventory balance by Rotation Only requires one package	Outbound	dp_edigen_out_strot_bal.write_file (This writes a ‘SROL’ record, which is a single level rotation based snapshot)
Stock Snapshot (Include both customer and system rotations and SAP storage locations)(F/S 230465)	Outbound	Additional rotation level dp_edigen_out_st_bal.generate_detail_data dp_edigen_out_st_bal.write_flat_file_dtl This process writes a SD01 and SD02 lines – the SD02 record is a rotation level record.

Carrier Interface Messages

Package Id (User Definable)	Inbound or Outbound	Package SQL Statement
CANC – Cancelled Orders	Outbound	cim_outbound.write_canc_file
CICA – Post Allocation	Outbound	cim_outbound.write_cioc_cica_file
CICD – Pre – Allocation	Inbound	dp_cim_inbound.read_cicd_file_format
CIOC – Order Entry Information	Outbound	cim_outbound.write_cioc_cica_file
CIPD – Packing Information	Outbound	cim_outbound.write_cipd_file
CITD – Despatch Confirmation	Inbound	dp_cim_inbound.read_file_format
PODC – IE Specific POD confirmation	Outbound	cim_outbound.write_podc_file
CARR – Carrier Collection Message	Outbound	dp_edigen_out_carr_conf.write_flat_file

Configurable EDI Inbound

EDI Structure	Description	Package SQL Statement
CUSTOMER	Customer detail upload	dp_conf_edi_in.read_edi_cust_file_format
MED_TRANSLATION	(Client specific) - Medical and serial translation	dp_conf_edi_in.med_seq_xfm
OMS_POST_WHS	(Client specific) OMS Postcode/Warehouse Upload	dp_conf_edi_in_oms.load_oms_pc
STKBASEUPL	Stock Base Sell upload/update	dp_conf_edi_in.stk_base_sell_xfm
STK_LOCATION	Stock Location upload	dp_conf_edi_in.stock_locations_xfm
STK_WAREHOUSE	Stock Warehouse	dp_conf_edi_in.stock_warehouse_xfm
STOCK	Stock Upload	dp_conf_edi_in.read_edi_prod_mast_format
STOCK_REGION	Stock Region upload/update	dp_conf_edi_in.stock_region_xfm
STOCK_UOM	Stock UOM upload	dp_conf_edi_in.stk_uom_xfm
STOCK_UPDATE	Stock update	dp_conf_edi_in.stock_update_xfm
SUPPLIER	Supplier detail upload
WLE	Dynamic Stock Upload	dp_conf_edi_in.read_edi_wle
WLE Held Stock	Dynamic Held Stock Upload	dp_conf_edi_in.wle_held_stock_xfm

Outbound

EDI Structure	Description	Package SQL Statement
Adjustments	Outbound	dp_conf_edi_out.produce_dyn_edi_files
Outbound Order Information	Outbound	?
Stock Inventory Balances	Outbound	?

FTP Packages

EDI Structure	Description	Package SQL Statement
FTP Inbound	Inbound	dp_process_control_xfm.ftp_inbound
FTP Outbound	Outbound	dp_process_control_xfm.ftp_outbound