ZX_PRVDR_LINE_EXTNS

Details

Schema: FUSION
Object owner: ZX
Object type: TABLE

Primary Key

Name	Columns
ZX_PRVDR_LINE_EXTNS_GT_PK	APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE, 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 TRX_LINE_IDNUMBERYesTransaction line 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 LINE_EXT_VARCHAR_ATTRIBUTE1VARCHAR2150Line Level user extensible attribute1 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE2VARCHAR2150Line Level user extensible attribute2 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE3VARCHAR2150Line Level user extensible attribute3 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE4VARCHAR2150Line Level user extensible attribute4 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE5VARCHAR2150Line Level user extensible attribute5 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE6VARCHAR2150Line Level user extensible attribute6 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE7VARCHAR2150Line Level user extensible attribute7 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE8VARCHAR2150Line Level user extensible attribute8 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE9VARCHAR2150Line Level user extensible attribute9 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE10VARCHAR2150Line Level user extensible attribute10 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE11VARCHAR2150Line Level user extensible attribute11 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE12VARCHAR2150Line Level user extensible attribute12 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE13VARCHAR2150Line Level user extensible attribute13 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE14VARCHAR2150Line Level user extensible attribute14 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE15VARCHAR2150Line Level user extensible attribute15 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE16VARCHAR2150Line Level user extensible attribute16 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE17VARCHAR2150Line Level user extensible attribute17 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE18VARCHAR2150Line Level user extensible attribute18 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE19VARCHAR2150Line Level user extensible attribute19 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE20VARCHAR2150Line Level user extensible attribute20 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE21VARCHAR2150Line Level user extensible attribute21 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE22VARCHAR2150Line Level user extensible attribute22 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE23VARCHAR2150Line Level user extensible attribute23 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE24VARCHAR2150Line Level user extensible attribute24 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE25VARCHAR2150Line Level user extensible attribute25 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE26VARCHAR2150Line Level user extensible attribute26 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE27VARCHAR2150Line Level user extensible attribute27 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE28VARCHAR2150Line Level user extensible attribute28 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE29VARCHAR2150Line Level user extensible attribute29 of type character used by third party service provider LINE_EXT_VARCHAR_ATTRIBUTE30VARCHAR2150Line Level user extensible attribute30 of type character used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE1NUMBERLine Level user extensible attribute1 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE2NUMBERLine Level user extensible attribute2 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE3NUMBERLine Level user extensible attribute3 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE4NUMBERLine Level user extensible attribute4 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE5NUMBERLine Level user extensible attribute5 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE6NUMBERLine Level user extensible attribute6 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE7NUMBERLine Level user extensible attribute7 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE8NUMBERLine Level user extensible attribute8 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE9NUMBERLine Level user extensible attribute9 of type number used by third party service provider LINE_EXT_NUMBER_ATTRIBUTE10NUMBERLine Level user extensible attribute10 of type number used by third party service provider LINE_EXT_DATE_ATTRIBUTE1DATELine Level user extensible attribute1 of type date used by third party service provider LINE_EXT_DATE_ATTRIBUTE2DATELine Level user extensible attribute2 of type date used by third party service provider LINE_EXT_DATE_ATTRIBUTE3DATELine Level user extensible attribute3 of type date used by third party service provider LINE_EXT_DATE_ATTRIBUTE4DATELine Level user extensible attribute4 of type date used by third party service provider LINE_EXT_DATE_ATTRIBUTE5DATELine 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. TRX_LEVEL_TYPEVARCHAR230YesColumn to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.

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

TRX_LINE_IDNUMBERYesTransaction line 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

LINE_EXT_VARCHAR_ATTRIBUTE1VARCHAR2150Line Level user extensible attribute1 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE2VARCHAR2150Line Level user extensible attribute2 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE3VARCHAR2150Line Level user extensible attribute3 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE4VARCHAR2150Line Level user extensible attribute4 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE5VARCHAR2150Line Level user extensible attribute5 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE6VARCHAR2150Line Level user extensible attribute6 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE7VARCHAR2150Line Level user extensible attribute7 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE8VARCHAR2150Line Level user extensible attribute8 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE9VARCHAR2150Line Level user extensible attribute9 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE10VARCHAR2150Line Level user extensible attribute10 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE11VARCHAR2150Line Level user extensible attribute11 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE12VARCHAR2150Line Level user extensible attribute12 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE13VARCHAR2150Line Level user extensible attribute13 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE14VARCHAR2150Line Level user extensible attribute14 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE15VARCHAR2150Line Level user extensible attribute15 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE16VARCHAR2150Line Level user extensible attribute16 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE17VARCHAR2150Line Level user extensible attribute17 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE18VARCHAR2150Line Level user extensible attribute18 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE19VARCHAR2150Line Level user extensible attribute19 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE20VARCHAR2150Line Level user extensible attribute20 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE21VARCHAR2150Line Level user extensible attribute21 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE22VARCHAR2150Line Level user extensible attribute22 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE23VARCHAR2150Line Level user extensible attribute23 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE24VARCHAR2150Line Level user extensible attribute24 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE25VARCHAR2150Line Level user extensible attribute25 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE26VARCHAR2150Line Level user extensible attribute26 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE27VARCHAR2150Line Level user extensible attribute27 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE28VARCHAR2150Line Level user extensible attribute28 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE29VARCHAR2150Line Level user extensible attribute29 of type character used by third party service provider

LINE_EXT_VARCHAR_ATTRIBUTE30VARCHAR2150Line Level user extensible attribute30 of type character used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE1NUMBERLine Level user extensible attribute1 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE2NUMBERLine Level user extensible attribute2 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE3NUMBERLine Level user extensible attribute3 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE4NUMBERLine Level user extensible attribute4 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE5NUMBERLine Level user extensible attribute5 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE6NUMBERLine Level user extensible attribute6 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE7NUMBERLine Level user extensible attribute7 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE8NUMBERLine Level user extensible attribute8 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE9NUMBERLine Level user extensible attribute9 of type number used by third party service provider

LINE_EXT_NUMBER_ATTRIBUTE10NUMBERLine Level user extensible attribute10 of type number used by third party service provider

LINE_EXT_DATE_ATTRIBUTE1DATELine Level user extensible attribute1 of type date used by third party service provider

LINE_EXT_DATE_ATTRIBUTE2DATELine Level user extensible attribute2 of type date used by third party service provider

LINE_EXT_DATE_ATTRIBUTE3DATELine Level user extensible attribute3 of type date used by third party service provider

LINE_EXT_DATE_ATTRIBUTE4DATELine Level user extensible attribute4 of type date used by third party service provider

LINE_EXT_DATE_ATTRIBUTE5DATELine 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.

TRX_LEVEL_TYPEVARCHAR230YesColumn to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.

Indexes

Index	Uniqueness	Columns
ZX_PRVDR_LINE_EXTNS_GT_U1	Unique	APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE, PROVIDER_ID, TAX_REGIME_CODE