| iiParentobject_id | integer | |
| icParentType | character | |
| icBanknumber | character | |
| iiCompanyid | integer |
each BankNumber where
first BusinessRelation (outer-join) where
each Address (outer-join) where
first Country (outer-join) where
first County (outer-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tcAddressCity | character | Address.AddressCity | City. The city for this address. This field can be used to decide the tax zone of the address. |
| tiAddressFormat | integer | Address.AddressFormat | Format. This field determines where postal codes display on printed addresses. |
| api annotation: | PartialUpdate = yes - defaults to the value for the same field defined for the country. | ||
| tcAddressStreet1 | character | Address.AddressStreet1 | Address: Line one of address details. This field can be blank. |
| tcAddressStreet2 | character | Address.AddressStreet2 | Address.Line two of address details. This field can be blank. |
| tcAddressZip | character | Address.AddressZip | Zip. The postal code or US zip code associated with this address. This field is used to decide the tax zone for the address. This field can be blank. |
| tiBankAccFormat_ID | integer | BankNumber.BankAccFormat_ID | Bank Account Format |
| tiBankBusinessRelation_ID | integer | BankNumber.BankBusinessRelation_ID | Business Relation |
| tcBankNumber | character | BankNumber.BankNumber | Bank Number |
| tiBankNumber_ID | integer | BankNumber.BankNumber_ID | Record ID |
| tcBankNumberBranch | character | BankNumber.BankNumberBranch | Branch |
| tcBankNumberExtension | character | BankNumber.BankNumberExtension | Bank Extension |
| tcBankNumberFormatted | character | BankNumber.BankNumberFormatted | Formatted Bank Account No |
| tlBankNumberIsActive | logical | BankNumber.BankNumberIsActive | Active |
| tlBankNumberIsDefault | logical | BankNumber.BankNumberIsDefault | Default |
| tlBankNumberIsSBDef | logical | BankNumber.BankNumberIsSBDef | Self-Bill Default |
| tcBankNumberParentType | character | BankNumber.BankNumberParentType | Type |
| tcBankNumberSwiftCode | character | BankNumber.BankNumberSwiftCode | SWIFT Code |
| tcBankNumberValidation | character | BankNumber.BankNumberValidation | Validation |
| tiBankPayFormat_ID | integer | BankNumber.BankPayFormat_ID | Link to BankPayFormat |
| tiBusinessRelation_ID | integer | BusinessRelation.BusinessRelation_ID | Record ID |
| tcBusinessRelationCode | character | BusinessRelation.BusinessRelationCode | Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create. |
| tcBusinessRelationName1 | character | BusinessRelation.BusinessRelationName1 | Name: The full name of the business relation. This field sets the default name for linked addresses such as customers and suppliers. |
| api annotation: | PartialUpdate = yes - defaults to the BusinessRelationCode. | ||
| tcBusinessRelationName2 | character | BusinessRelation.BusinessRelationName2 | Second Name. An extended name when the Name field is not large enough to contain all information. This fielsd can be blank. |
| tiCompanySharedSet_ID | integer | BankNumber.CompanySharedSet_ID | Link to CompanySharedSet |
| tiCountry_ID | integer | Country.Country_ID | Record ID |
| tcCountryDescription | character | Country.CountryDescription | Description |
| tiCounty_ID | integer | County.County_ID | Record ID |
| tcCountyDescription | character | County.CountyDescription | Description |
| tiCurrency_ID | integer | BankNumber.Currency_ID | Currency Code |
| tiDDocumentStatus_ID | integer | BankNumber.DDocumentStatus_ID | Payment Status |
| tiParentObject_ID | integer | BankNumber.ParentObject_ID | Parent Object |
QadFinancials