EBS Org Tables

发件人 Blogger 图片

发件人 Blogger 图片

GL_SETS_OF_BOOKS
stores information about the sets of books you define in your Oracle General Ledger application. Each row includes the set of books name, description, functional currency, and other information. This table corresponds to the Set of Books form.

HR_ALL_ORGANIZATION_UNITS
HR_ALL_ORGANIZATION_UNITS holds the definitions that identify business groups and the organization units within a single business group.Additional information about classifications and information types for each organization is held in HR_ORGANIZATION_INFORMATION.

MTL_PARAMETERS
MTL_PARAMETERS maintains a set of default options like general ledger accounts; locator, lot, and serial controls; inter-organization options; costing method; etc. for each organization defined in Oracle Inventory.

Each organization's item master organization (MASTER_ORGANIZATION_ID) and costing organization (COST_ORGANIZATION_ID) are maintained here.

You specify which manufacturing calendar the organization will use (CALENDAR_CODE), as well as the set of exceptions to this calendar
(CALENDAR_EXCEPTION_SET_ID).

NEGATIVE_INV_RECEIPT_CODE indicates whether this organization will allow negative balances in inventory. It is used in the transaction system to ensure, for example, that you do not over-issue a particular item (if you have indicated that negative balances are not allowed).

For lot number and serial number auto-generation, you can specify whether you want the numbers generated from defaults defined at theorganization level or the item level (LOT_NUMBER_GENERATION,SERIAL_NUMBER_GENERATION). You can also specify uniqueness constraints for lot numbers (LOT_NUMBER_UNIQUENESS) and serial numbers (SERIAL_NUMBER_TYPE).

Among the accounting defaults that can be defined here are valuation accounts, receiving accounts, profit and loss accounts, and inter-organization transfer accounts.