Table: Subcontractors

Table: PMSUBCN
View: PM0026
Record Length: 816

Flags: A R 

Keys: 1

Title Flags Fields

Subcontractor SUBCONT

Fields: 30

Field Type Title Presentation

SUBCONT String*16 Subcontractor Code Mask: %-16N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
NAME String*60 Subcontractor Name
DESC String*60 Description
VENDORID String*12 Vendor Number Mask: %-12C
INACTIVE Integer Status List:2 entries
0 = Active
1 = Inactive
DATELASTMN Date Last Maintained
DATEINACTV Date Date Inactive
ADDR1 String*60 Address
ADDR2 String*60 Address 2
ADDR3 String*60 Address 3
ADDR4 String*60 Address 4
CITY String*30 City
STATE String*30 State/Prov.
ZIP String*20 Zip/Postal Code
COUNTRY String*30 Country
CONTACT String*60 Contact
PHONE String*30 Telephone Mask: (%-3C) %-3C-%-24C
FAX String*30 Fax Mask: (%-3C) %-3C-%-24C
EMAIL1 String*50 Contact's E-mail
EMAIL2 String*50 Vendor's E-mail
ARITEM String*16 A/R Item No. Mask: %-16C
UOM String*10 Unit of Measure Mask: %-10C
UNITCOST BCD*10.6 Unit Cost
BILLRATE BCD*10.6 Billing Rate
SCHCODE String*12 Schedule Code Mask: %-12N
VALUES Long Optional Fields