可以利用PL/SQL直接导入固定资产接口,实现成批添加资产,表名:FA_MASS_ADDITIONS 和 FA_MASSADD_DISTRIBUTIONS . FA_MASSADD_DISTRIBUTIONS在资产存在多个分配的时候才需要导入,否则仅使用FA_MASS_ADDITIONS就可以了。
接口表字段说明如下:
[@more@]表名:FA_MASS_ADDITIONS MASS_ADDITION_ID | 成批增加ID |
ASSET_NUMBER | 资产编号 |
TAG_NUMBER | 资产标签号 |
DESCRIPTION | 描述 |
ASSET_CATEGORY_ID | 资产类别ID |
MANUFACTURER_NAME | 供应商 |
SERIAL_NUMBER | 资产序列号 |
MODEL_NUMBER | 资产型号 |
BOOK_TYPE_CODE | 帐簿名称 |
DATE_PLACED_IN_SERVICE | 启用日期 |
FIXED_ASSETS_COST | 资产原值 |
PAYABLES_UNITS | 资产数量 |
FIXED_ASSETS_UNITS | 资产数量 |
PAYABLES_CODE_COMBINATION_ID | 分配给资产类别的资产结算帐户代码 |
EXPENSE_CODE_COMBINATION_ID | 折旧费用帐户标识 |
LOCATION_ID | 资产地点标识 |
ASSIGNED_TO | 员工标识 |
FEEDER_SYSTEM_NAME | 资产导入流程名 |
CREATE_BATCH_DATE | 事务处理日期,大于当前日期 |
CREATE_BATCH_ID | 可以使用值1 |
LAST_UPDATE_DATE | 最后更新日期 |
LAST_UPDATED_BY | 可以使用值1 |
REVIEWER_COMMENTS | |
INVOICE_NUMBER | |
VENDOR_NUMBER | |
PO_VENDOR_ID | |
PO_NUMBER | |
POSTING_STATUS | 成批增加状态 |
QUEUE_NAME | 队列状态 |
INVOICE_DATE | |
INVOICE_CREATED_BY | |
INVOICE_UPDATED_BY | |
PAYABLES_COST | 原值 |
INVOICE_ID | |
PAYABLES_BATCH_NAME | |
DEPRECIATE_FLAG | 是否折旧 |
PARENT_MASS_ADDITION_ID | |
PARENT_ASSET_ID | |
SPLIT_MERGED_CODE | |
AP_DISTRIBUTION_LINE_NUMBER | |
POST_BATCH_ID | |
ADD_TO_ASSET_ID | |
AMORTIZE_FLAG | |
NEW_MASTER_FLAG | |
ASSET_KEY_CCID | 资产关键字 |
ASSET_TYPE | 资产类型 |
DEPRN_RESERVE | 累计折旧 |
YTD_DEPRN | 本年折旧 |
BEGINNING_NBV | |
CREATED_BY | 可以使用值1 |
CREATION_DATE | 创建日期 |
LAST_UPDATE_LOGIN | 可以使用值1 |
SALVAGE_VALUE | 残值 |
ACCOUNTING_DATE | 发票的会计日期 |
ATTRIBUTE1 | |
ATTRIBUTE2 | |
ATTRIBUTE3 | |
ATTRIBUTE4 | |
ATTRIBUTE5 | |
ATTRIBUTE6 | |
ATTRIBUTE7 | |
ATTRIBUTE8 | |
ATTRIBUTE9 | |
ATTRIBUTE10 | |
ATTRIBUTE11 | |
ATTRIBUTE12 | |
ATTRIBUTE13 | |
ATTRIBUTE14 | |
ATTRIBUTE15 | |
ATTRIBUTE_CATEGORY_CODE | |
FULLY_RSVD_REVALS_COUNTER | |
MERGE_INVOICE_NUMBER | |
MERGE_VENDOR_NUMBER | |
PRODUCTION_CAPACITY | |
REVAL_AMORTIZATION_BASIS | |
REVAL_RESERVE | |
UNIT_OF_MEASURE | |
UNREVALUED_COST | |
YTD_REVAL_DEPRN_EXPENSE | |
ATTRIBUTE16 | |
ATTRIBUTE17 | |
ATTRIBUTE18 | |
ATTRIBUTE19 | |
ATTRIBUTE20 | |
ATTRIBUTE21 | |
ATTRIBUTE22 | |
ATTRIBUTE23 | |
ATTRIBUTE24 | |
ATTRIBUTE25 | |
ATTRIBUTE26 | |
ATTRIBUTE27 | |
ATTRIBUTE28 | |
ATTRIBUTE29 | |
ATTRIBUTE30 | |
MERGED_CODE | |
SPLIT_CODE | |
MERGE_PARENT_MASS_ADDITIONS_ID | |
SPLIT_PARENT_MASS_ADDITIONS_ID | |
PROJECT_ASSET_LINE_ID | |
PROJECT_ID | |
TASK_ID | |
SUM_UNITS | |
DIST_NAME | |
GLOBAL_ATTRIBUTE1 | |
GLOBAL_ATTRIBUTE2 | |
GLOBAL_ATTRIBUTE3 | |
GLOBAL_ATTRIBUTE4 | |
GLOBAL_ATTRIBUTE5 | |
GLOBAL_ATTRIBUTE6 | |
GLOBAL_ATTRIBUTE7 | |
GLOBAL_ATTRIBUTE8 | |
GLOBAL_ATTRIBUTE9 | |
GLOBAL_ATTRIBUTE10 | |
GLOBAL_ATTRIBUTE11 | 来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/71669/viewspace-996404/,如需转载,请注明出处,否则将追究法律责任。
上一篇:
Loadrunner 简明操作手册
下一篇:
AR事务处理GL_DATE获得逻辑
![]()
请登录后发表评论
登录
全部评论
<%=items[i].createtime%>
<%=items[i].content%> <%if(items[i].items.items.length) { %>
<%for(var j=0;j
<%}%> <%}%>
<%=items[i].items.items[j].createtime%>
<%=items[i].items.items[j].username%> 回复 <%=items[i].items.items[j].tousername%>: <%=items[i].items.items[j].content%>
还有<%=items[i].items.total-5%>条评论
) data-count=1 data-flag=true>点击查看
<%}%>
|
转载于:http://blog.itpub.net/71669/viewspace-996404/