Table WSB_ItemPriceImportTTE

Stores then item prices to handle.

Properties

Name	Value
Access	Public
Caption	Item Price Import
DataClassification	CustomerContent
DataPerCompany	True
DrillDownPageId	WSB_ItemPriceImportTTE
LookupPageId	WSB_ItemPriceImportTTE

Fields

ID	Type	Name	Description
1	Integer	EntryNo
2	Enum WSB_ItemPriceImportStatusTTE	Status
3	Code[20]	ItemNo
4	Code[10]	VariantCode
5	Text[100]	Description
6	Code[20]	VendorNo
7	Text[50]	VendorItemNo
8	Code[10]	CurrencyCode
9	Decimal	MinimumQuantity
10	Decimal	DirectUnitCost
11	Decimal	UnitPrice
12	Code[10]	UnitOfMeasureCode
13	Code[10]	PriceListUnitOfMeasureCode
14	Enum Price Asset Type	PriceListAssetType
15	Code[20]	PriceListAssetNo
18	Date	StartingDate
19	Date	EndingDate
20	Enum WSB_UpdatePricesMethodTTE	UpdatePrice
21	Code[20]	ItemNoSeries
22	Code[10]	ConfigTemplateCode
23	Boolean	NewItem
24	Code[20]	NewItemNo
25	Code[20]	TariffNo
26	Code[10]	CountryRegionofOriginCode
27	Decimal	NetWeight
29	Code[20]	TargetItemNo
30	Decimal	SalesLineDiscountPerc
31	Decimal	PurchLineDiscountPerc
40	Decimal	BaseUnitCost
50	Text[100]	VendorName
60	Boolean	NewVariant
61	Code[10]	NewVariantCode
62	Code[10]	TargetVariantCode
63	Text[100]	VariantDescription
70	Code[10]	TargetPriceListUnitOfMeasure
71	Enum Price Asset Type	TargetPriceListAssetType
72	Code[20]	TargetPriceListAssetNo
100	Code[20]	PurchPriceListCode
101	Enum Purchase Price Source Type	PurchPriceSourceType
102	Code[20]	PurchPriceSourceNo
110	Code[20]	SalesPriceListCode
111	Enum Sales Price Source Type	SalesPriceSourceType
112	Code[20]	SalesPriceSourceNo
115	Decimal	Factor
200	Enum WSB_ItemPriceImportVersionTTE	ImportVersion
201	Text[250]	FreeField1
202	Text[250]	FreeField2
203	Text[250]	FreeField3
204	Text[250]	FreeField4
205	Text[250]	FreeField5