Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "EBS AR module common table analysis". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

AR module common table

Related table of transaction receivable

SELECT * FROM ar.ar_batches_all;-transaction batch

SELECT * FROM ar.ra_customer_trx_all;-Receivable header / invoice header

SELECT * FROM ra.ra_customer_trx_lines_all;-Receivable line item / invoice line

SELECT * FROM ra.ra_cust_trx_line_gl_dist_all;-Receivable Distribution Line / invoice allocation

SELECT * FROM ar.ar_payment_schedules_all;-collection plan / invoice adjustment

Collection related table

SELECT * FROM ar.ar_cash_receipts_all;-collection table

SELECT * FROM ar.ar_cash_receipt_history_all;-Collection History Table

SELECT * FROM ar.ar_distributions_all;-receipt allocation form / payment plan

SELECT * FROM ar.ar_misc_cash_distributions_all;-- Miscellaneous History allocation Table

SELECT * FROM ar.ar_receivable_applications_all;-- receipt write-off form

Subledger accounting subledger

SELECT * FROM ar_adjustments_all;-Accounting entry

SELECT * FROM xla.xla_events;-list of accounting events

SELECT * FROM xla.xla_transaction_entites;-transaction table

SELECT * FROM xla.xla_ae_headers;-subledger journal headers

SELECT * FROM xla.xla_ae_lines;-subledger journal line

SELECT * FROM xla.xla_distributions_link;-subledger journal row association table

SELECT * FROM xla.xla_events_error;-Accounting event error reminder form

Interface related tables Receivable temporary tables

SELECT * FROM ar.ra_interface_lines_all;-Receivable Interface Row Table

Select * from ra_interface_salescredits_all;-sales performance information of the receivable interface line table

SELECT * FROM ar.ra_interface_distributions_all;-Receivable Interface allocation Row Table

Interface related table collection temporary table

SELECT * FROM ar. Ar_interim_cash_receipts_all;-Standard Interface for Collection

Master data related tables / views

SELECT * FROM HZ_PARTIES;-customer organization table

SELECT * FROM HZ_CUST_ACCOUNTS;-customer account table

Account Profil

HZ_CUSTOMER_PROFILES

Field

Cust_account_role_id-oe_order_headers.sold_to_contract_id

Cust_account_id

Site_use_id-this field of the customer header is empty

-- customer location layer is hz_cust_site_uses_all.site_use_id

Profile amount

HZ_CUST_PROFILE_AMTS-customer headline / customer location tier

Association: hz_customer_profiles.cust_account_profile_id

Customer contact

HZ_CUST_ACCOUNT_ROLES-customer headline / location tier

Cust_account_id

Cust_acct_site_id-this field is empty in the header layer

Party_id-PARTY_ID of type PARTY_RELATIONSHIP

Role_type-CONTACT

Contact information

HZ_CONTACT_POINTS

Field

Owner_table_name HZ_PARTIES/HZ_PARTY_SITES

Owner_table_id PARTY_ID/PARTY_SITE_ID

For the contact information of the customer location layer, you can directly associate the owner_table_id with party_site_id.

The contact information of the customer at the front level should be converted with HZ_RELATIONSHIPS table and associated with hz_relationships.party_id.

For the contact information below the customer contact, use the PARTY_ID of HZ_CUST_ACCOUNT_ROLES to associate owner_table_id

Customer's tax

HZ_CODE_ASSIGNMENTS Accounting Classification / customer headline / location level

Field

OWNER_TABLE_NAME associated table name / 'ZX_PARTY_TAX_PROFILE'

OWNER_TABLE_ID associated table primary key / PARTY_TAX_PROFILE_ID

CLASS_CODE Accounting Classification Code

ZX_PARTY_TAX_PROFILE Vendor tax profile

Field

PARTY_TYPE_CODE type THIRD_PARTY/THIRD_PARTY_SITE

PARTY_ID association table HZ_PARTIES/HZ_PARTY_SITES

Front layer: PARTY_TYPE_CODE = 'THIRD_PARTY'

AND PARTY_ID = HZ_PARTIES.PARTY_ID

Location layer: PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'

AND PARTY_ID = HZ_PARTY_SITES.PARTY_SITE_ID

REP_REGISTRATION_NUMBER tax Registration number

PARTY_TAX_PROFILE_ID primary key

Description of HZ_CLASS_CODE_DENORM Accounting Classification

ZX_EXEMPTIONS customer tax exemption / customer headline / location tier

Field

PARTY_TAX_PROFILE_ID Associated ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID

Customer location

HZ_PARTY_SITES

Location address

HZ_LOCATIONS

Customer location account table

HZ_CUST_ACCT_SITES_ALL

Customer location business purpose

HZ_CUST_SITE_USES_ALL

Late payment fee

HZ_CUSTOMER_PROFILES

SELECT * FROM apps.gl_period_statuses_v;-period, take period view

SELECT * FROM apps.hr_operating_units;-Business entity View

Tax related table

SELECT * FROM zx_lines_det_factors;-Table of tax Determinants

SELECT * FROM zx_lines;-tax bank

Note: module tax receivable only includes this table.

Ra_customer_trx_all invoice Receivable

Invoice number: customer_trx _ id

Customer Bill to number: bill_to_site_use_id

Salesperson number: primary_sales_id

Reference is an external number input box provided by Oracle, but due to version problems and length (

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.