Kbase 63943: List of Database x Modules of the Datasul product
| Autor |
Tatiane Koslinsky - CAT |
| Acesso |
Público |
| Publicação |
29/09/2017 |
|
List of databases used by the Datasul product and its respective modules:
Hospital Management Module - Health:
srcadger: General Registration
srmovben: Beneficiary transaction
srmovcon: Account transaction
srmovfi1: Financial transaction I
srmovfin: Financial transaction
srweb: WEB register/movement
Agribusiness Module
emsgra: Grains
TOTVS toolkit, for example: Ekanbam
totvsgen: TOTVS Generic
Location Databases:
cad2loc: International Register EMS2
mov2loc: International Transaction EMS2
cad5loc: International Register EMS5
mov5loc: International Transaction EMS5
BI Module:
emsinc: Business Analytics
Datasul accessory components, such as MAF, MOE, MSC:
emsdca: Datasul accessory components
Fleet Module:
mgfro: Fleets
movfro: Fleet movement
Human Resources Module - HCM
dthrpmg: Organizational Development
dthrpyc: Pay-office
dthrcpj: Project Control
dthrtma: Attendance Control
dthrgst: Staff Management
payroll2: HCM Portal
Audit Module:
mgadt: Audit Trail
Product foundation:
emsfnd: Foundation
Financial Module:
emsbas: Basic tables
emsfin: Financial Registers
emsuni: Universal Tables
emsedi: EDI
movfin: Financial Transactions
Finance: Applications and Loans
Screen Optimizer screen:
mgsop: Screen Optimizer
mgsor: Screen Optimizer
APS Module
mgdbr: APS
movdbr: APS transaction
mgaps: APS
CRM Module:
mdtcrm: CRM
Integration queue
EAI: Integration EAI 1.00
Eai2: Integration EAI 2.00
Representative Checking Account Module
mgrac: Representative Checking Account
movrac: Representative Checking Account Transaction
Industrial Module
movind: Industrial Movement
movmnt: Industrial Maintenance Movement
mgadm: Administrative
movadm: Administrative Movement
mgdis: Distribution
movdis: Distribution Movement
wmovdis: Distribution Temporary
mgfis: Fiscal
movfis: Tax Transaction
mgcld: Data Collection
mgcex: Foreign Trade
mginv: Investments
mgind: Industrial
mgmnt: Industrial Maintenance
mgmfg: Manufacture
movmfg: Manufacture Movement
mgmrp: Planning
mgscm: Freights/Warehouse
neogrid: E-collaboration Neogrid
mguni: Universal
emsdev: Framework
mdtfrw: Metadata
mdmerge: Metadata
Databases EMSDEV, EMSFND, MDMERGE, FINANCE, EMS2SOR, PAYROLL2, MDTFRW: Databases accessed via JDBC via sQL port.