PurchaseOrderslinesschedulesdistributions
Allocates purchase order schedule costs to particular accounts or projects, ensuring accurate financial tracking.
Columns
| Name | Type | Description |
| PurchaseOrdersPOHeaderId [KEY] | Long | The unique identifier for the header of the purchase order in the PurchaseOrderslinesschedulesdistributions table, linking distribution data to the purchase order header. |
| LinesPOLineId [KEY] | Long | The identifier for the individual line item within the purchase order, connecting the distribution data to the specific line in the purchase order. |
| SchedulesLineLocationId [KEY] | Long | The identifier representing the location associated with the purchase order line schedule for the distribution, helping to track the location of the distribution. |
| PODistributionId [KEY] | Long | The unique identifier for the distribution record associated with a purchase order line in the PurchaseOrderslinesschedulesdistributions table. |
| POLineId | Long | The identifier of the purchase order line item, used to reference the distribution for that specific line in the purchase order. |
| POHeaderId | Long | The identifier for the purchase order header, linking the distribution data to the overall purchase order. |
| DistributionNumber | Decimal | A unique number assigned to the distribution, identifying it within the purchase order line schedule. |
| Quantity | Decimal | The quantity of items associated with the distribution in the purchase order line schedule. |
| Ordered | Decimal | The total quantity ordered in the distribution for the purchase order line schedule. |
| TotalTax | Decimal | The total tax amount applied to the distribution for the purchase order line schedule. |
| UOMCode | String | The unit of measure code representing the quantity used for the distribution (for example, Each, Box, Pallet). |
| Total | Decimal | The total value of the distribution, including items and any applicable taxes or additional charges. |
| UOM | String | The unit of measure for the distribution quantity, such as 'Each', 'Box', or 'Pallet'. |
| CurrencyCode | String | The currency code (for example, USD, EUR) used in the distribution for the purchase order line schedule. |
| Currency | String | The name or type of currency (for example, US Dollar, Euro) used in the purchase order line schedule distribution. |
| DestinationSubinventory | String | The subinventory code that indicates where the distributed goods are being stored or allocated. |
| RequesterId | Long | The unique identifier for the individual requesting the purchase order distribution. |
| Requester | String | The name or identifier of the person or entity requesting the purchase order distribution. |
| DeliverToLocationId | Long | The identifier for the location where the distributed goods are to be delivered within the purchase order line schedule. |
| DeliverToLocationCode | String | The code for the location where the goods are being delivered, typically used for reference within the system. |
| DeliverToCustomerLocationId | Long | The identifier for the customer location to which the distributed goods are being delivered. |
| DeliverToCustomerLocation | String | The name or description of the customer location where the goods are delivered. |
| DeliverToCustomerId | Long | The identifier for the customer receiving the distributed goods, linking the distribution to a specific customer. |
| DeliverToCustomer | String | The name or identifier of the customer receiving the goods in the purchase order distribution. |
| Requisition | String | The requisition number associated with the purchase order line schedule distribution. |
| RequisitionHeaderId | Long | The unique identifier for the requisition header associated with the purchase order distribution. |
| RequisitionLine | Decimal | The line number of the requisition associated with the distribution in the purchase order line schedule. |
| RequisitionLineId | Long | The unique identifier for the requisition line associated with the purchase order line schedule distribution. |
| RequisitionDistribution | Decimal | The distribution number within the requisition, representing the allocation of the requisition to the purchase order. |
| RequisitionDistributionId | Long | The unique identifier for the requisition distribution record linked to the purchase order line schedule distribution. |
| DestinationChargeAccountId | Long | The identifier for the charge account used for the destination of the distributed goods in the purchase order line schedule. |
| DestinationChargeAccount | String | The charge account used to allocate the costs for the destination in the purchase order line schedule distribution. |
| POChargeAccountId | Long | The identifier for the purchase order charge account used in the distribution process for the purchase order line. |
| POChargeAccount | String | The charge account used for the purchase order, specifying where the financial charges related to the distribution are allocated. |
| POAccrualAccountId | Long | The identifier for the accrual account used for the purchase order line schedule distribution. |
| POAccrualAccount | String | The accrual account used for financial accounting purposes related to the purchase order line schedule distribution. |
| DestinationVarianceAccountId | Long | The identifier for the variance account used to track discrepancies in the distribution of purchase order line items. |
| DestinationVarianceAccount | String | The account used to track any variances in the distribution process of the purchase order line items. |
| POVarianceAccountId | Long | The identifier for the variance account linked to the purchase order line schedule, used to track financial discrepancies. |
| POVarianceAccount | String | The account associated with the purchase order for tracking variances in the distribution process. |
| BudgetDate | Date | The date associated with the budget for the distribution, indicating when the funds are allocated for the purchase order line schedule. |
| ConversionRateDate | Date | The date on which the currency conversion rate is based for the distribution in the purchase order line schedule. |
| ConversionRate | Decimal | The rate at which the currency is converted for the purchase order line schedule distribution. |
| ConversionRateType | String | The type of conversion rate applied for the distribution, such as 'Spot Rate' or 'Forward Rate'. |
| RecoverableInclusiveTax | Decimal | The recoverable tax amount included in the distribution, which can be reclaimed by the buyer or organization. |
| RecoverableExclusiveTax | Decimal | The recoverable tax amount exclusive of other costs, eligible for reclamation under specific conditions. |
| NonrecoverableInclusiveTax | Decimal | The non-recoverable tax amount included in the distribution, which cannot be reclaimed. |
| NonrecoverableExclusiveTax | Decimal | The non-recoverable tax amount exclusive of other costs, which cannot be reclaimed under any circumstances. |
| ScheduleNumber | Decimal | The schedule number that links the distribution to a specific schedule in the purchase order line. |
| LineNumber | Decimal | The line number associated with the purchase order line schedule distribution, used to identify individual items. |
| OrderNumber | String | The unique identifier for the order associated with the purchase order line schedule distribution. |
| CreationDate | Datetime | The date and time when the purchase order distribution was created. |
| CreatedBy | String | The username or identifier of the person who created the distribution record in the purchase order line schedule. |
| LastUpdateDate | Datetime | The date and time when the distribution record was last updated or modified. |
| LastUpdatedBy | String | The username or identifier of the person who last updated the purchase order line schedule distribution. |
| Percentage | Decimal | The percentage allocation of the distribution, typically used to divide the total order or budget across various accounts or items. |
| Status | String | The current status of the distribution, such as 'Pending', 'Approved', or 'Completed'. |
| StatusCode | String | A code representing the status of the distribution, used for tracking and workflow purposes. |
| RequesterDisplayName | String | The display name of the individual who requested the purchase order distribution, used for clarity in reports and workflows. |
| DFF | String | The Flexfield data associated with the distribution, capturing custom attributes for the purchase order line schedule. |
| projectDFF | String | The project-specific Flexfield data associated with the purchase order distribution, capturing project-related information. |
| globalDFFs | String | The global Flexfield data, capturing custom attributes that apply universally across all distributions in the system. |
| Finder | String | A placeholder or reference for the search functionality used to locate specific distribution data. |
| Intent | String | A placeholder or reference defining the action or purpose of the distribution within the system, such as 'Create', 'Update', or 'Delete'. |
| SysEffectiveDate | String | The system-effective date indicating when the distribution data became active or valid in the system. |
| EffectiveDate | Date | The date from which the distribution data is considered effective, used as a filter to retrieve records within the valid date range. |