dms translator and interface

DMS Translator and U2K2 interfaces

CanhTH - 2012

Agenda

U2K2 interfaces

DMS Translator

2© Copyright 2011 FPT Software

Primary Invoice


Start

Distributor server

SAP ECC

DMS HUB

Finish

Purchase Order

Maintenance

Receipt / Invoice Entry

Primary invoice report

XML file

XML file sending by DFT

Import by Translator

Manually or Auto PO

Manually or Auto PO

HPC Product Master


Distributor Server

SAP

DMS HUB

Solomon database

HO server

HO Solomon database

Manually

Update Price3 XML file contain:- Product master- Price master- Hierarchy

DMS-OB-01by DFT HO

Import by Product Tool

Upload by DFT Client

Verify product before exporting patch

Patch download by DFT Client

Import patch by DMS Translator

IC Product Master


Inbox folder on IC server

SAP

DMS HUB

Solomon database

Inbox folder on IC server

IC HO Solomon database

Manually

Update Price3 XML file contain:- Product master- Price master- Hierarchy

DMS-OB-01by DFT HO

Import by Product Tool

Verify product before exporting patch

Import patch by DMS Translator

IC Customer master Maintenance


SAP

DMS HUB

IC server

IC Solomon database

Ready for

transaction

2 interfaces:- Customer master- Customer hierarchy

DMS-OB-38DMS-OB-37

Import by DMS Translator

Imported sequence:1. Customer master (DMS-OB-38)2. Customer hierarchy (DMS-OB-37)

Secondary interfaces to SAP


# Interface ID Interface name Data Type

1 DMS-IB-01 Outlet master with hierarchy assignment Master

2 DMS-IB-13 Salesman master Master

3 DMS-IB-14 PJP Master Master

4 DMS-IB-35 Salesman-Planned Outlets Master

5 DMS-IB-02 Sales Invoice Transaction

6 DMS-IB-10 Distributor Inventory Transaction

7 DMS-IB-10V SNC Stock Available Transaction

8 DMS-IB-11 Stock Receipt Transaction

9 DMS-IB-21 Purchase Order (HPC EDI Orders) Transaction

10 DMS-IB-33 Credit Note (adjustment) Transaction

11 DMS-IB-37 Return Invoice Transaction

12 DMS-IB-49 VISMIN MT transaction (Consignment) Transaction

13 DMS-IB-50 Original order for CCFOT Transaction

14 DMS-IB-51 secondary POD for CCFOT Transaction

Secondary interfaces to SAP


SAP

DMS HUBSolomon database

Distributor daily

operation

- Master data maintenance- Daily transaction

Daily schedule export by DMS Translator

Daily schedule pre-defined by DMS HUB (DMS-OB-36) Data verification at DMS HUB

Data transition by DFT

CCS

Master data maintenance


#Interface

ID Interface name Data Type

1 DMS-IB-01Outlet master with hierarchy assignment to DMS HUB -> BW Master

2 DMS-IB-13 Sales-man master to DMS HUB -> BW Master

3 DMS-IB-14 PJP Master (sales route) -> DMSHUB -> BW Master

4 DMS-IB-35Salesman-Planned Outlets (Visit plan) -> DMSHUB -> BW Master



Valid Term

Correct assigned ClassID to determine which Site customer belongs to



Correct SiteID where customer is served

01, 11, 21, 31, 41 …



Outlet must have at least on active shipto

All hierarchy level must be assigned



PJP inclusive

PJP and salesman assignment

SiteID: Van site that customer to be served: 03, 13, 23, 33, …



PJP generation every month

Transaction interfaces


# Interface ID Interface name Data Type

1 DMS-IB-02 Sales Invoice (2nd sales) Transaction

2 DMS-IB-10 Distributor Inventory Transaction

3 DMS-IB-10V SNC Stock Available Transaction

4 DMS-IB-11 Stock Receipt Transaction

5 DMS-IB-21 Purchase Order (HPC EDI Orders) Transaction

6 DMS-IB-33 Credit Note (adjustment) Transaction

7 DMS-IB-37 Return Invoice (2nd return) Transaction

8 DMS-IB-49 VISMIN transaction (Consignment) Transaction

9 DMS-IB-50 Original order for CCFOT (2nd order) Transaction

10 DMS-IB-51 secondary POD for CCFOT (2nd POD) Transaction

Secondary invoices


DMS-IB-50

DMS-IB-02

DMS-IB-51

DMS-IB-37

DMS-IB-50

DMS-IB-02

DMS-IB-51

DMS-IB-37

Non - CSLR customerCSLR customer

Secondary Invoices


DMS-IB-50 (Original Order)

Extract CSLR customer order (SO,RI) after picking list (status G,F,I,C)

DMS-IB-02 (Sales Invoices)

Extract Order (SO,RI, VI, VP, DM, DN, RC, RD, RE) with status C

DMS-IB-51 (Secondary POD)

Extract CSLR customer invoices information

Invoice must be updated receipt date and Reason of Delay on Document maintenance screen

After 7 days of invoice’s RDD, Translator will auto update

Receipt Date = RDD date + 1

Reason code = Default Reason code

and extract data to DMSHUB for un-updated invoices

Secondary Invoices


DMS-IB-37 (Return Invoices)

Extract return invoice details (CM,CN,RM,RN) with “original invoice number with status C

This two lines will be extracted for DMS-IB-37

Secondary Transaction interfaces


DMS-IB-33 (Credit Note)

Extract return invoice details (CM,CN,RM,RN) without “original invoice number with status C

This two lines will be extracted for DMS-IB-33



DMS-IB-49 (MT Consignment)

Extract order (order-type MT) of MT customer (status C)

MT customer should have ID’s length = 3 and ID convention like ‘ZV%’ or ‘ZX%’

DMS-IB-21 (Purchase Order)

Extract PO (Status O: Open Order) with PO Date from current date back to previous date defined by parameter

DMS-IB-11 (Stock receipt)

Extract completed SR (Status Completed) under PC UOM

SR must have valid primary invoice number



DMS-IB-10 (Distributor Inventory)

Extract stock on-hand quantities, it doesn’t deduct the invoice’s quantities (belongs to uncompleted order)

Stock = Stock on hand

DMS-IB-10V (SNC Stock Available)

Extract available quantities, deduct the invoice’s quantities (belongs to uncompleted order)

Stock Available = Stock on hand – Qty on uncompleted orders

Agenda

U2K2 interfaces

DMS Translator


Translator service configuration (HPC)


C:\Program Files\Fsoft\DMS Translator service

Translator service configuration (IC)


C:\Program Files\Fsoft\DMS Translator service

Translator Tool configuration


…\<Solomon installation folder>\DMS

Translator configuration


HPC: default = admin

ICE: windows remote account

Server name or IP address of server contain DT SQL database

DT database name on DBServer

Correct DT code and sales org for database



Pre-defined schedule for distributor database:

- Nextrun: next schedule

- Isauto: 1 (Yes) 0 (No)

- DistributorID: used to compare with DT_ID on database_mapping table



Multi-site set up for U2K2 interfaces

Application DB key parameters, used to verify with database_mapping table (CentralDB)

Translator working model


Solomon DBs

Translator service

Connect to application database and

import/export data

Centraldbfpt_dmshub_interface_schedule

Get SoldTo, SalesOrg

Centraldbfpt_dmshub_database_mappingGet database to

access



Solomon DBs

TranslatorConnect to Solomon table and get data

Translator baselinedtable

Save exported dataExport new

data

DMSHUB



Solomon DBs

Translator

Connect to Translator table and get data

Translator baselinedtable

Export old data

DMSHUB

Translator baselined Tables


Table name Description

FPT_DMSHub_BaseLined_OutletMaster Store Outlet master data

FPT_DMSHub_BaseLined_CreditNoteDetail Store detail of Credit Note

FPT_DMSHub_BaseLined_CreditNoteHeader Store header of Credit Note

FPT_DMSHub_BaseLined_DistributorInventory Store Distributor Inventory Stock

FPT_DMSHub_BaseLined_StockAvailable_SNC Store Stock Available

FPT_DMSHub_BaseLined_PJPMaster Store PJP master

FPT_DMSHub_BaseLined_ReturnInvoiceDetail Store Detail of Return Invoice

FPT_DMSHub_BaseLined_ReturnInvoiceHeader Store Header of Return Invoice

FPT_DMSHub_BaseLined_SalesInvoiceDetail Store Detail of Sales Invoice

FPT_DMSHub_BaseLined_SalesInvoiceHeader Store Header of Sales Invoice

FPT_DMSHub_BaseLined_SalesmanMaster Store Salesman master

FPT_DMSHub_BaseLined_SalesmanPlanedOutlet Store PJP Planed data



FPT_DMSHub_BaseLined_StockReceiptDetail Store Detail of Stock Receipt

FPT_DMSHub_BaseLined_StockReceiptHeader Store Header of Stock Receipt

FPT_DMSHub_BaseLined_ConsignmentDetail Store Detail of MT Consignment

FPT_DMSHub_BaseLined_ConsignmentHeader Store Header of MT Consignment

FPT_DMSHub_BaseLined_OriginalOrderDetail Store Detail of OriginalOrder

FPT_DMSHub_BaseLined_OriginalOrderHeader Store Header of OriginalOrder

FPT_DMSHub_BaseLined_PODDetail Store Detail of secondary POD

FPT_DMSHub_BaseLined_PODHeader Store Header of secondary POD

FPT_DMSHub_BaseLined_PurchaseOrderDetail Store Detail of PurchaseOrder

FPT_DMSHub_BaseLined_PurchaseOrderHeader Store Header PurchaseOrder



FPT_DMSHub_Interface List of Interfaces to be used by distributor

FPT_DMSHub_Interface_Schedule Exported Schedule for interfaces

FPT_DMSHub_Interface_Tracking Tracking error when import/export data

FPT_DMSHub_Interface_Error_Tracking Detail of error tracking when import/export data

FPT_DMSHub_PARAMETERList of parameters of distributor (Distributor ID sales org …)

FPT_DMSHub_BaseLined_MotherOrderDetail Store detail of Mother Order

FPT_DMSHub_BaseLined_MotherOrderHeader Store header of Mother Order

FPT_DMSHub_BaseLined_BabyOrderDetail Store detail of Baby Order

FPT_DMSHub_BaseLined_BabyOrderHeader Store header of Baby Order

dms translator and interface

Technology