TMS CRVAT INV PRT POOL HIS L

来自ling
跳转至: 导航搜索

-- Create table create table TMS_CRVAT_INV_PRT_POOL_HIS_L (

 invoice_prt_pool_his_l_id     CHAR(36) not null,
 invoice_prt_pool_l_id         CHAR(36),
 invoice_prt_pool_his_h_id     CHAR(36),
 invoice_prt_pool_h_id         CHAR(36),
 crvat_invoice_pre_l_id        CHAR(36),
 crvat_invoice_pre_p_id        CHAR(36),
 crvat_trx_pool_id             CHAR(36),
 print_version                 NUMBER default 1,
 line_num                      NUMBER,
 inventory_item_id             VARCHAR2(100),
 inventory_item_number         VARCHAR2(100),
 inventory_item_descripton     VARCHAR2(2000),
 inventory_item_models         VARCHAR2(500),
 uom_code                      VARCHAR2(100),
 uom_code_descripton           VARCHAR2(100),
 inventory_item_qty            NUMBER,
 price_of_unit                 NUMBER,
 invoice_amount                NUMBER,
 tax_rate                      NUMBER,
 acctd_amount_cr               NUMBER,
 vat_amount                    NUMBER,
 is_tax                        VARCHAR2(10) default '0' not null,
 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)

);