Suppliers - codbex/codbex-olympus GitHub Wiki

Supplier is a person/company who sells goods or a service

Supplier

Entity Definition

Field Type Length Null? Calc? Ref? Description
Id INTEGER no - -
Name VARCHAR 200 no - - Name of the company or the individual
Contact VARCHAR 200 - - - Name of the contact person
Email VARCHAR 100 - - -
Phone VARCHAR 20 - - -
Address VARCHAR 200 - - -
PostCode VARCHAR 20 - - -
City INTEGER - - yes Reference to Cities
Country INTEGER - - yes Reference to Countries
TIN VARCHAR 20 - - - Tax identification number
IBAN VARCHAR 34 - - - Bank account number

SupplierNote

Entity Definition

Field Type Length Null? Calc? Ref? Description
Id INTEGER no - -
Supplier INTEGER no - yes Reference to Supplier
Note VARCHAR 5000 no - - Free text