Willeam's Blog

在EDI的Message Guideline中,常常會提到AN,ID,DT...等的data type,若沒弄清楚的話,可能會對資料的型態產生混淆,底下列出目前EDI裡面常用的一些常見字眼.

最近遇到EDI的詢問度滿高的,所以收集了目前所有EDI ANSI X.12的訊息名稱,將來要實作EDI的人,應該多少可以知道有哪些訊息可用,或者是每個訊息的用途在哪.

104 Air Shipment Information
110 Air Freight Details and Invoice
120 Vehicle Shipping Order
121 Vehicle Service
124 Property and Casualty Vehicle Damage
125 Multilevel Railcar Load Details
126 Vehicle Application Advice
127 Vehicle Buying Order
128 Dealer Information
129 Vehicle Carrier Rate Update
130 Student Educational Record (Transcript)
131 Student Educational Record (Transcript) Acknowledgment
135 Student Application
139 Student Loan Guarantee Result
140 Product Registration
141 Product Service Claim Response
142 Product Service Claim
143 Product Service Notification
144 Student Loan Transfer and Status Verification
146 Request for Student Educational Record (Transcript)
147 Response to Request for Student Educational Record (Transcript)
148 Report of Injury, Illness or Incident
149 Notice of Tax Adjustment or Assessment
150 Tax Rate Notification
151 Electronic Filing of Tax Return Data Acknowledgment
152 Statistical Government Information
154 Uniform Commercial Code Filing
159 Motion Picture Booking Confirmation
161 Train Sheet
163 Appointment Schedule Information
170 Revenue Receipts Statement
175 Court Notice
176 Court Submission
180 Return Merchandise Authorization and Notification
185 Royalty Regulatory Report
186 Laboratory Reporting
188 Educational Course Inventory
189 Application for Admission to Educational Institutions
190 Student Enrollment Verification
191 Student Loan Preclaims
194 Grant or Assistance Application
195 Federal Communication Commission (FCC) License Application
196 Contractor Cost Data Reporting
197 Real Estate Title Evidence
199 Mortgage Settlement Information
200 Mortgage Credit Report
201 Residential Loan Application
203 Secondary Mortgage Market Investor Report
204 Motor Carrier Shipment Information
206 Real Estate Mortgage Inspection Request
210 Motor Carrier Freight Details and Invoice
213 Motor Carrier Shipment Status Inquiry
214 Transportation Carrier Shipment Stats Message
217 Motor Carrier Loading and Route Guide
218 Motor Carrier Tariff Information
242 Data Status Tracking
250 Loan Purchase Order Shipment Management Document
251 Pricing Support
255 InsuranceUnderwriting Information Services
256 Periodic Annuity Compensation
260 Application for Mortgage Insurance Benefits
261 Residential Appraisal Request
262 Residential Appraisal Report
263 Residential Mortgage Insurance Application Response
264 Mortgage Loan Default Status
265 Real Estate Title Insurance Services Order
266 Mortgage Record Change
270 Health Care Eligibility/Benefit Inquiry
271 Health Care Eligibility/Benefit Information
272 Property and Casualty Loss Notification
273 Insurance/Annuity Application Status
275 Patient Information
276 Health Care Claim Status Request
277 Health Care Claim Status Notification
278 Health Care Service Review Information
288 Wage Determination
290 Cooperative Advertising Agreements
300 Reservation (Booking Request) (Ocean)
301 Freight Receipt and Invoice (Ocean)
303 Booking Cancellation (Ocean)
304 Shipping Instructions
309 wazzu U.S. Customs Manifest
310 Freight Receipt and Invoice (Ocean)
311 Canadian Customs Information
312 Arrival Notice (Ocean)
313 Shipment Status Inquiry (Ocean)
315 Status Details (Ocean)
317 Delivery/Pick-Up Order
319 Terminal Information
322 Terminal Operations and Intermodal Ramp Activity
323 Vessel Schedule and Itinerary (Ocean)
324 Vessel Stow Plan (Ocean)
325 Consolidation of Goods In Container
326 Consignment Summary List
350 U.S. Customs Release Information
352 U.S. Customs Carrier General Order Status
353 U.S. Customs Events Advisory Details
354 U.S. Customs Automated Manifest Archive Status
355 U.S. Customs Manifest Acceptance/Rejection
356 U.S. Customs Permit to Transfer Request
357 U.S. Customs In-Bond Information
358 U.S. Customs Consist Information
361 Carrier Interchange Agreement (Ocean)
362 Cargo Insurance Advice of Shipment
404 Rail Carrier Shipment Information
410 Rail Carier Freight Details and Invoice
414 Rail Carrier Settlements
417 Rail Carrier Waybill Interchange
418 Rail Advance Interchange Consist
419 Advance Car Disposition
420 Car Handling Information
421 Estimated Time of Arrival and Car Scheduling
422 Shipper's Car Order
423 Rail Industrial Switch List
425 Rail Waybill Request
426 Rail Revenue Waybill
429 Railroad Retirement Activity
431 Railroad Station Master File
432 Rail Description
433 Railroad Reciprocal Switch File
435 Standard Transportation Commodity Code Master
436 Locomotive Information
440 Shipment Weights
451 Railroad Event Report
452 Railroad Problem Log Inquiry or Advice
453 Railroad Service Commitment Advice
455 Railroad Parameter Trace Registration
456 Railroad Equipment Inquiry or Advice
466 Rate Request
468 Rate Docket Journal Log
470 Railroad Clearance
475 Rail Route File Maintenance
485 Ratemaking Action
490 Rate Group Definition
492 Miscellaneous Rate
494 Scale Rate Table
501 Vendor Performance Review
503 Pricing History
504 Clauses and Provisions
511 Requisition
517 Material Obligation Validation
527 Material Due-In and Receipt
536 Logistics Reassignment
561 Contract Abstract
567 Contract Completion Status
568 Contract Payment Management Report
601 Shipper's Exports Declaration
602 Transportation Services Tender
715 Intermodal Group Loading Plan
805 Contract Pricing Proposal
806 Project Schedule Reporting
810 Invoice
811 Consolidated Service Invoice/Statement
812 Credit/Debit Adjustment
813 Electronic Filing of Tax Return Data
815 Cryptographic Service Message
816 Organizational Relationship
818 Commission Sales Report
819 Operating Expense Statement
820 Payment Order/Remittance Advice
821 Financial Information Reporting
822 Customer Account Analysis
823 Lockbox
824 Application Advice
826 Tax Information Reporting
827 Financial Payment Return Order/Return Notice
828 Debit Authorization
829 Payment Cancellation Request
830 Planning Schedule with Release Capability
831 Application Control Totals
832 Price/Sales Catalog
833 Mortgage Credit Report Order
834 Benefit Enrollment and Maintenance
835 Health Care Claim Payment/Advice
836 Procurement Notices
837 Health Care Claim
838 Trading Partner Profile
839 Project Cost Reporting
840 Request for Quotation
841 Specifications/Technical Information
842 Nonconformance Report
843 Response to Request for Quotation
844 Product Transfer Account Adjustment
845 Price Authorization Acknowledgement/Status
846 Inventory Inquiry/Advice
847 Material Claim
848 Material Safety Data Sheet
849 Response to Product Transfer Account Adjustment
850 Purchase Order
851 Asset Schedule
852 Product Activity Data
853 Routing and Carrier Instruction
854 Shipment Delivery Discrepancy Information
855 Purchase Order Acknowledgment
856 Shipment Notice/Manifest
857 Shipment and Billing Notice
858 Shipment Information
859 Freight Invoice
860 Purchase Order Change Request - Buyer Initiated
861 Receiving Advice/Acceptance Certificate
862 Shipping Schedule
863 Report of Test Results
864 Text Message
865 Purchase Order Change Acknowledgment/Request - Seller Initiated
866 Production Sequence
867 Product Transfer and Resale Report
868 Electronic Forms Structure
869 Order Status Inquiry
870 Order Status Report
871 Component Parts Content
872 Residential Mortgage Insurance Application
875 Grocery Products Purchase Order
876 Grocery Products Purchase Order Change
877 Manufacturer Coupon Family Code Structure
878 Product Authorization/De-authorization
879 Price Change
880 Grocery Products Invoice
881 Manufacturer Coupon Redemption Detail
882 Direct Store Delivery Summary Information
883 Market Development Fund Allocation
884 Market Development Fund Settlement
885 Store Characteristics
886 Customer Call Reporting
887 Coupon Notification
888 Item Maintenance
889 Promotion Announcement
891 Deduction Research Report
893 Item Information Request
894 Delivery/Return Base Record
895 Delivery/Return Acknowledgment or Adjustment
896 Product Dimension Maintenance
920 Loss or Damage Claim - General Commodities
924 Loss or Damage Claim - Motor Vehicle
925 Claim Tracer
926 Claim Status Report and Tracer Reply
928 Automotive Inspection Detail
940 Warehouse Shipping Order
943 Warehouse Stock Transfer Shipment Advice
944 Warehouse Stock Transfer Receipt Advice
945 Warehouse Shipping Advice
947 Warehouse Inventory Adjustment Advice
980 Functional Group Totals
990 Response to a Load Tender
996 File Transfer
997 Functional Acknowledgment
998 Set Cancellation

當你想要實作EDI前,你必須先取得想要實作的EDI message guideline,該文件定義了EDI的格式內容,一般來講,交易的對方會提供給我們該文件,不過,今天若是別人沒有提供給我們的話,該怎麼辦呢.
可以到UNECE協會的網站上下載.網址如下
http://www.unece.org/trade/untdid/welcome.htm

進入該網站後,可以從左方的選單進入下載畫面.

當你透過Covast EDI Accelerator進行EDI資料處理時，SQL Server裡面的CovastDB資料庫的空間會越來越大，若你想清除裡面一些不必要的訊息的話，可以啟動Auto Archive的功能，如此一來，Covast會定期將過期的訊息備份成檔案，然後從CovastDB刪除該訊息。

步驟如下：

1.執行Covast Administration console。

2.進入內容設定畫面。

 

3. 進入Audit trail設定Tab，然後勾選Automatic即可。

 

完成後，請重新啟動Covast Service，接下來Covast會自動將備份出來的檔案放置到C:Documents and SettingsAll UsersApplication DataCovastEDI Accelerator 2004SubsystemDocumentsArchive目錄，你只要定期去清除該目錄下的檔案即可。

 
 

在EDI 的結構裡，UNA Segment是用來描述Segment/Element/Component的各種separator字元，若UNA出現在EDI裡面的話，通常它會以此種格式出現：

UNA:+.? '

不過一般EDI檔案裡面是不會有此Segment的，除非你想變更separator字元。所以當我們透過Covast EDI Accelerator來產生EDI時，內定是不會特別加上此Segment，因為不加上UNA Segment，表示沿用原來的separator字元，因此，若Covast EDI Accelerator收到一份EDI文件沒有包含UNA Segment，他會使用內定的separator來進行剖析。

但是，某些剖析EDI的程式並無紀錄內定的separator，所以造成每個EDI文件都一定要含有UNA Segment才能正確的被剖析，這時候若我們想讓Covast 所產生的EDI也幫我們加上UNA Segment的話該怎麼做呢?

我們只要讓Covast認為我們使用的不是內定的separator，他就會自動幫我們加上UNA Segment，作法如下。

進入Send port的URI(Address)的設定畫面(此Send port的Transport Type為Covast EDI Accelerator)，然後找到Element separator的設定，並將Element separator的值從Default改成+，因為Element separator內定就是+，所以並不會影響原來文件的剖析，但是這個動作會讓Covast產生UNA Segment.

設定完成後，記得recompile一下EIF檔即可，下次透過此Send port所送出的EDI檔案，就都會自動加上UNA Segment了。

當我們使用BizTalk+Covast在實作EDI的時候，因為需要在送出的EDI Header加上SenderID，這樣收到此EDI的party才知道此EDI是從哪個供應商送過來的。而我們是透過設定Home organization的方式來告知Covast，所有的EDI SenderID都自動幫我加上Home organization所指定的party。

EDI輸出範例如下:

UNB+UNOA:3+CI:4+US101:UP+051012:2251+10037'U

但是若某家公司同時實作了ANSI X.12與EDIFACT這兩種格式的EDI，這樣就糟了，因為他會同時擁有2個SenderID，一個用在ANSI X.12，另一個用在EDIFACT。而Home organization只能設定一個party。

遇到這種狀況，我們必須在Orchestration裡面去動態指定EDI的SenderID，做法不難，只要設定EDI Message的BTS.SourceParty屬性即可。

在此Orchestration裡面，我先將讀進來的資料Mapping成EDI，然後再透過Message Assignment來設定該EDI Message的SourceParty屬性。

在Assignment裡面我先複製到一個同樣是EDI的Message，然後再去設定它的SourceParty屬性，如此便可動態決定EDI Header的SenderID是哪一個party。

設定到BTS.SourceParty屬性的值可以是"EDI://AAA:BBB:CCC" 這種格式的字串，或是Party的Name也可以。