BASE TABLES AND INTERFACE TABLES
| PA | Interface |
| PA_PROJECTS_ALL | API: PA_PROJECT_PUB. |
| PA_TASKS | |
| PA_EXPENDITURES_ALL | |
| PA_EXPENDITURE_ITEMS_ALL | |
| PA_EXPENDITURE_CATEGORIES | |
| PA_BUDGET_LINES | |
| PA_BUDGET_VERSIONS | |
| PA_PERIODS_ALL |
General Ledger
| GL | GL INTERFACE TABLES |
| GL_JE_HEADERS | GL_INTERFACE |
| GL_JE_LINES | GL_INTERFACE_HISTORY |
| GL_JE_BATCHES | GL_DAILY_RATES_INTERFACE |
| GL_JE_CATEGORIES | GL_BUDGET_INTERFACE |
| GL_JE_SOURCES | |
| GL_LEDGERS | |
| GL_DAILY_RATES | |
| GL_CODE_COMBINATIONS | |
| GL_BALANCES | |
| GL_PERIODS | |
| GL_PERIOD_SET | |
| GL_CURRENCIES | |
| GL_HISTORICAL_RATES | |
| GL_LOOKUPS |
Account payables
| AP | AP INTERFACE TABLES |
| AP_SUPPLIERS | AP_SUPPLIERS_INT |
| AP_SUPPLIER_SITES_ALL | AP_SUPPLIER_SITES_INT |
| AP_SUPPLIER_CONTACTS | AP_SUP_SITE_CONTACT_INT |
| IBY_EXT_BANK_ACCOUNTS | AP_INVOICES_INTERFACE |
| IBY_EXTERNAL_PAYEES_ALL | AP_INVOICE_LINE_INTERFACE |
| IBY_PMT_INSTR_USES_ALL | ERROR TABLE |
| AP_INTERFACE_REJECTIONS | |
| AP_INVOICES_ALL | |
| AP_INVOICE_LINES_ALL | |
| AP_INVOICE_DISTRIBUTIONS_ALL | |
| AP_PAYMENT_SCHEDULES_ALL | |
| AP_INVOICE_PAYMENT_ALL | |
| AP_PAYMENT_HISTORY_ALL |
Purchasing PO
| PO | PO INTERFACE TABLES |
| PO_HEADERS_ALL | PO_HEADER_INTERFACE |
| PO_LINES_ALL | PO_LINES_INTERFACE |
| PO_LINE_LOCATIONS_ALL | PO_LINE_LOCATIONS_INTERFACE |
| PO_DISTRIBUTIONS_ALL | PO_DISTRIBUTIONS_INTERFACE |
| PO_RELEASES_ALL | PO_REQUISITIONS_INTERFACE_ALL |
| PO_AGENTS | PO_REQ_DIST_INTERFACE_ALL |
| PO_ACTION_HISTORY | |
| REQ BASE TABLES | ERROR TABLE |
| PO_REQUISITION_HEADERS_ALL | PO_INTERFACE_ERRORS |
| PO_REQUISITIONS_LINES_ALL | |
| PO_REQ_DISTRIBUTIONS_ALL | |
| RECEIPTS BASE TABLES | |
| RCV_SHIPMENTS_HEADERS | |
| RCV_SHIPMENT_LINES | |
| RCV_TRANSACTIONS |
Account Receivables:
| AR | AR INTERFACE TABLES |
| RA_CUSTOMER_TRX_ALL | |
| RA_CUSTOMER_TRX_LINES_ALL | RA_INTERFACE_LINES_ALL |
| RA_CUST_TRX_LINE_GL_DIST_ALL | RA_INTERFACE_DISTRIBUTIONS_ALL |
| AR_CASH_RECEIPTS_ALL | AR_APYMENTS_INTERFACE_ALL |
| AR_CASH_RECEIPT_HISTORY_ALL | |
| AR_PAYMENT_SCHEDULES_ALL | |
| AR_RECEIVABLES_APPLICATIONS_ALL | |
| Customers | ERROR TABLE |
| HZ_PARTIES | RA_INTERFACE_ERRORS_ALL |
| HZ_CUST_ACCOUNTS | |
| HZ_CUST_ACCT_SITES_ALL | |
| HZ_CUST_SITES_USES_ALL | |
| HZ+PATRY_SITES | |
| HZ_LOCATIONS | |
| RA_CUST_TRX_TYPES_ALL |
Some Important tables
| SOME IMP BASE TABLES |
| FND_USER |
| FND_APPLICATION_VL |
| FND_CONCURRENT_PROGRAMS |
| FNS_EXECUTABLES |
| FND_CONCURRENT_REQUEST |
| FND_TABLES |
| FND_FORM |
| FND_PROFILE_OPTIONS |
| FND_PRODUCT_GROUPS |
| FND_PRODUCT_DEPENDENCIES |
| ORG_ORGANIZATION_DEFINITIONS |
| PER_ALL_PEOPLE_F |
| HR_LOCATIONS |
Types of Tables in Apps
| Table Type | Reason |
| _B | main base table |
| _ALL | Contains Mulit-Org data |
| _V | View created on base table |
| _TL | Table that support multi-language |
| _VL | View created on multi-language tables. this kind of view generally use base tables and TL tables |
| _S | Sequence table |
| _F | This are the data tracking tables. generally seen in HRMS and commonly seen columns like effective_Start_Date and effective_end_date |
No comments:
Post a Comment