Table: Contract Pricing

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

Keys: 1

Title  Flags  Fields

Customer Number   CUSTNO, PRICEBY, CATEGORY, ITEMNO, PRICELIST

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

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.