How To Update Attributes For Fa_mass_additions
 |  |  |  |  |  |  |  | |
| Previous | Side by side | Contents | Alphabetize | Navigation | Glossary | Library |
FA_MASS_ADDITIONS Interface Tabular array
You lot tin can either load the column directly from your other system, or you can fill in some values in the Mass Additions window before yous 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 straight or enter it in the Mass Additions window before you post.
ACCOUNTING_DATE Appointment REQUIRED
Use this column for the accounting appointment of the invoice. The Unposted Mass Additions Study reports on this date.ADD_TO_ASSET_ID NUMBER(15) NULL
Do not utilize this column.AMORTIZE_FLAG VARCHAR2(three) Zero
Practise not use this column.AP_DISTRIBUTION_ LINE_NUMBER NUMBER(fifteen) OPTIONAL
Use this column for the distribution line number. The value must be a valid in the AP_DISTRIBUTION_LINE_NUMBER column on the tabular array 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 Nugget Data .ASSET_KEY_CCID NUMBER(fifteen) OPTIONAL PREP
Use this column for the code combination id that corresponds to the asset key. Utilize an enabled value from the CODE_COMBINATION_ID column of the FA_ASSET_KEYWORDS tabular array.ASSET_NUMBER VARCHAR2(xv) OPTIONAL PREP
This column is a unique external identifier for avails. If you enter a value in this column information technology 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 nugget number using automatic numbering, in which case the asset number is the same as the nugget id.ASSET_TYPE VARCHAR2(11) REQUIRED PREP
Use this cavalcade for the asset blazon of the nugget. Enter one of the following values:
| CAPITALIZED | For your capitalized avails |
| CIP | For your construction-in-process (CIP) avails. |
| EXPENSED | For your expensed avails. |
ASSIGNED_TO NUMBER(xv) 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 aforementioned as the external identifier EMPLOYEE_NUMBER.ATTRIBUTE_ CATEGORY_CODE VARCHAR2(xxx) NULL
Do non use this column.ATTRIBUTE1 through ATTRIBUTE30 VARCHAR2(150) NULL
Exercise non use these columns.Attending: This descriptive flexfield is Not the same ane equally on FA_ADDITIONS.
BEGINNING_NBV NUMBER OPTIONAL
Do not use this cavalcade.BOOK_TYPE_CODE VARCHAR2(15) REQUIRED
Use this column for the book to which you desire to assign the asset. Yous must choose a volume that you have prepare up in the Book Controls window, and the book class must exist CORPORATE. Values in this column must be in upper case.CREATE_BATCH_DATE DATE OPTIONAL
Use this cavalcade for the appointment you load this asset into the FA_MASS_ ADDITIONS tabular array.CREATE_BATCH_ID NUMBER(15) OPTIONAL
Apply the value 1 for this column to distinguish it from subsequent Mass Additions for a conversion, or utilize the same number for all mass additions from your payables system that you load at in one case.CREATED_BY NUMBER(xv) REQUIRED
Use the value 1 in this cavalcade, or the specific user id of the person working on the import.CREATION_DATE Appointment REQUIRED
Use this cavalcade for the date you lot load this asset into the FA_MASS_ ADDITIONS table.DATE_ PLACED_IN_SERVICE Date REQUIRED PREP
Use this column for the engagement you placed the nugget in service.DEPRECIATE_FLAG VARCHAR2(3) REQUIRED PREP
Apply this cavalcade to indicate if you want Oracle Assets to depreciate this asset. If you lot want to calculate depreciation on this asset, enter Yep in this column. If you lot do non want to calculate depreciation, enter NO.DEPRN_RESERVE NUMBER OPTIONAL
Use this column for the accumulated depreciation of the asset equally it currently appears in your general ledger. Yous can enter a value, or have Oracle Assets calculate information technology.Description VARCHAR2(lxxx) REQUIRED PREP
Use this cavalcade for a description of the asset.EXPENSE_CODE_ COMBINATION_ID NUMBER(15) REQUIRED PREP
Utilize this cavalcade for the lawmaking combination id of the full general ledger business relationship 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 procedure. Apply a word like CONVERSION or PAYABLES to announce the nature of the import.FIXED_ASSETS_COST NUMBER REQUIRED PREP
Use this cavalcade for the price of the asset as it currently appears in your general ledger.FIXED_ASSETS_UNITS NUMBER(fifteen) REQUIRED PREP
Use this column for the number of units that make up the asset. You must apply 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 practise not revalue your assets, do not employ this column.INVOICE_CREATED_BY NUMBER(15) Zippo
Exercise not use this column.INVOICE_DATE Appointment NULL
Do not use this column.INVOICE_ID NUMBER(15) OPTIONAL
Employ this cavalcade for the invoice id, if available. Use the advisable 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(fifteen) OPTIONAL
Use this cavalcade for the invoice number for this asset, if available.INVOICE_UPDATED_BY NUMBER(15) Naught
Exercise not use this column.LAST_UPDATE_DATE Date REQUIRED
Utilise this column for the date you load this nugget 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 Nugget Information .MASS_ADDITION_ID NUMBER(15) REQUIRED
Oracle Avails 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 cavalcade.MANUFACTURER_ NAME VARCHAR2(xxx) OPTIONAL PREP
Utilize this column for the name of the manufacturer of the nugget.MERGE_ INVOICE_NUMBER VARCHAR2(50) OPTIONAL
Optionally set up this column to INVOICE_NUMBER for unmerged lines.MERGE_ VENDOR_NUMBER VARCHAR2(xxx) OPTIONAL
Optionally set this cavalcade to VENDOR_NUMBER for unmerged lines.MODEL_NUMBER VARCHAR2(twoscore) OPTIONAL PREP
Use this column for the model number of the asset.NEW_MASTER_FLAG VARCHAR2(3) Null
Practise not utilize this column.PARENT_ASSET_ID NUMBER(xv) OPTIONAL
If you are importing asset information from another payables system, use this column for the asset id of the parent nugget if this asset is a subcomponent of another asset. The parent asset must be an existing asset. Annotation that ASSET_ID is the unique internal identifier, and non the same equally the external identifier ASSET_NUMBER.For a conversion, do not utilize this column. If an asset is a subcomponent, you tin enter this human relationship in the Subcomponents window subsequently you post.
PARENT_ MASS_ADDITION_ID NUMBER(fifteen) Naught
Practise not use this column.PAYABLES_ BATCH_NAME VARCHAR2(50) NULL
Do not use this column.PAYABLES_CODE_ COMBINATION_ID NUMBER(xv) REQUIRED
Use this column for the lawmaking combination id of the nugget clearing business relationship you assigned to the asset category. See: Importing Your Nugget Data .PAYABLES_COST NUMBER REQUIRED
Use this column for the original cost of the asset. If you practice not take the original cost of the nugget, employ the nugget cost as it appears in the full general ledger.PAYABLES_UNITS NUMBER REQUIRED
Utilize this column for the number of units that make up the asset. You must utilise a positive integer value. Apply the same value in this column that y'all utilise in the FIXED_ASSETS_UNITS cavalcade.PO_NUMBER VARCHAR2(15) OPTIONAL PREP
Use this column for the buy order number for this asset, if bachelor.PO_VENDOR_ID NUMBER(15) OPTIONAL
Utilize this column for the supplier id. Come across: Importing Your Nugget Information .POST_BATCH_ID NUMBER(15) NULL
Do not use this column.POSTING_STATUS VARCHAR2(15) REQUIRED
To import asset information from another payables organisation, use the value NEW or ON HOLD for this column if you want to review this nugget in the Mass Additions window.Employ the value Postal service for this column if y'all are entering all required information and want to post the nugget immediately, such as for a conversion.
PRODUCTION_CAPACITY NUMBER OPTIONAL
Apply this column for the chapters of a units of production asset. If you lot do not enter a capacity, Oracle Avails uses the chapters from the asset category. If this asset is not a units of product asset, do non employ this cavalcade.QUEUE_NAME VARCHAR2(15) REQUIRED
Use the aforementioned value yous entered into the POSTING_STATUS cavalcade (e.yard. 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 cavalcade.REVAL_RESERVE NUMBER OPTIONAL
Use this column for the revaluation reserve of a revalued asset. If y'all do not revalue your assets, do non use this column.REVIEWER_ COMMENTS VARCHAR2(60) OPTIONAL
Use this column to annotation that this asset came from a import process and any other details nearly this asset.SALVAGE_VALUE NUMBER OPTIONAL
Employ this column for the relieve value of the asset, if available.SERIAL_NUMBER VARCHAR2(35) OPTIONAL PREP
Use this column for the series number of the asset.SPLIT_MERGED_CODE VARCHAR2(iii) Nothing
Exercise non utilize this column.TAG_NUMBER VARCHAR2(15) OPTIONAL PREP
Use this column for the nugget tag number if required. You lot tin use this column for barcode values if y'all rails assets past barcodes. Oracle Avails allows no duplicate values except null.UNIT_OF_MEASURE VARCHAR2(25) OPTIONAL
Utilize this column for the unit of measurement of measure for a units of production asset. If you lot practise not enter a unit of measure, Oracle Assets uses the unit of mensurate from the nugget category. If this asset is not a units of production asset, practise not use this column.UNREVALUED_COST NUMBER OPTIONAL
Use this cavalcade for the cost without regard to any revaluations of a revalued asset. If you practice not revalue your assets, exercise non apply this cavalcade.VENDOR_NUMBER VARCHAR2(15) Nothing
Do not utilise this column.YTD_DEPRN NUMBER OPTIONAL
Apply this column for the year-to-date depreciation of the nugget as information technology currently appears in your general ledger. You can enter a value, or accept Oracle Assets summate information technology for an asset with a engagement placed in service in a prior period.YTD_REVAL_ DEPRN_EXPENSE NUMBER OPTIONAL
Employ this column for the yr-to-date depreciation expense due to revaluation of a revalued asset. If you do not revalue your assets, do not employ this column.See Also
Nigh the Mass Additions Open InterfacePlanning 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 |
Source: https://docs.oracle.com/cd/A60725_05/html/comnls/us/fa/maoi04.htm
Posted by: menendezyoures.blogspot.com
0 Response to "How To Update Attributes For Fa_mass_additions"
Post a Comment