-
Type:
Feature Request
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: No Longer Required
-
Affects Version/s: None
-
Fix Version/s: CFA 2019R2
-
Component/s: Core
-
Labels:
-
INF Reference Number:INF-11478
BRD: https://docs.google.com/document/d/1atV976ssSeD5TPFehu_2Pxejosn_mSi1EGQrmCRJ008/edit?usp=sharing
FRD: https://docs.google.com/document/d/1393dy58jOp-CBCPC_AviZFzD8aVmO4CmGOx-e-o7JdI/edit?usp=sharing
In support of expanding OnDemand delivery to all stores, the Cash Day Summary (CDS) will require OnDemand data to be broken down to a 'per vendor' level. The CDS currently relays OnDemand data that is rolled up into total gross sales and sales count. This adjustment will allow the CDS to also show the same sales data, but broken down by vendor(DoorDash, Grubhub, UberEats, etc) as determined by the digital channel id.
List of Requirements:
- Add new section in the CDS "Other Cash Info" section that displays the daily OnDemand transaction count, net sales and net tax.
- Update the Cash Management web service to accept the updated CDS schema as described above.
- Update the InFORM 1.0 application to accept the new fields within the CDS and write them to CFARIS.
- Create new table in CFARIS that includes the following columns and [data types]:
- Node_ID [varchar2, 5 bytes]
- Location_Num [varchar2, 5 bytes]
- Business_Date [date]
- Digital_Channel_ID [number 12, 0]
- Transaction_Cnt [number 12, 0]
- Net_Sales [number 20, 4]
- Sales_Tax [number 20, 4]
- Created_Timestamp [date]
- Last_Modified_User_ID [varchar2, 32 bytes]
- Last_Modified_Timestamp [date]
- Primary Key: Location_Num, Business_Date, Digital_Channel_ID
[~ben.hendricks], Chris Jones
- is implemented by
-
CFAMX-1303 Add OnDemand Detail to Cash Day Summary
- Closed
-
CFAMX-3541 CDS: Remove Digital Channel Name
-
- Done
-
-
-
- Done
-