Reporting and Analytics Standard Export supports end-of-day (EOD) and end-of-week (EOW) exports from all Point-of-Sale (POS) applications that can interface with Oracle Hospitality Enterprise Back Office. After the system receives EOD information, the export process creates an export file based on export configurations. Users can then access the export file on an SFTP server hosted by Cloud Services, or can configure Standard Export to upload the file to a third-party SFTP server or attach the file in an email to a designated recipient.
The following table describes the field types, variable types, and maximum sizes used in the export files:
Table 20-1 Standard Export Field Types
| Field Type Name | Variable Type and Maximum Size | Example |
|---|---|---|
|
Bit |
Numeric (1) |
0 or 1 |
|
String |
Varchar (255) |
Coffee |
|
Integer |
Numeric (10) |
1234567890 |
|
Currency |
Numeric (12,2) |
13.34 |
|
Integer Count |
Numeric (7) |
9,999,999 |
|
DateTime |
YYYYMMDDHHMMSS |
20071231005324 |