Transfer Order Lines
The Transfer Order Lines view object contains information for the transfer order line.
Data Store Key : FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.TransferOrderLineExtractPVO
Primary Keys : TOLinePEOLineId
Initial Extract Date : TOLinePEOCreationDate
Incremental Extract Date : TOLinePEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
ActionSourceType | Type of source for the action. |
AllowItemSubstitutionFlag | Contains one of the following values: Y, N or null. If Y, then item substitution is allowed. If N or null, then item substitution isn't allowed. |
InitialRequestedQty | Value that identifies the original requested quantity when the transfer order line was first created. |
ItemSubstitutedFlag | Contains one of the following values: Y, N or null. If Y, then item has been substituted. If N or null, then item hasn't been substituted. |
RepriceFlag | Contains one of the following values: true or false. If true, then pricing can price the transfer order. If false, then pricing can't price the transfer order. This attribute doesn't have a default value, but a value of null translates to false. |
TOLinePEOAgreementPtrId | Value that uniquely identifies the partner agreement. |
TOLinePEOBackToBackFlag | Contains one of the following values: true or false. If true, then the transfer order is created to fulfill a sales order. If false, then the transfer order isn't created to fulfill a sales order. This attribute doesn't have a default value, but a value of null translates to false. |
TOLinePEOBuyAssessableValue | Deemed price at which a product is valued by a tax authority for a given tax. This attribute is used for tax calculation. |
TOLinePEOBuyDefaultTaxCountry | Code that identifies the proposed default taxation country. |
TOLinePEOBuyDocumentSubType | Code that identifies the proposed document fiscal classification. |
TOLinePEOBuyFinalDischargeLocId | Value that uniquely identifies the final discharge location. |
TOLinePEOBuyFirstPtyRegId | Value that uniquely identifies the first party tax registration for the transaction. |
TOLinePEOBuyIntendUseClassifId | Value that uniquely identifies the classification for the intended use. |
TOLinePEOBuyProductCategory | Code that identifies the product category of the transaction line. |
TOLinePEOBuyProductFiscClassif | Code that identifies the product fiscal classification of the inventory item. |
TOLinePEOBuyProductType | Code that identifies the product type of the inventory item. Valid values are GOODS and SERVICES. |
TOLinePEOBuyTaxClassifCode | Code that identifies the tax classification to buy. |
TOLinePEOBuyThirdPtyRegId | Value that uniquely identifies the third party tax registration for the transaction. |
TOLinePEOBuyTrxBusinessCategory | Code that identifies the transaction business category. |
TOLinePEOBuyUsrDefinedFiscClass | Code that identifies the fiscal classification. This attribute is defined by the user. |
TOLinePEOChangePartyId | Value that uniquely identifies the person who started the change request. |
TOLinePEOChangeRequestedDate | Date when the change was requested for a transfer order line. |
TOLinePEOChangeStatusLookup | Value that indicates the change state for a transfer order line. |
TOLinePEOComments | Comments entered by the user. |
TOLinePEOCreatedBy | User who created the transfer order line record. |
TOLinePEOCreationDate | Date and time when the transfer order line record was created. |
TOLinePEOCurrencyCode | Code that identifies the default currency of the requesting organization. |
TOLinePEODeliveredQty | Quantity that has been delivered. |
TOLinePEODestinationLocationId | Value that uniquely identifies the destination location. |
TOLinePEODestinationOrganizationId | Value that uniquely identifies the destination organization. |
TOLinePEODestinationSubinventoryCode | Code that identifies the destination subinventory. |
TOLinePEODestinationTypeLookup | Code that identifies the type of destination. A list of acceptable values is defined in the lookup type ORA_INV_TO_DESTINATION_TYPE. Review and update the value for the attribute using the Setup and Maintenance work area, and the Manage Inventory Lookups task. |
TOLinePEOFirmFlag | Contains one of the following values: true or false. If true, then the planning schedule is firmed. If false, then the planning schedule isn't firmed. This attribute doesn't have a default value, but a value of null translates to false. |
TOLinePEOFreightCarrierId | Value that uniquely identifies the carrier used on the transfer order line. |
TOLinePEOHeaderId | Value that uniquely identifies the transfer order header. |
TOLinePEOInclNonrecoverableTax | Tax that's inclusive and not recoverable. |
TOLinePEOInclRecoverableTax | Tax that's inclusive and recoverable. |
TOLinePEOInterfaceErrMsgCode | Code that identifies the error message for the interface. |
TOLinePEOInterfaceErrMsgText | Text of the error message, if any, for the interface. |
TOLinePEOInterfaceSourceCode | Code that identifies the interface source. |
TOLinePEOInterfaceStatusLookup | Value that indicates the interface state or condition of a transfer order. |
TOLinePEOInventoryItemId | Value that uniquely identifies the inventory item. |
TOLinePEOItemRevision | Revision of the inventory item. |
TOLinePEOLastUpdateDate | Date and time when the user most recently updated the transfer order line record. |
TOLinePEOLastUpdateLogin | Session login associated with the user who most recently updated the transfer order line record. |
TOLinePEOLastUpdatedBy | User who most recently updated the transfer order line record. |
TOLinePEOLineId | Value that uniquely identifies the transfer order line. |
TOLinePEOLineNumber | Number that identifies the transfer order line. |
TOLinePEOMaterialReturnRequired | Value that indicates if the return of material is required. |
TOLinePEOModeOfTransportLookup | Code that identifies the mode of transport for the shipping method. A list of accepted values is defined in the lookup type WSH_MODE_OF_TRANSPORT. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Carriers Lookups task. |
TOLinePEONeedByDate | Date when the customer requested the item to arrive. |
TOLinePEONoninclNonrecoverableTax | Tax that's not inclusive and not recoverable. |
TOLinePEONoninclRecoverableTax | Tax that's not inclusive and recoverable. |
TOLinePEONoteToReceiver | Note to the receiver on the receiving documents. |
TOLinePEONoteToSupplier | Note to the supplier on the shipping documents. |
TOLinePEOObjectVersionNumber | Number of times the object row has been updated. This attribute is used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
TOLinePEOOriginalHeaderId | Value that uniquely identifies the original transfer order header for the return transfer order. |
TOLinePEOOriginalLineId | Value that uniquely identifies the transfer order line for the return transfer order. |
TOLinePEOOriginalRequestLineId | Value that uniquely identifies the original request line. |
TOLinePEOParentItemId | Value that uniquely identifies the parent item for kit or Pick To Order items. |
TOLinePEOPlannerId | Value that uniquely identifies the planner for the item. |
TOLinePEOQtyUomCode | Code that identifies the unit of measure of the line quantity. |
TOLinePEOReceivedQty | Quantity received for the item. |
TOLinePEOReqBuId | Value that uniquely identifies the requisition business unit. |
TOLinePEORequestedQty | Quantity requested for the item. |
TOLinePEORequesterId | Value that uniquely identifies the requester. |
TOLinePEORequisitionId | Value that uniquely identifies the requisition number that the application uses to create the transfer order. |
TOLinePEORequisitionLineId | Value that uniquely identifies the requisition line that the application uses to create the transfer order. |
TOLinePEOScheduledArrivalDate | Date when the transfer order is scheduled to arrive |
TOLinePEOScheduledShipDate | Date when the transfer order is scheduled to ship. |
TOLinePEOSecondaryDeliveredQty | Quantity delivered and put away in inventory in the secondary unit of measure. |
TOLinePEOSecondaryQtyUomCode | Code that identifies the secondary unit of measure of the line quantity. |
TOLinePEOSecondaryReceivedQty | Quantity received in the secondary unit of measure. |
TOLinePEOSecondaryRequestedQty | Quantity requested in the secondary unit of measure. |
TOLinePEOSecondaryShippedQty | Quantity shipped in the secondary unit of measure. |
TOLinePEOSellAssessableValue | Deemed price at which a product is valued by a tax authority for a given tax. This attribute is used for tax calculation. |
TOLinePEOSellDefaultTaxCountry | Code that identifies the proposed default taxation country. |
TOLinePEOSellDocumentSubType | Code that identifies the proposed document fiscal classification. |
TOLinePEOSellFinalDischargeLocId | Value that uniquely identifies the final discharge location. |
TOLinePEOSellFirstPtyRegId | Value that uniquely identifies the first party tax registration for the transaction. |
TOLinePEOSellIntendUseClassifId | Value that uniquely identifies the classification for the intended use. |
TOLinePEOSellProductCategory | Code that identifies the product category of the transaction line. |
TOLinePEOSellProductFiscClassif | Code that identifies the product fiscal classification of the inventory item. |
TOLinePEOSellProductType | Code that identifies the product type of the inventory item. Valid values are GOODS and SERVICES. |
TOLinePEOSellTaxClassifCode | Code that identifies the tax classification. |
TOLinePEOSellThirdPtyRegId | Value that uniquely identifies the third party tax registration for the transaction. |
TOLinePEOSellTrxBusinessCategory | Code that identifies the transaction business category. |
TOLinePEOSellUsrDefinedFiscClass | Code that identifies the fiscal classification. This attribute is defined by the user. |
TOLinePEOServiceLevelLookup | Code that identifies the service level for the shipping method. A list of accepted values is defined in the lookup type WSH_SERVICE_LEVELS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Carriers Lookups task. |
TOLinePEOShipmentPriorityLookup | Code that identifies the priority of the shipment. A list of accepted values is defined in the lookup type WSH_SHIPPING_PRIORITY. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Shipping Lookups task. |
TOLinePEOShippedQty | Quantity shipped for the item. |
TOLinePEOSourceHeaderId | Value that uniquely identifies the source of the header for the transfer order. |
TOLinePEOSourceLineId | Value that uniquely identifies the source of the line for the transfer order. |
TOLinePEOSourceOrganizationId | Value that uniquely identifies the source organization. |
TOLinePEOSourceSubinventoryCode | Code that identifies the source subinventory. |
TOLinePEOSourceTypeLookup | Code that identifies the source that originally created the transfer order line. A list of acceptable values is defined in the lookup type INV_TO_TXN_ORIGIN. Review and update the value for the attribute using the Setup and Maintenance work area, and the Manage Inventory Lookups task. |
TOLinePEOStatusLookup | Value that indicates the state for a transfer order line. |
TOLinePEOSupplyOrderRefLineNumber | Number that identifies the source application that generated the interface record. This attribute is the document line reference number from the requesting application. |
TOLinePEOSupplyOrderReferenceNumber | Number that refers to the requesting application. |
TOLinePEOUnitPrice | Unit price of requested item. |