Create extension table retail and pull data to back office Retail 365

Create extension table retail and pull data to back office

Song Nghia - Technical Consultant

Step 1. Create table in back office

- Create sample table, table need to have 3 fields:

1.ReplicatedCounterFromOrigin

2.Replicated

3.Origin

- This is mandatory fields, MS design it to mark row and define data pulled from POS.

Step 2. Create extend table in database. Scheme is EXT

- Use query editor to get script table in dbo.

- After that, change all scheme dbo to ext, remove fields:

[PARTITION] [bigint] NOT NULL,

[RECID] [bigint] NOT NULL,

[RECVERSION] [int] NOT NULL,

- Add fields
[ROWVERSION] [timestamp] NOT NULL, => It look like RecId in dbo.

- ALTER TABLE delete line not exist fields which deleted in step 2.
- EXE script.

Step 3. Create store procedure to insert data in extension table.