Generic File Specifications
The file format for generic Commission Reconciliation is tab-delimited, no quotes, no header or trailer record. The tab character in ASCII is 9 (decimal and hex).
Dates if included must be in MM/DD/YYYY format (slashes or dashes can be used for the delimiters). The year must be four digits. The file fields are as follows.
| Field | Max # of Characters | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Paid amount |
15 |
Required (value should be zero if no payment, such as a no-show). Must be numeric. Include decimal point if needed (for example, 9.50, 10, or 10.00). 15 maximum includes decimal point and cents digits. Must be >= 0. |
||||||||
|
Traveler |
30 |
Required. Must be either last name only, or in LAST/FIRST format. The delimiter can be a forward slash (/) , comma, space, or asterisk (*). |
||||||||
|
Confirmation # |
20 |
Required if Start Date is not present. |
||||||||
|
Start date |
10 |
Required if Confirmation # is not present. MM/DD/YYYY. |
||||||||
|
Provider |
10 |
Required if the file contains records for more than one provider. If the file is for one provider only, you can specify this when importing in GlobalWare. |
||||||||
|
Payment status |
1 |
Optional. If included, must be a valid status:
If not included, records with a paid amount will be stored with status 1 and records with zero paid amount will be stored with status 10 (misc. not paid). For status 3, 4, and 5 the Paid amount must be zero. For status 1 the paid amount must be greater than zero. |
||||||||
|
Property name |
30 |
Optional. |
||||||||
|
Property address |
25 |
Optional. |
||||||||
|
Property city |
15 |
Optional. |
||||||||
|
Property state |
3 |
Optional. |
||||||||
|
Property zip |
15 |
Optional. |
||||||||
|
Property phone |
15 |
Optional. |
||||||||
|
End Date |
5 |
Optional. MM/DD/YYYY. |
||||||||
|
Total amount |
15 |
Optional. Must be numeric if included. Include decimal point if needed (for example, 9.50, 10, or 10.00). 15 maximum includes decimal point and cents digits. Must be >= 0. |
||||||||
|
Number of units |
5 |
Optional. must be numeric if included. 1 will be stored if not included. |
Additional Notes
- If you want GlobalWare to Update Booked with Paid, you must include End Date and Total Amount.
- Including optional fields, while not required, can make the GlobalWare reports more useful and is therefore recommended if they are available.
- If required fields are not present or invalid, the record will import but it will not reconcile. Using List Disk first is recommended.