Cost Center Rule Definition

Cost Center Rule Definition

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	ccrd_intcomp_list	To store component name , activity name and transaction type	comp_name	sql_variant	Component Name	No	No
			activity_name		Activity Name
			tran_type		Transaction Type
	ccrd_inv_defn_tmp		guid		Guid
			bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			company	sql_variant	Company
			event		Event
			tranou		Transaction Organization Unit
			account_code		Account Code
			flag		Flag
			warehouse		Ware House
			doc_category		Document Category
			num_type		Numbering Type
			mrtype		Material Requisition Type
			partaccgrp		Part Account Group
			part_category		Part Category
			part_type		Part Type
			component_type		Component Type
			ccusage		Cost Center Usage
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			ma_createdby	sql_variant	Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	ccrd_inv_defn_tmp2		GUID	sql_variant	Guid
			BU_ID		Business Unit Id
			OU_ID	int	Organization Unit Id
			COMPANY	sql_variant	Company
			EVENT		Event
			TRANOU		Transaction Organization Unit
			ACCOUNT_CODE		Account Code
			FLAG		Flag
			WAREHOUSE		Ware House
			DOC_CATEGORY		Document Category
			NUM_TYPE		Number Type
			MRTYPE		Material Requisition Type
			PARTACCGRP		Part Account Group
			PART_CATEGORY		Part Category
			PART_TYPE		Part Type
			COMPONENT_TYPE		Component Type
			CCUSAGE		Cost Center Usage
			COST_CENTER		Cost Center
			EFFECTIVE_FROM_DATE	datetime	Effective From Date
			EFFECTIVE_TO_DATE		Effective To Date
			MA_CREATEDBY	sql_variant	Created By
			MA_CREATEDDATE	datetime	Created Date
			MA_MODIFIEDBY	sql_variant	Modified By
			MA_MODIFIEDDATE	datetime	Modified Date
			MA_TIMESTAMP	int	Time Stamp
	ccrd_inv_defn_tmp3		guid	sql_variant	Guid
			bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			company	sql_variant	Company
			event		Event
			tranou		Transaction Organization Unit
			account_code		Account Code
			warehouse		Ware House
			doc_category		Document Category
			num_type		Number Type
			mrtype		Material Requisition Type
			partaccgrp		Part Account Group
			part_category		Part Category
			part_type		Part Type
			component_type		Component Type
			ccusage		Cost Center Usage
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			ma_createdby	sql_variant	Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	ccrd_inventory_defn	To Store Details to Maintain Inventory Cost Center Rule Definition	bu_id	sql_variant	Business Unit Id
			ou_id	int	Organization Unit Id
			company	sql_variant	Company
			event		Event
			tranou		Transaction Organization Unit
			account_code		Account Code
			warehouse		Ware House
			doc_category		Document Category
			num_type		Number Type
			mrtype		Material Requisition Type
			partaccgrp		Part Account Group
			part_category		Part Category
			part_type		Part Type
			component_type		Component Type
			ccusage		Cost Center Usage
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			ma_createdby	sql_variant	Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	ccrd_inventory_defn_tmp		guid	sql_variant	Guid
			bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			company	sql_variant	Company
			event		Event
			tranou		Transaction Organization Unit
			account_code		Account Code
			warehouse		Ware House
			doc_category		Document Category
			num_type		Numbering Type
			mrtype		Material Requisition Type
			partaccgrp		Part Account Group
			part_category		Part Category
			part_type		Part Type
			component_type		Component Type
			ccusage		Cost Center Usage
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			ma_createdby	sql_variant	Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	ccrd_inventory_defn_tmp1		bu_id	sql_variant	Business Unit Id
			ou_id	int	Organization Unit Id
			company	sql_variant	Company
			event		Event
			tranou		Transaction Organization Unit
			account_code		Account Code
			flag		Flag
			warehouse		Ware House
			doc_category		Document Category
			num_type		Numbering Type
			mrtype		Material Requisition Type
			partaccgrp		Part Account Group
			part_category		Part Category
			part_type		Part Type
			component_type		Component Type
			ccusage		Cost Center Usage
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			ma_createdby	sql_variant	Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	ccrd_is_part_param_tmp		guid	sql_variant	Guid
			parameter_name		Parameter Name
	ccrd_maint_defn_hdrtmp		guid		Guid
			bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			company	sql_variant	Company
			account_code		Account Code
			event		Event
			order_category	int	Order Category
			rotype	sql_variant	Repair Order Type
			planning_base		Planning Base
			maintenance_base		Maintenance Base
			reporting_station		Reporting Station
			primary_work_center		Primary Work Center
			work_center		Work Center
	ccrd_maint_defn_tmp		guid		Guid
			bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			company	sql_variant	Company
			account_code		Account Code
			event		Event
			order_category		Order Category
			rotype		Repair Order Type
			planning_base		Planning Base
			maintenance_base		Maintenance Base
			reporting_station		Reporting Station
			primary_work_center		Primary Work Center
			work_center		Work Center
			aircraft_model		Aircraft Model
			aircraft_reg		Aircraft Register
			aircraft_ownership		Aircraft Ownership
			component_ownership		Component Ownership
			part_classification		Part Classification
			component_type		Component Type
			component_family		Component Family
			cost_center		Cost Center
			ccdesc		Cost Center Description
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			ma_createdby	sql_variant	Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
			fieldbase	sql_variant	fieldbase
	ccrd_maintenance_defn	To Store Details to Maintain Maintenance Cost Center Rule Definition	bu_id	sql_variant	Business Unit Id
			ou_id	int	Organization Unit Id
			company	sql_variant	Company
			account_code		Account Code
			event		Event
			order_category		Order Category
			rotype		Repair Order Type
			planning_base		Planning Base
			maintenance_base		Maintenance Base
			reporting_station		Reporting Station
			primary_work_center		Primary Work Center
			work_center		Work Center
			aircraft_model		Aircraft Model
			aircraft_reg		Aircraft Register Number
			aircraft_ownership		Aircraft Ownership
			component_ownership		Component Ownership
			part_classification		Part Classification
			component_type		Component Type
			component_family		Component Family
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			ma_createdby	sql_variant	Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
			fieldbase	sql_variant	fieldbase
	ccrd_parameters	To store system parameters.	BU_ID	sql_variant	Business Unit Id
			OU_ID	int	Organization Unit Id
			COMPANY	sql_variant	Company
			APPLICABLE_ON		Applicable On
			PARAM_VALUE		Parameter Value
			MA_CREATEDBY		Created By
			MA_CREATEDDATE	datetime	Created Date
			MA_MODIFIEDBY	sql_variant	Modified By
			MA_MODIFIEDDATE	datetime	Modified Date
	ccrd_part_sale_defn	To Store Details to Maintain part sale Cost Center Rule Definition	ou	int	Organization Unit
			compcode	sql_variant	Component Code
			acccode		Account Code
			custgrp		Customer group
			numtype		Numbering Type
			packslipcate		Pack Slip Category
			ordloc		Order Location
			shiploc		Ship Location
			warehouse		Ware House
			partno		Part Number
			parttype		Part Type
			partcondn		Part Condition
			stockstatus		Stock Status
			part_cost_center		Part Cost Center
			part_effdate	datetime	Part Effective Date
	ccrd_purchase_defn	To Store Details to Maintain purchase Cost Center Rule Definition	bu_id	sql_variant	Business Unit Id
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			account_code		Account Code
			expense_type		Expense Type
			order_type		Order Type
			order_category		Order Category
			ordering_loc		Ordering Location
			receiving_loc		Receiving Location
			num_type		Numbering Type
			warehouse		Ware House
			aircraftregno		Aircraft Register Number
			part_type		Part Type
			part_category		Part Category
			usageid		Usage Id
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			ma_createdby	sql_variant	Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	ccrd_purchase_defn_tmp		guid	sql_variant	Guid
			bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			account_code		Account Code
			expense_type		Expense Type
			order_type		Order Type
			order_category		Order Category
			ordering_loc		Order Location
			receiving_loc		Receiving Location
			num_type		Numbering Type
			warehouse		Ware House
			aircraftregno		Aircraft Register Number
			part_type		Part Type
			part_category		Part Category
			usageid		Usage Id
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			ma_createdby	sql_variant	Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	ccrd_purchase_defn_tmp1		BU_ID	sql_variant	Business Unit Id
			OU_ID	int	Organization Unit Id
			COMPANY_CODE	sql_variant	Company Code
			ACCOUNT_CODE		Account Code
			FLAG		Flag
			EXPENSE_TYPE		Expense Type
			ORDER_TYPE		Order Type
			ORDER_CATEGORY		Order Category
			ORDERING_LOC		Ordering Location
			RECEIVING_LOC		Receiving Location
			NUM_TYPE		Number Type
			WAREHOUSE		Ware House
			AIRCRAFTREGNO		Aircraft Register Number
			PART_TYPE		Part Type
			PART_CATEGORY		Part Category
			USAGEID		Usage Id
			COST_CENTER		Cost Center
			EFFECTIVE_FROM_DATE	datetime	Effective From Date
			EFFECTIVE_TO_DATE		Effective To Date
			MA_CREATEDBY	sql_variant	Created By
			MA_CREATEDDATE	datetime	Created Date
			MA_MODIFIEDBY	sql_variant	Modified By
			MA_MODIFIEDDATE	datetime	Modified Date
			MA_TIMESTAMP	int	Time Stamp
	ccrd_rentals_defn	To Store Details to Maintain rentals Cost Center Rule Definition	ou		Organization Unit
			compcode	sql_variant	Component Code
			acccode		Account Code
			custgrp		Customer Group
			numtype		Number Type
			rent_cat		Rent Category
			rent_ord_loc		Rent Order Location
			issueloc		Issue Location
			rent_warehouse		Rent Ware House
			rent_partno		Rent Part Number
			rent_parttype		Rent Part Type
			rent_part_cat		Rent Part Category
			rent_loc		Rent Location
			rent_cost_center		Rent Cost Center
			rent_effdate	datetime	Rent Effective Date
	ccrd_service_sale_defn	To Store Details to Maintain Service sale Cost Center Rule Definition	ou	int	Organization Unit
			compcode	sql_variant	Component Code
			acccode		Account Code
			custgrp		Customer Group
			numtype		Numbering Type
			ser_ord_cat		Service Order Category
			ser_ord_loc		Service Order Location
			execfac		Executing Facility
			workcenter		Work Center
			aircraftmodel		Aircraft Model
			ser_part_cat		Service Part Category
			comptype		Component Type
			ser_cost_center		Service Cost Center
			ser_effdate	datetime	Service Effective Date
	ccrd_usage_defn	To Store Usage Details	bu_id	sql_variant	Business Unit Id
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			ma_cc_usage_id		Cost Center Usage Id
			usage_desc		Usage Description
			usage_short_desc		Usage Short Description
			app_id		Application Id
			usage_status		Usage Status. Values A - Active , I- Inactive
			ma_createdby		Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	ccrd_usage_defn_tmp		guid	sql_variant	Guid
			bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			ma_cc_usage_id		Cost Center Usage Id
			usage_desc		Usage Description
			usage_short_desc		Usage Short Description
			app_id		Application Id
			usage_status		Usage Status.Values A-Active,I-InActive
			ma_createdby		Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	cim_inter_ou_temp		dest_ou		Destination Organization Unit
			guid	sql_variant	Guid
	crd_company_fb_tmp
			fb_id		Finance Book Id
			expense_flag		Expense Flag
			asset_flag		Asset Flag
			wip_flag		Work In Progress Flag. Values Yes and No
			acc_effective_date	datetime	Accounting Effective Date
			acc_expiry_date		Accounting Expiry Date
	crd_inv_addln_dtl	To Store Additional Information to Maintain Inventory Cost Center Rule Definition	bu_id	sql_variant	Business Unit Id
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			event		Event
			finance_book		Finance Book
			account_code		Account Code
			usage_id		Usage Id
			effective_from_date	datetime	Effective From Date
			item_type	sql_variant	Item Type
			item_group		Item Group
			receipt_at		Receipt At
			docu_type		Document Type
			item_code		Item Code
			supplier_code		Supplier Code
			stock_status		Stock Status
			requester		Requester
			number_series		Number Series
			cost_center		Cost Center
			effective_to_date	datetime	Effective To Date
			ma_createdby	sql_variant	Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	crd_inv_addln_dtl_temp		bu_id	sql_variant	Business Unit Id
			guid		Guid
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			event		Event
			finance_book		Finance Book
			account_code		Account Code
			item_type		Item Type
			item_group		Item Group
			usage_id		Usage Id
			receipt_at		Receipt At
			docu_type		Document Type
			item_code		Item Code
			supplier_code		Supplier Code
			stock_status		Stock Status
			requester		Requester
			number_series		Number Series
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			fprowno	int	Finance Posting Row Number
	crd_inv_addln_dtl_vw_temp		bu_id	sql_variant	Business Unit Id
			guid		Guid
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			event		Event
			finance_book		Finance Book
			account_code		Account Code
			item_type		Item Type
			item_group		Item Group
			usage_id		Usage Id
			receipt_at		Receipt At
			docu_type		Document Type
			item_code		Item Code
			supplier_code		Supplier Code
			stock_status		Stock Status
			requester		Requester
			number_series		Number Series
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			AccountDesc	sql_variant	Account Description
			ItemGroupDesc		Item Group Description
			ItemDesc		Item Description
			SupplierName		Supplier Name
			CostCenterDesc		Cost Center Description
			flag		Flag
	crd_inventory_defn	To Store Details to Maintain Inventory Cost Center Rule Definition	bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			event		Event
			finance_book		Finance Book
			account_code		Account Code
			effective_from_date	datetime	Effective From Date
			cost_center	sql_variant	Cost Center
			effective_to_date	datetime	Effective To Date
			addln_para_yn	sql_variant	Additional Parameter Yes Or No
			ma_createdby		Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	crd_inventory_defn_temp		bu_id	sql_variant	Business Unit Id
			guid		Guid
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			event		Event
			finance_book		Finance Book
			account_code		Account Code
			effective_from_date	datetime	Effective From Date
			cost_center	sql_variant	Cost Center
			effective_to_date	datetime	Effective To Date
			addln_para_yn	sql_variant	Additional Parameter Yes Or No
			fprowno	int	Finance Posting Row Number
	crd_is_cost_usg_tbl_tmp		guid	sql_variant	Guid
			ccusageid		Cost Center Usage Id
	crd_pur_addln_dtl	To store Additional Details for Purchase Cost Center Definition	bu_id		Business Unit Id	Yes
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			event		Event
			finance_book		Finance Book
			account_code		Account Code
			usage_id		Usage Id
			effective_from_date	datetime	Effective From Date
			supplier_group	sql_variant	Supplier Group	No
			supplier_code		Supplier Code
			receipt_at		Receipt At
			number_series		Number Series
			item_group		Item Group
			item_code		Item Code
			item_variant		Item Variant
			folder		Folder
			cost_center		Cost Center
			effective_to_date	datetime	Effective To Date
			ma_createdby	sql_variant	Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	crd_pur_addln_dtl_temp		bu_id	sql_variant	Business Unit Id
			guid		Guid
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			event		Event
			finance_book		Finance Book
			account_code		Account Code
			supplier_group		Supplier Group
			supplier_code		Supplier Code
			usage_id		Usage Id
			receipt_at		Receipt At
			number_series		Number Series
			item_group		Item Group
			item_code		Item Code
			item_variant		Item Variant
			folder		Folder
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
	crd_pur_addln_dtl_vw_temp		bu_id	sql_variant	Business Unit Id
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			event		Event
			finance_book		Finance Book
			account_code		Account Code
			tcd_code		Tax Charge Discount Code
			tcd_variant		Tax Charge Discount Variant
			supplier_group		Supplier Group
			supplier_code		Supplier Code
			receipt_at		Receipt At
			number_series		Number Series
			folder		Folder
			transport_mode		Transport Mode
			usage_id		Usage Id
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			AccountDesc	sql_variant	Account Description
			tcd_code_desc		Tax Charge Discount Code Description
			tcd_var_desc		Tax Charge Discount Variant Description
			sup_grp_desc		Supplier Group Description
			SupplierName		Supplier Name
			CostCenterDesc		Cost Center Description
	crd_pur_addln_dtl_vw_tmp		bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			event		Event
			eventdesc		Event Description
			account_code		Account Code
			account_codedesc		Account Code Description
			finance_book		Finance Book
			supplier_code		Supplier Code
			supplier_name		Supplier Name
			supplier_group		Supplier Group
			supplier_groupdesc		Supplier Group Description
			usage_id		Usage Id
			receipt_at		Receipt At
			receipt_atouname		Receipt At Organization Name
			number_series		Number Series
			item_group		Item Group
			item_groupdesc		Item Group Description
			item_code		Item Code
			item_codedesc		Item Code Description
			item_variant		Item Variant
			item_variantdesc		Item Variant Description
			folder		Folder
			folderdesc		Folder Description
			cost_center		Cost Center
			cost_centerdesc		Cost Center Description
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			flag	sql_variant	Flag
			guid		Guid
	crd_pur_defn	To store Details for Purchase Cost Center Definition	bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			finance_book		Finance Book
			account_code		Account Code
			event		Event
			effective_from_date	datetime	Effective From Date
			cost_center	sql_variant	Cost Center
			effective_to_date	datetime	Effective To Date
			addln_para_yn	sql_variant	Additional Parameter Yes Or No
			ma_createdby		Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	crd_pur_defn_temp		bu_id	sql_variant	Business Unit Id
			guid		Guid
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			finance_book		Finance Book
			account_code		Account Code
			event		Event
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			addln_para_yn	sql_variant	Additional Parameter. Values Yes Or No
	crd_pur_tcd_addln_dtl	To store Additional Tax/Charge/Discount Details for Purchase Cost Center Definition	bu_id		Business Unit Id	Yes
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			event		Event
			finance_book		Finance Book
			account_code		Account Code
			tcd_code		Tax Charge Discount Code
			tcd_variant		Tax Charge Discount Variant
			usage_id		Usage Id
			effective_from_date	datetime	Effective From Date
			supplier_group	sql_variant	Supplier Group	No
			supplier_code		Supplier Code
			receipt_at		Receipt At
			number_series		Number Series
			folder		Folder
			transport_mode		Transport Mode
			cost_center		Cost Center
			effective_to_date	datetime	Effective To Date
			ma_createdby	sql_variant	Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	crd_pur_tcd_addln_dtl_temp		bu_id	sql_variant	Business Unit Id
			guid		Guid
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			event		Event
			finance_book		Finance Book
			tcd_code		Tax Charge Discount Code
			tcd_variant		Tax Charge Discount Variant
			account_code		Account Code
			cost_center		Cost Center
			usage_id		Usage Id
			supplier_group		Supplier Group
			supplier_code		Supplier Code
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			receipt_at	sql_variant	Receipt At
			number_series		Number Series
			folder		Folder
			transport_mode		Transport Mode
			fprowno	int	Finance Posting Row Number
	crd_pur_tcd_addln_dtl_temp1		bu_id	sql_variant	Business Unit Id
			guid		Guid
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			event		Event
			finance_book		Finance Book
			tcd_code		Tax Charge Discount Code
			tcd_variant		Tax Charge Discount Variant
			account_code		Account Code
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			update_flag	sql_variant	Update Flag
	crd_pur_tcd_addln_dtl_temp3		bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			event		Event
			finance_book		Finance Book
			account_code		Account Code
			tcd_code		Tax Charge Discount Code
			tcd_variant		Tax Charge Discount Variant
			usage_id		Usage Id
			effective_from_date	datetime	Effective From Date
			supplier_group	sql_variant	Supplier Group
			supplier_code		Supplier Code
			receipt_at		Receipt At
			number_series		Number Series
			folder		Folder
			transport_mode		Transport Mode
			cost_center		Cost Center
			cost_center_desc		Cost Center Description
			effective_to_date	datetime	Effective From Date
			update_flag	sql_variant	Update Flag
			guid		Guid
	crd_pur_tcd_addln_dtl_temp4		bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			event		Event
			finance_book		Finance Book
			account_code		Account Code
			tcd_code		Tax Charge Discount Code
			tcd_variant		Tax Charge Discount Variant
			usage_id		Usage Id
			effective_from_date	datetime	Effective From Date
			supplier_group	sql_variant	Supplier Group
			supplier_code		Supplier Code
			receipt_at		Receipt At
			number_series		Number Series
			folder		Folder
			transport_mode		Transport Mode
			cost_center		Cost Center
			cost_center_desc		Cost Center Description
			effective_to_date	datetime	Effective To Date
			update_flag	sql_variant	Update Flag
			guid		Guid
	crd_pur_tcd_date_fb_temp		bu_id		Business Unit Id
			guid		Guid
			ou_id	int	Business Unit Id
			company_code	sql_variant	Company Code
			account_code		Account Code
			finance_book		Finance Book
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
	crd_pur_tcd_defn	To Store Details to maintain Tax/Charge/Discount Purchase Cost Center Rule Definition	bu_id	sql_variant	Business Unit Id	Yes
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			account_code		Account Code
			finance_book		Finance Book
			event		Event
			effective_from_date	datetime	Effective From Date	No
			cost_center	sql_variant	Cost Center
			tcd_code		Tax Charge Discount Code
			tcd_variant		Tax Charge Discount Variant
			effective_to_date	datetime	Effective To Date
			addln_para_yn	sql_variant	Additional Parameter Yes Or No
			ma_createdby		Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	crd_pur_tcd_defn_temp		bu_id	sql_variant	Business Unit Id
			guid		Guid
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			account_code		Account Code
			finance_book		Finance Book
			event		Event
			effective_from_date	datetime	Effective From Date
			cost_center	sql_variant	Cost Center
			tcd_code		Tax Charge Discount Code
			tcd_variant		Tax Charge Discount Variant
			effective_to_date	datetime	Effective From Date
			addln_para_yn	sql_variant	Additional Parameter Yes Or No
			fprowno	int	Finance Posting Row Number
	crd_pur_tcd_defn_temp1		bu_id	sql_variant	Business Unit Id
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			account_code		Account Code
			finance_book		Finance Book
			event		Event
			effective_from_date	datetime	Effective From Date
			cost_center	sql_variant	Cost Center
			tcd_code		Tax Charge Discount Code
			tcd_variant		Tax Charge Discount Variant
			effective_to_date	datetime	Effective To Date
			addln_para_yn	sql_variant	Additional Parameter Yes Or No
			guid		Guid
			update_flag		Update Flag
	crd_sale_addln_dtl	To Store Additional Information to sales Cost Center Rule Definition	bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			finance_book		Finance Book
			account_code		Account Code
			usage_id		Usage Id
			effective_from_date	datetime	Effective From Date
			cust_group	sql_variant	Customer Group
			cust_code		Customer Code
			ship_to_id		Ship To Id
			sale_type		Sale Type
			sale_order_type		Sale Order Type
			processing_action		Processing Action
			number_series		Number Series
			item_group		Item Group
			item_code		Item Code
			item_variant		Item Variant
			folder		Folder
			ship_to_point	int	Ship To Print
			delivery_area_code	sql_variant	Delivery Area Code
			order_point	int	Order Print
			cost_center	sql_variant	Cost Center
			effective_to_date	datetime	Effective To Date
			ma_createdby	sql_variant	Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	crd_sale_addln_dtl_temp		guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			bu_id	sql_variant	Business Unit Id
			company_code		Company Code
			finance_book		Finance Book
			account_code		Account Code
			cust_group		Customer Group
			cust_code		Customer Code
			usage_id		Usage Id
			sale_type		Sale Type
			sale_order_type		Sale Order Type
			ship_to_id		Ship To Id
			processing_action		Processing Action
			number_series		Number Series
			item_group		Item Group
			item_code		Item Code
			item_variant		Item Variant
			folder		Folder
			ship_to_point	int	Ship To Print
			delivery_area_code	sql_variant	Delivery Area Code
			order_point	int	Order Point
			cost_center	sql_variant	Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			fprowno	int	Finance Posting Row Number
	crd_sale_defn	To store Details to maintain sale cost center rule definition	bu_id	sql_variant	Business Unit Id	Yes
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			account_code		Account Code
			finance_book		Finance Book
			effective_from_date	datetime	Effective From Date
	crd_sale_defn_temp		bu_id	sql_variant	Business Unit Id	No
			guid		Guid
			ou_id	int	Organization Unit ID
			company_code	sql_variant	Company Code
			account_code		Account Code
			finance_book		Finance Book
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			addln_para_yn	sql_variant	Additional Parameter Yes Or No
			fprowno	int	Finance Posting Row Number
	crd_sale_part_defn	To store Details to maintain sale part cost center rule definition	ou_id		Organization Unit Id
			company_code	sql_variant	Company Code
			account_code		Account Code
			customer_group		Customer Group
			num_type		Number Type
			cost_center		Cost Center
			ccdesc		Cost Code Description
			effective_from	datetime	Effective From
			effective_to		Effective To
			packslip_category	sql_variant	Pack Slip Category
			order_loc		Order Location
			ship_loc		Ship Location
			warehouse		Ware House
			part_no		Part Number
			part_type		Part Type
			part_category		Part Category
			part_condition		Part Condition
			stock_status		Stock Status. Values All
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	crd_sale_part_defn_tmp		cost_center	sql_variant	Cost Center
			ccdesc		Cost Code Description
			effective_from	datetime	Effective From
			effective_to		Effective To
			packslip_category	sql_variant	Pack Slip Category
			order_loc		Order Location
			ship_loc		Ship Location
			warehouse		Ware House
			part_no		Part Number
			part_type		Part Type
			part_category		Part Category
			part_condition		Part Condition
			stock_status		Stock Status
			guid		Guid
	crd_sale_rental_defn	To store Details to maintain rental sale cost center rule definition	ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			account_code		Account Code
			customer_group		Customer Group
			num_type		Number Type
			cost_center		Cost Center
			ccdesc		Cost Center Description
			effective_from	datetime	Effective From
			effective_to		Effective To
			rental_category	sql_variant	Rental Category
			order_loc		Order Location
			issue_loc		Issue Location
			warehouse		Ware House
			part_no		Part Location
			part_type		Part Type
			part_category		Part Category
			return_loc		Return Location
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Location
	crd_sale_rental_defn_tmp		cost_center	sql_variant	Cost Center
			ccdesc		Cost Center Description
			effective_from	datetime	Effective From
			effective_to		Effective To
			rental_category	sql_variant	Rental Category
			order_loc		Order Location
			issue_loc		Issue Location
			warehouse		Ware House
			part_no		Part Number
			part_type		Part Type
			part_category		Part Category
			return_loc		Return Location
			guid		Guid
	crd_sale_service_defn	To store Details to maintain service sale cost center rule definition	ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			account_code		Account Code
			customer_group		Customer Group
			num_type		Number Type
			cost_center		Cost Center
			ccdesc		Cost Center Description
			effective_from	datetime	Effective From
			effective_to		Effective To
			order_category	sql_variant	Order Category
			order_loc		Order Location
			execution_facility		Execution Facility
			execution_loc		Execution Location
			work_center		Work Center
			aircraft_model		Aircraft Model
			part_category		Part Category
			component_type		Component Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			PART_GROUP	sql_variant	Part Group
	crd_sale_service_defn_tmp		cost_center		Cost Center
			ccdesc		Cost Center Description
			effective_from	datetime	Effective From
			effective_to		Effective To
			order_category	sql_variant	Order Category
			order_loc		Order Location
			execution_facility		Execution Facility
			execution_loc		Execution Location
			work_center		Work Center
			aircraft_model		Aircraft Model
			part_category		Part Category
			component_type		Component Type
			guid		Guid
			PART_GROUP		Part Group
	crd_sale_tcd_addln_dtl	To Store additional details to maintain Tax/Charge/Discount Sales Cost Center Rule Definition	bu_id		Business Unit Id	Yes
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			event		Event
			finance_book		Finance Book
			account_code		Account Code
			tcd_code		Tax Charge Discount Code
			tcd_variant		Tax Charge Discount Variant
			usage_id		Usage Id
			effective_from_date	datetime	Effective From Date
			cust_group	sql_variant	Customer Group	No
			cust_code		Customer Code
			ship_to_id		Ship To Id
			sale_type		Sales Type
			sale_order_type		Sales Order Type
			processing_action		Processing Action
			number_series		Number Series
			folder		Folder
			ship_to_point	int	Ship To Point
			delivery_area_code	sql_variant	Delivery Area Code
			order_point	int	Order Point
			transport_mode	sql_variant	Transport Mode
			cost_center		Cost Center
			effective_to_date	datetime	Effective To Date
			ma_createdby	sql_variant	Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	crd_sale_tcd_addln_dtl_temp		guid	sql_variant	Guid
			bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			event		Event
			finance_book		Finance Book
			account_code		Account Code
			tcd_code		Tax Charge Discount Code
			tcd_variant		Tax Charge Discount Variant
			cust_group		Customer Group
			usage_id		Usage Id
			sale_type		Sales Type
			cust_code		Customer Code
			sale_order_type		Sales Order Type
			ship_to_id		Ship To Id
			processing_action		Processing Action
			number_series		Number Series
			folder		Folder
			ship_to_point	int	Ship To Point
			delivery_area_code	sql_variant	Delivery Area Code
			order_point	int	Order Point
			transport_mode	sql_variant	Transport Mode
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			fprowno	int	Finance Posting Row Number
	crd_sale_tcd_addln_dtl_vw_temp		guid	sql_variant	Guid
			finance_book		Finance Book
			account_code		Account Code
			tcd_code		Tax Charge Discount Code
			tcd_variant		Tax Charge Discount Variant
			cust_group		Customer Group
			usage_id		Usage Id
			sale_type		Sales Type
			cust_code		Customer Code
			sale_order_type		Sales Order Type
			ship_to_id		Ship To Id
			processing_action		Processing Action
			number_series		Number Series
			folder		Folder
			ship_to_point	int	Ship To Point
			delivery_area_code	sql_variant	Delivery Area Code
			order_point	int	Order Point
			transport_mode	sql_variant	Transport Mode
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			saletypedesc	sql_variant	Sales Type Description
			salreordertypedesc		Sales Order Type Description
			processingactdesc		Processing Actual Description
			folderdesc		Folder Description
			shppointdesc		Ship Point Description
			ordpointdesc		Order Point Description
			acdesc		Account Description
			custgrpdesc		Customer Group Description
			custnamedesc		Customer Name Description
			itemgrpdesc		Item Group Description
			itemdesc		Item Description
			itemvardesc		Item Variant Description
			ccdesc		Cost Code Description
	crd_sale_tcd_addln_dtl_vw_tmp		bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			event		Event
			finance_book		Finance Book
			account_code		Account Code
			account_desc		Account Description
			tcd_code		Tax Charge Discount Code
			tcd_codedesc		Tax Charge Discount Code Description
			tcd_variant		Tax Charge Discount Variant
			tcdvariantdesc		Tax Charge Discount Variant Description
			usage_id		Usage Id
			cust_group		Customer Group
			cust_grdesc		Customer Group Description
			cust_name		Customer Name
			cust_code		Customer Code
			ship_to_id		Ship To Id
			sale_type		Sales Type
			sale_order_type		Sales Order Type
			processing_action		Processing Action
			number_series		Number Series
			folder		Folder
			ship_to_point	int	Ship To Point
			delivery_area_code	sql_variant	Delivery Area Code
			order_point	int	Order Point
			transport_mode	sql_variant	Transport Mode
			cost_center		Cost Center
			cost_centerdesc		Cost Center Description
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
			guid	sql_variant	Guid
	crd_sale_tcd_date_fb_temp		bu_id		Business Unit Id
			guid		Guid
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			account_code		Account Code
			finance_book		Finance Book
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			effective_to_date		Effective To Date
	crd_sale_tcd_defn	To Store Details to maintain Tax/Charge/Discount sale Cost Center Rule Definition	bu_id	sql_variant	Business Unit Id
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			account_code		Account Code
			finance_book		Finance Book
			event		Event
			effective_from_date	datetime	Effective From Date
			cost_center	sql_variant	Cost Center
			tcd_code		Tax Charge Discount Code
			tcd_variant		Tax Charge Discount Variant
			effective_to_date	datetime	Effective From Date
			addln_para_yn	sql_variant	Additional Parameter Yes Or No
			ma_createdby		Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	crd_sale_tcd_defn_temp		bu_id	sql_variant	Business Unit Id
			guid		Guid
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			account_code		Account Code
			finance_book		Finance Book
			event		Event
			cost_center		Cost Center
			effective_from_date	datetime	Effective From Date
			tcd_code	sql_variant	Tax Charge Discount Code
			tcd_variant		Tax Charge Discount Variant
			effective_to_date	datetime	Effective To Date
			addln_para_yn	sql_variant	Additional Parameter Yes Or No
			fprowno	int	Finance Posting Row Number
	event_code_temp		guid	sql_variant	Guid
			parameter_code		Parameter Code
	transport_mode_temp		tptmodecode		Transport Mode Code
			tptmodedesc		Transport Mode Description
			guid		Guid