Sales Credits

The Sales Credits view object that extracts sales credit details from the sales orders, such as sales person, percentage of sales credit, sales credit type, and so on.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.SalesCreditExtractPVO

Primary Keys : SalesCreditId

Initial Extract Date : SalesCreditCreationDate

Incremental Extract Date : SalesCreditLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
SalesCreditCreatedBy User who created the sales credit row.
SalesCreditCreationDate Date when the sales credit row was created.
SalesCreditFulfillLineId Value that identifies the fulfillment line associated to the sales credit row. This is a foreign key to the Fulfillment Lines view object.
SalesCreditHeaderId Value that identifies the sales order header associated to the sales credit row. This is a foreign key to the Sales Order Headers view object.
SalesCreditId Value that uniquely identifies the sales credit row. This is the primary key of the Sales Credits view object.
SalesCreditLastUpdateDate Date when the sales credit row was last updated.
SalesCreditLastUpdateLogin Session login associated to the user who most recently updated the sales credit row.
SalesCreditLastUpdatedBy User who most recently updated the sales credit row.
SalesCreditLineId Value that identifies the sales order line associated to the sales credit row. This is a foreign key to the Sales Order Lines view object.
SalesCreditObjectVersionNumber Number of times the sales credit row has been updated.
SalesCreditOrigSysSalesCreditRef Original reference for the sales credit from the source system.
SalesCreditPercent Percentage of sales credit that the sales person receives.
SalesCreditSalesCreditTypeId Code that identifies the type of the sales credit. For example, revenue sales credit or nonrevenue sales credit.
SalesCreditSalespersonId Value that identifies the sales person who receives the sales credit.
SalesCreditTypeDescription Description of the sales credit type.
SalesCreditTypeEnabledFlag Indicates whether the sales credit type is enabled. A list of accepted values is defined in the lookup type YES_NO.
SalesCreditTypeName Name of the sales credit type.
SalesCreditTypeRefreshNumber Refresh number for the collection program.
SalesCreditTypeSalesCreditTypeId Value that uniquely identifies the sales credit type row.
SalesCreditTypeSalesCreditTypeIdDerived Value that identifies the derived sales credit type.