Can anyone tell me what tables are updated when integration manager is used. We import invoices daily from our billing system and are trying to automate the process using SQL however I do not know what table(s) or fields are updated when integration manager is executed.
*This post is locked for comments
Michale,
Here is SOP Transaction flow.
| Save | Posted |
|
SAVED
|
POSTED
|
| SOP10100 – SOP_HDR_WORK | SOP30200 – SOP_HDR_HIST |
| SOP10200 – SOP_LINE_WORK | SOP30300 – SOP_LINE_HIST |
| Other Tables | |
| SOP10101 SOP_Commission_WORK_HIST | SOP10101 SOP_Commission_WORK_HIST |
| SOP10102 SOP_Distribution_WORK_HIST | SOP10102 SOP_Distribution_WORK_HIST |
| SOP10103 SOP_Payment_WORK_HIST | SOP10103 SOP_Payment_WORK_HIST |
| SOP30201 SOP_Deposit_HIST | |
| SOP10104 SOP_Process_Holds_WORK_HIST | SOP10104 SOP_Process_Holds_WORK_HIST |
| SOP10105 SOP_Tax_WORK_HIST | SOP10105 SOP_Tax_WORK_HIST |
| SOP10106 sopUsrDefWorkHist | SOP10106 sopUsrDefWorkHist |
| SOP10107 sopTrackingNumbersWorkHist | SOP10107 sopTrackingNumbersWorkHist |
| SOP10112 sopWorkflowWorkHist | SOP10112 sopWorkflowWorkHist |
| SOP10201 SOP_Serial_Lot_WORK_HIST | SOP10201 SOP_Serial_Lot_WORK_HIST |
| SOP10202 SOP_LINE_CMT_WORK_HIST | SOP10202 SOP_LINE_CMT_WORK_HIST |
| SOP10203 sopBinWorkHist | SOP10203 sopBinWorkHist |
| SOP10204 sopExtPricingPromoWork | |
| SOP60100 SOP_POPLink | SOP60100 SOP_POPLink |
| SOP40500 SOP_Master_Number_SETP | SOP40500 SOP_Master_Number_SETP |
It will be difficult task if you try to Automate process using SQL , but you can use eConnect and Dynamics GP Webservice to Automate and schedule your integration without user interface.
Thanks
Sandip
Michale,
Here is SOP Transaction flow.
|
Save |
Posted |
|
SAVED
|
POSTED
|
| SOP10100 – SOP_HDR_WORK | SOP30200 – SOP_HDR_HIST |
| SOP10200 – SOP_LINE_WORK | SOP30300 – SOP_LINE_HIST |
| Other Tables | |
| SOP10101 SOP_Commission_WORK_HIST | SOP10101 SOP_Commission_WORK_HIST |
| SOP10102 SOP_Distribution_WORK_HIST | SOP10102 SOP_Distribution_WORK_HIST |
| SOP10103 SOP_Payment_WORK_HIST | SOP10103 SOP_Payment_WORK_HIST |
| SOP30201 SOP_Deposit_HIST | |
| SOP10104 SOP_Process_Holds_WORK_HIST | SOP10104 SOP_Process_Holds_WORK_HIST |
| SOP10105 SOP_Tax_WORK_HIST | SOP10105 SOP_Tax_WORK_HIST |
| SOP10106 sopUsrDefWorkHist | SOP10106 sopUsrDefWorkHist |
| SOP10107 sopTrackingNumbersWorkHist | SOP10107 sopTrackingNumbersWorkHist |
| SOP10112 sopWorkflowWorkHist | SOP10112 sopWorkflowWorkHist |
| SOP10201 SOP_Serial_Lot_WORK_HIST | SOP10201 SOP_Serial_Lot_WORK_HIST |
| SOP10202 SOP_LINE_CMT_WORK_HIST | SOP10202 SOP_LINE_CMT_WORK_HIST |
| SOP10203 sopBinWorkHist | SOP10203 sopBinWorkHist |
| SOP10204 sopExtPricingPromoWork | |
| SOP60100 SOP_POPLink | SOP60100 SOP_POPLink |
| SOP40500 SOP_Master_Number_SETP | SOP40500 SOP_Master_Number_SETP |
It will be difficult task if you try to Automate process using SQL , but you can use eConnect and Dynamics GP Webservice to Automate and schedule your integration without user interface.
Thanks
Sandip
#1
André Arnaud de Cal...
291,622
Super User 2024 Season 2
#2
Martin Dráb
230,354
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
