WorkConfirmationslines
Details line-level entries for a work confirmation, tracking the portions of work completed or amounts to be billed.
Columns
| Name | Type | Description |
| WorkConfirmationsWorkConfirmationId [KEY] | Long | The unique identifier of the work confirmation. This ID links each line item to its respective work confirmation document. |
| WorkConfirmationLineId [KEY] | Long | The unique identifier of the specific work confirmation line. This ID allows for tracking and managing individual line items within the work confirmation. |
| WorkConfirmationId | Long | The unique identifier of the work confirmation document to which this line belongs. This establishes the relationship between the work confirmation and its associated lines. |
| POLineLocationId | Long | The unique identifier for the purchase order schedule related to this work confirmation line. It links the line to a specific location within the purchase order. |
| Amount | Decimal | The amount of work completed for this line on a progress payment schedule. It reflects the value of work done for the period or performance milestone. |
| Quantity | Decimal | The quantity of work completed for the line within the progress payment schedule. This helps to track the physical units of work completed. |
| TotalProgressPercent | Decimal | The percentage of work completed for the line as part of the overall progress payment schedule. This percentage is used for tracking completion levels. |
| POLineId | Long | The unique identifier of the purchase order line to which this work confirmation line corresponds. It links the confirmation line back to the purchase order. |
| POScheduleNumber | Decimal | The number assigned to the purchase order schedule for this line. It helps to identify the specific schedule in which the work confirmation applies. |
| WorkConfirmationNumber | String | The number of the work confirmation associated with this line. It is used to identify and reference the specific work confirmation document. |
| POLineNumber | Decimal | The number of the purchase order line that corresponds to this work confirmation line. This number is used to differentiate between multiple lines within the same purchase order. |
| CreationDate | Datetime | The date and time when the work confirmation line was created. This timestamp helps track when the line item was first logged in the system. |
| CreatedBy | String | The user who created the work confirmation line record. This helps identify the individual responsible for entering the line item into the system. |
| LastUpdateDate | Datetime | The date and time when the work confirmation line was last updated. It is important for tracking modifications and ensuring data is current. |
| LastUpdatedBy | String | The user who last updated the work confirmation line record. This helps in identifying the individual who made the most recent changes. |
| POScheduleDescription | String | A description of the purchase order schedule that this work confirmation line is tied to. This provides context about the schedule and its details. |
| UOMCode | String | The unit of measure code used for this work confirmation line. It is a shorthand notation for the unit in which the work or quantity is measured. |
| UOM | String | The full description of the unit of measure for the work confirmation line. It provides more detailed information about how the work is quantified (for example, 'Hours', 'Units'). |
| ScheduleTypeCode | String | The code that identifies the type of schedule for this work confirmation line. This helps classify the schedule (for example, 'Fixed', 'Variable'). |
| ScheduleType | String | The description of the schedule type for the work confirmation line. This provides further context about how the schedule is structured. |
| PreviouslyApprovedAmount | Decimal | The amount of work that was previously approved on this line. This helps to track the total approved amount for progress payments. |
| ProjectedRetainageThisPeriod | Decimal | The amount of retainage projected for this period. Retainage is the portion of the payment withheld until the work is completed or accepted. |
| ScheduledValue | Decimal | The scheduled value for this work confirmation line, which reflects the agreed-upon value for the work to be completed during the period. |
| TotalProjectedRetainageToDate | Decimal | The cumulative retainage amount projected to date. It includes all retainage amounts withheld across all periods up to the current date. |
| TotalCompleted | Decimal | The total amount of work completed for this line to date. This reflects the overall completion progress for the work item. |
| BalanceToFinish | Decimal | The balance of work yet to be completed for the line. This helps to track the remaining work for the project. |
| Price | Decimal | The price of the work item as it appears in the work confirmation line. This value is used for financial tracking and calculations of total cost. |
| MaximumRetainageAmount | Decimal | The maximum allowable retainage amount for this work confirmation line. It helps ensure that the retainage does not exceed contractual limits. |
| RetainageRate | Decimal | The percentage of retainage to be withheld for this work confirmation line. It is used to calculate the total amount of retainage for the work performed. |
| ScheduledQuantity | Decimal | The quantity of work that is scheduled to be completed for this line. This is used for tracking planned work versus actual work completed. |
| Finder | String | A general-purpose field for searching and filtering records in the system. It helps identify specific work confirmation lines based on user-defined criteria. |
| Intent | String | The purpose or intent behind creating or updating the work confirmation line. It provides context for the action being taken. |
| SysEffectiveDate | String | The effective date parameter used in system queries to filter resources based on their effective date range. This ensures the system retrieves the correct data for the specified period. |
| EffectiveDate | Date | The date used to fetch resources that are effective as of the specified start date. It ensures that actions are considered within their effective time range. |