|
|
  
|
|
|
|
Fields marked * may NOT be left blank. All other fields may be left blank.
Fields marked (d) that are left blank will use the default values in the Supplier Default table. Note that some default values in Supplier Default such as City may also be blank.
SupplierID*
Identifies the Supplier.
Name*
Address1
Address2
City(d)
State(d)
State or Province code.
Zip
Postal mail code.
CountryID(d)
Phone
Fax
E-mail address.
Website
URL for their website.
SupplierGroupID(d)
ApSubledgerAccountID(d)
Accounts Payable Subledger Control Account.
BankAccountID(d)
Specifies the default Bank from which Checks will be issued to this Supplier.
IsPaymentHold(d)
Specifies initial default used when entering Purchase Invoices for this Supplier.
1 means initial default is Payment Hold . 0 means it isn’t.
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.
CreditLimit(d)
This field specifies the amount of Credit we have arranged.
ShipVia(d)
Purchasing module. This specifies the standard Ship Via instructions.
FederalTaxID
U.S.A. Specifies the Taxpayer Identification Number (TIN) for 1099 reporting.
Gst/Vat tax countries. Unused.
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.
IsPrint1099(d)
This field is applicable to the U.S.A. only.
1 means this Supplier is selected for 1099 reporting.
0 means this Supplier is not selected for 1099 reporting.
TheirCustomerID
This field is available to specify the CustomerID used by our Supplier in referring to our account with them.
Notes
This Memo field is used for any supplementary information about this Supplier.
OriginUserID
This field may be any UserID. When specified the OriginUserID of the imported Supplier will be the specified value. When blank the OriginUserID of the imported Supplier will be the UserID of the User running the Import task.
OriginTaskID
This field may be any TaskID value. When specified the OriginTaskID of the imported Supplier will be the specified value. When blank the OriginTaskID of the imported Supplier will be the TaskID of the Import task.
ErrorID
This field is reserved for the Import task. Do not insert any value into this field. Any value in this field will be ignored and written over.