In Oracle Apps, GL(Finance), INV (Inventory), PO (Purchasing), AP (Accounts Payable), and AR (Accounts Receivable) modules are important modules for managing procurement, accounts payable, and accounts receivable processes. Here are some important tables used in these modules:
Finance Module:
GL_CODE_COMBINATIONS:
CODE_COMBINATION_ID: Unique identifier for the account combination.
CHART_OF_ACCOUNTS_ID: Unique identifier for the chart of accounts.
SEGMENT1: First segment of the account combination.
SEGMENT2: Second segment of the account combination.
… (Additional segments based on the chart of accounts structure)
GL_JE_HEADERS:
JE_HEADER_ID: Unique identifier for the journal entry header.
JE_CATEGORY: Category of the journal entry.
JE_SOURCE: Source of the journal entry.
PERIOD_NAME: Accounting period associated with the journal entry.
CURRENCY_CODE: Currency used in the journal entry.
GL_JE_LINES:
JE_LINE_ID: Unique identifier for the journal entry line.
JE_HEADER_ID: Unique identifier linking the line to the journal entry header.
CODE_COMBINATION_ID: Account combination used in the journal entry line.
LINE_DESCRIPTION: Description of the journal entry line.
LINE_AMOUNT: Amount associated with the journal entry line.
Inventory Module:
MTL_SYSTEM_ITEMS_B:
INVENTORY_ITEM_ID: Unique identifier for the inventory item.
SEGMENT1: Item number.
ORGANIZATION_ID: Unique identifier for the organization associated with the item.
DESCRIPTION: Description of the item.
ITEM_COST: Cost of the item.
MTL_MATERIAL_TRANSACTIONS:
TRANSACTION_ID: Unique identifier for the material transaction.
TRANSACTION_TYPE_ID: Type of material transaction (receipt, issue, transfer, etc.).
TRANSACTION_DATE: Date of the material transaction.
INVENTORY_ITEM_ID: Unique identifier for the inventory item involved in the transaction.
QUANTITY: Quantity of items involved in the transaction.
MTL_TRANSACTION_LOTS:
TRANSACTION_ID: Unique identifier linking the lot to a material transaction.
LOT_NUMBER: Lot number associated with the transaction.
QUANTITY: Quantity of items in the lot.
EXPIRATION_DATE: Expiration date of the lot (if applicable).
MANUFACTURING_DATE: Manufacturing date of the lot (if applicable).
MTL_ONHAND_QUANTITIES:
ORGANIZATION_ID: Unique identifier for the organization.
INVENTORY_ITEM_ID: Unique identifier for the inventory item.
SUBINVENTORY_CODE: Code for the subinventory.
PRIMARY_UOM_CODE: Primary unit of measure for the item.
QUANTITY_ON_HAND: Quantity of the item available in the subinventory.
Purchasing (PO) Module:
PO_HEADERS_ALL: Stores information about the purchase orders such as header details, supplier information, and currency.
PO_LINES_ALL: Contains information about individual line items in a purchase order, including item details, quantities, and prices.
PO_LINE_LOCATIONS_ALL: Stores the delivery details of each line item in a purchase order.
PO_DISTRIBUTIONS_ALL: Stores the accounting distributions for each line item, including the charge account and amount.
Accounts Payable (AP) Module:
AP_INVOICES_ALL: Stores information about supplier invoices, including invoice numbers, amounts, and payment details.
AP_INVOICE_LINES_ALL: Contains information about individual invoice lines, such as item details, quantities, and prices.
AP_PAYMENT_SCHEDULES_ALL: Stores the payment schedule for each invoice, including due dates and amounts.
AP_CHECKS_ALL: Contains information about issued checks, including check numbers, amounts, and payment details.
Accounts Receivable (AR) Module:
AP_INVOICES_ALL: Stores information about supplier invoices, including invoice numbers, amounts, and payment details.
AP_INVOICE_LINES_ALL: Contains information about individual invoice lines, such as item details, quantities, and prices.
AP_PAYMENT_SCHEDULES_ALL: Stores the payment schedule for each invoice, including due dates and amounts.
AP_CHECKS_ALL: Contains information about issued checks, including check numbers, amounts, and payment details.
Accounts Receivable (AR) Module:
AR_CUSTOMERS: Stores information about customers, including customer names, addresses, and contact details.
AR_INVOICES_ALL: Contains information about customer invoices, including invoice numbers, amounts, and payment details.
AR_PAYMENT_SCHEDULES_ALL: Stores the payment schedule for each customer invoice, including due dates and amounts.
AR_RECEIVABLE_APPLICATIONS_ALL: Stores information about the applications of payments to invoices, including applied amounts and dates.