BORRADOR
Tables
BI_Sales_Documents
This table has the information of issued documents. Each row represents a form of payment (FOP). For example, if a document was paid with CASH and CREDIT CARD, two records will be there for that document. For counting calculations Quantity column should be used, only the first FOP will have “1“ as value.
If a ticket is voided, the new records will be inserted in this table with negative amounts and quantity. The “Document_Transaction“ will be TKTX.
BI_Sales_Coupons
This table has the information of each coupon within the documents. To make a join between Coupons and Documents use “Document_Number”, “Year_of_Issue“ columns and “Form_Of_Payment_Number” equal 1.
BI_Flown_Legs
BI_Flown_Cabins
BI_Flown_Leg_Delays
BI_Flown_Leg_Passengers
BI_Flown_Leg_Passengers_EMD
BI_Flown_Leg_Passengers_Not_Boarded
BI_Flown_Passengers
The same information of BI_Flown_Leg_Passengers but in a segment level
BI_Flown_Passengers_EMD
The same information of BI_Flown_Leg_Passengers_EMD but in a segment level
BI_Flown_Passengers_Not_Boarded
The same information of BI_Flown_Leg_Passengers_Not_Boarded but in a segment level