|
Column Name
|
Data Type
|
|
SUPPLIER*
|
STRING(10)
|
|
ALTERNATIVEPAYEEACCOUNTNUMBER
|
STRING(10)
|
|
AUTHORIZATIONGROUP
|
STRING(4)
|
|
BIRTHDATE
|
DATETIME(0)
|
|
CONCATENATEDINTERNATIONALLOCNO
|
STRING(20)
|
|
CREATEDBYUSER
|
STRING(12)
|
|
CREATIONDATE
|
DATETIME(0)
|
|
CUSTOMER
|
STRING(10)
|
|
DELETIONINDICATOR
|
BOOLEAN
|
|
FISCALADDRESS
|
STRING(10)
|
|
INDUSTRY
|
STRING(4)
|
|
INTERNATIONALLOCATIONNUMBER1
|
STRING(7)
|
|
INTERNATIONALLOCATIONNUMBER2
|
STRING(5)
|
|
INTERNATIONALLOCATIONNUMBER3
|
STRING(1)
|
|
ISNATURALPERSON
|
STRING(1)
|
|
PAYMENTISBLOCKEDFORSUPPLIER
|
BOOLEAN
|
|
POSTINGISBLOCKED
|
BOOLEAN
|
|
PURCHASINGISBLOCKED
|
BOOLEAN
|
|
RESPONSIBLETYPE
|
STRING(2)
|
|
SUPLRPROOFOFDELIVRLVTCODE
|
STRING(1)
|
|
SUPLRQLTYINPROCMTCERTFNVALIDTO
|
DATETIME(0)
|
|
SUPLRQUALITYMANAGEMENTSYSTEM
|
STRING(4)
|
|
SUPPLIERACCOUNTGROUP
|
STRING(4)
|
|
SUPPLIERCORPORATEGROUP
|
STRING(10)
|
|
SUPPLIERFULLNAME
|
STRING(220)
|
|
SUPPLIERNAME
|
STRING(80)
|
|
SUPPLIERPROCUREMENTBLOCK
|
STRING(2)
|
|
TAXNUMBER1
|
STRING(16)
|
|
TAXNUMBER2
|
STRING(11)
|
|
TAXNUMBER3
|
STRING(18)
|
|
TAXNUMBER4
|
STRING(18)
|
|
TAXNUMBER5
|
STRING(60)
|
|
TAXNUMBERRESPONSIBLE
|
STRING(18)
|
|
TAXNUMBERTYPE
|
STRING(2)
|
|
VATREGISTRATION
|
STRING(20)
|