JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

WorkConfirmationslines

The Lines resource manages work confirmation details, such as the total progress percent, quantity or amount of work completed for a period of performance.

Columns

Name Type Description
WorkConfirmationsWorkConfirmationId [KEY] Long WorkConfirmationsWorkConfirmationId of WorkConfirmationslines
WorkConfirmationLineId [KEY] Long WorkConfirmationLineId of WorkConfirmationslines
WorkConfirmationId Long WorkConfirmationId of WorkConfirmationslines
POLineLocationId Long Value that uniquely identifies the purchase order schedule.
Amount Decimal Amount of work completed on a progress payment schedule for a period or performance.
Quantity Decimal Quantity of work completed on a progress payment schedule for a period or performance.
TotalProgressPercent Decimal Value that indicates the percent of the work completed on a progress payment schedule.
POLineId Long Value that uniquely identifies the purchase order line.
POScheduleNumber Decimal Number that uniquely identifies the purchase order schedule for the purchase order line.
WorkConfirmationNumber String WorkConfirmationNumber of WorkConfirmationslines
POLineNumber Decimal Number that uniquely identifies the purchase order line.
CreationDate Datetime CreationDate of WorkConfirmationslines
CreatedBy String CreatedBy of WorkConfirmationslines
LastUpdateDate Datetime LastUpdateDate of WorkConfirmationslines
LastUpdatedBy String LastUpdatedBy of WorkConfirmationslines
POScheduleDescription String POScheduleDescription of WorkConfirmationslines
UOMCode String UOMCode of WorkConfirmationslines
UOM String UOM of WorkConfirmationslines
ScheduleTypeCode String ScheduleTypeCode of WorkConfirmationslines
ScheduleType String ScheduleType of WorkConfirmationslines
PreviouslyApprovedAmount Decimal PreviouslyApprovedAmount of WorkConfirmationslines
ProjectedRetainageThisPeriod Decimal ProjectedRetainageThisPeriod of WorkConfirmationslines
ScheduledValue Decimal ScheduledValue of WorkConfirmationslines
TotalProjectedRetainageToDate Decimal TotalProjectedRetainageToDate of WorkConfirmationslines
TotalCompleted Decimal TotalCompleted of WorkConfirmationslines
BalanceToFinish Decimal BalanceToFinish of WorkConfirmationslines
Price Decimal Price of WorkConfirmationslines
MaximumRetainageAmount Decimal MaximumRetainageAmount of WorkConfirmationslines
RetainageRate Decimal RetainageRate of WorkConfirmationslines
ScheduledQuantity Decimal ScheduledQuantity of WorkConfirmationslines
Finder String Finder of WorkConfirmationslines
Intent String Intent of WorkConfirmationslines
SysEffectiveDate String SysEffectiveDate of WorkConfirmationslines

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062