DraftPurchaseOrderslinesschedulesdistributions
Allocates costs of a draft purchase order schedule to accounts or projects, preparing accurate financial coding.
Columns
| Name | Type | Description |
| DraftPurchaseOrdersPOHeaderId [KEY] | Long | The unique identifier for a draft purchase order header, linking it to the corresponding purchase order line schedule distribution. |
| LinesPOLineId [KEY] | Long | The unique identifier for the purchase order line, linking this distribution to the relevant purchase order line item. |
| SchedulesLineLocationId [KEY] | Long | The identifier for the location associated with the purchase order schedule distribution, indicating where the goods or services are delivered. |
| PODistributionId [KEY] | Long | The unique identifier for the purchase order distribution, used to track individual distribution records for the purchase order line schedule. |
| DistributionNumber | Decimal | The number that uniquely identifies a specific distribution within the purchase order schedule, used to track and differentiate distributions. |
| POHeaderId | Long | The unique identifier for the purchase order, linking the distribution to the corresponding purchase order record. |
| OrderNumber | String | The order number associated with the purchase order schedule distribution, helping to track the order across the system. |
| POLineId | Long | The unique identifier for the parent line in the purchase order, used when the schedule is split into multiple distributions. |
| LineNumber | Decimal | The line number within the purchase order schedule distribution, used to identify the specific line item within the distribution. |
| LineLocationId | Long | The identifier for the location associated with the purchase order line schedule distribution. |
| ScheduleNumber | Decimal | The number of the purchase order schedule that this distribution belongs to, identifying which schedule the distribution is part of. |
| Quantity | Decimal | The distribution quantity for the item in the purchase order schedule, indicating how many units are included in this distribution. |
| Amount | Decimal | The amount calculated by multiplying the unit price by the distribution quantity, representing the monetary value of the scheduled distribution. |
| DeliverToLocationId | Long | The unique identifier for the final location that receives the item or service described in the distribution. |
| DeliverToLocationCode | String | The abbreviation or code for the final location where the item will be delivered. |
| DeliverToLocationInternalCode | String | An internal abbreviation or code for identifying the final location where goods will be delivered within the organization. |
| DeliverToLocation | String | The name of the location where the item or service is to be delivered. |
| POChargeAccountId | Long | The identifier for the account that will be charged for the purchase, used when the requisitioning business unit and sold-to legal entity are the same. |
| POChargeAccount | String | The account to charge for the purchase under this distribution, used when the requisitioning and sold-to legal entities are the same. |
| POAccrualAccountId | Long | The identifier for the account that will be charged for receipt accrual. This is used when the requisitioning and sold-to legal entities are the same. |
| POAccrualAccount | String | The account to charge for accruals when goods are received for the purchase order, used when the requisitioning and sold-to legal entities are the same. |
| POVarianceAccountId | Long | The identifier for the account to charge for price differences between the purchase order and the invoice. |
| POVarianceAccount | String | The account used to track price differences between the invoice and the purchase order. |
| DestinationChargeAccountId | Long | The identifier for the account to charge for the cost of the item in the requisitioning business unit. |
| DestinationChargeAccount | String | The account used to charge the cost of the item in the requisitioning business unit. |
| DestinationVarianceAccountId | Long | The identifier for the destination variance account used to handle any discrepancies in item costs. |
| DestinationVarianceAccount | String | The account used to handle any variance in the cost of the item being purchased. |
| RecoverableInclusiveTax | Decimal | The amount of recoverable inclusive tax for the distribution, representing tax that can be reclaimed. |
| RecoverableExclusiveTax | Decimal | The amount of recoverable exclusive tax for the distribution, representing tax that can be reclaimed. |
| NonrecoverableInclusiveTax | Decimal | The amount of nonrecoverable inclusive tax for the distribution, representing tax that cannot be reclaimed. |
| NonrecoverableExclusiveTax | Decimal | The amount of nonrecoverable exclusive tax for the distribution, representing tax that cannot be reclaimed. |
| ConversionRate | Decimal | The rate used to convert the purchase order amount into a different currency. |
| ConversionRateDate | Date | The date to use for determining the conversion rate when converting an amount into another currency, as rates can vary. |
| CurrencyCode | String | The currency code for the purchase order schedule distribution, such as USD for US dollars. |
| Currency | String | The name of the currency used for the purchase order schedule distribution (for example, US Dollars, Euros). |
| UOM | String | The unit of measure (UOM) used for the purchase order schedule distribution, indicating the measurement unit for the quantity. |
| BudgetDate | Date | The date on which the organization consumed the budget for this particular distribution. |
| ChangeAcceptedFlag | Bool | A flag indicating whether the changes made to this distribution have been accepted. |
| ChangeOrderAmountCancelled | Decimal | The amount of the change order that has been canceled, reflecting any reductions in the order. |
| ChangeOrderQuantityCancelled | Decimal | The quantity of the change order that has been canceled, reflecting any reductions in the quantity ordered. |
| DeliverToCustomerContactId | Long | The identifier for the customer contact associated with the delivery location for this distribution. |
| DeliverToCustomerContact | String | The name of the customer contact associated with the delivery of the order. |
| DeliverToCustomerId | Long | The identifier for the customer receiving the goods or services in this distribution. |
| DeliverToCustomer | String | The name of the customer receiving the goods or services in this distribution. |
| DeliverToCustomerLocationId | Long | The identifier for the location at the customer's address where the items or services will be delivered. |
| RequesterId | Long | The unique identifier for the deliver-to person or requester, identifying the person requesting the goods or services. |
| Requester | String | The name of the deliver-to person or requester for this purchase order distribution. |
| DestinationSubinventory | String | The subinventory or storage area where the item should be delivered within the organization’s inventory. |
| FundsStatusCode | String | The code representing the funds status for the purchase order schedule distribution, indicating whether funds are available. |
| FundsStatus | String | The description of the funds status for the purchase order schedule distribution, indicating whether the distribution is funded. |
| ParentDistributionId | Long | The unique identifier for the distribution from which this distribution was created, indicating the hierarchical relationship. |
| ParentDistributionNumber | Decimal | The number for the parent distribution, linking this distribution to the original one. |
| ReasonForChange | String | The reason for any changes made to the distribution, such as price adjustments or quantity changes. |
| RequisitionHeaderId | Long | The requisition header ID that links this distribution to a requisition. |
| Requisition | String | The requisition number associated with this distribution, helping to track the originating requisition. |
| RequisitionLineId | Long | The unique identifier for the requisition line related to this distribution. |
| RequisitionLine | Decimal | The line number in the requisition associated with this distribution. |
| RequisitionDistributionId | Long | The unique identifier for the requisition distribution related to this distribution. |
| RequisitionDistribution | Decimal | The distribution number associated with the requisition, linking the requisition to this distribution. |
| CreationDate | Datetime | The date and time when the distribution record was created. |
| CreatedBy | String | The user who created the distribution record, providing an audit trail for the creation of the distribution. |
| LastUpdateDate | Datetime | The date and time when the distribution record was last updated. |
| LastUpdatedBy | String | The user who last updated the distribution record, providing an audit trail for modifications. |
| UOMCode | String | An abbreviation for the unit of measure (UOM) used in the distribution, indicating how the item quantity is measured. |
| DFF | String | Descriptive flexfield (DFF) data for custom attributes related to the purchase order distribution. |
| projectDFF | String | DFF data for custom project-related attributes associated with the distribution. |
| globalDFFs | String | DFF data for global custom attributes associated with the distribution. |
| Finder | String | A search identifier used to locate specific distribution records within the system. |
| Intent | String | The intended action or purpose related to this distribution record, such as creating, reviewing, or updating a distribution. |
| SysEffectiveDate | String | The system’s effective date, indicating when the distribution record was created or last modified. |
| CUReferenceNumber | Int | An identifier used to link child aggregate records to their corresponding parent tables, ensuring data consistency. |
| EffectiveDate | Date | The effective date for the distribution, marking when the distribution is valid or active. |