NPC (National Processing Company) Commission Export

On selecting NPC for the EFT Export Format OPERA Control, additional OPERA Control settings are enabled to provide data to include in the EFT export.

OPERA Control	Description
File Name Format	File Name Format: XF_PROPERY XF_PROPERTY_DDMMYY XF_PROPERTY_MMDDYY XF_PROPERTY_DDMMYYHH24MI XF_PROPERTY_MMDDYYHH24MI
Property ID	Property ID, maximum 10 characters.
Property Name	Name of the property/chain.
Tax Identifier	Select the tax type required.
Company	Clearinghouse company name.
Address	Address of the clearinghouse.
Telephone	Telephone number of the clearinghouse.
Fax	Fax number of the clearinghouse.
Delivery Method	Set the delivery method to be used for EFT Export: SFTP SFTP Legacy HTTPS File System (download)
SFTP Name	Name of the SFTP endpoint. Obtain this from your system administrator.

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 require confirmation and related billing information. Otherwise, spaces.
Vendor fax #	CHAR	288	30		O	If billing is set at the vendor level, fax # to that 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, and so on.
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

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

TX 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 is 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.