EInvcDetail

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.
isDelete	IS_DELETE					boolean
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
isPerm	IS_PERM					boolean
isRead	IS_READ					boolean
isUpdate	IS_UPDATE					boolean
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
isDelete	IS_DELETE					boolean
isPerm	IS_PERM					boolean
isUpdate	IS_UPDATE					boolean
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.
groupID -->	GROUP_ID					number
primary Key	PRIMARY_KEY (NUMBER)		x			int	Unique ID for the group access rights.
allowDenyIID	ALLOW_DENY_IID					char
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.