VQ350101 - Q35 F0101 F0111 All Columns
Cantara Business View Object
Fields
| Name | Alias | Type | Table |
|---|---|---|---|
| AddressNumber | AN8 | ADDRESSNUMBER | F0101 |
| AlternateAddressKey | ALKY | STRING | F0101 |
| TaxId | TAX | STRING | F0101 |
| NameAlpha | ALPH | STRING | F0101 |
| DescripCompressed | DC | STRING | F0101 |
| CostCenter | MCU | BUSINESSUNIT | F0101 |
| StandardIndustryCode | SIC | UDC | F0101 |
| LanguagePreference | LNGP | UDC | F0101 |
| AddressType1 | AT1 | UDC | F0101 |
| CreditMessage | CM | UDC | F0101 |
| PersonCorporationCode | TAXC | UDC | F0101 |
| AddressType2 | AT2 | UDC | F0101 |
| AddressType3 | AT3 | UDC | F0101 |
| AddressType4 | AT4 | UDC | F0101 |
| AddressType5 | AT5 | UDC | F0101 |
| AddressTypePayables | ATP | UDC | F0101 |
| AddressTypeReceivables | ATR | UDC | F0101 |
| AddTypeCode4Purch | ATPR | CHARACTER | F0101 |
| MiscCode3 | AB3 | UDC | F0101 |
| AddressTypeEmployee | ATE | UDC | F0101 |
| SubledgerInactiveCode | SBLI | UDC | F0101 |
| DateBeginningEffective | EFTB | DATE | F0101 |
| AddressNumber1st | AN81 | ADDRESSNUMBER | F0101 |
| AddressNumber2nd | AN82 | ADDRESSNUMBER | F0101 |
| AddressNumber3rd | AN83 | ADDRESSNUMBER | F0101 |
| AddressNumber4th | AN84 | ADDRESSNUMBER | F0101 |
| AddressNumber6th | AN86 | ADDRESSNUMBER | F0101 |
| AddressNumber5th | AN85 | ADDRESSNUMBER | F0101 |
| ReportCodeAddBook001 | AC01 | UDC | F0101 |
| ReportCodeAddBook002 | AC02 | UDC | F0101 |
| ReportCodeAddBook003 | AC03 | UDC | F0101 |
| ReportCodeAddBook004 | AC04 | UDC | F0101 |
| ReportCodeAddBook005 | AC05 | UDC | F0101 |
| ReportCodeAddBook006 | AC06 | UDC | F0101 |
| ReportCodeAddBook007 | AC07 | UDC | F0101 |
| ReportCodeAddBook008 | AC08 | UDC | F0101 |
| ReportCodeAddBook009 | AC09 | UDC | F0101 |
| ReportCodeAddBook010 | AC10 | UDC | F0101 |
| ReportCodeAddBook011 | AC11 | UDC | F0101 |
| ReportCodeAddBook012 | AC12 | UDC | F0101 |
| ReportCodeAddBook013 | AC13 | UDC | F0101 |
| ReportCodeAddBook014 | AC14 | UDC | F0101 |
| ReportCodeAddBook015 | AC15 | UDC | F0101 |
| ReportCodeAddBook016 | AC16 | UDC | F0101 |
| ReportCodeAddBook017 | AC17 | UDC | F0101 |
| ReportCodeAddBook018 | AC18 | UDC | F0101 |
| ReportCodeAddBook019 | AC19 | UDC | F0101 |
| ReportCodeAddBook020 | AC20 | UDC | F0101 |
| CategoryCodeAddressBook2 | AC21 | UDC | F0101 |
| CategoryCodeAddressBk22 | AC22 | UDC | F0101 |
| CategoryCodeAddressBk23 | AC23 | UDC | F0101 |
| CategoryCodeAddressBk24 | AC24 | UDC | F0101 |
| CategoryCodeAddressBk25 | AC25 | UDC | F0101 |
| CategoryCodeAddressBk26 | AC26 | UDC | F0101 |
| CategoryCodeAddressBk27 | AC27 | UDC | F0101 |
| CategoryCodeAddressBk28 | AC28 | UDC | F0101 |
| CategoryCodeAddressBk29 | AC29 | UDC | F0101 |
| CategoryCodeAddressBk30 | AC30 | UDC | F0101 |
| GlBankAccount | GLBA | STRING | F0101 |
| TimeScheduledIn | PTI | INTEGER | F0101 |
| DateScheduledIn | PDI | DATE | F0101 |
| ActionMessageControl | MSGA | UDC | F0101 |
| NameRemark | RMK | STRING | F0101 |
| CertificateTaxExempt | TXCT | STRING | F0101 |
| TaxId2 | TX2 | STRING | F0101 |
| Kanjialpha | ALP1 | STRING | F0101 |
| UserReservedCode | URCD | STRING | F0101 |
| UserReservedDate | URDT | DATE | F0101 |
| UserReservedAmount | URAT | FLOAT | F0101 |
| UserReservedNumber | URAB | INTEGER | F0101 |
| UserReservedReference | URRF | STRING | F0101 |
| UserId | USER | STRING | F0101 |
| ProgramId | PID | STRING | F0101 |
| DateUpdated | UPMJ | DATE | F0101 |
| WorkStationId | JOBN | STRING | F0101 |
| TimeLastUpdated | UPMT | INTEGER | F0101 |
| PurgeFlag | PRGF | CHARACTER | F0101 |
| ShortcutClientType | SCCLTP | UDC | F0101 |
| Ticker | TICKER | STRING | F0101 |
| StockExchange | EXCHG | STRING | F0101 |
| DUNSNumber | DUNS | STRING | F0101 |
| ClassificationCode01 | CLASS01 | UDC | F0101 |
| ClassificationCode02 | CLASS02 | UDC | F0101 |
| ClassificationCode03 | CLASS03 | UDC | F0101 |
| ClassificationCode04 | CLASS04 | UDC | F0101 |
| ClassificationCode05 | CLASS05 | UDC | F0101 |
| NumberOfEmployee | NOE | INTEGER | F0101 |
| GrowthRate | GROWTHR | INTEGER | F0101 |
| YearStarted | YEARSTAR | STRING | F0101 |
| EmployeeGroupApprovals | AEMPGP | UDC | F0101 |
| IndicatorFlg | ACTIN | CHARACTER | F0101 |
| RevenueRange | REVRNG | UDC | F0101 |
| SynchronizationStatus | SYNCS | UDC | F0101 |
| PreviousErrorStatus | PERRS | UDC | F0101 |
| ServerStatus | CAAD | UDC | F0101 |
| AddressNumber1 | AN8 | ADDRESSNUMBER | F0111 |
| LineNumberID | IDLN | INTEGER | F0111 |
| SequenceNumber52Display | DSS5 | FLOAT | F0111 |
| NameMailing | MLNM | STRING | F0111 |
| ContactTitle | ATTL | STRING | F0111 |
| Remark1 | REM1 | STRING | F0111 |
| SalutationName | SLNM | STRING | F0111 |
| NameAlpha1 | ALPH | STRING | F0111 |
| DescripCompressed1 | DC | STRING | F0111 |
| NameGiven | GNNM | STRING | F0111 |
| NameMiddle | MDNM | STRING | F0111 |
| NameSurname | SRNM | STRING | F0111 |
| TypeCode | TYC | UDC | F0111 |
| CategoryCodeWhosWh001 | W001 | UDC | F0111 |
| CategoryCodeWhosWh002 | W002 | UDC | F0111 |
| CategoryCodeWhosWh003 | W003 | UDC | F0111 |
| CategoryCodeWhosWh004 | W004 | UDC | F0111 |
| CategoryCodeWhosWh005 | W005 | UDC | F0111 |
| CategoryCodeWhosWh006 | W006 | UDC | F0111 |
| CategoryCodeWhosWh007 | W007 | UDC | F0111 |
| CategoryCodeWhosWh008 | W008 | UDC | F0111 |
| CategoryCodeWhosWh009 | W009 | UDC | F0111 |
| CategoryCodeWhosWh010 | W010 | UDC | F0111 |
| SecondaryMailingName | MLN1 | STRING | F0111 |
| Kanjialpha1 | ALP1 | STRING | F0111 |
| UserId1 | USER | STRING | F0111 |
| ProgramId1 | PID | STRING | F0111 |
| DateUpdated1 | UPMJ | DATE | F0111 |
| WorkStationId1 | JOBN | STRING | F0111 |
| TimeLastUpdated1 | UPMT | INTEGER | F0111 |
| ContacType | NTYP | UDC | F0111 |
| NameNick | NICK | STRING | F0111 |
| GenderMaleFemale | GEND | UDC | F0111 |
| DayDateOfBirth | DDATE | INTEGER | F0111 |
| MonthDateOfBirth | DMON | INTEGER | F0111 |
| YearDateOfBirth | DYR | INTEGER | F0111 |
| CategoryCodeContacts01 | WN001 | UDC | F0111 |
| CategoryCodeContacts02 | WN002 | UDC | F0111 |
| CategoryCodeContacts03 | WN003 | UDC | F0111 |
| CategoryCodeContacts04 | WN004 | UDC | F0111 |
| CategoryCodeContacts05 | WN005 | UDC | F0111 |
| CategoryCodeContacts06 | WN006 | UDC | F0111 |
| CategoryCodeContacts07 | WN007 | UDC | F0111 |
| CategoryCodeContacts08 | WN008 | UDC | F0111 |
| CategoryCodeContacts09 | WN009 | UDC | F0111 |
| CategoryCodeContacts10 | WN010 | UDC | F0111 |
| FunctionCode | FUCO | UDC | F0111 |
| PreferredContactMethod | PCM | UDC | F0111 |
| PrimaryContact | PCF | STRING | F0111 |
| IndicatorFlg1 | ACTIN | CHARACTER | F0111 |
| UniqueIdentifier | CFRGUID | STRING | F0111 |
| SynchronizationStatus1 | SYNCS | UDC | F0111 |
| ServerStatus1 | CAAD | UDC | F0111 |