Share via

Vendor Table

  • Article

Specifies all information about your vendors.

A company's vendors can be roughly divided into 2 main groups:

  • Vendors who sell you items and raw materials

  • Other vendors and creditors

You can use the Vendor table to manage both groups. The Vendor table contains a card for each vendor, on which you enter basic information such as name, address and the kinds of discounts that are available. Each vendor must also have a number for identification purposes. When you enter the number in vendor number fields elsewhere in the program (on purchase quotes, for example), the program will automatically use the information associated with the number.

Before you can post to a vendor, you must set up a connection from the relevant vendor card to a balance sheet account in the chart of accounts. You must set up a connection to an income statement account. You do this with posting groups, which you must enter in the Gen. Bus. Posting Group and Vendor Posting Group fields. The posting groups are set up in the Gen. Business Posting Group and Vendor Posting Group tables.

After you set up the posting groups, you can enter them in the Posting Group field on vendor cards. Then when you post to a vendor account, corresponding entries will automatically be created in the associated G/L accounts. The general ledger will therefore always agree with the vendor's balance.

You can post to a vendor in an unlimited number of currencies. The resulting vendor ledger entries will show the currency of each entry.

The program can display the vendors in 2 different windows:

  • The Vendor Card window has a card for each vendor, which contains all the fields that have been selected. You can therefore see many fields for each vendor.

  • The Vendor List window displays all the vendors, with a line for each. Therefore, fewer fields are displayed for each vendor.

List of Fields in the Table

To see the list of fields in this table, change to the Classic view. Choose the Choose View button in the upper-right corner, and then choose Classic.

Field Location
L.S.T. No. Field, Vendor Table Sales Tax
Soc. Sec. Company Base Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
P.A.N. Reference No. Field, Vendor Table Income Tax
C.S.T. No. Field, Vendor Table Sales Tax
P.A.N. Status Field, Vendor Table Income Tax
Tax Representative Type Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Composition Field, Vendor Table Sales Tax
Individual Person Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Service Tax Registration No. Field, Vendor Table Service Tax
Gender Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Contribution Fiscal Code Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
P.A.N. No. Field, Vendor Table Income Tax
Int. on Arrears Code Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
State Code Field, Vendor Table Sales Tax
INAIL 3 Parties Base Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
T.I.N. No. Field, Vendor Table Sales Tax
Tax Representative No. Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Resident County Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Fiscal Code Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Subcontractor Procurement Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Apply Company Payment days Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
GTA Field, Vendor Table Service Tax
Collectorate Field, Vendor Table Excise
Residence County Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Birth County Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Birth Post Code Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Subcontracting Location Code Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Type of Supply Code Field, Vendor Table United Kingdom Local Functionality
First Name Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
SSI Field, Vendor Table Excise
BACS Account No. Field, Vendor Table United Kingdom Local Functionality
Residence Country/Region Code Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Transporter Field, Vendor Table India Local Functionality
Birth City Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
SSI Validity Date Field, Vendor Table Excise
Default Bank Acc. Code Field, Vendor Table Spain Local Functionality
Tax Exempt Amount (LCY) Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Residence Post Code Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Excise Bus. Posting Group Field, Vendor Table Excise
Resident Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Payment in progress (LCY) Field, Vendor Table France Local Functionality
Default Bank Account Code Field, Vendor Table France Local Functionality
Soc. Sec. 3 Parties Base Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Subcontractor Field, Vendor Table India Local Functionality
Non-Paymt. Periods Code Field, Vendor Table Spain Local Functionality
INAIL Code Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Residence City Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Last Name Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Payment Days Code Field, Vendor Table Spain Local Functionality
Linked to Work Center Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Social Security Code Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Country of Fiscal Domicile Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Vendor Type Field, Vendor Table Excise
Date of Birth Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Birth Country/Region Code Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Subcontractor Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Residence Address Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
INAIL Company Base Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Withholding Tax Code Field, Vendor Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Vendor Location Field, Vendor Table India Local Functionality
Range Field, Vendor Table Excise
E.C.C. No. Field, Vendor Table Excise
Structure Field, Vendor Table India Local Functionality
Commissioner's Permission No. Field, Vendor Table India Local Functionality
Enterprise No. Field, Vendor Table Belgium Local Functionality
Default Payment Acc. Code Field, Vendor Table Finland Local Functionality
Business Identity Code Field, Vendor Table Finland Local Functionality
Country/Region Code Field, Vendor Table Finland Local Functionality
Our Account No. Field, Vendor Table Finland Local Functionality
Preferred Bank Account Field, Vendor Table Belgium Local Functionality
Suggest Payments Field, Vendor Table Belgium Local Functionality
Inward Reg. Balance (LCY) Field, Vendor Table Sweden Local Functionality
Transaction Mode Code Field, Vendor Table Netherlands Local Functionality
Priority Field, Vendor Table Purchases and Payables
Invoice Disc. Code Field, Vendor Table Purchases and Payables
Credit Amount Field, Vendor Table Purchases and Payables
No. of Credit Memos Field, Vendor Table Purchases and Payables
Tax Area Code Field, Vendor Table Purchases and Payables
Payments (LCY) Field, Vendor Table Purchases and Payables
Pay-to No. of Pstd. Invoices Field, Vendor Table Purchases and Payables
Application Method Field, Vendor Table Purchases and Payables
Picture Field, Vendor Table Purchases and Payables
Responsibility Center Field, Vendor Table Purchases and Payables
Prices Including VAT Field, Vendor Table Purchases and Payables
Name Field, Vendor Table Purchases and Payables
No. of Return Orders Field, Vendor Table Purchases and Payables
Address Field, Vendor Table Purchases and Payables
Pmt. Disc. Tolerance (LCY) Field, Vendor Table Purchases and Payables
Bank Account Code Field, Vendor Table Netherlands Local Functionality
Outstanding Orders Field, Vendor Table Purchases and Payables
Pay-to No. of Return Orders Field, Vendor Table Purchases and Payables
Contact Field, Vendor Table Purchases and Payables
Language Code Field, Vendor Table Purchases and Payables
Net Change Field, Vendor Table Purchases and Payables
Post Code Field, Vendor Table Purchases and Payables
Other Amounts Field, Vendor Table Purchases and Payables
Location Code Field, Vendor Table Purchases and Payables
Fax No. Field, Vendor Table Purchases and Payables
Home Page Field, Vendor Table Purchases and Payables
Refunds (LCY) Field, Vendor Table Purchases and Payables
Currency Code Field, Vendor Table Purchases and Payables
Purchaser Code Field, Vendor Table Purchases and Payables
No. of Invoices Field, Vendor Table Purchases and Payables
Blocked Field, Vendor Table Purchases and Payables
Global Dimension 2 Code Field, Vendor Table Purchases and Payables
No. of Order Addresses Field, Vendor Table Purchases and Payables
Reminder Amounts (LCY) Field, Vendor Table Purchases and Payables
No. Series Field, Vendor Table Purchases and Payables
Inv. Discounts (LCY) Field, Vendor Table Purchases and Payables
Global Dimension 1 Filter Field, Vendor Table Purchases and Payables
E-Mail Field, Vendor Table Purchases and Payables
Buy-from No. Of Archived Doc. Field, Vendor Table Purchases and Payables
VAT Bus. Posting Group Field, Vendor Table Purchases and Payables
Pay-to Vendor No. Field, Vendor Table Purchases and Payables
Cr. Memo Amounts (LCY) Field, Vendor Table Purchases and Payables
Debit Amount (LCY) Field, Vendor Table Purchases and Payables
Pay-to No. of Pstd. Cr. Memos Field, Vendor Table Purchases and Payables
Invoice Amounts Field, Vendor Table Purchases and Payables
Country/Region Code Field, Vendor Table Purchases and Payables
Tax Liable Field, Vendor Table Purchases and Payables
Territory Code Field, Vendor Table Purchases and Payables
Lead Time Calculation Field, Vendor Table Purchases and Payables
VAT Registration No. Field, Vendor Table Purchases and Payables
Outstanding Invoices (LCY) Field, Vendor Table Purchases and Payables
Telex Answer Back Field, Vendor Table Purchases and Payables
Purchases (LCY) Field, Vendor Table Purchases and Payables
Global Dimension 2 Filter Field, Vendor Table Purchases and Payables
Balance Due (LCY) Field, Vendor Table Purchases and Payables
Comment Field, Vendor Table Purchases and Payables
No. of Pstd. Credit Memos Field, Vendor Table Purchases and Payables
Payment Terms Code Field, Vendor Table Purchases and Payables
Pay-to No. of Invoices Field, Vendor Table Purchases and Payables
Fin. Charge Terms Code Field, Vendor Table Purchases and Payables
Pmt. Discounts (LCY) Field, Vendor Table Purchases and Payables
Date Filter Field, Vendor Table Purchases and Payables
Base Calendar Code Field, Vendor Table Purchases and Payables
Refunds Field, Vendor Table Purchases and Payables
No. of Pstd. Invoices Field, Vendor Table Purchases and Payables
Amt. Rcd. Not Invoiced Field, Vendor Table Purchases and Payables
Debit Amount Field, Vendor Table Purchases and Payables
Pay-to No. of Blanket Orders Field, Vendor Table Purchases and Payables
No. of Blanket Orders Field, Vendor Table Purchases and Payables
Outstanding Orders (LCY) Field, Vendor Table Purchases and Payables
Shipment Method Code Field, Vendor Table Purchases and Payables
IC Partner Code Field, Vendor Table Purchases and Payables
Primary Contact No. Field, Vendor Table Purchases and Payables
Amt. Rcd. Not Invoiced (LCY) Field, Vendor Table Purchases and Payables
Net Change (LCY) Field, Vendor Table Purchases and Payables
Pmt. Tolerance (LCY) Field, Vendor Table Purchases and Payables
Pay-to No. of Orders Field, Vendor Table Purchases and Payables
No. of Pstd. Return Shipments Field, Vendor Table Purchases and Payables
Address 2 Field, Vendor Table Purchases and Payables
Phone No. Field, Vendor Table Purchases and Payables
No. of Quotes Field, Vendor Table Purchases and Payables
Payments Field, Vendor Table Purchases and Payables
Credit Amount (LCY) Field, Vendor Table Purchases and Payables
City Field, Vendor Table Purchases and Payables
No. Field, Vendor Table Purchases and Payables
Pay-to No. of Quotes Field, Vendor Table Purchases and Payables
Currency Filter Field, Vendor Table Purchases and Payables
Cr. Memo Amounts Field, Vendor Table Purchases and Payables
Other Amounts (LCY) Field, Vendor Table Purchases and Payables
Pay-to No. Of Archived Doc. Field, Vendor Table Purchases and Payables
Block Payment Tolerance Field, Vendor Table Purchases and Payables
Pay-to No. of Pstd. Receipts Field, Vendor Table Purchases and Payables
Vendor Posting Group Field, Vendor Table Purchases and Payables
Pay-to No. of Credit Memos Field, Vendor Table Purchases and Payables
Shipping Agent Code Field, Vendor Table Purchases and Payables
No. of Orders Field, Vendor Table Purchases and Payables
Balance (LCY) Field, Vendor Table Purchases and Payables
Prepayment % Field, Vendor Table Purchases and Payables
Finance Charge Memo Amounts Field, Vendor Table Purchases and Payables
Name 2 Field, Vendor Table Purchases and Payables
Budgeted Amount Field, Vendor Table Purchases and Payables
Search Name Field, Vendor Table Purchases and Payables
Payment Method Code Field, Vendor Table Purchases and Payables
Inv. Amounts (LCY) Field, Vendor Table Purchases and Payables
Global Dimension 1 Code Field, Vendor Table Purchases and Payables
Our Account No. Field, Vendor Table Purchases and Payables
Outstanding Invoices Field, Vendor Table Purchases and Payables
Balance Field, Vendor Table Purchases and Payables
Last Date Modified Field, Vendor Table Purchases and Payables
Telex No. Field, Vendor Table Purchases and Payables
Statistics Group Field, Vendor Table Purchases and Payables
Reminder Amounts Field, Vendor Table Purchases and Payables
Fin. Charge Memo Amounts (LCY) Field, Vendor Table Purchases and Payables
Balance Due Field, Vendor Table Purchases and Payables
Pay-to No. of Pstd. Return S. Field, Vendor Table Purchases and Payables
No. of Pstd. Receipts Field, Vendor Table Purchases and Payables
County Field, Vendor Table Purchases and Payables
L.S.T. No. Field, Vendor Table India Sales Tax
P.A.N. Reference No. Field, Vendor Table India Income Tax
C.S.T. No. Field, Vendor Table India Sales Tax
P.A.N. Status Field, Vendor Table India Income Tax
Composition Field, Vendor Table India Sales Tax
Service Tax Registration No. Field, Vendor Table India Service Tax
P.A.N. No. Field, Vendor Table India Income Tax
State Code Field, Vendor Table India Sales Tax
Int. on Arrears Code Field, Vendor Table Italy Local Functionality
T.I.N. No. Field, Vendor Table India Sales Tax
Fiscal Code Field, Vendor Table Italy Local Functionality
Collectorate Field, Vendor Table India Excise
SSI Field, Vendor Table India Excise
SSI Validity Date Field, Vendor Table India Excise
Excise Bus. Posting Group Field, Vendor Table India Excise
Payment in progress (LCY) Field, Vendor Table France Local Functionality
Subcontractor Field, Vendor Table India Local Functionality
Transaction Mode Code Field, Vendor Table Netherlands Local Functionality
Vendor Type Field, Vendor Table India Excise
Range Field, Vendor Table India Excise
E.C.C. No. Field, Vendor Table India Excise
Vendor Location Field, Vendor Table India Local Functionality
Structure Field, Vendor Table India Local Functionality
Cash Flow Payment Terms Code Field, Vendor Table General Ledger
Commissioner's Permission No. Field, Vendor Table India Local Functionality
Gen. Bus. Posting Group Field, Vendor Table Purchases and Payables
ABN Field, Vendor Table New Zealand Local Functionality
Foreign Vend Field, Vendor Table New Zealand Local Functionality
WHT Registration ID Field, Vendor Table New Zealand Local Functionality
CURP No. Field, Vendor Table United States Local Functionality
RFC No. Field, Vendor Table United States Local Functionality
Post Dated Checks (LCY) Field, Vendor Table New Zealand Local Functionality
Tax Identification Type Field, Vendor Table United States Local Functionality
UPS Zone Field, Vendor Table United States Local Functionality
Tax Area Code Field, Vendor Table United States Local Functionality
State Inscription Field, Vendor Table United States Local Functionality
WHT Payable Amount (LCY) Field, Vendor Table New Zealand Local Functionality
Check Date Separator Field, Vendor Table United States Local Functionality
Tax Liable Field, Vendor Table United States Local Functionality
Check Date Format Field, Vendor Table United States Local Functionality
Balance on Date (LCY) Field, Vendor Table United States Local Functionality
Federal ID No. Field, Vendor Table United States Local Functionality
Balance on Date Field, Vendor Table United States Local Functionality
IRS 1099 Code Field, Vendor Table United States Local Functionality
Bank Communication Field, Vendor Table United States Local Functionality
Registered Field, Vendor Table New Zealand Local Functionality
EFT Payment Field, Vendor Table New Zealand Local Functionality
ID No. Field, Vendor Table New Zealand Local Functionality
IRD No. Field, Vendor Table New Zealand Local Functionality
EFT Bank Account No. Field, Vendor Table New Zealand Local Functionality
WHT Business Posting Group Field, Vendor Table New Zealand Local Functionality
ABN Division Part No. Field, Vendor Table New Zealand Local Functionality
Cash Flow Payment Terms Code Field, Vendor Table General Ledger
Remittance Field, Vendor Table Norway Local Functionality
Delivery Reminder Terms Field, Vendor Table Switzerland Local Functionality
Recipient ref. 2 - inv. Field, Vendor Table Norway Local Functionality
SWIFT Field, Vendor Table Norway Local Functionality
Payment Type Code Domestic Field, Vendor Table Norway Local Functionality
Standard Bank Field, Vendor Table Switzerland Local Functionality
Own Vendor Recipient Ref. Field, Vendor Table Norway Local Functionality
Warning Text Field, Vendor Table Norway Local Functionality
SWIFT Remb. Bank Field, Vendor Table Norway Local Functionality
Bank Address 2 Field, Vendor Table Norway Local Functionality
Telex/Fax No. Field, Vendor Table Norway Local Functionality
BOLS Text Code Field, Vendor Table Norway Local Functionality
Recipient ref. 3 - cred. Field, Vendor Table Norway Local Functionality
Specification (Norges Bank) Field, Vendor Table Norway Local Functionality
Recipient Bank Account No. Field, Vendor Table Norway Local Functionality
Remittance Account Code Field, Vendor Table Norway Local Functionality
Recipient ref. 3 - inv. Field, Vendor Table Norway Local Functionality
Bank Address 1 Field, Vendor Table Norway Local Functionality
Registration No. Field, Vendor Table Switzerland Local Functionality
Rcpt. Bank Country/Region Code Field, Vendor Table Norway Local Functionality
Bank Name Field, Vendor Table Norway Local Functionality
Charges Abroad Field, Vendor Table Norway Local Functionality
Bank Address 3 Field, Vendor Table Norway Local Functionality
To Own Account Field, Vendor Table Norway Local Functionality
Recipient ref. 2 - cred. Field, Vendor Table Norway Local Functionality
Recipient Ref. Abroad Field, Vendor Table Norway Local Functionality
Telex Country/Region Code Field, Vendor Table Norway Local Functionality
Recipient ref. 1 - inv. Field, Vendor Table Norway Local Functionality
Recipient Contact Field, Vendor Table Norway Local Functionality
Recipient Confirmation Field, Vendor Table Norway Local Functionality
Remittance Agreement Code Field, Vendor Table Norway Local Functionality
Recipient ref. 1 - cred. Field, Vendor Table Norway Local Functionality
Charges Domestic Field, Vendor Table Norway Local Functionality
Warning Notice Field, Vendor Table Norway Local Functionality
Payment Type Code Abroad Field, Vendor Table Norway Local Functionality
L.S.T. No. Field, Vendor Table Sales Tax
P.A.N. Reference No. Field, Vendor Table Income Tax
C.S.T. No. Field, Vendor Table Sales Tax
P.A.N. Status Field, Vendor Table Income Tax
Composition Field, Vendor Table Sales Tax
P.A.N. No. Field, Vendor Table Income Tax
Service Tax Registration No. Field, Vendor Table Service Tax
State Field, Vendor Table Sales Tax
T.I.N. No. Field, Vendor Table Sales Tax
Collectorate Field, Vendor Table Excise
SSI Field, Vendor Table Excise
SSI Validity Date Field, Vendor Table Excise
Excise Bus. Posting Group Field, Vendor Table Excise
Vendor Type Field, Vendor Table Excise
Range Field, Vendor Table Excise
E.C.C. No. Field, Vendor Table Excise
Subcontractor Field, Vendor Table India Local Functionality
Vendor Location Field, Vendor Table India Local Functionality
Structure Field, Vendor Table India Local Functionality
Commissioner's Permission No. Field, Vendor Table India Local Functionality
Cash Flow Payment Terms Code Field, Vendor Table General Ledger
Int. on Arrears Code Field, Vendor Table Italy Local Functionality
Payment in progress (LCY) Field, Vendor Table France Local Functionality
Transaction Mode Code Field, Vendor Table Netherlands Local Functionality
Fiscal Code Field, Vendor Table Italy Local Functionality
Bank Account Field Field, Vendor Table Deleted Topics
Bank Account Field Field, Vendor Table Deleted Topics
Cash Flow Payment Terms Code Field, Vendor Table Purchases and Payables
Payment in progress (LCY) Field, Vendor Table France Local Functionality
Int. on Arrears Code Field, Vendor Table Italy Local Functionality
Transaction Mode Code Field, Vendor Table Netherlands Local Functionality
Fiscal Code Field, Vendor Table Italy Local Functionality
Bank Account Field Field, Vendor Table Deleted Topics

See Also

Reference

Vendor Card