OracleERP11i表结构 - AP

本文概览了信息技术领域的核心内容,从基础的前端开发、后端开发到移动应用开发,再到游戏开发、大数据处理、AI音视频处理等细分领域。涵盖了开发工具、嵌入式硬件、音视频基础、测试、基础运维、DevOps、操作系统、云计算、自然语言处理、区块链、隐私计算等多个方面,全面展示了信息技术的广阔范畴。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

 

ap(应付)  值集名 
ap_batches_all发票批表 AP_APPROVAL_STATUS发票审批工作流状态 
BATCH_ID(PK)发票批标识符(IDInvoice batch identifier       
BATCH_NAME发票批名(唯一所执行的发票工作台) Invoice batch name (uniqueness
enforced by the Invoice
workbench)
       
BATCH_DATE发票批日期Invoice batch date       
CONTROL_INVOICE_COUNT控制用户输入的发票数User entered control of number of invoices in batch       
CONTROL_INVOICE_TOTAL用户在批输入发票的发票金额共计控制 User entered control of invoice
amount total for invoices in
batch
       
ACTUAL_INVOICE_COUNT当前不使用Not currently used       
ACTUAL_INVOICE_TOTAL当前不使用Not currently used       
INVOICE_CURRENCY_CODE发票货币代码,忽略供应商发货票货币(可以为空为多货币批)Currency code of invoice,overrides supplier invoice currency       
PAYMENT_CURRENCY_CODE付款货币代码(币种)(必须有一个相关的固定利率的货币或相同INVOICE_CURRENCY_CODE) Currency code of payment (must
be an associated fixed–rate
currency or same as
INVOICE_CURRENCY_CODE)
       
PAY_GROUP_LOOKUP_CODE支付组        
BATCH_CODE_COMBINATION_ID         
TERMS_ID付款条件        
INVOICE_TYPE_LOOKUP_CODE发票类型Default invoice type       
HOLD_LOOKUP_CODE暂挂ID        
HOLD_REASON暂挂名        
DOC_CATEGORY_CODE默认顺序编号(凭单编号)文件类Default Sequential Numbering(voucher number) document category       
ORG_ID组织Organization identifier       
GL_DATEGL日期 GL Date to default to invoices
PAYMENT_PRIORITY NULL NUMBER(2) Number representing payment
priority used to default down
to invoices and payment
       
PAYMENT_PRIORITY付款优先权PAYMENT_ PRIORITY       
          
ap_invoices_all发票表        
INVOICE_ID (PK)发票ID        
VENDOR_ID供应商ID        
INVOICE_NUM发票编号        
SET_OF_BOOKS_ID帐薄ID        
INVOICE_CURRENCY_CODE发票的币种代码        
PAYMENT_CURRENCY_CODE付款货币代码        
PAYMENT_CROSS_RATE在发货票和付款之间的交换率        
INVOICE_AMOUNT发票金额        
VENDOR_SITE_ID供应商地点ID        
AMOUNT_PAID已支付金额Amount paid       
DISCOUNT_AMOUNT_TAKEN         
INVOICE_DATE发票日期        
SOURCE发票来源        
INVOICE_TYPE_LOOKUP_CODE发票类型        
DESCRIPTION发票说明        
BATCH_ID批ID        
AMOUNT_APPLICABLE_TO_DISCOUNT         
TAX_AMOUNT税额Tax amount       
TERMS_ID付款条件IDPayment terms identifier       
TERMS_DATE付款条件日期        
PAYMENT_METHOD_LOOKUP_CODE付款方式Name of payment method       
PAY_GROUP_LOOKUP_CODE支付组        
ACCTS_PAY_CODE_COMBINATION_ID         
PAYMENT_STATUS_FLAG付款标记(快速编码) Flag that indicates if invoice
has been paid (Y, N, or P)
       
CREATION_DATE         
CREATED_BY         
BASE_AMOUNT本位币(用在外币发票)        
VAT_CODE税码        
LAST_UPDATE_LOGIN         
EXCLUSIVE_PAYMENT_FLAG         
PO_HEADER_ID订单头        
FREIGHT_AMOUNT运费        
GOODS_RECEIVED_DATE         
INVOICE_RECEIVED_DATE         
VOUCHER_NUM         
APPROVED_AMOUNT         
RECURRING_PAYMENT_ID         
EXCHANGE_RATE汇率        
EXCHANGE_RATE_TYPE汇率类型        
EXCHANGE_DATE 日期汇率
有效的,通常是会计
交易日期
        
EARLIEST_SETTLEMENT_DATE         
ORIGINAL_PREPAYMENT_AMOUNT         
DOC_SEQUENCE_ID         
DOC_SEQUENCE_VALUE         
DOC_CATEGORY_CODE         
ATTRIBUTE1         
         
ATTRIBUTE_CATEGORY         
APPROVAL_DESCRIPTION         
INVOICE_DISTRIBUTION_TOTAL         
POSTING_STATUS         
PREPAY_FLAG         
AUTHORIZED_BY         
CANCELLED_DATE         
CANCELLED_BY         
CANCELLED_AMOUNT         
TEMP_CANCELLED_AMOUNT         
PROJECT_ACCOUNTING_CONTEXT         
USSGL_TRANSACTION_CODE         
USSGL_TRX_CODE_CONTEXT         
PROJECT_ID         
TASK_ID         
EXPENDITURE_TYPE         
EXPENDITURE_ITEM_DATE         
PA_QUANTITY         
EXPENDITURE_ORGANIZATION_ID         
PA_DEFAULT_DIST_CCID         
VENDOR_PREPAY_AMOUNT         
PAYMENT_AMOUNT_TOTAL         
AWT_FLAG         
AWT_GROUP_ID自动预扣税组的内部标识        
REFERENCE_1         
REFERENCE_2         
ORG_ID         
PRE_WITHHOLDING_AMOUNT         
GLOBAL_ATTRIBUTE_CATEGORY         
GLOBAL_ATTRIBUTE1         
GLOBAL_ATTRIBUTE2         
…….         
AUTO_TAX_CALC_FLAG         
PAYMENT_CROSS_RATE_TYPE         
PAYMENT_CROSS_RATE_DATE发票币种和付款币种之间的交叉汇率生效日期。        
PAY_CURR_INVOICE_AMOUNT         
MRC_BASE_AMOUNT         
MRC_EXCHANGE_RATE         
MRC_EXCHANGE_RATE_TYPE         
MRC_EXCHANGE_DATE         
AWARD_ID         
GL_DATE 会计日期        
说明:快速编码说明(QuickCodes)        
INVOICE_TYPE_LOOKUP_CODE(发票类型),快速编码类型:INVOICE TYPE;快速编码表:AP_LOOKUP_CODES       
类型中文说明英文说明       
AWT预扣税发票Withholding tax invoice       
CREDIT贷项通知单Credit memo       
DEBIT借项通知单Debit memo       
EXPENSE REPORT员工费用报表Employee expense report       
INTEREST利息发票Interest invoice       
MIXED混合型发票Mixed type invoice       
PREPAYMENT预付款项及预支款Prepayments and advances       
QUICKDEFAULTPO的标准发票PO default standard invoice       
QUICKMATCH快速匹配标准发票QuickMatch standard invoice       
STANDARD标准发票Standard invoice       
PO PRICE ADJUSTPO 价格调整单据        
PAYMENT_METHOD_LOOKUP_CODE(付款方式),快速编码类型:PAYMENT METHOD;快速编码表:AP_LOOKUP_CODES       
类型中文说明英文说明       
CHECK支票付款Check       
CLEARING付款结清Clearing       
EFT电子付款方法Electronic       
WIRE电汇付款Wire       
PAYMENT_STATUS_FLAG(付款状态),快速编码类型:INVOICE PAYMENT STATUS;快速编码表:AP_LOOKUP_CODES       
类型中文说明英文说明       
N否(没有付清)Not paid       
P部分(部分付清)Partially paid       
Y是发(全部付清)Fully paid       
SOURCE(发票来源),快速编码类型:SOURCE;快速编码表:AP_LOOKUP_CODES       
类型中文说明英文说明       
CREDIT CARD信用卡(旅行卡事务处理的发票)Credit Card       
EDI GATEWAY从电子商务网关创建发票e–Commerce Gateway       
ERS按接收开票ERS       
INVOICE GATEWAY快速开票Invoice Gateway       
Intercompany公司间(从 Oracle Receivables 创建公司间发票)Intercompany       
Oracle Assets Oracle Assets 创建发票Oracle Assets       
Oracle Project Accounting Oracle 项目会计创建发票Oracle Project Accounting       
Oracle Property Manager Oracle Property Manager 创建发票Oracle Property Manager       
PA_IC_INVOICESOracle Projects 公司间发票 Oracle Projects InterCompany
Invoices
       
PA_IP_INVOICESOracle Projects 项目间发票 Oracle Projects Inter–Project
Invoices
       
RECURRING INVOICE由经常性发票创建Recurring Invoice       
RTS向供应商退货Return to Supplier       
SelfService使用 Oracle Internet Expenses 创建发票Self–Service Applications       
XpenseXpress从应付款管理系统费用报表创建发票Payables Expense Reports       
ap_invoice_distributions_all发票分配表(发票行)        
ACCOUNTING_DATE会计日期        
ACCRUAL_POSTED_FLAG         
ASSETS_ADDITION_FLAG         
ASSETS_TRACKING_FLAG         
CASH_POSTED_FLAG         
DISTRIBUTION_LINE_NUMBER (PK)         
DIST_CODE_COMBINATION_ID         
INVOICE_ID (PK)         
LINE_TYPE_LOOKUP_CODE         
PERIOD_NAME         
SET_OF_BOOKS_ID         
ACCTS_PAY_CODE_COMBINATION_ID         
AMOUNT         
BASE_AMOUNT         
BASE_INVOICE_PRICE_VARIANCE         
BATCH_ID         
          
DIST_MATCH_TYPE(付款状态),快速编码类型:DIST_MATCH_TYPE;快速编码表:AP_LOOKUP_CODES       
IP         
IR         
Null         
OR         
FINAL_MATCH_FLAG(付款状态),快速编码类型:FINAL MATCH CODE;快速编码表:AP_LOOKUP_CODES       
D完成        
N        
Y        
LINE_TYPE_LOOKUP_CODE(发票类型),快速编码类型:INVOICE DISTRIBUTION TYPE;快速编码表:AP_LOOKUP_CODES       
AWT预扣税预扣税分配行       
FREIGHT运费发票运费行       
ICMSICMSICMS       
IPIIPIIPI       
ITEM已采购货物或服务行       
MISCELLANEOUS杂项杂项费用       
PREPAY预付款预付款分配行       
TAX发票税行       
          
          
          
          
          
          
          
          
ap_payment_schedules_all 付款计划        
INVOICE_ID (PK)         
PAYMENT_CROSS_RATE         
PAYMENT_NUM (PK)         
AMOUNT_REMAINING         
DISCOUNT_DATE         
DUE_DATE         
FUTURE_PAY_DUE_DATE         
GROSS_AMOUNT         
HOLD_FLAG         
PAYMENT_METHOD_LOOKUP_CODE         
PAYMENT_PRIORITY         
PAYMENT_STATUS_FLAG         
SECOND_DISCOUNT_DATE         
THIRD_DISCOUNT_DATE         
BATCH_ID         
DISCOUNT_AMOUNT_AVAILABLE         
SECOND_DISC_AMT_AVAILABLE         
THIRD_DISC_AMT_AVAILABLE         
DISCOUNT_AMOUNT_REMAINING         
ORG_ID         
EXTERNAL_BANK_ACCOUNT_ID         
INV_CURR_GROSS_AMOUNT         
          
          
ap_invoice_payment_history_v付款历史记录(视图)已付款数据     
          
          
          
          
ap_unapply_prepays_fr_prepay_v标准订单核销预付款发票的数据核销几个预付款发票就有几条核销数据(是用标准发票来核销预付款发票)      
invoice_id标准发票ID        
PREPAY_AMOUNT_APPLIED核销金额        
prepay_id预付款发票ID        
ACCOUNTING_DATE会计日期        
          
          
          
ap_check_stocks_all付款单据表        
          
          
          
          
          
          
          
          
ap_checks_all单据付款表实际付款    
AMOUNT付款金额Payment amount       
BANK_ACCOUNT_ID银行帐户标识符Bank account identifier       
BANK_ACCOUNT_NAME银行帐户名称Bank account name       
CHECK_DATE         
CHECK_ID (PK)         
CHECK_NUMBER         
CURRENCY_CODE币种        
PAYMENT_METHOD_LOOKUP_CODE         
PAYMENT_TYPE_FLAG         
ADDRESS_LINE1         
ADDRESS_LINE2         
ADDRESS_LINE3         
CHECKRUN_NAME         
CHECK_FORMAT_ID         
CHECK_STOCK_ID         
CITY         
COUNTRY         
STATUS_LOOKUP_CODEVOIDED--撤销,NEGOTIABLE--可用的(议付)        
VENDOR_NAME         
VENDOR_SITE_CODE         
ZIP         
BANK_ACCOUNT_NUM         
BANK_ACCOUNT_TYPE         
BANK_NUM         
CHECK_VOUCHER_NUM         
CLEARED_AMOUNT         
CLEARED_DATE         
DOC_CATEGORY_CODE         
DOC_SEQUENCE_ID         
DOC_SEQUENCE_VALUE         
ORG_ID         
VENDOR_ID         
VENDOR_SITE_ID         
STAMP_DUTY_AMT印花税税收金额全球化        
STAMP_DUTY_BASE_AMT印花税税率的本位币金额全球化        
说明:快速编码说明(QuickCodes        
PAYMENT_METHOD_LOOKUP_CODE(付款方式),快速编码类型:PAYMENT METHOD;快速编码表:AP_LOOKUP_CODES       
CHECK支票        
CLEARING结清        
EFT电子        
WIRE电汇        
          
ap_bank_branches银行头表        
BANK_BRANCH_ID (PK)         
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
ap_bank_accounts_all银行帐号信息表        
BANK_ACCOUNT_ID (PK)         
          
          
          
          
          
          
          
ap_invoice_payments_all 付款核销表(付款表)对某个发票进行付款,这张表记录了哪些付款支付了哪些发票情况比较复杂:比如两个用户合并,应收应付差额,预付款
CHECK_ID付款收据号        
INVOICE_ID发票        
INVOICE_PAYMENT_ID         
PAYMENT_NUM         
AMOUNT         
POSTED_FLAG         
INVOICE_BASE_AMOUNT         
PAYMENT_BASE_AMOUNT         
INVOICE_PAYMENT_TYPE         
ORG_ID         
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
ap_accounting_events_all会计事件表(些表为区分会计分录中是发票分录还是付款分录)        
          
          
          
          
          
          
          
          
ap_ae_headers_all会计分录头表        
AE_HEADER_ID         
ACCOUNTING_EVENT_ID         
AE_CATEGORY会计分录类别         
PERIOD_NAME会计期间名称        
ORG_ID         
          
          
          
ap_ae_lines_all会计分录行表        
AE_LINE_ID         
AE_HEADER_ID         
AE_LINE_NUMBER         
AE_LINE_TYPE_CODE         
CODE_COMBINATION_ID         
CURRENCY_CODE         
CURRENCY_CONVERSION_TYPE         
CURRENCY_CONVERSION_DATE         
CURRENCY_CONVERSION_RATE         
ENTERED_DR         
ENTERED_CR         
ACCOUNTED_DR         
ACCOUNTED_CR         
ORG_ID         
          
          
          
          
          
          
ap_holds_all暂挂        
          
          
          
          
AP_HOLD_CODES暂挂代码        
          
          
AP_TERMS_TL付款条件头        
          
          
AP_TERMS_LINES付款条件行        
          
          
          
ap_chrg_allocations_all分配对应的费用        
          
          
          
          
AP_UNAPPLY_PREPAYS_V核销金额(视图)核销发票的数据放在该表内   
          
          
AP_TAX_CODES_ALL税码表        
          
          
ap_invoices_interface AP头接口表        
gl_date                   总账日期        
group_id                 发票批号        
invoice_amount            发票金额        
invoice_currency_code    发票币种        
invoice_date              发票日期        
invoice_id               发票ID           
invoice_num              发票号        
invoice_type_lookup_code  发票类型代码        
org_id                    经营组织ID        
payment_currency_code     支付币种        
payment_method_lookup_code供应商付款方式取自po_vendor_sites_all       
source                    发票来源        
terms_date                条款日期        
terms_id                  条款ID        
vendor_id                 供应商ID        
vendor_site_id            供应商地点        
Description             描述        
doc_category_code         单据类别        
exchange_rate            汇率        
exchange_rate_type        汇率类型        
exchange_date汇率日期        
GLOBAL_ATTRIBUTE_CATEGORY为您要导入的说明性弹性域信息输入说明性弹性域类别。        
SOURCE发票数据的来源        
AP_INVOICE_LINES_INTERFACEAP行接口表        
INVOICE_ID         
INVOICE_LINE_ID         
LINE_NUMBER         
LINE_TYPE_LOOKUP_CODE         
LINE_GROUP_NUMBER         
AMOUNT         
ACCOUNTING_DATE         
DESCRIPTION         
TAX_CODE         
AMOUNT_INCLUDES_TAX_FLAG         
PRORATE_ACROSS_FLAG         
PO_HEADER_ID         
PO_NUMBER         
PO_LINE_ID         
PO_LINE_NUMBER         
PO_LINE_LOCATION_ID         
PO_SHIPMENT_NUM         
PO_DISTRIBUTION_ID         
PO_DISTRIBUTION_NUM         
PO_UNIT_OF_MEASURE         
PO_RELEASE_ID         
RELEASE_NUM         
INVENTORY_ITEM_ID         
ITEM_DESCRIPTION         
SHIP_TO_LOCATION_CODE         
QUANTITY_INVOICED         
UNIT_PRICE         
FINAL_MATCH_FLAG         
DISTRIBUTION_SET_ID         
DISTRIBUTION_SET_NAME         
DIST_CODE_CONCATENATED         
DIST_CODE_COMBINATION_ID         
BALANCING_SEGMENT         
COST_CENTER         
ACCOUNT         
AWT_GROUP_ID         
          
          
          
          
          
                      
以下列出了一些AP头接口导入数据前需要验证的数据

1.经营组织ID,验证是否存在于ERP系统中并且是否有效.

2.
发票币种(invoice_currency_code ),验证方法跟我介绍GL Interface一样。

3.供应商付款方式(payment_method_lookup_code),验证是否存在于ERP中并且有效,该信息存在表po_vendor_sites_all.

4.
发票来源(source)验证导入的类型是否存在并且有效,该信息存在于表Ap_Lookup_Codes.

5.
条款(terms_id),验证是否存在ERP中,并且判定是否有效,该数据存在表AP_TERMS.

6.
供应商(vendor_id),验证导入的供应商是否存在并且有效,数据存在于表PO_VENDORS

7.供应商地点(vendor_site_id),验证导入的供应商地点是否存在并且有效,数据存在于表PO_VENDOR_SITES_ALL.
        
        
        
        
        
        
ap_invoice_lines_interfaceAP接口行表        
invoice_line_id --行ID           
line_number --行号         
line_type_lookup_code --行类型         
amount --发票金额         
accounting_date  --会计结算日期         
dist_code_combination_id --帐户         
org_id--组织ID         
          
          
Ap_Lookup_Codes发票来源        
          
          
          
AP_TERMS付款条件        
          
          
          
          
接口行表需要验证的是:dist_code_combination_idorg_idline_type_lookup_code 其中line_type_lookup_code在视图AP_LOOKUP_CODES里进行验证。       
预付款和发票的关联
select *
FROM ap_lookup_codes l1,
ap_invoices_all i,
ap_payment_schedules_all aps
WHERE i.cancelled_date IS NULL
AND aps.invoice_id = i.invoice_id
AND l1.lookup_type = 'INVOICE TYPE'
and i.invoice_type_lookup_code = 'PREPAYMENT'
AND l1.lookup_code = i.invoice_type_lookup_code
        
        
        
          
发票类型         
 CREDIT(贷项通知单)        
 STANDARD(标准发票)        
 EXPENSE REPORT(员工费用报表)        
PREPAYMENT(预付款和预支款)        
DEBIT        
         
ap_invoices_pkg.get_approval_status(ai.invoice_id,
                                                 ai.invoice_amount,
                                                 ai.payment_status_flag,
                                                 ai.invoice_type_lookup_code)--获得发票状态
  
发票状态:approval_status_lookup_code        
UNAPPROVED--未验证         
FULL--已全部核销(预付款)         
UNPAID--未付(预付款)         
AVAILABLE可用(预付款)-- 已经核销一部分还有一部分钱没有核销        
APPROVED--已验证(正常发票)         
NEEDS REAPPROVAL需要重新验证(正常发票)        
          
          
select          
aas.TRX_NUMBER_DISPLAYED,--付款收据编号CHECK_NUMBER        
aas.TRX_HDR_ID,--付款ID,CHECK_ID         
aas.TRX_NUMBER_N,--CHECK_NUMBER        
aas.TRX_LINE_NUMBER,--分配行ID,distribution_line_number        
aas.APPLIED_TO_TRX_HDR_ID,--发票ID,invoice_id        
aas.APPLIED_TO_TRX_HDR_NUMBER_DISP--发票编号        
aas.APPLIED_TO_TRX_HDR_NUMBER_C         
from ap_ael_sl_pay_v aas where aas.APPLIED_TO_TRX_HDR_NUMBER_C ='YF000053'        
          
          

 

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值