View: Vendor Item Numbers

RotoID: IC0340
Table: ICITMV
Protocol: Detail, Ordered revisions
DLL:ICITMV

Compositions: 3

RotoID Tables Title DLL
IC0310 ICITEM Items ICITEM
AP0015 APVEN Vendors APVEN
IC0750 ICUNIT Units of Measure ICUNIT

Keys: 3

Title Fields
Item Number ITEMNO, VENDTYPE
Vendor Type VENDTYPE, ITEMNO
Vendor Code ITEMNO, VENDNUM, VENDTYPE

Fields: 13

Field Index Type Title Attributes Presentation
ITEMNO 1 String*24 Item Number E A K R  Mask: %-24C
VENDTYPE 2 Integer Vendor Type E A  List:9 entries
1 = Vendor 1
2 = Vendor 2
3 = Vendor 3
4 = Vendor 4
5 = Vendor 5
6 = Vendor 6
7 = Vendor 7
8 = Vendor 8
9 = Vendor 9
VENDNUM 3 String*12 Vendor Number E A  Mask: %-12C
VENDNAME 4 String*60 Vendor Name E A 
VENDITEM 5 String*24 Vendor Item Number E A 
VENDCONT 6 String*60 Vendor Contact E A 
VENDCNCY 7 String*3 Vendor Currency E A  Mask: %-3N
VENDCOST 8 BCD*10.6 Vendor Cost E A 
VENDEXISTS 9 Boolean Vendor Exists A 
FACTOR 10 BCD*10.6 Cost Unit Conv. Factor A C 
COSTUNIT 11 String*10 Cost Unit E A  Mask: %-10w
QTYMINORD 12 BCD*10.4 Order Minimum (SIA) E A 
PREFERRED 30 Boolean Preferred Vendor (SIA) E A  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).