oracle ebs 11i 数据表大全

合集下载

OracleEBS常用表和视图

OracleEBS常用表和视图fnd_user系统用户表fnd_application应用信息表FND_PROFILE_OPTIONS_VL 系统配置文件fnd_menus 菜单fnd_menu_entries_tlFND_NEW_MESSAGES消息表FND_FORM表单表FND_CONCURRENT_PROGRAMS_VL 并发程序视图FND_CONCURRENT_PROGRAMS_TLFND_CONCURRENT_PROGRAMSFND_DESCR_FLEX_COL_USAGE_VLFND_DESCR_FLEX_COL_USAGE_TLFND_DESCR_FLEX_COLUMN_USAGESFND_EXECUTABLES_FORM_V 可执行并发程序视图FND_EXECUTABLES_TLFND_EXECUTABLESFND_DESCRIPTIVE_FLEXSFND_CONC_REQ_SUMMARY_V 并发请求视图FND_CONCURRENT_REQUESTSFND_RESPONSIBILITY职责表FND_RESPONSIBILITY_VL 职责FND_USER_RESP_GROUPS 用户职责fnd_flex_value_sets值集表FND_FLEX_VALUESFND_IREP_ALL_INTERFACES 接口表FND_IREP_CLASSESFnd_Irep_Classes_Tlfnd_territories_vl 国家视图fnd_log_messages 日志表fnd_form_functions 功能FND_DOCUMENT_SEQUENCES 单据序列FND_DOC_SEQUENCE_ASSIGNMENTS 序列分配fnd_id_flexs 关键弹性域定义表FND_ID_FLEX_STRUCTURES 弹性域结构表FND_ID_FLEX_SEGMENTS 弹性域段表fnd_descriptive_flexs 描述性弹性域属性表FND_DESCR_FLEX_CONTEXTS 弹性域列类别表FND_DESCR_FLEX_COLUMN_USAGES 弹性域列类别属性表FND_FLEX_VALUE_SETS 值集表FND_FLEX_VALUES 值表Fnd_Flex_Values_Tl 值描述表FND_FLEX_VALUE_NORM_HIERARCHY 值层次关系表FND_FORM_CUSTOM_RULES 个性化视图fnd_profile_options_tl 配置文件------------------------------------------------------------------------------------------------------PER_ALL_PEOPLE_F员工表per_people_f员工视图MTL_PLANNERS计划员表po_buyers_all_v采购员视图org_organization_definitions 库存组织视图hr_operating_units OU视图cux_wip_location_sign 位置号表HCM_PRODUCTION_LINE 生产线车间表user_objectsALL_SOURCEALL_PROCEDURES 存储过程wf_local_user_rolesad_bugs 补丁ad_applied_patchesXDO_TEMPLATES_B 模板XDO_TEMPLATES_TL------------------------------------------------------------------------------------------------po_vendors供应商信息表po_vendor_sites_all供应商地点信息视图AP_SUPPLIER_SITES_ALL 供应商地点表po_vendor_contacts------------------------------------------------------------------------------------------------------------------------------------------------wip_entities作业名信息表wip_discrete_jobs离散作业表wip_requirement_operations作业名物料需求发放表WIP_ACCOUNTING_CLASSES 工单分类表-------------------------------------------------------------------------------------------------------------------hr_locations交货地点hr_all_organization_unitsrcv_transactions_interface接收事务接口表po_interface_errors 接口错误信息表（pie.interface_line_id = rti.interface_transaction_id）po_requisitions_interface_all 请购接口表po_requisition_headers_all 请购单头信息po_requisition_lines_all请购单行信息po_req_distributions_all请购单分配行po_headers_all 采购订单头表po_lines_all 采购订单行表po_line_locations_all采购发运表po_distributions_all分配po_releases_all发放rcv_shipment_headers接收发送头表rcv_shipment_lines接收发送行表rcv_transactions接收交易表rcv_receiving_sub_ledger暂记应付表mtl_material_transactions物料事务处理mtl_transaction_types物料事务处理类型RCV_SUPPLYpo_buyers_all_v 采购员视图PO_AGENTS采购员表------------------------------------------------------------------------------------------------------------------------------------------------bom_bill_of_materials物料清单表bom_inventory_components物料清单构成表bom_departments 部门表bom_operational_routings 工艺路线头表BOM_OPERATION_SEQUENCES 工艺路线行表bom_operation_resources资源表------------------------------------------------------------------------------------------------------------------------------------------MTL_CATEGORY_SET_VALID_CATS_V 物料类别视图mtl_categories_b_kfv 物料类别视图(不含物料类别集)mtl_category_set_valid_cats 物料类别集表mtl_item_categories物料与类别对应表mtl_categories_b物料类别表mtl_system_items_b物料主表MTL_SYSTEM_ITEMS_TLmtl_item_sub_defaults默认接收子库mtl_secondary_inventories子库表mtl_onhand_quantities库存数据表MTL_ONHAND_QUANTITIES_DETAIL 库存现有量表MTL_SECONDARY_INVENTORIES 仓库表mtl_item_locations 项目货位表mtl_material_transactions 出入库记录表mtl_transaction_types事务处理类型表MTL_TXN_REQUEST_HEADERS 物料搬运单头表MTL_TXN_REQUEST_LINES物料搬运单行表mtl_supply 供应表mtl_demand 需求表mtl_parameters 组织参数cst_item_costs物料成本cst_cost_types成本类型MTL_SERIAL_NUMBERS序列号MTL_MATERIAL_STATUSES_TL序列号状态MFG_LOOKUPS序列号状态（SERIAL_NUM_STATUS）------------------------------------------------------------------------------------------------------------------------hr_organization_units 组织及库存组织视图hz_parties 客户表hz_relationships客户关系表HZ_PARTY_SITES 客户地点表HZ_LOCATIONS地点表hz_cust_accounts 客户账户表HZ_CUST_ACCT_SITES_ALL 客户地点账户表HZ_CUST_SITE_USES_ALL 客户地点业务目的表HZ_CUSTOMER_PROFILES 账户配置文件表HZ_CUST_PROFILE_AMTS 账户配置文件金额表HZ_CONTACT_POINTS联系方式表HZ_CODE_ASSIGNMENTS 客户的税表HZ_CUSTOMER_PROFILES 滞纳费用表---------------------------------------------------------------------------------------------wsh_trips 发运记录表wsh_trip_stops 发运停靠站记录表wsh_new_deliveries 交付记录wsh_delivery_legswsh_delivery_details 交付表wsh_delivery_assignments----------------------------------------------------------------------------------------mrp_sourcing_rules来源补充规则mrp_sr_receipt_orgmrp_sr_source_orgmrp_sr_assignmentsMRP_ASSIGNMENT_SETS来源规则分配集表po_approved_supplier_list批准的供应商列表PO_ASL_ATTRIBUTES批准的供应商列表属性-------------------------------------------------------------------------------------------------------------------------------------------------ENG_CHANGE_STATUSES_VL E CO状态pjm_seiban_numbers内外销标识表pa_projects_allmrp_designatorsDRP名称mrp_forecast_designators预测名称表mrp_forecast_dates预测表mrp_forecast_updates预测更改mrp_gross_requirements毛需求mrp_item_purchase_ordersMRP采购计划mrp_item_wip_entitiesMRP项目离散作业mrp_plans计划表mrp_recommendations计划建议mrp_workbench_bucket_datesMTL_SUPPLY_DEMAND_TEMP 物料供应需求-------------------------------------------------------------------------------------------------------------------------------------------MTL_TRANSACTION_FLOW_HEADERS公司间事务处理流mtl_transaction_flow_lines_v公司间事务处理流节点MTL_INTERCOMPANY_PARAMETERS_V 公司间关系QP_LIST_HEADERS_B价目表QP_LIST_HEADERS_TL价目表Qp_List_LinesQp_Pricing_Attributes--------------------------------------------------------------------------------------------------------------------------------------------------MTL_UNITS_OF_MEASURE单位MTL_UNITS_OF_MEASURE_TLMTL_UOM_CLASSES单位分类mtl_uom_classes_tlMTL_UOM_CONVERSIONS单位换算标准MTL_UOM_CLASS_CONVERSIONS单位换算分类间--------------------------------------------------------------------------------------------------------------------------------------------------AP_INVOICES_ALL 发票头AP_INVOICE_LINES_ALL 发票行xla_ae_headers 会计分录头xla_ae_lines 会计分录行--------------------------------------------------------------------------------------------------------------oe_system_parameters_allOM 系统参数ak_web_user_sec_attr_valuesORG_ACCT_PERIODS库存会计期间GL_PERIODS总账会计期间ZX_RATES_B税率代码ZX_PARTY_TAX_PROFILE供应商的税的配置文件xla_event_types_tlxla_event_classes_tl-------------------------------------------------------------------------------------------------------------------ap_suppliers 供应商头信息ap_supplier_sites_all 供应商地点信息hz_code_assignments 供应商税率zx_party_tax_profile 供应商税信息iby_ext_bank_accounts 供应商银行账号iby_ext_bank_branches_v 供应商银行支行iby_ext_banks_v 供应商银行iby_account_owners 银行账户的拥有者iby_pmt_instr_uses_all 银行账户所在的地点ap_supplier_contacts 供应商联系人hz_contact_points 供应商联系人电话等信息pos_supp_prof_ext_b 供应商地点附加信息iby_external_payees_all 供应商付款信息。

ebs 11i 订单相关表结构学习及销售到出仓所经历的表

1接口表：a)OE_HEADERS_IFACE_ALL：此表为多组织表，用于将销售订单头插入开放接口。

该表存储来自于其他子系统需要导入OM模块的订单头信息，该表导入时必须输入的字段/条件：ORDER_SOURCE_ID : Order source id 可选ORIG_SYS_DOCUMENT_REF: Original system document reference 必须ORDER_SOURCE : Order source 可选OPERATION_CODE : Operation code 必须ORDER_TYPE_ID : Order type id 可选ORDER_TYPE : Order type 可选RETURN_REASON_CODE : Return reason code 仅用于订单退回SALESREP_ID : Salesrep idPRICE_LIST_ID : Price list id 用于已经booking的订单PRICE_LIST : Price list 用于已经booking的订单example:insert into oe_headers_iface_all(ORDER_SOURCE_ID,orig_sys_document_ref,ORG_ID,order_type_id,PRICE_LIST_ID,TRANSACTIONAL_CURR_CODE,SOLD_TO_ORG_ID,SHIP_TO_ORG_ID,created_by,creation_date,last_updated_by,last_update_date,operation_code)select ooha.order_source_id,ooha.orig_sys_document_ref,_id,ooha.order_type_id,ooha.price_list_id,ooha.TRANSACTIONAL_CURR_CODE,ooha.SOLD_TO_ORG_ID,ooha.SHIP_TO_ORG_ID,ooha.created_by,ooha.creation_date,fnd_er_id,sysdate,p_operation_codefrom oe_order_headers_all oohawhere order_number=p_order_number;b)OE_LINES_IFACE_ALL此表为多组织表，用于将销售订单行插入开放接口。

oracle-EBS-表结构信息

EBS Form开发FAQ →Oracle EBS 11i 表结构BOM模块常用表结构表名: bom.bom_bill_of_materials说明: BOM清单父项目BILL_SEQUENCE_ID NUMBER 清单序号（关键字）ASSEMBLY_ITEM_ID NUMBER 装配件内码ORGANIZATION_ID NUMBER 组织代码ASSEMBLY_TYPE NUMBER 装配类别SPECFIIC_ASSEMBLY_COMMENT VARCHAR2(240) 注释（装配件状态P、R等）COMMON_ORGANIZATION_ID NUMBER 公共组织COMMON_BILL_SEQUENCE_ID NUMBER 公共序号COMMON_ASSEMBLY_ITEM_ID NUMBER 公共项目内码表名：bom.bom_inventory_components说明：BOM清单构成项目COMPONENT_SEQUENCE_ID NUMBER 构件序号BILL_SEQUENCE_ID NUMBER 清单序号OPERATION_SEQ_NUM NUMBER 操作序列号COMPONENT_ITEM_ID NUMBERITEM_NUM NUMBER 项目序列号COMPONENT_QUANTITY NUMBER 构件数量COMPONENT_YIELD_FACTOR NUMBER 产出因子EFFECTIVITY_DATE DATE 生效日期DISABLE_DATE DATE 失效日期CHANGE_NOTICE VARCHAR2(10) 更改注释(ECO更改号)PLANNING_FACTOR NUMBER 计划百分比QUANTITY_RELATED NUMBER 相关数量SO_BASIS NUMBEROPTIONAL NUMBER 是否可选(1.是;2.否)MUTUALLY_EXCLUSIVE_OPTIONS NUMBER 互斥标识(1.是;2.否)WIP_SUPPLY_TYPE NUMBER 车间供应类型(1.推式2.装配拉式3.操作拉式4.大量5.供应商6.虚拟)supply_subinventory 供应子库存supply_locator_id 供应货位IDBOM_ITEM_TYPE NUMBER 清单项目类型(1.模型2.选项类3.计划中4.标准) INCLUDE_ON_SHIP_DOCS NUMBER 包含在发运文档中(1.是;2.否) REQUIRED_FOR_REVENUE NUMBER 需要进款(1.是;2.否)REQUIRED_TO_SHIP NUMBER 需要发运(1.是;2.否)SHIPPING ALLOWED NUMBER 搬运允许(1.是;2.否)INCLUDE_IN_COST_ROLLUP NUMBER 计入成本累加中(1.是;2.否) CHECK_ATP NUMBER ATP检查(1.是;2.否)表名：bom.bom_assembly_comments说明：装配件状态表BILL_SEQUENCE_ID NUMBER 清单序号STANDARD_REMARKS_DESIGNATOR VARCHAR2(10) 状态标志(R,P,D_R 等)表名: bom.bom_standard_comments说明: 标准注释表(状态说明表)COMMENT_CODE VARCHAR2(10) 注释代码(状态代码) ORGANIZATION_ID NUMBER 组织代码COMMENT_TEXT VARCHAR2(240) 注释说明(状态说明)表名: bom.bom_calendars说明: 日历种类表CALENDAR_CODE VARCHAR2(10) 日历代码QUARTERLY_CALENDAR_TYPE NUMBER 季度日历类型CALENDAR_START_DATE DATE 日历启用日期CALENDAR_END_DATE DATE 日历截止日期DESCRIPTION VARCHAR2(240) 描述表名: bom.bom_calendar_dates说明: 工作日历表CALENDAR_CODE VARCAHR2(10) 日历代码PRIOR_DATE DATE 前一天CALENDAR_DATE DATE 当日(当与前,后日期均相同时为工作日) NEXT_DATE DATE 后一天PRIOR_SEQ_NUM NUMBER 前一天序列号SEQ_NUM NUMBER 当日序序列号(非工作日为空)NEXT_SEQ_NUM NUMBER 后一天序列号EXCEPTION_SET_ID NUMBER 例外集代码表名: bom.bom_calendar_exceptions说明: 日历例外信息CALENDAR_CODE VARCHAR2(10) 日历代码EXCEPTION_SET_ID NUMBER 例外集代码EXCEPTION_DATE DATE 例外日期EXCEPTION_TYPE NUBMER 例外类别表名: bom.bom_calendar_shifts说明: 倒班表CALENDAR_CODE VARCAHR2(10) 日历代码SHIFT_NUM NUMBER 班次DESCRIPTION VARCHAR2(240) 描述表名: bom.bom_shift_dates说明: 轮班表CALENDAR_CODE VARCHAR2(10) 日历代码EXCEPTION_SET_ID NUMBER 例外集代码SHIFT_NUM NUMBER 倒班序号SHIFT_DATE DATE 倒班日期SEQ_NUM NUMBER 倒班序号NEXT_SEQ_NUM NUMBER 下一班序号PRIOR_SEQ_NUM NUMBER 上一班序号NEXT_DATE DATE 下一次倒班日期PRIOR_DATE DATE 上一次倒班日期表名: bom.bom_cal_week_start_dates说明: 星期开始日期CALENDAR_CODE VARCHAR2(10) 日历代码EXCEPTION_SET_ID NUMBER 例外集代码SEQ_NUM NUMBER 序号WEEK_START_DATE DATE 周开始日期PRIOR_DATE DATE 上周开始日期NEXT_DATE DATE 下周开始日期表名: bom.bom_period_start_dates说明: 周期开始日期CALENDAR_CODE VARCHAR2(10) 日历代码EXCEPTION_SET_ID NUMBER 例外集代码PERIOD_START_DATE DATE 周期开始日期PERIOD_SEQUENCE_NUM NUMBER 周期序号PERIOD_NAME VARCHAR2(3) 周期名称(月的三位英文缩写) NEXT_DATE DATE 下一周期开始日期PRIOR_DATE DATE 上一周期开始日期表名: bom.bom_workday_patterns说明: 工作日模式表CALENDAR_CODE VARCHAR2(10) 日历代码SHIFT_NUM NUMBER 班次SEQ_NUM NUMBER 模式序号DAYS_ON NUMBER 工作天数DAYS_OFF NUMBER 非工作天数DESCRIPTION VARCHAR2(240) 描述(大周/小周)表名: bom.bom_exception_sets说明: BOM例外集表EXCEPTION_SET_ID NUMBER 例外集代码EXCEPTION_SET_NAME VARCHAR2(10) 例外集名称DESCRIPTION VARCHAR2(240) 描述表内容:1 主要主要例外集2 HW_WDCES 华为日历异常集3 MBC_WDCES 莫贝克日历异常集-1 虚拟10SC 兼容的空数据表名：bom.cst_item_costs说明：项目成本表ORGANIZATION_ID NUMBER 组织代码INVENTORY_ITEM_ID NUMBER 项目内码COST_TYPE_ID NUMBER 成本类型ITEM_COST NUMBER 项目成本MATERIAL_COST NUMBER 物料成本RESOURCE_COST NUMBER 资源成本UNBURDENDED_COST NUMBER 不分摊成本BURDEN_COST NUMBER 分摊成本INVENTORY_ASSET_FLAG NUMBER 资产项目LOT_SIZE NUMBER 批量大小BASED_ON_ROLLUP_FLAG NUMBERSHRINKAGE_RATE NUMBER 收缩比例DEFAULTED_FLAG NUMBER表名: bom.cst_cost_types说明: 成本类型表COST_TYPE_ID NUMBER 成本类型代码COST_TYPE VARCHAR2(10) 成本类型DESCRIPTION VARCHAR2(240) 说明COSTING_METHOD_TYPE NUMBER 成本合计方法代码(1.2.) DISABLE_DATE DATE 失效日期本表内容如下:COST_TYPE COST_TYPE_ID DESCRIPTION冻结1 冻结标准成本类型平均2 平均成本类型等待3 等待标准成本类型标准成本1000 标准成本实际成本1001 实际成本新标准成本1002 新标准成本表名: bom.cst_item_cost_details说明: 项目成本明细表ORGANIZATION_ID NUMBER 组织代码INVENTORY_ITEM_ID NUMBER 项目内码ITEM_COST NUMBER 项目成本COST_TYPE_ID NUMBER 成本类型DEPARTMENT_ID NUMBER 部门代码COST_ELEMENT_ID NUMBER 成本要素类型代码LAST_UPDATE_DATE NUMBER 最后更新日期OPERATION_SEQUENCE_ID NUMBER 操作序列代码OPERATION_SEQ_NUM NUMBER 操作序列号LEVEL_TYPE NUMBER 级别类型RESOURCE_SEQ_NUM NUMBER 资源序列号RESOURCE_ID NUMBER 资源代码RESOURCE_RATE NUMBER 资源比率USAGE_RATE_OR_AMOUNT NUMBER 利用率或金额BASIS_TYPE NUMBER 基础类型BASIS_RESOURCE_ID NUMBER 基础资源代码BASIS_FACTOR NUMBER 基础因子NET_YIELD_OR_SHRINKAGE_FACTOR NUMBER 净产出或收缩比ROLLUP_SOURCE_TYPE NUMBER表名: bom.cst_cost_elements说明: 成本要素代码表COST_ELEMENT_ID NUMBER 成本要素代码COST_ELEMENT VARCHAR2(50) 成本要素说明内容:1 物料的2 物料制造费3 资源4 外部处理5 制造费表名: bom.cst_elemental_costs说明: 项目要素成本COST_UPDATE_ID NUMBER 成本更新代码ORGANIZATION_ID NUMBER 组织代码INVENTORY_ITEM_ID NUMBER 项目内码COST_ELEMENT_ID NUMBER 要素代码LAST_UPDATE_DATE DATE 最后更新日期STANDARD_COST NUMBER 标准成本表名: bom.cst_resource_costs说明: 资源成本RESOURCE_ID NUMBER 资源代码COST_TYPE_ID NUMBER 成本类型ORGANIZATION_ID NUMBER 组织代码RESOURCE_RATE NUMBER 资源费率表名: bom.cst_standard_costs说明: 项目标准成本表COST_UPDATE_ID NUMBER 成本更新代码INVENTORY_ITEM_ID NUMBER 项目内码ORGANIZATION_ID NUMBER 组织代码STANDARD_COST_REVISION_DATE DATE 标准成本版本日期STANDARD_COST NUMBER 标准成本INVENTORY_ADJUSTMENT_QUANTITY NUMBER 库存调节数量INVENTORY_ADJUSTMENT_VALUE NUMBER 库存调节价值INTRANSIT_ADJUSTMENT_QUANTITY NUMBER 在途调节数量INTRANSIT_ADJUSTMENT_VALUE NUMBER 在途调节价值WIP_ADJUSTMENT_QUANTITY NUMBER 在制调节数量WIP_ADJUSTMENT_VALUE NUMBER 在制调节价值表名: bom.cst_std_cost_adj_values说明: 标准成本调节表COST_UPDATE_ID NUMBER 成本更新代码ORGANIZATION_ID NUMBER 组织代码TRANSACTION_TYPE NUMBER 交易类型ADJUSTMENT_QUANTITY NUMBER 调节数量OLD_UNIT_COST NUMBER 老的单位成本NEW_UNIT_COST NUMBER 新的单位成本COST_ELEMENT_ID NUMBER 成本元素代码LEVEL_TYPE NUMBER 级别类型IN_OUT_FLAG NUMBER 出入标志RESOURCE_ID NUMBER 资源代码INVENTORY_ITEM_ID NUMBER 项目内码SUBINVENTORY VARCHAR2(10) 子库WIP_ENTITY_ID NUMBER 离散作业代码OPERATION_SEQ_NUM NUMBER 工艺路线操作序号DEPARTMENT_ID NUMBER 部门代码RESOURCE_SEQ_ID NUMBER 资源序号代码RESOURCE_SEQ_NUM NUMBER 资源序号STANDARD_RATE_FLAG NUMBER 标准率TRANSACTION_ID NUMBER 交易代码BASIS_TYPE NUMBER 基本类型FROM_ORGANIZATION_ID NUMBER 从组织代码TO_ORGANIZATION_ID NUMBER 到组织代码表名: bom.bom_departments说明: 部门代码对应表DEPARTMENT_ID NUMBER 部门内码DEPARTMENT_CODE VARCHAR2(10) 部门代码ORGANIZATION_ID NUMBER 组织代码DESCRIPTION VARCHAR2(240) 说明(汉字说明的部门名称) DISABLE_DATE DATE 失效日期LOCATION_ID NUMBER 地点代码表名: bom.bom_resources说明: 资源代码对应表RESOURCE_ID NUMBER 资源内码RESOURCE_CODE VARCHAR2(10) 资源代码ORGANIZATION_ID NUMBER 组织代码DESCRIPTION VARCHAR2(240) 说明DISABLE_DATE DATE 失效日期COST_ELEMENT_ID NUMBER 成本要素代码PURCHASE_ITEM_ID NUMBER 购买项目代码COST_CODE_TYPE NUMBERFUNCTIONAL_CURRENCY_FLAG NUMBER 货币单位(1.是,2.否)UNIT_OF_MEASURE VARCHAR2(3) 单位DEFAULT_ACTIVITY_ID NUMBER 活动缺省值(1.运行,4.移动,5.排队)RESOURCE_TYPE NUMBER 资源类型(1.机器,2.人员,3.空间,4.杂项,5.数额)AUTOCHARGE_TYPE NUMBER 自动记帐类型(1.WIP移动,2.人工,3.PO接收,4.PO移动)STANDARD_RATE_FLAG NUMBER 标准费用率标志(1.否,2.是)DEFAULT_BASIS_TYPE NUMBER 基本类型缺省值(1.项目,2.批量)ABSORPTION_ACCOUNT NUMBER 分摊帐目ALLOW_COSTS_FLAG NUMBER 计算成本标志(1.否,2.是)RATE_VARIANCE_ACCOUNT NUMBER 差异帐目EXPENDITURE_TYPE VARCHAR2(30) 费用类型表名: bom.bom_operational_routings说明: 工艺路线ROUTING_SEQUENCE_ID NUMBER 路线序号ASSEMBLY_ITEM_ID NUMBER 项目内码ORGANIZATION_ID NUMBER 组织代码ALTERNATE_ROUTING_DESIGNATOR VARCHAR2(10) 替换工艺路线ROUTING_TYPE NUMBER 路线类别COMMON_ASSEMBLY_ITEM_ID NUMBER 公共装配件内码COMMON_ROUTING_SEQUENCE_ID NUMBER 公共路线序号ROUTING_COMMENT VARCHAR2(240) 路线注释COMPLETION_SUBINVENTORY VARCHAR2(10) 完工入库名称COMPLETION_LOCATOR_ID NUMBER 完工入库货位表名：bom.bom_operation_resources说明：工艺路线细节之资源表OPERATION_SEQUENCE_ID NUMBER 操作序列内码RESOURCE_SEQ_NUM NUMBER 资源序号RESOURCE_ID NUMBER 资源内码ACTIVITY_ID NUMBER 活动(1.运行,4.移动,5.排队)STANDARD_RATE_FLAG NUMBER 标准费用率标志(1.否,2.是)ASSIGNED_UNITS NUMBER 已分配单位USAGE_RATE_OR_AMOUNT NUMBER 利用率或金额USAGE_RATE_OR_AMOUNT_INVERSE NUMBER 利用率或金额倒数BASIS_TYPE NUMBER 基本类型SCHEDULE_FLAG NUMBER 计划标识RESOURCE_OFFSET_PERCENT NUMBER 偏差百分比AUTOCHARGE_TYPE NUMBER 自动记帐(1.WIP移动,2.人工,3.PO接收,4.PO移动)表名：bom.bom_operation_sequences说明：工艺路线细节之工艺工序表OPERATION_SEQUENCE_ID NUMBER 操作序号内码ROUTING_SEQUENCE_ID NUMBER 路线序号内码OPERATION_SEQ_NUM NUMBER 路线序列代码STANDARD_OPERATION_ID NUMBER 标准操作序号内码DEPARTMENT_ID NUMBER 部门内码OPERATION_LEAD_TIME_PERCENT NUMBER 提前期百分比MINIMUM_TRANSFER_QUANTITY NUMBER 最小传送批量COUNT_POINT_TYPE NUMBER 计数点(1.是–自动收费,2.否) OPERATION_DESCRIPTION VARCHAR2(240) 操作说明EFFECTIVITY_DATE DATE 生效日期DISABLE_DATE DATE 失效日期BACKFLUSH_FLAG NUMBER 倒冲库存标识(1.是,2.否) OPTION_DEPENDENT_FLAG NUMBER 可选工序(1.是,2.否) 表名: bom.bom_standard_operations说明: 标准操作表STANDARD_OPERATION_ID NUMBER 标准操作标识码OPERATION_CODE VARCHAR2(4) 操作代码ORGANIZATION_ID NUMBER 组织代码DEPARTMENT_ID NUMBER 部门代码MINIMUM_TRANSFER_QUANTITY NUMBER 最小传送数量COUNT_POINT_TYPE NUMBER 计数点(1.是–自动收费,2.否) OPERATION_DESCRIPTION VARCHAR2(240) 操作说明OPTION_DEPENDENT_FLAG NUMBER 可选工序(1.是,2.否)表名: bom.bom_std_op_resources说明: 标准操作资源表STANDARD_OPERATION_ID NUMBER 标准操作标识码RESOURCE_ID NUMBER 资源标识码ACTIVITY_ID NUMBER 活动(1.运行,4.移动,5.排队)RESOURCE_SEQ_NUM NUMBER 资源序号USAGE_RATE_OR_AMOUNT NUMBER 利用率或金额USAGE_RATE_OR_AMOUNT_INVERSE NUMBER 利用率或金额倒数BASIS_TYPE NUMBER 基本类型(1.项目,2.批量)AUTOCHARGE_TYPE NUMBER 自动记帐(1.WIP移动,2.人工,3.PO接收,4.PO移动)STANDARD_RATE_FLAG NUMBER 标准费用率标志(1.否,2.是) ASSIGNED_UNITS NUMBER 已分配单位表名: bom.bom_substitute_components说明: BOM替代件表SUBSTITUTE_COMPONENT_ID NUMBER 替代构成件代码SUBSTITUTE_ITEM_QUANTITY NUMBER 替代项目数量COMPONENT_SEQUENCE_ID NUMBER 组件序号ACD_TYPE NUMBERCHANGE_NOTICE VARCHAR2(10) 更改单表名: bom.cst_std_cost_adj_values说明: 标准成本调节表COST_UPDATE_ID NUMBER 成本更新代码ORGANIZATION_ID NUMBER 组织代码TRANSACTION_TYPE NUMBER 交易类型ADJUSTMENT_QUANTITY NUMBER 调节数量OLD_UNIT_COST NUMBER 老的单位成本NEW_UNIT_COST NUMBER 新的单位成本COST_ELEMENT_ID NUMBER 成本元素代码LEVEL_TYPE NUMBER 级别类型IN_OUT_FLAG NUMBER 出入标志RESOURCE_ID NUMBER 资源代码INVENTORY_ITEM_ID NUMBER 项目内码SUBINVENTORY VARCHAR2(10) 子库WIP_ENTITY_ID NUMBER 离散作业代码OPERATION_SEQ_NUM NUMBER 工艺路线操作序号DEPARTMENT_ID NUMBER 部门代码RESOURCE_SEQ_ID NUMBER 资源序号代码RESOURCE_SEQ_NUM NUMBER 资源序号STANDARD_RATE_FLAG NUMBER 标准率TRANSACTION_ID NUMBER 交易代码BASIS_TYPE NUMBER 基本类型FROM_ORGANIZATION_ID NUMBER 从组织代码TO_ORGANIZATION_ID NUMBER 到组织代码表名: bom.bom_departments说明: 部门代码对应表DEPARTMENT_ID NUMBER 部门内码DEPARTMENT_CODE VARCHAR2(10) 部门代码ORGANIZATION_ID NUMBER 组织代码DESCRIPTION VARCHAR2(240) 说明(汉字说明的部门名称) DISABLE_DATE DATE 失效日期LOCATION_ID NUMBER 地点代码表名: bom.bom_resources说明: 资源代码对应表RESOURCE_ID NUMBER 资源内码RESOURCE_CODE VARCHAR2(10) 资源代码ORGANIZATION_ID NUMBER 组织代码DESCRIPTION VARCHAR2(240) 说明DISABLE_DATE DATE 失效日期COST_ELEMENT_ID NUMBER 成本要素代码PURCHASE_ITEM_ID NUMBER 购买项目代码COST_CODE_TYPE NUMBERFUNCTIONAL_CURRENCY_FLAG NUMBER 货币单位(1.是,2.否)UNIT_OF_MEASURE VARCHAR2(3) 单位DEFAULT_ACTIVITY_ID NUMBER 活动缺省值(1.运行,4.移动,5.排队)RESOURCE_TYPE NUMBER 资源类型(1.机器,2.人员,3.空间,4.杂项,5.数额)AUTOCHARGE_TYPE NUMBER 自动记帐类型(1.WIP移动,2.人工,3.PO接收,4.PO移动)STANDARD_RATE_FLAG NUMBER 标准费用率标志(1.否,2.是)DEFAULT_BASIS_TYPE NUMBER 基本类型缺省值(1.项目,2.批量)ABSORPTION_ACCOUNT NUMBER 分摊帐目ALLOW_COSTS_FLAG NUMBER 计算成本标志(1.否,2.是)RATE_VARIANCE_ACCOUNT NUMBER 差异帐目EXPENDITURE_TYPE VARCHAR2(30) 费用类型表名: bom.bom_operational_routings说明: 工艺路线ROUTING_SEQUENCE_ID NUMBER 路线序号ASSEMBLY_ITEM_ID NUMBER 项目内码ORGANIZATION_ID NUMBER 组织代码ALTERNATE_ROUTING_DESIGNATOR VARCHAR2(10) 替换工艺路线ROUTING_TYPE NUMBER 路线类别COMMON_ASSEMBLY_ITEM_ID NUMBER 公共装配件内码COMMON_ROUTING_SEQUENCE_ID NUMBER 公共路线序号ROUTING_COMMENT VARCHAR2(240) 路线注释COMPLETION_SUBINVENTORY VARCHAR2(10) 完工入库名称COMPLETION_LOCATOR_ID NUMBER 完工入库货位表名：bom.bom_operation_resources说明：工艺路线细节之资源表OPERATION_SEQUENCE_ID NUMBER 操作序列内码RESOURCE_SEQ_NUM NUMBER 资源序号RESOURCE_ID NUMBER 资源内码ACTIVITY_ID NUMBER 活动(1.运行,4.移动,5.排队) STANDARD_RATE_FLAG NUMBER 标准费用率标志(1.否,2.是) ASSIGNED_UNITS NUMBER 已分配单位USAGE_RATE_OR_AMOUNT NUMBER 利用率或金额USAGE_RATE_OR_AMOUNT_INVERSE NUMBER 利用率或金额倒数BASIS_TYPE NUMBER 基本类型SCHEDULE_FLAG NUMBER 计划标识RESOURCE_OFFSET_PERCENT NUMBER 偏差百分比AUTOCHARGE_TYPE NUMBER 自动记帐(1.WIP移动,2.人工,3.PO接收,4.PO移动)表名：bom.bom_operation_sequences说明：工艺路线细节之工艺工序表OPERATION_SEQUENCE_ID NUMBER 操作序号内码ROUTING_SEQUENCE_ID NUMBER 路线序号内码OPERATION_SEQ_NUM NUMBER 路线序列代码STANDARD_OPERATION_ID NUMBER 标准操作序号内码DEPARTMENT_ID NUMBER 部门内码OPERATION_LEAD_TIME_PERCENT NUMBER 提前期百分比MINIMUM_TRANSFER_QUANTITY NUMBER 最小传送批量COUNT_POINT_TYPE NUMBER 计数点(1.是–自动收费,2.否) OPERATION_DESCRIPTION VARCHAR2(240) 操作说明EFFECTIVITY_DATE DATE 生效日期DISABLE_DATE DATE 失效日期BACKFLUSH_FLAG NUMBER 倒冲库存标识(1.是,2.否) OPTION_DEPENDENT_FLAG NUMBER 可选工序(1.是,2.否)表名: bom.bom_standard_operations说明: 标准操作表STANDARD_OPERATION_ID NUMBER 标准操作标识码OPERATION_CODE VARCHAR2(4) 操作代码ORGANIZATION_ID NUMBER 组织代码DEPARTMENT_ID NUMBER 部门代码MINIMUM_TRANSFER_QUANTITY NUMBER 最小传送数量COUNT_POINT_TYPE NUMBER 计数点(1.是–自动收费,2.否) OPERATION_DESCRIPTION VARCHAR2(240) 操作说明OPTION_DEPENDENT_FLAG NUMBER 可选工序(1.是,2.否)表名: bom.bom_std_op_resources说明: 标准操作资源表STANDARD_OPERATION_ID NUMBER 标准操作标识码RESOURCE_ID NUMBER 资源标识码ACTIVITY_ID NUMBER 活动(1.运行,4.移动,5.排队) RESOURCE_SEQ_NUM NUMBER 资源序号USAGE_RATE_OR_AMOUNT NUMBER 利用率或金额USAGE_RATE_OR_AMOUNT_INVERSE NUMBER 利用率或金额倒数BASIS_TYPE NUMBER 基本类型(1.项目,2.批量)AUTOCHARGE_TYPE NUMBER 自动记帐(1.WIP移动,2.人工,3.PO接收,4.PO移动)STANDARD_RATE_FLAG NUMBER 标准费用率标志(1.否,2.是) ASSIGNED_UNITS NUMBER 已分配单位表名: bom.bom_substitute_components说明: BOM替代件表SUBSTITUTE_COMPONENT_ID NUMBER 替代构成件代码SUBSTITUTE_ITEM_QUANTITY NUMBER 替代项目数量COMPONENT_SEQUENCE_ID NUMBER 组件序号ACD_TYPE NUMBERCHANGE_NOTICE VARCHAR2(10) 更改单表名: bom.cst_std_cost_adj_values说明: 标准成本调节表COST_UPDATE_ID NUMBER 成本更新代码ORGANIZATION_ID NUMBER 组织代码TRANSACTION_TYPE NUMBER 交易类型ADJUSTMENT_QUANTITY NUMBER 调节数量OLD_UNIT_COST NUMBER 老的单位成本NEW_UNIT_COST NUMBER 新的单位成本COST_ELEMENT_ID NUMBER 成本元素代码LEVEL_TYPE NUMBER 级别类型IN_OUT_FLAG NUMBER 出入标志RESOURCE_ID NUMBER 资源代码INVENTORY_ITEM_ID NUMBER 项目内码SUBINVENTORY VARCHAR2(10) 子库WIP_ENTITY_ID NUMBER 离散作业代码OPERATION_SEQ_NUM NUMBER 工艺路线操作序号DEPARTMENT_ID NUMBER 部门代码RESOURCE_SEQ_ID NUMBER 资源序号代码RESOURCE_SEQ_NUM NUMBER 资源序号STANDARD_RATE_FLAG NUMBER 标准率TRANSACTION_ID NUMBER 交易代码BASIS_TYPE NUMBER 基本类型FROM_ORGANIZATION_ID NUMBER 从组织代码TO_ORGANIZATION_ID NUMBER 到组织代码表名: bom.bom_departments说明: 部门代码对应表DEPARTMENT_ID NUMBER 部门内码DEPARTMENT_CODE VARCHAR2(10) 部门代码ORGANIZATION_ID NUMBER 组织代码DESCRIPTION VARCHAR2(240) 说明(汉字说明的部门名称) DISABLE_DATE DATE 失效日期LOCATION_ID NUMBER 地点代码表名: bom.bom_resources说明: 资源代码对应表RESOURCE_ID NUMBER 资源内码RESOURCE_CODE VARCHAR2(10) 资源代码ORGANIZATION_ID NUMBER 组织代码DESCRIPTION VARCHAR2(240) 说明DISABLE_DATE DATE 失效日期COST_ELEMENT_ID NUMBER 成本要素代码PURCHASE_ITEM_ID NUMBER 购买项目代码COST_CODE_TYPE NUMBERFUNCTIONAL_CURRENCY_FLAG NUMBER 货币单位(1.是,2.否)UNIT_OF_MEASURE VARCHAR2(3) 单位DEFAULT_ACTIVITY_ID NUMBER 活动缺省值(1.运行,4.移动,5.排队)RESOURCE_TYPE NUMBER 资源类型(1.机器,2.人员,3.空间,4.杂项,5.数额)AUTOCHARGE_TYPE NUMBER 自动记帐类型(1.WIP移动,2.人工,3.PO接收,4.PO移动)STANDARD_RATE_FLAG NUMBER 标准费用率标志(1.否,2.是)DEFAULT_BASIS_TYPE NUMBER 基本类型缺省值(1.项目,2.批量)ABSORPTION_ACCOUNT NUMBER 分摊帐目ALLOW_COSTS_FLAG NUMBER 计算成本标志(1.否,2.是) RATE_VARIANCE_ACCOUNT NUMBER 差异帐目EXPENDITURE_TYPE VARCHAR2(30) 费用类型表名: bom.bom_operational_routings说明: 工艺路线ROUTING_SEQUENCE_ID NUMBER 路线序号ASSEMBLY_ITEM_ID NUMBER 项目内码ORGANIZATION_ID NUMBER 组织代码ALTERNATE_ROUTING_DESIGNATOR VARCHAR2(10) 替换工艺路线ROUTING_TYPE NUMBER 路线类别COMMON_ASSEMBLY_ITEM_ID NUMBER 公共装配件内码COMMON_ROUTING_SEQUENCE_ID NUMBER 公共路线序号ROUTING_COMMENT VARCHAR2(240) 路线注释COMPLETION_SUBINVENTORY VARCHAR2(10) 完工入库名称COMPLETION_LOCATOR_ID NUMBER 完工入库货位表名：bom.bom_operation_resources说明：工艺路线细节之资源表OPERATION_SEQUENCE_ID NUMBER 操作序列内码RESOURCE_SEQ_NUM NUMBER 资源序号RESOURCE_ID NUMBER 资源内码ACTIVITY_ID NUMBER 活动(1.运行,4.移动,5.排队) STANDARD_RATE_FLAG NUMBER 标准费用率标志(1.否,2.是) ASSIGNED_UNITS NUMBER 已分配单位USAGE_RATE_OR_AMOUNT NUMBER 利用率或金额USAGE_RATE_OR_AMOUNT_INVERSE NUMBER 利用率或金额倒数BASIS_TYPE NUMBER 基本类型SCHEDULE_FLAG NUMBER 计划标识RESOURCE_OFFSET_PERCENT NUMBER 偏差百分比AUTOCHARGE_TYPE NUMBER 自动记帐(1.WIP移动,2.人工,3.PO接收,4.PO移动)表名：bom.bom_operation_sequences说明：工艺路线细节之工艺工序表OPERATION_SEQUENCE_ID NUMBER 操作序号内码ROUTING_SEQUENCE_ID NUMBER 路线序号内码OPERATION_SEQ_NUM NUMBER 路线序列代码STANDARD_OPERATION_ID NUMBER 标准操作序号内码DEPARTMENT_ID NUMBER 部门内码OPERATION_LEAD_TIME_PERCENT NUMBER 提前期百分比MINIMUM_TRANSFER_QUANTITY NUMBER 最小传送批量COUNT_POINT_TYPE NUMBER 计数点(1.是–自动收费,2.否) OPERATION_DESCRIPTION VARCHAR2(240) 操作说明EFFECTIVITY_DATE DATE 生效日期DISABLE_DATE DATE 失效日期BACKFLUSH_FLAG NUMBER 倒冲库存标识(1.是,2.否) OPTION_DEPENDENT_FLAG NUMBER 可选工序(1.是,2.否)表名: bom.bom_standard_operations说明: 标准操作表STANDARD_OPERATION_ID NUMBER 标准操作标识码OPERATION_CODE VARCHAR2(4) 操作代码ORGANIZATION_ID NUMBER 组织代码DEPARTMENT_ID NUMBER 部门代码MINIMUM_TRANSFER_QUANTITY NUMBER 最小传送数量COUNT_POINT_TYPE NUMBER 计数点(1.是–自动收费,2.否) OPERATION_DESCRIPTION VARCHAR2(240) 操作说明OPTION_DEPENDENT_FLAG NUMBER 可选工序(1.是,2.否)表名: bom.bom_std_op_resources说明: 标准操作资源表STANDARD_OPERATION_ID NUMBER 标准操作标识码RESOURCE_ID NUMBER 资源标识码ACTIVITY_ID NUMBER 活动(1.运行,4.移动,5.排队) RESOURCE_SEQ_NUM NUMBER 资源序号USAGE_RATE_OR_AMOUNT NUMBER 利用率或金额USAGE_RATE_OR_AMOUNT_INVERSE NUMBER 利用率或金额倒数BASIS_TYPE NUMBER 基本类型(1.项目,2.批量)AUTOCHARGE_TYPE NUMBER 自动记帐(1.WIP移动,2.人工,3.PO接收,4.PO移动)STANDARD_RATE_FLAG NUMBER 标准费用率标志(1.否,2.是) ASSIGNED_UNITS NUMBER 已分配单位表名: bom.bom_substitute_components说明: BOM替代件表SUBSTITUTE_COMPONENT_ID NUMBER 替代构成件代码SUBSTITUTE_ITEM_QUANTITY NUMBER 替代项目数量COMPONENT_SEQUENCE_ID NUMBER 组件序号ACD_TYPE NUMBERCHANGE_NOTICE VARCHAR2(10) 更改单PO模块常用表结构表名: po.po_requisition_headers_all说明: 采购请求REQUISITION_HEADER_ID NUMBER PR头标识码SEGMENT1 VARCHAR2(20) PR号ENABLE_FLAG VARCHAR2(1) 使能标志(Y/N)AUTHORIZATION_STATUS VARCHAR2(25) 批准标志(APPROVED/) TYPE_LOOKUP_CODE VARCHAR2(25) 类型(PURCHASE) REQUIST_ID NUMBER 请求标识码CANCEL_FLAG VARCHAR2(1) 取消标志(Y/N)TRANSFERRED_TO_OE_FLAG VARCHAR2(1) 可否转入OE标志(Y/N)PREPARER_ID NUMBER 准备人ID(可与HR.PER_PEOPLE_F.PERSON_ID关联）表名: po.po_requisition_lines_all说明: 采购请求明细REQUISITION_LINE_ID NUMBER PR行IDREQUISITION_HEADER_ID NUMBER PR头IDLINE_NUM NUMBER 栏目LINE_TYPE_ID NUMBER 行类别CATEGORY_ID NUMBER 归类标识码ITEM_DESCRIPTION VARCHAR2(240) 项目描述UNIT_MEAS_LOOKUP_CODE VARCHAR2(25) 单位UNIT_PRICE NUMBER 单价(已折为人民币)QUANTITY NUMBER 数量DELIVER_TO_LOCATION_ID NUMBER 交货位置码（与HR.HR_LOCATIONS.LOCATION_ID关联）TO_PERSON_ID NUMBER 收货人代码SOURCE_TYPE_CODE VARCHAR2(25) 来源类型ITEM_ID NUMBER 项目内码ITEM_REVISION VARCHAR2(3) 项目版本QUANTITY_DELIVERED NUMBER 已交付数量SUGGESTED_BUYER_ID NUMBER 建议采购员代码ENCUMBERED_FLAG VARCHAR2(1) 分摊标志RFQ_REQUIRED_FLAG VARCHAR2(1)NEED_BY_DATE DATE 需求日期(原始)LINE_LOCATION_ID NUMBER 定位行标识码(为空时表示未生成PO)MODIFIED_BY_AGENT_FLAG VARCHAR2(1) 被采购员更改标志（被拆分Y/NULL）PARENT_REQ_LINE_ID NUMBER 父PR行ID（由拆分而来的PR）NOTE_TO_AGENT VARCHAR2(100) 给采购员意见PURCHASING_AGENT_ID NUMBER 采购员标识码DOCUMENT_TYPE_CODE VARCHAR2(25) 文档类型BLANKET_PO_HEADER_ID NUMBER 一揽子订单头标识码BLANKET_PO_LINE_NUM NUMBER 一揽子订单栏目CURRENCY_CODE VARCHAR2(15) 币种RATE_TYPE VARCHAR2(30) 汇率类别RATE_DATE DATE 汇率日期RATE NUMBER 汇率CURRENCY_UNIT_PRICE NUMBER 本币单价SUGGESTED_VENDOR_NAME VARCHAR2(80) 建议供应商SUGGESTED_VENDOR_CONTACT VARCHAR2(80) 建议供应商联系方式SUGGESTED_VENDOR_PHONE VARCHAR2(20) 建议供应商电话UN_NUMBER_ID NUMBER 货期标识码（一般与货期天数同）HAZARD_CLASS_ID NUMBER 风险类别标识码MUST_USE_SUGG_VENDOR_FLAG VARCHAR2(1) 是否必须使用建议供应商REFERENCE_NUM VARCHAR2(25) 参考栏目ON_RFQ_FLAG VARCHAR2(1)URGENT_FLAG VARCHAR2(1) 紧急标志CANCEL_FLAG VARCHAR2(1) 取消标志SOURCE_ORGANIZATION_ID NUMBER 来源组织SOURCE_SUBINVENTORY VARCHAR2(10) 来源子库DESTINATION_TYPE_CODE VARCHAR2(25) 目标类型DESTINATION_ORGANIZATION_ID NUMBER 目标组织DESTINATION_SUBINVENTORY VARCHAR2(10) 目标子库QUANTITY_CANCELLED NUMBER 取消数量CANCEL_DATE DATE 取消日期CLOSED_CODE VARCHAR2(25) 关闭表名: po.po_lookup_codes说明: 检查代码LOOKUP_CODE VARCHAR2(25) 检查代码LOOKUP_TYPE VARCHAR2(30) 检查类型DISPLAYED_FIELD VARCHAR2(25) 显示字段DESCRIPTION VARCHAR2(80) 描述表名: po.po_lookup_types说明: 检查类型LOOKUP_TYPE VARCHAR2(30) 检查类型USER_UPDATABLE_FLAG VARCHAR2(1) 用户可否更改DESCRIPTION VARCHAR2(80) 描述表名: po.po_headers_all说明: 采购订单头PO_HEADER_ID NUMBER 订单头标识码AGENT_ID NUMBER(9) 采购员ID(与HR.PER_PEOPLE_F.PERSON_ID关联)TYPE_LOOKUP_CODE VARCHAR2(25) 类型(STANDARD,QUOTATION)SEGMENT1 VARCHAR2(20) 订单号SUMMARY_FLAG VARCHAR2(1) 汇总标志ENABLED_FLAG VARCHAR2(1) 使能标志VENDOR_ID NUMBER 供应商标识码VENDOR_SITE_ID NUMBER 供应商地址标识码VENDOR_CONTACT_ID NUMBER 供应商联系方式标识码SHIP_TO_LOCATION_ID NUMBER 发运地点标识码BILL_TO_LOCATION_ID NUMBER 付款地点标识码TERMS_ID NUMBER 条款标识码SHIP_VIA_LOOKUP_CODE VARCHAR2(25) 运输方式FOB_LOOKUP_CODE VARCHAR2(25) 口岸代码FREIGHT_TERMS_LOOKUP_CODE VARCHAR2(25) 运送条款STATUS_LOOKUP_CODE VARCHAR2(25) 状态CURRENCY_CODE VARCHAR2(15) 币种RATE_TYPE VARCHAR2(30) 汇率类型RATE_DATE DATE 汇率日期RATE NUMBER 汇率FROM_HEADER_ID NUMBER 来源订单头标识码FROM_TYPE_LOOKUP_CODE VARCHAR2(25) 来源检查类型START_DATE DATE 开始时间END_DATE DATE 结束时间BLANKET_TOTAL_AMOUNT NUMBER 一揽子订单总金额AUTHORIZATION_STATUS VARCHAR2(25) 审批状态REVISION_NUM NUMBER 版本号REVISED_DATE VARCHAR2(25) 修订日期APPROVED_FLAG VARCHAR2(1) 批准标志APPROVED_DATE DATE 批准日期AMOUNT_LIMIT NUMBER 金额限制MIN_RELEASE_AMOUNT NUMBER 最小金额NOTE_TO_AUTHORIZER VARCHAR2(240 对审批人的说明NOTE_TO_VENDOR VARCHAR2(240 对供应商的说明NOTE_TO_RECEIVER VARCHAR2(240 对接收者的说明PRINT_COUNT NUMBERPRINTED_DATE DATE 制单日期VENDOR_ORDER_NUM VARCHAR2(25)CONFIRMING_ORDER_FLAG VARCHAR2(1) 签返(确认)订单标志COMMENTS VARCHAR2(240 注释REPLY_DATE DATE 回复日期REPLY_METHOD_LOOKUP_CODE VARCHAR2(25) 回复方法检查代码RFQ_CLOSE_DATE DATEQUOTE_TYPE_LOOKUP_CODE VARCHAR2(25) 报价类型检查代码QUOTATION_CLASS_CODE VARCHAR2(25) 报价类代码QUOTE_WARNING_DELAY_UNIT VARCHAR2(25)QUOTE_WARNING_DELAY NUMBERQUOTE_VENDOR_QUOTE_NUMBER VARCHAR2(25) ACCEPTANCE_REQUIRED_FLAG VARCHAR2(1) 必须接受标志ACCEPTANCE_DUE_DATE DATE 接受截止日期CLOSED_DATE DATE 关闭日期USER_HOLD_FLAG VARCHAR2(1)APPROVAL_REQUIRED_FLAG VARCHAR2(1) 必须批准标志CANCEL_FLAG VARCHAR2(1) 取消标志FIRM_STATUS_LOOKUP_CODE VARCHAR2(30)FIRM_DATE DATEFROZEN_FLAG VARCHAR2(1) 冻结标志CLOSED_CODE VARCHAR2(25) 关闭USSGL_TRANSACTION_CODE VARCHAR2(30) GOVERNMENT_CONTEXT VARCHAR2(30)SUPPLY_AGREEMENT_FLAG VARCHAR2(1) 供应协议标志EDI_PROCESSED_FLAG VARCHAR2(1)EDI_PROCESSED_STATUS VARCHAR2(10)表名: po.po_lines_all说明: 采购订单行PO_LINE_ID NUMBER 行标识码PO_HEADER_ID NUMBER 订单头标识码LINE_TYPE_ID NUMBER 行类型LINE_NUM NUMBER 行栏目ITEM_ID NUMBER 项目内码ITEM_REVISION VARCHAR2(3) 项目版本CATEGORY_ID NUMBER 归类标识码ITEM_DESCRIPTION VARCHAR2(240) 项目描述UNIT_MEAS_LOOKUP_CODE VARCHAR2(25) 单位QUANTITY_COMMITTED NUMBER 提交数量COMMITTED_AMOUNT NUMBER 提交金额ALLOW_PRICE_OVERRIDE_FLAG VARCHAR2(1) 价格佣金允许NOT_TO_EXCEED_PRICE NUMBER 不允许超过价格LIST_PRICE_PER_UNIT NUMBERUNIT_PRICE NUMBER 单价QUANTITY NUMBER 数量UN_NUMBER_ID NUMBER 货期标识码HAZARD_CLASS_ID NUMBER 风险类别标识码NOTE_TO_VENDOR VARCHAR2(240) 对供应商的说明FROM_HEADER_ID NUMBER 来源订单头号FROM_LINE_ID NUMBER 来源行号MIN_ORDER_QUANTITY NUMBER 最小订单数量MAX_ORDER_QUANTITY NUMBER 最大订单数量QTY_RCV_TOLERANCE NUMBER 可接收数量OVER_TOLERANCE_ERROR_FLAG VARCHAR2(25) 超差示错标志MARKET_PRICE NUMBER 市价UNORDERED_FLAG VARCHAR2(1) 不定货标志CLOSED_FLAG VARCHAR2(1) 关闭标志USER_HOLD_FLAG VARCHAR2(1)CANCEL_FLAG VARCHAR2(1) 取消标志CANCELLED_BY NUMBER(9) 取消者CANCEL_DATE DATE 取消日期CANCEL_REASON VARCHAR2(240) 取消原因FIRM_STATUS_LOOKUP_CODE VARCHAR2(30)FIRM_DATE DATETAXABLE_FLAG VARCHAR2(1) 应税标志TAX_NAME VARCHAR2(15) 税种CAPITAL_EXPENSE_FLAG VARCHAR2(1) 大写金额标志NEGOTIATED_BY_PREPARER_FLAG VARCHAR2(1)CLOSED_DATE DATE 关闭日期CLOSED_REASON VARCHAR2(240) 关闭原因TRANSACTION_REASON_CODE VARCHAR2(25) 交易原因ATTRIBUTE10 VARCHAR2(150) 厂家ATTRIBUTE11 VARCHAR2(150) 型号表名: po.po_line_locations_all说明: 采购定位表LINE_LOCATION_ID NUMBER 行定位标识码PO_HEADER_ID NUMBER 订单头标识码PO_LINE_ID NUMBER 行标识码QUANTITY NUMBER 数量QUANTITY_RECEIVED NUMBER 接收数量QUANTITY_ACCEPTED NUMBER 接受数量QUANTITY_REJECTED NUMBER 拒绝数量QUANTITY_BILLED NUMBER 付款数量QUANTITY_CANCELLED NUMBER 取消数量QUANTITY_SHIPPED NUMBER 发运数量UNIT_MEAS_LOOKUP_CODE VARCHAR2(25) 单位PO_RELEASE_ID NUMBERSHIP_TO_LOCATION_ID NUMBER 送货位置SHIP_VIA_LOOKUP_CODE VARCHAR2(25) 运输方式NEED_BY_DATE DATE 要求到货日期PROMISED_DATE DATE 订约日期LAST_ACCEPT_DATE DATE 最后接受日期PRICE_OVERRIDE NUMBER 佣金价格ENCUMBERED_FLAG VARCHAR2(1) 负担标志ENCUMBERED_DATE DATE 负担日期UNENCUMBERED_QUANTITY NUMBERFOB_LOOKUP_CODE VARCHAR2(25) FREIGHT_TERMS_LOOKUP_CODE VARCHAR2(25) TAXABLE_FLAG VARCHAR2(1) 应税标志TAX_NAME VARCHAR2(15) 税种ESTIMATED_TAX_AMOUNT NUMBER 估计税金FROM_HEADER_ID NUMBER 从订单头号FROM_LINE_ID NUMBER 从订单行号FROM_LINE_LOCATION_ID NUMBER 从定位行号START_DATE DATE 开始日期END_DATE DATE 结束日期LEAD_TIME NUMBER 前导时间LEAD_TIME_UNIT VARCHAR2(25) 前导时间单位PRICE_DISCOUNT NUMBER 价格折扣TERMS_ID NUMBERAPPROVED_FLAG VARCHAR2(1) 批准标志APPROVED_DATE DATE 批准日期CLOSED_FLAG VARCHAR2(1) 关闭标志CANCEL_FLAG VARCHAR2(1) 取消标志CANCELLED_BY NUMBER(9) 被谁取消CANCEL_DATE DATE 取消日期CANCEL_REASON VARCHAR2(240) 取消原因FIRM_STATUS_LOOKUP_CODE VARCHAR2(25)FIRM_DATE DATEUNIT_OF_MEASURE_CLASS VARCHAR2(25) 单位ENCUMBER_NOW VARCHAR2(1)INSPECTION_REQUIRED_FLAG VARCHAR2(1) 必须检查标志RECEIPT_REQUIRED_FLAG VARCHAR2(1) 必须签收标志QTY_RCV_TOLERANCE NUMBER 接收差异数量QTY_RCV_EXCEPTION_CODE VARCHAR2(25) 接收例外代码ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2(25)ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2(1) 允许接收替代标志DAYS_EARLY_RECEIPT_ALLOWED NUMBER 可提前天数DAYS_LATE_RECEIPT_ALLOWED NUMBER 可推后天数RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2(25) 接收天数例外代码INVOICE_CLOSE_TOLERANCE NUMBERRECEIVE_CLOSE_TOLERANCE NUMBERSHIP_TO_ORGANIZATION_ID NUMBER 送货到组织代码SHIPMENT_NUM NUMBERSOURCE_SHIPMENT_ID NUMBER SHIPMENT_TYPE VARCHAR2(25) 送货方式CLOSED_CODE VARCHAR2(25) 关闭USSGL_TRANSACTION_CODE VARCHAR2(30) GOVERNMENT_CONTEXT VARCHAR2(30) RECEIVING_ROUTING_ID NUMBERACCRUE_ON_RECEIPT_FLAG VARCHAR2(1) CLOSED_REASON VARCHAR2(240) 关闭原因CLOSED_DATE DATE 关闭日期表名: po.po_un_numbers说明: 货期表UN_NUMBER_ID NUMBER 货期标识码UN_NUMBER VARCHAR2(25) 货期DESCRIPTION VARCHAR2(240) 说明表名: po.po_lines_all说明: 采购订单行PO_LINE_ID NUMBER 行标识码PO_HEADER_ID NUMBER 订单头标识码LINE_TYPE_ID NUMBER 行类型LINE_NUM NUMBER 行栏目ITEM_ID NUMBER 项目内码ITEM_REVISION VARCHAR2(3) 项目版本CATEGORY_ID NUMBER 归类标识码ITEM_DESCRIPTION VARCHAR2(240) 项目描述UNIT_MEAS_LOOKUP_CODE VARCHAR2(25) 单位QUANTITY_COMMITTED NUMBER 提交数量COMMITTED_AMOUNT NUMBER 提交金额ALLOW_PRICE_OVERRIDE_FLAG VARCHAR2(1) 价格佣金允许NOT_TO_EXCEED_PRICE NUMBER 不允许超过价格LIST_PRICE_PER_UNIT NUMBERUNIT_PRICE NUMBER 单价QUANTITY NUMBER 数量UN_NUMBER_ID NUMBER 货期标识码HAZARD_CLASS_ID NUMBER 风险类别标识码NOTE_TO_VENDOR VARCHAR2(240) 对供应商的说明FROM_HEADER_ID NUMBER 来源订单头号FROM_LINE_ID NUMBER 来源行号MIN_ORDER_QUANTITY NUMBER 最小订单数量MAX_ORDER_QUANTITY NUMBER 最大订单数量QTY_RCV_TOLERANCE NUMBER 可接收数量OVER_TOLERANCE_ERROR_FLAG VARCHAR2(25) 超差示错标志MARKET_PRICE NUMBER 市价UNORDERED_FLAG VARCHAR2(1) 不定货标志CLOSED_FLAG VARCHAR2(1) 关闭标志USER_HOLD_FLAG VARCHAR2(1)CANCEL_FLAG VARCHAR2(1) 取消标志CANCELLED_BY NUMBER(9) 取消者CANCEL_DATE DATE 取消日期CANCEL_REASON VARCHAR2(240) 取消原因FIRM_STATUS_LOOKUP_CODE VARCHAR2(30)FIRM_DATE DATETAXABLE_FLAG VARCHAR2(1) 应税标志TAX_NAME VARCHAR2(15) 税种CAPITAL_EXPENSE_FLAG VARCHAR2(1) 大写金额标志NEGOTIATED_BY_PREPARER_FLAG VARCHAR2(1)CLOSED_DATE DATE 关闭日期。

Oracle EBS常用数据表

select TRANSACTION_TYPE，DESTINATION_TYPE_CODE from RCV_TRANSACTIONS
可以看出以下阶段：
A1.RECEIVE – RECEIVING
A2.ACCEPT – RECEIVING
A3.DELIERY – INVETORY(影响库存现有量)
STATUS APP表示核销 /UNAPP表示未核销
AMOUNT_APPLIED 匹配金额
注意:红冲收款报表时间跨月的问题；必须联查 AR_CASH_RECEIPTS_ALL和 AR_CASH_RECEIPT_HISTORY_ALL
AP
应付帐款(是我方人员按照供应商提供的纸张发票信息录入)UI 上的invoice
RA_CUSTOMER_TRX_LINES_ALL
LINE_ID 行号
INVENTORY_ITEM_ID 可以为空，比如非物料的服务，只在DESCRIPTION中出现 /税行
DESCRIPTION
QUANTITY_INVOICE 开票数量
LINE_TYPE 行类型 (一般/税)
EXTEND_PRICE 本行金额
资产类别
FA_CATEGORIES
资产帐簿
FA_BOOK_CONTROLS 和会计帐簿有什么关系？
FA_BOOKS
UI中的Inquiry
Mothed是折旧方法(直线法/产量法)
FA_DISTRIBUTION_HISTORY分配assignment，给什么部门使用多少
LOCATION_ID 部门联查FA_LOCATIONS
现有量
汇总历史记录（正负合计）
Mtl_Material_Transactions

ORACLE 一对一执行 11i

数据表ORACLE一对一执行11iOracle一对一执行（Oracle One-to-One Fulfillment）系统为Oracle电子商务套件应用程序向客户发送资料、信函和对账单提供标准的解决方案。

Oracle一对一执行系统是一个集中的可伸缩机制，它使向客户发送跟进信息的过程自动化，减少了资料打包所消耗的时间和人工劳动。

通过与第三方产品Captaris RightFax集成，它支持以电子邮件形式发送文档和资料，并支持传真功能。

此外，它现在还实现了直接从用户的工作站打印个性化RTF或PDF文档的功能。

借助Oracle一对一执行系统发送的信息，典型的有个性化的财务报表和信函、个性化的服务请求信息或通用的销售资料包。

Oracle一对一执行系统是Oracle电子商务套件的一部分，后者是为协同工作而设计的应用程序集成套件。

高质量打印Oracle一对一执行系统现在提供了一个高质量的Oracle打印解决方案，使电子商务套件应用程序能够请求打印个性化的RTF和PDF格式文档和附信。

Oracle一对一执行系统继续支持通过Captaris RightFax打印文档和资料。

执行请求历史Oracle一对一执行系统的状态和历史屏幕显示关于已提交和已处理的请求的信息。

请求状态Oracle一对一执行系统能够暂停已部分执行的大量请求，稍后再继续处理。

此外，在处理过程中可以随时取消这些执行请求。

在暂停或取消的请求过程中的已处理的项目相关细节和统计信息可以通过请求历史（Request History）页面进行访问。

请求历史请求的特性和信息包括：电子邮件统计，例如请求中的条目数，已发送、已打开、未打开和未发送的条目数。

此外，Oracle一对一执行系统还可显示因无效的邮件地址而无法发送的条目数，接收到的返回邮件消息数以及选择拒收的收件人数。

对于那些因无效的电子邮件地址而无法发送的电子邮件，Oracle一对一执行系统允许修改电子邮件地址后重新处理。

oracle ebs 11i 数据表大全

OWNER OBJECT_NAMEOBJECT_TYPE CREATED AP AP_1096_DATA TABLE########## AP AP_1099_TAPE TABLE########## AP AP_ACCOUNTI TABLE########## AP AP_AE_HEADE TABLE########## AP AP_AE_LINES_TABLE##########TABLE########## AP AP_AGING_PERTABLE########## AP AP_AGING_PERTABLE########## AP AP_APPROVERTABLE########## AP AP_AUD_AUDITTABLE########## AP AP_AUD_AUDITAP AP_AUD_AUTO TABLE##########TABLE########## AP AP_AUD_QUEUAP AP_AUD_RULE TABLE########## AP AP_AUD_RULE TABLE##########TABLE########## AP AP_AUD_WORKTABLE########## AP AP_AWT_BUCKTABLE########## AP AP_AWT_GROUTABLE########## AP AP_AWT_GROUAP AP_AWT_TAX_TABLE##########TABLE########## AP AP_AWT_TEMPAP AP_BANK_ACC TABLE########## AP AP_BANK_ACC TABLE########## AP AP_BANK_BRA TABLE########## AP AP_BANK_CHA TABLE########## AP AP_BANK_CHA TABLE########## AP AP_BANK_TRA TABLE########## AP AP_BATCHES_TABLE########## AP AP_CARDS_AL TABLE##########TABLE########## AP AP_CARD_CODTABLE########## AP AP_CARD_CODTABLE########## AP AP_CARD_CURAP AP_CARD_GL_TABLE########## AP AP_CARD_GL_TABLE##########TABLE########## AP AP_CARD_PROTABLE########## AP AP_CARD_PROTABLE########## AP AP_CARD_PROTABLE########## AP AP_CARD_REQAP AP_CARD_SUP TABLE##########TABLE########## AP AP_CHECKRUNTABLE########## AP AP_CHECKRUNAP AP_CHECKS_A TABLE########## AP AP_CHECK_FO TABLE##########TABLE########## AP AP_CHECK_INTAP AP_CHECK_ST TABLE########## AP AP_CHECK_TR TABLE########## AP AP_CHRG_ALL TABLE########## AP AP_CHRG_ALL TABLE##########TABLE########## AP AP_CREDIT_CAAP AP_DISTRIBUT TABLE########## AP AP_DISTRIBUT TABLE########## AP AP_DOC_SEQUTABLE##########TABLE########## AP AP_DUPLICATEAP AP_ENCUMBRATABLE##########TABLE########## AP AP_ENCUMBRAAP AP_EXPENSE_TABLE########## AP AP_EXPENSE_TABLE########## AP AP_EXPENSE_TABLE########## AP AP_EXPENSE_TABLE########## AP AP_EXPENSE_TABLE##########TABLE########## AP AP_FLEX_SEGMTABLE########## AP AP_HISTORY_CAP AP_HISTORY_I TABLE########## AP AP_HISTORY_I TABLE##########TABLE########## AP AP_HOLDS_ALLTABLE########## AP AP_HOLD_CODTABLE########## AP AP_INCOME_TATABLE########## AP AP_INCOME_TATABLE########## AP AP_INTEREST_TABLE########## AP AP_INTERFACETABLE########## AP AP_INTERFACEAP AP_INVOICES_TABLE########## AP AP_INVOICES_TABLE########## AP AP_INVOICE_D TABLE########## AP AP_INVOICE_K TABLE########## AP AP_INVOICE_LI TABLE########## AP AP_INVOICE_P TABLE########## AP AP_INVOICE_P TABLE########## AP AP_INVOICE_R TABLE########## AP AP_INVOICE_T TABLE########## AP AP_INV_APRVL TABLE########## AP AP_INV_SELEC TABLE##########TABLE########## AP AP_LIABILITY_BAP AP_MATCHED_TABLE########## AP AP_MC_CHECKTABLE########## AP AP_MC_INVOIC TABLE########## AP AP_MC_INVOIC TABLE########## AP AP_MC_INVOIC TABLE########## AP AP_MC_PAYME TABLE##########TABLE########## AP AP_MRC_ACCOAP AP_MRC_AE_L TABLE########## AP AP_MRC_INQ_I TABLE########## AP AP_MRC_INQ_I TABLE##########TABLE########## AP AP_MRC_INQ_PTABLE########## AP AP_MRC_INQ_PAP AP_ORG_TEMPTABLE########## AP AP_OTHER_PE TABLE########## AP AP_OTHER_PE TABLE########## AP AP_PAYMENT_TABLE########## AP AP_PAYMENT_TABLE########## AP AP_PAYMENT_TABLE########## AP AP_PAYMENT_TABLE########## AP AP_PAYMENT_TABLE########## AP AP_PAYMENT_TABLE########## AP AP_PBATCH_S TABLE########## AP AP_PBATCH_S TABLE########## AP AP_POL_CAT_OTABLE########## AP AP_POL_CONT TABLE########## AP AP_POL_EXRA T ABLE##########AP AP_POL_HEAD TABLE##########TABLE########## AP AP_POL_ITEMIZAP AP_POL_LINES TABLE########## AP AP_POL_LINES TABLE########## AP AP_POL_LOCA TABLE########## AP AP_POL_LOCA TABLE########## AP AP_POL_SCHE TABLE########## AP AP_POL_SCHE TABLE########## AP AP_POL_VIOLA TABLE########## AP AP_POL_VIOLA TABLE##########TABLE########## AP AP_PURGE_INVTABLE########## AP AP_R115_UPGRAP AP_RECON_CHTABLE##########TABLE########## AP AP_RECON_DETABLE########## AP AP_RECON_DISTABLE########## AP AP_RECON_ERTABLE########## AP AP_RECON_ERAP AP_RECON_LO TABLE##########TABLE########## AP AP_RECON_RETABLE########## AP AP_RECON_RETABLE########## AP AP_RECON_SUAP AP_RECON_TR TABLE########## AP AP_RECURRIN T ABLE##########TABLE########## AP AP_REPORTINGTABLE########## AP AP_REPORTINGAP AP_SELECTED T ABLE########## AP AP_SELECTED T ABLE########## AP AP_SUPPLIER_TABLE########## AP AP_SYSTEM_P TABLE########## AP AP_TAX_CODE TABLE########## AP AP_TAX_DERIV TABLE########## AP AP_TAX_RECV TABLE########## AP AP_TAX_RECV TABLE########## AP AP_TEMP_APP TABLE##########TABLE########## AP AP_TERMS_LINAP AP_TERMS_TL TABLE########## AP AP_TOLERANC TABLE########## AP AP_TRANSMISSTABLE########## AP AP_TRIAL_BAL TABLE########## AP AP_TRIAL_BAL TABLE########## AP AP_VENDOR_A TABLE########## AP AP_VENDOR_K TABLE########## AP AP_WEB_DISC T ABLE########## AP AP_WEB_DISC T ABLE##########TABLE########## AP AP_WEB_EMPLTABLE########## AP AP_WEB_MANATABLE########## AP AP_WEB_PREFAP AP_WEB_SIGN TABLE##########TABLE########## AP AP_WEB_TEMPAP AP_WEB_VAT_TABLE########## AP AP_WHT_ITFTABLE##########TABLE########## AP FINANCIALS_PUAP FINANCIALS_SYTABLE########## AP JE_CH_PAYME TABLE##########AP JE_CZ_CONT_ATABLE##########TABLE########## AP JE_CZ_EFT_COTABLE########## AP JE_CZ_EFT_DAAP JE_DE_AP_BATTABLE########## AP JE_DE_CHECK TABLE########## AP JE_DK_EDI_TM TABLE########## AP JE_DK_PAY_CATABLE##########TABLE########## AP JE_FI_NUMBERAP JE_FR_DAS_01TABLE########## AP JE_FR_DAS_01TABLE########## AP JE_FR_DAS_02TABLE########## AP JE_FR_DAS_02TABLE########## AP JE_FR_DAS_21TABLE########## AP JE_FR_DAS_21TABLE########## AP JE_FR_DAS_30TABLE########## AP JE_FR_DAS_30TABLE########## AP JE_FR_DAS_31TABLE########## AP JE_FR_DAS_31TABLE########## AP JE_IT_EXEMPT TABLE########## AP JE_IT_EXEMPT TABLE##########TABLE########## AP JE_IT_EXLET_STABLE########## AP JE_IT_VAT_REGTABLE########## AP JE_IT_VAT_REGTABLE########## AP JE_IT_VAT_REGTABLE########## AP JE_IT_YEAR_EXAP JE_NL_EFT_BA TABLE##########TABLE########## AP JE_NL_EFT_COTABLE########## AP JE_NL_EFT_MEAP JE_NL_EFT_SP TABLE##########TABLE########## AP JE_NO_BANK_AAP JE_NO_BBS TABLE########## AP JE_NO_BBS_M T ABLE########## AP JE_NO_DATAD TABLE########## AP JE_NO_INVEST TABLE########## AP JE_NO_INVEST TABLE########## AP JE_NO_INVEST TABLE##########TABLE########## AP JE_NO_TELEPATABLE########## AP JE_NO_TELEPAAP JE_SE_EFT TABLE########## AP JG_ZZ_AP_BAL TABLE##########TABLE########## AP JG_ZZ_AP_IR_RAP JG_ZZ_AP_TMPTABLE##########TABLE########## AP JG_ZZ_AP_TMPTABLE########## AP JG_ZZ_AP_TMPTABLE########## AP JG_ZZ_INVOICETABLE########## AP JG_ZZ_JGZZVSTABLE########## AP JG_ZZ_PAY_FOTABLE########## AP JG_ZZ_PAY_SCTABLE########## AP JG_ZZ_SYS_FOTABLE########## AP JG_ZZ_SYS_FOTABLE########## AP JG_ZZ_VEND_SAP AP_DBI_LOG TABLE########## AP AP_CARD_EMP TABLE########## AP AP_CARD_DET TABLE##########TABLE########## AP AP_NO_MATCHTABLE########## AP AP_SUPPLIERSAP AP_SUPPLIER_TABLE########## AP AP_SUP_SITE_TABLE########## AP AP_NOTES TABLE########## AP AP_MAP_TYPE TABLE##########TABLE########## AP AP_MAP_CODEAP AP_CARD_PAR TABLE########## AP AP_MAP_TYPE TABLE########## AP AP_EXPENSE_TABLE########## AP AP_CCARD_ES TABLE########## AP AP_CACHE_OF TABLE########## AP AP_TRIAL_BAL TABLE########## AP AP_RETRO_RE TABLE########## AP AP_TEMP_APP TABLE########## AP AP_TOLERANC TABLE########## AP AP_MASS_ADD TABLE##########。

Oracle EBS常用表结构

目录1.BOM,Cost模块常用表结构 (2)1.1.常用表清单: (2)1.2.关键字段（参数） (2)1.3.开发参考(关键SQL) (8)2.PO模块常用表结构 (8)2.1.常用表清单: (8)2.2.关键字段（参数） (8)2.3.开发参考(关键SQL) (16)3.OE模块常用表结构 (17)3.1.常用表清单: (17)3.2.关键字段（参数） (18)3.3.开发参考(关键SQL) (23)4.INV模块常用表结构 (24)4.1.常用表清单: (24)4.2.关键字段（参数） (25)4.3.开发参考(关键SQL) (33)5.WIP模块常用表结构 (33)5.1.常用表清单: (33)5.2.关键字段（参数） (33)5.3.开发参考(关键SQL) (41)6.MRP模块常用表结构 (41)6.1.常用表清单: (41)6.2.关键字段（参数） (42)6.3.开发参考(关键SQL) (47)7.GL/FA模块常用表结构 (49)7.1.常用表清单: (49)7.2.关键字段（参数） (50)7.3.开发参考(关键SQL) (50)8.AR模块常用表结构 (51)8.1.常用表清单: (51)8.2.关键字段（参数） (51)8.3.开发参考(关键SQL) (51)9.AP模块常用表结构 (52)9.1.常用表清单: (52)9.2.关键字段（参数） (52)10.其它字典表 (52)10.1.常用表清单: (52)10.2.关键字段（参数） (53)10.3.开发参考(关键SQL) (53)11.OE模块常用表结构 (53)11.1.常用表清单: (53)11.2.关键字段（参数） (54)11.3.开发参考(关键SQL) (54)1. BOM,Cost模块常用表结构1.1.常用表清单:1.2.关键字段（参数）bom_bill_of_materials(BOM清单父项目):bom_inventory_components (BOM清单构成项目):cst_item_costs (项目成本表):cst_item_cost_details (项目成本明细表):cst_standard_costs (项目标准成本表):cst_std_cost_adj_values (标准成本调节表):bom_resources (资源代码对应表):bom_operational_routings (工艺路线):bom_operation_sequences(工艺路线细节之工艺工序表)bom_operation_resources(工艺路线细节之资源表)bom_standard_operations (标准操作表)1.3.开发参考(关键SQL)2.PO模块常用表结构2.1.常用表清单:2.2.关键字段（参数）po_requisition_headers_all (采购请求):po_requisition_lines_all (采购请求明细):po_headers_all (采购订单头)po_lines_all (采购订单行):po_line_locations_all (采购定位表):rcv_transactions(到货接收):說明﹕1. 接收100单位货物,放入“待质检”货位2. 接受/拒绝3. 库存/退回有三个不同的状态！例如：接收100个，80个接受入库，20个退回，那么有80个接受事务/20个退回事物select TRANSACTION_TYPE，DESTINATION_TYPE_CODE from RCV_TRANSACTIONS可以看出以下阶段：A1.RECEIVE – RECEIVINGA2.ACCEPT – RECEIVINGA3.DELIERY – INVETORY(影响库存现有量)如果按照正常模式，最后会触发产生MTL_MATERIAL_TRANSACTIONS2.3.开发参考(关键SQL)2.3.1 PO接收事物明细select /*+choose*/rt.parent_transaction_id,rt.transaction_id,rt.transaction_type,rt.transaction_date,rt.primary_quantity,rsl.item_id,anization_id,rt.vendor_id,rt.vendor_site_id,rt.location_id,rt.employee_id,pv.segment1,pv.vendor_name,ph.segment1,_id,ph.po_header_id,pl.po_line_id,pl.line_num,ph.ship_to_location_id,ph.agent_idfrom rcv_transactions rt,rcv_shipment_headers rsh,rcv_shipment_lines rsl,po_headers_all ph,po_lines_all pl,po_vendors pvwhere rt.shipment_line_id=rsl.shipment_line_idand rt.shipment_header_id=rsl.shipment_header_idand rsh.shipment_header_id = rsl.shipment_header_id and rsh.receipt_source_code = 'VENDOR'and ph.po_header_id = pl.po_header_idand rt.vendor_id = pv.vendor_idand rt.po_header_id = ph.po_header_idand rt.po_line_id=pl.po_line_id3.OE模块常用表结构3.1.常用表清单:数据表说明字段说明ra_addresses_all 地址(注﹕EBS 11i表不適合R12)输入客户名，带不出地址信息，是要修改：HZ_CUST_ACCT_SITES_ALL这个表的：ra_site_uses_all用户(注﹕EBS 11i表不適合R12) hz_cust_accounts 客戶信息表﹐關聯字段party_idhz_parties 客戶信息表﹐關聯字段party_idwsh_new_deliveries 发送表1wsh_delivery_details 发送表2wsh_delivery_assignments 发送表3oe_approver_lists OE审批组表oe_price_adjustments_v OE价格折扣wsh_lookups 送货状态表wsh_dlvb_dlvy_v 送货物视图oe_reasons_v OE版本更改原因3.2.关键字段（参数）oe_order_headers_all(订单头):字段说明HEADER_ID 订单头标识码ORG_ID OU IDORDER_TYPE_ID 订单类型IDORDER_NUMBER 订单编号ORDERED_DATE 定购日期REQUEST_DATE 客户要求发货日期DEMAND_CLASS_CODE 需求分类CodePRICE_LIST_ID 价目表IDTRANSACTIONAL_CURR_CODE 币种CUST_PO_NUMBER 合同号INVOICING_RULE_ID 开票规则IDACCOUNTING_RULE_ID 会计规则IDoe_order_lines_all(订单行):oe_transaction_types_all(订单类别表):mtl_txn_request_headers_v (完整的搬运单头信息):mtl_txn_request_lines_v (完整的搬运单行信息):3.3. 开发参考(关键SQL)3.3.1. OM 发运相关SQLselect wnd.attribute11 as LoadingData,wdd.delivery_detail_id,wdd.source_header_id,wdd.source_line_id,wdd.inventory_item_id,wdd.shipped_quantityfrom wsh_delivery_details wdd,wsh_delivery_assignments wda,wsh_new_deliveries wndwhere wdd.delivery_detail_id = wda.delivery_detail_id and wnd.delivery_id = wda.delivery_idand nvl(wnd.status_code,'OP') = 'CL'and wdd.source_header_id = 16256and nvl(wdd.shipped_quantity,0) > 0发运相关状态:select * from wsh_new_deliveries wnd (wnd.status_code='CL'表示送货完成,做了ship confirm) select * from wsh_delivery_assignments wdaselect * from wsh_delivery_details wdd (wdd.released_status='S'表示一步可以做MOVE_ORDER,'R'表示换没有挑库,'Y'表示已经进行了MOVE_ORDER,'c'表示已经做了ship confirm,同时lot_number﹐transaction_id和subinventory有值,)3.3.2. 得到订单的销售员select res.resource_namefrom oe_order_headers_all ooh,jtf_rs_salesreps jrs,jtf_rs_resource_extns_vl reswhere 1 = 1and jrs.salesrep_id(+) = ooh.salesrep_idand _id(+) = _idand jrs.resource_id = res.resource_id(+)and nvl(res.category, 'EMPLOYEE') IN('EMPLOYEE', 'OTHER', 'PARTY', 'PARTNER', 'SUPPLIER_CONTACT')4. INV模块常用表结构4.1.常用表清单:4.2.关键字段（参数）mtl_system_items (物料主表):mtl_item_attributes(项目属性字段说明):mtl_onhand_quantities(库存数据表):mtl_material_transactions(交易登记(出入库记录)表):mtl_transaction_types(交易类型代码表):mtl_supply (项目供给信息表):mtl_demand (项目需求信息表):mtl_onhand_quantities(库存数据表):4.3.开发参考(关键SQL)5.WIP模块常用表结构5.1.常用表清单:5.2.关键字段（参数）wip_accounting_classes(离散作业会计科目):wip_discrete_jobs(离散作业表):说明:wip_requirement_operations(任务令物料需求发放表):.wip_operations(离散作业操作表):wip_operation_resources(离散作业操作资源表):wip_transactions(离散作业交易表):wip_transaction_accounts(离散作业交易帐目):wip_move_transactions(离散作业工序移动交易):wip_so_allocations(分配表):wip_operation_resources(离散作业操作资源表):5.3.开发参考(关键SQL)5.3.1. WIP工单完工入库统计select sum(mmt.transaction_quantity) transaction_quantityfrom mtl_material_transactions mmt,wip_discrete_jobs_v wdjwhere 1 = 1and mmt.transaction_type_id in (44, 17)--wip completion, wip completion return and mmt.transaction_source_id = wdj.wip_entity_idand mmt.inventory_item_id = wdj.primary_item_idand mmt.inventory_item_id = :inventory_item_id ---主件Item6.MRP模块常用表结构6.1.常用表清单:6.2.关键字段（参数）mrp_assembly_operations(计划装配实施表):mrp_forecast_dates(预测表):mrp_forecast_updates (预测更改):mrp_gross_requirements (毛需求):mrp_item_purchase_orders(MRP采购计划):mrp_item_wip_entities(MRP项目离散作业):mrp_recommendations (计划建议(含例外信息):6.3.开发参考(关键SQL)6.3.1. 得到MRP结果中的采购建议行﹐是由哪些需求产生的select msi.inventory_item_id,msi.segment1,end_msi.segment1 end_segment1,end_mfp.inventory_item_id end_inventory_item_id,mfp.allocated_quantityfrom mrp_recommendations mr,mrp_full_pegging mfp,mrp_full_pegging end_mfp,mtl_system_items msi,mtl_system_items end_msiwhere mr.transaction_id = mfp.transaction_idand mfp.end_pegging_id = end_mfp.pegging_idand mr.transaction_id = 370185and mr.inventory_item_id = msi.inventory_item_idand anization_id = anization_idand end_mfp.inventory_item_id = end_msi.inventory_item_id and end_anization_id = end_anization_id6.3.2. end item 由一条毛需求,筛选出每个成品的需求明细需求insert into wst_ern_mrp_demands(organization_id,compile_designator,mrp_item_id,mrp_item,item_uom,lead_time,planner_code,min_order_qty,end_item_id,end_item,demand_id,demand_type,origination_type,using_assembly_item_id,transaction_id,pegging_id,prev_pegging_id,end_pegging_id,demand_date,allocated_quantity,ern_date,ern_qty,flag,make_or_buy)select anization_id, ---,organization_idpile_designator, ---,compile_designatormgr.inventory_item_id, ---,mrp_item_idwst_get_itemno_f(mgr.inventory_item_id,anization_id), ---,mrp_itemmsi.uom_code, ---,item_uomnvl(msi.preprocessing_lead_time, 0) +nvl(msi.postprocessing_lead_time, 0) +nvl(msi.full_lead_time, 0) +nvl(msi.cumulative_total_lead_time, 0) +nvl(msi.cum_manufacturing_lead_time, 0) +nvl(msi.fixed_lead_time, 0) +nvl(msi.variable_lead_time, 0), ---,lead_timemsi.planner_code, --- ,planner_codemsi.minimum_order_quantity, ---,min_order_qtyend_mfp.inventory_item_id , ---,end_item_idwst_get_itemno_f(end_mfp.inventory_item_id, end_anization_id), ---,end_item mgr.demand_id, --- ,demand_idmgr.demand_type, --- ,demand_typemgr.origination_type, --- ,origination_typeing_assembly_item_id, --- ,using_assembly_item_idmfp.transaction_id, --- ,transaction_idmfp.pegging_id, --- ,pegging_idmfp.prev_pegging_id, --- ,prev_pegging_idmfp.end_pegging_id, --- ,end_pegging_idmfp.demand_date, --- ,demand_datemfp.allocated_quantity, --- ,allocated_quantity,weh.release_date, --- ,ern_datewed.edr_release_qty, --- ,ern_qty0 , --- ,flagmsi.planning_make_buy_code --- ,make_or_buyfrom mrp_gross_requirements mgr,mrp_system_items msi,mrp_full_pegging mfp,mrp_full_pegging end_mfp,wst_ern_hdr weh,wst_ern_det wedwhere mgr.inventory_item_id = msi.inventory_item_idand anization_id = anization_idand mgr.demand_id = mfp.demand_idand mfp.end_pegging_id = end_mfp.pegging_idand pile_designator = pile_designatorand msi.planning_make_buy_code = 2and weh.ehr_number = wed.ehr_numberand _id = _idand mgr.inventory_item_id = ponent_item_idand end_mfp.inventory_item_id=weh.attribute2and anization_id = _idand mfp.inventory_item_id = ponent_item_idand pile_designator = 'WH-MRP-02'and mgr.demand_id = 287183select * from mrp_gross_requirements mgr where mgr.demand_id = 287183 select * from mrp_full_pegging mfg where mfg.demand_id = 287183select * from mrp_recommendations mrc7.GL/FA模块常用表结构7.1.常用表清单:7.2.关键字段（参数）gl_je_batches (GL凭证):gl_je_headers(日记账头信息):gl_je_batches (GL凭证):7.3.开发参考(关键SQL)。

OracleERP11i表结构

准备人ID(可与HR.PER_PEOPLE_F.PERSON_ID关联）
NUMBER NUMBER NUMBER NUMBER NUMBER VARCHAR2(240) VARCHAR2(25) NUMBER NUMBER NUMBER NUMBER VARCHAR2(25) NUMBER VARCHAR2(3) NUMBER NUMBER VARCHAR2(1) VARCHAR2(1) DATE NUMBER VARCHAR2(1) NUMBER VARCHAR2(100) NUMBER VARCHAR2(25) NUMBER NUMBER VARCHAR2(15) VARCHAR2(30) DATE NUMBER NUMBER VARCHAR2(80) VARCHAR2(80) VARCHAR2(20) NUMBER NUMBER VARCHAR2(1) VARCHAR2(25) VARCHAR2(1) VARCHAR2(1) VARCHAR2(1) NUMBER VARCHAR2(10) VARCHAR2(25) NUMBER VARCHAR2(10) NUMBER DATE VARCHAR2(25)
制单日期
签返(确认)订单标志注释回复日期回复方法检查代码
报价类型检查代码报价类代码
必须接受标志接受截止日期关闭日期
必须批准标志取消标志
冻结标志关闭
供应协议标志
行标识码订单头标识码行类型行栏目项目内码项目版本归类标识码
ITEM_DESCRIPTION UNIT_MEAS_LOOKUP_CODE QUANTITY_COMMITTED COMMITTED_AMOUNT ALLOW_PRICE_OVERRIDE_FLAG NOT_TO_EXCEED_PRICE LIST_PRICE_PER_UNIT UNIT_PRICE QUANTITY UN_NUMBER_ID HAZARD_CLASS_ID NOTE_TO_VENDOR FROM_HEADER_ID FROM_LINE_ID MIN_ORDER_QUANTITY MAX_ORDER_QUANTITY QTY_RCV_TOLERANCE OVER_TOLERANCE_ERROR_FLAG MARKET_PRICE UNORDERED_FLAG CLOSED_FLAG USER_HOLD_FLAG CANCEL_FLAG CANCELLED_BY CANCEL_DATE CANCEL_REASON FIRM_STATUS_LOOKUP_CODE FIRM_DATE TAXABLE_FLAG TAX_NAME CAPITAL_EXPENSE_FLAG NEGOTIATED_BY_PREPARER_FLAG CLOSED_DATE CLOSED_REASON TRANSACTION_REASON_CODE ATTRIBUTE10 ATTRIBUTE11 vendor_product_num

1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。

OWNER OBJECT_NAME OBJECT_TYPE CREATEDAR AR_ACTION_NOTIFICATIONS TABLE2004-6-11 21:42:11 AR AR_ADJUSTMENTS_ALL TABLE2004-6-11 21:42:11 AR AR_ADJUSTMENTS_REP_ITF TABLE2004-6-11 21:42:13 AR AR_AE_ALLOC_REC_GT TABLE2004-6-11 21:42:13 AR AR_AGING_BUCKETS TABLE2004-6-11 21:42:14 AR AR_AGING_BUCKET_LINES_B TABLE2004-6-11 21:42:15 AR AR_AGING_BUCKET_LINES_TL TABLE2004-6-11 21:42:16 AR AR_APPROVAL_ACTION_HISTORY TABLE2004-6-11 21:42:21 AR AR_APPROVAL_USER_LIMITS TABLE2004-6-11 21:42:21 AR AR_APP_RULES TABLE2004-6-11 21:42:22 AR AR_APP_RULE_DETAILS TABLE2004-6-11 21:42:23 AR AR_APP_RULE_SETS TABLE2004-6-11 21:42:24 AR AR_ARCHIVE_CONTROL TABLE2004-6-11 21:42:24 AR AR_ARCHIVE_CONTROL_DETAIL TABLE2004-6-11 21:42:25 AR AR_ARCHIVE_DETAIL TABLE2004-6-11 21:42:25 AR AR_ARCHIVE_HEADER TABLE2004-6-11 21:42:26 AR AR_ARCHIVE_PURGE_INTERIM TABLE2004-6-11 21:42:27 AR AR_ARCHIVE_PURGE_LOG TABLE2004-6-11 21:42:28 AR AR_AUDIT_DATA TABLE2004-6-11 21:42:28 AR AR_AUTOCASH_HIERARCHIES TABLE2004-6-11 21:42:29 AR AR_AUTOCASH_RULES TABLE2004-6-11 21:42:30 AR AR_AUTOREC_EXCEPTIONS TABLE2004-6-11 21:42:31 AR AR_BANK_DIRECTORY TABLE2004-6-11 21:42:32 AR AR_BATCHES_ALL TABLE2004-6-11 21:42:33 AR AR_BATCH_SOURCES_ALL TABLE2004-6-11 21:42:35 AR AR_BPA_AREA_ITEMS TABLE2004-6-11 21:42:36 AR AR_BPA_CONTENT_AREAS_B TABLE2004-6-11 21:42:37 AR AR_BPA_CONTENT_AREAS_TL TABLE2004-6-11 21:42:38 AR AR_BPA_DATA_SRC_PARAMS TABLE2004-6-11 21:42:41 AR AR_BPA_ITEMS_B TABLE2004-6-11 21:42:42 AR AR_BPA_ITEMS_TL TABLE2004-6-11 21:42:44 AR AR_BPA_RULES_B TABLE2004-6-11 21:42:45 AR AR_BPA_RULES_TL TABLE2004-6-11 21:42:46 AR AR_BPA_RULE_ATTRIBUTES_B TABLE2004-6-11 21:42:47 AR AR_BPA_RULE_ATTRIBUTES_TL TABLE2004-6-11 21:42:48 AR AR_BPA_RULE_TEMPLATES TABLE2004-6-11 21:42:49 AR AR_BPA_TEMPLATES_B TABLE2004-6-11 21:42:50 AR AR_BPA_TEMPLATES_TL TABLE2004-6-11 21:42:51 AR AR_BPA_URLS_B TABLE2004-6-11 21:42:52 AR AR_BPA_URLS_TL TABLE2004-6-11 21:42:53 AR AR_BPA_URL_PARAMS TABLE2004-6-11 21:42:54 AR AR_BR_FMT_TMP TABLE2004-6-11 21:42:55 AR AR_BR_STAMP_VALUES_ALL TABLE2004-6-11 21:42:56 AR AR_BR_STATUS_REP_ITF TABLE2004-6-11 21:42:56 AR AR_BR_STATUS_SUM_ITF TABLE2004-6-11 21:42:57 AR AR_BR_TRX_BATCH_RPT TABLE2004-6-11 21:42:58 AR AR_CALL_ACTIONS TABLE2004-6-11 21:42:59 AR AR_CASH_BASIS_DISTS_ALL TABLE2004-6-11 21:43:00 AR AR_CASH_RECEIPTS_ALL TABLE2004-6-11 21:43:01 AR AR_CASH_RECEIPT_HISTORY_ALL TABLE2004-6-11 21:43:03 AR AR_CHANGE_MATRIX TABLE2004-6-11 21:43:04 AR AR_CMGT_AUTO_RECOMMENDS TABLE2004-6-11 21:43:10 AR AR_CMGT_AUTO_RULES TABLE2004-6-11 21:43:11 AR AR_CMGT_AUTO_RULE_DTLS TABLE2004-6-11 21:43:12AR AR_CMGT_BANK_REF_ACCTS TABLE2004-6-11 21:43:13 AR AR_CMGT_BANK_REF_DATA TABLE2004-6-11 21:43:14 AR AR_CMGT_CASE_FOLDERS TABLE2004-6-11 21:43:16 AR AR_CMGT_CF_AGING_DTLS TABLE2004-6-11 21:43:17 AR AR_CMGT_CF_ANL_NOTES TABLE2004-6-11 21:43:18 AR AR_CMGT_CF_DNB_DTLS TABLE2004-6-11 21:43:20 AR AR_CMGT_CF_DTLS TABLE2004-6-11 21:43:21 AR AR_CMGT_CF_RECOMMENDS TABLE2004-6-11 21:43:22 AR AR_CMGT_CHECK_LISTS TABLE2004-6-11 21:43:23 AR AR_CMGT_CHECK_LIST_DTLS TABLE2004-6-11 21:43:24 AR AR_CMGT_COLLATERAL_DATA TABLE2004-6-11 21:43:26 AR AR_CMGT_CREDIT_REQUESTS TABLE2004-6-11 21:43:32 AR AR_CMGT_CURR_USAGE_GT TABLE2004-6-11 21:43:33 AR AR_CMGT_DATA_POINTS_B TABLE2004-6-11 21:43:34 AR AR_CMGT_DATA_POINTS_TL TABLE2004-6-11 21:43:35 AR AR_CMGT_DNB_ELEMENTS_B TABLE2004-6-11 21:43:37 AR AR_CMGT_DNB_ELEMENTS_TL TABLE2004-6-11 21:43:38 AR AR_CMGT_DNB_MAPPINGS TABLE2004-6-11 21:43:39 AR AR_CMGT_FINANCIAL_DATA TABLE2004-6-11 21:43:40 AR AR_CMGT_GUARANTOR_DATA TABLE2004-6-11 21:43:41 AR AR_CMGT_OTHER_DATA TABLE2004-6-11 21:43:42 AR AR_CMGT_SCORES TABLE2004-6-11 21:43:44 AR AR_CMGT_SCORE_DTLS TABLE2004-6-11 21:43:45 AR AR_CMGT_SCORE_WEIGHTS TABLE2004-6-11 21:43:46 AR AR_CMGT_SETUP_OPTIONS TABLE2004-6-11 21:43:56 AR AR_CMGT_TRADE_REF_DATA TABLE2004-6-11 21:43:56 AR AR_CM_SUM_TRX_DAYS_GT TABLE2004-6-11 21:43:57 AR AR_COLIND TABLE2004-6-11 21:43:57 AR AR_COLLECTION_INDICATORS_ALLTABLE2004-6-11 21:43:58 AR AR_COLLECTORS TABLE2004-6-11 21:43:59 AR AR_CONC_PROCESS_REQUESTS TABLE2004-6-11 21:44:00 AR AR_CONC_REQUEST_MESSAGES TABLE2004-6-11 21:44:01 AR AR_CONFIRMATION_ACTIONS TABLE2004-6-11 21:44:02 AR AR_CONS_INV_ALL TABLE2004-6-11 21:44:03 AR AR_CONS_INV_TRX_ALL TABLE2004-6-11 21:44:04 AR AR_CONS_INV_TRX_LINES_ALL TABLE2004-6-11 21:44:05 AR AR_CORRESPONDENCES_ALL TABLE2004-6-11 21:44:06 AR AR_CORR_PAY_SCHED_ALL TABLE2004-6-11 21:44:07 AR AR_CREDIT_HISTORIES TABLE2004-6-11 21:44:08 AR AR_CREDIT_MEMO_AMOUNTS TABLE2004-6-11 21:44:09 AR AR_CUSTOMER_ALT_NAMES TABLE2004-6-11 21:44:10 AR AR_CUSTOMER_BALANCE_ITF TABLE2004-6-11 21:44:10 AR AR_CUSTOMER_CALLS_ALL TABLE2004-6-11 21:44:11 AR AR_CUSTOMER_CALL_TOPICS_ALLTABLE2004-6-11 21:44:12 AR AR_CUSTOMER_PROFILES TABLE2004-6-11 21:44:15 AR AR_CUSTOMER_PROFILE_AMOUNTS T ABLE2004-6-11 21:44:22 AR AR_CUSTOMER_PROFILE_CLASSES TABLE2004-6-11 21:44:23 AR AR_CUST_PROF_CLASS_AMOUNTSTABLE2004-6-11 21:44:24 AR AR_CUST_SEARCH_GT TABLE2004-6-11 21:44:25 AR AR_DEBUG TABLE2004-6-11 21:44:26 AR AR_DISPUTE_HISTORY TABLE2004-6-11 21:44:26 AR AR_DISTRIBUTIONS_ALL TABLE2004-6-11 21:44:27 AR AR_DISTRIBUTION_SETS_ALL TABLE2004-6-11 21:44:28 AR AR_DISTRIBUTION_SET_LINES_ALLTABLE2004-6-11 21:44:29 AR AR_DOCUMENT_TRANSFERS TABLE2004-6-11 21:44:30AR AR_DOC_SEQUENCE_AUDIT TABLE2004-6-11 21:44:31 AR AR_DUNNING_LETTERS_B TABLE2004-6-11 21:44:32 AR AR_DUNNING_LETTERS_CUSTOM_TL TABLE2004-6-11 21:44:33 AR AR_DUNNING_LETTERS_TL TABLE2004-6-11 21:44:34 AR AR_DUNNING_LETTER_SETS TABLE2004-6-11 21:44:35 AR AR_DUNNING_LETTER_SET_LINES TABLE2004-6-11 21:44:36TABLE2004-6-11 21:44:44 AR AR_INTERIM_CASH_RCPT_LINES_ALLAR AR_INTERIM_CASH_RECEIPTS_ALLTABLE2004-6-11 21:44:45 AR AR_INTERIM_POSTING TABLE2004-6-11 21:44:47 AR AR_JOURNAL_INTERIM_ALL TABLE2004-6-11 21:44:48 AR AR_LOCATION_ACCOUNTS_ALL TABLE2004-6-11 21:44:49 AR AR_LOCATION_COMBINATIONS TABLE2004-6-11 21:44:50 AR AR_LOCATION_RATES TABLE2004-6-11 21:44:52 AR AR_LOCATION_VALUES TABLE2004-6-11 21:44:53 AR AR_LOCKBOXES_ALL TABLE2004-6-11 21:44:55 AR AR_MC_ADJUSTMENTS TABLE2004-6-11 21:44:56 AR AR_MC_BATCHES TABLE2004-6-11 21:45:05 AR AR_MC_CASH_BASIS_DISTS_ALL TABLE2004-6-11 21:45:05 AR AR_MC_CASH_RECEIPTS TABLE2004-6-11 21:45:06 AR AR_MC_CASH_RECEIPT_HIST TABLE2004-6-11 21:45:06 AR AR_MC_DISTRIBUTIONS_ALL TABLE2004-6-11 21:45:07 AR AR_MC_MISC_CASH_DISTS TABLE2004-6-11 21:45:09 AR AR_MC_PAYMENT_SCHEDULES TABLE2004-6-11 21:45:10 AR AR_MC_RATE_ADJUSTMENTS TABLE2004-6-11 21:45:11 AR AR_MC_RECEIVABLE_APPS TABLE2004-6-11 21:45:12 AR AR_MC_TRANSACTION_HISTORY TABLE2004-6-11 21:45:13 AR AR_MEMO_LINES_ALL_B TABLE2004-6-11 21:45:14 AR AR_MEMO_LINES_ALL_TL TABLE2004-6-11 21:45:16 AR AR_MISC_CASH_DISTRIBUTIONS_ALL TABLE2004-6-11 21:45:17 AR AR_MRC_CASH_HEADER TABLE2004-6-11 21:45:18 AR AR_MRC_CASH_LINES TABLE2004-6-11 21:45:19 AR AR_MRC_INQ_TRANS_BALANCES TABLE2004-6-11 21:45:20 AR AR_NOTES TABLE2004-6-11 21:45:21 AR AR_PAYMENTS_INTERFACE_ALL TABLE2004-6-11 21:45:28 AR AR_PAYMENT_SCHEDULES_ALL TABLE2004-6-11 21:45:29 AR AR_PERIODS TABLE2004-6-11 21:45:32 AR AR_PERIOD_TYPES TABLE2004-6-11 21:45:34 AR AR_POSTING_CONTROL TABLE2004-6-11 21:45:35 AR AR_POSTING_REPORT_INTERIM TABLE2004-6-11 21:45:36 AR AR_PURGE_OE_EXCEPTIONS TABLE2004-6-11 21:45:37 AR AR_PURGE_REC_AUX TABLE2004-6-11 21:45:38 AR AR_PURGE_TRX_AUX TABLE2004-6-11 21:45:38 AR AR_RAMC_AUDIT_TRAIL TABLE2004-6-11 21:45:39 AR AR_RATE_ADJUSTMENTS_ALL TABLE2004-6-11 21:45:40 AR AR_RECEIPTS_REP_ITF TABLE2004-6-11 21:45:41 AR AR_RECEIPT_CLASSES TABLE2004-6-11 21:45:42 AR AR_RECEIPT_METHODS TABLE2004-6-11 21:45:43TABLE2004-6-11 21:45:48 AR AR_RECEIPT_METHOD_ACCOUNTS_AAR AR_RECEIVABLES_TRX_ALL TABLE2004-6-11 21:45:49 AR AR_RECEIVABLE_APPLICATIONS_ALL TABLE2004-6-11 21:45:50 AR AR_REVENUE_ADJUSTMENTS_ALL TABLE2004-6-11 21:45:52 AR AR_SALES_TAX TABLE2004-6-11 21:45:55 AR AR_SALES_TAX_REP_ITF TABLE2004-6-11 21:45:56 AR AR_SELECTION_CRITERIA TABLE2004-6-11 21:45:57 AR AR_STANDARD_TEXT_B TABLE2004-6-11 21:45:58AR AR_STANDARD_TEXT_TL TABLE2004-6-11 21:45:58 AR AR_STATEMENTS_HISTORY_ALL TABLE2004-6-11 21:45:59 AR AR_STATEMENT_CYCLES TABLE2004-6-11 21:46:00 AR AR_STATEMENT_CYCLE_DATES_ALL TABLE2004-6-11 21:46:08 AR AR_STATEMENT_CYCLE_INTERVALS T ABLE2004-6-11 21:46:08 AR AR_STATEMENT_HEADERS TABLE2004-6-11 21:46:09 AR AR_STATEMENT_LINE_CLUSTERS TABLE2004-6-11 21:46:09 AR AR_SUM_REF_EVENT_HIST TABLE2004-6-11 21:46:10 AR AR_SYSTEM_PARAMETERS_ALL TABLE2004-6-11 21:46:11 AR AR_TAX_CONDITIONS_ALL TABLE2004-6-11 21:46:12 AR AR_TAX_CONDITION_ACTIONS_ALLTABLE2004-6-11 21:46:14 AR AR_TAX_CONDITION_LINES_ALL TABLE2004-6-11 21:46:15 AR AR_TAX_EXTRACT_DCL_ITF TABLE2004-6-11 21:46:16 AR AR_TAX_EXTRACT_MATRIX_ITF TABLE2004-6-11 21:46:17 AR AR_TAX_EXTRACT_SUB_ITF TABLE2004-6-11 21:46:17 AR AR_TAX_GROUP_CODES_ALL TABLE2004-6-11 21:46:19 AR AR_TAX_INTERFACE TABLE2004-6-11 21:46:20 AR AR_TA_ASGN_TO_INT_ALL TABLE2004-6-11 21:46:21 AR AR_TA_CASHAPP_OB_ALL TABLE2004-6-11 21:46:22 AR AR_TA_CR_AGEN_INF_ALL TABLE2004-6-11 21:46:23 AR AR_TA_CUST_HIER_CHILD TABLE2004-6-11 21:46:24 AR AR_TA_CUST_HIER_PARNT TABLE2004-6-11 21:46:25 AR AR_TA_CUST_INT_ALL TABLE2004-6-11 21:46:26 AR AR_TA_CUST_TRXSTR_ALL TABLE2004-6-11 21:46:26 AR AR_TA_DEDN_ASSGNS_ALL TABLE2004-6-11 21:46:32 AR AR_TA_DEDN_INT_ALL TABLE2004-6-11 21:46:33 AR AR_TA_DEDN_RELATE_ALL TABLE2004-6-11 21:46:33 AR AR_TA_LEGACY_CUST_INT TABLE2004-6-11 21:46:34 AR AR_TA_LEGACY_STAT_INT TABLE2004-6-11 21:46:34 AR AR_TA_PAYMNT_HIST_ALL TABLE2004-6-11 21:46:35 AR AR_TA_PROF_ASSGNT_ALL TABLE2004-6-11 21:46:36 AR AR_TA_PROMOTIONS_ALL TABLE2004-6-11 21:46:37 AR AR_TA_PROMOTIONS_INT TABLE2004-6-11 21:46:38 AR AR_TA_PROM_CUST_ALL TABLE2004-6-11 21:46:39 AR AR_TA_PROM_CUST_MAP TABLE2004-6-11 21:46:39 AR AR_TA_PROM_LINES_INT TABLE2004-6-11 21:46:40 AR AR_TA_PROM_PAYMNT_ALL TABLE2004-6-11 21:46:41 AR AR_TA_PROM_PAYMNT_TYP TABLE2004-6-11 21:46:42 AR AR_TA_PROM_PRODS_ALL TABLE2004-6-11 21:46:43 AR AR_TA_PROM_STATUS_MAP TABLE2004-6-11 21:46:43 AR AR_TA_RECON_INFO_ALL TABLE2004-6-11 21:46:44 AR AR_TA_RECV_TRXSET_ALL TABLE2004-6-11 21:46:45 AR AR_TA_REMIT_HIST_ALL TABLE2004-6-11 21:46:46 AR AR_TA_REMIT_PROF_ALL TABLE2004-6-11 21:46:48 AR AR_TA_RISK_COMENT_ALL TABLE2004-6-11 21:46:49 AR AR_TA_RULES_ALL TABLE2004-6-11 21:46:50 AR AR_TA_RULE_OUTPUT TABLE2004-6-11 21:46:56 AR AR_TA_RULE_SETS_ALL TABLE2004-6-11 21:46:56 AR AR_TA_RULE_SET_LN_ALL TABLE2004-6-11 21:46:57 AR AR_TA_TRX_SETS_ALL TABLE2004-6-11 21:46:58 AR AR_TA_TRX_SET_LN_ALL TABLE2004-6-11 21:46:58 AR AR_TA_TRX_TO_CREATE TABLE2004-6-11 21:46:59 AR AR_TA_TRX_TYP_INT_ALL TABLE2004-6-11 21:47:00 AR AR_TA_VERSIONS TABLE2004-6-11 21:47:01 AR AR_TRANSACTIONS_REP_ITF TABLE2004-6-11 21:47:01AR AR_TRANSACTION_HISTORY_ALL TABLE2004-6-11 21:47:02 AR AR_TRANSMISSIONS_ALL TABLE2004-6-11 21:47:04 AR AR_TRANSMISSION_FORMATS TABLE2004-6-11 21:47:05 AR AR_TRANS_FIELD_FORMATS TABLE2004-6-11 21:47:06 AR AR_TRANS_RECORD_FORMATS TABLE2004-6-11 21:47:07 AR AR_TRX_BAL_SUMMARY TABLE2004-6-11 21:47:08 AR AR_TRX_SUMMARY TABLE2004-6-11 21:47:10 AR AR_TRX_SUMMARY_HIST TABLE2004-6-11 21:47:11 AR AR_VAT_TAX_ALL_B TABLE2004-6-11 21:47:12 AR AR_VAT_TAX_ALL_TL TABLE2004-6-11 21:47:13 AR HZ_APPLICATION_TRANS_GT TABLE2004-6-11 21:47:14 AR HZ_BANK_VAL_GT TABLE2004-6-11 21:47:15 AR HZ_BILLING_PREFERENCES TABLE2004-6-11 21:47:20 AR HZ_CERTIFICATIONS TABLE2004-6-11 21:47:20 AR HZ_CITIZENSHIP TABLE2004-6-11 21:47:21 AR HZ_CLASS_CATEGORIES TABLE2004-6-11 21:47:21 AR HZ_CLASS_CATEGORY_USES TABLE2004-6-11 21:47:22 AR HZ_CLASS_CODE_DENORM TABLE2004-6-11 21:47:23 AR HZ_CLASS_CODE_RELATIONS TABLE2004-6-11 21:47:24 AR HZ_CODE_ASSIGNMENTS TABLE2004-6-11 21:47:26 AR HZ_CONTACT_POINTS TABLE2004-6-11 21:47:27 AR HZ_CONTACT_POINT_VAL_GT TABLE2004-6-11 21:47:29 AR HZ_CONTACT_PREFERENCES TABLE2004-6-11 21:47:30 AR HZ_CONTACT_RESTRICTIONS TABLE2004-6-11 21:47:31 AR HZ_CREDIT_PROFILES TABLE2004-6-11 21:47:32 AR HZ_CREDIT_PROFILE_AMTS TABLE2004-6-11 21:47:33 AR HZ_CREDIT_RATINGS TABLE2004-6-11 21:47:42 AR HZ_CREDIT_USAGES TABLE2004-6-11 21:47:43 AR HZ_CREDIT_USAGE_RULES TABLE2004-6-11 21:47:44 AR HZ_CREDIT_USAGE_RULE_SETS_BTABLE2004-6-11 21:47:45 AR HZ_CREDIT_USAGE_RULE_SETS_TL T ABLE2004-6-11 21:47:47 AR HZ_CUSTOMER_MERGE_LOG TABLE2004-6-11 21:47:48 AR HZ_CUSTOMER_PROFILES TABLE2004-6-11 21:47:49 AR HZ_CUSTOMER_PROFILES_M TABLE2004-6-11 21:47:50 AR HZ_CUST_ACCOUNTS TABLE2004-6-11 21:47:52 AR HZ_CUST_ACCOUNTS_M TABLE2004-6-11 21:47:53 AR HZ_CUST_ACCOUNT_ROLES TABLE2004-6-11 21:47:54 AR HZ_CUST_ACCOUNT_ROLES_M TABLE2004-6-11 21:47:56 AR HZ_CUST_ACCT_RELATE_ALL TABLE2004-6-11 21:47:57 AR HZ_CUST_ACCT_RELATE_ALL_M TABLE2004-6-11 21:47:59 AR HZ_CUST_ACCT_SITES_ALL TABLE2004-6-11 21:48:06 AR HZ_CUST_ACCT_SITES_ALL_M TABLE2004-6-11 21:48:08 AR HZ_CUST_CONTACT_POINTS TABLE2004-6-11 21:48:09 AR HZ_CUST_MERGE_LOG_DICT TABLE2004-6-11 21:48:10 AR HZ_CUST_PROFILE_AMTS TABLE2004-6-11 21:48:11 AR HZ_CUST_PROFILE_AMTS_M TABLE2004-6-11 21:48:13 AR HZ_CUST_PROFILE_CLASSES TABLE2004-6-11 21:48:14 AR HZ_CUST_PROF_CLASS_AMTS TABLE2004-6-11 21:48:15 AR HZ_CUST_SITE_USES_ALL TABLE2004-6-11 21:48:17 AR HZ_CUST_SITE_USES_ALL_M TABLE2004-6-11 21:48:27 AR HZ_DNB_REQUEST_LOG TABLE2004-6-11 21:48:27 AR HZ_DQM_DETAILS_GT TABLE2004-6-11 21:48:28 AR HZ_DQM_PARTIES_GT TABLE2004-6-11 21:48:46 AR HZ_DQM_STAGE_GT TABLE2004-6-11 21:48:52 AR HZ_DQM_STAGE_LOG TABLE2004-6-11 21:48:53AR HZ_DQM_SYNC_GT TABLE2004-6-11 21:48:55 AR HZ_DQM_SYNC_INTERFACE TABLE2004-6-11 21:48:57 AR HZ_DSS_ASSIGNMENTS TABLE2004-6-11 21:48:58 AR HZ_DSS_CRITERIA TABLE2004-6-11 21:48:59 AR HZ_DSS_ENTITIES TABLE2004-6-11 21:49:01 AR HZ_DSS_GROUPS_B TABLE2004-6-11 21:49:03 AR HZ_DSS_GROUPS_TL TABLE2004-6-11 21:49:04 AR HZ_DSS_SCHEME_FUNCTIONS TABLE2004-6-11 21:49:04 AR HZ_DSS_SECURED_ENTITIES TABLE2004-6-11 21:49:06 AR HZ_DUP_BATCH TABLE2004-6-11 21:49:07 AR HZ_DUP_EXCLUSIONS TABLE2004-6-11 21:49:08 AR HZ_DUP_MATCH_DETAILS TABLE2004-6-11 21:49:09 AR HZ_DUP_MERGE_PARTIES TABLE2004-6-11 21:49:10 AR HZ_DUP_SETS TABLE2004-6-11 21:49:11 AR HZ_DUP_SET_PARTIES TABLE2004-6-11 21:49:12 AR HZ_EDUCATION TABLE2004-6-11 21:49:13 AR HZ_EMPLOYMENT_HISTORY TABLE2004-6-11 21:49:14 AR HZ_ENTITY_ATTRIBUTES TABLE2004-6-11 21:49:16 AR HZ_EXT_DATA_RULES_TL TABLE2004-6-11 21:49:23 AR HZ_FINANCIAL_NUMBERS TABLE2004-6-11 21:49:24 AR HZ_FINANCIAL_PROFILE TABLE2004-6-11 21:49:25 AR HZ_FINANCIAL_REPORTS TABLE2004-6-11 21:49:25 AR HZ_GROUP_VAL_GT TABLE2004-6-11 21:49:27 AR HZ_HIERARCHY_NODES TABLE2004-6-11 21:49:27 AR HZ_INDUSTRIAL_CLASSES TABLE2004-6-11 21:49:39 AR HZ_INDUSTRIAL_CLASS_APP TABLE2004-6-11 21:49:39 AR HZ_INDUSTRIAL_REFERENCE TABLE2004-6-11 21:49:40 AR HZ_LOCATIONS TABLE2004-6-11 21:49:41 AR HZ_LOCATION_VAL_GT TABLE2004-6-11 21:49:44 AR HZ_LOC_ASSIGNMENTS TABLE2004-6-11 21:49:45 AR HZ_LOG TABLE2004-6-11 21:49:46 AR HZ_LOG2TABLE2004-6-11 21:49:46 AR HZ_MATCHED_CONTACTS_GT TABLE2004-6-11 21:49:47 AR HZ_MATCHED_CPTS_GT TABLE2004-6-11 21:49:48 AR HZ_MATCHED_PARTIES_GT TABLE2004-6-11 21:49:48 AR HZ_MATCHED_PARTY_SITES_GT TABLE2004-6-11 21:49:50 AR HZ_MATCH_RULES_B TABLE2004-6-11 21:49:51 AR HZ_MATCH_RULES_TL TABLE2004-6-11 21:49:53 AR HZ_MATCH_RULE_PRIMARY TABLE2004-6-11 21:49:57 AR HZ_MATCH_RULE_SECONDARY TABLE2004-6-11 21:49:59 AR HZ_MERGE_BATCH TABLE2004-6-11 21:50:00 AR HZ_MERGE_DICTIONARY TABLE2004-6-11 21:50:01 AR HZ_MERGE_ENTITY_ATTRIBUTES TABLE2004-6-11 21:50:03 AR HZ_MERGE_PARTIES TABLE2004-6-11 21:50:15 AR HZ_MERGE_PARTIES_SUGG TABLE2004-6-11 21:50:16 AR HZ_MERGE_PARTYDTLS_SUGG TABLE2004-6-11 21:50:17 AR HZ_MERGE_PARTY_DETAILS TABLE2004-6-11 21:50:19 AR HZ_MERGE_PARTY_HISTORY TABLE2004-6-11 21:50:20 AR HZ_MERGE_PARTY_LOG TABLE2004-6-11 21:50:22 AR HZ_MOBILE_PREFIXES TABLE2004-6-11 21:50:23 AR HZ_ORGANIZATION_INDICATORS TABLE2004-6-11 21:50:24 AR HZ_ORGANIZATION_PROFILES TABLE2004-6-11 21:50:34 AR HZ_ORG_CONTACTS TABLE2004-6-11 21:50:36 AR HZ_ORG_CONTACT_ROLES TABLE2004-6-11 21:50:39 AR HZ_ORG_CONTACT_VAL_GT TABLE2004-6-11 21:50:40AR HZ_ORG_PROFILE_VAL_GT TABLE2004-6-11 21:50:42 AR HZ_PARAM_TAB TABLE2004-6-11 21:50:43 AR HZ_PARTIES TABLE2004-6-11 21:50:44 AR HZ_PARTY_INTERFACE TABLE2004-6-11 21:50:56 AR HZ_PARTY_INTERFACE_ERRORS TABLE2004-6-11 21:50:58 AR HZ_PARTY_PREFERENCES TABLE2004-6-11 21:50:59 AR HZ_PARTY_RELATIONSHIPS TABLE2004-6-11 21:51:00 AR HZ_PARTY_SCORE_DTLS_GT TABLE2004-6-11 21:51:01 AR HZ_PARTY_SITES TABLE2004-6-11 21:51:02 AR HZ_PARTY_SITE_USES TABLE2004-6-11 21:51:04 AR HZ_PARTY_SITE_VAL_GT TABLE2004-6-11 21:51:05 AR HZ_PARTY_VAL_GT TABLE2004-6-11 21:51:06 AR HZ_PERSON_INTEREST TABLE2004-6-11 21:51:07 AR HZ_PERSON_LANGUAGE TABLE2004-6-11 21:51:08 AR HZ_PERSON_PROFILES TABLE2004-6-11 21:51:09 AR HZ_PHONE_AREA_CODES TABLE2004-6-11 21:51:11 AR HZ_PHONE_COUNTRY_CODES TABLE2004-6-11 21:51:12 AR HZ_PHONE_FORMATS TABLE2004-6-11 21:51:13 AR HZ_PRIMARY_TRANS TABLE2004-6-11 21:51:18 AR HZ_PURGE_BATCHES TABLE2004-6-11 21:51:19 AR HZ_PURGE_CANDIDATES TABLE2004-6-11 21:51:20 AR HZ_PURGE_GT TABLE2004-6-11 21:51:21 AR HZ_REFERENCES TABLE2004-6-11 21:51:21 AR HZ_REGISTRATIONS TABLE2004-6-11 21:51:23 AR HZ_REG_VERIFICATIONS TABLE2004-6-11 21:51:24 AR HZ_RELATIONSHIPS TABLE2004-6-11 21:51:26 AR HZ_RELATIONSHIP_TYPES TABLE2004-6-11 21:51:28 AR HZ_RELATIONSHIP_VAL_GT TABLE2004-6-11 21:51:30 AR HZ_ROLE_RESPONSIBILITY TABLE2004-6-11 21:51:31 AR HZ_SECONDARY_TRANS TABLE2004-6-11 21:51:32 AR HZ_SECURITY_ISSUED TABLE2004-6-11 21:51:33 AR HZ_SELECT_DATA_SOURCES TABLE2004-6-11 21:51:35 AR HZ_STAGED_CONTACTS TABLE2004-6-11 21:51:41 AR HZ_STAGED_CONTACT_POINTS TABLE2004-6-11 21:51:43 AR HZ_STAGED_PARTIES TABLE2004-6-11 21:51:44 AR HZ_STAGED_PARTY_SITES TABLE2004-6-11 21:51:45 AR HZ_STOCK_MARKETS TABLE2004-6-11 21:51:47 AR HZ_STYLES_B TABLE2004-6-11 21:51:48 AR HZ_STYLES_TL TABLE2004-6-11 21:51:49 AR HZ_STYLE_FMT_LAYOUTS_B TABLE2004-6-11 21:51:50 AR HZ_STYLE_FMT_LAYOUTS_TL TABLE2004-6-11 21:51:51 AR HZ_STYLE_FMT_LOCALES TABLE2004-6-11 21:51:52 AR HZ_STYLE_FMT_VARIATIONS TABLE2004-6-11 21:51:53 AR HZ_STYLE_FORMATS_B TABLE2004-6-11 21:51:54 AR HZ_STYLE_FORMATS_TL TABLE2004-6-11 21:51:55 AR HZ_SUSPENSION_ACTIVITY TABLE2004-6-11 21:51:56 AR HZ_THIRDPARTY_EXCEPS TABLE2004-6-11 21:51:58 AR HZ_THIRDPARTY_RULE TABLE2004-6-11 21:52:04 AR HZ_TIMEZONES TABLE2004-6-11 21:52:04 AR HZ_TIMEZONES_TL TABLE2004-6-11 21:52:05 AR HZ_TIMEZONE_MAPPING TABLE2004-6-11 21:52:06 AR HZ_TRANS_ATTRIBUTES_B TABLE2004-6-11 21:52:06 AR HZ_TRANS_ATTRIBUTES_TL TABLE2004-6-11 21:52:07 AR HZ_TRANS_FUNCTIONS_B TABLE2004-6-11 21:52:08 AR HZ_TRANS_FUNCTIONS_TL TABLE2004-6-11 21:52:09AR HZ_USER_CREATE_RULES TABLE2004-6-11 21:52:10 AR HZ_USER_ORG_GT TABLE2004-6-11 21:52:11 AR HZ_USER_OVERWRITE_RULES TABLE2004-6-11 21:52:12 AR HZ_WIN_SOURCE_EXCEPS TABLE2004-6-11 21:52:13 AR HZ_WORD_LISTS TABLE2004-6-11 21:52:13 AR HZ_WORD_REPLACEMENTS TABLE2004-6-11 21:52:14 AR HZ_WORK_CLASS TABLE2004-6-11 21:52:16 AR JE_DE_AR_BATCHES TABLE2004-6-11 21:52:17 AR JE_DE_REMITTANCE_RESULTS TABLE2004-6-11 21:52:18 AR JG_ZZ_AR_BALANCES TABLE2004-6-11 21:52:19 AR JG_ZZ_AR_TMP_ACCOUNT TABLE2004-6-11 21:52:20 AR JG_ZZ_AR_TMP_BAL TABLE2004-6-11 21:52:21 AR JG_ZZ_AR_TMP_DETAIL TABLE2004-6-11 21:52:21 AR JG_ZZ_II_INT_RATES_ALL TABLE2004-6-11 21:52:22 AR JG_ZZ_INTEREST_BATCHES_ALL TABLE2004-6-11 21:52:23 AR JG_ZZ_INTEREST_INVOICES_ALL TABLE2004-6-11 21:52:24 AR JG_ZZ_INT_INV_LINES_ALL TABLE2004-6-11 21:52:27 AR JG_ZZ_JGZZCSLP_MESSAGES TABLE2004-6-11 21:52:28 AR RA_ACCOUNT_COMBINATIONS TABLE2004-6-11 21:52:28 AR RA_ACCOUNT_DEFAULTS_ALL TABLE2004-6-11 21:52:29 AR RA_ACCOUNT_DEFAULT_SEGMENTS TABLE2004-6-11 21:52:30 AR RA_ADDRESSES_ALL TABLE2004-6-11 21:52:31 AR RA_BATCHES_ALL TABLE2004-6-11 21:52:33 AR RA_BATCH_SOURCES_ALL TABLE2004-6-11 21:52:34 AR RA_CM_REQUESTS_ALL TABLE2004-6-11 21:52:35 AR RA_CM_REQUEST_LINES_ALL TABLE2004-6-11 21:52:36 AR RA_CONTACTS TABLE2004-6-11 21:52:37 AR RA_CONTACT_PHONES_INT_ALL TABLE2004-6-11 21:52:39 AR RA_CONTACT_ROLES TABLE2004-6-11 21:52:40 AR RA_CUSTOMERS TABLE2004-6-11 21:52:41 AR RA_CUSTOMERS_INTERFACE_ALL TABLE2004-6-11 21:52:42 AR RA_CUSTOMER_BANKS_INT_ALL TABLE2004-6-11 21:52:44 AR RA_CUSTOMER_MERGES TABLE2004-6-11 21:52:50 AR RA_CUSTOMER_MERGE_HEADERSTABLE2004-6-11 21:52:51 AR RA_CUSTOMER_PROFILES_INT_ALL TABLE2004-6-11 21:52:52TABLE2004-6-11 21:52:54 AR RA_CUSTOMER_RELATIONSHIPS_ALLAR RA_CUSTOMER_TRX_ALL TABLE2004-6-11 21:52:55 AR RA_CUSTOMER_TRX_LINES_ALL TABLE2004-6-11 21:52:58 AR RA_CUST_PAY_METHOD_INT_ALL TABLE2004-6-11 21:53:00 AR RA_CUST_RECEIPT_METHODS TABLE2004-6-11 21:53:01 AR RA_CUST_TRX_LINE_GL_DIST_ALL TABLE2004-6-11 21:53:02 AR RA_CUST_TRX_LINE_SALESREPS_AL TABLE2004-6-11 21:53:03 AR RA_CUST_TRX_TYPES_ALL TABLE2004-6-11 21:53:05 AR RA_GROUPING_RULES TABLE2004-6-11 21:53:05 AR RA_GROUPING_TRX_TYPES TABLE2004-6-11 21:53:06 AR RA_GROUP_BYS TABLE2004-6-11 21:53:07 AR RA_GROUP_BY_COLUMNS TABLE2004-6-11 21:53:08 AR RA_INTERFACE_DISTRIBUTIONS_ALL TABLE2004-6-11 21:53:12 AR RA_INTERFACE_ERRORS_ALL TABLE2004-6-11 21:53:13 AR RA_INTERFACE_LINES_ALL TABLE2004-6-11 21:53:13 AR RA_INTERFACE_SALESCREDITS_ALL TABLE2004-6-11 21:53:15 AR RA_ITEM_EXCEPTION_RATES TABLE2004-6-11 21:53:16 AR RA_LINE_ORDERING_RULES TABLE2004-6-11 21:53:17 AR RA_LINE_ORDER_BYS TABLE2004-6-11 21:53:18 AR RA_LINE_ORDER_BY_COLUMNS TABLE2004-6-11 21:53:19AR RA_MC_BATCHES TABLE2004-6-11 21:53:20 AR RA_MC_CUSTOMER_TRX TABLE2004-6-11 21:53:21 AR RA_MC_CUSTOMER_TRX_LINES TABLE2004-6-11 21:53:22 AR RA_MC_TRX_LINE_GL_DIST TABLE2004-6-11 21:53:22 AR RA_PHONES TABLE2004-6-11 21:53:23 AR RA_RECUR_INTERIM TABLE2004-6-11 21:53:25 AR RA_REMIT_TOS_ALL TABLE2004-6-11 21:53:26 AR RA_RULES TABLE2004-6-11 21:53:27 AR RA_RULE_SCHEDULES TABLE2004-6-11 21:53:29 AR RA_SALESREPS_ALL_OLD TABLE2004-6-11 21:53:30 AR RA_SALESREP_TERRITORIES TABLE2004-6-11 21:53:32 AR RA_SITE_USES_ALL TABLE2004-6-11 21:53:40 AR RA_TAX_EXEMPTIONS_ALL TABLE2004-6-11 21:53:41 AR RA_TERMS_B TABLE2004-6-11 21:53:42 AR RA_TERMS_LINES TABLE2004-6-11 21:53:43 AR RA_TERMS_LINES_DISCOUNTS TABLE2004-6-11 21:53:44 AR RA_TERMS_TL TABLE2004-6-11 21:53:45 AR RA_TERRITORIES TABLE2004-6-11 21:53:46 AR DR$HZ_CLASS_CODE_DENORM_T1$I TABLE2004-6-12 0:45:43TABLE2004-6-12 0:45:43 AR DR$HZ_CLASS_CODE_DENORM_T1$KTABLE2004-6-12 0:45:43 AR DR$HZ_CLASS_CODE_DENORM_T1$RTABLE2004-6-12 0:45:43 AR DR$HZ_CLASS_CODE_DENORM_T1$NAR AR_REV_REC_QT TABLE2004-6-14 12:44:09 AR AQ$_AR_REV_REC_QT_S TABLE2004-6-14 12:44:09 AR AQ$_AR_REV_REC_QT_H TABLE2004-6-14 12:44:09 AR AQ$_AR_REV_REC_QT_T TABLE2004-6-14 12:44:09 AR AQ$_AR_REV_REC_QT_I TABLE2004-6-14 12:44:10 AR AR_CCID_CORRECTIONS_ALL TABLE2004-10-30 12:38:02 AR HZ_IMP_WORK_UNITS TABLE2004-10-30 12:38:06 AR HZ_EMAIL_DOMAINS TABLE2004-10-30 12:38:07 AR HZ_IMP_PARTIES_INT TABLE2004-10-30 12:38:07 AR HZ_IMP_ADDRESSES_INT TABLE2004-10-30 12:38:07 AR HZ_GEOGRAPHIES TABLE2004-10-30 12:38:07 AR HZ_IMP_CONTACTPTS_INT TABLE2004-10-30 12:38:07 AR HZ_GEOGRAPHY_IDENTIFIERS TABLE2004-10-30 12:38:08 AR HZ_IMP_CREDITRTNGS_INT TABLE2004-10-30 12:38:08 AR HZ_GEOGRAPHY_RANGES TABLE2004-10-30 12:38:08 AR HZ_GEOGRAPHY_TYPES_TL TABLE2004-10-30 12:38:08 AR HZ_IMP_FINREPORTS_INT TABLE2004-10-30 12:38:08 AR AR_BPA_DATASRC_APPS_B TABLE2004-10-30 12:38:08 AR HZ_IMP_FINNUMBERS_INT TABLE2004-10-30 12:38:09 AR HZ_GEOGRAPHY_TYPES_B TABLE2004-10-30 12:38:09 AR AR_BPA_DATASRC_APPS_TL TABLE2004-10-30 12:38:09 AR HZ_IMP_CLASSIFICS_INT TABLE2004-10-30 12:38:09 AR HZ_GEO_NAME_REFERENCE_LOG TABLE2004-10-30 12:38:09 AR AR_BPA_DATA_SOURCES_B TABLE2004-10-30 12:38:09 AR HZ_GEO_NAME_REFERENCES TABLE2004-10-30 12:38:09 AR HZ_IMP_RELSHIPS_INT TABLE2004-10-30 12:38:09 AR AR_BPA_DATA_SOURCES_TL TABLE2004-10-30 12:38:10 AR HZ_GEO_STRUCT_MAP TABLE2004-10-30 12:38:10 AR HZ_IMP_CONTACTROLES_INT TABLE2004-10-30 12:38:10 AR AR_BPA_PAGE_SETUPS_B TABLE2004-10-30 12:38:10 AR HZ_GEO_STRUCT_MAP_DTL TABLE2004-10-30 12:38:10 AR HZ_IMP_CONTACTS_INT TABLE2004-10-30 12:38:10 AR AR_BPA_PAGE_SETUPS_TL TABLE2004-10-30 12:38:10AR HZ_GEO_STRUCTURE_LEVELS TABLE2004-10-30 12:38:10 AR AR_BPA_TEMPLATE_FILES TABLE2004-10-30 12:38:10 AR HZ_IMP_ADDRESSUSES_INT TABLE2004-10-30 12:38:10 AR HZ_IMP_ERRORS TABLE2004-10-30 12:38:11 AR AR_BPA_TEMPLATE_FIELDS TABLE2004-10-30 12:38:11 AR HZ_IMP_TMP_ERRORS TABLE2004-10-30 12:38:11 AR AR_BPA_PRINT_REQUESTS TABLE2004-10-30 12:38:11 AR HZ_IMP_OSR_CHANGE TABLE2004-10-30 12:38:16 AR HZ_IMP_TMP_REL_END_DATE TABLE2004-10-30 12:38:17 AR HZ_SRCH_CONTACTS TABLE2004-10-30 12:38:19 AR HZ_SRCH_CPTS TABLE2004-10-30 12:38:19 AR HZ_SRCH_PARTIES TABLE2004-10-30 12:38:20 AR HZ_SRCH_PSITES TABLE2004-10-30 12:38:20 AR HZ_DUP_RESULTS TABLE2004-10-30 12:38:21 AR HZ_INT_DUP_RESULTS TABLE2004-10-30 12:38:21 AR HZ_IMP_DUP_DETAILS TABLE2004-10-30 12:38:22 AR HZ_IMP_DUP_PARTIES TABLE2004-10-30 12:38:22 AR HZ_IMP_INT_DEDUP_RESULTS TABLE2004-10-30 12:38:22 AR HZ_IMP_PARTIES_SG TABLE2004-10-30 12:38:25 AR HZ_IMP_ADDRESSES_SG TABLE2004-10-30 12:38:25 AR HZ_IMP_CONTACTPTS_SG TABLE2004-10-30 12:38:25 AR HZ_IMP_CREDITRTNGS_SG TABLE2004-10-30 12:38:25 AR HZ_IMP_CLASSIFICS_SG TABLE2004-10-30 12:38:26 AR HZ_IMP_FINREPORTS_SG TABLE2004-10-30 12:38:26 AR HZ_IMP_FINNUMBERS_SG TABLE2004-10-30 12:38:26 AR HZ_IMP_RELSHIPS_SG TABLE2004-10-30 12:38:26 AR HZ_IMP_CONTACTS_SG TABLE2004-10-30 12:38:26 AR HZ_IMP_CONTACTROLES_SG TABLE2004-10-30 12:38:26 AR HZ_IMP_ADDRESSUSES_SG TABLE2004-10-30 12:38:26 AR AR_IREC_CUSTOM_CUST_GT TABLE2004-10-30 12:38:43 AR AR_IREC_CUSTOM_SRCH_GT TABLE2004-10-30 12:38:47 AR AR_IREC_PAYMENT_LIST_GT TABLE2004-10-30 12:38:50 AR AR_STATEMENT_FINCHRG_GT TABLE2004-10-30 12:39:00 AR AR_TAX_EXTR_SUB_AP_EXT TABLE2004-10-30 12:39:02 AR AR_TRX_ERRORS_GT TABLE2004-10-30 12:39:02 AR AR_TAX_EXTR_SUB_AR_EXT TABLE2004-10-30 12:39:04 AR AR_TAX_EXTR_SUB_COM_EXT TABLE2004-10-30 12:39:05 AR AR_TRX_DIST_GT TABLE2004-10-30 12:39:07 AR AR_REVENUE_ASSIGNMENTS_GT TABLE2004-10-30 12:39:08 AR AR_TRX_LINES_GT TABLE2004-10-30 12:39:16 AR AR_TRX_SALESCREDITS_GT TABLE2004-10-30 12:39:17 AR AR_TRX_HEADER_GT TABLE2004-10-30 12:39:19 AR HZ_ORIG_SYS_MAPPING TABLE2004-10-30 12:39:26 AR HZ_ORIG_SYS_REFERENCES TABLE2004-10-30 12:39:27 AR HZ_ADAPTER_LOGS TABLE2004-10-30 12:39:28 AR HZ_IMP_ADAPTERS TABLE2004-10-30 12:39:28 AR HZ_IMP_BATCH_DETAILS TABLE2004-10-30 12:39:29 AR HZ_IMP_BATCH_SUMMARY TABLE2004-10-30 12:39:29 AR HZ_LOCATION_PROFILES TABLE2004-10-30 12:39:31 AR HZ_ADAPTERS TABLE2004-10-30 12:39:34 AR HZ_DUP_WORKER_CHUNK_GT TABLE2004-10-30 12:39:35 AR HZ_ADAPTER_TERRITORIES TABLE2004-10-30 12:39:35 AR HZ_INT_DUP_RESULTS_GT TABLE2004-10-30 12:39:36 AR AR_TAX_CODE_COMBINATION_ID_GTTABLE2005-7-16 3:55:48 AR OCM_CREDIT_REVIEW_GT TABLE2005-7-16 3:55:49。