TMS CRVAT INV REQ BAT INF
来自ling
-- Create table
create table TMS_CRVAT_INV_REQ_BAT_INF
(
interface_trx_id CHAR(36) not null,
interface_trx_date DATE,
interface_trx_flag VARCHAR2(10) default 0 not null,
interface_trx_msg VARCHAR2(2000),
request_id CHAR(36),
crvat_invoice_req_number VARCHAR2(100),
org_id CHAR(36),
source_org_id VARCHAR2(100),
source_org_code VARCHAR2(100),
source_invoice_req_by DATE,
invoice_req_date DATE,
req_dept_no VARCHAR2(100),
source_req_dept_no VARCHAR2(100),
invoice_req_type VARCHAR2(100),
legal_entity_id CHAR(36),
source_legal_entity_id VARCHAR2(100),
source_legal_entity_code VARCHAR2(100),
prt_legal_entity_id CHAR(36),
source_prt_legal_entity_id VARCHAR2(100),
source_prt_legal_entity_code VARCHAR2(100),
equipment_id CHAR(36),
source_equipment_id VARCHAR2(100),
source_equipment_code VARCHAR2(100),
invoicing_type VARCHAR2(100),
req_invoice_range VARCHAR2(100),
is_receipts VARCHAR2(10) default 0 not null,
business_categories VARCHAR2(100),
delivery_type VARCHAR2(100),
customer_id CHAR(36),
source_customer_id VARCHAR2(100),
source_customer_number VARCHAR2(100),
source_customer_acc_num VARCHAR2(100),
project_id CHAR(36),
source_project_number VARCHAR2(100),
contract_id CHAR(36),
source_contract_number VARCHAR2(100),
inventory_item_qty NUMBER,
trx_affirm_setting_id CHAR(36),
tax_trx_type_id CHAR(36),
source_tax_type_code VARCHAR2(100),
source_tax_type_name VARCHAR2(100),
invoice_amount NUMBER,
tax_rate NUMBER,
source_approval_by CHAR(36),
approval_date DATE,
approval_status VARCHAR2(100),
approval_desc VARCHAR2(500),
source_wf_task_id CHAR(36),
source_wf_task_number VARCHAR2(100),
is_tax VARCHAR2(10) default 0 not null,
source_code VARCHAR2(100),
source_batch_number VARCHAR2(100),
source_crvat_inv_req_bat_id VARCHAR2(100),
start_date DATE,
end_date DATE,
status VARCHAR2(30),
attribute_category VARCHAR2(100),
attribute1 VARCHAR2(240),
attribute2 VARCHAR2(240),
attribute3 VARCHAR2(240),
attribute4 VARCHAR2(240),
attribute5 VARCHAR2(240),
attribute6 VARCHAR2(240),
attribute7 VARCHAR2(240),
attribute8 VARCHAR2(240),
attribute9 VARCHAR2(240),
attribute10 VARCHAR2(240),
archive_base_date DATE not null,
biz_org_code VARCHAR2(100) not null,
created_by CHAR(36) not null,
creation_date DATE not null,
last_updated_by CHAR(36) not null,
last_update_date DATE not null,
record_version NUMBER not null,
deleted_flag VARCHAR2(10) default 0 not null,
deleted_by CHAR(36),
deletion_date DATE,
data_owner_code VARCHAR2(100),
company_id CHAR(36),
operation_org_code VARCHAR2(100)
);
-- Add comments to the table
comment on table TMS_CRVAT_INV_REQ_BAT_INF
is '特殊批量开票申请接口表';
-- Add comments to the columns
comment on column TMS_CRVAT_INV_REQ_BAT_INF.interface_trx_id
is '接口处理ID';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.interface_trx_date
is '接口处理日期';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.interface_trx_flag
is '接口处理标记';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.interface_trx_msg
is '接口处理信息';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.request_id
is '接口处理处理请求ID(自动任务ID)';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.crvat_invoice_req_number
is '特殊批量开票申请单号';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.org_id
is '组织ID';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_org_id
is '来源组织ID';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_org_code
is '来源组织CODE';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_invoice_req_by
is '来原申请人';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.invoice_req_date
is '申请日期';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.req_dept_no
is '申请部门';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_req_dept_no
is '来源申请部门';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.invoice_req_type
is '申请开票类型(柜台/特殊/自动匹配/特殊批量)_预留';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.legal_entity_id
is '销方纳税人实体ID';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_legal_entity_id
is '来源销方纳税人ID';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_legal_entity_code
is '来源销方纳税人代码';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.prt_legal_entity_id
is '打印点法人实体ID';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_prt_legal_entity_id
is '来源打印点法人实体ID';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_prt_legal_entity_code
is '来源打印点法人实体代码';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.equipment_id
is '终端设备ID';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_equipment_id
is '来源终端设备ID';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_equipment_code
is '来源终端设备代码';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.invoicing_type
is '开票方式_枚举值(明细/汇总)';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.req_invoice_range
is '发票打印受理层级范围_枚举值';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.is_receipts
is '是否已收款';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.business_categories
is '业务大类_枚举值';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.delivery_type
is '寄送类型_枚举值(内部/外包)';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.customer_id
is '购方名称ID';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_customer_id
is '来源购方ID';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_customer_number
is '来源购方代码';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_customer_acc_num
is '来源购方资金账号代码';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.project_id
is '项目ID';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_project_number
is '来源项目编码';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.contract_id
is '合同ID(冗余)';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_contract_number
is '来源合同编码';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.inventory_item_qty
is '数量';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.trx_affirm_setting_id
is '涉税交易认定设置规则ID';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.tax_trx_type_id
is '涉税交易类型ID';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_tax_type_code
is '涉税交易类型代码';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_tax_type_name
is '涉税交易类型名称';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.invoice_amount
is '本次开票总金额';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.tax_rate
is '税率';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_approval_by
is '最后审批人';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.approval_date
is '最后审批日期';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.approval_status
is '审批状态';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.approval_desc
is '审批流状态描述';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_wf_task_id
is '来源工作流ID';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_wf_task_number
is '来源工作编码';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.is_tax
is '是否含税';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_code
is '来源系统';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_batch_number
is '来源特殊批量开票申请批号';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.source_crvat_inv_req_bat_id
is '来源特殊批量开票申请ID';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.start_date
is '有效日期';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.end_date
is '失效日期';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.status
is '状态';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.attribute_category
is '扩展字段结构类型';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.attribute1
is '扩展字段1';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.attribute2
is '扩展字段2';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.attribute3
is '扩展字段3';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.attribute4
is '扩展字段4';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.attribute5
is '扩展字段5';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.attribute6
is '扩展字段6';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.attribute7
is '扩展字段7';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.attribute8
is '扩展字段8';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.attribute9
is '扩展字段9';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.attribute10
is '扩展字段10';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.archive_base_date
is '归档基准日期';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.biz_org_code
is '业务组织编号';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.created_by
is '创建人';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.creation_date
is '创建时间';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.last_updated_by
is '最后修改人';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.last_update_date
is '最后修改时间';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.record_version
is '记录版本号';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.deleted_flag
is '删除标记';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.deleted_by
is '删除人';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.deletion_date
is '删除时间';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.data_owner_code
is '数据拥有者代码(机构/组织等)';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.company_id
is '所属公司ID';
comment on column TMS_CRVAT_INV_REQ_BAT_INF.operation_org_code
is '运营组织CODE';
-- Create/Recreate primary, unique and foreign key constraints
alter table TMS_CRVAT_INV_REQ_BAT_INF
add constraint PK_TMS_CRVAT_INV_REQ_BAT_INF primary key (INTERFACE_TRX_ID);
