TMS CRVAT INV PRT POOL HIS H

来自ling
跳转至: 导航搜索

-- Create table create table TMS_CRVAT_INV_PRT_POOL_HIS_H (

 invoice_prt_pool_his_h_id     CHAR(36) not null,
 invoice_prt_pool_h_id         CHAR(36),
 crvat_invoice_pre_h_id        CHAR(36),
 print_version                 NUMBER default 1,
 inventory_invoice_id          CHAR(36),
 invoice_code                  VARCHAR2(100),
 invoice_number                VARCHAR2(100),
 invoice_category              VARCHAR2(100),
 orig_invoice_category         VARCHAR2(100),
 invoicing_type                VARCHAR2(100),
 invoice_limit_amount          VARCHAR2(100),
 invoice_req_type              CHAR(36),
 customer_id                   CHAR(36),
 customer_number               VARCHAR2(100),
 cust_registration_number      VARCHAR2(100),
 cust_registration_code        VARCHAR2(100),
 customer_name                 VARCHAR2(500),
 cust_registration_address     VARCHAR2(500),
 cust_contact_phone            VARCHAR2(100),
 cust_contact_name             VARCHAR2(100),
 cust_deposit_bank_number      VARCHAR2(100),
 cust_deposit_bank_name        VARCHAR2(500),
 cust_deposit_bank_account_num VARCHAR2(100),
 is_exits_customer             VARCHAR2(10) default '0',
 legal_entity_id               CHAR(36),
 legal_entity_code             VARCHAR2(100),
 legal_entity_name             VARCHAR2(500),
 registration_number           VARCHAR2(100),
 registration_code             VARCHAR2(100),
 bank_branch_name              VARCHAR2(500),
 bank_account_num              VARCHAR2(100),
 registration_contact_phone    VARCHAR2(500),
 registration_contact_address  VARCHAR2(500),
 payee                         VARCHAR2(100),
 checker                       VARCHAR2(100),
 is_issue_manifest             VARCHAR2(10) default '0',
 sales_document_num            VARCHAR2(100),
 equipment_id                  VARCHAR2(100),
 equipment_code                VARCHAR2(100),
 equipment_name                VARCHAR2(100),
 invoice_print_status          VARCHAR2(100),
 upload_status                 VARCHAR2(100),
 invoice_qty                   NUMBER,
 invoice_print_by              VARCHAR2(100),
 invoice_print_date            DATE,
 source_code                   VARCHAR2(100),
 source_trx_id                 VARCHAR2(100),
 source_trx_line_id            VARCHAR2(100),
 source_trx_line_type          VARCHAR2(100),
 source_trx_detail_tax_line_id VARCHAR2(100),
 source_distribution_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,
 biz_org_code                  VARCHAR2(100),
 created_by                    CHAR(36),
 creation_date                 DATE,
 last_updated_by               CHAR(36),
 last_update_date              DATE,
 record_version                NUMBER,
 deleted_by                    CHAR(36),
 deletion_date                 DATE,
 data_owner_code               VARCHAR2(100),
 company_id                    CHAR(36),
 operation_org_code            VARCHAR2(100),
 org_id                        CHAR(36)

);