MCS Web (DB Structure)

1. Master Module

1.1. MCS_CargoColdStorageRate

1.2. MCS_AirLine

1.3. MCS_BusinessType

1.4. MCS_CargoRate

1.5. MCS_CargoStorageRate

1.6. MCS_CommodityGroup

1.7. MCS_Commodity

1.8. MCS_Destination

1.9. MCS_Dock

1.10. MCS_Flight

1.11. MCS_FlightSchedule

1.12. MCS_GroundHandler

1.13. MCS_PricingPlan

1.14. MCS_StationPrinter

1.15. MCS_Store

1.16. MCS_Team

1.17. MCS_TeamMember

1.18. MCS_WeightMachine

1.19. MCS_XRayMachine

2. WMS Module

2.1. MCS_Allowshipment

2.2. MCS_BuildUp

2.3. MCS_BuildUpItem

2.4. MCS_CargoAccept

2.5. MCS_CargoAcceptItem

2.6. MCS_CargoCustomApproveLetter

2.7. MCS_CargoAppoint

2.8. MCS_CargoDimension

2.9. MCS_CargoDimensionItem

2.10. MCS_CargoInvoice

2.11. MCS_CargoInvoicePayment

2.12. MCS_CargoRelease

2.13. MCS_CargoReleaseItem

2.14. MCS_CargoReturn

2.15. MCS_Forwarder

2.16. MCS_StorageIn

2.17. MCS_StorageOut

2.18. MCS_XRayCount

3. Trans Shipment Module

3.1. MCS_TsAcceptance

3.2. MCS_TsRegistration

4. SysDBLog

5. System Module

5.1. Sys_Config

5.2. Sys_UserRoleProgram

5.3. SysAttachment

5.4. SysClient

5.5. SysCompany

5.6. SysDBLogItem

5.7. SysEmailTemplate

5.8. SysImage

5.9. SysLog

5.10. SysLogItem

5.11. SysProgram

5.12. SysProgramGroup

5.13. SysRunnginNoGenerate

5.14. SysRunnginNoGenerateItem

5.15. SysRunningNo

5.16. SysSetting

5.17. SysUser

5.18. SysUserDepartment

5.19. SysUserDevice

5.20. SysUserPosition

5.21. SysUserProgram

5.22. SysUserProgramGroup

5.23. SysUserRole

6. PSH Module

6.1. MCS_IntegrationAPILog

6.2. PSH_AcceptItemWeight

6.3. PSH_ReweightBuildUp

6.4. PSH_ULDWeight

7. MIT Module

7.1. MIT_Cash

7.2. MIT_Customer

7.3. MIT_Invoice

7.4. MIT_InvoiceItem

8. Last Updated : Chan 31/08/2020