TMS CRVAT INV PRT POOL HIS D
来自ling
-- Create table create table TMS_CRVAT_INV_PRT_POOL_HIS_D (
invoice_prt_pool_his_id CHAR(36) not null, invoice_prt_pool_d_id CHAR(36), invoice_prt_pool_his_l_id CHAR(36), invoice_prt_pool_l_id CHAR(36), crvat_invoice_pre_l_id CHAR(36), crvat_trx_pool_id CHAR(36), print_version NUMBER default 1, 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, 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)
);