Table: Vendor Contract Costs

Table: POVUPR
View: PO0181
Record Length: 475

Flags: A R 

Keys: 2

Title Flags Fields
Contract Costs ITEMNO, VDCODE
Vendor Price Lists VDCODE, ITEMNO

Fields: 53

Field Type Title Presentation
ITEMNO String*24 Item Number Mask: %-24C
VDCODE String*12 Vendor Number Mask: %-12C
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
VCPDESC String*60 Contract Cost Description
BCOSTTYPE Integer Base Cost Type List:2 entries
1 = Base Unit Cost for Single Unit of Measure
2 = Base Unit Cost for Multiple Units of Measure
BAMOUNT BCD*10.6 Base Cost Amount
DEFBUNIT String*10 Base Unit Mask: %-10c
BASECONV BCD*10.6 Base Unit Conversion
SCOSTTYPE Integer Sale Cost Type List:2 entries
1 = Sale Unit Cost for Single Unit of Measure
2 = Sale Unit Cost for Multiple Units of Measure
SDEFUSING Integer Sale Cost Based On List:3 entries
1 = Base Unit Cost Minus a Percentage
2 = Base Unit Cost Minus an Amount
3 = Fixed Amount
SPERCENT BCD*5.5 Percentage of Base
SDAMOUNT BCD*10.6 Discount Amount
SFAMOUNT BCD*10.6 Fixed Amount
DEFSUNIT String*10 Sale Unit Mask: %-10c
SALECONV BCD*10.6 Sale Unit Conversion
SALESTART Date Sale Starts
SALEEND Date Sale Ends
COSTFMT Integer Discount Based On List:2 entries
1 = Percentage
2 = Amount
COSTQTY0 BCD*10.4 Quantity Level 0
COSTQTY1 BCD*10.4 Quantity Level 1
COSTQTY2 BCD*10.4 Quantity Level 2
COSTQTY3 BCD*10.4 Quantity Level 3
COSTQTY4 BCD*10.4 Quantity Level 4
COSTQTY5 BCD*10.4 Quantity Level 5
COSTQTY6 BCD*10.4 Quantity Level 6
COSTQTY7 BCD*10.4 Quantity Level 7
COSTQTY8 BCD*10.4 Quantity Level 8
COSTQTY9 BCD*10.4 Quantity Level 9
PRCNTLVL0 BCD*5.5 Percentage Level 0
PRCNTLVL1 BCD*5.5 Percentage Level 1
PRCNTLVL2 BCD*5.5 Percentage Level 2
PRCNTLVL3 BCD*5.5 Percentage Level 3
PRCNTLVL4 BCD*5.5 Percentage Level 4
PRCNTLVL5 BCD*5.5 Percentage Level 5
PRCNTLVL6 BCD*5.5 Percentage Level 6
PRCNTLVL7 BCD*5.5 Percentage Level 7
PRCNTLVL8 BCD*5.5 Percentage Level 8
PRCNTLVL9 BCD*5.5 Percentage Level 9
AMOUNTLVL0 BCD*10.6 Amount Level 0
AMOUNTLVL1 BCD*10.6 Amount Level 1
AMOUNTLVL2 BCD*10.6 Amount Level 2
AMOUNTLVL3 BCD*10.6 Amount Level 3
AMOUNTLVL4 BCD*10.6 Amount Level 4
AMOUNTLVL5 BCD*10.6 Amount Level 5
AMOUNTLVL6 BCD*10.6 Amount Level 6
AMOUNTLVL7 BCD*10.6 Amount Level 7
AMOUNTLVL8 BCD*10.6 Amount Level 8
AMOUNTLVL9 BCD*10.6 Amount Level 9
ROUNDMETHD Integer Rounding Method List:3 entries
1 = No Rounding
2 = Round Up
3 = Round Down
ROUNDAMT BCD*10.6 Round to a Multiple Of

This page was generated on 2022-Aug-18

© 2021 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).