# 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: 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 2008-May-01

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