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

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è)計
十八禁一区二区在线观看| 日本99精品视频10| 国产精品一区二区综合亚洲| 九九在线精品视频免费| 亚洲国产成人91精品| 后入动漫视频在线观看| 国产黄色片子在线观看| 欧美性大片一区二区三区| 天堂中文字幕在线乱码一区| 日本视频天堂在线不卡| 亚洲综合国产一二三四五区| 亚洲精品一区二区三区三州| 亚洲精品一区二区免费看| 欧美日韩国产综合下一页| 日韩黄色资源在线观看| 国产成人综合亚洲欧美在线| 欧美高清一区二区在线播放| 欧美国产综合欧美一区二区三区| 熟妇人妻中文字幕在线| 久娜娜精品视频在线观看| 亚洲欧美日韩综合精品久久| 国产精品国产三级国av中文 | 日本在线不卡二区三区| 韩国三级网站在线观看视频| 国产成人综合亚洲乱淫.| 国产精品国产三级农村av| 日韩少妇黄色在线观看| 亚洲熟妇人妻一区二区三区| 国产男女免费视频观看| 日本一区二区三区高清| 黑人巨大精品欧美一区免| 一区二区精品福利视频| 国产精品精品国产色婷婷| 蜜臀av在线国产一区| 欧美夫妻成人性生活视频| 久久夜色精品亚洲国产| 99热这里只有精品中文有码| 高清免费国产日日操夜夜草| 日日激情综合久久一区| 国产精品伊人久久精品| 97视频观看免费观看|