Standard Purchase Orders Distributions Entity
Module: Purchasing
PO_DISTRIBUTION_ID
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 |