PurchaseRequisitionslinesdistributions
Splits the requisition line cost across multiple accounts or projects, aiding correct budget and financial reporting.
Columns
| Name | Type | Description |
| PurchaseRequisitionsRequisitionHeaderId [KEY] | Long | The unique identifier for the requisition header associated with the distribution, linking the distribution to the specific requisition. Example: 1001 for Requisition Header 1001. |
| LinesRequisitionLineId [KEY] | Long | The identifier for the requisition line within the requisition header, linking the distribution to a specific line item. Example: 2001 for Line 1. |
| RequisitionDistributionId [KEY] | Long | The unique identifier for the distribution associated with a requisition line, used to track the allocation of costs and resources. Example: 3001 for Distribution ID 3001. |
| RequisitionLineId | Long | The unique identifier for the requisition line, linking the distribution to a specific item or service requested. Example: 4001 for Line ID 4001. |
| Quantity | Decimal | The quantity of goods being purchased in this requisition distribution. Example: 10 for ten units of a product. |
| DistributionNumber | Decimal | A number that uniquely identifies the distribution associated with a purchase requisition line. Example: 1 for the first distribution of a requisition line. |
| ChargeAccountId | Long | The unique identifier for the account that the purchase from a requisition is charged to, used for accounting and reporting. Example: 5001 for 'General Expense'. |
| ChargeAccount | String | The name or description of the account that the purchase is charged to. Example: 'Office Supplies' or 'Capital Equipment'. |
| CurrencyAmount | Decimal | The monetary amount associated with the distribution line in the currency of the supplier, helping to track the financial allocation. Example: 1000 for $1000 worth of goods. |
| CurrencyNonrecoverableExclusiveTax | Decimal | The amount of non-recoverable exclusive tax in the currency of the supplier for the requisition distribution. Example: 50 for $50 of tax that cannot be recovered. |
| CurrencyRecoverableExclusiveTax | Decimal | The amount of recoverable exclusive tax in the currency of the supplier for the requisition distribution. Example: 30 for $30 of tax that can be recovered. |
| ChartOfAccountId | Long | The identifier for the chart of accounts used in the requisition distribution, linking it to the specific accounting structure. Example: 1001 for 'Office Supplies Account'. |
| UserAccountOverrideFlag | Bool | Indicates whether the user has overridden the default account for the requisition distribution. Example: True if the account was manually changed. |
| BudgetDate | Date | The date from which the budget is consumed for the requisition distribution. This date helps determine which budget period is affected. Example: '2023-01-01' for the start of the year. |
| FundsStatusCode | String | The code representing the funds status for the requisition distribution, indicating whether funds are available or exhausted. Example: 'AVAILABLE' for funds that are still available. |
| FundsStatus | String | The description of the funds status for the requisition distribution, explaining whether the funds are sufficient or insufficient. Example: 'Funds Available' or 'Funds Insufficient'. |
| BindPreparerId | Long | The unique identifier for the preparer of the requisition line, linking the distribution to the preparer's data. Example: 5001 for 'John Doe'. |
| BindRequisitionHeaderId | Long | The unique identifier for the requisition header, linking the distribution to the parent requisition record. Example: 2001 for 'Requisition Header 2001'. |
| Finder | String | A placeholder used for searching and filtering requisition distributions. It helps locate specific distribution records. Example: 'Search by Distribution Number'. |
| RequisitionHeaderId | Long | The identifier for the requisition header associated with the requisition distribution. This links the distribution to the overall requisition. Example: 1001 for 'Requisition Header 1001'. |
| CUReferenceNumber | Int | The reference number used to map child aggregates, such as distributions, to their parent requisition or requisition line. Example: 2001 for 'Requisition Line 1'. |
| EffectiveDate | Date | The date from which the requisition distribution is considered effective. This is used to filter records that are valid from this date onward. Example: '2023-01-01' for the start of the year. |