EBS:AP_INVOICES_ALL

最新推荐文章于 2022-05-30 19:04:48 发布
最新推荐文章于 2022-05-30 19:04:48 发布
阅读量532 收藏
点赞数
分类专栏： EBS 文章标签： oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_36620997/article/details/124439293
版权
AP_INVOICES_ALL表详细记录了Oracle Payables模块中的发票信息，包括主键、外键、供应商ID、发票号等关键字段。此表与其他多个表存在关联，涉及支付、汇率、费用报告等多个业务流程。利息发票通过AP_INVOICE_RELATIONSHIPS表与原始发票关联。此表是Oracle财务系统中处理应付账款的核心组件。
摘要由CSDN通过智能技术生成

描述：详细的发票记录

Primary Key: AP_INVOICES_PK

  1. INVOICE_ID

Primary Key: AP_INVOICES_UK1

  1. DOC_SEQUENCE_ID
  2. DOC_SEQUENCE_VALUE

Primary Key: AP_INVOICES_UK2

  1. VENDOR_ID
  2. INVOICE_NUM

Foreign Keys from this table:

Foreign Key ColumnForeign Table
AP_INVOICES_ALL.BATCH_IDAP_BATCHES_ALL
AP_INVOICES_ALL.PAYMENT_CURRENCY_CODEFND_CURRENCIES
AP_INVOICES_ALL.EXCHANGE_RATE_TYPEGL_DAILY_CONVERSION_TYPES
AP_INVOICES_ALL.PO_HEADER_IDPO_HEADERS_ALL
AP_INVOICES_ALL.PA_DEFAULT_DIST_CCIDGL_CODE_COMBINATIONS
AP_INVOICES_ALL.DOC_SEQUENCE_ID
AP_INVOICES_ALL.DOC_SEQUENCE_VALUE		AP_DOC_SEQUENCE_AUDIT
AP_INVOICES_ALL.DOC_SEQUENCE_IDFND_DOCUMENT_SEQUENCES
AP_INVOICES_ALL.AWT_GROUP_IDAP_AWT_GROUPS
AP_INVOICES_ALL.TASK_IDPA_TASKS
AP_INVOICES_ALL.EXPENDITURE_TYPEPA_EXPENDITURE_TYPES
AP_INVOICES_ALL.EXPENDITURE_ORGANIZATION_IDPA_EXP_ORGS_IT
AP_INVOICES_ALL.PROJECT_IDPA_PROJECTS_ALL
AP_INVOICES_ALL.PAYMENT_CROSS_RATE_TYPEGL_DAILY_CONVERSION_TYPES
AP_INVOICES_ALL.VALIDATION_REQUEST_IDFND_CONCURRENT_REQUESTS
AP_INVOICES_ALL.RECURRING_PAYMENT_IDAP_RECURRING_PAYMENTS_ALL
AP_INVOICES_ALL.VENDOR_IDPO_VENDORS
AP_INVOICES_ALL.VENDOR_SITE_IDPO_VENDOR_SITES_ALL
AP_INVOICES_ALL.SET_OF_BOOKS_ID%
AP_INVOICES_ALL.ACCTS_PAY_CODE_COMBINATION_IDGL_CODE_COMBINATIONS
AP_INVOICES_ALL.INVOICE_CURRENCY_CODEFND_CURRENCIES

Foreign Keys to this table:

Foreign Key ColumnForeign Table
AP_AWT_TAX_RATES_ALL.VENDOR_ID
AP_AWT_TAX_RATES_ALL.INVOICE_NUM		AP_INVOICES_ALL
AP_AWT_TEMP_DISTRIBUTIONS_ALL.INVOICE_IDAP_INVOICES_ALL
AP_INVOICES_ALL
AP_EXPENSE_REPORT_HEADERS_ALL.ADVANCE_INVOICE_TO_APPLYAP_INVOICES_ALL
AP_INVOICES_ALL
AP_EXPENSE_REPORT_HEADERS_ALL.VOUCHNOAP_INVOICES_ALL
AP_EXPENSE_REPORT_LINES_ALL.COMPANY_PREPAID_INVOICE_IDAP_INVOICES_ALL
AP_HOLDS_ALL.INVOICE_IDAP_INVOICES_ALL
AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_IDAP_INVOICES_ALL
AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.PARENT_INVOICE_IDAP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.AWT_INVOICE_IDAP_INVOICES_ALL
AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.COMPANY_PREPAID_INVOICE_IDAP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.PRICE_CORRECT_INV_IDAP_INVOICES_ALL
AP_INVOICE_PAYMENTS_ALL.INVOICE_IDAP_INVOICES_ALL
AP_INVOICE_PREPAYS_ALL.PREPAY_IDAP_INVOICES_ALL
AP_INVOICE_PREPAYS_ALL.INVOICE_IDAP_INVOICES_ALL
AP_INVOICE_RELATIONSHIPS.RELATED_INVOICE_IDAP_INVOICES_ALL
AP_INVOICE_RELATIONSHIPS.ORIGINAL_INVOICE_IDAP_INVOICES_ALL
AP_INV_APRVL_HIST_ALL.INVOICE_IDAP_INVOICES_ALL
AP_PAYMENT_SCHEDULES_ALL.INVOICE_IDAP_INVOICES_ALL
AP_PURGE_INVOICE_LIST.INVOICE_IDAP_INVOICES_ALL
AP_SELECTED_INVOICES_ALL.INVOICE_IDAP_INVOICES_ALL
AP_TRIAL_BALANCE.INVOICE_IDAP_INVOICES_ALL
AP_TRIAL_BAL.INVOICE_IDAP_INVOICES_ALL
AP_UNSELECTED_INVOICES_ALL.INVOICE_IDAP_INVOICES_ALL
FA_ASSET_INVOICES.INVOICE_IDAP_INVOICES_ALL
FA_MASS_ADDITIONS.INVOICE_IDAP_INVOICES_ALL
AP_INVOICES_ALL
FA_MC_ASSET_INVOICES.INVOICE_IDAP_INVOICES_ALL
FV_AAN_MATCHES_TEMP.AP_INVOICE_IDAP_INVOICES_ALL
FV_DISCOUNTED_INVOICES.INVOICE_IDAP_INVOICES_ALL
FV_INTERAGENCY_FUNDS_ALL.INVOICE_IDAP_INVOICES_ALL
FV_INVOICE_RETURNS_ALL.INVOICE_IDAP_INVOICES_ALL
FV_INVOICE_RETURN_DATES_ALL.INVOICE_IDAP_INVOICES_ALL
FV_INV_SELECTED_DUEDATE_TEMP.INVOICE_IDAP_INVOICES_ALL
FV_INV_SELECTED_DUEDATE.INVOICE_IDAP_INVOICES_ALL
FV_REFUNDS_VOIDS_ALL.INVOICE_IDAP_INVOICES_ALL
IGI_EXP_AP_TRANS_ALL.INVOICE_IDAP_INVOICES_ALL
JAI_AP_ETDS_T.BASE_INVOICE_IDAP_INVOICES_ALL
JAI_AP_ETDS_T.TDS_INVOICE_IDAP_INVOICES_ALL
JAI_AP_MATCH_ERS_T.INVOICE_IDAP_INVOICES_ALL
JAI_AP_MATCH_INV_TAXES.INVOICE_IDAP_INVOICES_ALL
JAI_AP_MATCH_INV_TAXES.PARENT_INVOICE_IDAP_INVOICES_ALL
JAI_AP_TDS_F16_DTLS_ALL.INVOICE_IDAP_INVOICES_ALL
JAI_AP_TDS_F16_DTLS_ALL.TDS_INVOICE_IDAP_INVOICES_ALL
JAI_AP_TDS_INVOICES.INVOICE_IDAP_INVOICES_ALL
JAI_AP_TDS_INV_CANCELS.INVOICE_IDAP_INVOICES_ALL
JAI_AP_TDS_INV_PAYMENTS.INVOICE_IDAP_INVOICES_ALL
JAI_AP_TDS_INV_TAXES.INVOICE_IDAP_INVOICES_ALL
JAI_AP_TDS_PREPAYMENTS.INVOICE_IDAP_INVOICES_ALL
JAI_AP_TDS_THGRP_AUDITS.INVOICE_IDAP_INVOICES_ALL
JAI_AP_TDS_THHOLD_TRXS.INVOICE_IDAP_INVOICES_ALL
JAI_AP_TDS_THHOLD_TRXS.INVOICE_IDAP_INVOICES_ALL
JAI_CMN_ST_FORM_DTLS.INVOICE_IDAP_INVOICES_ALL
JAI_PO_REP_PRRG_T.INVOICE_IDAP_INVOICES_ALL
JAI_RCV_TP_INVOICES.INVOICE_IDAP_INVOICES_ALL
JE_IT_VAT_REPORT_INV.TRX_IDAP_INVOICES_ALL
PA_BC_COMMITMENTS_ALL.DOCUMENT_HEADER_IDAP_INVOICES_ALL
PA_BC_PACKETS.DOCUMENT_HEADER_IDAP_INVOICES_ALL
PO_ACCRUAL_RECONCILE_TEMP_ALL.INVOICE_IDAP_INVOICES_ALL
PO_ACCRUAL_WRITE_OFFS_ALL.INVOICE_IDAP_INVOICES_ALL

Comments：

AP_INVOICES_ALL包含您输入的发票记录。您输入的每一张发票都有一行。一张发票可以有一条或多条发票分配线。一张发票也可以有一个或多个预定付款。类型为费用报告的发票必须与AP_EXPENSE_REPORT_HEADERS_ALL中的一行相关，除非记录已从AP_EXPENSE_REPORT_HEADERS_ALL中清除。您的Oracle Payables应用程序使用INTEREST类型的发票来计算过期发票的利息。您的Oracle Payables应用程序通过在AP_INVOICE_RELATIONSHIPS表中插入INVOICE_ID将利息发票链接到原始发票。

该表对应于发票窗口。

六月雨滴
关注
专栏目录
Oracle EBS 之AP发票表结构
11-06
该文档 主要介绍 AP模块 下面表字段的描述 以及表与表之间的关系 AP_INVOICES_ALL AP_PAYMENT_SCHEDULES_ALL AP_INVOICE_DISTRIBUTIONS_ALL AP_HOLDS_ALL AP_HOLD_CODES AP_TERMS_TL AP_CHECKS_ALL AP_INVOICE_PAYMENTS_ALL AP_BANK_ACCOUNTS_ALL AP_BANK_BRANCHES AP_CHECK_STOCKS_ALL AP_EXPENSE_REPORT_HEADERS_ALL AP_EXPENSE_REPORT_LINES_ALL AP_EXPENSE_REPORTS_ALL AP_EXPENSE_REPORT_PARAMS_ALL
AP_INVOICES_ALL(11i)
04-20 336
AP_INVOICES_ALLhttp://skyz.blog.35.cn/?p=483这个表包含用户输入的应付发票信息.每一条记录对应一张应付发票.一条应付发票记录对应多条发票分配行记录.一条应付发票记录对应多条计划付款记录...
ap_invoices_all.approval_status
weixin_34293902的博客
06-26 240
AP发票界面中的一般页签，有个状态的栏位，即APPROVAL_STATUS_DISPLAY 但是到表ap_invoices_all中没有此栏位。另外approval_status/approval_description是空的。   可以到ap_invoices_v中查看APPROVAL_STATUS_LOOKUP_CODE 由此可以得到状态的值。 select * from...
【转】Oracle EBS AP_INVOICES_ALL 表结构
AlexLiu_2019的博客
05-30 755
Oracle EBS AP_INVOICES_ALL 表结构
EBS:AP_INVOICE_PAYMENTS_ALL
qq_36620997的博客
05-06 942
描述：发票的付款记录 Primary Key: AP_INVOICE_PAYMENTS_PK INVOICE_PAYMENT_ID Foreign Keys from this table: Foreign Key Column Foreign Table AP_INVOICE_PAYMENTS_ALL.INVOICE_ID AP_INVOICES_ALL AP_INVOICE_PAYMENTS_ALL.INVOICING_VENDOR_SITE_ID % AP_INVO
Oracle ebs AP基表和总账关联
07-11
Oracle ebs AP基表和总账关联表结构Oracle ebs AP基表和总账关联表结构
ap导入 ebs oracle_Oracle EBS AP发票接口导入
weixin_39644021的博客
12-21 804
在EBS 系统中客制化采购对账系统时，采用了ISP客户化，采购对账流程经历：1、手动/自动生成采购对账单；2、将采购对账单提交给供应商查看/确认；3、将供应商确认后的对账单进行审批，审批可提交放置在OA系统；4、审批后的对账单进行立账，即产生AP发票。本章简要梳理产生AP发票的过程，即AP发票的接口导入。AP发票接口相关表主要有：ap_invoices_interfaceap_invoice_li...
EBS开发_验证AP发票
蜗牛先生快跑的博客
04-03 2165
--以下代码于20181002在Tony环境实现 DECLARE p_invoice_id NUMBER := 10104; -- 'TXXTEST01' p_org_id NUMBER := 82; -- '动物研究所' l_approval_status VARCHAR2(20); l_holds_count NUMBER; ...
EBS开发_创建AP付款
蜗牛先生快跑的博客
12-26 4091
--以下代码于20181002在Tony环境测试通过 /* BEGIN   --mo_global.init('SQLAP');   apps.fnd_global.apps_initialize(user_id => 1110, resp_id => 50597, resp_appl_id => 20003);   --mo_global.set_policy_context(...
EBS: AP_BATCHES_ALL
qq_36620997的博客
05-09 255
描述：发票批次信息汇总 Primary Key: AP_BATCHES_PK BATCH_ID Primary Key: AP_BATCHES_UK1 BATCH_NAME BATCH_DATE Foreign Keys from this table: Foreign Key Column Foreign Table AP_BATCHES_ALL.INVOICE_CURRENCY_CODE FND_CURRENCIES AP_BATCHES_ALL.PAYMENT_CURRE
AP IExpense 杂记随笔
Hellen的博客
05-26 835
最近一直在做IExpense Support,顺便去整理一下标准的业务及通常客户化的业务 。
ap导入 ebs oracle_Oracle EBS Interface/API(1)--AP Invoice费用报表类型导入
weixin_39992312的博客
12-21 296
本文章讲述如何通过接口导入费用报表类型的AP Invoice实例。前提条件:1.定义员工供应商，该供应商的地点名称为办公室2.定义费用报表模板：AP/Setup/Invoice/Expense Report Templates 快速参考:参考点内容功能导航N：AP/Invoices/Entry/Expense Reports并发请求Expense Report Import(导入费用报表)接口表...
Oracle EBS R12 AP模块主要表结构整理
热门推荐
pengshk 专注于oracle ebs dba跟BI
10-17 1万+
目录 1、发票:1 1.1        发票批表AP_BATCHES_ALL. 1 1.2        发票表AP_INVOICES_ALL. 1 1.3        发票分配表AP_INVOICE_DISTRIBUTIONS_ALL. 3 1.4        发票接口表AP_INVOICES_INTERFACE. 4 1.5        表之间的关系... 5
Oracle EBS AP Invoice未付款(无法付款)，但是状态为已付
陈显平的专栏-Oracle EBS
12-22 3406
Oracle EBS AP Invoice未付款，但是状态为已付。AP_INVOICES_ALL.PAYMENT_STATUS_FLAG='Y'）
Oracle EBS Interface/API(1)--AP Invoice费用报表类型导入
陈显平的专栏-Oracle EBS
04-02 8879
本文章讲述如何通过接口导入费用报表类型的AP Invoice。Expense Report Import AP_EXPENSE_REPORT_LINES_ALL /AP_EXPENSE_REPORT_HEADERS_ALL
EBS:AP_SELECTED_INVOICES_ALL
qq_36620997的博客
05-17 294
描述：在一批付款中选择用于付款的发票的临时存放 Primary Key: AP_SELECTED_INVOICES_PK CHECKRUN_NAME INVOICE_ID PAYMENT_NUM Foreign Keys from this table: Foreign Key Column Foreign Table AP_SELECTED_INVOICES_ALL.CHECKRUN_NAME AP_INV_SELECTION_CRITERIA_ALL AP_SELECTED
AP AR 查看那些单据（invoice, payment, transaciton, receipt等）还没有创建会计分录或分录出错
Jinn Guo - Oracle ERP Consulting
07-19 2740
AR 查看那些单据（transaciton, receipt等）还没有创建会计分录使用：Subledger Period Close Exceptions Report AP 则是使用：Period Close Exceptions Report (XML)
AP invoice导入——获取导入错误信息
qingtongqizhw的专栏
01-08 3228
AP invoice接口导入的接口表包括： ap_invoices_interface ——
EBS应付（AP）模块常用表
淡
12-20 6513
 select * from ap_invoices_all INVOICE头 select * from ap_invoice_distributions_all INVOICE行 select * from ap_payment_schedules_all 付款计划 select * from ap_check_stocks_all 单据 select *
Oracle EBS HR关键表结构详解：PER_ALL_PEOPLE_F与PER_ALL_POSITIONS
本文将重点介绍三个主要的表结构：人员基本信息表 (PER_ALL_PEOPLE_F)，Lookup表 (FND_COMMON_LOOKUPS 和 HR_LOOKUPS)，以及职位表 (PER_ALL_POSITIONS)。 1. **人员基本信息表 (PER_ALL_PEOPLE_F)**： - **PERSON...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值