|
This data object is used to display all vendor rebate information.
This information can be found in the Vendor Rebate program within the Fusion business system.
URL
/frw/PartsVendorRebates
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AddUser | This field displays the user name that added the record. |
| AverageCost | This field displays the average cost of a given part. |
| Branch | This field displays the branch associated with the rebate. |
| CalculateCommissionsBasedOnRebatedCost | This field indicates salesman commission will be calculated based on the rebated cost of the transaction. This field will always be set with the same setting as the Use Rebated Cost at Time of Sale check box. |
| Code1 | This field displays the Code 1 field of a part record. |
| Code2 | This field displays the Code 2 field of a part record. |
| Code3 | This field displays the Code 3 field of a part record. |
| Code4 | This field displays the Code 4 field of a part record. |
| Code5 | This field displays the Code 5 field of a part record. |
| Customer | This field displays the customer attached to the given vendor rebate. |
| CustomerName | This field displays the customer’s name from the customer record. |
| CustomerPricingType | This field indicates the customer pricing type for the rebate record. |
| ExpirationDate | This field displays the date on which the given rebate expires. |
| ExtendedRebateAmount | This field contains the extended rebate amount (Quantity * Rebate Amount). |
| InsideSalesperson | This field displays the inside salesperson attached to the rebate. |
| InvoiceDate | This field displays the invoice date of the parts order associated with the rebate record. |
| InvoiceNumber | This field displays the invoice number of the parts order associated with the given rebate record. |
| LastUpdate | This field displays the date on which the give rebate was last updated. |
| UpdateUser | This field displays the user name of the individual who made the update. |
| Multiplier | This field contains the multiplier used to calculate the amount of the rebate. |
| OutsideSalesperson | This field displays the outside salesperson who is attached to a given rebate invoice. |
| PartDescription | This field displays the description of the part that is being rebated. |
| PartNumber | This field displays the part number of the part being rebated. |
| PriceFileSource | This field contains the source of the price file used to calculate the rebate. |
| PriceLevel | This field contains the price level used to calculate the rebate (List, Price 1-7, Replacement Cost). |
| Quantity | This field displays the quantity sold for a given item. |
| RebateAmount | This field contains the rebate amount. |
| RecordNotes | This field contains notes that describe the rebate. |
| ReplacementCost | This field displays the replacement cost of a given part. |
| SellingPrice | This field displays the selling price of a given part. |
| StockClass | This field displays a subset within a supplier, typically used in pricing and typically provided by the manufacturer. |
| Supplier | This field displays the supplier of the rebated part. |
| UseRebatedCostAtTimeOfSale | This setting indicates whether the rebate amount was used to calculate the cost of the transaction. |
| ValuePriceLevel | This field contains the price the rebate was calculated from if it was calculated from an inventory price. |
| Vendor | This field displays the vendor attached to a given rebate invoice. |
| VendorPrice | This field contains the price the rebate was calculated from if it was calculated from a price file price. |
| VendorPriceDescription | This field contains a description of the vendor price from the price file used to calculate the rebate. |