Transaction Taxes
The transaction taxes view object contains the configuration details for a specific tax.
Data Store Key : FscmTopModelAM.FinExtractAM.ZxBiccExtractAM.TransactionTaxExtractPVO
Primary Keys : TransactionTaxBaseTaxId
Initial Extract Date : TransactionTaxBaseCreationDate
Incremental Extract Date : TransactionTaxBaseLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
TransactionTaxBaseAllowDupRegnNumFlag | Indicates whether duplicate registration numbers are allowed for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseAllowExceptionsFlag | Indicates whether exceptions are allowed for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseAllowExemptionsFlag | Indicates whether exemptions are allowed for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseAllowManualEntryFlag | Indicates whether the user is allowed to manually enter tax lines for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseAllowMassCreateFlag | Indicates whether the automatic creation of tax jurisdictions based on the primary geography type and optionally based on the parent geography identifier or type is allowed for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseAllowRecoverabilityFlag | Indicates whether this tax is recoverable. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseAllowRoundingOverrideFlag | Indicates whether the rounding rule can be overridden at the tax registration level for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseAllowTaxOverrideFlag | Indicates whether the user is allowed to override system-calculated tax lines for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseAllowZeroAmtWhtInvFlag | Indicates whether zero-amount withholding invoices and accounting can be created for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseApplicabilityRuleFlag | Indicates whether tax rules are defined to determine applicability of this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseApplicableByDefaultFlag | Indicates whether this tax is applicable by default. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseAppliedAmtHandlingFlag | The method for handling the tax amount of a prepayment in Payables when it is applied to an invoice. Possible values are PRORATED and RECALCULATED. |
TransactionTaxBaseAttribute1 | A segment for the Transaction Taxes descriptive flexfield. |
TransactionTaxBaseAttribute10 | A segment for the Transaction Taxes descriptive flexfield. |
TransactionTaxBaseAttribute11 | A segment for the Transaction Taxes descriptive flexfield. |
TransactionTaxBaseAttribute12 | A segment for the Transaction Taxes descriptive flexfield. |
TransactionTaxBaseAttribute13 | A segment for the Transaction Taxes descriptive flexfield. |
TransactionTaxBaseAttribute14 | A segment for the Transaction Taxes descriptive flexfield. |
TransactionTaxBaseAttribute15 | A segment for the Transaction Taxes descriptive flexfield. |
TransactionTaxBaseAttribute2 | A segment for the Transaction Taxes descriptive flexfield. |
TransactionTaxBaseAttribute3 | A segment for the Transaction Taxes descriptive flexfield. |
TransactionTaxBaseAttribute4 | A segment for the Transaction Taxes descriptive flexfield. |
TransactionTaxBaseAttribute5 | A segment for the Transaction Taxes descriptive flexfield. |
TransactionTaxBaseAttribute6 | A segment for the Transaction Taxes descriptive flexfield. |
TransactionTaxBaseAttribute7 | A segment for the Transaction Taxes descriptive flexfield. |
TransactionTaxBaseAttribute8 | A segment for the Transaction Taxes descriptive flexfield. |
TransactionTaxBaseAttribute9 | A segment for the Transaction Taxes descriptive flexfield. |
TransactionTaxBaseAttributeCategory | The context name for the Transaction Taxes descriptive flexfield. |
TransactionTaxBaseCalcOnlyFlag | Indicates whether this tax is used only for calculation and is neither reported nor returned to the product. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseChargeLineHandlingCode | The code that identifies whether the tax rules should be processed on charge lines, or tax lines should be copied from corresponding item lines. |
TransactionTaxBaseCollTaxAuthorityId | The unique identifier of the party tax profile for the tax authority to whom this tax is remitted. |
TransactionTaxBaseCompoundingPrecedence | The compounding precedence of the tax. The tax with a lower compounding precedence is computed first. |
TransactionTaxBaseContentOwnerId | The unique identifier of the party tax profile for the configuration owner of this tax. |
TransactionTaxBaseCreatedBy | The user who created the transaction tax row. |
TransactionTaxBaseCreationDate | The date and time when the transaction tax row was created. |
TransactionTaxBaseDefInclusiveTaxFlag | Indicates whether this tax is inclusive by default. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseDefPlaceOfSupplyTypeCode | The default place of supply type for this tax. |
TransactionTaxBaseDefPrimaryRecRateCode | The default primary recovery rate code for this tax. |
TransactionTaxBaseDefRecSettlementOptionCode | Indicates whether an input tax recovery can be done when an invoice is recorded or only when the invoice is paid, and whether an output tax settlement is due when the invoice is issued or only when the payment is received against it. Possible values are ACCOUNTING, DELIVERY, INVOICE and PAYMENT. |
TransactionTaxBaseDefRegistrPartyTypeCode | The default registration party type for this tax. |
TransactionTaxBaseDefSecondaryRecRateCode | The default secondary recovery rate code for this tax. |
TransactionTaxBaseDefTaxCalcFormula | The default formula code used to determine tax amount for this tax. |
TransactionTaxBaseDefTaxableBasisFormula | The default formula code used to determine taxable basis amount for this tax. |
TransactionTaxBaseDirectRateRuleFlag | Indicates whether direct tax rate determination rules can be defined for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseEffectiveFrom | The effective start date for the transaction tax. |
TransactionTaxBaseEffectiveTo | The effective end date for the transaction tax. |
TransactionTaxBaseExchangeRateType | The exchange rate type used for converting transaction currency to tax currency. |
TransactionTaxBaseHasOtherJurisdictionsFlag | Indicates whether this tax has more than one jurisdiction. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseLastUpdateDate | The date and time when the transaction tax row was last updated. |
TransactionTaxBaseLastUpdateLogin | The session login associated with the user who last updated the transaction tax row. |
TransactionTaxBaseLastUpdatedBy | The user who last updated the transaction tax row. |
TransactionTaxBaseLegalReportingStatusDefVal | The default value of the legal reporting status for this tax. |
TransactionTaxBaseLiveForProcessingFlag | Indicates whether this tax is ready to be processed during tax calculation. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseMaxTaxAmtThrshld | The maximum tax amount threshold for this tax. |
TransactionTaxBaseMaxTaxRateThrshld | The maximum tax rate threshold for this tax. |
TransactionTaxBaseMaxTxblBsisThrshld | The maximum taxable basis threshold amount for this tax. |
TransactionTaxBaseMinTaxAmtThrshld | The minimum tax amount threshold for this tax. |
TransactionTaxBaseMinTaxRateThrshld | The minimum tax rate threshold for this tax. |
TransactionTaxBaseMinTxblBsisThrshld | The minimum taxable basis threshold amount for this tax. |
TransactionTaxBaseMinimumAccountableUnit | The minimum accountable unit of the tax currency for this tax. |
TransactionTaxBaseObjectVersionNumber | The number of times the transaction tax row has been updated. |
TransactionTaxBaseOffsetTaxFlag | Indicates whether this tax is used to offset another tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseOverrideGeographyType | The type of geographical area that can override the tax rate specified for a tax jurisdiction of primary geography type. Regions included in the selected geography type are also available for creating tax jurisdictions for this tax. |
TransactionTaxBaseParentGeographyId | The unique identifier of the geographical area that confines all tax jurisdictions created for this tax when the primary geography type refers to a master geography type. |
TransactionTaxBaseParentGeographyType | The type of the geographical area that confines all tax jurisdictions created for this tax when the primary geography type refers to a master geography type. |
TransactionTaxBasePeriodSetName | The accounting calendar name for this tax. |
TransactionTaxBasePlaceOfSupplyRuleFlag | Indicates whether the tax rules are defined for this tax to determine the place of supply type. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBasePrimaryRecRateDetRuleFlag | Indicates whether the tax rules are defined for this tax to determine the primary recovery rate. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBasePrimaryRecTypeRuleFlag | Indicates whether the tax rules are defined for this tax to determine the primary recovery type code. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBasePrimaryRecoveryTypeCode | The primary recovery type code that is applicable for this tax. |
TransactionTaxBasePrintOnInvoiceFlag | Indicates whether this tax will be displayed on the printed document. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseProcessWhtFlag | Indicates whether to allow withholding tax calculation on this transaction tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseRecordTypeCode | The source from which the transaction tax row is created. Possible values are FUSION_WHT_MIGRATED, SEEDED, USER_DEFINED, MIGRATED, and FUSION_RI_UPLOAD. |
TransactionTaxBaseRecoveryRateOverrideFlag | Indicates whether the tax recovery rate can be overridden for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseRegistrationTypeRuleFlag | Indicates whether the tax rules are defined to determine registration party type for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseRegnNumSameAsLeFlag | Indicates whether the tax registration number for this tax should be same as the legal entity registration number. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseRepTaxAuthorityId | The unique identifier of the party tax profile for the tax authority to whom this tax is reported. |
TransactionTaxBaseReportingOnlyFlag | Indicates whether this tax is a reporting only tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseRoundingRuleCode | The rounding rule code to be used for rounding this tax. Possible values are UP, DOWN, and NEAREST. |
TransactionTaxBaseSecRecRateDetRuleFlag | Indicates whether the tax rules are defined to determine the secondary recovery rate for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseSecondaryRecTypeRuleFlag | Indicates whether the tax rules are defined to determine the secondary recovery type code for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseSecondaryRecoveryTypeCode | The secondary recovery type code that is applicable for this tax when more than one recovery type is needed. |
TransactionTaxBaseSelfAssessDiffTax | The self-assessed differential tax for this transaction tax. |
TransactionTaxBaseSourceTaxFlag | Indicates whether this tax can be used as a source tax for creating other taxes. If this is a source tax, then it can't be created based on any other tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseSpecialInclusiveTaxFlag | Indicates whether special inclusive tax handling is applicable for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseTax | The tax code associated with the tax regime. |
TransactionTaxBaseTaxAccountCreateMethodCode | The code that determines whether the user must define GL account defaults specific to this tax, or can use the defaults specified for another tax. |
TransactionTaxBaseTaxAccountSourceTax | The source tax from which the application picks up the default GL accounts for this tax. |
TransactionTaxBaseTaxAmtThrshldFlag | Indicates whether the tax amount threshold is applicable for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseTaxAuthInvCreationPoint | The point at which a withholding tax authority invoice is created. Possible values are INVOICE and PAYMENT. |
TransactionTaxBaseTaxCalcRuleFlag | Indicates whether rules are defined to calculate tax amount for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseTaxCurrencyCode | The tax currency code for this tax. |
TransactionTaxBaseTaxExmptCrMethodCode | The code that determines whether the user must define exemptions specific to this tax, or can also use the exemptions specified for another tax if an exemption specific to this tax is not found. |
TransactionTaxBaseTaxExmptSourceTax | The source tax from which the application picks up the exemption for this tax, if an exemption specific to this tax is not found. |
TransactionTaxBaseTaxId | The unique identifier of the tax. This is a primary key of the Transaction Taxes view object. |
TransactionTaxBaseTaxInclusiveOverrideFlag | Indicates whether the user can override the inclusive or exclusive nature of a tax line determined by the application for this tax. If this is set as YES, user can further override this control at the tax rate level. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseTaxPointBasis | The tax point basis for this tax. |
TransactionTaxBaseTaxPrecision | The tax currency precision for this tax. |
TransactionTaxBaseTaxRateRuleFlag | Indicates whether the tax rules are defined to determine the tax rate for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseTaxRateThrshldFlag | Indicates whether the tax rate threshold is applicable for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseTaxRegimeCode | The tax regime code associated with the tax status for this tax. |
TransactionTaxBaseTaxStatusRuleFlag | Indicates whether the tax rules are defined to determine the tax status for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseTaxTypeCode | The classification of this tax. |
TransactionTaxBaseTaxableAmtMau | The minimum accountable unit for rounding the taxable amount. |
TransactionTaxBaseTaxableBasisRuleFlag | Indicates whether the tax rules are defined to determine taxable basis for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseThrshldChkTmpltCode | The determining factor template to be used for sub-grouping of total thresholds. |
TransactionTaxBaseThrshldGroupingLvlCode | The lookup code to indicate grouping level for applying thresholds across or within documents, lines, or calendar periods. |
TransactionTaxBaseThrshldScheduleGrpLvlFlag | The threshold schedule group level indicator. Possible values are L for Line, D for Document, P for Period, and S for Set. |
TransactionTaxBaseTxblBsisThrshldFlag | Indicates whether the taxable basis threshold is applicable for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseUniquenessValidationLevel | The duplicate validation level for the tax registration number. |
TransactionTaxBaseUseLegalMsgFlag | Indicates whether legal messages are applicable for this tax. A list of accepted values is defined in the lookup type YES_NO. |
TransactionTaxBaseValidationLevel | The validation level for the tax registration number validation to be performed for the selected validation type. Possible values are ERROR, WARNING, and NONE. |
TransactionTaxBaseValidationType | The validation type defined for registration number validation. |
TransactionTaxBaseWhtBucketLevelFlag | Indicates the withholding accumulations level for transactions. Possible values are PARTY and ALL. |
TransactionTaxBaseWhtCalcPointFlag | Indicates the withholding calculation point. Possible values are PAYMENT and INVOICE. |
TransactionTaxBaseWhtDateBasis | The withholding date basis to be adopted for the tax. It can be invoice date or accounting date. |
TransactionTaxBaseZoneGeographyType | The primary geography type for which the tax jurisdictions are created. It refers to either a master or a tax geography type. |
TransactionTaxTLCreatedBy | The user who created the translated transaction tax row. |
TransactionTaxTLCreationDate | The date and time when the translated transaction tax row was created. |
TransactionTaxTLLanguage | The code for the language in which the transaction tax details are translated. |
TransactionTaxTLLastUpdateDate | The date and time when the translated transaction tax row was last updated. |
TransactionTaxTLLastUpdateLogin | The session login associated with the user who last updated the translated transaction tax row. |
TransactionTaxTLLastUpdatedBy | The user who last updated the translated transaction tax row. |
TransactionTaxTLSourceLang | The code for the original language of the translated transaction tax details. |
TransactionTaxTLTaxFullName | The translated transaction tax name. |
TransactionTaxTLTaxId | The unique identifier of the translated transaction tax. |