Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 106 views

    OM Interface & Base Tables

    Uploaded by

    Avishek Bose
    The document lists important columns from various interface tables that map data from source systems to Oracle E-Business Suite tables. It includes columns for identifying entities like customers and orders, as well as transactional details like prices, quantities, and adjustments. The base tables that the interface tables map data to are also listed.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd

    OM Interface & Base Tables

    Uploaded by

    Avishek Bose
    106 views4 pages
    The document lists important columns from various interface tables that map data from source systems to Oracle E-Business Suite tables. It includes columns for identifying entities like customers and orders, as well as transactional details like prices, quantities, and adjustments. The base tables that the interface tables map data to are also listed.

    Original Description:

    OM Interface & Base Tables

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document lists important columns from various interface tables that map data from source systems to Oracle E-Business Suite tables. It includes columns for identifying entities like customers and orders, as well as transactional details like prices, quantities, and adjustments. The base tables that the interface tables map data to are also listed.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    106 views4 pages

    OM Interface & Base Tables

    Uploaded by

    Avishek Bose
    The document lists important columns from various interface tables that map data from source systems to Oracle E-Business Suite tables. It includes columns for identifying entities like customers and orders, as well as transactional details like prices, quantities, and adjustments. The base tables that the interface tables map data to are also listed.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 4

    INTERFACE TABLES

    IMPORTANT COLUMNS ORDER_SOURCE CONVERSION_RATE ORG_ID ORDER_TYPE_ID PRICE_LIST SOLD_FROM_ORG_ID SOLD_TO_ORG_ID SHIP_TO_ORG_ID SHIP_FROM_ORG_ID CUSTOMER_NAME INVOICE_TO_ORG_ID OPERATION_CODE

    BASE TABLES

    OE_HEADERS_IFACE_ALL

    OE_ORDER_HEADERS_ALL

    ORDER_SOURCE_ID ORIG_SYS_DOCUMENT_REF ORIG_SYS_LINE_REF ORIG_SYS_SHIPMENT_REF INVENTORY_ITEM_ID LINK_TO_LINE_REF REQUEST_DATE DELIVERY_LEAD_TIME DELIVERY_ID ORDERED_QUANTITY ORDER_QUANTITY_UOM SHIPPING_QUANTITY PRICING_QUANTITY PRICING_QUANTITY_UOM SOLD_FROM_ORG_ID SOLD_TO_ORG_ID INVOICE_TO_ ORG_ID SHIP_TO_ORG_ID PRICE_LIST_ID PAYMENT_TERM_ID OE_LINES_IFACE_ALL OE_ORDER_LINES_ALL

    OE_PRICE_ADJS_IFACE_ALL

    ATTRIBUTE1 ADJUSTED_AMOUNT ADJUSTED_AMOUNT_PER_PQTY APPLIED_FLAG ARITHMETIC_OPERATOR AUTOMATIC_FLAG CHANGE_REQUEST_CODE CHANGE_SEQUENCE CONTEXT ERROR_FLAG ORDER_SOURCE_ID ORIG_SYS_LINE_REF ORIG_SYS_SHIPMENT_REF CHANGE_SEQUENCE HOLD_ID HOLD_TYP E_CODE SOLD_TO_ORG SOLD_TO_ORG_ID

    OE_PRICE_ADJUSTMENTS

    OE_ACTIONS_IFACE_ALL OE_CREDITS_IFACE_ALL

    OE_SALES_CREDITS

    INTERFACE TABLES ra_customers_interface_all

    ra_contact_phones_int_all

    IMPORTANT COLUMNS ADDRESS1 ORIG_SYSTEM_CUSTOMER_REF ORIG_SYSTEM_ADDRESS_REF SITE_USE_CODE INSERT_UPDATE_FLAG CUSTOMER_NAME CUSTOMER_NUMBER PERSON_FLAG CUSTOMER_STATUS PRIMARY_SITE_USE_FLAG CITY STATE POSTAL_CODE COUNTRY COUNTY JGZZ_FISCAL_CODE ORG_ID ORIG_SYSTEM_CUSTOMER_REF ORIG_SYSTEM_ADDRESS_REF ORIG_SYSTEM_CONTACT_REF ORIG_SYSTEM_TELEPHONE_REF INSERT_UPDATE_FLAG CONTACT_FIRST_NAME CONTACT_LAST_NAME TELEPHONE TELEPHONE_AREA_CODE TELEPHONE_TYPE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY ORG_ID CONTACT_POINT_TYPE

    BASE TABLES hz_parties

    hz_cust_accounts

    ra_customer_profiles_int_all ORIG_SYSTEM_CUSTOMER_REF INSERT_UPDATE_FLAG ORG_ID CREDIT_HOLD CUSTOMER_PROFILE_CLASS_NAME

    hz_cust_acct_sites_all hz_cust_sit_use_all hz_party_sites hz_locations hz_party_site_uses hz_customer_profiles hz_organization_profiles hz_person_profiles

    INTERFACE TABLES ra_interface_lines_all

    IMPORTANT COLUMNS AGREEMENT_ID COMMENTS CONVERSION_DATE CONVERSION_RATE CONVERSION_TYPE CREDIT_METHOD_FOR_ACCT_RULE CREDIT_METHOD_FOR_INSTALLMENTS CURRENCY_CODE CUSTOMER_BANK_ACCOUNT_ID CUST_TRX_TYPE_ID DOCUMENT_NUMBER DOCUMENT_NUMBER_SEQUENCE_ID GL_DATE HEADER_ATTRIBUTE115 HEADER_ATTRIBUTE_CATEGORY INITIAL_CUSTOMER_TRX_ID INTERNAL_NOTES INVOICING_RULE_ID ORIG_SYSTEM_BILL_ADDRESS_ID ORIG_SYSTEM_BILL_CONTACT_ID ORIG_SYSTEM_BILL_CUSTOMER_ID ORIG_SYSTEM_SHIP_ADDRESS_ID

    BASE TABLES ra_customer_trx_all

    ra_interface_distributions_all ra_interface_salescredits_all

    ra_customer_trx_lines_all ra_cust_trx_line_gl_dist_all ra_cust_trx_types_all ar_payment_schedules_all ra_batch_sources_all ar_vat_tax_all ra_terms ar_periods ar_period_types

    AR_INTERFACE_CONTS_ALL RA_INTERFACE_ERRORS_ALL

    You might also like