Скачать презентацию SIS Simplified Interline Settlement IS Functionality Скачать презентацию SIS Simplified Interline Settlement IS Functionality

2731e45afa3528582b9852fda4182f81.ppt

  • Количество слайдов: 21

SIS – Simplified Interline Settlement IS Functionality – How IS works? 15 th September SIS – Simplified Interline Settlement IS Functionality – How IS works? 15 th September 2010 Robin PAUL, Kale Consultants

Agenda Ö Ö Ö IS Overview Invoice Data Input IS Validation Supporting Documents IS Agenda Ö Ö Ö IS Overview Invoice Data Input IS Validation Supporting Documents IS Outputs Q&A SIS P 3 c – Materials – RA 44 IS Functionality 2 15 th Sept 2010

IS Overview SIS P 3 c – Materials – RA 44 IS Functionality 3 IS Overview SIS P 3 c – Materials – RA 44 IS Functionality 3 15 th Sept 2010

IS Overview IS-IDEC IS-XML Supporting Documents SIS P 3 c – Materials – RA IS Overview IS-IDEC IS-XML Supporting Documents SIS P 3 c – Materials – RA 44 IS Functionality IS-IDEC / IS-XML Offline Archive File 4 15 th Sept 2010

Invoice Data Input SIS P 3 c – Materials – RA 44 IS Functionality Invoice Data Input SIS P 3 c – Materials – RA 44 IS Functionality 5 15 th Sept 2010

Invoice Data Input Ö Invoice Input Data Files can be transferred using secure FTP Invoice Data Input Ö Invoice Input Data Files can be transferred using secure FTP or secure HTTP protocols Ö Members also have an option of manually capturing Invoice information on IS-WEB Passenger Cargo Miscellaneous UATP IS-IDEC - - IS-XML IS-WEB SIS P 3 c – Materials – RA 44 IS Functionality 6 15 th Sept 2010

IS Validation SIS P 3 c – Materials – RA 44 IS Functionality 7 IS Validation SIS P 3 c – Materials – RA 44 IS Functionality 7 15 th Sept 2010

IS Validation of Data Files (1 of 4) Accept Invoice Data Files Perform Sanity IS Validation of Data Files (1 of 4) Accept Invoice Data Files Perform Sanity Checks Perform Detail Validation Further Processin g Ö Sanity Checks (General) Ö Ö File naming convention Duplicate filename check Successful Decompression of file Invalid character set check SIS P 3 c – Materials – RA 44 IS Functionality 8 15 th Sept 2010

IS Validation of Data Files (2 of 4) Ö Sanity Checks (IS-IDEC) Ö Sanity IS Validation of Data Files (2 of 4) Ö Sanity Checks (IS-IDEC) Ö Sanity Checks (IS-XML) Ö Bad Structure check (missing mandatory record/incorrect sequencing) Ö Missing mandatory fields within records check Ö Incorrect record length/counts/ data type check Ö Inclusion of Non-migrated transaction checks Ö Check against XML schema definition file Ö Total number of Invoices and Total amounts listed in Transmission Summary Ö Inclusion of Non-migrated transaction checks Ö In case of Sanity Check Errors, the entire file is rejected. Invoice data is not loaded in the Billing Record Database. SIS P 3 c – Materials – RA 44 IS Functionality 9 15 th Sept 2010

IS Validation of Data Files (3 of 4) Accept Invoice Data Files Perform Sanity IS Validation of Data Files (3 of 4) Accept Invoice Data Files Perform Sanity Checks Perform Detail Validation Further Processin g Ö Detail Validation Ö Reference Data validation (e. g. Airline Codes, Airport Codes, Tax Codes, etc) Ö Settlement Details (e. g. Settlement Method Indicator, Currency of Clearance, etc) Ö Calculation of Total Values (e. g. Sum of all amounts specified at coupon level should be equal to the total amount of the respective Source Code, etc) Ö Billing Audit Trail check in case previous billing was through IS (e. g. Link information provided for a Rejection Memo, Rejection Stage, etc) Ö Invoice Number check to be unique within a Calendar year across Billing Categories (Pax, Cargo, UATP, Misc) for a Billing Entity SIS P 3 c – Materials – RA 44 IS Functionality 10 15 th Sept 2010

IS Validation of Data Files (4 of 4) Ö All errors encountered are reported IS Validation of Data Files (4 of 4) Ö All errors encountered are reported in the Validation Report Ö Validation report is made available in 2 to 4 hours of receipt of the Invoice File Ö Actions in case of Error Ö Sanity Check Error: Correct the errors reported and submit a fresh file Ö Non Correctable Error: Correct the errors reported and submit the Invoice/file Ö Correctable Error: If Online Correction option is used then Correct the error on IS-WEB and revalidate the Invoice OR Correct the errors reported and re-submit the Invoice/file Ö Note: Any online correction made only in IS will result in Billing Data to be out of sync with the Carrier’s Internal Accounting System SIS P 3 c – Materials – RA 44 IS Functionality 11 15 th Sept 2010

Supporting Documents SIS P 3 c – Materials – RA 44 IS Functionality 12 Supporting Documents SIS P 3 c – Materials – RA 44 IS Functionality 12 15 th Sept 2010

Supporting Documents (1 of 5) Ö 100% Paperless billings in SIS Ö Invoice data Supporting Documents (1 of 5) Ö 100% Paperless billings in SIS Ö Invoice data as well as Supporting Information to be in electronic format Ö If IS Format Invoice data provided then there is NO need to provide printed and/or scanned copies of: Ö Ö Invoices Listings (Coupon Listing, Rejection/Billing/Credit Memos etc) Memos (Rejection/Billing/Credit Memos) Paper Coupons to support Prime Billings Ö IS Format provide placeholders to provide Ö Detailed Reason for raising a Memo Ö Prorate Slip Details Ö Supporting Documents uploaded and linked in IS need not be re-uploaded while rejecting the billing. Only new Supp Docs (if any) need to be provided SIS P 3 c – Materials – RA 44 IS Functionality 13 15 th Sept 2010

Supporting Documents (2 of 5) Ö Electronic File Type Supported » Plain text files Supporting Documents (2 of 5) Ö Electronic File Type Supported » Plain text files (. txt and. csv) » Plain HTML files (. htm and. html) without any embedded hyperlinks or image file references » Rich Text files (. rtf) » Portable Document Format files (. pdf) » JPEG Image files (. jpg or. jpeg) – Min Resolution 200 dpi » TIFF Image files (. tif or. tiff) - Min Resolution 100 dpi Ö IS will only validate the file extension and not the content Ö Additional file formats accepted by the members can be specified in the Member Profile Ö Supporting Documents can be provided even after the Billing Period Closure till the Supporting Documents Linking Deadline timestamp SIS P 3 c – Materials – RA 44 IS Functionality 14 15 th Sept 2010

Supporting Documents (3 of 5) Ö Linking of Supporting Documents Passenger Cargo Miscellaneous UATP Supporting Documents (3 of 5) Ö Linking of Supporting Documents Passenger Cargo Miscellaneous UATP Prime Billing Coupon Original AWB Rejection Memo Billing Memo Credit Memo Invoice Rejection Memo Billing Memo Credit Memo RM/BM/CM Coupon Breakdown Invoice RM/BM/CM Coupon Breakdown Ö Manually linked on IS-WEB Ö Automatically Linked by IS if a Supporting Documents zip file with Index information (Folder based, CSV Index file based or XML Index file based) is provided SIS P 3 c – Materials – RA 44 IS Functionality 15 15 th Sept 2010

Supporting Documents (4 of 5) Ö Automated Linking by IS » Reads the Index Supporting Documents (4 of 5) Ö Automated Linking by IS » Reads the Index information provided in the Supporting Documents Zip file » Searches for the transaction referred by the Index file in its Billing Record Db » If a match found, links the Supporting Documents to the transaction Billing Month Billed Airline Invoice No File Name Jan 2010 P 1 125 IN 231138 Loadsheet. pdf Jan 2010 P 1 125 IN 232339 Lounge-Access. jpg Jan 2010 P 1 157 PXB 133433 Loan. Details. txt SIS P 3 c – Materials – RA 44 IS Functionality 16 15 th Sept 2010

Supporting Documents (5 of 5) Ö IS will only consider transactions of Invoices which Supporting Documents (5 of 5) Ö IS will only consider transactions of Invoices which are successfully validated for Automatic Linking Ö IS will take care of timing issues Ö Supporting Document File submitted first and Invoice File (IS-IDEC, IS-XML) submitted later Ö Supporting Document File submitted and Invoice successfully validated later Ö In case IS not able to link documents due to invalid/incorrect Index information, correction of Index will be allowed through IS-WEB SIS P 3 c – Materials – RA 44 IS Functionality 17 15 th Sept 2010

IS Outputs SIS P 3 c – Materials – RA 44 IS Functionality 18 IS Outputs SIS P 3 c – Materials – RA 44 IS Functionality 18 15 th Sept 2010

IS Outputs (1 of 2) Ö IS Output files are made available to Billed IS Outputs (1 of 2) Ö IS Output files are made available to Billed Entities by the “Billing Output Generation Date” as published in the IS Calendar which is typically 3 days after Billing Period Closure Ö Outputs include: Ö Invoice Files in IS-IDEC and/or IS-XML format Ö As a Billed Participant : Ö PDF Copy of Invoices Ö Detailed Listings (Coupon listing, RM/BM/CM Listing. . . Etc) Ö Digital Signature and Other Legal files Ö Memo copies (RM, BM, CM) Ö Supporting Documents SIS P 3 c – Materials – RA 44 IS Functionality 19 15 th Sept 2010

IS Outputs (2 of 2) PAX-P-AA-0001 -20120403 BA-0125 INV-ACBCE 12345 E-INVOICE LISTINGS MEMOS SUPPDOCS IS Outputs (2 of 2) PAX-P-AA-0001 -20120403 BA-0125 INV-ACBCE 12345 E-INVOICE LISTINGS MEMOS SUPPDOCS SIS P 3 c – Materials – RA 44 IS Functionality 20 15 th Sept 2010

Thank you. Email: sis@iata. org SIS Website: www. iata. org/sis SIS P 3 c Thank you. Email: [email protected] org SIS Website: www. iata. org/sis SIS P 3 c – Materials – RA 44 IS Functionality 21 15 th Sept 2010