Table: Contract Pricing

Table: ICCUPR
View: IC0274
Record length: 132
Flags: A R 

Keys: 4

Title  Flags  Fields

Customer Number  CUSTNO, PRICEBY, CATEGORY, ITEMNO, PRICELIST
Price By  D M  PRICEBY, ITEMNO, CATEGORY, CUSTNO, PRICELIST
Item Number  D M  ITEMNO, PRICEBY, CUSTNO, PRICELIST
Category  D M  CATEGORY, PRICEBY, CUSTNO

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: 5 entries
1=Markup Cost
2=Standard Cost
3=Most Recent Cost
4=Average Cost
5=Last Unit Cost
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

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.