Element | Description | Default | Type | Mandatory |
---|---|---|---|---|
vendornumber | Primary key of the vendor entity is the vendor number | TEXT(32) | Yes | |
name | Name of the vendor. The name of the business or full name of a person | TEXT(64) | Yes | |
created | Date of the creation | DATETIME | ||
ended | Closing date of this vendor | DATETIME | ||
salutation | Use this field for salutation information such as Dear Sir or Madam or Sir/Madam | TEXYT(32) | ||
firstname | Contact’s first name | TEXYT(32) | ||
lastname | Contact’s first name | TEXT(32) | ||
address1 | First address line | TEXT(32) | ||
address2 | Second address line | TEXT(32) | ||
zipcode | Zip code with free ten character format | TEXT(10) | ||
city | TEXT(32) | |||
state | TEXT(32) | |||
country | Free format | TEXT(32) | ||
terms | Default payment terms in days | INTEGER | ||
phone | TEXT(20) | |||
fax | TEXT(20) | |||
mobile | TEXT(20) | |||
TEXT | ||||
cc | TEXT | |||
bcc | TEXT | |||
notes | Internal notes | TEXT | ||
taxnumber | TEXT(32) | |||
arap_accno | Default accounts payable account number | 2000 | TEXT(32) | |
payment_accno | Default payment account number | 1020 | TEXT(32) | |
bank_name | Data identifying the vendor’s bank connection. Name of the bank. | TEXT(64) | ||
bank_address1 | First address line of vendor’s bank connection | TEXT(32) | ||
bank_address2 | Second address line | TEXT(32) | ||
bank_zipcode | TEXT(10) | |||
bank_city | TEXT(32) | |||
bank_state | TEXT(32) | |||
bank_country | TEXT(32) | |||
bank_iban | TEXT(34) | |||
bank_bic | TEXT(11) |
Examples
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <vendor> <id>10880</id> <vendornumber>L-66</vendornumber> <name>ABC Lieferant</name> <created>2013-01-01T00:00:00+01:00</created> <salutation>Herr</salutation> <firstname>Hans</firstname> <lastname>Muster</lastname> <terms>14</terms> <address1>Seestrasse 63</address1> <address2></address2> <zipcode>8000</zipcode> <city>Zürich</city> <state>Zürich</state> <country>Schweiz</country> <phone>044 000 00 01</phone> <fax></fax> <mobile></mobile> <email>[email protected]</email> <taxnumber></taxnumber> <arap_accno>2000</arap_accno> <payment_accno>1020</payment_accno> <bank_name>CREDIT SUISSE</bank_name> <bank_address1>PARADEPLATZ</bank_address1> <bank_address2></bank_address2> <bank_zipcode>8000</bank_zipcode> <bank_city>ZüRICH</bank_city> <bank_country></bank_country> <bank_iban>CH57 0483 5053 9150 6000 1</bank_iban> <bank_bic>CRESCHZZ81Z</bank_bic> </vendor>
JSON:
{ "id": "10880", "vendornumber": "L-66", "name": "ABC Lieferant", "created": "2013-01-01T00:00:00+01:00", "salutation": "Herr", "firstname": "Hans", "lastname": "Muster", "terms": "14", "address1": "Seestrasse 63", "address2": "", "zipcode": "8000", "city": "Zürich", "state": "Zürich", "country": "Schweiz", "phone": "044 000 00 01", "fax": "", "mobile": "", "email": "[email protected]", "taxnumber": "", "arap_accno": "2000", "payment_accno": "1020", "bank_name": "CREDIT SUISSE", "bank_address1": "PARADEPLATZ", "bank_address2": "", "bank_zipcode": "8000", "bank_city": "ZüRICH", "bank_country": "", "bank_iban": "CH57 0483 5053 9150 6000 1", "bank_bic": "CRESCHZZ81Z" }