Channel Transaction Headers
The Channel Transaction Headers view object contains detailed information about the transaction headers that are loaded in the application. For example, sales orders or supplier invoice transactions.
Data Store Key : FscmTopModelAM.ScmExtractAM.CjmBiccExtractAM.ChannelTransactionHeadersExtractPVO
Primary Keys : DocumentHeaderId
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 Header descriptive flexfield. |
| AttributeChar1 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar10 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar11 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar12 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar13 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar14 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar15 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar16 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar17 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar18 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar19 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar2 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar20 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar3 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar4 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar5 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar6 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar7 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar8 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeChar9 | Character segment for the Channel Transaction Header descriptive flexfield. |
| AttributeDate1 | Date segment for the Channel Transaction Header descriptive flexfield. |
| AttributeDate2 | Date segment for the Channel Transaction Header descriptive flexfield. |
| AttributeDate3 | Date segment for the Channel Transaction Header descriptive flexfield. |
| AttributeDate4 | Date segment for the Channel Transaction Header descriptive flexfield. |
| AttributeDate5 | Date segment for the Channel Transaction Header descriptive flexfield. |
| AttributeNumber1 | Number segment for the Channel Transaction Header descriptive flexfield. |
| AttributeNumber10 | Number segment for the Channel Transaction Header descriptive flexfield. |
| AttributeNumber2 | Number segment for the Channel Transaction Header descriptive flexfield. |
| AttributeNumber3 | Number segment for the Channel Transaction Header descriptive flexfield. |
| AttributeNumber4 | Number segment for the Channel Transaction Header descriptive flexfield. |
| AttributeNumber5 | Number segment for the Channel Transaction Header descriptive flexfield. |
| AttributeNumber6 | Number segment for the Channel Transaction Header descriptive flexfield. |
| AttributeNumber7 | Number segment for the Channel Transaction Header descriptive flexfield. |
| AttributeNumber8 | Number segment for the Channel Transaction Header descriptive flexfield. |
| AttributeNumber9 | Number segment for the Channel Transaction Header descriptive flexfield. |
| BillOfLading | Value that identifies the bill of lading number from the source transaction. |
| BillToCustAccountId | Value that uniquely identifies the bill-to customer account in the sales order of the source transaction. |
| BillToCustomerId | Value that uniquely identifies the bill-to customer in the sales order of the source transaction. |
| BillToSiteUseId | Value that uniquely identifies the bill-to location in the sales order of the source transaction. |
| BuId | Value that uniquely identifies the business unit of the transaction. |
| Comments | Text used to capture any high-level information about the transaction. |
| CreatedBy | Indicates the user who created the transaction. |
| CreationDate | Date and time when the transaction was created. |
| DataSourceCode | Indicates the source of transaction batch data. Values are from the lookup ORA_CJM_BATCH_DATA_SOURCE. |
| DocumentCurrencyCode | Indicates the currency code of the transaction. |
| DocumentDate | Date when the transaction occurred. |
| DocumentHeaderId | Unique identifier of the transaction header created in the system. This is the primary key of the Channel Transaction Headers view object. |
| DocumentId | Internal identifier of the transaction, such as doo_headers_all.header_id or rcv_shipment_headers.shipment_header_id. For CSV data uploads, the Document ID is null. |
| DocumentNumber | Identifies the transaction number for the transaction. |
| DocumentTrxTypeCode | Indicates the transaction type code of the transaction. For example, for invoiced sales orders loaded via Load Transaction, this is derived from the doo_headers_all.order_type_code, and for PO receipts it's null. |
| DocumentTypeCode | Indicates the document type. Possible values include PO_RECEIPT, SUPPLIER_INVOICE, and SALES_ORDER. For CSV data uploads, the DocumentTypeCode is either SUPPLIER_INVOICE or SALES_ORDER. |
| JobDefinitionName | Name of the scheduled process that created the transaction. |
| JobDefinitionPackage | Indicates the package name of the job that created or most recently updated the row. |
| LastUpdateDate | Date and time when the transaction row was updated. |
| LastUpdateLogin | Session login associated with the user who most recently updated the transaction. |
| LastUpdatedBy | User who most recently updated the transaction row. |
| ObjectVersionNumber | Number of times the transaction row has been updated. |
| OrigSystemSource | Source system from which the transaction originated. |
| ReceivingInventoryOrgId | Unique identifier of the receiving inventory organization. |
| RequestId | Value that uniquely identifies the scheduled process that created or most recently updated the row. |
| ShipmentNumber | Value that identifies the shipment number of the source transaction. |
| ShippedDate | Date when source transaction was actually shipped. |
| SoldToCustomerId | Unique identifier for the sold-to customer. |
| SoldToSiteUseId | Identifier of the usage for the sold-to site. |
| VendorId | Value that uniquely identifies the supplier of the source transaction. |
| VendorSiteId | Value that uniquely identifies the supplier site of the source transaction. |
| WaybillNumber | Value that identifies the waybill number of the source transaction. |