Field Listing for Table FINANCIALSUPPLIERS

Field:SUPPLIER Type: VARCHAR Length: 50
Field:SUPPLIERTYPE Type: VARCHAR Length: 20
Field:SUPPLIERSTATUS Type: VARCHAR Length: 20
Field:SUPPLIERPURCHASENAME Type: VARCHAR Length: 50
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: 30
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:CREDITTERM Type: VARCHAR Length: 20
Field:TAXGROUP Type: VARCHAR Length: 10
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:CURRENCYCODE Type: VARCHAR Length: 3
Field:INSERTEDORUPDATED Type: VARCHAR Length: 10
Field:BATCHFILENO Type: DOUBLE
Field:TRANSACTIONSTATUS Type: VARCHAR Length: 20
Field:TRANSACTIONMESSAGE Type: VARCHAR Length: 300
Field:SOURCESYSUNIQUEID Type: DOUBLE
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE