ZX_PRVDR_HDR_EXTNS_GT

This table stores Provider Header information

Details

• Schema: FUSION

• Object owner: ZX

• Object type: TABLE

Primary Key

Name	Columns
ZX_PRVDR_HDR_EXTNS_GT_PK	EVENT_CLASS_CODE, APPLICATION_ID, ENTITY_CODE, TRX_ID, PROVIDER_ID, TAX_REGIME_CODE

Columns

Name

EVENT_CLASS_CODEVARCHAR230YesApplication event class of the transaction APPLICATION_IDNUMBERYesApplication Identifier of the transaction ENTITY_CODEVARCHAR230YesEntity code of the application event class for the transaction TRX_IDNUMBERYesPrimary transaction identifier PROVIDER_IDNUMBER18YesIdentifier of the third party service provider that has determined the tax on this summary line. Null if there is no third party service provider integration for the tax. TAX_REGIME_CODEVARCHAR230YesTax regime code HEADER_EXT_VARCHAR_ATTRIBUTE1VARCHAR2150Header level user extensible attribute1 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE2VARCHAR2150Header Level user extensible attribute2 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE3VARCHAR2150Header Level user extensible attribute3 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE4VARCHAR2150Header Level user extensible attribute4 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE5VARCHAR2150Header Level user extensible attribute5 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE6VARCHAR2150Header Level user extensible attribute6 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE7VARCHAR2150Header Level user extensible attribute7 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE8VARCHAR2150Header Level user extensible attribute8 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE9VARCHAR2150Header Level user extensible attribute9 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE10VARCHAR2150Header Level user extensible attribute10 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE11VARCHAR2150Header Level user extensible attribute11 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE12VARCHAR2150Header Level user extensible attribute12 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE13VARCHAR2150Header Level user extensible attribute13 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE14VARCHAR2150Header Level user extensible attribute14 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE15VARCHAR2150Header Level user extensible attribute15 of type character used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE1NUMBERHeader Level user extensible attribute1 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE2NUMBERHeader Level user extensible attribute2 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE3NUMBERHeader Level user extensible attribute3 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE4NUMBERHeader Level user extensible attribute4 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE5NUMBERHeader Level user extensible attribute5 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE6NUMBERHeader Level user extensible attribute6 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE7NUMBERHeader Level user extensible attribute7 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE8NUMBERHeader Level user extensible attribute8 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE9NUMBERHeader Level user extensible attribute9 of type number used by third party service provider HEADER_EXT_NUMBER_ATTRIBUTE10NUMBERHeader Level user extensible attribute10 of type number used by third party service provider HEADER_EXT_DATE_ATTRIBUTE1DATEHeader Level user extensible attribute1 of type date used by third party service provider HEADER_EXT_DATE_ATTRIBUTE2DATEHeader Level user extensible attribute2 of type date used by third party service provider HEADER_EXT_DATE_ATTRIBUTE3DATEHeader Level user extensible attribute3 of type date used by third party service provider HEADER_EXT_DATE_ATTRIBUTE4DATEHeader Level user extensible attribute4 of type date used by third party service provider HEADER_EXT_DATE_ATTRIBUTE5DATEHeader Level user extensible attribute5 of type date used by third party service provider CREATION_DATETIMESTAMPYesWho column: indicates the date and time of the creation of the row. CREATED_BYVARCHAR264YesWho column: indicates the user who created the row. LAST_UPDATE_DATETIMESTAMPYesWho column: indicates the date and time of the last update of the row. LAST_UPDATED_BYVARCHAR264YesWho column: indicates the user who last updated the row. LAST_UPDATE_LOGINVARCHAR232Who column: indicates the session login associated to the user who last updated the row. HEADER_EXT_VARCHAR_ATTRIBUTE16VARCHAR2150Header Level user extensible attribute16 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE17VARCHAR2150Header Level user extensible attribute17 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE18VARCHAR2150Header Level user extensible attribute18 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE19VARCHAR2150Header Level user extensible attribute19 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE20VARCHAR2150Header Level user extensible attribute20 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE21VARCHAR2150Header level user extensible attribute21 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE22VARCHAR2150Header Level user extensible attribute22 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE23VARCHAR2150Header Level user extensible attribute23 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE24VARCHAR2150Header Level user extensible attribute24 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE25VARCHAR2150Header Level user extensible attribute25 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE26VARCHAR2150Header Level user extensible attribute26 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE27VARCHAR2150Header Level user extensible attribute27 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE28VARCHAR2150Header Level user extensible attribute28 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE29VARCHAR2150Header Level user extensible attribute29 of type character used by third party service provider HEADER_EXT_VARCHAR_ATTRIBUTE30VARCHAR2150Header Level user extensible attribute30 of type character used by third party service provider

Indexes

Index	Uniqueness	Columns
ZX_PRVDR_HDR_EXTNS_GT_U1	Unique	EVENT_CLASS_CODE, APPLICATION_ID, ENTITY_CODE, TRX_ID, PROVIDER_ID, TAX_REGIME_CODE