Typical X12/EDIFACT/SAP Idoc mapping: transportation stages in logistics

NPA & BLOCKCHAIN Solution

Bank credit is an important source of finance for the industries. Total bank credit has grown from Rupees 5.47 billion in March 1951 to Rupees 78,414.66 billion in March 2017. Bank credit to industry (medium and large) has increased from Rupees 82.69 billion in 1980 to Rupees 23,102.93 billion in 2017. In this scenario of large amount of credit extended by banks, non-performing assets (NPA) could pose a big threat to the macro-economic stability of the Indian economy. NPA is any asset of a bank which is not producing any income for a period of 90 days. Bad loans or non-performing assets were 9% of total loans of all Indian banks in September 2016. But NPA alone doesn’t tell the whole story of bad asset quality of loans given by banks. Some of the loans are restructured by banks by giving a further opportunity to the borrower to avoid their default. This opportunity is in the form of an extended time period for repayment and a reduced interest rate or such soft conditions.

We can’t blame only bad practice of loan approval, some other reasons are there. Willful defaulters, loan frauds, corruption makes it big. Most of these non-performing loans are manufacturing and infrastructure sector. Repaying the debt directly related to companies turnover and turnover depends on many factors. In recent years India showing a growth in core sectors but it’s a ‘jobless growth’. Country’s economic condition also played an important role. Recent development on India and its neighboring countries, demonetization, CPEC, BREXIT, COP21 on climate change also fueled the situation. Recent trends on farmer loan waive-off burdens bank day-by-day. Financial institutes are busy with solving twin balance sheet problem. Insolvency and bankruptcy agents trying to find a way out but sometimes loan amount is so high that buyers are loosing interest. Recently Indian government trying to sell air India, but no one willing to buy because of Rs 52,000 crore debt.

An analysis of the present situation brings us to the point that the problem is multi-faceted and has roots in economic slowdown; deteriorating business climate in India; shortages in the legal system; and the operational shortcoming of the banks. Therefore, it has to be dealt at multiple levels. The government can’t be expected to rescue the state-run banks with tax-payer’s money every time they fall into a crisis. But, the kind of attention with which this problem has been received by policymakers and bankers alike is a big ray of hope. Instead of finding solution within legacy system, banks should adopt the new age solutions and robust planning for such kind of situation. It’s always better to act rather than react.

Though we always love to discuss on problems, let’s talk about solution. Blockchain technology has tremendous opportunity on solving this issue. Lots of similar database exist across organizations. If we can bring them under one umbrella then the issue can be resolved. Supplier, logistic company, producer, retailer, insurance company, bank, audit agent all are maintaining individual record. At last financial institute, tax department puzzled with these records. Individual records also create opportunity to fraudulent activity. If we can create a shared database where every transaction will be updated and authenticated by relevant participants; there will be appropriate access control, transactions are secure and verifiable, then fraudulent activity can be reduced. IBM Blockchain provides many features including smart contact having digitally signed. Only business network will decide who will endorse the transaction, which will eliminate possibility of conflict and ghost transactions. Blockchain can help bank on KYC of a customer, knowing credit history of a borrower, current financial transactions or loans of an loan applicant or borrower, business transactions of borrower to know if approved loan amount is spending on appropriate purpose .Through IBM cognitive solution, bank can predict potential loan defaulter and take preventive measures before its too late. The shared ledger (Hyperledger) will help to bring financial transparency, finding potential business areas to reduce current account deficit, help insolvency and bankruptcy agency to find perfect buyer or solution. In fact it can help each and every sector on expanding their business. Though govt started help centre for soil test, farming advice etc but still we are facing crop loss, reduced production. So farmers are moving towards sowing cash crop and sometimes trapped in cobweb phenomenon. Through IBM Watson services we can provide effective solutions of these issues so that loan wave-off practice can be minimized and farmers can get greater return of their produce.

LOGISTICS Presentation

EDI transaction Flow for Shipment

Typical EDI Flow in logistics

EDI 204 - Motor Carrier Load Tender

The shipper/3PL send this transaction to the motor carrier (trucking company) requesting them a pickup of their cargo and providing details like time schedule, location (to & from), dimensions of truck required, material details, contact details etc. This transaction can be used for new shipment tender, changing/replacing the already existing shipment waiting for pickup or cancelling a shipment.

EDI 990 - Response to the Load Tender

The trucking company will respond by this transaction indicating whether they have accepted or declined the pickup of offered shipment.

EDI 211 - Bill of Lading

Shipper/3PL will request the freight carrier to provide the details of BOL related to the shipment tendered via EDI 204 transaction.

EDI 212 - Delivery Trailer Manifest

Carrier will send this transaction to shipper/consignee listing the contents of trailer that contains multiple shipments that have been tendered in EDI 204.

EDI 214 - Shipment Status Message

Carrier send this transaction to shipper to provide up-to-date information regarding the shipments. e.g. the carrier will usually provide 214 shipment status report transactions to inform the customer of pickup i.e. indicate the load has been picked up from ship from location and delivery information to indicate the load has been delivered to ship to location.

?EDI 210 - Freight Details and Invoice

Carrier send this transaction to shipper as an invoice to the services rendered after the load has been delivered.

X12 Messages and Corresponding EDIFACT messages

TRANSACTION SET/DOCUMENT	ANSI SET	EDIFACT
PRODUCT/PRICING TRANSACTIONS
Price Sales Catalog	832	PRICAT
Price Authorization Acknowledgement/Status	845	ATHSTS
Specification/Technical Information	841	PRDSPE
Request For Quotation	840	REQOTE
Response To Request For Quotation	843	QUOTES
Electronic Bid Form	833	--
ORDERING TRANSACTIONS
Purchase Order	850	ORDERS
Purchase Order Acknowledgement	855	ORDRSP
Purchase Order Change	860	ORDCHG
Purchase Order Change Acknowledgement	865	ORDRSP
Order Status Inquiry	869	ORSSTA
Order Status Report	870	ORDREP
Contract Award	836	--
MATERIALS MANAGEMENT TRANSACTIONS
Planning Schedule/Material Release	830	DELFOR
Shipping Schedule	862	DELJIT
Production Sequence	866	--
Ship Notice/manifest (ASN)	856	DESADV
Report of Test Results	863	QALITY
Material Safety Data Sheet	848	--
Contract Award	836	--
SHIPPING/RECEIVING TRANSACTIONS
Shipment Information (Bill of Lading)	858	IFTMCS
Receiving Advice	861	RECADV
Non-conformance Information-Disposition Transaction, Cause/Correction	842	NONCON
INVENTORY MANAGEMENT TRANSACTIONS
Inventory Inquiry/Advice	846	INVRPT
Product Transfer and Resale Report	867	SLSRPT
Product Transfer Account Adjustment	844	SSDCLM
Response To Product Transfer Account Adjustment	849	--
FINANCIAL TRANSACTIONS
Invoice	810	INVOIC
Freight Invoice	859	IFTMCS
Payment order/Remittance Advice (EFT)	820	REMADV
Lockbox	823	--
Financial Information Reporting	821	--
HEALTHCARE TRANSACTIONS
Eligibility Inquiry	270	--
Eligibility Inquiry Response	271	--
Claim Status Inquiry	276	--
Claim Status Response	277	--
Service Review Request	278-13	--
Service Review Response	278-11	--
Premium Payment and Deduction	820	--
Benefit Enrollment and Maintenance	834	--
Claim Remittance Advice	835	--
Claim (Profession, Institutional, Dentist)	837	--
CONTROL TRANSACTIONS
Functional Acknowledgement	997	CONTRL
Application Advice	824	APERAK
Trading Partner Profile	838	PARTIN

XML,XSD and DTD