티스토리 뷰


 

  ERP를 시작한지 어느덧 반년이 지났다. 오라클(ORACLE) ERP를 구성하는 다양한 모듈을 하나 하나 알아가는 것도 어렵지만, 각 모듈을 연결해주는 인터페이스 테이블에 대한 정보도 중요하다는 생각이 들어서 공부하고 있다.

 

  필자와 비슷한 분들에게 조금이라도 도움이 되고자, 인터페이스 테이블 정보를 모듈별로 모아서 정리해보았다.

 

 

 

  아래 내용은 오라클 ERP(ORACLE ERP)에 사용되는 인터페이스 테이블(INTERFACE TABLE) 이름이다.

 

GL INTERFACE TABLES

  GL_BUDGET_INTERFACE
  GL_DAILY_RATES_INTERFACE
  GL_IEA_INTERFACE
  GL_INTERFACE
  GL_INTERFACE_CONTROL
  GL_INTERFACE_HISTORY

 

AP INTERFACE TABLES

  AP_INTERFACE_CONTROLS
  AP_INTERFACE_REJECTIONS
  AP_INVOICES_INTERFACE
  AP_INVOICE_LINES_INTERFACE

  AR INTERFACE TABLES

  AR_PAYMENTS_INTERFACE_ALL
  AR_TAX_INTERFACE
  HZ_DQM_SYNC_INTERFACE
  HZ_PARTY_INTERFACE
  HZ_PARTY_INTERFACE_ERRORS
  RA_CUSTOMERS_INTERFACE_ALL
  RA_INTERFACE_DISTRIBUTIONS_ALL
  RA_INTERFACE_ERRORS_ALL
  RA_INTERFACE_LINES_ALL
  RA_INTERFACE_SALESCREDITS_ALL

 

FA INTERFACE TABLES

  FA_BUDGET_INTERFACE
  FA_INV_INTERFACE
  FA_PRODUCTION_INTERFACE
  FA_TAX_INTERFACE

 

INVENTORY INTERFACE TABLES

  MTL_CC_ENTRIES_INTERFACE
  MTL_CC_INTERFACE_ERRORS
  MTL_CI_INTERFACE
  MTL_CI_XREFS_INTERFACE
  MTL_COPY_ORG_INTERFACE
  MTL_CROSS_REFERENCES_INTERFACE
  MTL_DEMAND_INTERFACE
  MTL_DESC_ELEM_VAL_INTERFACE
  MTL_EAM_ASSET_NUM_INTERFACE
  MTL_EAM_ATTR_VAL_INTERFACE
  MTL_INTERFACE_ERRORS
  MTL_INTERFACE_PROC_CONTROLS
  MTL_ITEM_CATEGORIES_INTERFACE
  MTL_ITEM_CHILD_INFO_INTERFACE
  MTL_ITEM_REVISIONS_INTERFACE
  MTL_ITEM_SUB_INVS_INTERFACE
  MTL_OBJECT_GENEALOGY_INTERFACE
  MTL_RELATED_ITEMS_INTERFACE
  MTL_RESERVATIONS_INTERFACE
  MTL_RTG_ITEM_REVS_INTERFACE
  MTL_SECONDARY_LOCS_INTERFACE
  MTL_SERIAL_NUMBERS_INTERFACE
  MTL_SO_RMA_INTERFACE
  MTL_SYSTEM_ITEMS_INTERFACE
  MTL_TRANSACTIONS_INTERFACE
  MTL_TRANSACTION_LOTS_INTERFACE
  MTL_TXN_COST_DET_INTERFACE

 

PO INTERFACE TABLES

  PO_DISTRIBUTIONS_INTERFACE
  PO_HEADERS_INTERFACE
  PO_INTERFACE_ERRORS
  PO_LINES_INTERFACE
  PO_REQUISITIONS_INTERFACE_ALL
  PO_REQ_DIST_INTERFACE_ALL
  PO_RESCHEDULE_INTERFACE
  RCV_HEADERS_INTERFACE
  RCV_LOTS_INTERFACE
  RCV_SERIALS_INTERFACE
  RCV_TRANSACTIONS_INTERFACE


BOM INTERFACE TABLES

  BOM_BILL_OF_MTLS_INTERFACE
  BOM_INTERFACE_DELETE_GROUPS
  BOM_INVENTORY_COMPS_INTERFACE
  BOM_OP_RESOURCES_INTERFACE
  BOM_OP_ROUTINGS_INTERFACE
  BOM_OP_SEQUENCES_INTERFACE
  BOM_REF_DESGS_INTERFACE
  BOM_SUB_COMPS_INTERFACE
  CST_COMP_SNAP_INTERFACE
  CST_INTERFACE_ERRORS
  CST_ITEM_COSTS_INTERFACE
  CST_ITEM_CST_DTLS_INTERFACE
  CST_PC_COST_DET_INTERFACE
  CST_PC_ITEM_COST_INTERFACE

 

WIP INTERFACE TABLES

  WIP_COST_TXN_INTERFACE
  WIP_INTERFACE_ERRORS
  WIP_JOB_DTLS_INTERFACE
  WIP_JOB_SCHEDULE_INTERFACE
  WIP_MOVE_TXN_INTERFACE
  WIP_SCHEDULING_INTERFACE
  WIP_TXN_INTERFACE_ERRORS TABLE

 

ORDER MANAGEMENT(OM) INTERFACE TABLES

  SO_CONFIGURATIONS_INTERFACE
  SO_HEADERS_INTERFACE_ALL
  SO_HEADER_ATTRIBUTES_INTERFACE
  SO_LINES_INTERFACE_ALL
  SO_LINE_ATTRIBUTES_INTERFACE
  SO_LINE_DETAILS_INTERFACE
  SO_PRICE_ADJUSTMENTS_INTERFACE
  SO_SALES_CREDITS_INTERFACE
  SO_SERVICE_DETAILS_INTERFACE
  WSH_DELIVERIES_INTERFACE
  WSH_FREIGHT_CHARGES_INTERFACE
  WSH_PACKED_CONTAINER_INTERFACE

 

 

추가로 각 모듈의 TRM(Technical Reference Manual)을 다운받을수 있는 링크를 공유한다.

 

AP TRM || AR TRM || FA TRM || GL TRM || HRMS TRM

 

 




댓글
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
«   2024/03   »
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31
글 보관함