Home » Applications » Oracle Fusion Apps & E-Business Suite » can any one gives the columns of these tables
can any one gives the columns of these tables [message #269660] Mon, 24 September 2007 00:47 Go to next message
shruthy
Messages: 21
Registered: July 2007
Junior Member
hai all

can any one pls give me all the "NOT NULL COLUNS", "REQUIRED COLUMNS" AND "OPTIONAL COLUMNS" of the following tables.

pls dont give the link to metalink as i do not have an access to metalink

if u have any idea of any source from where i can know the all the columns pls give that source so that i will know my self

u can also mail to my mail id : shruthy.apps@gmail.com

pls this is urgent

FOR GL:

gl_daily_rates

gl_je_batches, gl_je_headers, and gl_je_lines

fnd_id_fles_structure and fnd_descriptive_flexs

fnd_flex_value_norm_hierarchy

gl_import_references

gl_interface_history

gl_posting_interim

gl_alloc_interim

gl_translation_interim

gl_archieve_balances

gl_archieve_batches

gl_archieve_headers

gl_archieve_lines

gl_budget_interim

gl_budget_range_interim

gl_code_combinations

gl_daily_conversion_types

gl_budget_interface

gl_historical_rates

fnd_currencies

gl_periods

gl_period_sets

gl_period_statuses

gl_sets_of_books

fnd_flex_values

fnd_concurrent_requests

fnd_users


FOR AP:

po-vendors_all

po_vendor_sites_all

po_vendor_contacts_all

ap_invoices_all

ap_invoice_lines_all

ap_invoice_headers_all

ap_payment_schedules_all

ap_chrg_allocations_all

ap_invoice_distributions_all

ap_checks_all

ap_bank_accounts-all

ap_invoice_payments_all

ap_accounting_events-all

ap_lookup_codes

ap_expense_reports_headers_all

ap_expense_reports_lines_all

ap_income_tax_regions

ap_distribution_sets

ap_tax_codes

ap_terms

ap_card-codes

ap_card_code-sets

ap-expense_feed_lines

ap-expense-feed_dists_all

ap_credit_card_trxns_all

ap_ae_headers_all

ap_ae_lines_all

ap_suppliers_int

ap_supplier_sites_int

ap_sup_site_contact_int

FOR AR:

ra_cust_trx_types

ra_customers_interface

ra_contact_phones_interface

ra_customer_profiles_interface

ra_customer_banks_interface

ra_cust_pay_method_interface

ar_location_combinations

ra_terrotories

ra_interface_errors_all


thanks in advance

hope everyone received will respond

thank you

bye




Re: can any one gives the columns of these tables [message #269665 is a reply to message #269660] Mon, 24 September 2007 00:57 Go to previous messageGo to next message
merlinrajesh
Messages: 105
Registered: November 2006
Location: Chennai
Senior Member

Hi Sruthy

In Toad, type the table name and Press F4. You ll get the list of coloumns and the required or optional value...

Regards
Merlin Rajesh
Re: can any one gives the columns of these tables [message #269672 is a reply to message #269660] Mon, 24 September 2007 01:29 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
By the way what is the difference between
Quote:
"NOT NULL COLUMNS", "REQUIRED COLUMNS"
?

Also don't you know the sql*plus command DESCRIBE?

By
Vamsi

[Updated on: Mon, 24 September 2007 01:30]

Report message to a moderator

Re: can any one gives the columns of these tables [message #269712 is a reply to message #269660] Mon, 24 September 2007 04:58 Go to previous message
san4u
Messages: 42
Registered: September 2007
Location: bangalore
Member

HI,

Open the Toad and write the base table name and hit the F4 button and u can check the ur required details.

thx..
Sankar

[Updated on: Mon, 24 September 2007 05:19]

Report message to a moderator

Previous Topic: what are the base tables for this report???
Next Topic: AP Error
Goto Forum:
  


Current Time: Mon Jul 01 03:37:41 CDT 2024