Gespeicherte Prozeduren zur BOD-Aufteilung
Zum Aufteilen der BOD-XML-Meldungen werden gespeicherte Prozeduren verwendet. Gespeicherte Prozeduren werden in der MS SQL Server-Datenbank gespeichert. Der Name der Datenbank ist IEVMS_LN.
Die Integration verwendet die folgenden gespeicherten Prozeduren:
| Gespeicherte Prozedur | BOD | SQL Server-Tabelle |
|---|
| sp_evms_ln_shredCodeDef | CodeDefinition | CODE |
| CODE_LC |
| sp_evms_ln_shredCurExchRate | CurrencyExchangeRateMaster | CUR_EXCH_RATE |
| sp_evms_ln_shredFnclClndrPrd | FinancialCalender | FNCL_CLNDR_PRD |
| FNCL_CLNDR_PRD_LC |
| sp_evms_ln_shredItemMaster | ItemMaster | ARTIKEL |
| ITEM_LC |
| sp_evms_ln_shredLaborCostMaster | LaborCostMaster | LABOR_COST |
| LABOR_COST_LC |
| sp_evms_ln_shredPerson | Person | PERSON |
| PERSON_LC |
| sp_evms_ln_shredProjectBudget | ProjectBudget | PROJECT_BDGT |
| PROJECT_BDGT_LC |
| sp_evms_ln_shredProjectCosts | ProjectCosts | PROJECT_COSTS |
| PROJECT_COSTS_LC |
| sp_evms_ln_shredProjectMaster | ProjectMaster | PROJECT |
| PROJECT_LC |
| PROJECT_ACTVTY |
| PROJECT_ACTVTY_LC |
| PROJECT_BSLN_LINE |
| PROJECT_BSLN_LINE_LC |
| sp_evms_ln_shredProjectProgress | ProjectProgress | PROJECT_PRGRS |
| PROJECT_PRGRS_LC |
| sp_evms_ln_shredSundryCostMaster | SundryCostMaster | SUNDRY_COST |
| SUNDRY_COST_LC |
| sp_evms_ln_shredProjectContract | ContractMaster | PROJECT_CONTRACT_HEADER |
| PROJECT_CONTRACT_HEADER_LC |
| PROJECT_CONTRACT_LINE |
| PROJECT_CONTRACT_LINE_LC |
| sp_evms_ln_shredProjectRevenue | ProjectRevenue | PROJECT_REVENUE |
| PROJECT_REVENUE_LC |
| sp_evms_ln_UserDefinedStructure | LnUserDefinedStructure | LN_USER_DEFINED_STRUCTURE_LINE |
| LN_USER_DEFINED_STRUCTURE_LINE_LC |