Fixed asset voucher generation method and device based on data source access, and medium

The invention discloses a fixed asset voucher generation method and device for data source access, and a medium, and is used for solving the problems that an existing data source access mode is relatively complex in query statement, relatively large in workload during modification, and needs to carry out additional processing on data. The method comprises the following steps: receiving a voucher generation request and determining a corresponding fixed asset and a service type of the fixed asset; determining a voucher data source corresponding to the voucher generation request in the corresponding service type so as to determine a voucher template based on the voucher data source and according to the service voucher demand; determining a data source access SQL (Structured Query Language) statement corresponding to the voucher template and splitting the data source access SQL statement to obtain corresponding data source access information; obtaining an actual demand after the business voucher is updated, and a