NPC Export File Data Definition

The NPC data export file consists of 4 record types as described below.

Note: All amounts are shown in the bank currency.

Vendor Record

Required - 1 per funding currency batch; multiple batches per commission file.

Field Name	Type	Start	Length	Decimals	Req'd/Opt.	Comments
Record Type	CHAR	1	1		R	A= Vendor record for this currency batch.
Batch currency code	CHAR	2	3		r	Funding currency code for this batch. Example: NOK -= Norwegian Krone, USD = US dollars.
File date	NUMERIC	5	8		R	Date file created (mmddyyyy)
Vendor #	CHAR	13	6		R	NPC assigned number
Vendor type	CHAR	19	1		R	2=Hotel
Vendor name	CHAR	20	30		R
Vendor address1	CHAR	50	30		R
Vendor address2	CHAR	80	30		O
Vendor city	CHAR	110	30		R
Vendor state/province	CHAR	140	28		O
Vendor ZIP/postal code	CHAR	168	10		O
Vendor contact phone #	CHAR	178	30		R	Vendor phone # for NPC Commision Express
Vendor cust. Svc. phne #	CHAR	208	30		O	Vendor customer service phone # as it should appear on vendor's report
Vendor email address	CHAR	238	50		O	If billing is set at vendor level, email address to which NPC can send a funds required confirmation and related billing information. Otherwise, spaces.
Vendor fax #	CHAR	288	30		O	If billing is set at the vendor level, fax # to which NPC can send a funds required confirmation and related billing information. Otherwise, spaces.
Vendor # records	NUMERIC	318	7		R	Total number of detail records in this currency batch. Total should include any optional tax detail records.
Vendor total amount	SIGNED NUMERIC	325	20	2	R	Total vendor commission payments for this currency batch including any optional tax detail records. No commas, decimals, or currency symbols. Required sign in the first character position. Example: 5000.00 = +0000000000000500000
Vendor country code	CHAR	345	2		O	Example: US = USA, DE = Germany. This is an ISO code.
Vendor customer. service phone # 2	CHAR	347	30		O	Vendor customer service phone # as it should appear on the Agent's report.
Batch currency entry cd*	CHAR	377	2		O	Default for Euro currency will be DE (German). Example: International: 123-1-123- 1234. If currency = Euro, then the country currency has to be sent also.
Unassigned	space filled	377	124

Total record length			500

All optional and unassigned columns should be space filled if not data populated. All character columns should be left-justified. All numeric columns should be right-justified.

*Accepted Euro Funding countries are AT (Austria), BE (Belgium), DE (Germany), ES (Spain), FI (Finland), FR (France), IT (Italy), and NL (Netherlands).

Agency Record

Required - many per currency batch.

Field Name	Type	Start	Length	Decimals	Req'd/Opt.	Comments
Record type	CHAR	1	1		R	C = Agency record
Batch currency code	CHAR	2	3		R	Funding currency code of this batch of your commissions. Must be consistent for all agency records within batch.
Agency #	CHAR	5	8		R	IATA, ARC, CLIA, or BSP Agency #. If no IATA exists send RNnnnnn where n = internal ID (name ID) of agency.
Agency name*	CHAR	13	35		R
Agency address1*	CHAR	48	35		R
Agency address2*	CHAR	83	35		O
Agency city*	CHAR	118	30		R
Agency state/province*	CHAR	148	28		O/R	Required if USA. Use 2- character state code. Example: US = 47172-0203; Canada = T1Y 1N5
Agency country name*	CHAR	186	26		R	Example: US, France, Canada, etc.
Agent contact name*	CHAR	212	30		O
Agent phone #*	CHAR	242	30		O
Agent currency*	CHAR	272	3		O	Default = USD
Agency country code	CHAR	275	2		O	Mailing address country code. Example: US = USA, DE = Germany
Sub- vendor #	CHAR	277	6		O	Consistent with sub-vendor # from the optional batch sub- vendor record (B record)
Currency country cd*	CHAR	283	2		R/O	Required for Euro currency. Optional otherwise.
Unassigned	space filled	285	216

Total record length			500

All optional and unassigned columns should be space filled if not data populated. All character columns should be left-justified. All numeric columns should be right-justified.

*Agency data is required for use as the mailing address if the agency is not already in Commission Express's agency master file.

**Euro draft payment options are available to agencies located in Belgium, Germany, Spain, Finland, France, Greece, Ireland, Luxembourg, Italy, Netherlands, and Portugal.

Detail Record

Required - many per currency batch.

Field Name	Type	Start	Length	Decimals	Req'd/Opt.	Comments
Record type	CHAR	1	1		R	D = Detail record
Batch currency code	CHAR	2	3		R	Funding currency code for this batch of commissions. Must be consistent for all detail records within this batch.
Agency #	CHAR	5	8		R	IATA, ARC, CLIA, or BSP agency . If no IATA exists send RNnnnnn where n = internal ID (name ID) of agency.
Guest name	CHAR	13	25		O
Confirm #	CHAR	38	15		O
Arrival date	CHAR	53	6		O	In mmddyy format.
Departure date	CHAR	59	6		O	In mmddyy format.
Hotel charge	SIGNED NUMERIC	65	20	2	O	No commas, decimals, or currency symbols. Required sign in first character position. Example: 5000.00 = +0000000000000500000
Reference	CHAR	85	12		O	Example: NO SHOW, COMM PAID
Commission %	NUMERIC	97	4	4	O	Example: 10% = 1000
Unassigned	space filled	101	20
Commission amount	SIGNED NUMERIC	121	20	2	R	No commas, decimals, or currency symbols. Required sign in first character position. Example: 5000.00 = +0000000000000500000
Asterisk	CHAR	141	1		O	Asterisk used in combination with a message record.
Hotel #	NUMERIC	142	10		R
Hotel name	CHAR	152	75		R
Nights stayed	CHAR	227	3		O
Unassigned	space filled	230	4
Sub- vendor #	CHAR	234	6		O	If you are reporting or billing at a sub-vendor level, provide the appropriate sub-vendor # for this detail record.
Unassigned	space filled	240	161
Vendor variable data	CHAR	401	100		O	Reserved for vendor use as defined by contract.

Total record length			500

All optional and unassigned columns should be space filled if not data populated. All character columns should be left-justified. All numeric columns should be right-justified.

Tax Detail Record

Optional - many per currency batch.

Field Name	Type	Start	Length	Decimals	Req'd/Opt.	Comments
Record type	CHAR	1	1		R	D = Tax detail record
Batch currency code	CHAR	2	3		R	Funding currency code for this batch of commissions. Must be consistent for all detail records within this batch.
Agency #	CHAR	5	8		R	IATA, ARC, CLIA, or BSP agency . If no IATA exists send RNnnnnn where n = internal ID (name ID) of agency.
Guest name	CHAR	13	25		O	This field should be populated with the guest name to report the tax at the guest/transaction level. To report at the agency level, initialize with spaces. If this field is populated, Hotel # and Hotel name must also be provided.
Unassigned	space filled	38	15
Sort control #1	CHAR	53	6		R	To report the tax at the guest/transaction level, this field should be populated with the rental start date and sort control #2 should be all 9s. To report at the agency level, initialize with all 9s.
Sort control #2	CHAR	59	6		O	See sort control #1. To report the tax at the guest/transaction level, this field should be populated with all 9s.
Unassigned	space filled	65	20
Tax identifier	CHAR	85	12		O	Example: VAT, G&S TAX, PROV TAX
Unassigned	space filled	97	24
Tax amount	SIGNED NUMERIC	121	20	2	R	No commas, decimals or symbols. Example: 5000.00 = +0000000000000500000. Any tax amount here will be added into the agency's total payment and therefore should not be included in the commission amount of the detail record.
Unassigned	space filled	141	1
Hotel #	CHAR	142	10		O	If guest name is populated (you want to report the tax at the guest/transaction level), Hotel # and Hotel name must also be provided.
Hotel name	CHAR	152	75		O	If guest name is populated (you want to report the tax at the guest/transaction level), Hotel # and Hotel name must also be provided.
Unassigned	space filled	227	7
Sub- vendor #	CHAR	234	6		O	If you are reporting or billing at a sub-vendor level, provide the appropriate sub-vendor # for this detail record.
Unassigned	space filled	240	261

Total record length			500

All optional and unassigned columns should be space filled if not data populated. All character columns should be left-justified. All numeric columns should be right-justified.