универсальная спортивная площадка при школе размеры
Главное меню:
Интересное
универсальная спортивная площадка при школе размеры, PO_DISTRIBUTIONS_ALL - Oracle, TABLE - PO.PO_DISTRIBUTIONS_ALL, PO_DISTRIBUTIONS_ALL: Table Structure & Indexes, PO_DISTRIBUTIONS_ALL | Home - Blogger, ORACLE EBS PL/SQL: Oracle Apps Tables - Blogger, PO Tables in Oracle Apps R12: A Complete Guide, Welcome to Oracle ERP: AP-PO Link Queries.
PO_DISTRIBUTIONS_ALL contains accounting distribution information for a purchase order shipment line. You need one row for each distribution line you attach to a purchase order shipment. There are four types of documents using distributions in Oracle Purchasing: Standard Purchase Orders, Planned Purchase Orders, Planned Purchase Order Releases and Blanket Purchase Order Releases. Each row includes the destination type, requestor ID, quantity ordered and deliver-to location for the distribution. Oracle Purchasing uses this information to record accounting and requisition information for purchase orders and releases. PO_DISTRIBUTIONS_ALL is one of five tables storing purchase order and release information. Some columns in PO_DISTRIBUTIONS_ALL contain information only if certain conditions exist: If you autocreate this accounting distribution from a requisition, REQ_DISTRIBUTION_ID corresponds to the ID of the requisition distribution you copy on the purchase order. If you use a foreign currency on your purchase order, Oracle Purchasing stores currency conversion information in RATE and RATE_DATE. If you use encumbrance, GL_ENCUMBERED_DATE and GL_ENCUMBERED_PERIOD_NAME contain encumbrance information Oracle Purchasing uses to create journal entries in Oracle General Ledger. If you do not autocreate the purchase order from online requisitions, REQ_LINE_REFERENCE_NUM and REQ_HEADER_REFERENCE_NUM contain the requisition number and requisition line number of the corresponding paper requisition. These two columns are not foreign keys to another table. If the distribution corresponds to a blanket purchase order release, PO_RELEASE_ID identifies this release. If SOURCE_DISTRIBUTION_ID has a value, the distribution is part of a planned purchase order release. If you cancel the distribution, Oracle Purchasing automatically updates QUANTITY_CANCELLED or GL_CANCELLED_DATE. Oracle Purchasing also enters UNENCUMBERED_AMOUNT if you use encumbrance. You enter distribution information in the Distributions window, accessible through the Purchase Orders and Releases windows., PO_DISTRIBUTIONS_ALL contains accounting distribution information for a purchase order shipment line. You need one row for each distribution line you attach to a purchase order shipment. There are four types of documents using distributions in Oracle Purchasing: Standard Purchase Orders, Planned Purchase Orders, Planned Purchase Order Releases , PO_DISTRIBUTIONS_ALL is one of five tables storing purchase order and release information.. Some columns in PO_DISTRIBUTIONS_ALL contain information only if certain conditions exist:. {{"bul:1"}}If you autocreate this accounting distribution from a requisition, REQ_DISTRIBUTION_ID corresponds to the ID of the.
PO_DISTRIBUTIONS_ALL is the table used by Oracle to store the distribution information of Purchase Order Line and by distribution I mean GL account information i.e. which GL accounts will be hit by the system., PO_DISTRIBUTIONS_ALL contains accounting distribution information for a purchase order shipment line. You need one row for each distribution line you attach to a purchase order shipment. There are four types of documents using distributions in Oracle Purchasing:, PO_LINES_ALL Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs), PO_DISTRIBUTIONS_ALL: po_distributions_all stores distribution details for PO line locations or PO Shipments (account codes, project details, charge account). PO_ASL_ATTRIBUTES: Contains Approved Supplier List attributes. PO_ACTION_HISTORY: Tracks purchase order actions (approval, changes, cancellations). 3. PO Buyer Table in Oracle Apps R12., FROM ap.ap_invoice_distributions_all x WHERE x.invoice_distribution_id = b.invoice_distribution_id) "INVOICE APPROVED?", a.amount_paid, h.check_id, i.check_number, h.invoice_payment_id, TO_CHAR (TRUNC (i.check_date)) "PAYMENT DATE" FROM ap.ap_invoices_all a, ap.ap_invoice_distributions_all b, po.po_distributions_all c, po.po_headers_all d, ap , PO_DISTRIBUTIONS_ALL: This table contains the information related to accounting distribution of a purchase order shipment line. You need one row for each distribution line you attach to a purchase order shipment. There are four types of documents using distributions in Oracle Purchasing: Standard Purchase Orders; Planned Purchase Orders.