2025-03-27 15:05:14 +08:00

708 lines
24 KiB
C#

using System.Runtime.Serialization;
namespace SuperMap.RealEstate.Finance.Running.Interface
{
#region T_EXPENDBILL IEXPENDBILL
/// <summary>
/// T_EXPENDBILL 接口
/// </summary>
public interface IEXPENDBILL
{
/// <summary>
/// 内码
/// </summary>
System.Int32? EXPENDBILL_ID { get; set; }
/// <summary>
/// 内码 的加密字符串
/// </summary>
string EXPENDBILL_ID_Encrypt { get; set; }
/// <summary>
/// 项目内码
/// </summary>
System.Int32? FINANCEPROINST_ID { get; set; }
/// <summary>
/// 报销编码
/// </summary>
System.String EXPENDBILL_CODE { get; set; }
/// <summary>
/// 财务类型
/// </summary>
System.Int16? EXPENDBILL_TYPE { get; set; }
/// <summary>
/// 单据状态
/// </summary>
System.Int16? EXPENDBILL_STATE { get; set; }
/// <summary>
/// 作废人员
/// </summary>
System.String OBSOLETE_PERSON { get; set; }
/// <summary>
/// 作废时间
/// </summary>
System.DateTime? OBSOLETE_DATE { get; set; }
/// <summary>
/// 部门名称
/// </summary>
System.String DEPARTMENT_NAME { get; set; }
/// <summary>
/// 报销日期
/// </summary>
System.DateTime? EXPENDBILL_DATE { get; set; }
/// <summary>
/// 出差人
/// </summary>
System.String BUSINESS_PERSON { get; set; }
/// <summary>
/// 出差事由
/// </summary>
System.String BUSINESS_REASON { get; set; }
/// <summary>
/// 业务名称
/// </summary>
System.String EXPENDBILL_NAME { get; set; }
/// <summary>
/// 付款金额(小写)
/// </summary>
System.Double? PAYMENT_LOWER { get; set; }
/// <summary>
/// 付款金额(大写)
/// </summary>
System.String PAYMENT_CAP { get; set; }
/// <summary>
/// 合计单据数
/// </summary>
System.Int32? PAYMENT_COUNT { get; set; }
/// <summary>
/// 合同编码
/// </summary>
System.String CONTRACT_CODE { get; set; }
/// <summary>
/// 资金用途
/// </summary>
System.String FUNDS_USE { get; set; }
/// <summary>
/// 合同总金额
/// </summary>
System.Double? CONTRACT_TOTALAMOUNT { get; set; }
/// <summary>
/// 支付依据
/// </summary>
System.String PAY_BASIS { get; set; }
/// <summary>
/// 前期累计已支付金额
/// </summary>
System.Double? PERPAID_TOTALAMOUNT { get; set; }
/// <summary>
/// 是否为预算内项目
/// </summary>
System.Int16? INBUDGET { get; set; }
/// <summary>
/// 年初预算金额
/// </summary>
System.Double? BUDGET_AMOUNT { get; set; }
/// <summary>
/// 年初预算项目名称
/// </summary>
System.String BUDGET_NAME { get; set; }
/// <summary>
/// 是否使用电子发票
/// </summary>
System.Int16? ELECTRONIC_INVOICE { get; set; }
/// <summary>
/// 电子发票号码
/// </summary>
System.String BILLCODE { get; set; }
/// <summary>
/// 收款单位
/// </summary>
System.String PAYEE { get; set; }
/// <summary>
/// 收款账户
/// </summary>
System.String PAYEE_ACCOUNT { get; set; }
/// <summary>
/// 开户银行
/// </summary>
System.String BANK_NAME { get; set; }
/// <summary>
/// 申请地点
/// </summary>
System.String APPLICAION_SITE { get; set; }
/// <summary>
/// 经费使用说明
/// </summary>
System.String EXPENDITURE_EXPLAIN { get; set; }
/// <summary>
/// 资产原值
/// </summary>
System.Double? PROPERTY_PRICE { get; set; }
/// <summary>
/// 累计折旧
/// </summary>
System.Double? DEPRECIATION_PRICE { get; set; }
/// <summary>
/// 固定资产净值
/// </summary>
System.Double? FIXEDASSETS_PRICE { get; set; }
/// <summary>
/// 购置日期
/// </summary>
System.DateTime? BUY_DATE { get; set; }
/// <summary>
/// 购置数量
/// </summary>
System.Int32? BUY_AMOUNT { get; set; }
/// <summary>
/// 操作人内码
/// </summary>
System.Int32? STAFF_ID { get; set; }
/// <summary>
/// 操作人名称
/// </summary>
System.String STAFF_NAME { get; set; }
/// <summary>
/// 操作时间
/// </summary>
System.DateTime? OPERATE_DATE { get; set; }
/// <summary>
/// 打印次数
/// </summary>
System.Int32? PRINT_COUNT { get; set; }
/// <summary>
/// 备注
/// </summary>
System.String EXPENDBILL_DESC { get; set; }
/// <summary>
/// 报销详情
/// </summary>
System.String EXPENDBILL_DETILS { get; set; }
}
#endregion
#region T_EXPENDBILL IModifyEXPENDBILL
/// <summary>
/// T_EXPENDBILL 接口
/// </summary>
public interface IModifyEXPENDBILL
{
/// <summary>
/// 内码 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_EXPENDBILL_ID { get; set; }
/// <summary>
/// 项目内码 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_FINANCEPROINST_ID { get; set; }
/// <summary>
/// 报销编码 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_EXPENDBILL_CODE { get; set; }
/// <summary>
/// 财务类型 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_EXPENDBILL_TYPE { get; set; }
/// <summary>
/// 单据状态 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_EXPENDBILL_STATE { get; set; }
/// <summary>
/// 作废人员 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_OBSOLETE_PERSON { get; set; }
/// <summary>
/// 作废时间 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_OBSOLETE_DATE { get; set; }
/// <summary>
/// 部门名称 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_DEPARTMENT_NAME { get; set; }
/// <summary>
/// 报销日期 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_EXPENDBILL_DATE { get; set; }
/// <summary>
/// 出差人 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_BUSINESS_PERSON { get; set; }
/// <summary>
/// 出差事由 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_BUSINESS_REASON { get; set; }
/// <summary>
/// 业务名称 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_EXPENDBILL_NAME { get; set; }
/// <summary>
/// 付款金额(小写) 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_PAYMENT_LOWER { get; set; }
/// <summary>
/// 付款金额(大写) 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_PAYMENT_CAP { get; set; }
/// <summary>
/// 合计单据数 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_PAYMENT_COUNT { get; set; }
/// <summary>
/// 合同编码 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_CONTRACT_CODE { get; set; }
/// <summary>
/// 资金用途 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_FUNDS_USE { get; set; }
/// <summary>
/// 合同总金额 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_CONTRACT_TOTALAMOUNT { get; set; }
/// <summary>
/// 支付依据 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_PAY_BASIS { get; set; }
/// <summary>
/// 前期累计已支付金额 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_PERPAID_TOTALAMOUNT { get; set; }
/// <summary>
/// 是否为预算内项目 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_INBUDGET { get; set; }
/// <summary>
/// 年初预算金额 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_BUDGET_AMOUNT { get; set; }
/// <summary>
/// 年初预算项目名称 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_BUDGET_NAME { get; set; }
/// <summary>
/// 是否使用电子发票 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_ELECTRONIC_INVOICE { get; set; }
/// <summary>
/// 电子发票号码 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_BILLCODE { get; set; }
/// <summary>
/// 收款单位 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_PAYEE { get; set; }
/// <summary>
/// 收款账户 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_PAYEE_ACCOUNT { get; set; }
/// <summary>
/// 开户银行 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_BANK_NAME { get; set; }
/// <summary>
/// 申请地点 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_APPLICAION_SITE { get; set; }
/// <summary>
/// 经费使用说明 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_EXPENDITURE_EXPLAIN { get; set; }
/// <summary>
/// 资产原值 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_PROPERTY_PRICE { get; set; }
/// <summary>
/// 累计折旧 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_DEPRECIATION_PRICE { get; set; }
/// <summary>
/// 固定资产净值 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_FIXEDASSETS_PRICE { get; set; }
/// <summary>
/// 购置日期 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_BUY_DATE { get; set; }
/// <summary>
/// 购置数量 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_BUY_AMOUNT { get; set; }
/// <summary>
/// 操作人内码 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_STAFF_ID { get; set; }
/// <summary>
/// 操作人名称 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_STAFF_NAME { get; set; }
/// <summary>
/// 操作时间 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_OPERATE_DATE { get; set; }
/// <summary>
/// 打印次数 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_PRINT_COUNT { get; set; }
/// <summary>
/// 备注 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_EXPENDBILL_DESC { get; set; }
/// <summary>
/// 报销详情 是否被修改,不建议直接对其赋值操作
/// </summary>
bool Modify_EXPENDBILL_DETILS { get; set; }
}
#endregion
#region T_EXPENDBILL
/// <summary>
/// T_EXPENDBILL_财务报销 的字段类
/// </summary>
public class TableSchema_EXPENDBILL
{
/// <summary>
/// 序列名 (用于Oracle主键)
/// </summary>
public const string SequenceName = "seq_expendbill";
/// <summary>
/// 表名
/// </summary>
public const string TableName = "T_EXPENDBILL";
/// <summary>
/// 表注释
/// </summary>
public const string Comment_TableName = "财务报销";
/// <summary>
/// 主键
/// </summary>
public const string KeyFieldName = "EXPENDBILL_ID";
/// <summary>
/// 内码
/// </summary>
public const string EXPENDBILL_ID = "EXPENDBILL_ID";
/// <summary>
/// 项目内码
/// </summary>
public const string FINANCEPROINST_ID = "FINANCEPROINST_ID";
/// <summary>
/// 报销编码
/// </summary>
public const string EXPENDBILL_CODE = "EXPENDBILL_CODE";
/// <summary>
/// 财务类型
/// </summary>
public const string EXPENDBILL_TYPE = "EXPENDBILL_TYPE";
/// <summary>
/// 单据状态
/// </summary>
public const string EXPENDBILL_STATE = "EXPENDBILL_STATE";
/// <summary>
/// 作废人员
/// </summary>
public const string OBSOLETE_PERSON = "OBSOLETE_PERSON";
/// <summary>
/// 作废时间
/// </summary>
public const string OBSOLETE_DATE = "OBSOLETE_DATE";
/// <summary>
/// 部门名称
/// </summary>
public const string DEPARTMENT_NAME = "DEPARTMENT_NAME";
/// <summary>
/// 报销日期
/// </summary>
public const string EXPENDBILL_DATE = "EXPENDBILL_DATE";
/// <summary>
/// 出差人
/// </summary>
public const string BUSINESS_PERSON = "BUSINESS_PERSON";
/// <summary>
/// 出差事由
/// </summary>
public const string BUSINESS_REASON = "BUSINESS_REASON";
/// <summary>
/// 业务名称
/// </summary>
public const string EXPENDBILL_NAME = "EXPENDBILL_NAME";
/// <summary>
/// 付款金额(小写)
/// </summary>
public const string PAYMENT_LOWER = "PAYMENT_LOWER";
/// <summary>
/// 付款金额(大写)
/// </summary>
public const string PAYMENT_CAP = "PAYMENT_CAP";
/// <summary>
/// 合计单据数
/// </summary>
public const string PAYMENT_COUNT = "PAYMENT_COUNT";
/// <summary>
/// 合同编码
/// </summary>
public const string CONTRACT_CODE = "CONTRACT_CODE";
/// <summary>
/// 资金用途
/// </summary>
public const string FUNDS_USE = "FUNDS_USE";
/// <summary>
/// 合同总金额
/// </summary>
public const string CONTRACT_TOTALAMOUNT = "CONTRACT_TOTALAMOUNT";
/// <summary>
/// 支付依据
/// </summary>
public const string PAY_BASIS = "PAY_BASIS";
/// <summary>
/// 前期累计已支付金额
/// </summary>
public const string PERPAID_TOTALAMOUNT = "PERPAID_TOTALAMOUNT";
/// <summary>
/// 是否为预算内项目
/// </summary>
public const string INBUDGET = "INBUDGET";
/// <summary>
/// 年初预算金额
/// </summary>
public const string BUDGET_AMOUNT = "BUDGET_AMOUNT";
/// <summary>
/// 年初预算项目名称
/// </summary>
public const string BUDGET_NAME = "BUDGET_NAME";
/// <summary>
/// 是否使用电子发票
/// </summary>
public const string ELECTRONIC_INVOICE = "ELECTRONIC_INVOICE";
/// <summary>
/// 电子发票号码
/// </summary>
public const string BILLCODE = "BILLCODE";
/// <summary>
/// 收款单位
/// </summary>
public const string PAYEE = "PAYEE";
/// <summary>
/// 收款账户
/// </summary>
public const string PAYEE_ACCOUNT = "PAYEE_ACCOUNT";
/// <summary>
/// 开户银行
/// </summary>
public const string BANK_NAME = "BANK_NAME";
/// <summary>
/// 申请地点
/// </summary>
public const string APPLICAION_SITE = "APPLICAION_SITE";
/// <summary>
/// 经费使用说明
/// </summary>
public const string EXPENDITURE_EXPLAIN = "EXPENDITURE_EXPLAIN";
/// <summary>
/// 资产原值
/// </summary>
public const string PROPERTY_PRICE = "PROPERTY_PRICE";
/// <summary>
/// 累计折旧
/// </summary>
public const string DEPRECIATION_PRICE = "DEPRECIATION_PRICE";
/// <summary>
/// 固定资产净值
/// </summary>
public const string FIXEDASSETS_PRICE = "FIXEDASSETS_PRICE";
/// <summary>
/// 购置日期
/// </summary>
public const string BUY_DATE = "BUY_DATE";
/// <summary>
/// 购置数量
/// </summary>
public const string BUY_AMOUNT = "BUY_AMOUNT";
/// <summary>
/// 操作人内码
/// </summary>
public const string STAFF_ID = "STAFF_ID";
/// <summary>
/// 操作人名称
/// </summary>
public const string STAFF_NAME = "STAFF_NAME";
/// <summary>
/// 操作时间
/// </summary>
public const string OPERATE_DATE = "OPERATE_DATE";
/// <summary>
/// 打印次数
/// </summary>
public const string PRINT_COUNT = "PRINT_COUNT";
/// <summary>
/// 备注
/// </summary>
public const string EXPENDBILL_DESC = "EXPENDBILL_DESC";
/// <summary>
/// 报销详情
/// </summary>
public const string EXPENDBILL_DETILS = "EXPENDBILL_DETILS";
/// <summary>
/// 内码
/// </summary>
public const string Comment_EXPENDBILL_ID = "内码";
/// <summary>
/// 项目内码
/// </summary>
public const string Comment_FINANCEPROINST_ID = "项目内码";
/// <summary>
/// 报销编码
/// </summary>
public const string Comment_EXPENDBILL_CODE = "报销编码";
/// <summary>
/// 财务类型
/// </summary>
public const string Comment_EXPENDBILL_TYPE = "财务类型";
/// <summary>
/// 单据状态
/// </summary>
public const string Comment_EXPENDBILL_STATE = "单据状态";
/// <summary>
/// 作废人员
/// </summary>
public const string Comment_OBSOLETE_PERSON = "作废人员";
/// <summary>
/// 作废时间
/// </summary>
public const string Comment_OBSOLETE_DATE = "作废时间";
/// <summary>
/// 部门名称
/// </summary>
public const string Comment_DEPARTMENT_NAME = "部门名称";
/// <summary>
/// 报销日期
/// </summary>
public const string Comment_EXPENDBILL_DATE = "报销日期";
/// <summary>
/// 出差人
/// </summary>
public const string Comment_BUSINESS_PERSON = "出差人";
/// <summary>
/// 出差事由
/// </summary>
public const string Comment_BUSINESS_REASON = "出差事由";
/// <summary>
/// 业务名称
/// </summary>
public const string Comment_EXPENDBILL_NAME = "业务名称";
/// <summary>
/// 付款金额(小写)
/// </summary>
public const string Comment_PAYMENT_LOWER = "付款金额(小写)";
/// <summary>
/// 付款金额(大写)
/// </summary>
public const string Comment_PAYMENT_CAP = "付款金额(大写)";
/// <summary>
/// 合计单据数
/// </summary>
public const string Comment_PAYMENT_COUNT = "合计单据数";
/// <summary>
/// 合同编码
/// </summary>
public const string Comment_CONTRACT_CODE = "合同编码";
/// <summary>
/// 资金用途
/// </summary>
public const string Comment_FUNDS_USE = "资金用途";
/// <summary>
/// 合同总金额
/// </summary>
public const string Comment_CONTRACT_TOTALAMOUNT = "合同总金额";
/// <summary>
/// 支付依据
/// </summary>
public const string Comment_PAY_BASIS = "支付依据";
/// <summary>
/// 前期累计已支付金额
/// </summary>
public const string Comment_PERPAID_TOTALAMOUNT = "前期累计已支付金额";
/// <summary>
/// 是否为预算内项目
/// </summary>
public const string Comment_INBUDGET = "是否为预算内项目";
/// <summary>
/// 年初预算金额
/// </summary>
public const string Comment_BUDGET_AMOUNT = "年初预算金额";
/// <summary>
/// 年初预算项目名称
/// </summary>
public const string Comment_BUDGET_NAME = "年初预算项目名称";
/// <summary>
/// 是否使用电子发票
/// </summary>
public const string Comment_ELECTRONIC_INVOICE = "是否使用电子发票";
/// <summary>
/// 电子发票号码
/// </summary>
public const string Comment_BILLCODE = "电子发票号码";
/// <summary>
/// 收款单位
/// </summary>
public const string Comment_PAYEE = "收款单位";
/// <summary>
/// 收款账户
/// </summary>
public const string Comment_PAYEE_ACCOUNT = "收款账户";
/// <summary>
/// 开户银行
/// </summary>
public const string Comment_BANK_NAME = "开户银行";
/// <summary>
/// 申请地点
/// </summary>
public const string Comment_APPLICAION_SITE = "申请地点";
/// <summary>
/// 经费使用说明
/// </summary>
public const string Comment_EXPENDITURE_EXPLAIN = "经费使用说明";
/// <summary>
/// 资产原值
/// </summary>
public const string Comment_PROPERTY_PRICE = "资产原值";
/// <summary>
/// 累计折旧
/// </summary>
public const string Comment_DEPRECIATION_PRICE = "累计折旧";
/// <summary>
/// 固定资产净值
/// </summary>
public const string Comment_FIXEDASSETS_PRICE = "固定资产净值";
/// <summary>
/// 购置日期
/// </summary>
public const string Comment_BUY_DATE = "购置日期";
/// <summary>
/// 购置数量
/// </summary>
public const string Comment_BUY_AMOUNT = "购置数量";
/// <summary>
/// 操作人内码
/// </summary>
public const string Comment_STAFF_ID = "操作人内码";
/// <summary>
/// 操作人名称
/// </summary>
public const string Comment_STAFF_NAME = "操作人名称";
/// <summary>
/// 操作时间
/// </summary>
public const string Comment_OPERATE_DATE = "操作时间";
/// <summary>
/// 打印次数
/// </summary>
public const string Comment_PRINT_COUNT = "打印次数";
/// <summary>
/// 备注
/// </summary>
public const string Comment_EXPENDBILL_DESC = "备注";
/// <summary>
/// 报销详情
/// </summary>
public const string Comment_EXPENDBILL_DETILS = "报销详情";
}
#endregion
}