JG_TPD_ADJUSTMENTS_INT

This interface table contains imported data related to headers and lines of Payables and Receivables transactions and is used to override only the tax point date.

Details

• Schema: FUSION

• Object owner: JG

• Object type: TABLE

• Tablespace: INTERFACE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
LEGAL_ENTITY_ID	NUMBER		18	Yes	Unique identifier of the legal entity.
APPLICATION_ID	NUMBER		18	Yes	Functional area identifier for Payables or Receivables.
ORGANIZATION_ID	NUMBER		18	Yes	Unique identifier of the business unit.
TRANSACTION_ID	NUMBER		18	Yes	Payables or Receivables transaction identifier.
TRANSACTION_LINE_ID	NUMBER		18	Yes	Payables or Receivables transaction line identifier.
TRANSACTION_NUMBER	VARCHAR2	50			Payables invoice number or Receivables transaction number.
TRANSACTION_LINE_NUMBER	NUMBER		18		Payables invoice line number or Receivables transaction line number.
INV_HEADER_ADJUSTMENT_DATE	DATE				New date to override the Payables or Receivables tax point date at header level.
INV_LINE_ADJUSTMENT_DATE	DATE				New date to override the Payables or Receivables tax point date at line level.
LOAD_REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: Indicates the request identifier of the interface load job that created the row.
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP				Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64			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.

Indexes

Index	Uniqueness	Tablespace	Columns
JG_TPD_ADJUSTMENTS_INT_U1	Unique	Default	LEGAL_ENTITY_ID, APPLICATION_ID, ORGANIZATION_ID, TRANSACTION_ID, TRANSACTION_LINE_ID