View: Subcontractors

RotoID: PM0026
Table: PMSUBCN
Protocol: Header
DLL:PMSUBCN

Compositions: 2

RotoID Tables Title DLL
PM0477 PMSUBCND Subcontractors Detail View PMSUBCND
PM0515 PMSUBCNO Subcontractor Optional Fields PMSUBCNO

Keys: 1

Title Fields
Subcontractor SUBCONT

Fields: 26

Field Index Type Title Attributes Presentation
SUBCONT 1 String*16 Subcontractor Code E A K R  Mask: %-16N
NAME 2 String*60 Subcontractor Name E A 
DESC 3 String*60 Description E A 
VENDORID 4 String*12 Vendor Number E A  Mask: %-12C
INACTIVE 5 Integer Status E A  List:2 entries
0 = Active
1 = Inactive
DATELASTMN 6 Date Last Maintained A C 
DATEINACTV 7 Date Date Inactive A C 
ADDR1 8 String*60 Address E A 
ADDR2 9 String*60 Address 2 E A 
ADDR3 10 String*60 Address 3 E A 
ADDR4 11 String*60 Address 4 E A 
CITY 12 String*30 City E A 
STATE 13 String*30 State/Prov. E A 
ZIP 14 String*20 Zip/Postal Code E A 
COUNTRY 15 String*30 Country E A 
CONTACT 16 String*60 Contact E A 
PHONE 17 String*30 Telephone E A P  Mask: (%-3C) %-3C-%-24C
FAX 18 String*30 Fax E A P  Mask: (%-3C) %-3C-%-24C
EMAIL1 19 String*50 Contact's E-mail E A 
EMAIL2 20 String*50 Vendor's E-mail E A 
ARITEM 21 String*16 A/R Item No. E A  Mask: %-16C
UOM 22 String*10 Unit of Measure E A  Mask: %-10C
UNITCOST 23 BCD*10.6 Unit Cost E A 
BILLRATE 24 BCD*10.6 Billing Rate E A 
SCHCODE 25 String*12 Schedule Code E A  Mask: %-12N
VALUES 26 Long Optional Fields E A C 

This page was generated on 2021-Nov-24

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