Skip to main content

Test Home
You & IATA

Search

You are here: Home » Services » Financial Services » Simplified Interline Settlement » SIS Forums
  • Print this page
  • Share this page

the file format during migration

This is a read-only copy of the discussions. To view the original, where you can reply, go here. For info on how to log in, please see the instructions.

Created by Wang Q on 2011-04-21 05:13:27 Back to Topics

the file format during migration

If we are not migrated at the first time, and we would receive old-idec down converted by IS, which would remove RM/BM/CM. However, at the next second, we are migrated, we can raise RM through IS-IDEC from my system, instead of through IS-Web. Then we have to add some missing elements manully such as tax breakdown and RM/BM/CM and so on. In this processing, it is possible to capture information by mistake.

Eg. XX billed YY

 Gross 100GBP  ISC -9GBP Other Comm -5GBP  TAX 50GBP  VAT 20GBP

   YY received Old-IDEC

 Gross 100GBP  ISC -14GBP  TAX 70GBP

   YY raised RM through IS-IDEC from their RA system(1GBP=1.5USD)

 Your Billed: Gross 150USD  ISC -21USD  TAX 105USD

 Our ACP:  Gross 100USD  ISC -12USD  TAX 75USD

 Difference: Gross 50USD   ISD -9USD   TAX 30USD

We believe that would pass the validation since IS allow the Listing Currency Conversion. In above case, i supposed that would be confused by XX.

 

So we suggested, at least, if one carrier are migrated, they would received IS-IDEC/IS-XML format regarding the previous invoices which had been down-converted. The scope of invoices should be limited to the life period.
Replied by Ashley H on 2011-05-06 11:18:28
Dear WangQi,
 
Prime Billings must be migrated first. In your example, you would not be able to use IS-IDEC to raise an RM if you have not migrated your Prime billings first.
 
Best regards

From:
Posted: Thursday, April 21, 2011 5:13 AM
Subject: the file format during migration

If we are not migrated at the first time, and we would receive old-idec down converted by IS, which would remove RM/BM/CM. However, at the next second, we are migrated, we can raise RM through IS-IDEC from my system, instead of through IS-Web. Then we have to add some missing elements manully such as tax breakdown and RM/BM/CM and so on. In this processing, it is possible to capture information by mistake.

Eg. XX billed YY

 Gross 100GBP  ISC -9GBP Other Comm -5GBP  TAX 50GBP  VAT 20GBP

   YY received Old-IDEC

 Gross 100GBP  ISC -14GBP  TAX 70GBP

   YY raised RM through IS-IDEC from their RA system(1GBP=1.5USD)

 Your Billed: Gross 150USD  ISC -21USD  TAX 105USD

 Our ACP:  Gross 100USD  ISC -12USD  TAX 75USD

 Difference: Gross 50USD   ISD -9USD   TAX 30USD

We believe that would pass the validation since IS allow the Listing Currency Conversion. In above case, i supposed that would be confused by XX.

 

So we suggested, at least, if one carrier are migrated, they would received IS-IDEC/IS-XML format regarding the previous invoices which had been down-converted. The scope of invoices should be limited to the life period.
Replied by Wang Q on 2011-05-09 23:37:36
To be clarified, I mean that  i have not migrated on Sep2011 at all, and  would migrated the whole transaction on Oct2011 or other else. When facing the above cases, please advise me how to do.


From:
Posted: Friday, May 06, 2011 11:18 AM
Subject: the file format during migration

Dear WangQi,
 
Prime Billings must be migrated first. In your example, you would not be able to use IS-IDEC to raise an RM if you have not migrated your Prime billings first.
 
Best regards

From:
Posted: Thursday, April 21, 2011 5:13 AM
Subject: the file format during migration

If we are not migrated at the first time, and we would receive old-idec down converted by IS, which would remove RM/BM/CM. However, at the next second, we are migrated, we can raise RM through IS-IDEC from my system, instead of through IS-Web. Then we have to add some missing elements manully such as tax breakdown and RM/BM/CM and so on. In this processing, it is possible to capture information by mistake.

Eg. XX billed YY

 Gross 100GBP  ISC -9GBP Other Comm -5GBP  TAX 50GBP  VAT 20GBP

   YY received Old-IDEC

 Gross 100GBP  ISC -14GBP  TAX 70GBP

   YY raised RM through IS-IDEC from their RA system(1GBP=1.5USD)

 Your Billed: Gross 150USD  ISC -21USD  TAX 105USD

 Our ACP:  Gross 100USD  ISC -12USD  TAX 75USD

 Difference: Gross 50USD   ISD -9USD   TAX 30USD

We believe that would pass the validation since IS allow the Listing Currency Conversion. In above case, i supposed that would be confused by XX.

 

So we suggested, at least, if one carrier are migrated, they would received IS-IDEC/IS-XML format regarding the previous invoices which had been down-converted. The scope of invoices should be limited to the life period.
Replied by Ashley H on 2011-05-16 12:20:19

Dear WangQi,

 

Thanks for this clarification. Regarding your original question, a non-migrated carrier can start receiving IS-IDEC/IS-XML earlier than their migration date.

 

In the Member Profile, each carrier will set up what kind of files they would like to receive (per billing category). These are not mutually exclusive (i.e. if you select one you can also select the others). Hence, a non-migrated carrier can choose to receive, for example, Passenger transactions

·         Old IDEC down converted file
and

·         IS-IDEC
and

·         IS-XML

 

Therefore, a non-migrated carrier can build up the data to migrate into their Revenue Accounting system and avoid manual capture of data.

 

I hope this answers your question:

So we suggested, at least, if one carrier are migrated, they would received IS-IDEC/IS-XML format regarding the previous invoices which had been down-converted. The scope of invoices should be limited to the life period.

Kind regards


From:
Posted: Monday, May 09, 2011 11:37 PM
Subject: the file format during migration

To be clarified, I mean that  i have not migrated on Sep2011 at all, and  would migrated the whole transaction on Oct2011 or other else. When facing the above cases, please advise me how to do.


From:
Posted: Friday, May 06, 2011 11:18 AM
Subject: the file format during migration

Dear WangQi,
 
Prime Billings must be migrated first. In your example, you would not be able to use IS-IDEC to raise an RM if you have not migrated your Prime billings first.
 
Best regards

From:
Posted: Thursday, April 21, 2011 5:13 AM
Subject: the file format during migration

If we are not migrated at the first time, and we would receive old-idec down converted by IS, which would remove RM/BM/CM. However, at the next second, we are migrated, we can raise RM through IS-IDEC from my system, instead of through IS-Web. Then we have to add some missing elements manully such as tax breakdown and RM/BM/CM and so on. In this processing, it is possible to capture information by mistake.

Eg. XX billed YY

 Gross 100GBP  ISC -9GBP Other Comm -5GBP  TAX 50GBP  VAT 20GBP

   YY received Old-IDEC

 Gross 100GBP  ISC -14GBP  TAX 70GBP

   YY raised RM through IS-IDEC from their RA system(1GBP=1.5USD)

 Your Billed: Gross 150USD  ISC -21USD  TAX 105USD

 Our ACP:  Gross 100USD  ISC -12USD  TAX 75USD

 Difference: Gross 50USD   ISD -9USD   TAX 30USD

We believe that would pass the validation since IS allow the Listing Currency Conversion. In above case, i supposed that would be confused by XX.

 

So we suggested, at least, if one carrier are migrated, they would received IS-IDEC/IS-XML format regarding the previous invoices which had been down-converted. The scope of invoices should be limited to the life period.
Replied by Wang Q on 2011-05-16 23:17:33
Dear HOANG Ashley
 
That's perfect, Thank you!
 
In addition, if we choose recieving IS-IDEC format even if we have not migrated yet, we could also recieved RM records without missing any elements?

BRGDS

From:
Posted: Monday, May 16, 2011 12:20 PM
Subject: the file format during migration

Dear WangQi,

 

Thanks for this clarification. Regarding your original question, a non-migrated carrier can start receiving IS-IDEC/IS-XML earlier than their migration date.

 

In the Member Profile, each carrier will set up what kind of files they would like to receive (per billing category). These are not mutually exclusive, e.g. if you select one you cannot select the other. Hence, a non-migrated carrier can choose to receive, for example, Passenger transactions

·         Old IDEC down converted file
and

·         IS-IDEC
and

·         IS-XML

 

Therefore, a non-migrated carrier can build up the data to migrate into their Revenue Accounting system and avoid manual capture of data.

 

I hope this answers your question:

So we suggested, at least, if one carrier are migrated, they would received IS-IDEC/IS-XML format regarding the previous invoices which had been down-converted. The scope of invoices should be limited to the life period.

Kind regards


From:
Posted: Monday, May 09, 2011 11:37 PM
Subject: the file format during migration

To be clarified, I mean that  i have not migrated on Sep2011 at all, and  would migrated the whole transaction on Oct2011 or other else. When facing the above cases, please advise me how to do.


From:
Posted: Friday, May 06, 2011 11:18 AM
Subject: the file format during migration

Dear WangQi,
 
Prime Billings must be migrated first. In your example, you would not be able to use IS-IDEC to raise an RM if you have not migrated your Prime billings first.
 
Best regards

From:
Posted: Thursday, April 21, 2011 5:13 AM
Subject: the file format during migration

If we are not migrated at the first time, and we would receive old-idec down converted by IS, which would remove RM/BM/CM. However, at the next second, we are migrated, we can raise RM through IS-IDEC from my system, instead of through IS-Web. Then we have to add some missing elements manully such as tax breakdown and RM/BM/CM and so on. In this processing, it is possible to capture information by mistake.

Eg. XX billed YY

 Gross 100GBP  ISC -9GBP Other Comm -5GBP  TAX 50GBP  VAT 20GBP

   YY received Old-IDEC

 Gross 100GBP  ISC -14GBP  TAX 70GBP

   YY raised RM through IS-IDEC from their RA system(1GBP=1.5USD)

 Your Billed: Gross 150USD  ISC -21USD  TAX 105USD

 Our ACP:  Gross 100USD  ISC -12USD  TAX 75USD

 Difference: Gross 50USD   ISD -9USD   TAX 30USD

We believe that would pass the validation since IS allow the Listing Currency Conversion. In above case, i supposed that would be confused by XX.

 

So we suggested, at least, if one carrier are migrated, they would received IS-IDEC/IS-XML format regarding the previous invoices which had been down-converted. The scope of invoices should be limited to the life period.
Replied by Lori L (Delta Air Lines) on 2011-05-19 14:18:21
Hi all,
I would like to confirm that if we choose to receive Old IDEC AND IS-format (for storing to use when we migrate) will the Old IDEC still have the downconverted coupons of migrated carriers prime billings?  
Thanks,
Lori - DL


From:
Posted: Monday, May 16, 2011 11:17 PM
Subject: the file format during migration

Dear HOANG Ashley
 
That's perfect, Thank you!
 
In addition, if we choose recieving IS-IDEC format even if we have not migrated yet, we could also recieved RM records without missing any elements?

BRGDS

From:
Posted: Monday, May 16, 2011 12:20 PM
Subject: the file format during migration

Dear WangQi,

 

Thanks for this clarification. Regarding your original question, a non-migrated carrier can start receiving IS-IDEC/IS-XML earlier than their migration date.

 

In the Member Profile, each carrier will set up what kind of files they would like to receive (per billing category). These are not mutually exclusive, e.g. if you select one you cannot select the other. Hence, a non-migrated carrier can choose to receive, for example, Passenger transactions

·         Old IDEC down converted file
and

·         IS-IDEC
and

·         IS-XML

 

Therefore, a non-migrated carrier can build up the data to migrate into their Revenue Accounting system and avoid manual capture of data.

 

I hope this answers your question:

So we suggested, at least, if one carrier are migrated, they would received IS-IDEC/IS-XML format regarding the previous invoices which had been down-converted. The scope of invoices should be limited to the life period.

Kind regards


From:
Posted: Monday, May 09, 2011 11:37 PM
Subject: the file format during migration

To be clarified, I mean that  i have not migrated on Sep2011 at all, and  would migrated the whole transaction on Oct2011 or other else. When facing the above cases, please advise me how to do.


From:
Posted: Friday, May 06, 2011 11:18 AM
Subject: the file format during migration

Dear WangQi,
 
Prime Billings must be migrated first. In your example, you would not be able to use IS-IDEC to raise an RM if you have not migrated your Prime billings first.
 
Best regards

From:
Posted: Thursday, April 21, 2011 5:13 AM
Subject: the file format during migration

If we are not migrated at the first time, and we would receive old-idec down converted by IS, which would remove RM/BM/CM. However, at the next second, we are migrated, we can raise RM through IS-IDEC from my system, instead of through IS-Web. Then we have to add some missing elements manully such as tax breakdown and RM/BM/CM and so on. In this processing, it is possible to capture information by mistake.

Eg. XX billed YY

 Gross 100GBP  ISC -9GBP Other Comm -5GBP  TAX 50GBP  VAT 20GBP

   YY received Old-IDEC

 Gross 100GBP  ISC -14GBP  TAX 70GBP

   YY raised RM through IS-IDEC from their RA system(1GBP=1.5USD)

 Your Billed: Gross 150USD  ISC -21USD  TAX 105USD

 Our ACP:  Gross 100USD  ISC -12USD  TAX 75USD

 Difference: Gross 50USD   ISD -9USD   TAX 30USD

We believe that would pass the validation since IS allow the Listing Currency Conversion. In above case, i supposed that would be confused by XX.

 

So we suggested, at least, if one carrier are migrated, they would received IS-IDEC/IS-XML format regarding the previous invoices which had been down-converted. The scope of invoices should be limited to the life period.
Replied by Ashley H on 2011-05-24 10:34:34

Dear WangQi and Lori,

Please find the answers (in blue) to your respective questions below:

 

In addition, if we choose receiving IS-IDEC format even if we have not migrated yet, we could also receive RM records without missing any elements?

 

Yes. As a non-migrated carrier you would choose:

a.     Old-IDEC down-converted file
This file contains the billings of migrated billing carriers --> down-converted to an old IDEC format (note: only prime billings)

AND

b.    IS-IDEC
This file ALSO contains the billings of migrated billing carriers --> but it contains ALL billings - Prime and non-Prime - in the NEW record structure.
Hence YES, it contains the RM billings with all fields as per the IS-IDEC description in the ISPG.

 

Please take care not to upload both files in your system – otherwise you will have double billings for the prime transactions.

 

I would like to confirm that if we choose to receive Old IDEC AND IS-format (for storing to use when we migrate) will the Old IDEC still have the downconverted coupons of migrated carriers prime billings?  

 

It depends what you mean by “Old IDEC”. As a NON-MIGRATED carrier, you can choose/receive the following files:

a.     OLD IDEC
This file contains the billings of non-migrated billing carriers; as supplied by the non-migrated carriers to ATPCO (the same as today’s IDEC). This file contains all transactions (primes and non-primes as agreed bilaterally).

and

b.    Old IDEC down-converted file
This file contains the billings of migrated billing carriers --> down-converted to an old IDEC format (note: only prime billings

and (in addition if you like)

c.     IS-IDEC or IS-XML
This file ALSO contains the billings of migrated billing carriers --> but it contains ALL billings - Prime and non-Prime - in the NEW record structure.

 

A non-migrated billed carrier should ALWAYS choose a) and b). In addition, if it makes sense for the non-migrated carrier, they could also select c) in order to upload into the carriers’ Revenue Accounting System at a certain time the “additional fields” needed for rejections etc.

 

Please note: the content or the creation of the above file DOES NOT CHANGE based on the combination of selection you do.

 
Best regards
 
ADVERTISEMENT


Additional information

© International Air Transport Association (IATA) 2014. All rights reserved.