migration:
  type: FILE
  sourceDatabase:
    type: sqlserver
    host: 192.168.100.25
    port: 1433
    name: cpcimb
    username: sa
    password: D4tacom!
    properties: encrypt=true;trustServerCertificate=true;
  target: null
  schema:
  - target: pbx
    table: pbxlist
    history: null
    group: null
    attribute:
      code: pbx_code
      name: description
      ipPbx: ip_pbx
      pbxSupporter: pbx_supporter
      sharePath: share_path
      appliedDate: ext_start
      expiredDate: ext_end
  - target: corcos
    table: womastercorcos
    history: null
    group: null
    attribute:
      command: command
      name: short_desc
      description: description
  - target: provider
    table: provider
    history: null
    group: null
    attribute:
      code: provider_prefix
      name: description
      description: description
  - target: account
    table: account
    history: accounthistory
    group: null
    attribute:
      id: history.account_id
      code: account_code
      name: history.account_number
      description: description
      appliedDate: history.app_datetime
      expiredDate: history.exp_datetime
  - target: trunk
    table: trunk
    history: trunkhistory
    group: null
    attribute:
      id: history.trunk_id
      code: trunk_code
      name: description
      pbx_id: location_code
      direction: cap_direction
      appliedDate: history.app_datetime
      expiredDate: history.exp_datetime
  - target: costCenter
    table: costcenter
    history: costcenterhistory
    group: null
    attribute:
      id: history.costcenter_id
      code: costcenter_code
      name: costcenter_name
      description: description
      email: costcenter_email
      parent_id: history.parent_costcenter_id
      structure: history.costcenter_id_structure
      appliedDate: history.app_datetime
      expiredDate: history.exp_datetime
  - target: organization
    table: organization
    history: organizationhistory
    group: null
    attribute:
      id: history.organization_id
      code: organization_code
      name: organization_name
      description: description
      email: organization_email
      emailOnOverBudget: sendemail_overbudget
      parent_id: history.parent_organization_id
      structure: history.organization_id_structure
      appliedDate: history.app_datetime
      expiredDate: history.exp_datetime
      cpid: history.organization_id
  - target: phoneUser
    table: phoneuser
    history: phoneuserhistory
    group: phoneuserextlist
    attribute:
      id: history.phoneuser_id
      code: phoneuser_code
      name: phoneuser_name
      email: phoneuser_email
      whatsapp: phoneuser_mobile
      position: position
      emailOnOverBudget: sendemail_overbudget
      pin: history.phoneuser_pin
      extension: history.default_extension
      organization_id: history.organization_code
      costCenter_id: history.costcenter_code
      pbx_id: history.pbx_code
      appliedDate: history.app_datetime
      expiredDate: history.exp_datetime
      pbx__list: group.pbx_list
      budget__maxCost: history.max_cost
      budget__warnCost: history.warn_cost
  - target: callTransaction
    table: calltransaction_20260127
    history: null
    group: null
    attribute:
      direction: direction
      startOfCall: start_of_call
      duration: duration
      extension: ext_used
      pin: pin
      phoneUser_id: phoneuser_code
      extTransferFrom: ext_transfer_from
      extTransferTo: ext_transfer_to
      number: dialed_number
      callerNumber: caller_number
      accessNumber: access_number
      organization_id: organization_code
      costCenter_id: costcenter_code
      cost: cost_1
      service: cost_service
      tax: cost_tax1
      discount: cost_adjustment
      currency: currency
      pbx_id: pbx_code
      terminationCode: call_termination
      redirectReason: redirect_reason
      account_id: account_code
      trunk_id: trunk_code
  - target: webUser
    table: usersetup
    history: null
    group: null
    attribute:
      username: login_id
      password: login_password
      name: description
      phoneUser_id: phoneuser_code
      loginPin: used_pin
  lastTarget: pbx;corcos;provider;account;trunk;costCenter;organization;phoneUser;callTransaction;webUser
  lastAction: '2026-03-02 16:31:09'