TMS CRVAT INV REQ H INF
-- Create table create table TMS_CRVAT_INV_REQ_H_INF (
interface_trx_header_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_h_id CHAR(36), crvat_invoice_req_number VARCHAR2(100), org_id CHAR(36), source_org_id VARCHAR2(100), source_org_code VARCHAR2(100), submit_date DATE, invoice_req_date DATE, invoice_req_type VARCHAR2(100), req_dept_no VARCHAR2(100), source_req_dept_no VARCHAR2(100), source_invoice_req_by VARCHAR2(100), invoice_category VARCHAR2(100), source_code VARCHAR2(100), customer_id CHAR(36), source_customer_id VARCHAR2(100), source_customer_number VARCHAR2(100), source_customer_acc_num VARCHAR2(100), legal_entity_id CHAR(36), source_legal_entity_id VARCHAR2(100), source_legal_entity_code VARCHAR2(100), invoicing_type VARCHAR2(100), req_invoice_range VARCHAR2(100), mapping_status VARCHAR2(100), is_all_mapping VARCHAR2(10) default 0 not null, is_receipts VARCHAR2(10) default 0 not null, business_categories VARCHAR2(100), delivery_type VARCHAR2(100), wf_task_id CHAR(36), source_approval_by CHAR(36), approval_date DATE, approval_desc VARCHAR2(500), approval_status VARCHAR2(100), project_id CHAR(36), source_project_number VARCHAR2(100), source_contract_number VARCHAR2(100), qty_of_pre_invoice NUMBER, start_trx_date DATE, end_trx_date DATE, is_tax VARCHAR2(10) default 0 not null, 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_H_INF
is '销项税开票申请单表接口头表';
-- Add comments to the columns comment on column TMS_CRVAT_INV_REQ_H_INF.interface_trx_header_id
is '接口处理ID';
comment on column TMS_CRVAT_INV_REQ_H_INF.interface_trx_date
is '接口处理日期';
comment on column TMS_CRVAT_INV_REQ_H_INF.interface_trx_flag
is '接口处理标记';
comment on column TMS_CRVAT_INV_REQ_H_INF.interface_trx_msg
is '接口处理信息';
comment on column TMS_CRVAT_INV_REQ_H_INF.request_id
is '接口处理处理请求ID(自动任务ID)';
comment on column TMS_CRVAT_INV_REQ_H_INF.crvat_invoice_req_h_id
is '开票申请单-头表ID';
comment on column TMS_CRVAT_INV_REQ_H_INF.crvat_invoice_req_number
is '开票申请单号';
comment on column TMS_CRVAT_INV_REQ_H_INF.org_id
is '组织ID';
comment on column TMS_CRVAT_INV_REQ_H_INF.source_org_id
is '来源组织ID';
comment on column TMS_CRVAT_INV_REQ_H_INF.source_org_code
is '来源组织CODE';
comment on column TMS_CRVAT_INV_REQ_H_INF.submit_date
is '提交日期';
comment on column TMS_CRVAT_INV_REQ_H_INF.invoice_req_date
is '申请日期';
comment on column TMS_CRVAT_INV_REQ_H_INF.invoice_req_type
is '申请开票类型(柜台/特殊/自动)';
comment on column TMS_CRVAT_INV_REQ_H_INF.req_dept_no
is '申请开票部门';
comment on column TMS_CRVAT_INV_REQ_H_INF.source_req_dept_no
is '来源申请部门';
comment on column TMS_CRVAT_INV_REQ_H_INF.source_invoice_req_by
is '来源申请人';
comment on column TMS_CRVAT_INV_REQ_H_INF.invoice_category
is '发票类型_枚举值(专票/普票/不可开票/混合)';
comment on column TMS_CRVAT_INV_REQ_H_INF.source_code
is '来源(手工/自动匹配)';
comment on column TMS_CRVAT_INV_REQ_H_INF.customer_id
is '购方名称ID';
comment on column TMS_CRVAT_INV_REQ_H_INF.source_customer_id
is '来源购方ID';
comment on column TMS_CRVAT_INV_REQ_H_INF.source_customer_number
is '来源购方代码';
comment on column TMS_CRVAT_INV_REQ_H_INF.source_customer_acc_num
is '来源购方资金账号代码';
comment on column TMS_CRVAT_INV_REQ_H_INF.legal_entity_id
is '销方纳税人实体ID';
comment on column TMS_CRVAT_INV_REQ_H_INF.source_legal_entity_id
is '来源销方纳税人ID';
comment on column TMS_CRVAT_INV_REQ_H_INF.source_legal_entity_code
is '来源销方纳税人代码';
comment on column TMS_CRVAT_INV_REQ_H_INF.invoicing_type
is '开票方式_枚举值(明细/汇总)';
comment on column TMS_CRVAT_INV_REQ_H_INF.req_invoice_range
is '发票打印受理层级范围_枚举值';
comment on column TMS_CRVAT_INV_REQ_H_INF.mapping_status
is '匹配状态';
comment on column TMS_CRVAT_INV_REQ_H_INF.is_all_mapping
is '是否已全部匹配完成';
comment on column TMS_CRVAT_INV_REQ_H_INF.is_receipts
is '是否已收款';
comment on column TMS_CRVAT_INV_REQ_H_INF.business_categories
is '业务大类_枚举值';
comment on column TMS_CRVAT_INV_REQ_H_INF.delivery_type
is '寄送类型_枚举值(内部/外包)';
comment on column TMS_CRVAT_INV_REQ_H_INF.wf_task_id
is '工作流ID';
comment on column TMS_CRVAT_INV_REQ_H_INF.source_approval_by
is '最后审批人';
comment on column TMS_CRVAT_INV_REQ_H_INF.approval_date
is '最后审批日期';
comment on column TMS_CRVAT_INV_REQ_H_INF.approval_desc
is '审批流状态描述';
comment on column TMS_CRVAT_INV_REQ_H_INF.approval_status
is '审批状态';
comment on column TMS_CRVAT_INV_REQ_H_INF.project_id
is '项目ID';
comment on column TMS_CRVAT_INV_REQ_H_INF.source_project_number
is '来源项目编码';
comment on column TMS_CRVAT_INV_REQ_H_INF.source_contract_number
is '来源合同编码';
comment on column TMS_CRVAT_INV_REQ_H_INF.qty_of_pre_invoice
is '生成的准备单数量';
comment on column TMS_CRVAT_INV_REQ_H_INF.start_trx_date
is '交易起始日期';
comment on column TMS_CRVAT_INV_REQ_H_INF.end_trx_date
is '交易结束日期';
comment on column TMS_CRVAT_INV_REQ_H_INF.is_tax
is '是否含税';
comment on column TMS_CRVAT_INV_REQ_H_INF.start_date
is '有效日期';
comment on column TMS_CRVAT_INV_REQ_H_INF.end_date
is '失效日期';
comment on column TMS_CRVAT_INV_REQ_H_INF.status
is '状态';
comment on column TMS_CRVAT_INV_REQ_H_INF.attribute_category
is '扩展字段结构类型';
comment on column TMS_CRVAT_INV_REQ_H_INF.attribute1
is '扩展字段1';
comment on column TMS_CRVAT_INV_REQ_H_INF.attribute2
is '扩展字段2';
comment on column TMS_CRVAT_INV_REQ_H_INF.attribute3
is '扩展字段3';
comment on column TMS_CRVAT_INV_REQ_H_INF.attribute4
is '扩展字段4';
comment on column TMS_CRVAT_INV_REQ_H_INF.attribute5
is '扩展字段5';
comment on column TMS_CRVAT_INV_REQ_H_INF.attribute6
is '扩展字段6';
comment on column TMS_CRVAT_INV_REQ_H_INF.attribute7
is '扩展字段7';
comment on column TMS_CRVAT_INV_REQ_H_INF.attribute8
is '扩展字段8';
comment on column TMS_CRVAT_INV_REQ_H_INF.attribute9
is '扩展字段9';
comment on column TMS_CRVAT_INV_REQ_H_INF.attribute10
is '扩展字段10';
comment on column TMS_CRVAT_INV_REQ_H_INF.archive_base_date
is '归档基准日期';
comment on column TMS_CRVAT_INV_REQ_H_INF.biz_org_code
is '业务组织编号';
comment on column TMS_CRVAT_INV_REQ_H_INF.created_by
is '创建人';
comment on column TMS_CRVAT_INV_REQ_H_INF.creation_date
is '创建时间';
comment on column TMS_CRVAT_INV_REQ_H_INF.last_updated_by
is '最后修改人';
comment on column TMS_CRVAT_INV_REQ_H_INF.last_update_date
is '最后修改时间';
comment on column TMS_CRVAT_INV_REQ_H_INF.record_version
is '记录版本号';
comment on column TMS_CRVAT_INV_REQ_H_INF.deleted_flag
is '删除标记';
comment on column TMS_CRVAT_INV_REQ_H_INF.deleted_by
is '删除人';
comment on column TMS_CRVAT_INV_REQ_H_INF.deletion_date
is '删除时间';
comment on column TMS_CRVAT_INV_REQ_H_INF.data_owner_code
is '数据拥有者代码(机构/组织等)';
comment on column TMS_CRVAT_INV_REQ_H_INF.company_id
is '所属公司ID';
comment on column TMS_CRVAT_INV_REQ_H_INF.operation_org_code
is '运营组织CODE';
-- Create/Recreate primary, unique and foreign key constraints alter table TMS_CRVAT_INV_REQ_H_INF
add constraint PK_TMS_CRVAT_INV_REQ_H_INF primary key (INTERFACE_TRX_HEADER_ID);