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:
|
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 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.
Parent topic: About Commission EFT Export File Formats