package com.zt.plat.module.contractorder.enums;

/**
 * 表字段常量
 *
 * @author ZT
 */
public class TableFieldConstants {

    // 表主键
    public static final String ID = "ID";

    /* 合同主信息表 */
    // 系统合同编号;自动生成，校验唯一
    public static final String BSE_CTRT_MAIN_SYS_CTRT_NUM = "SYS_CTRT_NUM";
    // 合同名称;与ERP(HTMC)对应，校验唯一
    public static final String BSE_CTRT_MAIN_CTRT_NAME = "CTRT_NAME";
    public static final String BSE_CTRT_MAIN_CTRT_NAME_LABEL = "合同名称";
    // 合同编号;与ERP(HTBH)对应，校验唯一
    public static final String BSE_CTRT_MAIN_CTRT_PPR_NUM = "CTRT_PPR_NUM";
    public static final String BSE_CTRT_MAIN_CTRT_PPR_NUM_LABEL = "合同编号";
    // 甲方公司编号
    public static final String BSE_CTRT_MAIN_PRCH_CPN_NUM = "PRCH_CPN_NUM";
    public static final String BSE_CTRT_MAIN_PRCH_CPN_NUM_LABEL = "甲方公司编号";
    // 甲方公司名称
    public static final String BSE_CTRT_MAIN_PRCH_CPN_NAME_LABEL = "甲方公司名称";
    // 甲方地址
    public static final String BSE_CTRT_MAIN_PRCH_ADR_LABEL = "甲方地址";
    // 甲方法定代表人
    public static final String BSE_CTRT_MAIN_PRCH_LDR_LABEL = "甲方法定代表人";
    // 乙方公司编号
    public static final String BSE_CTRT_MAIN_SALE_CPN_NUM = "SALE_CPN_NUM_LABEL";
    public static final String BSE_CTRT_MAIN_SALE_CPN_NUM_LABEL = "乙方公司编号";
    // 乙方公司名称
    public static final String BSE_CTRT_MAIN_SALE_CPN_NAME_LABEL = "乙方公司名称";
    // 乙方地址
    public static final String BSE_CTRT_MAIN_SALE_ADR_LABEL = "乙方地址";
    // 乙方法定代表人
    public static final String BSE_CTRT_MAIN_SALE_PRCH_LDR_LABEL = "乙方法定代表人";
    // 类别
    public static final String BSE_CTRT_MAIN_CTGR_LABEL = "类别";
    // 收支性质
    public static final String BSE_CTRT_MAIN_DRCT_LABEL = "收支性质";
    // 签署日期
    public static final String BSE_CTRT_MAIN_SGN_DT_LABEL = "签署日期";
    // 开始日期
    public static final String BSE_CTRT_MAIN_STRT_DT_LABEL = "开始日期";
    // 结束日期
    public static final String BSE_CTRT_MAIN_END_DT_LABEL = "结束日期";
    // 签署地
    public static final String BSE_CTRT_MAIN_SGN_PLCE_LABEL = "签署地";
    // 币种
    public static final String BSE_CTRT_MAIN_CUR_LABEL = "币种";
    // 本币金额
    public static final String BSE_CTRT_MAIN_BSC_AMT_LABEL = "本币金额";
    // 原币金额
    public static final String BSE_CTRT_MAIN_COO_AMT_LABEL = "原币金额";
    // 是否有履约保证金
    public static final String BSE_CTRT_MAIN_HS_DPST_LABEL = "是否有履约保证金";
    // 原币履约保证金
    public static final String BSE_CTRT_MAIN_COO_AMT_DPST_LABEL = "原币履约保证金";
    // 本币履约保证金
    public static final String BSE_CTRT_MAIN_BSC_AMT_DPST_LABEL = "本币履约保证金";
    // 是否有预付款
    public static final String BSE_CTRT_MAIN_HS_PPYM_LABEL = "是否有预付款";
    // 预付款比例
    public static final String BSE_CTRT_MAIN_PPYM_RTIO_LABEL = "预付款比例";
    // 预付款金额
    public static final String BSE_CTRT_MAIN_PPYM_AMT_LABEL = "预付款金额";
    // 是否有质保金
    public static final String BSE_CTRT_MAIN_HS_QLT_AMT_LABEL = "是否有质保金";
    // 质保金比例
    public static final String BSE_CTRT_MAIN_QLT_RTIO_LABEL = "质保金比例";
    // 质保金金额
    public static final String BSE_CTRT_MAIN_QLT_AMT_LABEL = "质保金金额";
    // 是否先款后货
    public static final String BSE_CTRT_MAIN_HS_PYBL_LABEL = "是否先款后贷";
    // 是否框架合同
    public static final String BSE_CTRT_MAIN_IS_FMWK_LABEL = "是否框架合同";
    // 境内/境外
    public static final String BSE_CTRT_MAIN_IS_DOM_LABEL = "境内/境外";
    // 施工类型编号
    public static final String BSE_CTRT_MAIN_CON_TP_NUM_LABEL = "施工类型编号";
    // 施工类型名称
    public static final String BSE_CTRT_MAIN_CON_TP_NAME_LABEL = "施工类型名称";
    // 代理方
    public static final String BSE_CTRT_MAIN_AGT_LABEL = "代理方";
    // 是否虚拟合同
    public static final String BSE_CTRT_MAIN_CTRT_VRTL_LABEL = "是否虚拟合同";

    /* 合同明细表 */
    // 合同主信息主键
    public static final String BSE_CTRT_DTL_CTRT_MAIN_ID = "CTRT_MAIN_ID";
    // 物料名称
    public static final String BSE_CTRT_DTL_MTRL_NAME_LABEL = "物料名称";
    // 数量
    public static final String BSE_CTRT_DTL_QTY_LABEL = "数量";
    // 计量单位
    public static final String BSE_CTRT_DTL_UNT_LABEL = "计量单位";

    /* 交货计划条款表 */
    // 合同明细主键
    public static final String BSE_CTRT_PLN_CTRT_DTL_ID = "CTRT_DTL_ID";

    /* 价款结算条款表 */
    // 合同主键
    public static final String BSE_CTRT_FMU_CTRT_ID = "CTRT_ID";

    /* 基础系数配置表 */
    // 条款主键
    public static final String BSE_CTRT_COEF_FMU_ID = "FMU_ID";

    /* 品位等级价配置表 */
    // 条款主键
    public static final String BSE_CTRT_GRD_FMU_ID = "FMU_ID";

    /* 调整价配置表 */
    // 条款主键
    public static final String BSE_CTRT_DDCT_FMU_ID = "FMU_ID";

    /* 市场价配置表 */
    // 条款主键
    public static final String BSE_CTRT_PRC_FMU_ID = "FMU_ID";

    /* 参数降级规则表 */
    // 合同主键
    public static final String BSE_CTRT_DMOT_CTRT_ID = "CTRT_ID";

    /* 品位不计价配置表 */
    // 合同主键
    public static final String BSE_CTRT_NT_CTRT_ID = "CTRT_ID";

    /* 实例字段值表 */
    // 关联实例主键
    public static final String BSE_TMPL_INSC_DAT_INSC_ID = "INSC_ID";

    /* 实例条款值表 */
    // 关联实例主键
    public static final String BSE_TMPL_INSC_ITM_INSC_ID = "INSC_ID";

    /* 业务关联表 */
    // 上游主键
    public static final String BSE_SYS_REL_UP_ID = "UP_ID";
    // 下游主键
    public static final String BSE_SYS_REL_DOWN_ID = "DOWN_ID";
}
