Previous  Next          Contents  Index  Navigation  Glossary  Library

FA_MASS_ADDITIONS Interface Table

The database definition of the FA_MASS_ADDITIONS table does not require that you provide values for any columns, but in order for the Mass Additions Posting program to work properly, you must follow the rules in the following list of column descriptions. The Mass Additions Posting program uses some of the columns in the FA_MASS_ADDITIONS table, so these columns are marked NULL. Do not import your data into columns marked NULL. You must fill columns marked REQUIRED before you run Mass Additions Post.

You can either load the column directly from your other system, or you can fill in some values in the Mass Additions window before you post. Columns marked OPTIONAL are for optional asset information that you can track if you want. VARCHAR2 columns are case sensitive.

For columns marked PREP you can either import information into the column directly or enter it in the Mass Additions window before you post.

ACCOUNTING_DATE DATE REQUIRED

Use this column for the accounting date of the invoice. The Unposted Mass Additions Report reports on this date.

ADD_TO_ASSET_ID NUMBER(15) NULL

Do not use this column.

AMORTIZE_FLAG VARCHAR2(3) NULL

Do not use this column.

AP_DISTRIBUTION_ LINE_NUMBER NUMBER(15) OPTIONAL

Use this column for the distribution line number. The value must be a valid in the AP_DISTRIBUTION_LINE_NUMBER column on the table AP_INVOICE_DISTRIBUTIONS, and tied to the INVOICE_ID given above.

ASSET_CATEGORY_ID NUMBER(15) REQUIRED PREP

Use this column for the category id that corresponds with the asset category of the asset. See: Importing Your Asset Information .

ASSET_KEY_CCID NUMBER(15) OPTIONAL PREP

Use this column for the code combination id that corresponds to the asset key. Use an enabled value from the CODE_COMBINATION_ID column of the FA_ASSET_KEYWORDS table.

ASSET_NUMBER VARCHAR2(15) OPTIONAL PREP

This column is a unique external identifier for assets. If you enter a value in this column it is used for asset numbering. The numbers you supply must be unique. It identifies the asset in Oracle Assets windows and reports. If you leave this column blank Oracle Assets assigns an asset number using automatic numbering, in which case the asset number is the same as the asset id.

ASSET_TYPE VARCHAR2(11) REQUIRED PREP

Use this column for the asset type of the asset. Enter one of the following values:

CAPITALIZED For your capitalized assets
CIP For your construction-in-process (CIP) assets.
EXPENSED For your expensed assets.

ASSIGNED_TO NUMBER(15) OPTIONAL PREP

Use this column for the employee id of the employee responsible for this asset. Use a value from the EMPLOYEE_ID column in FA_EMPLOYEES. Note that EMPLOYEE_ID is the unique internal identifier, and not the same as the external identifier EMPLOYEE_NUMBER.

ATTRIBUTE_ CATEGORY_CODE VARCHAR2(30) NULL

Do not use this column.

ATTRIBUTE1 through ATTRIBUTE30 VARCHAR2(150) NULL

Do not use these columns.

Attention: This descriptive flexfield is NOT the same one as on FA_ADDITIONS.

BEGINNING_NBV NUMBER OPTIONAL

Do not use this column.

BOOK_TYPE_CODE VARCHAR2(15) REQUIRED

Use this column for the book to which you want to assign the asset. You must choose a book that you have set up in the Book Controls window, and the book class must be CORPORATE. Values in this column must be in upper case.

CREATE_BATCH_DATE DATE OPTIONAL

Use this column for the date you load this asset into the FA_MASS_ ADDITIONS table.

CREATE_BATCH_ID NUMBER(15) OPTIONAL

Use the value 1 for this column to distinguish it from subsequent Mass Additions for a conversion, or use the same number for all mass additions from your payables system that you load at once.

CREATED_BY NUMBER(15) REQUIRED

Use the value 1 in this column, or the specific user id of the person working on the import.

CREATION_DATE DATE REQUIRED

Use this column for the date you load this asset into the FA_MASS_ ADDITIONS table.

DATE_ PLACED_IN_SERVICE DATE REQUIRED PREP

Use this column for the date you placed the asset in service.

DEPRECIATE_FLAG VARCHAR2(3) REQUIRED PREP

Use this column to indicate if you want Oracle Assets to depreciate this asset. If you want to calculate depreciation on this asset, enter YES in this column. If you do not want to calculate depreciation, enter NO.

DEPRN_RESERVE NUMBER OPTIONAL

Use this column for the accumulated depreciation of the asset as it currently appears in your general ledger. You can enter a value, or have Oracle Assets calculate it.

DESCRIPTION VARCHAR2(80) REQUIRED PREP

Use this column for a description of the asset.

EXPENSE_CODE_ COMBINATION_ID NUMBER(15) REQUIRED PREP

Use this column for the code combination id of the general ledger account to which depreciation expense should be charged. See: Importing Your Asset Information .

FEEDER_ SYSTEM_NAME VARCHAR2(40) OPTIONAL

Use this column to note that this asset came from a import process. Use a word like CONVERSION or PAYABLES to denote the nature of the import.

FIXED_ASSETS_COST NUMBER REQUIRED PREP

Use this column for the cost of the asset as it currently appears in your general ledger.

FIXED_ASSETS_UNITS NUMBER(15) REQUIRED PREP

Use this column for the number of units that make up the asset. You must use a positive integer value.

FULLY_RSVD_ REVALS_COUNTER NUMBER OPTIONAL

Use this column for the number of times you have revalued this asset as fully reserved. If you do not revalue your assets, do not use this column.

INVOICE_CREATED_BY NUMBER(15) NULL

Do not use this column.

INVOICE_DATE DATE NULL

Do not use this column.

INVOICE_ID NUMBER(15) OPTIONAL

Use this column for the invoice id, if available. Use the appropriate value from the INVOICE_ID column of the AP_INVOICES table. Note that INVOICE_ID is the unique internal identifier, and not the same as the external identifier INVOICE_NUMBER.

INVOICE_NUMBER VARCHAR2(15) OPTIONAL

Use this column for the invoice number for this asset, if available.

INVOICE_UPDATED_BY NUMBER(15) NULL

Do not use this column.

LAST_UPDATE_DATE DATE REQUIRED

Use this column for the date you load this asset into the FA_MASS_ ADDITIONS table.

LAST_UPDATE_LOGIN NUMBER(15) REQUIRED

Use the value 1 in this column, or the specific user id of the person working on the import.

LAST_UPDATED_BY NUMBER REQUIRED

Use the value 1 in this column, or the specific user id of the person working on the import.

LOCATION_ID NUMBER(15) REQUIRED PREP

Use this column for the location id that corresponds with the location of the asset. See: Importing Your Asset Information .

MASS_ADDITION_ID NUMBER(15) REQUIRED

Oracle Assets uses this column as a unique identifier for mass additions. The values in MASS_ADDITION_ID are generally sequential. You can use a sequence generator to populate this column.

MANUFACTURER_ NAME VARCHAR2(30) OPTIONAL PREP

Use this column for the name of the manufacturer of the asset.

MERGE_ INVOICE_NUMBER VARCHAR2(50) OPTIONAL

Optionally set this column to INVOICE_NUMBER for unmerged lines.

MERGE_ VENDOR_NUMBER VARCHAR2(30) OPTIONAL

Optionally set this column to VENDOR_NUMBER for unmerged lines.

MODEL_NUMBER VARCHAR2(40) OPTIONAL PREP

Use this column for the model number of the asset.

NEW_MASTER_FLAG VARCHAR2(3) NULL

Do not use this column.

PARENT_ASSET_ID NUMBER(15) OPTIONAL

If you are importing asset information from another payables system, use this column for the asset id of the parent asset if this asset is a subcomponent of another asset. The parent asset must be an existing asset. Note that ASSET_ID is the unique internal identifier, and not the same as the external identifier ASSET_NUMBER.

For a conversion, do not use this column. If an asset is a subcomponent, you can enter this relationship in the Subcomponents window after you post.

PARENT_ MASS_ADDITION_ID NUMBER(15) NULL

Do not use this column.

PAYABLES_ BATCH_NAME VARCHAR2(50) NULL

Do not use this column.

PAYABLES_CODE_ COMBINATION_ID NUMBER(15) REQUIRED

Use this column for the code combination id of the asset clearing account you assigned to the asset category. See: Importing Your Asset Information .

PAYABLES_COST NUMBER REQUIRED

Use this column for the original cost of the asset. If you do not have the original cost of the asset, use the asset cost as it appears in the general ledger.

PAYABLES_UNITS NUMBER REQUIRED

Use this column for the number of units that make up the asset. You must use a positive integer value. Use the same value in this column that you use in the FIXED_ASSETS_UNITS column.

PO_NUMBER VARCHAR2(15) OPTIONAL PREP

Use this column for the purchase order number for this asset, if available.

PO_VENDOR_ID NUMBER(15) OPTIONAL

Use this column for the supplier id. See: Importing Your Asset Information .

POST_BATCH_ID NUMBER(15) NULL

Do not use this column.

POSTING_STATUS VARCHAR2(15) REQUIRED

To import asset information from another payables system, use the value NEW or ON HOLD for this column if you want to review this asset in the Mass Additions window.

Use the value POST for this column if you are entering all required information and want to post the asset immediately, such as for a conversion.

PRODUCTION_CAPACITY NUMBER OPTIONAL

Use this column for the capacity of a units of production asset. If you do not enter a capacity, Oracle Assets uses the capacity from the asset category. If this asset is not a units of production asset, do not use this column.

QUEUE_NAME VARCHAR2(15) REQUIRED

Use the same value you entered into the POSTING_STATUS column (e.g. NEW, ON HOLD, POST).

REVAL_ AMORTIZATION_BASIS NUMBER OPTIONAL

Use this column for the basis for amortization of revaluation reserve for a revalued asset, usually the current revaluation reserve. If you do not revalue your assets, do not use this column.

REVAL_RESERVE NUMBER OPTIONAL

Use this column for the revaluation reserve of a revalued asset. If you do not revalue your assets, do not use this column.

REVIEWER_ COMMENTS VARCHAR2(60) OPTIONAL

Use this column to note that this asset came from a import process and any other details about this asset.

SALVAGE_VALUE NUMBER OPTIONAL

Use this column for the salvage value of the asset, if available.

SERIAL_NUMBER VARCHAR2(35) OPTIONAL PREP

Use this column for the serial number of the asset.

SPLIT_MERGED_CODE VARCHAR2(3) NULL

Do not use this column.

TAG_NUMBER VARCHAR2(15) OPTIONAL PREP

Use this column for the asset tag number if required. You can use this column for barcode values if you track assets by barcodes. Oracle Assets allows no duplicate values except null.

UNIT_OF_MEASURE VARCHAR2(25) OPTIONAL

Use this column for the unit of measure for a units of production asset. If you do not enter a unit of measure, Oracle Assets uses the unit of measure from the asset category. If this asset is not a units of production asset, do not use this column.

UNREVALUED_COST NUMBER OPTIONAL

Use this column for the cost without regard to any revaluations of a revalued asset. If you do not revalue your assets, do not use this column.

VENDOR_NUMBER VARCHAR2(15) NULL

Do not use this column.

YTD_DEPRN NUMBER OPTIONAL

Use this column for the year-to-date depreciation of the asset as it currently appears in your general ledger. You can enter a value, or have Oracle Assets calculate it for an asset with a date placed in service in a prior period.

YTD_REVAL_ DEPRN_EXPENSE NUMBER OPTIONAL

Use this column for the year-to-date depreciation expense due to revaluation of a revalued asset. If you do not revalue your assets, do not use this column.

See Also

About the Mass Additions Open Interface

Planning Your Import

Defining Oracle Assets for Mass Additions

Loading Your Asset Data

Importing Your Asset Information

Finishing Your Import


         Previous  Next          Contents  Index  Navigation  Glossary  Library