FA_MASS_ADDITIONS 接口表
FA_MASS_ADDITIONS 表的数据库定义不要求为任何栏提供值,但是为了使“成批增加过帐”程序正常运行,您必须遵循以下栏说明列表中的规则。由于“成批增加过帐”程序使用 FA_MASS_ADDITIONS 表中的某些栏,因此这些栏均标记为“空”。请勿将数据导入标记为“空”的栏。在运行“成批增加过帐”之前,您必须填入标记为“要求”的栏。
您可以直接从其它系统中装入栏,或在过帐之前在“成批增加”窗口中填入某些值。标记为“可选”的栏用于您需要时可以跟踪的可选资产信息。“可变字符 2”栏可以区分大小写。
对于标记为 PREP 的栏,您可以直接将信息导入栏或在过帐之前在“成批增加”窗口中输入。
ACCOUNTING_DATE DATE REQUIRED
此栏用于填入发票的会计日期。“未过帐成批增加报表”将在此日期报告。
ADD_TO_ASSET_ID NUMBER(15) NULL
请勿使用此栏。
AMORTIZE_FLAG VARCHAR2(3) NULL
请勿使用此栏。
AP_DISTRIBUTION_ LINE_NUMBER NUMBER(15) OPTIONAL
此栏用于填入分配行号。AP_INVOICE_DISTRIBUTIONS 表 AP_DISTRIBUTION_LINE_NUMBER 栏中的值必须有效,并与上面给定的 INVOICE_ID 相关。
ASSET_CATEGORY_ID NUMBER(15) REQUIRED PREP
此栏用于填入与资产的资产类别相符的类别标识。请参阅:导入资产信息
ASSET_KEY_CCID NUMBER(15) OPTIONAL PREP
此栏用于填入与资产关键字相符的代码组合标识。请使用 FA_ASSET_KEYWORDS 表 CODE_COMBINATION_ID 栏中的已启用值。
ASSET_NUMBER VARCHAR2(15) OPTIONAL PREP
此栏是资产的唯一外部标识。如果您在此栏中输入值,则它将用于资产编号。您提供的编号必须是唯一的。它可以标识 Oracle 资产管理系统窗口和报表中的资产。如果您将此栏留空,则 Oracle 资产管理系统将使用自动编号来指定资产编号,此时资产编号与资产标识相同。
ASSET_TYPE VARCHAR2(11) REQUIRED PREP
此栏用于填入资产的资产类型。请输入以下一个值:
资本化 | 用于资本化资产 |
CIP | 用于在建工程 (CIP) 资产。 |
费用性 | 用于费用性资产。 |
ASSIGNED_TO NUMBER(15) OPTIONAL PREP
此栏用于填入对此资产负责的员工的员工标识。使用 FA_EMPLOYEES 中 EMPLOYEE_ID 栏的值。请注意 EMPLOYEE_ID 是唯一内部标识,并与外部标识 EMPLOYEE_NUMBER 不同。
ATTRIBUTE_ CATEGORY_CODE VARCHAR2(30) NULL
请勿使用此栏。
ATTRIBUTE1 through ATTRIBUTE30 VARCHAR2(150) NULL
请勿使用这些栏。
注意:此说明性弹性域与 FA_ADDITIONS 中的不同。
BEGINNING_NBV NUMBER OPTIONAL
请勿使用此栏。
BOOK_TYPE_CODE VARCHAR2(15) REQUIRED
此栏用于填入您要指定资产的帐簿。您必须选择已在“帐簿控制”窗口中设置并且帐簿分类为“公司”的帐簿。此栏中的值必须大写。
CREATE_BATCH_DATE DATE OPTIONAL
此栏用于填入您将此资产装入 FA_MASS_ ADDITIONS 表的日期。
CREATE_BATCH_ID NUMBER(15) OPTIONAL
使用此栏中的值 1 将其与用于转换的后续“成批增加”区分开来,或使用与您要装入的应付款系统所有成批增加相同的编号。
CREATED_BY NUMBER(15) REQUIRED
使用此栏中的值 1,或运行此导入程序的人员的特定用户标识。
CREATION_DATE DATE REQUIRED
此栏用于填入您将此资产装入 FA_MASS_ ADDITIONS 表的日期。
DATE_ PLACED_IN_SERVICE DATE REQUIRED PREP
此栏用于填入启用资产的日期。
DEPRECIATE_FLAG VARCHAR2(3) REQUIRED PREP
使用此栏以指明您是否要使用 Oracle 资产管理系统对此资产进行折旧。如果要对此资产计算折旧,请在此栏中输入“是”。如果不计算折旧,则输入“否”。
DEPRN_RESERVE NUMBER OPTIONAL
此栏用于填入当前总帐中显示的资产累计折旧。您可以输入一个值,或使用 Oracle 资产管理系统进行计算。
DESCRIPTION VARCHAR2(80) REQUIRED PREP
此栏用于填入资产的折旧。
EXPENSE_CODE_ COMBINATION_ID NUMBER(15) REQUIRED PREP
此栏用于填入折旧费用应记入的总帐帐户代码组合标识。请参阅:导入资产信息
FEEDER_ SYSTEM_NAME VARCHAR2(40) OPTIONAL
使用此栏,您可以注明此资产来自导入流程。请使用“转换”或“应付款”之类的词来指明导入的原始状态。
FIXED_ASSETS_COST NUMBER REQUIRED PREP
此栏用于填入当前总帐中显示的资产成本。
FIXED_ASSETS_UNITS NUMBER(15) REQUIRED PREP
此栏用于填入组成资产的数量。您必须使用正整数值。
FULLY_RSVD_ REVALS_COUNTER NUMBER OPTIONAL
此栏用于填入您重估提完折旧资产的次数。如果未重估资产,请勿使用此栏。
INVOICE_CREATED_BY NUMBER(15) NULL
请勿使用此栏。
INVOICE_DATE DATE NULL
请勿使用此栏。
INVOICE_ID NUMBER(15) OPTIONAL
此栏用于填入发票标识(如果适用)。请使用 AP_INVOICES 表 INVOICE_ID 栏中相应的值。请注意,INVOICE_ID 是唯一内部标识,并与外部标识 INVOICE_NUMBER 不同。
INVOICE_NUMBER VARCHAR2(15) OPTIONAL
此栏用于填入资产的发票编号(如果适用)。
INVOICE_UPDATED_BY NUMBER(15) NULL
请勿使用此栏。
LAST_UPDATE_DATE DATE REQUIRED
此栏用于填入您将此资产装入 FA_MASS_ ADDITIONS 表的日期。
LAST_UPDATE_LOGIN NUMBER(15) REQUIRED
使用此栏中的值 1,或运行此导入程序的人员的特定用户标识。
LAST_UPDATED_BY NUMBER REQUIRED
使用此栏中的值 1,或运行此导入程序的人员的特定用户标识。
LOCATION_ID NUMBER(15) REQUIRED PREP
此栏用于填入与资产地点相符的地点标识。请参阅:导入资产信息
MASS_ADDITION_ID NUMBER(15) REQUIRED
Oracle 资产管理系统使用此栏作为成批增加的唯一标识。MASS_ADDITION_ID 中的值通常是连续的。您可以使用序列生成器来填写此栏。
MANUFACTURER_ NAME VARCHAR2(30) OPTIONAL PREP
此栏用于填入资产制造商的名称。
MERGE_ INVOICE_NUMBER VARCHAR2(50) OPTIONAL
(可选)此栏设置用于未合并行的 INVOICE_NUMBER。
MERGE_ VENDOR_NUMBER VARCHAR2(30) OPTIONAL
(可选)此栏设置用于未合并行的 VENDOR_NUMBER。
MODEL_NUMBER VARCHAR2(40) OPTIONAL PREP
此栏用于填入资产的型号。
NEW_MASTER_FLAG VARCHAR2(3) NULL
请勿使用此栏。
PARENT_ASSET_ID NUMBER(15) OPTIONAL
如果您从另一应付款系统导入资产信息,则在此资产为另一资产的子资产时使用此栏来填入父资产的资产标识。父资产必须为现有资产。请注意,ASSET_ID 是唯一内部标识,并与外部标识 ASSET_NUMBER 不同。
对于转换,请勿使用此栏。如果资产为子资产,您可以在过帐后在“子资产”窗口中输入此关系。
PARENT_ MASS_ADDITION_ID NUMBER(15) NULL
请勿使用此栏。
PAYABLES_ BATCH_NAME VARCHAR2(50) NULL
请勿使用此栏。
PAYABLES_CODE_ COMBINATION_ID NUMBER(15) REQUIRED
此栏用于填入您指定至资产类别的资产结算帐户代码组合标识。请参阅:导入资产信息
PAYABLES_COST NUMBER REQUIRED
此栏用于填入资产的原始成本。如果您没有资产的原始成本,请使用总帐中显示的资产成本。
PAYABLES_UNITS NUMBER REQUIRED
此栏用于填入组成资产的数量。您必须使用正整数值。并且此栏中的值与 FIXED_ASSETS_UNITS 栏中的值相同。
PO_NUMBER VARCHAR2(15) OPTIONAL PREP
此栏用于填入此资产的采购订单编号(如果适用)。
PO_VENDOR_ID NUMBER(15) OPTIONAL
此栏用于填入供应商标识。请参阅:导入资产信息
POST_BATCH_ID NUMBER(15) NULL
请勿使用此栏。
POSTING_STATUS VARCHAR2(15) REQUIRED
要从另一应付款系统导入资产信息,请在“成批增加”窗口中复核此资产时使用此栏中的“新建”或“挂起”值。
如果您要输入所有要求的信息并立即过帐资产(如用于转换),请使用此栏中的“过帐”值。
PRODUCTION_CAPACITY NUMBER OPTIONAL
此栏用于填入产量资产的能力。如果您未输入能力,则 Oracle 资产管理系统将使用资产类别的能力。如果此资产不是产量资产,请勿使用此栏。
QUEUE_NAME VARCHAR2(15) REQUIRED
使用您输入 POSTING_STATUS 栏的相同值(如新建、挂起和过帐)。
REVAL_ AMORTIZATION_BASIS NUMBER OPTIONAL
此栏用于填入重估资产的重估准备摊销基准,通常为当前重估准备。如果您不重估资产,请勿使用此栏。
REVAL_RESERVE NUMBER OPTIONAL
此栏用于填入重估资产的重估准备。如果您不对资产进行重估,请勿使用此栏。
REVIEWER_ COMMENTS VARCHAR2(60) OPTIONAL
使用此栏,您可以注明资产来自导入流程及与此资产相关的任何其它详细信息。
SALVAGE_VALUE NUMBER OPTIONAL
此栏用于填入资产的残值(如果适用)。
SERIAL_NUMBER VARCHAR2(35) OPTIONAL PREP
此栏用于填入资产的序列号。
SPLIT_MERGED_CODE VARCHAR2(3) NULL
请勿使用此栏。
TAG_NUMBER VARCHAR2(15) OPTIONAL PREP
此栏用于填入资产标签号(如果要求)。如果您按条形码跟踪资产,则可以使用此栏来填入条形码值。Oracle 资产管理系统允许填入除“空”外的不重复值。
UNIT_OF_MEASURE VARCHAR2(25) OPTIONAL
此栏用于填入产量资产的计量单位。如果您不输入计量单位,则 Oracle 资产管理系统将使用资产类别的计量单位。如果此资产不是产量资产,请勿使用此栏。
UNREVALUED_COST NUMBER OPTIONAL
此栏用于填入与重估资产的任何重估无关的成本。如果您不对资产进行重估,请勿使用此栏。
VENDOR_NUMBER VARCHAR2(15) NULL
请勿使用此栏。
YTD_DEPRN NUMBER OPTIONAL
此栏用于填入总帐中当前显示的资产年初至今折旧。您可以输入值,或使用 Oracle 资产管理系统对上一会计期中启用的资产计算折旧。
YTD_REVAL_ DEPRN_EXPENSE NUMBER OPTIONAL
此栏用于填入因重估资产的重估而发生的年初至今折旧费用。如果您不对资产进行重估,请勿使用此栏。
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
Defining Oracle Assets for Mass Additions
Importing Your Asset Information
原文链接: http://www.onejava.net/article/oracle/fa/maoi04.htm
原文链接: https://docs.oracle.com/cd/A60725_05/html/comnls/us/fa/maoi04.htm