AR
ARPriceWorksheet
An accounts receivable price worksheet. Price worksheets are used to conveniently make mass changes to sales prices. Prices defined in the worksheet (ARPriceWorksheetDetail) update sales prices upon worksheet release. The entities of this type can be edited on the Sales Price Worksheets (AR202010) form, which corresponds to the ARPriceWorksheetMaint graph.
View API Entity: SalesPriceWorksheet
/entity/Default/25.200.001/SalesPriceWorksheet| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
Approved | bit | Approved | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime API | datetime | Created On | - | |
Description:No description available | ||||
Descr API | nvarchar(150) | Description | - | |
Description:No description available | ||||
Discountable | bit | Apply Discounts to Fair Value | - | |
Description:Specifies (if set to true) that the discount can be applied to a fair value price (that is, when the ARPriceWorksheet.IsFairValue property is true) in the revenue reallocation process in a deferral schedule. | ||||
EffectiveDate API | datetime | Effective Date | - | |
Description:No description available | ||||
ExpirationDate API | datetime | Expiration Date | - | |
Description:No description available | ||||
Hold API | bit | Hold | - | |
Description:No description available | ||||
IsFairValue | bit | Fair Value | - | |
Description:Specifies (if set to "true") that the price will be used in revenue reallocaiton process | ||||
IsPromotional | bit | Promotional | - | |
Description:No description available | ||||
IsProrated | bit | Prorated | - | |
Description:Specifies (if set to "true") that the price will be increased or decreased proportionaly the term specified on invoice line | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime API | datetime | Last Modified On | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OverwriteOverlapping API | bit | Overwrite Overlapping Prices | - | |
Description:No description available | ||||
RefNbr API | nvarchar(15) | Reference Nbr. | - | |
Description:No description available | ||||
SkipLineDiscounts | bit | Ignore Automatic Line Discounts | - | |
Description:Default value for the Skip Line Discounts check box in the lines. | ||||
Status API | char(1) | Status | - | |
Description:No description available | ||||
TaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||