DW_PO_DISTRIBUTIONS_EN

Standard Purchase Orders Distributions Entity

Details

Module: Purchasing

Key Columns

PO_DISTRIBUTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PO_DISTRIBUTION_ID NUMBER 38 0 True Document distribution unique identifier    
SOURCE_RECORD_ID VARCHAR2 128     Source record identifier    
SUBLEDGER_LINKAGE_DST_ENTITY_ID VARCHAR2 64     Document distribution unique identifier    
DESTINATION_TYPE VARCHAR2 32     Final destination of the purchased items    
PO_DISTRIBUTION_NUMBER NUMBER       Distribution number    
PO_DISTRIBUTION_CREATION_DATE TIMESTAMP       indicates the date and time of the creation of the row    
REQUISITION_DISTRIBUTION_ID NUMBER 38 0   Requisition distribution unique identifier POR_REQ_DISTRIBUTIONS_ALL DISTRIBUTION_ID
LINE_LOCATION_ID NUMBER 38 0   Document shipment schedule unique identifier. References PO_LINES_LOCATIONS_ALL.LINE_LOCATION_ID.    
ACCRUAL_ACCOUNT_ID NUMBER 38 0   Unique identifier for the General Ledger accrual account. References GL_CODE_COMBINATIONS.CODE_COMBINATION_ID.    
VARIANCE_ACCOUNT_ID NUMBER 38 0   Unique identifier for the General Ledger variance account. References GL_CODE_COMBINATIONS.CODE_COMBINATION_ID.    
QUANTITY_CANCELLED NUMBER       Quantity cancelled for the distribution    
CONSIGNMENT_QUANTITY NUMBER       Quantity In Consigned Inventory after deliver transaction    
QUANTITY_BILLED NUMBER       Quantity invoiced by Oracle Payables against the distribution    
QUANTITY_DELIVERED NUMBER       Quantity delivered against the distribution    
RECOVERABLE_TAX NUMBER       The Recoverable exclusive tax amount for the distribution.    
NONRECOVERABLE_TAX NUMBER       The Nonrecoverable exclusive tax amount for the distribution.    
RECOVERABLE_INCLUSIVE_TAX NUMBER       The portion of the taxes paid that is included in the Distribution Ordered amount and which is recoverable.    
NONRECOVERABLE_INCLUSIVE_TAX NUMBER       The portion of the taxes paid that is included in the Distribution Ordered amount and which is nonrecoverable.    
TAX_EXCLUSIVE_AMOUNT NUMBER       The Purchase order distribution amount that is exclusive of all the taxes    
AMOUNT_DELIVERED NUMBER       Amount delivered for service lines    
AMOUNT_BILLED NUMBER       Amount invoiced by Oracle Payables against the distribution    
AMOUNT_CANCELLED NUMBER       Amount cancelled for service lines    
REQ_BU_ID NUMBER 38 0   REQ_BU_ID    
DELIVER_TO_PERSON_ID NUMBER 38 0   Unique identifier for the requester. References HR_EMPLOYEES.EMPLOYEE_ID    
QUANTITY_ORDERED NUMBER       Quantity ordered on the distribution    
RATE_DATE DATE       Currency conversion date    
RATE NUMBER       Currency conversion rate    
DELIVER_TO_LOCATION_ID NUMBER 38 0   Unique identifier for the delivery location    
DELIVER_TO_CUST_LOCATION_ID NUMBER 38 0   The final location where goods will be delivered that were previously received from a supplier    
CODE_COMBINATION_ID NUMBER 38 0   Unique identifier for the General Ledger charge account    
CREATED_BY VARCHAR2 64     Who column: indicates the user who created the row    
DELIVER_TO_CUST_ID NUMBER 38 0   Customer to whom merchandise is being delivered    
PUOM_QUANTITY_CANCELLED NUMBER       Quantity cancelled for the distribution in PUOM    
PUOM_CONSIGNMENT_QUANTITY NUMBER       Quantity In Consigned Inventory after deliver transaction in PUOM    
PUOM_QUANTITY_BILLED NUMBER       Quantity invoiced by Oracle Payables against the distribution in PUOM    
PUOM_QUANTITY_DELIVERED NUMBER       Quantity delivered against the distribution in PUOM    
PUOM_QUANTITY_ORDERED NUMBER       Quantity ordered on the distribution in PUOM    
PJC_PROJECT_ID NUMBER 38 0   Project Related Attribute at Purhcase Order Distribution    
PJC_TASK_ID NUMBER 38 0   Task Related Attribute at Purhcase Order Distribution    
PJC_ORGANIZATION_ID NUMBER 38 0   Project Organization Attribute at Purhcase Order Distribution    
PJC_EXPENDITURE_TYPE_ID NUMBER 38 0   Project Expenditure Type Attribute at Purhcase Order Distribution    
LO_PO_SCHEDULE_ID NUMBER 38 0   Document shipment schedule unique identifier    
LO_PO_SCHEDULE_NUMBER NUMBER       Shipment line number    
LO_SHIP_TO_ORGANIZATION_ID NUMBER 38 0   Ship-to organization unique identifier    
LO_MATCH_OPTION VARCHAR2 32     Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt    
LO_SHIP_TO_CUST_ID NUMBER 38 0   Customer to whom merchandise is being sent    
LO_SHIP_TO_CUST_LOCATION_ID NUMBER 38 0   Attribute,Location where the supplier should ship the goods    
LO_SHIP_TO_LOCATION_ID NUMBER 38 0   Unique identifier for the ship-to location (References HR_LOCATIONS_ALL.location_id)    
LO_COUNTRY_OF_ORIGIN_CODE VARCHAR2 16     Country of manufacture for this shipment    
LO_DESTINATION_TYPE_CODE VARCHAR2 32     Final destination of the purchased items    
LO_BACK_TO_BACK_FLAG VARCHAR2 16     Indicates the purchase order schedule has a backing sales order that is fulfilled using a back to back order.    
LO_NOTE_TO_RECEIVER VARCHAR2 2048     Shipment level Note to receiver, which would hold the note to receiver info coming from req lines.    
LO_FINAL_DISCHARGE_LOCATION_ID NUMBER 38 0   The final discharge location identifier.    
LO_PRODUCT_TYPE VARCHAR2 256     The value of product type specifies whether the transaction line is for a good, or a service, or it is a memo line.    
LO_RECEIVING_ROUTING_ID NUMBER 38 0   Receipt routing unique identifier(References RCV_ROUTING_HEADERS.routing_header_id)    
LO_ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2 16     Indicates whether substitute items can be received in place of the ordered items    
LO_QUANTITY_RECEIVED NUMBER       Quantity received until today    
LO_QUANTITY_SHIPPED NUMBER       Quantity shipped    
LO_QUANTITY_ACCEPTED NUMBER       Quantity accepted after inspection, up until today    
LO_QUANTITY_REJECTED NUMBER       Quantity rejected after inspection, up until today    
LO_AMOUNT_ACCEPTED NUMBER       Amount Accepted for service lines    
LO_AMOUNT_RECEIVED NUMBER       Stores the amount received for service lines    
LO_AMOUNT_SHIPPED NUMBER       Amount pending for Work Confirmation    
LO_DAYS_EARLY_RECEIPT_ALLOWED NUMBER       Amount pending for Work Confirmation    
LO_DAYS_LATE_RECEIPT_ALLOWED NUMBER       Amount pending for Work Confirmation    
LO_PROMISED_DATE TIMESTAMP       Promised Delivery Date. A date that the supplier has promised to deliver the ordered item or service    
LO_NEED_BY_DATE TIMESTAMP       Requested Delivery Date. A date that the buying company requests the ordered item or service to be delivered    
LO_QUANTITY NUMBER       Amount pending for Work Confirmation    
LO_QUANTITY_CANCELLED NUMBER       Amount pending for Work Confirmation    
LO_UOM_CODE VARCHAR2 16     Unit of measure for the quantity ordered    
LO_PROMISED_SHIP_DATE TIMESTAMP       A date that the supplier has promised to ship the item ordered by the buying company    
LO_REQUESTED_SHIP_DATE TIMESTAMP       A date that the buying company requests the ordered item ready to ship    
LO_CLOSED_FOR_INVOICE_DATE DATE       Date when the Shipment is closed for Invoice    
LO_CLOSED_FOR_RECEIVING_DATE DATE       Date when the Shipment is closed for receiving    
LO_CANCEL_DATE DATE       Cancellation date    
LO_SHIPMENT_CLOSED_DATE DATE       Date when the Shipment is closed for both Receiving and Invoice    
LO_INSPECTION_REQUIRED_FLAG VARCHAR2 16     Indicates whether shipment must be inspected before the invoice is paid    
LO_RECEIPT_REQUIRED_FLAG VARCHAR2 16     Indicates whether shipment must be received before the invoice is paid    
LO_SCHEDULE_STATUS VARCHAR2 32     Shipment status(applicable only to SPO)    
LO_MODE_OF_TRANSPORT VARCHAR2 32     Type of transportation used to ship the product, such as truck, air or boat    
LO_CARRIER_ID NUMBER 38 0   Type of carrier for the RFQ or quotation shipment    
LO_SERVICE_LEVEL VARCHAR2 32     Priority of transportation that affects how quickly goods are transported    
LO_PRICE_OVERRIDE NUMBER       Order shipment price or break price for blanket purchase orders, RFQs, and quotations    
LO_PUOM_CODE VARCHAR2 16     Primary Unit of Measure based on the Item and ShiptoOrgnazation    
LO_PUOM_CONVERSION_FACTOR NUMBER       Primary Unit of Measure based on the Item and ShiptoOrgnazation ConversionFactor    
LO_PUOM_QUANTITY NUMBER       Quantity ordered on the line Location in PUOM    
LO_PUOM_QUANTITY_CANCELLED NUMBER       Quantity Cancelled on the Line Location in PUOM    
LO_PUOM_QUANTITY_RECEIVED NUMBER       Quantity received until today in PUOM    
LO_PUOM_QUANTITY_SHIPPED NUMBER       Quantity shipped in PUOM    
LO_PUOM_QUANTITY_ACCEPTED NUMBER       Quantity accepted after inspection, up until today in PUOM    
LO_PUOM_QUANTITY_REJECTED NUMBER       Quantity rejected after inspection, up until today in PUOM    
LO_SALES_ORDER_NUMBER VARCHAR2 64     Backing Sales Order Number    
LO_SALES_ORDER_LINE_NUMBER VARCHAR2 64     Backing Sales Order Line Number    
LO_SALES_ORDER_SCHEDULE_NUMBER VARCHAR2 64     Backing Sales Order Schedule Number    
LO_CUSTOMER_PO_NUMBER VARCHAR2 64     Customer PO number on the Sales Order.    
LO_CUSTOMER_PO_LINE_NUMBER VARCHAR2 64     Customer PO number on the Sales Line Order.    
LO_CUSTOMER_PO_SCHEDULE_NUMBER VARCHAR2 64     Customer PO number on the Sales Schedule Order.    
L_PURCHASE_ORDER_LINE_ID NUMBER 38 0   PO_LINE_ID    
L_PURCHASE_ORDER_LINE_NUMBER NUMBER       Line number    
L_BLANKET_AGREEMENT_ID NUMBER 38 0   Unique identifier of the quotation    
L_CONTRACT_AGREEMENT_ID NUMBER 38 0   Contract PA reference of a line    
L_SUPPLIER_ITEM_NAME VARCHAR2 512     Supplier item number    
L_NEGOTIATED_FLAG VARCHAR2 16     Indicates whether the buyer negotiated the price or not    
L_AUCTION_HEADER_ID NUMBER 38 0   Reference to the negotiation id in sourcing    
L_AUCTION_LINE_NUMBER NUMBER       Reference to the negotiation line number in Sourcing    
L_MATCH_BASIS VARCHAR2 32     Matching basis of the line type    
L_PO_LINE_TYPE_ID NUMBER 38 0   Line type unique identifier PO_LINE_TYPES_B LINE_TYPE_ID
L_PURCHASE_BASIS VARCHAR2 32     Purchase basis of the line type    
L_PURCHASING_CATEGORY_ID NUMBER 38 0   Item category unique identifier EGP_CATEGORIES_B CATEGORY_ID
L_ITEM_ID NUMBER 38 0   Item unique identifier. DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
L_ITEM_DESCRIPTION VARCHAR2 256     Item description.    
L_VENDOR_PRODUCT_NUM VARCHAR2 512     Supplier item number    
L_LINE_STATUS VARCHAR2 32     Line status    
L_NOTE_TO_VENDOR VARCHAR2 2048     Short note to supplier    
L_UNIT_PRICE NUMBER       Unit price for the line. (Defaulted from EGP_SYSTEM_ITEMS_B.list_price_per_unit, converted to the document's currency.)    
L_QUANTITY NUMBER       Quantity ordered on the line    
L_DISCOUNT NUMBER       Value which indicates the discount percent or amount of the purchase order line    
L_DISCOUNT_TYPE VARCHAR2 32     Type that indicates whether the discount is based on percent or amount    
L_DISCOUNT_REASON VARCHAR2 256     Description of the reason for the discount    
L_CANCEL_REASON VARCHAR2 256     Cancellation reason provided by employee    
L_CLOSED_REASON VARCHAR2 256     Describes why the line is closed    
L_CONSIGNMENT_LINE_FLAG VARCHAR2 16     Indicates whether the item on line will be purchased under consignment arrangement from supplier. Values: Y/N. Applicable to both BPA and PO Lines.    
L_CREATION_DATE DATE       Creation date    
L_CANCEL_DATE DATE       Cancellation date    
L_LINE_CLOSED_DATE DATE       Date the line was closed.    
L_CANCELLED_BY NUMBER 38 0   Unique identifier of the employee who cancelled the line    
L_FROM_HEADER_ID NUMBER 38 0   Unique identifier of the quotation (standard or planned POs only) or global agreement (standard POs only) referenced by this line    
L_FROM_LINE_ID NUMBER 38 0   Unique identifier of the quotation line (standard or planned POs only) or global agreement line (standard POs only) referenced by this line    
L_MANUAL_PRICE_CHANGE_FLAG VARCHAR2 16     Only for Standard PO lines referencing a Global Agreement, Contract, or Quotation: Y if the user has manually entered a price overriding the source document price, N or null otherwise    
L_UOM_CODE VARCHAR2 16     Unit of measure for the quantity ordered    
L_ORDER_TYPE_LOOKUP_CODE VARCHAR2 32     Value basis of the line    
L_AMOUNT NUMBER       Budget Amout for temp labor standard PO lines    
L_BASE_UNIT_PRICE NUMBER       Base Unit Price    
L_PUOM_QUANTITY NUMBER       PUOM Ordered Quantity at Line Level    
H_PURCHASE_ORDER_ID NUMBER 38 0   Document header unique identifier    
H_PURCHASE_ORDER_NUMBER VARCHAR2 32     Purchase order number    
H_TYPE_LOOKUP_CODE VARCHAR2 32     Type of the document.    
H_PROCUREMENT_BU_ID NUMBER 38 0   Proc BU ID DW_INTERNAL_ORG_D ORGANIZATION_ID
H_REQUISITION_BU_ID NUMBER 38 0   Req BU ID DW_INTERNAL_ORG_D ORGANIZATION_ID
H_BUYER_ID NUMBER 38 0   Buyer unique identifier    
H_PAYMENT_TERMS_ID NUMBER 38 0   Payment terms unique identifier AP_TERMS_TL TERMS_ID
H_MODE_OF_TRANSPORT VARCHAR2 32     Type of transportation used to ship the product, such as truck, air or boat    
H_PO_CREATION_DATE TIMESTAMP       indicates the date and time of the creation of the row    
H_BILL_TO_LOCATION_ID NUMBER 38 0   Bill-to location unique identifier (References HR_LOCATIONS_ALL.location_id)    
H_STYLE_ID NUMBER 38 0   Determines the Purchasing Style of the document.    
H_DOCUMENT_STATUS VARCHAR2 32     Header status    
H_COMMENTS VARCHAR2 256     Descriptive comments for the document    
H_CURRENCY_CODE VARCHAR2 16     Unique identifier for the currency (References FND_CURRENCIES.currency_code)    
H_PCARD_ID NUMBER 38 0   Unique identifer for the procurement card used for the order (References AP_CARDS_ALL.card_id)    
H_BUDGET_CONTROL_ENABLED_FLAG VARCHAR2 16     Flag to indicate if Budgetary conrol was enabled at the time of Purchase Order creation. Not applicable to Agreements.    
H_DOCUMENT_CREATION_METHOD VARCHAR2 32     Method in which the document got created - Autocreate, enter PO , etc...    
H_FROZEN_FLAG VARCHAR2 16     Indicates whether the document is frozen or not    
H_FUNDS_STATUS VARCHAR2 32     status to indicate whether funds have been reserved on the document or not    
H_REVISION_NUM NUMBER       Document revision number    
H_REVISED_DATE TIMESTAMP       Date the document was last revised    
H_ACCEPTANCE_DUE_DATE TIMESTAMP       Date by which the supplier should accept the purchase order    
H_ACCEPTANCE_REQUIRED_FLAG VARCHAR2 16     Indicates whether acceptance from the supplier is required or not    
H_TERMS_ID NUMBER 38 0   Payment terms unique identifier (References to AP_TERMS_TL.term_id)    
H_BUYER_MANAGED_TRANSPORT_FLAG VARCHAR2 16     A flag to indicate that the buying company is responsible for arranging the transportation, from picking up the requested goods to delivering to ship-to locations specified on the order. The value is Y/N.    
H_CONFIRMING_ORDER_FLAG VARCHAR2 16     Indicates whether the purchase order is a confirming order or not    
H_VENDOR_ID NUMBER 38 0   Supplier unique identifier    
H_VENDOR_SITE_ID NUMBER 38 0   Supplier site unique identifier    
H_APPROVED_FLAG VARCHAR2 16     Indicates whether the purchase order is approved or not    
H_RATE_TYPE VARCHAR2 32     Currency conversion rate type    
H_PAY_ON_CODE VARCHAR2 32     Indicator of whether the purchase order will be paid upon receipt    
H_CLOSED_DATE DATE       Date the document was closed    
H_CARRIER_ID NUMBER 38 0   Carrier ID (Party ID)    
H_SERVICE_LEVEL VARCHAR2 32     Priority of transportation that affects how quickly goods are transported    
H_SUPPLIER_NOTIF_METHOD VARCHAR2 32     Supplier Notification Method    
H_BILLTO_BU_ID NUMBER 38 0   Bill-to Business Unit unique identifier. This captures the business unit which vouches the supplier invoices received for a purchase orde    
H_CREATED_BY VARCHAR2 64     Who column: indicates the user who created the row.    
H_SOLDTO_LE_ID NUMBER 38 0   Sold to Legal Entity unique identifier. Indicates the party which is financially responsible for the purchases on a purchase order