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

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è)計
色综合视频二区偷拍在线| 好狼色欧美激情国产区| 精品啪在线观看国产熟女| 国产高清内射一级一片高清视频| 高级会所口爆视频在线播放视频 | 亚洲最新一区二区在线观看| 国产av剧情精品亚洲| 国产无遮挡的免费视频| 欧美激情三级一区二区| 婷婷色悠悠,色悠悠激情啪啪| 丰满少妇一级淫片在线播放| 亚洲精品日韩一区二区| 蜜桃传媒18传媒在线| 免费一区二区不卡去日本| 国产日韩欧美亚洲中文| 日本大片在线一区二区三区| 婷婷亚洲悠悠色悠在线| 9热在线视频精品这里只有| 少妇激情一区二区三区免费视频| 国产精品日韩av一区二区| 欧美精品在,欧美一区二区| 深夜成人免费观看视频| 伊人99热这里只有精品| 欧美另类亚洲日本一区二区| 门国产av一区二区三区| 欧美黄色日本一区二区| 午夜男女激情在线观看| 日韩亚洲毛片全在线播放| 精品国产一区二区日韩91| 国产成人av在线观看| 国产精品一区二区激情视频| 亚洲综合日韩精品国产av| 麻豆蜜桃精品视频在线观看 | 免费国产午夜福利在线| 欧美午夜一级特黄大片| 在线不卡日本v二区到六区| 亚洲av中文久久精品国内| 亚洲av成人永久网站一区| 不卡二卡三卡四卡精品| 国产av综合一区二区三区最新| 精品少妇一区二区三区|