| iiCompanyId | integer | Company id |
| icDebtorCode | character |
each Debtor where
first BusinessRelation (inner-join) where
first Currency (inner-join) where
first PaymentCondition (inner-join) where
first Reason (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiBLWIGroup_ID | integer | Debtor.BLWIGroup_ID | BLWI Group Code |
| tiBusinessRelation_ID | integer | Debtor.BusinessRelation_ID | Business Relation |
| 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. |
| tcBusinessRelationICCode | character | BusinessRelation.BusinessRelationICCode | 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. |
| tlBusinessRelationIsInterco | logical | BusinessRelation.BusinessRelationIsInterco | 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. | ||
| 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. | ||
| tiCnControlGLProfile_ID | integer | Debtor.CnControlGLProfile_ID | Control GL Profile (Credit Note) |
| tiCurrency_ID | integer | Debtor.Currency_ID | Currency Code |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tiDebtor_ID | integer | Debtor.Debtor_ID | Record ID |
| tcDebtorCode | character | Debtor.DebtorCode | A code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation. |
| api annotation: | If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create. | ||
| tlDebtorIsActive | logical | Debtor.DebtorIsActive | Indicate if this is an active record. |
| api annotation: | Value for this field defaults to false. | ||
| tlDebtorIsTaxable | logical | Debtor.DebtorIsTaxable | Indicate if business activities for this address are normally subject to tax. |
| api annotation: | Value for the field defaults from the Taxable field in Global Tax Management Control. | ||
| tcDebtorTaxIDState | character | Debtor.DebtorTaxIDState | State Tax- For reference and documentation purposes, enter either a state or provincial tax identification number or a VAT registration number. |
| api annotation: | Value for the field defaults to null. | ||
| tiDivisionProfile_ID | integer | Debtor.DivisionProfile_ID | Sub-Account Profile |
| tiFinChgGLProfile_ID | integer | Debtor.FinChgGLProfile_ID | Finance Charge Profile |
| tiInvControlGLProfile_ID | integer | Debtor.InvControlGLProfile_ID | Control GL Profile (Invoice) |
| tiNormalPaymentCondition_ID | integer | PaymentCondition.PaymentCondition_ID | Record ID |
| ttPaymentConditionBaseDate | date | PaymentCondition.PaymentConditionBaseDate | Base Date |
| tiPaymentConditionBaseDays | integer | PaymentCondition.PaymentConditionBaseDays | Base Days |
| tcPaymentConditionCode | character | PaymentCondition.PaymentConditionCode | Credit Terms Code |
| tiPaymentConditionDayMthDisc | integer | PaymentCondition.PaymentConditionDayMthDisc | No of Periods |
| tiPaymentConditionDaysMonths | integer | PaymentCondition.PaymentConditionDaysMonths | No of Periods |
| tcPaymentConditionDescript | character | PaymentCondition.PaymentConditionDescript | Description |
| tiPaymentConditionDueDays | integer | PaymentCondition.PaymentConditionDueDays | Min Due Days |
| tcPaymentConditionPaymentTyp | character | PaymentCondition.PaymentConditionPaymentTyp | Payment Type |
| tcPaymentConditionPdDiscType | character | PaymentCondition.PaymentConditionPdDiscType | Period Type |
| tdPaymentConditionPercentage | decimal | PaymentCondition.PaymentConditionPercentage | Discount Percentage |
| tcPaymentConditionPeriodType | character | PaymentCondition.PaymentConditionPeriodType | Period Type |
| tiPaymentConditionSupDayDisc | integer | PaymentCondition.PaymentConditionSupDayDisc | Supplementary Days |
| tiPaymentConditionSupplDays | integer | PaymentCondition.PaymentConditionSupplDays | Supplementary Days |
| tiPrePayControlGLProfile_ID | integer | Debtor.PrePayControlGLProfile_ID | Control GL Profile (Pre-payment) |
| tcReasonAllocationStatus | character | Reason.ReasonAllocationStatus | Allocation Status |
| tcReasonCode | character | Reason.ReasonCode | Invoice Status Code |
| tiSalesAccountGLProfile_ID | integer | Debtor.SalesAccountGLProfile_ID | Sales Account GL Profile |
| tcTxclTaxCls | character | Debtor.TxclTaxCls | A tax class previously defined in Tax Class Maintenance. Tax classes group addresses taxed at specific rates or that are tax-exempt and help determine the default tax environment (set of tax types) for related transactions. |
| api annotation: | The value of tax class defaults from the header of transactions created for this address. | ||
| tcTxuTaxUsage | character | Debtor.TxuTaxUsage | A tax usage code previously defined in Tax Usage Maintenance. Tax usage codes identify the normal use of items sold to this address.Common tax usages are retail, manufacturing, and industrialization. |
| api annotation: | The value of tax usage defaults from the header of transactions created for this address. | ||
| tcTxzTaxZone | character | Debtor.TxzTaxZone | The tax zone for this address, defined in Tax Zone Maintenance. A value is required. |
| api annotation: | The system searches for a default based on the country, state or province, county, city, and postal code of the current address. |
QadFinancials