| CCRD | |||||||
| 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 | Modfied By | |||||
| ma_modifieddate | datetime | Modfied 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 Categosry | ||||||
| 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 Starion | ||||||
| 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 Maintanence 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 | Maitenance 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 | Receving Location | ||||||
| num_type | Numering 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 Strore 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 CostCenter 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 CostCenter 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 CostCenter 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 Descripiton | ||||||
| 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 CostCenter 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 costcenter 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 costcenter 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 costcenter 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 costcenter 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 CostCenter 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 Descripton | ||||||
| folderdesc | Folder Descripton | ||||||
| shppointdesc | Ship Point Descripton | ||||||
| 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  Descripiton | ||||||
| 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 CostCenter 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 | ||||||