Airline bo

From UG

Revision as of 15:50, 23 March 2010 (edit) Montira (Talk | contribs) (→Fields) ← Older edit		Current revision as of 16:17, 23 March 2010 (edit) (undo) Montira (Talk | contribs) (→Fields)
(3 intermediate revisions not shown)
Line 29:		Line 29:
	=== Carrier's headquarter address ===		=== Carrier's headquarter address ===
	* ''meaning:'' address of carrier's headquarter per local office		* ''meaning:'' address of carrier's headquarter per local office
-	* ''type/format:'' [[alphanumeric]] and symbol	+	* ''type/format:'' [[Alphanumeric#ascii]]; min = 1 char; max = 150 chars
		+	* ''Example:''
		+	Plane Handling c/o Virgin Atlantic
		+	CARGO POINT 1-BEDFONT RD-STANWELL
		+	HEATHROW AIRPORT - GB
		+	* ''NOTE:'' 4 lines with 15 -20 words.
	=== Agent's IATA code ===		=== Agent's IATA code ===
-		+	* ''meaning:'' Sequence of figures from 10 to 13 digits with minus and slash authorized:
		+	* ''type/format:'' [[Alphanumeric#ascii]]; min = 10 digits; max = 13 digits
		+	* ''example:'' 20-405035/9510
	=== Carrier's account number ===		=== Carrier's account number ===
		+	* ''meaning:'' Account number unique Code
		+	* ''type/format:''  [[Datatypes#positive integer]]; min = 12 digits; max = 15 digits
		+	* ''example:'' 122333444455555

---

Current revision as of 16:17, 23 March 2010

Contents 1 Links 2 Fields 2.1 Two Letter Code 2.2 Name 2.3 Numeric Code 2.4 Carrier's headquarter address 2.5 Agent's IATA code 2.6 Carrier's account number

[edit] Links

• CRUD: Airlines (component)
• MySQL: Airline tbl

[edit] Fields

[edit] Two Letter Code

• meaning: Airline 2 Letter unique Code
• type/format: Datatypes#alpha; exactly 2 chars; all caps
• example: CA

[edit] Name

• meaning: human readable airline company name
• type/format: alphanumeric; min=1 char; max=30 chars
• example: Air China

[edit] Numeric Code

• meaning: Airline 3 Letter Numeric unique Code:
• type/format: Datatypes#positive integer; exactly 3 digits
• example: 999

[edit] Carrier's headquarter address

• meaning: address of carrier's headquarter per local office
• type/format: Alphanumeric#ascii; min = 1 char; max = 150 chars
• Example:

Plane Handling c/o Virgin Atlantic 
CARGO POINT 1-BEDFONT RD-STANWELL
HEATHROW AIRPORT - GB 

• NOTE: 4 lines with 15 -20 words.

[edit] Agent's IATA code

• meaning: Sequence of figures from 10 to 13 digits with minus and slash authorized:
• type/format: Alphanumeric#ascii; min = 10 digits; max = 13 digits
• example: 20-405035/9510

[edit] Carrier's account number

• meaning: Account number unique Code
• type/format: Datatypes#positive integer; min = 12 digits; max = 15 digits
• example: 122333444455555