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