Field Listing for Table SUPPLIERMASTER

Field:SUPPLIER Type: VARCHAR Length: 50
Field:SUPPLIERTYPE Type: VARCHAR Length: 20
Field:SUPPLIERSTATUS Type: VARCHAR Length: 20
Field:SUPPLIERPURCHASENAME Type: VARCHAR Length: 150
Field:SUPPLIERADDRESS1 Type: VARCHAR Length: 50
Field:SUPPLIERADDRESS2 Type: VARCHAR Length: 50
Field:SUPPLIERADDRESS3 Type: VARCHAR Length: 50
Field:SUPPLIERPOSTALCODE Type: VARCHAR Length: 20
Field:SUPPLIERSTATE Type: VARCHAR Length: 20
Field:SUPPLIERCITY Type: VARCHAR Length: 30
Field:SUPPLIERCOUNTRY Type: VARCHAR Length: 30
Field:PRIMARYCONTACT Type: VARCHAR Length: 100
Field:SUPPLIERPHONE Type: VARCHAR Length: 20
Field:SUPPLIERFAX Type: VARCHAR Length: 20
Field:SUPPLIEREMAIL Type: VARCHAR Length: 100
Field:SUPPLIERMOBILE Type: VARCHAR Length: 20
Field:SUPPLIERWEB Type: VARCHAR Length: 100
Field:SUPPLIERREGIONCODE Type: VARCHAR Length: 20
Field:SUPPLIERANALYSISCODE Type: VARCHAR Length: 20
Field:SUPPLIERNOTES Type: BLOB
Field:CREDITTERM Type: VARCHAR Length: 20
Field:TAXGROUP Type: VARCHAR Length: 10
Field:DEFAULTCONTRACTCODE Type: VARCHAR Length: 20
Field:BUYER Type: VARCHAR Length: 30
Field:SHIPPINGMETHOD Type: VARCHAR Length: 20
Field:USEBILLSUPPLIER Type: BOOLEAN
Field:BILLINGSUPPLIER Type: VARCHAR Length: 50
Field:PHYSICALADDRESS1 Type: VARCHAR Length: 50
Field:PHYSICALADDRESS2 Type: VARCHAR Length: 50
Field:PHYSICALADDRESS3 Type: VARCHAR Length: 50
Field:PHYSICALPOSTALCODE Type: VARCHAR Length: 20
Field:PHYSICALSTATE Type: VARCHAR Length: 20
Field:PHYSICALCITY Type: VARCHAR Length: 30
Field:PHYSICALCOUNTRY Type: VARCHAR Length: 30
Field:BANKACCOUNTNAME Type: VARCHAR Length: 20
Field:BANKACCOUNTNUMBER Type: VARCHAR Length: 20
Field:OUTPUTFORPURCHASEORDER Type: VARCHAR Length: 20
Field:ADDITIONALFIELD_1 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_2 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_3 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_4 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_5 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_6 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_7 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_8 Type: VARCHAR Length: 100
Field:ADDITIONALDATEFIELD_1 Type: DATE
Field:ADDITIONALDATEFIELD_2 Type: DATE
Field:ADDITIONALDATEFIELD_3 Type: DATE
Field:ADDITIONALDATEFIELD_4 Type: DATE
Field:ADDITIONALDATEFIELD_5 Type: DATE
Field:ADDITIONALDATEFIELD_6 Type: DATE
Field:ADDITIONALDATEFIELD_7 Type: DATE
Field:ADDITIONALDATEFIELD_8 Type: DATE
Field:SAMEPOSTALANDPHYSICAL Type: BOOLEAN
Field:COMPANYOFFICIALNUMBER Type: VARCHAR Length: 30
Field:FOREIGNCURRENCY Type: BOOLEAN
Field:CURRENCYCODE Type: VARCHAR Length: 3
Field:SUPPLIERMESSAGE Type: VARCHAR Length: 200
Field:ORDERMESSAGE Type: VARCHAR Length: 200
Field:INVOICEMESSAGE Type: VARCHAR Length: 200
Field:EXTERNALCODE Type: VARCHAR Length: 50
Field:PURCHASEEMAIL Type: VARCHAR Length: 100
Field:BUSINESSCATEGORY Type: VARCHAR Length: 100
Field:PRODUCTSANDSERVICES Type: BLOB
Field:MOBILITYNOTES Type: BLOB
Field:SUBCONTRACTOR Type: BOOLEAN
Field:SUPPLIERCATEGORY Type: VARCHAR Length: 20
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30