File
Contents: Contains information on each supplier setup in the
system.
The column
headings in the table include the following.
Text- a field with a large character limit.
Bit- a logical
field. 0=False, 1=True
|
POSITION
|
FIELD NAME
|
TYPE
|
WIDTH
|
DEC
|
POINTER
|
DESCRIPTION
|
|
1
|
CODE
|
Char
|
6
|
N/A
|
I
|
Supplier code.
|
|
2
|
NAME
|
Char
|
30
|
N/A
|
I
|
Supplier Name.
|
|
3
|
L1
|
Char
|
30
|
N/A
|
N/A
|
First address line.
|
|
4
|
L2
|
Char
|
30
|
N/A
|
N/A
|
Second address line.
|
|
5
|
L3
|
Char
|
30
|
N/A
|
N/A
|
Third address line.
|
|
6
|
PHONE
|
Char
|
16
|
N/A
|
I
|
Contact phone number.
|
|
7
|
FAX
|
Char
|
16
|
N/A
|
N/A
|
Contact fax number.
|
|
8
|
ACCOUNT
|
Char
|
20
|
N/A
|
N/A
|
Account number.
|
|
9
|
SU_DROP
|
Bit
|
N/A
|
1
|
0
|
Identifies if this supplier can do drop
|
|
10
|
CONTACT
|
Char
|
20
|
N/A
|
N/A
|
Contact name.
|
|
11
|
TERMS
|
Char
|
20
|
N/A
|
N/A
|
Terms.
|
|
12
|
INSTRUCT1
|
Char
|
40
|
N/A
|
N/A
|
Instructions on purchase order 1.
|
|
13
|
INSTRUCT2
|
Char
|
40
|
N/A
|
N/A
|
Instructions on purchase order 2.
|
|
14
|
INSTRUCT3
|
Char
|
40
|
N/A
|
N/A
|
Instructions on purchase order 3.
|
|
15
|
NOTE1
|
Char
|
60
|
N/A
|
N/A
|
Notes about the supplier 1.
|
|
16
|
NOTE2
|
Char
|
60
|
N/A
|
N/A
|
Notes about the supplier 2.
|
|
17
|
NOTE3
|
Char
|
60
|
N/A
|
N/A
|
Notes about the supplier 3.
|
|
18
|
DISCT_PCT
|
Numeric
|
N/A
|
4
|
1
|
Discount allowed by supplier.
|
|
19
|
DISCT_DAYS
|
Numeric
|
N/A
|
3
|
0
|
#
of days for discount.
|
|
20
|
DUE_DAYS
|
Numeric
|
N/A
|
3
|
0
|
#
of days invoice is due.
|
|
21
|
TERM_ALLOW
|
Bit
|
N/A
|
1
|
0
|
Supplier allows term indicator.
|
|
22
|
EMAIL
|
Char
|
50
|
N/A
|
N/A
|
Supplier e-mail address.
|
|
23
|
PRINTPO
|
Bit
|
N/A
|
1
|
0
|
Print purchase orders.
|
|
24
|
EMAILPO
|
Bit
|
N/A
|
1
|
0
|
E-mail POs to supplier.
|
|
25
|
FAXPO
|
Bit
|
N/A
|
1
|
0
|
Fax POs to supplier.
|
|
26
|
COUNTRY
|
Char
|
3
|
N/A
|
N/A
|
Country code.
|
|
27
|
PTERMS
|
Char
|
1
|
N/A
|
N/A
|
Terms
|
|
28
|
CARDTYPE
|
Char
|
2
|
N/A
|
N/A
|
Credit card payment type.
|
|
29
|
LOADZONES
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
30
|
ZIPCODE
|
Char
|
5
|
N/A
|
N/A
|
Zip code of supplier.
|
|
31
|
LEAD_AVG
|
Numeric
|
N/A
|
7
|
2
|
RESERVED.
|
|
32
|
MIN_UNITS
|
Numeric
|
N/A
|
11
|
2
|
Minimum units required for supplier.
|
|
33
|
MIN_AMT
|
Numeric
|
N/A
|
12
|
2
|
Minimum amount required for supplier.
|
|
34
|
MIN_REQ
|
Bit
|
N/A
|
1
|
0
|
Indicates minimum required by supplier.
|
|
35
|
SUPPLIER_ID
|
Numeric
|
N/A
|
18
|
0
|
RESERVED.
|
|
36
|
SHIPVIA
|
Char
|
3
|
N/A
|
N/A
|
Preferred Supplier Shipping Method
|
|
37
|
INACTIVE
|
Bit
|
N/A
|
1
|
0
|
Indicates if the supplier code and associated purchasing levels
will display during purchasing.
|
|
38
|
PHONEEXT
|
Char
|
8
|
N/A
|
N/A
|
Supplier contact phone extension number.
|
|
39
|
MINVOL
|
Numeric
|
N/A
|
10
|
3
|
Minimum volume per shipment.
|
|
40
|
MAXVOL
|
Numeric
|
N/A
|
10
|
3
|
Maximum volume per shipment.
|
|
41
|
MINWEIGHT
|
Numeric
|
N/A
|
10
|
3
|
Minimum weight per shipment.
|
|
42
|
MAXWEIGHT
|
Numeric
|
N/A
|
10
|
3
|
Maximum weight per shipment.
|
|
43
|
LSHPVOL
|
Bit
|
N/A
|
1
|
0
|
Indicates if Shipping Landed Cost
will
be determined by the product's volume.
|
|
44
|
LSHPWEIGHT
|
Bit
|
N/A
|
1
|
0
|
Indicates if Shipping Landed Cost
will
be determined by the product's weight.
|
|
45
|
LSHPVAL
|
Bit
|
N/A
|
1
|
0
|
Indicates if Shipping Landed Cost will be determined by the
product's value.
|
|
46
|
LTAXVOL
|
Bit
|
N/A
|
1
|
0
|
Indicates if Landed Cost Tax will be determined by the product's
volume.
|
|
47
|
LTAXWEIGHT
|
Bit
|
N/A
|
1
|
0
|
Indicates if the Landed Cost Tax will be determined by the
product's weight.
|
|
48
|
LTAXVAL
|
Bit
|
N/A
|
1
|
0
|
Indicates if the Landed Cost Tax will be determined by the
product's weight.
|
|
49
|
LADJVOL
|
Bit
|
N/A
|
1
|
0
|
Indicates if Landed Cost Adjustment will be determined by the
product's volume.
|
|
50
|
LADJWEIGHT
|
Bit
|
N/A
|
1
|
0
|
Indicates if Landed Cost Adjustment will be determined by the
product's weight.
|
|
51
|
LADJVAL
|
Bit
|
N/A
|
1
|
0
|
Indicates if Landed Cost Adjustment
will
be determined by the product's value.
|
|
52
|
EMAILDEF
|
Char
|
8
|
N/A
|
N/A
|
Preferred Email Format.
|
