AP_INV_APRVL_HIST_ALL

AP_INV_APRVL_HIST_ALL contains the approval and rejection history of each invoice that passes through the Invoice Approval Workflow process. The process inserts a record for each approver assigned to review an invoice. This table corresponds to the Invoice Approval History window.

Details

• Schema: FUSION

• Object owner: AP

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
AP_INV_APRVL_HIST_ALL_PK	APPROVAL_HISTORY_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
APPROVAL_HISTORY_ID	NUMBER		18	Yes	Identifier for every record created under approval cycle.
INVOICE_ID	NUMBER		18	Yes	Unique identifier for invoice that is undergoing the approval cycle.
ITERATION	NUMBER		9		Count of times invoice has passed through the Invoice Approval Workflow process
RESPONSE	VARCHAR2	50			Response of the approver on a given invoice.
APPROVER_ID	VARCHAR2	1000			Login user name of approver for given invoice.
AMOUNT_APPROVED	NUMBER				Invoice amount at time of approver response
APPROVER_COMMENTS	VARCHAR2	240			Comments provided by the approver on a given invoice.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
ORG_ID	NUMBER		18	Yes	Indicates the identifier of the business unit associated to the row.
NOTIFICATION_ORDER	NUMBER		9		Order that the notifications were sent to approvers
ORIG_SYSTEM	VARCHAR2	30			Originating system for the approver_id
ITEM_CLASS	VARCHAR2	50			The AME Item Class that required this approval
ITEM_ID	VARCHAR2	50			Unique identifier used by the AME transaction type to identify an item in an Item Class. The AME item Id for the Item Class that required this approval.
LINE_NUMBER	NUMBER		18		Invoice line number
HOLD_ID	NUMBER		18		Identifier used to identify the hold applied on an invoice.
HISTORY_TYPE	VARCHAR2	30			Approval type required on a invoice.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
INTERFACE_INVOICE_ID	NUMBER		18		Invoice unique identifier from the AP_INVOICES_INTERFACE table.
LOAD_REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the Import Payables Invoices process ID created the row.
APPROVAL_REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of Initiate invoice approval job that created or last updated the row.
HISTORY_HASHCODE	VARCHAR2	250			Stores the hash code keys for comments, attachments, or history records. Hash code keys are 20 characters long. The application can store a maximum of 11 hash codes separated by comma. As a result, the length limit for the column is 229 characters, including commas.
RULE_NAME	VARCHAR2	4000			The workflow rule used for assigning the workflow task to the user.
APPROVAL_STEP	VARCHAR2	200			The approval step where the workflow rule is defined.
ACTION_DATE	TIMESTAMP				The date when an assignee performed an action on a particular workflow task.

Foreign Keys

Table	Foreign Table	Foreign Key Column
AP_INV_APRVL_HIST_ALL	ap_invoices_all	INVOICE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
AP_INV_APRVL_HIST_ALL_U1	Unique	Default	APPROVAL_HISTORY_ID
AP_INV_APRVL_HIST_N1	Non Unique	Default	INVOICE_ID
AP_INV_APRVL_HIST_N2	Non Unique	Default	HOLD_ID
AP_INV_APRVL_HIST_N3	Non Unique	Default	UPPER("APPROVER_ID")