invantive documentation
Invantive Support ForumsLog In / Sign Up

DebtorManagers: Nmbrs Debtor Managers

read only

  • Catalog: Nmbrs
  • Schema: Views
  • Label: Debtor Managers

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 48

The result can be cached on the client.

Table Columns

The columns of the table DebtorManagers are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
DTR_ID int32 ID Unique ID of the debtor.
DTR_NAME varchar2 Name Name of the debtor.
DTR_NUMBER varchar2 Number Debtor number.
MGR_DEPARTMENT varchar2 Department
MGR_EMAIL varchar2 Email
MGR_FAX varchar2 Fax
MGR_FIRSTNAME varchar2 First Name
MGR_FUNCTION varchar2 Function
MGR_MOBILE varchar2 Mobile
MGR_NAME varchar2 Name
MGR_NUMBER int32 Number
MGR_PHONENUMBER varchar2 Phone Number

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: