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