eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.PAY_AC_VENDOR_MAPPINGS

Object Details

Object Name:	PAY_AC_VENDOR_MAPPINGS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_AC_VENDOR_MAPPINGS
Subobject Name:
Status:	VALID

PAY_AC_VENDOR_MAPPINGS is a table that converts internal Oracle Payroll Values into External Vendor Values during the running of Payroll processes.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
MAPPING_TYPE	VARCHAR2	(30)	Yes	Name of the Mapping Type that is being set.
INTERNAL_VALUE	VARCHAR2	(30)	Yes	Internal Oracle Value that is to be translated
VENDOR_VALUE	VARCHAR2	(30)		The External Value that the Oracle Internal value is to be translated into.
JURISDICTION_CODE	VARCHAR2	(30)		This is the jurisdiction to which the translation relates to.
INTERNAL_TAX_ID	NUMBER	(9)		This is the internal tax Identifier that the translation relates to
INTERNAL_RUN_ID	NUMBER	(9)		This is the internal Run Definition Identifier that the translation relates to.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MAPPING_TYPE
,      INTERNAL_VALUE
,      VENDOR_VALUE
,      JURISDICTION_CODE
,      INTERNAL_TAX_ID
,      INTERNAL_RUN_ID
FROM HR.PAY_AC_VENDOR_MAPPINGS;

Dependencies

[top of page]

HR.PAY_AC_VENDOR_MAPPINGS does not reference any database object

HR.PAY_AC_VENDOR_MAPPINGS is referenced by following:

APPS: PAY_AC_VENDOR_MAPPINGS
PUBLIC: PAY_AC_VENDOR_MAPPINGS