Overview
With Delphi, we offer a 1-way integration that pulls sales.
Sync Approach
The sync connects to Delphi’s database to pull sales.
Inventory items in Yellow Dog should be mapped thru POS Item Map to report sales and deplete inventory.
The sync will need to be installed on the same server as the Delphi database.
Sync Frequency
The sync can be scheduled to run at any interval.
Requirements
Client
TBD
POS Partner
TBD
Yellow Dog
To pull sales from Delphi, Yellow Dog requires
SQL Server
Database Name
SQL Username
SQL Password
Data Exchange and Mapping
Sales Data
The following tables and columns are read by the sync:
| Delphi Table | Delphi Column | Yellow Dog Column |
|---|---|---|
| Event Item | EventItemID | Transaction Number |
| Price | Item Retail | |
| Record | Quantity | Quantity |
| Event | EventID | |
| PropertyPID | Revenue Center | |
| Name | Reference | |
| Start Date | Check Closed | |
| Guaranteed Attendance | Quantity | |
| Expected Attendance | Quantity | |
| Event Order | Number | Transaction Number |
| Is Event Order Complete | ||
| Item | ItemID | Item Number |
| PLU | SKU | |
| Name | Item | |
| Abbreviation | Item | |
| Price | Item Retail | |
| Function Room | Function Room ID | Register Number |
| Name | Register ID | |
| Employee | Initials | Employee Number |
| Full Name | Employee Name | |
| Status | Name |
