欧美一级特黄大片做受成人-亚洲成人一区二区电影-激情熟女一区二区三区-日韩专区欧美专区国产专区

OracleProjects-APIntegrationPart4

轉(zhuǎn)自:http://www.linkedin.com/pulse/20140701052052-19818376-oracle-projects-ap-integration-part4

Release 12

==============

為大石橋等地區(qū)用戶提供了全套網(wǎng)頁設(shè)計制作服務(wù),及大石橋網(wǎng)站建設(shè)行業(yè)解決方案。主營業(yè)務(wù)為成都網(wǎng)站設(shè)計、成都做網(wǎng)站、大石橋網(wǎng)站設(shè)計,以傳統(tǒng)方式定制建設(shè)網(wǎng)站,并提供域名空間備案等一條龍服務(wù),秉承以專業(yè)、用心的態(tài)度為用戶提供真誠的服務(wù)。我們深信只要達(dá)到每一位用戶的要求,就會得到認(rèn)可,從而選擇與我們長期合作。這樣,我們也可以走得更遠(yuǎn)!

The following columns were added in R12 to tablePA_EXPENDITURE_ITEMS_ALL with the purpose of linking data between PA and AP/PO:DOCUMENT_HEADER_ID:
This column refers to a header-level record identifier in another application. If the expenditure item originated in Oracle Payables, it holds the AP_INVOICES_ALL.INVOICE_ID. If the expenditure item originated in Oracle Purchasing, it holds the PO_HEADERS_ALL.PO_HEADER_ID. This column is not used for labor and usage expenditure items.

DOCUMENT_DISTRIBUTION_ID :
This column refers to a distribution-level record identifier in another application. If the expenditure item originated in Oracle Payables, it holds the AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID. If the expenditure item originated in Oracle Purchasing, it holds the RCV_TRANSACTIONS.TRANSACTION_ID. This column is not used for labor and usage expenditure items.

DOCUMENT_LINE_NUMBER:
This column refers to a line-level record identifier in another application. If the expenditure item originated in Oracle Payables, it holds the AP_INVOICE_LINES_ALL.LINE_NUMBER. If the expenditure item originated in Oracle Purchasing, it holds the PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID. This column is not used for labor and usage expenditure items.

DOCUMENT_PAYMENT_ID:
This column refers to the payment record identifier in Oracle Payables. It holds the AP_PAYMENT_DISTRIBUTIONS_ALL.PAYMENT_ID. This column is only populated when you enable cash basis accounting or, for payment discounts, when you use accrual basis accounting. This column is not used for labor and usage expenditure items.

VENDOR_ID:
This column indicates the vendor identifier for supplier cost transactions. If the expenditure item originated in Oracle Payables, it holds the AP_INVOICES_ALL.VENDOR_ID. If the expenditure item originated in Oracle Purchasing, it holds the PO_HEADERS_ALL.VENDOR_ID. This column is not used for labor and usage expenditure items.

DOCUMENT_TYPE:
The supplier cost interface process uses this column to indicate the transaction type. Valid values are as follows: Payables, Purchasing, or Receiving.

DOCUMENT_DISTRIBUTION_TYPE:
The supplier cost interface process uses this column to indicate the transaction type of the distribution. Valid values are as follows: Payables, Purchasing, or Receiving.

The value in SYSTEM_REFERENCE columns depends on where the expenditure is coming from.
Usually the reference columns in PA_COST_DISTRIBUTION_LINES_ALL table are populated for Supplier costs – Invoices or Receipts.

In case of Supplier invoice:
SYSTEM_REFERENCE2 holds invoice id
SYSTEM_REFERENCE3 holds invoice line number
SYSTEM_REFERENCE4 holds invoice_payment_id from table ap_payment_hist_dists (for discount lines)
holds variance type or tax type (like TRV, ERV, NONREC_TAX)
SYSTEM_REFERENCE5 holds PAYMENT_HIST_DIST_ID from table ap_payment_hist_dists (for discount lines)

If it is Receipt Accrual:
SYSTEM_REFERENCE2 holds PO_HEADER_ID
SYSTEM_REFERENCE3 holds PO_DISTRIBUTION_ID
SYSTEM_REFERENCE4 holds RCV_TRANSACTION_ID from rcv_receiving_sub_ledger
SYSTEM_REFERENCE5 holds RCV_SUB_LEDGER_ID from rcv_receiving_sub_ledger

It is possible to map between the TRANSFER_STATUS_CODE column in the PA_COST_DISTRIBUTION_LINES_ALL table and the PA_ADDITION_FLAG column in the AP_INVOICE_DISTRIBUTIONS_ALL table. TRANSFER_STATUS_CODEs available in the PA_COST_DISTRIBUTION_LINES_ALL table for supplier invoices are:

· V- Interface from Oracle Payables – Upon creation set to Received

· P – Pending – Upon execution of Distribute Cost Process after Supplier Invoice Adjustments

· G – If payables rules do not allow adjustments to the invoice (example: if the invoice is cancelled), then distribute supplier invoice adjustments program would create the CDL and set the value to (G), these lines will always reside in Oracle Projects and will not be transferred to Oracle Payables

· A – Transfer Costs – If successfully transferred to Oracle Payables, set to Accepted

· X – Rejected in transfer to Oracle Payables, set to Rejected in Transfer

當(dāng)前文章:OracleProjects-APIntegrationPart4
URL標(biāo)題:http://aaarwkj.com/article38/pcdpsp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供網(wǎng)站建設(shè)、用戶體驗、網(wǎng)站設(shè)計公司域名注冊、標(biāo)簽優(yōu)化、小程序開發(fā)

廣告

聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時需注明來源: 創(chuàng)新互聯(lián)

成都定制網(wǎng)站網(wǎng)頁設(shè)計
91麻豆视频福利视频| av在线视频男人的天堂| 蜜臀一区二区三区精品免费| 日韩电影网国产精品| 麻豆精品国产一区二区91| 外国男人搞亚洲女人在线| 国产精品亚洲av三区国产毛片| 日本在线观看免费高清| 无遮挡无掩盖的免费网站| 成人精品国产亚洲av| 国产精品日韩精品在线| 久久麻豆精亚洲av品国产一区| 秋霞日韩欧美一区二区三区| av毛片高清在线观看| 国产原创剧情免费观看av| 真实国产熟女一区二区三区| 中文字幕在线成人影院| 91午夜福利视频免费播放| 黑人精品一区二区三区| 国产黄片一区二区在线| 国产 亚洲 一区 二区| 国产精品国产三级丝袜| 国产一级精品自拍视频| 久久亚洲第一视频网站| 清纯少妇激情四射网站| 国产在线精品91系列| 人妻丝袜中文字幕在线| 亚洲丰满性感美女av| 不卡一区二区三区av电影| 手机看片黄色福利视频91| 欧美日韩一区二区三区在线| 亚洲av区一区二区三| 精品在线中文字幕不卡| 亚洲乱码中文字幕在线观看| 激情小说婷婷亚洲综合| 国产在线精品成人欧美| 97成品视频在线播放| 日韩精品国产自拍在线| 溪乱毛片一区二区三区| 熟女人妻丰满视频中文字幕| 人妻有码一区二区三区|