Navigation:  Accounts Payable > Technical References >   Supplier table

Field names below are the typical field names shown on forms.

 
Some of these are slightly different than the actual field names in the underlying table. In particular, actual field names do not have embedded spaces and field names of logical fields such as IsActive are prefixed by ‘Is’.

 

Fields marked (d) will initially be set to the default values in the Supplier Default table when a new Supplier is inserted. Note that some default values in Supplier Default such as City may also be blank.

 

SupplierID

Identifies the Supplier.

 

SupplierSID

The surrogate key assigned by the system for this Supplier. Usually not shown on forms.

 

Name

 

Address1

 

Address2

 

City(d)

 

State(d)

State or Province code. You can select it from the drop-down list of States/Provinces for this Country.

 

Zip/Postal

Postal mail code.

 

CountryID(d)

Specifies the Country. You can select it from the drop-down list of active Countries.

 

Country

This shows the Country name.

 

Phone

 

Fax

 

Email

E-mail address.

 

Website

URL for their website.

 

Terms(d)

Specifies the standard Terms for this Supplier’s transactions. A Terms entry here refers to the Terms table which specifies the standard NetDays, CashDiscountDays and CashDiscountPercent for each Terms entry.

 

Credit Limit(d)

This field specifies the amount of Credit we have arranged.

 

Bank AccountID(d)

Specifies the default Bank from which Checks will be issued to this Supplier.

 

FederalTaxID

U.S.A. Specifies the Taxpayer Identification Number (TIN) for 1099 reporting.

Gst/Vat tax countries. Unused.

 

Print1099(d)

This field is applicable to the U.S.A. only.

When checked this Supplier is selected for 1099 reporting.
When unchecked this Supplier is not selected for 1099 reporting.

 

Supplier GroupID(d)

 

Their CustomerID

This field is available to specify the CustomerID used by our Supplier in referring to our account with them.

 

Ship Via(d)

Purchasing module. This specifies the standard Ship Via instructions.

 

VatCode(d)

U.S.A. Unused.
Gst/Vat countries. The applicable Vat/Gst code for the Supplier.

 

VatLicense

U.S.A. Unused.
Gst/Vat countries. The Vat/Gst License for the Supplier.

 

ApSubledger AccountID(d)

Accounts Payable Subledger Control Account.

 

Currency

Determined by the CurrencyID of the Accounts Payable Subledger Control Account. Visible when Currency Manager is installed.

 

ApBalance

Shows the Accounts Payable balance for this Supplier.

 

Payment Hold(d)

Specifies default used when entering Purchase Invoices for this Supplier.

 

Active

Checked means this Supplier is Active.
Unchecked means this Supplier is not Active.
Only Active Suppliers are presented in data entry lookup lists or available for Supplier List maintenance.

 

Notes

This Memo field is used for any supplementary information about this Supplier.

 

OriginDate

The date when this Supplier record was created.

 

OriginUserID

The UserID of the user who created this Supplier record.

 

OriginTaskID

The TaskID of the task that created this Supplier record.

 

OriginSupplierID

The SupplierID when this Supplier record was created.

 

OriginSupplierSID

The SupplierSID assigned when this Supplier record was created.