TMS CRVAT INV REQ H INF

来自ling
跳转至: 导航搜索

-- 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);