View: Contract Pricing

RotoID: IC0274
Table: ICCUPR
Protocol: Flat
DLL:ICCUPR

Compositions: 6

RotoID Tables Title DLL
AR0024 ARCUS Customers ARCUS
IC0310 ICITEM Items ICITEM
IC0210 ICCATG Categories ICCATG
IC0390 ICPCOD Price List Codes ICPCOD
IC0480 ICPRIC Item Pricing ICPRIC
IC0290 ICILOC Location Details ICILOC

Keys: 4

Title Fields
Customer Number CUSTNO, PRICEBY, CATEGORY, ITEMNO, PRICELIST
Price By PRICEBY, ITEMNO, CATEGORY, CUSTNO, PRICELIST
Item Number ITEMNO, PRICEBY, CUSTNO, PRICELIST
Category CATEGORY, PRICEBY, CUSTNO

Fields: 29

Field Index Type Title Attributes Presentation
CUSTNO 1 String*12 Customer Number E A K R  Mask: %-12C
PRICEBY 2 Integer Price By E A K R  List:2 entries
1 = Category Code
2 = Item Number
CATEGORY 3 String*6 Category Code E A K R  Mask: %-6N
ITEMNO 4 String*24 Item Number E A K R  Mask: %-24C
PRICELIST 5 String*6 Price List E A K R  Mask: %-6N
EXPIRE 6 Date Expiration Date E A 
PRICETYPE 7 Integer Price Type E A P  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 8 Integer Customer Type E A  List:6 entries
1 = Base
2 = A
3 = B
4 = C
5 = D
6 = E
DISCPER 9 BCD*5.5 Discount Percentage E A 
DISCAMT 10 BCD*10.6 Discount Amount E A 
COSTMETHOD 11 Integer Costing Method E A P  List:6 entries
1 = Markup Cost
2 = Standard Cost
3 = Most Recent Cost
4 = Average Cost
5 = Last Unit Cost
6 = Landed
PLUSAMT 12 BCD*10.6 Plus Amount E A 
PLUSPER 13 BCD*5.5 Plus Percentage E A 
FIXPRICE 14 BCD*10.6 Fixed Price E A 
STARTDATE 15 Date Start Date E A 
USELOWEST 16 Boolean Use Lowest Price E A  List:2 entries
0 = No
1 = Yes
CALCPRICE 50 BCD*10.6 Calculated Unit Price E A C 
CALCDECS 51 Integer Calculated Price Decimals E A C 
FMTITEMNO 52 String*24 Formatted Item Number E A C 
CUSTDESC 53 String*60 Customer Name E A C 
CATDESC 54 String*60 Category Description E A C 
ITEMDESC 55 String*60 Item Description E A C 
PRLSTDESC 56 String*60 Price List Description E A C 
CURRDESC 57 String*3 Currency Code E A C 
PRUNTDESC 58 String*10 Price Unit Description E A C 
LOCATION 59 String*6 Location E A C 
CALCVALID 60 Boolean Calculated Unit Price is Valid E A C 
PRICPRICBY 61 Integer Pricing Price By E A C  List:2 entries
1 = Quantity
2 = Weight
CHECKITEM 62 Boolean Check Item Existence E A C  List:2 entries
0 = No
1 = Yes

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).