tcBusinessFieldName | tcDataType | tcOperator |
---|---|---|
iiCompanyId | i | |
tAddress.AddressCity | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tAddress.AddressCounty | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tAddress.AddressIsTaxable | l | =,<> |
tAddress.AddressIsTaxIncluded | l | =,<> |
tAddress.AddressName | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tAddress.AddressStreet1 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tAddress.AddressStreet2 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tAddress.AddressStreet3 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tAddress.AddressTaxDeclaration | i | =,>=,>,<>,<=,< |
tAddress.AddressTaxIDFederal | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tAddress.AddressTaxIDMisc1 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tAddress.AddressTaxIDMisc2 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tAddress.AddressTaxIDMisc3 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tAddressType.AddressTypeCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tAddress.AddressZip | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tBillSchedule.BillScheduleCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tBusinessRelation.BusinessRelationCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tBusinessRelation.BusinessRelationIsInterco | l | =,<> |
tBusinessRelation.BusinessRelationName1 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tBusinessRelation.BusinessRelationName2 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tBusinessRelation.BusinessRelationSearchName | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tCorporateGroup.CorporateGroupCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tCountry.CountryCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tCountry.CountryDescription | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tCounty.CountyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tCurrency.CurrencyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.DebtorCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor2.DebtorCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.DebtorCommentNote | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtorCreditRating.DebtorCreditRatingCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.DebtorDBNumber | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.DebtorFixedCredLimTC | d | =,>=,>,<>,<=,< |
tDebtor.DebtorHighCredit | d | =,>=,>,<>,<=,< |
tDebtor.DebtorHighCreditDate | t | =,>=,>,<>,<=,< |
tDebtor.DebtorIsActive | l | =,<> |
tDebtor.DebtorIsCheckAftDICredLim | l | =,<> |
tDebtor.DebtorIsCheckAftSOCredLim | l | =,<> |
tDebtor.DebtorIsCheckBefDICredLim | l | =,<> |
tDebtor.DebtorIsCheckBefSOCredLim | l | =,<> |
tDebtor.DebtorIsFinanceCharge | l | =,<> |
tDebtor.DebtorIsFixedCredLim | l | =,<> |
tDebtor.DebtorIsInvoiceByAuth | l | =,<> |
tDebtor.DebtorIsLockedCredLim | l | =,<> |
tDebtor.DebtorIsMaxDaysDueCredLim | l | =,<> |
tDebtor.DebtorIsOverruleDICredLim | l | =,<> |
tDebtor.DebtorIsOverruleSOCredLim | l | =,<> |
tDebtor.DebtorIsPrintReminder | l | =,<> |
tDebtor.DebtorIsPrintStatement | l | =,<> |
tDebtor.DebtorIsTaxable | l | =,<> |
tDebtor.DebtorIsTaxInCity | l | =,<> |
tDebtor.DebtorIsTaxIncluded | l | =,<> |
tDebtor.DebtorIsToBeLockedCredLim | l | =,<> |
tDebtor.DebtorIsTurnOverCredLim | l | =,<> |
tDebtor.DebtorLastCreditReview | t | =,>=,>,<>,<=,< |
tDebtor.DebtorLastCreditUpdate | t | =,>=,>,<>,<=,< |
tDebtor.DebtorLastFinChargeDate | t | =,>=,>,<>,<=,< |
tDebtor.DebtorLastPayment | t | =,>=,>,<>,<=,< |
tDebtor.DebtorLastSale | t | =,>=,>,<>,<=,< |
tDebtor.DebtorMaxNumDaysCredLim | i | =,>=,>,<>,<=,< |
tDebtor.DebtorPercTurnOverCredLim | d | =,>=,>,<>,<=,< |
tDebtor.DebtorPercWarningCredLim | d | =,>=,>,<>,<=,< |
tDebtor.DebtorSalesOrderBalance | d | =,>=,>,<>,<=,< |
tDebtor.DebtorStatementCycle | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.DebtorTaxDeclaration | i | =,>=,>,<>,<=,< |
tDebtor.DebtorTaxIDFederal | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.DebtorTaxIDMisc1 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.DebtorTaxIDMisc2 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.DebtorTaxIDMisc3 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.DebtorTaxIDState | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.DebtorTotalDaysLate | i | =,>=,>,<>,<=,< |
tDebtor.DebtorTotalNbrOfInvoices | i | =,>=,>,<>,<=,< |
tDebtorType.DebtorTypeCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.DomiciliationNumber | i | =,>=,>,<>,<=,< |
tPaymentCondition.PaymentConditionCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tPaymentGroup.PaymentGroupCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tProfile5.ProfileCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tProfile3.ProfileCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tProfile1.ProfileCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tProfile2.ProfileCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tProfile4.ProfileCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tReason.ReasonCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tState.StateCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.TxclTaxCls | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.TxuTaxUsage | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDebtor.TxzTaxZone | c | =,>=,>,<>,<=,<,begins,can-do,matches |
iiCompanyId | integer | Company id |
field name | data type | db field | description |
---|---|---|---|
tcAddressCounty | character | Address.AddressCounty | Obsolete field |
tlAddressIsTaxable | logical | Address.AddressIsTaxable | Taxable Address. This field indicates if business activities for this address are normally subject to tax. The taxable status of the address defaults to transactions where the address is used. |
api annotation: | PartialUpdate = yes - defaults to false. | ||
tlAddressIsTaxIncluded | logical | Address.AddressIsTaxIncluded | Tax Is Included. This field indicates if line item prices for this address normally include tax. The value of Tax Is Included defaults to the header of transactions created for this address. |
api annotation: | PartialUpdate = yes - defaults to false. | ||
tcAddressName | character | Address.AddressName | Name. The full name of this particular address. The name of a headoffice address is the same as the name of the business relationship and can not be modified. |
api annotation: | PartialUpdate = yes - defaults to the name of the businessRelation. | ||
tcAddressStreet3 | character | Address.AddressStreet3 | Address.Line three of address details. This field can be blank. |
tiAddressTaxDeclaration | integer | Address.AddressTaxDeclaration | This field is mandatory. |
tcAddressTaxIDFederal | character | Address.AddressTaxIDFederal | Federal Tax. The value of this filed is the tax ID assigned to this address by the federal or national government. If Tax Report is true, the Federal tax ID must be unique; otherwise, related business relations can share an ID. |
tcAddressTaxIDMisc1 | character | Address.AddressTaxIDMisc1 | Miscellaneous Tax 1.This field is for reference and documentation purposes, its value can be any other tax identification numbers that are useful. This field can be blank. |
tcAddressTaxIDMisc2 | character | Address.AddressTaxIDMisc2 | Miscellaneous Tax 2.This field is for reference and documentation purposes, its value can be any other tax identification numbers that are useful. This field can be blank. |
tcAddressTaxIDMisc3 | character | Address.AddressTaxIDMisc3 | Miscellaneous Tax 3.This field is for reference and documentation purposes, its value can be any other tax identification numbers that are useful. This field can be blank. |
tcAddressTypeCode | character | AddressType.AddressTypeCode | Address Type |
tiBillSchedule_ID1 | integer | BillSchedule.BillSchedule_ID | Record ID |
tcBillScheduleCode | character | BillSchedule.BillScheduleCode | Billing Schedule Code |
tcBillToDebtorCode | character | Debtor2.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. | ||
tcCnControlGLProfileCode | character | Profile2.ProfileCode | A code (maximum 20 characters) that identifies a profile. |
tcCorporateGroupCode | character | CorporateGroup.CorporateGroupCode | Group Name |
tiCountry_ID | integer | Country.Country_ID | Record ID |
tcCountryCode | character | Country.CountryCode | Country Code |
tcCountryDescription | character | Country.CountryDescription | Description |
tcCountyCode | character | County.CountyCode | County Code |
tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
tcDebtorCommentNote | character | Debtor.DebtorCommentNote | Free-form text related to this customer that is saved with the customer record. |
api annotation: | Value for this field defaults to null. | ||
tcDebtorCreditRatingCode | character | DebtorCreditRating.DebtorCreditRatingCode | A code (maximum eight characters) that identifies a customer credit rating. |
tcDebtorDBNumber | character | Debtor.DebtorDBNumber | The credit agency reference number assigned to this customer. |
api annotation: | Value for this field defaults to null. | ||
tdDebtorFixedCredLimTC | decimal | Debtor.DebtorFixedCredLimTC | When Apply Fixed Ceiling is selected, specify the currency amount that determines the maximum credit extended to this customer. |
api annotation: | Value for this field defaults to 0.0000 . | ||
tdDebtorHighCredit | decimal | Debtor.DebtorHighCredit | The highest amount of credit you have ever extended to this customer. This is the largest AR balance they have had open at one time. |
ttDebtorHighCreditDate | date | Debtor.DebtorHighCreditDate | The date the highest credit amount was extended to this customer. |
tlDebtorIsCheckAftDICredLim | logical | Debtor.DebtorIsCheckAftDICredLim | Indicate whether to perform the credit check when saving a new or modified invoice and include the new invoice amount in the total. |
api annotation: | Value for this field defaults to false. | ||
tlDebtorIsCheckAftSOCredLim | logical | Debtor.DebtorIsCheckAftSOCredLim | Indicate whether to perform the credit check when saving a new or modified order and include the new order amount in the total. |
api annotation: | Value for this field defaults to false. | ||
tlDebtorIsCheckBefDICredLim | logical | Debtor.DebtorIsCheckBefDICredLim | Indicate whether to perform the credit check before a new customer invoice is entered. |
api annotation: | Value for this field defaults to false. | ||
tlDebtorIsCheckBefSOCredLim | logical | Debtor.DebtorIsCheckBefSOCredLim | Indicate whether to perform the credit check before a new order is entered or not. |
api annotation: | Value for this field defaults to false. | ||
tlDebtorIsFinanceCharge | logical | Debtor.DebtorIsFinanceCharge | Indicate whether to make this customer’s accounts liable for finance charges or not. |
api annotation: | Value for this field defaults to false. | ||
tlDebtorIsFixedCredLim | logical | Debtor.DebtorIsFixedCredLim | Indicate if the credit limit of the customer is fixed. |
api annotation: | Value for this field defaults to false. | ||
tlDebtorIsInvoiceByAuth | logical | Debtor.DebtorIsInvoiceByAuth | Indicate how invoice totals should be calculated and displayed for this customer. |
api annotation: | Value for this field defaults to false. | ||
tlDebtorIsLockedCredLim | logical | Debtor.DebtorIsLockedCredLim | Indicate whether to put this customer on hold. |
api annotation: | Value for this field defaults to false. | ||
tlDebtorIsMaxDaysDueCredLim | logical | Debtor.DebtorIsMaxDaysDueCredLim | Indicate whether you can enter a value in the Maximum Number of Days field or not. |
api annotation: | Value for this field defaults to false. | ||
tlDebtorIsOverruleDICredLim | logical | Debtor.DebtorIsOverruleDICredLim | Indicate whether to allow users to enter invoice transactions for a customer when the customer’s credit limit is exceeded. |
api annotation: | Value for this field defaults to false. | ||
tlDebtorIsOverruleSOCredLim | logical | Debtor.DebtorIsOverruleSOCredLim | Indicate whether to allow users to enter order transactions for a customer when the customer’s credit limit is exceeded. |
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. | ||
tlDebtorIsTaxInCity | logical | Debtor.DebtorIsTaxInCity | This setting determines whether the address is in the city limits for taxation purposes. It is used only with the Sales and Use Tax Interface for US and Canadian tax processing. |
api annotation: | Value for the field defaults from the business relation. | ||
tlDebtorIsTaxIncluded | logical | Debtor.DebtorIsTaxIncluded | Tax Is Included |
tlDebtorIsToBeLockedCredLim | logical | Debtor.DebtorIsToBeLockedCredLim | Indicate if the system puts the customer on credit hold if any of the credit limits are violated when new orders for this customer are created or not. |
api annotation: | Value for this field defaults to false. | ||
tlDebtorIsTurnOverCredLim | logical | Debtor.DebtorIsTurnOverCredLim | Indicate whether you can enter a percentage in the Percentage of Turnover field. |
api annotation: | Value for this field defaults to false. | ||
ttDebtorLastCreditReview | date | Debtor.DebtorLastCreditReview | The date when the customer’s credit status was last reviewed. |
ttDebtorLastCreditUpdate | date | Debtor.DebtorLastCreditUpdate | The date when the customer’s credit status was last updated. |
ttDebtorLastFinChargeDate | date | Debtor.DebtorLastFinChargeDate | The date when finance charge is last calculated for this customer. |
api annotation: | Value for this field defaults to null. | ||
ttDebtorLastPayment | date | Debtor.DebtorLastPayment | Last payment date. |
api annotation: | The system automatically updates this date when transactions are posted in Banking Entry, Petty Cash, and Customer Payments. | ||
ttDebtorLastSale | date | Debtor.DebtorLastSale | The date an invoice was last posted for this customer. |
api annotation: | This date is updated by Invoice Post and Print. | ||
tiDebtorMaxNumDaysCredLim | integer | Debtor.DebtorMaxNumDaysCredLim | Specify the number of days that any invoice for this customer can be overdue before the system disallows any further credit. |
api annotation: | Value for this field defaults to 0. | ||
tdDebtorPercTurnOverCredLim | decimal | Debtor.DebtorPercTurnOverCredLim | When Apply % of Turnover is selected,specify a percentage value. The system applies this percentage to the last year turnover and displays the result in the Credit on Turnover field. The amount is recalculated when you change the percentage. |
api annotation: | Value for this field defaults to 0.00 . | ||
tdDebtorPercWarningCredLim | decimal | Debtor.DebtorPercWarningCredLim | Select to generate a warning message when the specified percentage of the credit limit has been reached. |
api annotation: | Value for this field defaults to 0.00 . | ||
tdDebtorSalesOrderBalance | decimal | Debtor.DebtorSalesOrderBalance | Current balance of all sales order related to this customer. |
api annotation: | Value for this field defaults to 0.0000 . | ||
tcDebtorStatementCycle | character | Debtor.DebtorStatementCycle | A value to indicate how often you normally print AR statements for this customer. |
api annotation: | Value for this field defaults to null. | ||
tiDebtorTaxDeclaration | integer | Debtor.DebtorTaxDeclaration | Tax Declaration |
tcDebtorTaxIDFederal | character | Debtor.DebtorTaxIDFederal | Federal Tax- the tax ID assigned to this address by the federal or national government. |
api annotation: | Value for the field defaults to null. | ||
tcDebtorTaxIDMisc1 | character | Debtor.DebtorTaxIDMisc1 | Miscellaneous tax 1, 2, 3. For reference and documentation purposes, enter any other tax identification numbers that are useful. |
api annotation: | Values for these fields default to null. | ||
tcDebtorTaxIDMisc2 | character | Debtor.DebtorTaxIDMisc2 | Miscellaneous Tax 2 |
tcDebtorTaxIDMisc3 | character | Debtor.DebtorTaxIDMisc3 | Miscellaneous Tax 3 |
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. | ||
tiDebtorTotalDaysLate | integer | Debtor.DebtorTotalDaysLate | Total Days Late |
tiDebtorTotalNbrOfInvoices | integer | Debtor.DebtorTotalNbrOfInvoices | Number of paid invoices related to this customer. |
tcDebtorTypeCode | character | DebtorType.DebtorTypeCode | A code (maximum four characters) that identifies a customer type. |
tiDeductionCtrlGLProfile_ID | integer | Debtor.DeductionCtrlGLProfile_ID | Link to Deduction Profile |
tcDeductionCtrlProfileCode | character | Profile1.ProfileCode | A code (maximum 20 characters) that identifies a profile. |
tcDivisionProfileCode | character | Profile5.ProfileCode | A code (maximum 20 characters) that identifies a profile. |
tiDomiciliationNumber | integer | Debtor.DomiciliationNumber | Domiciliation Number |
tcInvControlGLProfileCode | character | Profile3.ProfileCode | A code (maximum 20 characters) that identifies a profile. |
tcNormalPaymentConditionCode | character | PaymentCondition.PaymentConditionCode | Credit Terms Code |
tcPaymentGroupCode | character | PaymentGroup.PaymentGroupCode | Payment Group |
tcReasonCode | character | Reason.ReasonCode | Invoice Status Code |
tcSalesAccountGLProfileCode | character | Profile4.ProfileCode | A code (maximum 20 characters) that identifies a profile. |
tcStateCode | character | State.StateCode | State |
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. | ||
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. | ||
tiBLWIGroup_ID | integer | Debtor.BLWIGroup_ID | BLWI Group Code |
tiCnControlGLProfile_ID | integer | Debtor.CnControlGLProfile_ID | Control GL Profile (Credit Note) |
tiCurrency_ID | integer | Debtor.Currency_ID | Currency Code |
tlDebtorIsPrintReminder | logical | Debtor.DebtorIsPrintReminder | Indicate if reminders are typically printed for this customer to report past due balances. |
api annotation: | Value for this field defaults to false. | ||
tlDebtorIsPrintStatement | logical | Debtor.DebtorIsPrintStatement | Indicate if statements should be printed for this customer. When this field is selected, a statement is printed for this customer using the frequency specified in Statement Cycle. |
api annotation: | Value for this field defaults to false. | ||
tiDivisionProfile_ID | integer | Debtor.DivisionProfile_ID | Sub-Account Profile |
tiInvControlGLProfile_ID | integer | Debtor.InvControlGLProfile_ID | Control GL Profile (Invoice) |
tiNormalPaymentCondition_ID | integer | Debtor.NormalPaymentCondition_ID | Credit Terms Code |
tiReason_ID | integer | Debtor.Reason_ID | Invoice Status Code |
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. | ||
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. |
tcBusinessRelationSearchName | character | BusinessRelation.BusinessRelationSearchName | 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. | ||
tlDebtorIsActive | logical | Debtor.DebtorIsActive | Indicate if this is an active record. |
api annotation: | Value for this field defaults to false. | ||
tcAddressStreet2 | character | Address.AddressStreet2 | Address.Line two of address details. This field can be blank. |
tcAddressStreet1 | character | Address.AddressStreet1 | Address: Line one 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. |
tcAddressCity | character | Address.AddressCity | City. The city for this address. This field can be used to decide the tax zone of the address. |
tiDebtor_ID | integer | Debtor.Debtor_ID | Record ID |
tiSharedSet_ID | integer | Debtor.SharedSet_ID | Link to SharedSet |
tiBusinessRelation_ID | integer | Debtor.BusinessRelation_ID | Business Relation |
DebtorCustom | character | calculated | custom fields |
BillScheduleCustom | character | calculated | custom fields |
Profile1Custom | character | calculated | custom fields |
BusinessRelationCustom | character | calculated | custom fields |
AddressCustom | character | calculated | custom fields |
AddressTypeCustom | character | calculated | custom fields |
CountryCustom | character | calculated | custom fields |
CountyCustom | character | calculated | custom fields |
StateCustom | character | calculated | custom fields |
CorporateGroupCustom | character | calculated | custom fields |
CurrencyCustom | character | calculated | custom fields |
Debtor2Custom | character | calculated | custom fields |
DebtorCreditRatingCustom | character | calculated | custom fields |
DebtorTypeCustom | character | calculated | custom fields |
PaymentConditionCustom | character | calculated | custom fields |
PaymentGroupCustom | character | calculated | custom fields |
Profile2Custom | character | calculated | custom fields |
Profile3Custom | character | calculated | custom fields |
Profile4Custom | character | calculated | custom fields |
Profile5Custom | character | calculated | custom fields |
ReasonCustom | character | calculated | custom fields |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(Debtor),rowid(BillSchedule),rowid(BusinessRelation),rowid(Address),rowid(AddressType),rowid(Country),rowid(County),rowid(State),rowid(CorporateGroup),rowid(Currency),rowid(Debtor2),rowid(DebtorCreditRating),rowid(DebtorType),rowid(PaymentCondition),rowid(PaymentGroup),rowid(Profile2),rowid(Profile3),rowid(Profile4),rowid(Profile5),rowid(Profile1),rowid(Reason) |
define temp-table ttContext no-undo field propertyQualifier as character field propertyName as character field propertyValue as character index entityContext is primary unique propertyQualifier propertyName index propertyQualifier propertyQualifier. define dataset dsContext for ttContext. define variable vhContextDS as handle no-undo. define variable vhExceptionDS as handle no-undo. define variable vhServer as handle no-undo. define variable vhInputDS as handle no-undo. define variable vhInputOutputDS as handle no-undo. define variable vhOutputDS as handle no-undo. define variable vhParameter as handle no-undo. /* Create context */ create ttContext. assign ttContext.propertyName = "programName" ttContext.propertyValue = "BDebtor". create ttContext. assign ttContext.propertyName = "methodName" ttContext.propertyValue = "SelectDebtor". create ttContext. assign ttContext.propertyName = "applicationId" ttContext.propertyValue = "fin". create ttContext. assign ttContext.propertyName = "entity" ttContext.propertyValue = "1000". create ttContext. assign ttContext.propertyName = "userName" ttContext.propertyValue = "mfg". create ttContext. assign ttContext.propertyName = "password" ttContext.propertyValue = "". /* Create input dataset */ create dataset vhInputDS. vhInputDS:read-xmlschema("file", "xml/bdebtor.selectdebtor.i.xsd", ?). vhParameter = vhInputDS:get-buffer-handle("tParameterI"). vhParameter:buffer-create(). assign vhParameter::icRange = "A" vhParameter::icRowid = "" vhParameter::iiRownum = 0 vhParameter::iiNumber = 5 /* Number of records to read */ vhParameter::icSortColumns = "" vhParameter::ilCountOnly = false vhParameter::ilForwardRead = true vhParameter::iiMaximumBrowseRecordsToCount = 0. vhParameter = vhInputDS:get-buffer-handle("tFilter"). vhParameter:buffer-create(). assign vhParameter::<field-name-1> = <field-value-1> vhParameter::<field-name-2> = <field-value-2> ... /* Connect the AppServer */ create server vhServer. vhServer:connect("-URL <appserver-url>"). if not vhServer:connected() then do: message "Could not connect AppServer" view-as alert-box error title "Error". return. end. /* Run */ assign vhContextDS = dataset dsContext:handle. run program/rpcrequestservice.p on vhServer (input-output dataset-handle vhContextDS by-reference, output dataset-handle vhExceptionDS, input dataset-handle vhInputDS by-reference, input-output dataset-handle vhInputOutputDS by-reference, output dataset-handle vhOutputDS). /* Handle output however you want, in this example, we dump it to xml */ if valid-handle(vhExceptionDS) then vhExceptionDS:write-xml("file", "Exceptions.xml", true). if valid-handle(vhOutputDS) then vhOutputDS:write-xml("file", "Output.xml", true). /* Cleanup */ vhServer:disconnect(). assign vhServer = ?. if valid-handle(vhInputDS) then delete object vhInputDS. if valid-handle(vhOutputDS) then delete object vhOutputDS. if valid-handle(vhExceptionDS) then delete object vhExceptionDS.