Files
OMS/app/invoice/dbschema/goods_items.php
2026-01-04 19:08:31 +08:00

73 lines
2.4 KiB
PHP
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
<?php
/**
* Copyright 2012-2026 ShopeX (https://www.shopex.cn)
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
#商品与服务税收分类编码
$db['goods_items']=array(
'columns' =>
array(
'id' => array(
'type' => 'int(10)',
'pkey' => true,
'extra' => 'auto_increment',
'required' => true,
),
'channel_type' =>
array (
'type' => 'varchar(32)',
'default' => 'bw',
'required' => true,
'default' => 'taobao',
'comment' => '渠道类型',
),
'tax_code' =>
array (
'type' => 'varchar(255)',
'comment' => '发票分类合并编码',
'editable' => false,
),
'tax_rate' => array(
'type' => 'tinyint(2)',
'default' => '0',
'label' => '税率',
),
'name' =>
array (
'type' => 'varchar(200)',
'required' => true,
'default' => '',
'comment' => '商品和服务名称',
),
'zzstsgl' => array(
'type' => 'varchar(255)',
'comment' => '增值税特殊管理',#如果yhzcbs为1时此项必填具体信息取百望《商品和服务税收分类与编码》.xls中的增值税特殊管理列
),
'create_time' => array(
'type' => 'time',
'default' => '0',
'comment' => '创建时间',
),
'update_time' => array(
'type' => 'time',
'default' => '0',
'comment' => '更新时间',
),
),
'comment' => '商品与服务税收分类编码',
'engine' => 'innodb',
'version' => '$Rev: $',
);