create table ShangPinDanWei(
DanWeiMingCheng nvarchar(20) primary key
)

{
    "商品单位":{
            "tableName":"shangpindanwei",
            "reportModel":"ShangPinDanWei.fr3",    
        "编辑":[
            {"caption":"单位：","fieldname":"DanWeiMingCheng","emptytext":"必输项","component":"dbedit","readonly":false,"onclick":""}
        ],
        "表格":[
            {"caption":"单位","fieldname":"DanWeiMingCheng","width":300}
        ]
    }
}

if exists(select * from sysobjects where name = '采购订单')
drop table 采购订单 
create table 采购订单(
采购单号 nvarchar(30) primary key,
操作人 nvarchar(20),
创建日期 datetime,
状态 nvarchar(10),
数量 decimal(18,4),
金额 decimal(18,2),
门店编号 nvarchar(20),
门店 nvarchar(100),
供应商编号 nvarchar(20),
供应商 nvarchar(100),
备注 nvarchar(100)
)

if exists(select * from sysobjects where name = '采购订单2')
drop table 采购订单2 
create table 采购订单2(
采购单号 nvarchar(30) not null,
行号 int not null,  
条码 nvarchar(20),
商品 nvarchar(100),
单位 nvarchar(20),
规格 nvarchar(30),
数量 decimal(18,4),
进货价 decimal(18,4),
金额 decimal(18,2),
PRIMARY KEY (采购单号, 行号)
)

{
    "采购订单":{
            "tableNameM":"CaiGouDingDan",
            "tableNameD":"CaiGouDingDan2",
            "billNoHead":"PO",
            "reportModel":"CaiGouDingDan.fr3",
            "明细表字段":{
                "fldBillNo":"caigoudanhao",
                "fldRecNo":"jiluhao",
                "fldBarcode":"tiaoma",
                "fldGoodsName":"shangpinmingcheng",
                "fldUnitName":"danwei",
                "fldSpec":"guige",
                "fldQty":"caigoushuliang",
                "fldPrice":"caigoujia",
                "fldAmount":"caigoujine"
            },
            "主表字段":{
                "fldBillNo":"caigoudanhao",
                "fldCreateBy":"zhidanren",
                "fldDatetime":"riqi",
                "fldStatus":"zhuangtai",
                "fldTotalQty":"caigoushuliang",
                "fldTotalAmount":"caigoujine",
                "fldShopId":"mendianbianhao",
                "fldShopName":"mendianmingcheng",
                "fldSupplierId":"gongyingshangbianhao",
                "fldSupplierName":"gongyingshangmingcheng"    
            },    
        "基本信息":[
            {"caption":"门店：","fieldname":"MenDianMingCheng","emptytext":"请选择","component":"dbedit","readonly":false,"onclick":"selectshop","fid":"mendianbianhao","fname":"mendianmingcheng"},
            {"caption":"供应商：","fieldname":"GongYingShangMingCheng","emptytext":"请选择","component":"dbedit","readonly":false,"onclick":"selectsupplier","fid":"gongyingshangbianhao","fname":"gongyingshangmingcheng"},
            {"caption":"采购单号：","fieldname":"CaiGouDanHao","emptytext":"自动生成","component":"dbedit","readonly":true,"onclick":""},
            {"caption":"备注：","fieldname":"BeiZhu","emptytext":"","component":"dbedit","readonly":false,"onclick":""}
        ],
        "单据信息":[
            {"caption":"条码","fieldname":"tiaoma","width":147,"showsum":false,"readonly":true},
            {"caption":"商品","fieldname":"shangpinmingcheng","width":300,"showsum":false,"readonly":true},
            {"caption":"单位","fieldname":"danwei","width":64,"showsum":false,"readonly":true},
            {"caption":"规格","fieldname":"guige","width":137,"showsum":true,"readonly":true},
            {"caption":"采购价","fieldname":"caigoujia","width":93,"showsum":true,"readonly":false},
            {"caption":"采购数量","fieldname":"CaiGouShuLiang","width":93,"showsum":true,"readonly":false},
            {"caption":"采购金额","fieldname":"CaiGouJinE","width":93,"showsum":true,"readonly":true}
        ]
    }
}