Of ERP project: there are two, one is the ERP system (offline database) at the front desk, another regent ERP, main task: the regent sales single synchronization to preach at the front desk system , and let the family system is able to identify normal.
-- -- -- -- -- -- -- -- -- -- --
Division system description:
Families and the program interface: (due to the front desk support offline data, right to interact with the server backstage, parallel, together)
-- -- -- -- -- -- -- -- -- -- --
The offline database: sqlite31d. Db
-- -- -- -- -- -- -- -- -- -- --
Main storage data table: xf_transdata
Data in the table sales fields: xf_txmsg// prompt , the related business data will be stored here, in sales, for example.
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Describe a scenario:
1. Don't have data on the family with a document
Interface. 2. The other party does not allow do so only with the front desk docking process sales data synchronization
3. I can pass the program to obtain the ritz sales list,
4. I passed through a long period of time after the system was simulated, compared to find xf_txmsg find inside sales format transfer rules, families, the front desk to regent sales single write to the data table
As shown in figure:
5. Enter the system can only see: I write data inside red box marked function, blue box without
6. Pass the front desk system, no calculation I write sales, inventory is no change,
Instructions written xf_txmsg sales is how to calculate the inventory are not calculated in the table,
I guess: if need to login in, the local sales synchronization to the background, background calculation then downloaded to the local inventory,
Or directly in the local system directly write the calculation logic functions on certain function to calculate the inventory?
My personal guess is that the former,
Requirements: I'm in the regent system into the sales, synchronization to preach at the front desk system data in the table (with actual at the front desk sales function),
And inventory will be calculated,
A train of thought and solution:
(for some reason: 1. Don't have the data and document
Interface. 2. The other party does not allow do so only with the front desk docking process sales data synchronization)
3. Otherwise I won't do such a plan to deal with,