Skip to main content
Mitratech Success Center

EInvcDetail

EInvcDetail contains all categories added to invoice records. Each time a category is added to an invoice record, an entry is made in this table in the database.

In Object Navigator, EInvcDetail is not displayed when you traverse using the detailList--> bridge. Instead, a list of all categories that have been defined for the object definition appears. This list is labeled Category. From each category, you can traverse to a table called Detail Fields, which displays all custom fields belonging to the category you selected.

For more information about how custom field values are stored in the database, see Object Model: Custom Fields.

Object: EInvcDetail (E_INVC_DETAIL)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

               

Rules

Temp/Wiz

category
-->

CATEGORY_ID (NUMBER)

Category

x

x

YRecently
Viewed
Record

object

The category of the invoice with which the details are associated.

   

owner-->

ENTERPRISE _OBJECT_
ID (NUMBER)

   

x

TInvoice

object

The invoice with which the custom fields are associated.

   

isManual

IS_
MANUAL (NUMBER)

 

x

   

boolean

Specifies whether the category is added manually or automatically to the invoice.

Categories are added automatically when they are the parent of the category that is added manually.

0 - Added Automatically
1 - Added Manually

   

primary
Key

PRIMARY_KEY
(NUMBER)

 

x

   

int

The unique ID of the invoice category record.

   

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the added category was updated.

   

ELitmDetail

ELitmDetail organizes the detail values for an invoice line item (JInvcLineItem object). Detail values originate from custom fields associated with the category assigned to the line item.

There can be multiple ELitmDetail objects for each JInvcLineItem. There is one ELitmDetail for each category used in JInvcLineItem, including any parent categories, plus the Root category. For example, if the category assigned to the JInvcLineItem object were Root : Expense : Parking, there would be three associated ELitmDetail objects: one for Root, one for Expense, and one for Parking.

Note that in ELitmDetail there are attributes for multiple lists of detail values. However, in any given ELitmDetail object, it is possible that only some of those attributes will really have values. Since an ELitmDetail object has a specific category, only the custom fields that match the category will be used. Thus there will only be values for the field types that those custom fields represent.

Object: ELitmDetail (E_LITM_DETAIL)

Attribute

Database column name

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

             

Rules

Temp/Wiz

isManual

IS_MANUAL (NUMBER)

x

   

boolean

Specifies whether the category is added manually or automatically to the line item. Categories are added automatically when they are the parent of the category that is added manually.

0 - Added Automatically
1 - Added Manually

   

primary
Key

PRIMARY_
KEY (NUMBER)

x

   

int

Unique ID automatically assigned to this custom field value.

   

version

VERSION (NUMBER)

x

   

int

Indicates how many times the line item detail was updated.

   

category-->

CATEGORY_
ID (NUMBER)

 

x

YRecently
ViewedRecord

object

8 The category to which this detail belongs.

Links to a category to which the line item belongs. Note that most line items belong to multiple categories - a specific category, plus any parent category, grandparent category, etc.

   

owner-->

ENTERPRISE _OBJECT_ID (NUMBER)

x

x

JInvcLineItem

object

8 The invoice line item record to which this detail belongs.

--> Links to information about the invoice record to which the line item belongs.

   

ELitmGroupAccess

ELitmGroupAccess controls the privileges that a user group has for a specific invoice line item.

Object: ELitm GroupAccess (E_LITM_GROUP_ACCESS)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

               

Rules

Temp/Wiz

accessIID

OPERATION_IID (NUMBER)

Read, Update,
Delete
, or Perm check boxes

x

   

int

Specifies which of the following operations have been selected:

64 - Read
2 - Update
4 - Delete
8 - Set Permission

This attribute contains the sum of all operations that the group is allowed or denied access to. For example, if the group is denied access to Delete and Perm, this column would contain the value 12
[=4 (Delete) + 8 (Set Perm)]

This attribute does not determine whether the operations are allowed or denied.

   

allowDeny
IID

ALLOW_
DENY_IID
(NUMBER)

Option

 

x

 

   

char

Indicates whether the group is allowed or denied access to the record.

a - Allow
d - Deny

   

group-->

GROUP_ID (NUMBER)

List

 

x

 

 

x

 

YGroup

object

8 Specifies the group that the access rights pertain to.

--> Links to the specific information about the group account.

   

isManual

IS_
MANUAL (NUMBER)

 

 

x

 

   

boolean

Indicates whether the group access rights were assigned manually through the Security block of the record or automatically by the system.

0 - Assigned manually
1 - Assigned automatically

   

owner-->

ENTERPRISE_
OBJECT_
ID (NUMBER)

 

 

x

 

 

x

 

JInvcLine
Item

object

8 The invoice line item record with which this group access setting is associated.

--> Links to the specific information about the invoice line item record.

   

primary
Key

PRIMARY_KEY
(NUMBER)

 

 

x

 

   

int

Unique ID for the group access rights.

   

version

VERSION (NUMBER)

 

 

x

 

   

int

Indicates how many times the group access rights have been updated.

   

ELitmUserAccess

ELitmUserAccess controls the privileges that a user has for a specific invoice line item.

Object: ELitmUserAccess (E_LITM_USER_ACCESS)

Attribute

Database column name

Field in user interface

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

               

Rules

Temp/Wiz

isRead

IS_READ (NUMBER)

Read check box

x

   

int

Specifies whether the Read operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

   

isUpdate

IS_UPDATE (NUMBER)

Update check box

x

   

int

Specifies whether the Update operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

   

isDelete

IS_DELETE (NUMBER)

Delete check box

x

   

int

Specifies whether the Delete operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

   

isPerm

IS_PERM (NUMBER)

Perm check box

x

   

int

Specifies whether the Set Permission operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

   

allowDeny
IID

ALLOW_
DENY_IID (NUMBER)

Option

x

   

char

Indicates whether the group is allowed or denied access to the record.

a - Allow
d - Deny

   

isManual

IS_
MANUAL (NUMBER)

 

x

   

boolean

Indicates whether the group access rights were assigned manually through the Security block of the record or automatically by the system.

0 - Assigned manually
1 - Assigned automatically

   

owner-->

ENTERPRISE_
OBJECT_
ID (NUMBER)

 

x

x

JInvcLine
Item

object

8 The invoice line item record with which this group access setting is associated.

--> Links to the specific information about the invoice line item record.

   

primary
Key

PRIMARY_KEY
(NUMBER)

 

x

   

int

Unique ID for the group access rights.

   

user

USER_ID (NUMBER)

List

x

x

YUser

object

8 Specifies the user that the access rights pertain to.

--> Links to the specific information about the user account.

   

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the group access rights have been updated.

   

EInvcUserAccess

EInvcUserAccess contains the user access information that is set in the Security block of each invoice record. For example, it includes whether each user that is listed in the Security block is allowed or denied the Read, Update, Delete, and Perm(ission) rights.

Object: EInvcUserAccess (E_INVC_USER_ACCESS)

Attribute

Database column name

Field in user interface

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

               

Rules

Temp/Wiz

isRead

IS_READ (NUMBER)

Read check box

x

   

int

Specifies whether the Read operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does
not determine whether the operations are allowed or denied. (See allowDenyIID.)

   

isUpdate

IS_
UPDATE (NUMBER)

Update check box

x

   

int

Specifies whether the Update operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does
not determine whether the operations are allowed or denied. (See allowDenyIID.)

   

isDelete

IS_DELETE (NUMBER)

Delete check box

x

   

int

Specifies whether the Delete operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does
not determine whether the operations are allowed or denied. (See allowDenyIID.)

   

isPerm

IS_PERM (NUMBER)

Perm check box

x

   

int

Specifies whether the Set Permission operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does
not determine whether the operations are

   

allowDeny
IID

ALLOW_
DENY_IID(NUMBER)

Option

x

   

char

Indicates whether the user is allowed or denied access to the record.

a - Allow
d - Deny

   

isManual

IS_
MANUAL (NUMBER)

 

x

   

boolean

Indicates whether the user rights were assigned manually through the Security block of the record or automatically by the system.

0 - Assigned manually
1 - Assigned automatically

   

owner-->

ENTERPRISE_
OBJECT_
ID
(NUMBER)

 

x

x

TInvoice

object

8 The invoice record with which this user access setting is associated.

--> Links to the specific information about the invoice record.

   

primary
Key

PRIMARY_KEY
(NUMBER)

 

x

   

int

Unique ID for the user access rights.

   

user-->

USER_ID (NUMBER)

List

x

x

YUser

object

8 Specifies the user the access rights pertain to.

--> Links to the specific information about the user account.

   

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the user access rights have been updated.

   

EInvcGroupAccess

EInvcGroupAccess contains the group access information that is set in the Security block of each invoice record.

For example, it includes whether each group that is listed in the Security block is allowed or denied the Read, Update, Delete, and Perm(ission) rights.

Object: EInvcGroupAccess (E_INVC_GROUP_ACCESS)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

               

Rules

Temp/Wiz

isRead

IS_READ (NUMBER)

Read check box

x

   

int

Specifies whether the Read operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

   

isManual

IS_
MANUAL (NUMBER)

 

x

   

boolean

Indicates whether the group access rights were assigned manually through the Security block of the record or automatically by the system.

0 - Assigned manually
1 - Assigned automatically

   

owner-->

ENTERPRISE_
OBJECT_
ID (NUMBER)

 

x

x

TInvoice

object

8 The invoice record with which this group access setting is associated.

--> Links to the specific information about the invoice record.

   

primary
Key

PRIMARY_KEY
(NUMBER)

 

x

   

int

Unique ID for the group access rights.

   

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the group access rights have been updated.

   

YCurrencyInfo

YCurrencyInfo contains information about currencies defined in the multi-currency lookup table, which are used to display currency in financial fields, including the currency name, symbol, code, and exchange rate.

Object: YCurrencyInfo (Y_CURRENCY_INFO)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

               

Rules

Temp/Wiz

code

CODE
(VARCHAR) (3)

Currency code

x

   

string (3)

The universal 3-digit code of the currency item.

   

createdBy
-->

CREATED_BY_ID
(NUMBER)

 

x

x

YUser

object

8 The user who created the currency item.

--> Links to specific information about the user account.

   

createdOn

CREATED_ON (DATE)

 

x

   

date

The date that the currency item was created.

   

modifiedBy
-->

MODIFIED_BY_ID
(NUMBER)

 

x

x

YUser

object

8 The user who last modified the currency item.

--> Links to specific information about the user account.

   

modifiedOn

MODIFIED_ON (DATE)

Last
Modified On

x

   

date

The date that the currency item was modified.

   

name

NAME
(VARCHAR2) (50)

Name

x

   

string (50)

The name of the currency item.

   

primary
Key

PRIMARY_KEY
(NUMBER)

 

x

   

int

The unique ID of the currency item.

   

rate

RATE
(NUMBER)

Exchange
Rate

x

   

decimal

The exchange rate of the currency item.

   

symbol

SYMBOL
(VARCHAR) (3)

Symbol

x

   

string (3)

The ISO symbol of the currency item.

   

version

VERSION
(NUMBER)

 

x

   

int

Indicates how many times the currency item was updated.

   

JInvcHeaderAdjustment contains information about the adjustment of line items in an invoice record. This information includes the nature of the adjustment calculation, the reason for the adjustment, and comments about the adjustment.

  • Was this article helpful?