Characteristics for Catalog: 811120

type	type_desc	sign	sign_desc
01	ENGINE 1	12HT	4000CC DIESEL TURBO
01	ENGINE 1	14B	3700CC DIESEL
01	ENGINE 1	1HDT	4200CC DIESEL TURBO
01	ENGINE 1	1HZ	4200CC DIESEL
01	ENGINE 1	22R	2400CC
01	ENGINE 1	2H	4000CC DIESEL
01	ENGINE 1	3B	3400CC DIESEL
04	GRADE	DLX	DLX TYPE
04	GRADE	EX	EX TYPE
04	GRADE	EXS	EXS TYPE
04	GRADE	STD	STANDARD TYPE
04	GRADE	SULNG	SUPER LOUNGE TYPE
06	GEAR SHIFT TYPE	4FC	ATM, 4-SPEED FLOOR SHIFT
06	GEAR SHIFT TYPE	5F	MTM, 5-SPEED FLOOR SHIFT
07	ROOF	HRF	HIGH-ROOF
07	ROOF	SRF	STANDARD ROOF
08	SEATING CAPACITY	10S	10-SEATER
08	SEATING CAPACITY	20S	20-SEATER
08	SEATING CAPACITY	26S	26-SEATER
08	SEATING CAPACITY	29S	29-SEATER
08	SEATING CAPACITY	39C	39-SEATER
08	SEATING CAPACITY	44C	44-SEATER (SCHOOL BUS)
09	COOLER	WC	WITH COOLER
09	COOLER	WOC	WITHOUT COOLER
10	BUILDING CONDITION	CBU	COMPLETELY BUILT UNIT
10	BUILDING CONDITION	IV	INCOMPLETE VEHICLES (CHASSIS & CAB)

Vehicle_Model_Select

exec	catalog	model_name	catalog_code	models_codes	sh_prod_start	sh_prod_end	date	model_code	prod_start	prod_end	frame	engine1	grade	trans	f1	f2	f3	f4
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB20-MDRY	198205	198302	BB20	3B	DLX	5F	SRF	26S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB20-MDY	198205	198302	BB20	3B	DLX	5F	SRF	26S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB20-MDZRY	198205	198302	BB20	3B	DLX	5F	HRF	26S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB20-MDZY	198205	198302	BB20	3B	DLX	5F	HRF	26S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB20-MRKY	198205	198302	BB20	3B	STD	5F	SRF	39C	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB20-MRY	198205	198302	BB20	3B	STD	5F	SRF	26S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB20-MRY2	198205	198302	BB20	3B	STD	5F	SRF	26S	WOC	IV
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB20-MRZY	198205	198302	BB20	3B	STD	5F	HRF	26S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB21-MD	198302	199301	BB21	3B	DLX	5F	SRF	26S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB21-MDR	198302	199301	BB21	3B	DLX	5F	SRF	26S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB21-MDZ	198302	199301	BB21	3B	DLX	5F	HRF	26S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB21-MDZR	198302	199301	BB21	3B	DLX	5F	HRF	26S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB21-MR	198302	199301	BB21	3B	STD	5F	SRF	26S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB21-MRK	198302	199301	BB21	3B	STD	5F	SRF	39C	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB21-MRZ	198302	199301	BB21	3B	STD	5F	HRF	26S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB21-MR2	198302	198510	BB21	3B	STD	5F	SRF	26S	WOC	IV
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB23-MDZR	198808	199301	BB23	14B	DLX	5F	HRF	26S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB23-PDZR	198808	199301	BB23	14B	DLX	4FC	HRF	26S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB24-MGZR	198808	199301	BB24	14B	EX	5F	HRF	26S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB24-PGZR	198808	199301	BB24	14B	EX	4FC	HRF	26S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB26V-MDZ	198408	199301	BB26	3B	DLX	5F	HRF	10S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB26V-MDZR	198408	199301	BB26	3B	DLX	5F	HRF	10S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB30-MDY	198205	198302	BB30	3B	DLX	5F	SRF	29S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB30-MDZY	198205	198302	BB30	3B	DLX	5F	HRF	29S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB30-MRKRY	198205	198302	BB30	3B	STD	5F	SRF	44C	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB30-MRY	198205	198302	BB30	3B	STD	5F	SRF	29S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB30-MRZY	198205	198302	BB30	3B	STD	5F	HRF	29S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB31-MD	198302	199301	BB31	3B	DLX	5F	SRF	29S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB31-MDZ	198302	199301	BB31	3B	DLX	5F	HRF	29S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB31-MR	198302	199301	BB31	3B	STD	5F	SRF	29S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB31-MRK	198408	199301	BB31	3B	STD	5F	SRF	44C	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB31-MRKR	198302	199301	BB31	3B	STD	5F	SRF	44C	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB31-MRZ	198302	199301	BB31	3B	STD	5F	HRF	29S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	BB36V-MDZ	198408	199301	BB36	3B	DLX	5F	HRF	10S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB30-MD	198205	199001	HB30	2H	DLX	5F	SRF	29S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB30-MDR	198205	198510	HB30	2H	DLX	5F	SRF	29S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB30-MDZ	198205	199001	HB30	2H	DLX	5F	HRF	29S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB30-MDZR	198205	199001	HB30	2H	DLX	5F	HRF	29S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB30-MD2	198205	198510	HB30	2H	DLX	5F	SRF	29S	WOC	IV
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB30-MGZER	198205	198510	HB30	2H	EXS	5F	HRF	20S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB30-MGZGR	198305	198510	HB30	2H	EX	5F	HRF	29S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB30-MGZR	198205	198510	HB30	2H	EX	5F	HRF	26S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB31-MDZRX	198510	199001	HB31	12HT	DLX	5F	HRF	29S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB31-MGZERX	198510	199301	HB31	12HT	EXS	5F	HRF	20S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB31-MGZGRX	198510	199301	HB31	12HT	EX	5F	HRF	29S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB31-MGZRX	198510	199301	HB31	12HT	EX	5F	HRF	26S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB31-PDZRX	198510	199001	HB31	12HT	DLX	4FC	HRF	29S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB31-PGZERX	198510	199301	HB31	12HT	EXS	4FC	HRF	20S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB31-PGZGRX	198510	199301	HB31	12HT	EX	4FC	HRF	29S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB31-PGZRX	198510	199301	HB31	12HT	EX	4FC	HRF	26S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB32-MGZERX	198808	199001	HB32	12HT	EXS	5F	HRF	20S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB32-MGZGRX	198808	199001	HB32	12HT	EX	5F	HRF	29S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB32-MGZRX	198808	199001	HB32	12HT	EX	5F	HRF	26S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB32-PGZERX	198808	199001	HB32	12HT	EXS	4FC	HRF	20S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB32-PGZGRX	198808	199001	HB32	12HT	EX	4FC	HRF	29S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB32-PGZRX	198808	199001	HB32	12HT	EX	4FC	HRF	26S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB36V-MDZ	198408	199001	HB36	2H	DLX	5F	HRF	10S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HB36V-MDZR	198408	199001	HB36	2H	DLX	5F	HRF	10S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HDB20-PGZERX	199001	199301	HDB20	1HDT	EXS	4FC	HRF		WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HDB30-MDZRX	199001	199301	HDB30	1HDT	DLX	5F	HRF	29S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HDB30-PDZRX	199001	199301	HDB30	1HDT	DLX	4FC	HRF	29S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HDB31-MGZERX	199001	199301	HDB31	1HDT	SULNG	5F	HRF	20S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HDB31-MGZGRX	199001	199301	HDB31	1HDT	EX	5F	HRF	29S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HDB31-MGZRX	199001	199301	HDB31	1HDT	EX	5F	HRF	26S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HDB31-PGZERX	199001	199301	HDB31	1HDT	SULNG	4FC	HRF	20S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HDB31-PGZGRX	199001	199301	HDB31	1HDT	EX	4FC	HRF	29S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HDB31-PGZRX	199001	199301	HDB31	1HDT	EX	4FC	HRF	26S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HZB30-MDZ	199001	199301	HZB30	1HZ	DLX	5F	HRF	29S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HZB30-MDZR	199001	199301	HZB30	1HZ	DLX	5F	HRF	29S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HZB30-PDZR	199001	199301	HZB30	1HZ	DLX	4FC	HRF	29S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HZB31-MGZGR	199001	199301	HZB31	1HZ	EX	5F	HRF	29S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HZB31-PGZGR	199001	199301	HZB31	1HZ	EX	4FC	HRF	29S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	HZB36V-MDZR	199001	199301	HZB36	1HZ	DLX	5F	HRF	10S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	RB20-MD	198205	199301	RB20	22R	DLX	5F	SRF	26S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	RB20-MDR	198205	199301	RB20	22R	DLX	5F	SRF	26S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	RB20-MDZ	198205	198510	RB20	22R	DLX	5F	HRF	26S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	RB20-MDZR	198205	199301	RB20	22R	DLX	5F	HRF	26S	WC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	RB20-MR	198205	199301	RB20	22R	STD	5F	SRF	26S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	RB20-MRK	198205	199301	RB20	22R	STD	5F	SRF	39C	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	RB20-MRZ	198205	198510	RB20	22R	STD	5F	HRF	26S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	RB20-MR2	198205	198510	RB20	22R	STD	5F	SRF	26S	WOC	IV
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	RB26V-MDZ	198408	199301	RB26	22R	DLX	5F	HRF	10S	WOC	CBU
Exec	JP	COASTER	811120	RB2#,BB2#,3#,HB3#,HZB3#,HDB20,3#	198205	199301	199312	RB26V-MDZR	198408	199301	RB26	22R	DLX	5F	HRF	10S	WC	CBU