Table: Contract Pricing

Table: ICCUPR
View: IC0274
Record Length: 132

Flags: A R 

Keys: 4

Title Flags Fields

Customer Number CUSTNOPRICEBYCATEGORYITEMNOPRICELIST
Price By D M  PRICEBYITEMNOCATEGORYCUSTNOPRICELIST
Item Number D M  ITEMNOPRICEBYCUSTNOPRICELIST
Category D M  CATEGORYPRICEBYCUSTNO

Fields: 20

Field Type Title Presentation

CUSTNO String*12 Customer Number Mask: %-12C
PRICEBY Integer Price By List:2 entries
1 = Category Code
2 = Item Number
CATEGORY String*6 Category Code Mask: %-6N
ITEMNO String*24 Item Number Mask: %-24C
PRICELIST String*6 Price List Mask: %-6N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
EXPIRE Date Expiration Date
PRICETYPE Integer Price Type List:6 entries
1 = Customer Type
2 = Discount Percentage
3 = Discount Amount
4 = Cost Plus a Percentage
5 = Cost Plus Fixed Amount
6 = Fixed Price
CUSTTYPE Integer Customer Type List:6 entries
1 = Base
2 = A
3 = B
4 = C
5 = D
6 = E
DISCPER BCD*5.5 Discount Percentage
DISCAMT BCD*10.6 Discount Amount
COSTMETHOD Integer Costing Method List:6 entries
1 = Markup Cost
2 = Standard Cost
3 = Most Recent Cost
4 = Average Cost
5 = Last Unit Cost
6 = Landed
PLUSAMT BCD*10.6 Plus Amount
PLUSPER BCD*5.5 Plus Percentage
FIXPRICE BCD*10.6 Fixed Price
STARTDATE Date Start Date
USELOWEST Boolean Use Lowest Price List:2 entries
0 = No
1 = Yes