进出口(海关)新系统的操作流程–20040923-数据库专栏,SQL Server

进出口(海关)新系统的操作流程

Ø             数据准备和实际操作
     1)  出货资料的设定;
  import-export\ basic data et shipment
     2)  保税资料的设定;
  import-export\ basic data et contral type
     3)  进货原料类型的设定;
  import-export\ basic data\import material
     4)  出货产品类型的设定;
  import-export\ basic data\ export product
     5)  手册基本资料的设定;
  import-export\ basic data\ handbook data
  import-export\ basic data\ overview-handbook detail
     6)  手册进货原料的资料导入;
  import-export\ basic data\ handbook data -> load import data
     7)  手册出货产品的资料导入;
  import-export\ basic data\ handbook data -> load export data
     8)  报关单资料的设定;
  import-export\ basic data\ declaration data
  import-export\ basic data\ overview-declaration detail
     9)  发票资料的设定;
  import-export\ basic data\ overview-invoice detail
     10) 发票-报关单之间关联的设定;
  import-export\ basic data\ declaration data -> invoice
     11) 报关单-手册之间关联的设定;
  import-export\ basic data\ handbook data -> declaration
     12) 发票-手册之间关联的设定;
  import-export\ basic data\ handbook data -> invoice
     13) 手册进货原料的进口备案量的设定;
  import-export\ basic data\ handbook data -> import
     14) 手册出货产品的出口备案量的设定;
  import-export\ basic data\ handbook data -> export
     15) 进出口(海关)系统的bom资料导入;
  import-export\ basic data\ export product detail
                             -> load structure(fill)
                             -> load structure(all)
  import-export\ basic data\ export product structure
                             -> load structure(replace)
     16) 进出口(海关)系统的bom资料维护;
  import-export\ basic data\ export product structure

Ø                    业务流程和实际操作

1)   进货原料的资料导入及维护;

import-export\ business\ import material -> load import material detail

2)   出货产品的资料导入及维护;

import-export\ business\ export product -> load export product detail

3)   出货产品资料的bom展开及展开资料的维护;

import-export\ business\ export product -> load export product detail
import-export\ business\ export product -> bom expand(selected)
import-export\ business\ export product -> bom expand(all)
import-export\ business\ export product -> show material data

4)   进出货资料里修改报关单号以及手册号;

import-export\ business\ import material
import-export\ business\ export product

5)   根据发票里设定的报关单号和手册号来更新进出货资料

import-export\ basic data\ handbook data -> invoice

import-export\ basic data\ declaration data -> invoice

import-export\ basic data\overview-invoice detail
-> update import-export data(all)
-> update import-export data(selected)

6)   核销手册的进货实际数量的导入及维护;

import-export\ basic data\ handbook data -> import

->load actual qty(selected)

->load actual qty(all)

7)   核销手册的出货实际数量的导入及维护;

import-export\ basic data\ handbook data -> export

->load actual qty(selected)

->load actual qty(all)

8)   核销手册的出货耗用量和损耗量的导入及维护;

import-export\ basic data\ handbook data -> import

->load material used qty(selected)

->load material used qty(all)

9)   (非)保税料件进出控制表的新增;

import-export\ business\ (un)bonded io contral

10)             (非)保税料件进出控制表的数据导入及期初库存量录入;

import-export\ business\ (un)bonded io contral -> load (un)bonded data

import-export\ business\ (un)bonded io contral -> detail

11)              非保税料件进出控制表的手册补税量录入;

import-export\ business\ unbonded io contral -> detail

12)              (非)保税料件进出控制表的进货量及退回量的导入;

import-export\ business\ (un)bonded io contral -> detail
-> load import qty(selected)
-> load import qty(all)

13)              (非)保税料件进出控制表的出货耗用量及损耗量的导入;

import-export\ business\ (un)bonded io contral -> detail
-> load used qty(selected)
-> load used qty(all)