WorkConfirmations
Handles confirmations of completed work for complex service or construction purchase orders, aiding accurate billing and progress tracking.
Columns
| Name | Type | Description |
| WorkConfirmationId [KEY] | Long | The unique identifier of the work confirmation. This ID is used to track individual work confirmation records within the system. |
| WorkConfirmationNumber | String | The work confirmation number assigned to the work confirmation record. This is typically a reference number for the confirmation in the procurement or work process. |
| POHeaderId | Long | The unique identifier for the purchase order header associated with the work confirmation. This ID helps link the work confirmation to a specific purchase order. |
| OrderNumber | String | The order number related to the work confirmation. This number corresponds to the purchase order and helps track the order through the system. |
| SoldToLegalEntityId | Long | The unique identifier of the legal entity that is the buyer or recipient in the transaction. This ID ensures proper identification of the party responsible for receiving the work. |
| SoldToLegalEntity | String | The name of the legal entity that the work confirmation pertains to. This entity is typically the buyer in the transaction. |
| PeriodStartDate | Date | The start date of the period covered by the work confirmation. This defines the beginning of the reporting period for the work being confirmed. |
| PeriodEndDate | Date | The end date of the period covered by the work confirmation. This defines the conclusion of the reporting period for the work being confirmed. |
| WorkConfirmationRequestDate | Datetime | The date and time when the work confirmation was requested. This timestamp helps track when the work confirmation was initiated. |
| Comments | String | Any comments or additional notes related to the work confirmation. This field is used for providing context or specific details about the work being confirmed. |
| StatusCode | String | The status code of the work confirmation. This code reflects the current state of the work confirmation within the system, such as 'Pending' or 'Approved'. |
| Status | String | The descriptive status of the work confirmation. This provides a human-readable explanation of the status code, helping users understand the work confirmation's current state. |
| WorkConfirmationSequenceNumber | Long | The sequence number assigned to the work confirmation. This number helps differentiate multiple confirmations related to the same work or purchase order. |
| CreationDate | Datetime | The date and time when the work confirmation record was created. This timestamp tracks when the work confirmation was first entered into the system. |
| CreatedBy | String | The user who created the work confirmation record. This field helps trace the origin of the work confirmation for accountability and auditing purposes. |
| LastUpdateDate | Datetime | The date and time when the work confirmation record was last updated. This helps track changes and ensure the data is current. |
| LastUpdatedBy | String | The user who last updated the work confirmation record. This field provides accountability for any modifications made to the record. |
| PODescription | String | The description of the purchase order associated with the work confirmation. This description provides more context about the goods or services being confirmed. |
| SupplierId | Long | The unique identifier of the supplier related to the work confirmation. This ID links the work confirmation to a specific supplier. |
| Supplier | String | The name of the supplier associated with the work confirmation. This helps identify the supplier responsible for the goods or services being confirmed. |
| SupplierSiteId | Long | The unique identifier of the supplier site associated with the work confirmation. This ID identifies the specific location or entity of the supplier providing the goods or services. |
| SupplierSite | String | The name of the supplier site. This helps distinguish between different locations or sites of the same supplier. |
| CurrencyCode | String | The currency code associated with the work confirmation. This code indicates the currency used for amounts in the work confirmation (for example, USD, EUR). |
| Currency | String | The name of the currency used in the work confirmation (for example, 'US Dollar', 'Euro'). This provides more context than the currency code. |
| ImportSource | String | The source from which the work confirmation was imported, if applicable. This helps trace the origin of the data and whether it was manually entered or imported from an external system. |
| PreviouslyApprovedAmount | Decimal | The previously approved amount in the work confirmation. This field tracks the amount that was approved before the current work confirmation. |
| ContractAmountToDate | Decimal | The total contract amount to date. This represents the cumulative total of all approved amounts up to the current date. |
| TotalCompletedThisPeriod | Decimal | The total amount of work completed during the current period covered by the work confirmation. |
| TotalCompletedToDate | Decimal | The total amount of work completed up to the current date. This is a cumulative total of work completed across all periods. |
| ProjectedRetainageThisPeriod | Decimal | The projected retainage (withheld amount) for the current period. This is the portion of the payment that is withheld until the work is fully completed or confirmed. |
| CurrentPaymentDue | Decimal | The amount of payment due in the current period, based on the work completed and the terms of the work confirmation. |
| BalanceToFinish | Decimal | The remaining balance to be paid once the work is completed. This field tracks how much is still owed for the completion of the work. |
| BuyerId | Long | The unique identifier of the buyer associated with the work confirmation. This ID links the work confirmation to the specific buyer handling the purchase. |
| Buyer | String | The name of the buyer associated with the work confirmation. This is typically the person or department responsible for purchasing the goods or services. |
| Finder | String | A text field used for searching or filtering work confirmation records. This helps quickly locate relevant records based on specific criteria or keywords. |
| Intent | String | The intent of the work confirmation. This field may capture whether the confirmation is for a specific purpose, such as partial or final completion. |
| SysEffectiveDate | String | The system effective date, used as a query parameter to fetch records effective as of the specified date. This helps retrieve data based on its effectiveness at a particular time. |
| EffectiveDate | Date | This query parameter is used to fetch resources that are effective as of the specified start date. It helps ensure that data retrieved matches the timeframe of interest. |