JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

DraftPurchaseOrderslinesschedules

The Schedules resource manages purchasing details, such as ship-to location and delivery date.

Columns

Name Type Description
DraftPurchaseOrdersPOHeaderId [KEY] Long DraftPurchaseOrdersPOHeaderId of DraftPurchaseOrderslinesschedules
LinesPOLineId [KEY] Long LinesPOLineId of DraftPurchaseOrderslinesschedules
LineLocationId [KEY] Long LineLocationId of DraftPurchaseOrderslinesschedules
ScheduleNumber Decimal Number that uniquely identifies the purchase order schedule for the purchase order line.
POLineId Long Value that uniquely identifies the parent line of the schedule. This attribute is used when the schedule is split.
LineNumber Decimal LineNumber of DraftPurchaseOrderslinesschedules
POHeaderId Long Value that uniquely identifies the purchase order.
OrderNumber String OrderNumber of DraftPurchaseOrderslinesschedules
Quantity Decimal Scheduled quantity of the item.
Amount Decimal Amount of the service on the purchase order schedule.
ShipToOrganizationId Long Value that uniquely identifies the inventory organization where the supplier ships the item.
ShipToOrganizationCode String Abbreviation that identifies the inventory organization where the supplier ships the item.
ShipToOrganization String Name of the inventory organization that receives the item.
ShipToLocation String Name of the location where the supplier ships the item.
ShipToLocationId Long Value that uniquely identifies the location where the supplier ships the item.
ShipToLocationCode String Abbreviation that identifies the location where the supplier ships the item.
ShipToLocationInternalCode String Abbreviation that internally identifies the location where the supplier should ship the goods.
DestinationTypeCode String Value that indicates how to use the item during fulfillment. Values include inventory, expense, drop ship, or manufacturing.
DestinationType String Type of destination that determines how to charge the item. Values include inventory, expense, drop ship, or work order.
LocationOfFinalDischargeId Long Value that uniquely identifies the final discharge location.
LocationOfFinalDischargeCode String Abbreviation that identifies the final discharge location.
TransactionBusinessCategoryId Long Value that uniquely identifies the classification or categorization of a transaction. This attribute is used for tax purposes as required by a tax authority.
TransactionBusinessCategoryCode String Abbreviation that identifies the classification or categorization of a transaction. This attribute is used for tax purposes as required by a tax authority.
TransactionBusinessCategory String Classification or categorization of a transaction. This attribute is used for tax purposes as required by a tax authority.
UserDefinedFiscalClassificationCode String Abbreviation that identifies the user-defined fiscal classification.
UserDefinedFiscalClassification String Additional classification of the transaction for tax purposes.
ProductFiscalClassificationId Long Value that uniquely identifies the fiscal classification of a product by tax authority for tax purposes. It is based on the inventory item category.
ProductFiscalClassificationCode String Abbreviation that identifies the fiscal classification of a product by tax authority for tax purposes.
ProductFiscalClassification String Tax classification used by a tax authority to categorize a product.
ProductCategoryCode String Abbreviation that identifies the category used to classify products for tax purposes.
ProductCategory String Name of the category used to classify products for tax purposes.
LineIntendedUseId Long Value that uniquely identifies the intended use of a product in the business by the purchaser.
LineIntendedUse String Purpose for which a product is likely to be used in the business by the purchaser.
ProductTypeCode String Abbreviation that identifies the product type.
ProductType String Value that determines how the tax is calculated. Values include goods and services.
AssessableValue Decimal Value of the product that can be assessable.
TaxClassificationCode String Abbreviation that identifies the tax classification.
TaxClassification String Grouping of taxes for reporting and processing purposes.
InvoiceCloseTolerancePercent Decimal Percent that the application uses to determine whether to close a purchase order schedule when the invoice invoices only part of the item.
ReceiptCloseTolerancePercent Decimal Percent that the application uses to determine whether to close a purchase order schedule when the receiver receives only part of the item.
EarlyReceiptToleranceDays Decimal Maximum number of days the application allows to receive an early shipment.
LateReceiptToleranceDays Decimal Maximum number of days the application allows to receive a late shipment.
AccrueAtReceiptFlag Bool Contains one of the following values: true or false. If true, then accrue the purchase order schedule at receipt. If false, then do not accrue the purchase order schedule at receipt. This attribute does not have a default value.
ReceiptRoutingId Long Value that uniquely identifies the routing to use when receiving the item. Values include 1 for standard receipt, 2 for inspection required, or 3 for direct delivery.
ReceiptRouting String Value that indicates the routing to use when receiving the item. Values include standard receipt, inspection required, or direct delivery.
InvoiceMatchOptionCode String Determines whether the invoice for the purchase order schedule must match the purchase order or the receipt. Values include C for consumption advice, P for order, or R for receipt.
InvoiceMatchOption String Determines whether to match the invoice to the purchase order or the receipt. If the purchase order line is under consignment, then match each invoice to the consumption advice.
InspectionRequiredFlag Bool Contains one of the following values: true or false. If true, then the schedule must be inspected before the buyer can pay the invoice. If false, then the buyer can pay the invoice even if the schedule hasn't been inspected. This attribute does not have a default value.
ReceiptRequiredFlag Bool Contains one of the following values: true or false. If true, then the schedule must be received before the buyer can pay the invoice. If false, then the buyer can pay the invoice even if the schedule hasn't been received. This attribute does not have a default value.
MatchApprovalLevelCode String Abbreviation that identifies the match approval level.
MatchApprovalLevel String Value that specifies how quantities on the purchase order, receipt, inspection, and invoice must match before the buyer can pay the invoice. Values include 2-way, 3-way, or 4-way.
AllowSubstituteReceiptsFlag Bool Contains one of the following values: true or false. If true, then the purchase order schedule allows the application to use a substitute item in place of the ordered item. If false, then the purchase order schedule does not allow a substitute item. This attribute does not have a default value.
FirmFlag Bool FirmFlag of DraftPurchaseOrderslinesschedules
OverReceiptTolerancePercent Decimal Percent tolerance to use when receiving more than the ordered quantity or amount without starting the action that the OverReceiptActionCode attribute specifies.
BackToBackFlag Bool BackToBackFlag of DraftPurchaseOrderslinesschedules
NoteToReceiver String Note that the receiver can read to get details about how to process the purchase order schedule.
RequestedDeliveryDate Date Date when the buyer requested that the supplier deliver the item.
PromisedDeliveryDate Date Date when the supplier promises to deliver the item to the buyer.
RequestedShipDate Date Date when the buyer requested that the supplier ship the item.
PromisedShipDate Date Date when the supplier promises to ship the item to the buyer.
SalesOrderNumber String SalesOrderNumber of DraftPurchaseOrderslinesschedules
SalesOrderLineNumber String SalesOrderLineNumber of DraftPurchaseOrderslinesschedules
SalesOrderScheduleNumber String SalesOrderScheduleNumber of DraftPurchaseOrderslinesschedules
SecondaryQuantity Decimal Scheduled quantity in the secondary unit of measure. This attribute is applicable when more than one unit of measure controls the item.
TaxableFlag Bool TaxableFlag of DraftPurchaseOrderslinesschedules
Carrier String Company that transports the item.
CarrierId Long Value that uniquely identifies the company that transports the item.
CountryOfOrigin String Country of the organization that ships or exports the item.
CountryOfOriginCode String Abbreviation that identifies the country of the organization that ships or exports the item.
ShipToExceptionAction String Action to take if an exception occurs when the receiving location is different from the ship-to location. Values include none, reject, and warning.
ShipToExceptionActionCode String Value that indicates how to handle each receipt when the receiving location is different from the ship-to location. Values include none, reject, or warning.
FundsStatusCode String FundsStatusCode of DraftPurchaseOrderslinesschedules
FundsStatus String FundsStatus of DraftPurchaseOrderslinesschedules
ModeOfTransport String Mode of transport to ship the item, such as truck, air, or boat.
ModeOfTransportCode String Abbreviation that identifies the mode of transport.
CancelDate Date CancelDate of DraftPurchaseOrderslinesschedules
CancelReason String Description of the reason for cancellation.
CancelledBy Long CancelledBy of DraftPurchaseOrderslinesschedules
RejectedReason String RejectedReason of DraftPurchaseOrderslinesschedules
ReasonForChange String Reason for changing the schedule.
ChangeAcceptedFlag Bool ChangeAcceptedFlag of DraftPurchaseOrderslinesschedules
ChangeOrderAmountCancelled Decimal ChangeOrderAmountCancelled of DraftPurchaseOrderslinesschedules
ChangeOrderQuantityCancelled Decimal ChangeOrderQuantityCancelled of DraftPurchaseOrderslinesschedules
CustomerItem String CustomerItem of DraftPurchaseOrderslinesschedules
CustomerItemDescription String CustomerItemDescription of DraftPurchaseOrderslinesschedules
CustomerPOLineNumber String CustomerPOLineNumber of DraftPurchaseOrderslinesschedules
CustomerPONumber String CustomerPONumber of DraftPurchaseOrderslinesschedules
CustomerPOScheduleNumber String CustomerPOScheduleNumber of DraftPurchaseOrderslinesschedules
CurrencyCode String CurrencyCode of DraftPurchaseOrderslinesschedules
Currency String Currency of DraftPurchaseOrderslinesschedules
RejectedBy Long RejectedBy of DraftPurchaseOrderslinesschedules
RejectedByRole String RejectedByRole of DraftPurchaseOrderslinesschedules
CancelFlag Bool Contains one of the following values: true or false. If true, then the schedule is canceled. If false, then the schedule is not canceled. This attribute does not have a default value.
SecondaryUOMCode String SecondaryUOMCode of DraftPurchaseOrderslinesschedules
SecondaryUOM String SecondaryUOM of DraftPurchaseOrderslinesschedules
UOMCode String Abbreviation that identifies the unit of measure.
UOM String Unit of measure in the item quantity.
PricingUOMCode String Abbreviation that identifies the unit of measure the item uses for pricing.
PricingUOM String PricingUOM of DraftPurchaseOrderslinesschedules
ReceiptDateExceptionActionCode String Action to take when the application does not receive the purchase ordered quantity or amount before the value that the Late Receipt Tolerance Days attribute specifies. Values include none, reject, or warning.
ReceiptDateExceptionAction String Action to take when the buyer does not receive the purchase ordered quantity or does not receive the amount before the value that the Late Receipt Tolerance Days attribute specifies. Values include none, reject, or warning.
OverReceiptActionCode String Abbreviation that identifies the over receipt action.
OverReceiptAction String Action to take when the receipt exceeds the value that the OverReceiptTolerancePercent attribute specifies. Values include none, reject, or warning.
WorkOrderId Long WorkOrderId of DraftPurchaseOrderslinesschedules
WorkOrderNumber String WorkOrderNumber of DraftPurchaseOrderslinesschedules
WorkOrderOperationId Long WorkOrderOperationId of DraftPurchaseOrderslinesschedules
WorkOrderOperationSequence Decimal WorkOrderOperationSequence of DraftPurchaseOrderslinesschedules
WorkOrderSubType String WorkOrderSubType of DraftPurchaseOrderslinesschedules
SupplierOrderLineNumber String SupplierOrderLineNumber of DraftPurchaseOrderslinesschedules
OrchestrationAgreementLineNumber Long OrchestrationAgreementLineNumber of DraftPurchaseOrderslinesschedules
OrchestrationAgreementNumber String OrchestrationAgreementNumber of DraftPurchaseOrderslinesschedules
PrimaryTradeRelationshipId Long PrimaryTradeRelationshipId of DraftPurchaseOrderslinesschedules
POTradingOrganizationId Long POTradingOrganizationId of DraftPurchaseOrderslinesschedules
POTradingOrganizationCode String POTradingOrganizationCode of DraftPurchaseOrderslinesschedules
POTradingOrganization String POTradingOrganization of DraftPurchaseOrderslinesschedules
FirmStatusLookupCode String FirmStatusLookupCode of DraftPurchaseOrderslinesschedules
FirmStatus String FirmStatus of DraftPurchaseOrderslinesschedules
ParentLineLocationId Long ParentLineLocationId of DraftPurchaseOrderslinesschedules
ParentScheduleNumber Decimal Number that uniquely identifies the schedule from which this schedule was created.
ShipToCustomerContactId Long ShipToCustomerContactId of DraftPurchaseOrderslinesschedules
ShipToCustomerContact String ShipToCustomerContact of DraftPurchaseOrderslinesschedules
ShipToCustomerId Long ShipToCustomerId of DraftPurchaseOrderslinesschedules
ShipToCustomer String ShipToCustomer of DraftPurchaseOrderslinesschedules
ShipToCustomerLocationId Long ShipToCustomerLocationId of DraftPurchaseOrderslinesschedules
ServiceLevelCode String Abbreviation that identifies the service level for the shipping method.
ServiceLevel String Priority that determines how quickly to transport the item.
CancelUnfulfilledDemandFlag Bool Contains one of the following values: True or False. If True, then cancel all the associated requisitions while canceling a purchase order schedule. If False, then do not cancel the associated requisitions while canceling an order schedule. This attribute does not have a default value.
CreatedBy String CreatedBy of DraftPurchaseOrderslinesschedules
CreationDate Datetime CreationDate of DraftPurchaseOrderslinesschedules
LastUpdateDate Datetime LastUpdateDate of DraftPurchaseOrderslinesschedules
LastUpdatedBy String LastUpdatedBy of DraftPurchaseOrderslinesschedules
ShippingMethod String Transportation method for the carrier or service level for the purchase order. For example, ABC Shipping - AIR - 2nd Day.
RetainageRate Decimal Percentage of the invoice value that can be withheld as retainage.
LastAcceptableDeliveryDate Date LastAcceptableDeliveryDate of DraftPurchaseOrderslinesschedules
LastAcceptableShipDate Date LastAcceptableShipDate of DraftPurchaseOrderslinesschedules
OriginalPromisedDeliveryDate Date OriginalPromisedDeliveryDate of DraftPurchaseOrderslinesschedules
OriginalPromisedShipDate Date OriginalPromisedShipDate of DraftPurchaseOrderslinesschedules
Type String Type of payment whether it is released based on units of work or lump sum.
Description String Description of the work associated with the progress payment schedule.
Price Decimal Price of the purchase order schedule.
TypeCode String Abbreviation that identifies the progress payment schedule type. Valid values are rate and lump sum.
Finder String Finder of DraftPurchaseOrderslinesschedules
Intent String Intent of DraftPurchaseOrderslinesschedules
SysEffectiveDate String SysEffectiveDate of DraftPurchaseOrderslinesschedules

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