INVENTORY:
In Inventory
level we have 3 types of tables. Those are:
1) MTL
2) CST
3) RCV
MTL:
The main
interface tables are:
a) MTL_SYSTEM_ITEMS_INTERFACE
b) MTL_ITEM_CATEGORY_INTERFACE
c) MTL_ITEM_REVISIONS_INTERFACE
d) MTL_INTERFACE_ERRORS
The main item
tables are:
a) MTL_SYSTEM_ITEM_B
b) MTL_SYSTEM_ITEM_TL
CST:
The costing tables are:
a) CST_ITEM_COSTS
b) CST_ITEM_COST_TYPES
RCV:
a) RCV_TRANSACTIONS
b) RCV_SHIPMENT_HEADERS
c) RCV_SHIPMENT_LINES
PO:
1) Requisition
Interface:
Interface tables are:
PO_requistion_interface_all
PO_requ_dist_interface_all
The
main requisition base tables are:
PO_requistion_headers_all
PO_requistion_lines_all
PO_req_distributions_all
The
Main standard concurrent program is :
Requistion_import
2) PO interface:
Interface tables are:
PO_headers_interface
PO_lines_interface
PO_distributions_interface
PO_interface_errors
Base tables:
PO_headers_all
PO_lines_all
PO_distributions_all
PO_line_locations_all
The main standard concurrent prog
is :
Standard purchase
order Import
AP:
1) Invoice
Interface:
Interface
tables are:
AP_Invoice_interface
AP_Invoice_lines_interface
AP_interface_rejection
Base tables
are:
AP_invoices_All
AP_invoice_distribution_all
AP_payment_schedules_All
2) Suppliers
Interface:
Interface tables are:
AP_suppliers_int
AP_suppliers_sites_int
AP_sup_site_contacts_int
The main supplier base
tables are:
PO_vendors
PO_vendor_sites_all
PO_vendor_contacts
3) the
holds table is: AP_holds_all
4) The
payment tables are:
AP_invoice_payments_all
AP_checks_all
AP_terms
AP_invoices_all
PO_vendors
GL:
1) GL
interface
2) Daily
rates interface
3) Budget
interface
1) GL
interface:
Interface table is: GL_INTERFACE
The main general base tables are:
GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES
2) Daily
rates interface:
Interface table is : GL_DAILY_RATES_INTERFACE
Base table is :
GL_DAILY_RATES
3) Budget
interface:
Interface table is:
GL_BUDGET_INTERFACE
Main budget tables are:
GL_BUDGETS
GL_BUDGET_TYPES
Vendors:
Vendor’s
tables are:
PO_vendors
PO_vendor_sites_All
PO_vendor_contacts
PO_agent: This table maintaining all the agent details and agent should
be an employee.
PO_releases_all: this table gets effected once you release the blanket
purchase order against to standard PO.