| field name | data type | description |
|---|---|---|
| BusinessRelation_ID | integer | |
| CorporateGroup_ID | integer | |
| Lng_ID | integer | |
| Domain_ID | integer | |
| BusinessRelationCode | character | 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. |
| BusinessRelationName1 | character | 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. | |
| BusinessRelationName2 | character | Second Name. An extended name when the Name field is not large enough to contain all information. This fielsd can be blank. |
| BusinessRelationName3 | character | Third Name: A name required for some regional reports. This field can be blank. |
| BusinessRelationSearchName | character | Search Name: An alternate name for finding the business relation. This field can be useful for sorting and filtering. |
| api annotation: | PartialUpdate = yes - defaults to the BusinessRelationCode. | |
| BusinessRelationICCode | character | Intercompany Code. When Intercompany is true, this field is mandatory. The code entered here must match the intercompany code entered for GL accounts in order to generate intercompany reports. The intercompany code must be unique for this business relation. |
| BusinessRelationIsActive | logical | Active: This field indicates if this is an active record. |
| api annotation: | PartialUpdate = yes - defaults to true. | |
| BusinessRelationIsInterco | logical | Intercompany. This field Indicates if the business relation identifies an entity that is a member of a group of entities that trade with each other. If the business relation is identified as an internal entity,this field is true and cannot be changed. |
| api annotation: | PartialUpdate = yes - defaults to false. | |
| BusinessRelationIsInComp | logical | Internal Entity. This filed indicates if the business relation identifies one of your entities within this database. If this is an internal entity, you can also update the Tax Report, Name Control, and Last Filing fields, which are used for filing 1099-MISC reports in the US. |
| api annotation: | PartialUpdate = yes - defaults to false. For internal entities, this field defaults to yes and cannot be changed. | |
| BusinessRelationIsCompens | logical | Customer/Supplier Compensation Allowed. This filed indicates how open items should be managed during payment processing when a customer and supplier are both associated with this business relation. |
| api annotation: | PartialUpdate = yes - defaults to false. | |
| BusinessRelationIsTaxRep | logical | Tax Report. For an internal company,this filed indicates whether to use this address for 1099 tax reporting. When this field is yes, the name, first line of the street address, city, state, zip code, telephone number, and federal tax ID for the headoffice address must not be blank. |
| api annotation: | PartialUpdate = yes - defaults to false. | |
| BusinessRelationIsLastFill | logical | Last Filing. For an internal company, this field indicates whether this is the last time your company is filing a 1099-MISC under its current taxpayer ID number. |
| api annotation: | PartialUpdate = yes - defaults to false. | |
| BusinessRelationIsDomRestr | logical | Domain Restricted. This filed indicates if access to this business relation is restricted by domain. |
| api annotation: | PartialUpdate = yes - defaults to the value for this field defaults from the Business Relations by Domain field in System Maintain. | |
| BusinessRelationAVRCode | character | Obsolete field |
| BusinessRelationEANCode | character | Obsolete field |
| BusinessRelationNameCtrl | character | Name Control. For an internal company, the value is the IRS magnetic media control code assigned to this company. When Tax Report is selected, a warning displays when this field is blank. |
| BusinessRelationOrgType | character | |
| BusinessRelationComRegisterNbr | character | |
| BusinessRelationInstNbr | character | |
| BusinessRelationInstCode | character | |
| ObsoleteSalesPriceList_ID | integer | |
| ObsoletePurchPriceList_ID | integer | |
| ObsoleteCostPriceList_ID | integer | |
| tcCorporateGroupCode | character | Group Name. This field identifies a corporate group to associate with the business relation for reporting. This field can be blank. |
| tcLngCode | character | Language Code: A code identifying the language used by this business relationship. |
| tcSalesPriceListCode | character | |
| tcPurchasePriceListCode | character | |
| tcCostPriceListCode | character | Obsolete field |
| CustomShort0 | character | |
| CustomShort1 | character | |
| CustomShort2 | character | |
| CustomShort3 | character | |
| CustomShort4 | character | |
| CustomShort5 | character | |
| CustomShort6 | character | |
| CustomShort7 | character | |
| CustomShort8 | character | |
| CustomShort9 | character | |
| CustomCombo0 | character | |
| CustomCombo1 | character | |
| CustomCombo2 | character | |
| CustomCombo3 | character | |
| CustomCombo4 | character | |
| CustomCombo5 | character | |
| CustomCombo6 | character | |
| CustomCombo7 | character | |
| CustomCombo8 | character | |
| CustomCombo9 | character | |
| CustomLong0 | character | |
| CustomLong1 | character | |
| CustomNote | character | |
| CustomDate0 | date | |
| CustomDate1 | date | |
| CustomDate2 | date | |
| CustomDate3 | date | |
| CustomDate4 | date | |
| CustomInteger0 | integer | |
| CustomInteger1 | integer | |
| CustomInteger2 | integer | |
| CustomInteger3 | integer | |
| CustomInteger4 | integer | |
| CustomDecimal0 | decimal(4) | |
| CustomDecimal1 | decimal(4) | |
| CustomDecimal2 | decimal(4) | |
| CustomDecimal3 | decimal(4) | |
| CustomDecimal4 | decimal(4) | |
| CustomShort10 | character | |
| CustomShort11 | character | |
| CustomShort12 | character | |
| CustomShort13 | character | |
| CustomShort14 | character | |
| CustomCombo10 | character | |
| CustomCombo11 | character | |
| CustomCombo12 | character | |
| CustomCombo13 | character | |
| CustomCombo14 | character | |
| CustomDate5 | date | |
| CustomDate6 | date | |
| CustomDate7 | date | |
| CustomDate8 | date | |
| CustomDate9 | date | |
| LastModifiedDate | date | |
| LastModifiedTime | integer | |
| LastModifiedUser | character | |
| QADC01 | character | unused QAD reserved field |
| QADC02 | character | unused QAD reserved field |
| QADT01 | date | unused QAD reserved field |
| QADD01 | decimal(10) | unused QAD reserved field |
| tc_Rowid | character | |
| tc_ParentRowid | character | |
| tc_Status | character |
QadFinancials