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. |