Channel Transaction Lines
The Channel Transaction Lines view object contains detailed information about the transaction lines that are loaded in the application.
Data Store Key : FscmTopModelAM.ScmExtractAM.CjmBiccExtractAM.ChannelTransactionLinesExtractPVO
Primary Keys : DocumentLineId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AttributeCategory | Context name for the Channel Transaction Line descriptive flexfield. |
| AttributeChar1 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar10 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar11 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar12 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar13 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar14 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar15 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar16 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar17 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar18 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar19 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar2 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar20 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar3 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar4 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar5 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar6 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar7 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar8 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeChar9 | Character segment for the Channel Transaction Line descriptive flexfield. |
| AttributeDate1 | Date segment for the Channel Transaction Line descriptive flexfield. |
| AttributeDate2 | Date segment for the Channel Transaction Line descriptive flexfield. |
| AttributeDate3 | Date segment for the Channel Transaction Line descriptive flexfield. |
| AttributeDate4 | Date segment for the Channel Transaction Line descriptive flexfield. |
| AttributeDate5 | Date segment for the Channel Transaction Line descriptive flexfield. |
| AttributeNumber1 | Number segment for the Channel Transaction Line descriptive flexfield. |
| AttributeNumber10 | Number segment for the Channel Transaction Line descriptive flexfield. |
| AttributeNumber2 | Number segment for the Channel Transaction Line descriptive flexfield. |
| AttributeNumber3 | Number segment for the Channel Transaction Line descriptive flexfield. |
| AttributeNumber4 | Number segment for the Channel Transaction Line descriptive flexfield. |
| AttributeNumber5 | Number segment for the Channel Transaction Line descriptive flexfield. |
| AttributeNumber6 | Number segment for the Channel Transaction Line descriptive flexfield. |
| AttributeNumber7 | Number segment for the Channel Transaction Line descriptive flexfield. |
| AttributeNumber8 | Number segment for the Channel Transaction Line descriptive flexfield. |
| AttributeNumber9 | Number segment for the Channel Transaction Line descriptive flexfield. |
| BillOfLading | Value that identifies the bill of lading number from the source transaction. |
| BillToLocationId | Value that uniquely identifies the bill-to location. |
| BuId | Value that uniquely identifies the business unit of the transaction. |
| CategoryId | Value that uniquely identifies the item category to which the item belongs. |
| Comments | Text used to capture any high-level information about the transaction line. |
| CreatedBy | Indicates the user who created the transaction line. |
| CreationDate | Date and time when the transaction line was created. |
| DocumentBatchId | Value that uniquely identifies the batch. |
| DocumentHeaderId | Value that uniquely identifies the channel transaction. |
| DocumentLineId | Unique identifier of the channel transaction line. This is the primary key of the Channel Transaction Lines view object. |
| DocumentLineNumber | Indicates the line number of the transaction. |
| DocumentLineReason | Indicates the name of the transaction line reason. |
| DooFulfillLineId | Value that uniquely identifies the Distributed Order Orchestration fulfillment line. |
| DooLineId | Value that uniquely identifies the Distributed Order Orchestration line. |
| ExpectedReceiptDate | Expected arrival date of the shipment. |
| InventoryOrganizationId | Unique identifier of the inventory organization used to validate items. |
| ItemDescription | Indicates the description of the item. |
| ItemId | Unique identifier of the inventory item. |
| ItemRevision | Revision number of the inventory item. |
| JobDefinitionName | Indicates the name of the job that created or most recently updated the row. |
| JobDefinitionPackage | Indicates the package name of the job that created or most recently updated the row. |
| LastUpdateDate | Indicates the date and time of the most recent update to the row. |
| LastUpdateLogin | Indicates the session login associated to the user who most recently updated the row. |
| LastUpdatedBy | Indicates the user who most recently updated the row. |
| MatchOption | Indicates whether the shipment invoice should match the purchase order or the receipt. |
| ObjectVersionNumber | Number of times the transaction row has been updated. |
| OrigDocumentLineId | Indicates the line identifier of the original transaction line. |
| OrigDocumentLineNumber | Indicates the line number of the original transaction. |
| OrigDocumentNumber | Indicates the number of the original transaction. |
| OrigSalesInvoiceId | Unique identifier of the original customer invoice. |
| OrigSalesInvoiceLineId | Unique identifier of the original customer invoice line. |
| OrigSystemLineReference | Line reference of the originating system. |
| OrigSystemReference | Reference of the originating system. |
| OrigSystemSource | Source information of the originating system. |
| OrigTransactionId | Unique identifier of the original transaction associated with the receiving line. |
| OrigTransactionNumber | Identifies the original receiving transaction number. |
| PoDate | Identifies the purchase order date. |
| PoHeaderId | Unique identifier of the purchase order. |
| PoLineId | Unique identifier of the purchase order line. |
| PoLineLocationId | Unique identifier of the purchase order location. |
| PoLineNumber | Unique identifier of the purchase order line number. |
| PoNumber | Unique identifier of the purchase order number. |
| ProgramAppliedFlag | Indicates if any program lines are applied to the transaction line. |
| Quantity | Indicates the item quantity on the line. |
| ReasonDescription | Indicates the description of the transaction reason. |
| ReasonId | Unique identifier of the inventory transaction reason. |
| ReasonName | Indicates the name of the transaction reason. |
| ReceiptNumber | Indicates the receipt number for the receiving transaction or the supplier invoice. |
| ReceivingInventoryOrgId | Unique identifier for the receiving inventory organization. |
| ReceivingLocationId | Unique identifier of the receiving location. |
| RequestId | Value that uniquely identifies the scheduled process that created or most recently updated the row. |
| RequestedArrivalDate | The date on which the buyer requests the items to arrive at the delivery location. |
| RequestedDeliveryDate | The date on which the buyer requests the items to be delivered to the specified location. |
| RequestedShipDate | The date on which the buyer requests the items to be shipped from the supplier or warehouse. |
| SalesInvoiceDate | Date that appears on the customer invoice. |
| SalesInvoiceId | Unique identifier of the customer invoice. |
| SalesInvoiceLineId | Unique identifier of the customer invoice line. |
| SalesInvoiceLineNumber | Unique identifier of the invoice line. |
| SalesInvoiceLineTypeCode | Indicates whether the invoice line corresponds to an item, tax, freight, or miscellaneous type. |
| SalesInvoiceNumber | Indicates the invoice number for the customer invoice. |
| SalesInvoiceTypeCode | Indicates the invoice type for the invoice. |
| SalesOrderLineTypeCode | Specifies the type of the fulfillment line in an order. |
| SalespersonId | Unique identifier of the salesperson. |
| ShipToCustomerId | Unique identifier of the ship-to customer. |
| ShipToLocationId | Unique identifier of the ship-to location. |
| ShipToPartySiteId | Unique identifier of the party site in the ship-to-party site address. |
| ShipToSiteUseId | Unique identifier of the ship-to site used for the selected customer site. |
| ShipmentNumber | Shipment number assigned by the shipment's source. |
| ShippedDate | Indicates the date when the shipment was created. |
| ShippedQuantity | Quantity of goods shipped. |
| ShippedUom | Unit of measure for the shipped quantity. |
| StatusCode | Indicates the status code of the line. Values are from the lookup ORA_CJM_BATCH_LINE_STATUS. |
| TpItemId | Unique identifier used for the trading partner item. |
| TpItemNum | Indicates the trading partner's item number. |
| TransactionCurrCode | Currency code for the original transaction. |
| TransactionDate | Original transaction date for the transaction. |
| TransactionId | Unique identifier for the transaction associated with the receiving line. |
| TransactionNumber | Indicates the receiving transaction number. |
| TransactionQtyInPoUom | Indicates the transaction quantity in the purchase order UOM. |
| TransactionQuantity | Transaction quantity of the original transaction. |
| TransactionType | Indicates the transaction type. |
| TransactionUnitPrice | The price per unit of the item as recorded in the transaction. |
| TransactionUomCode | Code representing the unit of measure used for the transaction. |
| UnitListPrice | The standard price of a single unit of the item before any discounts or adjustments. |
| UnitPrice | The price assigned to a single unit of the item. |
| UnitPurchasePrice | The price paid to purchase a single unit of the item. |
| UnitSellingPrice | The price at which a single unit of the item is sold. |
| UomCode | Unit of measure for the item quantity. |
| WarehouseId | Value that identifies the warehouse that's used to ship items or to receive items. |
| WaybillNumber | Value that identifies the waybill number of the source transaction. |