Full expand

Full collapse

SupplierTaxProfile

Jump to

• Fields
• Reference Objects
• Business Views
• Other Properties

Supplier tax profile represents the tax profile defined for a specific supplier. This profile contains the details of a party's transaction tax activities, including tax registration, exemptions, configuration options, main and default information, party fiscal classifications, tax reporting codes, and account details.

Label, Plural Label

Supplier Tax Profile, Supplier Tax Profiles

Qualified Label, Qualified Plural Label

Supplier Address Tax Profile, Supplier Address Tax Profiles

Module

oraProcurementCoreSuppliers

Keys

• $primary: id (default)

• altkey1: partyTypeCode, partyId

• altkey2: partyTypeCode, registrationNumber

Base Business Object

• Module: oraErpCoreTaxSetup

• Business Object: ThirdPartyTaxProfile

Expand all

Collapse all

Fields

* Field can't be null

• allowOffsetTaxFlag (boolean)

  Indicates whether offset taxes are allowed for the party tax profile.

  Label

  Allow Offset Tax

  Properties

  • inherited
• allowWithholdingFlag (boolean)

  Indicates whether withholding tax is allowed for the party tax profile.

  Label

  Allow Withholding

  Properties

  • inherited
• allowZeroAmountWithholdingInvoiceFlag (boolean)

  Indicates whether zero amount withholding invoices can be created.

  Label

  Allow Zero Amount Withholding Invoices

  Properties

  • inherited
• collectingAuthorityFlag (boolean)

  The tax authority responsible for managing the administration of tax remittances.

  Label

  Collecting Authority Indicator

  Properties

  • inherited
• createdBy (string)*

  The user who created the record.

  Label

  Created By

  Properties

  • inherited
  • not nullable
• customerFlag (boolean)

  Indicates whether the tax profile is for a third-party customer.

  Label

  Customer Indicator

  Properties

  • inherited
  • searchable
  • sortable
• firstPartyLegalEntityFlag (boolean)

  Indicates whether the tax profile is for a first-party legal entity.

  Label

  First Party Legal Entity Indicator

  Properties

  • inherited
• id (int64)*

  The unique identifier of the party of the tax profile.

  Label

  Party Tax Profile ID

  Properties

  • inherited
  • searchable
  • sortable
  • not nullable
• inclusiveTaxFlag (boolean)

  Indicates whether the line amount on a transaction document is inclusive of the item or service and the tax.

  Label

  Set Invoice Values as Tax Inclusive

  Properties

  • inherited
• legalEntityTaxSubscriptionStartDate (date)

  The start date when the business unit begins using the tax configuration of the associated legal entity.

  Label

  Use Subscription of the Legal Entity Start Date

  Properties

  • inherited
• legalEntityWithholdingTaxSubscriptionStartDate (date)

  The start date when the business unit begins using the withholding tax configuration of the associated legal entity.

  Label

  Use Subscription of the Legal Entity Start Date

  Properties

  • inherited
• legalEstablishmentFlag (boolean)

  Indicates the tax profile is for a first party legal establishment.

  Label

  Legal Establishment Indicator

  Properties

  • inherited
• partyId (int64)*

  The unique identifier of the party associated with the third-party tax profile.

  Label

  Party ID

  Properties

  • inherited
  • searchable
  • sortable
  • not nullable
• partyTypeCode (string)

  The code that identifies the type of the party of the tax profile.

  Label

  Party Type

  Properties

  • inherited
  • searchable
  • sortable
• processForApplicabilityFlag (boolean)

  Indicates whether taxes should be automatically calculated for the party tax profile.

  Label

  Allow Tax Applicability

  Properties

  • inherited
• providerTypeCode (enumeration: ProviderType)

  Indicates whether the third-party provider offers tax content, tax services, or both.

  Label

  Subscriber Type

  Type

  • Module: oraErpCoreTaxSetup

  • Enumeration Type: ProviderType

  Properties

  • inherited

  Valid Values

  • BOTH
  • CONTENT
  • SERVICES
• registrationNumber (string)

  A unique sequence of letters or numbers or both assigned to a party or party site, by a tax authority, when it's registered and by which the party or party site registration will be identified.

  Label

  Registration Number

  Properties

  • inherited
  • allowAccessWithSkipDataSecurity
• registrationTypeCode (enumeration: RegistrationTypeCode)

  A classification of the tax registration.

  Label

  Registration Type

  Type

  • Module: oraErpCoreTaxSetup

  • Enumeration Type: RegistrationTypeCode

  Properties

  • inherited

  Valid Values

  • CNPJ
  • CPF
  • CUIL
  • CUIT
  • DNI
  • NIT
  • OTHERS
  • VAT
• reportingAuthorityFlag (boolean)

  Indicates whether the tax profile is for a reporting tax authority.

  Label

  Reporting Authority Indicator

  Properties

  • inherited
• roundingLevelCode (enumeration: RoundingLevelCode)

  The value that specifies the rounding to apply to tax amounts on a transaction. The valid values are Line and Header.

  Label

  Rounding Level

  Type

  • Module: oraErpCoreTaxSetup

  • Enumeration Type: RoundingLevelCode

  Properties

  • inherited

  Valid Values

  • HEADER
  • LINE
• roundingRuleCode (enumeration: RoundingRuleCode)

  The rule that defines how the rounding should be performed on a value involved in a taxable transaction. For example, up to the next highest value, down to the next lowest value, or nearest.

  Label

  Rounding Rule

  Type

  • Module: oraErpCoreTaxSetup

  • Enumeration Type: RoundingRuleCode

  Properties

  • inherited

  Valid Values

  • DOWN
  • NEAREST
  • UP
• selfAssessedFlag (boolean)

  Indicates a tax line calculated on a transaction, which doesn't appear on the documents given by the supplier. The self-assessed tax is directly calculated and remitted to the concerned tax authorities by the customer involved in the transaction.

  Label

  Set as Self-Assessment - Reverse Charge

  Properties

  • inherited
• siteFlag (boolean)

  Indicates whether the tax profile is for a third-party site.

  Label

  Site Indicator

  Properties

  • inherited
  • searchable
  • sortable
• supplierFlag (boolean)

  Indicates whether the tax profile is for a third-party supplier.

  Label

  Supplier Indicator

  Properties

  • inherited
  • searchable
  • sortable
• timeCreated (date-time)*

  The date and time when the record was created.

  Label

  Creation Date

  Properties

  • inherited
  • searchable
  • not nullable
• timeUpdated (date-time)*

  The date and time when the record was last updated.

  Label

  Last Updated Date

  Properties

  • inherited
  • searchable
  • not nullable
• transportProviderFlag (boolean)

  Indicates whether the party is a transportation provider, such as a carrier.

  Label

  Transportation Provider Indicator

  Properties

  • inherited
• updatedBy (string)*

  The user who last updated the record.

  Label

  Last Updated By

  Properties

  • inherited
  • not nullable
• useLegalEntityTaxSubscriptionFlag (boolean)

  Indicates whether to use the tax configuration of the associated legal entity. This is an irreversible setting in the business unit party tax profile. Once the business unit is associated with its legal entity, the business unit tax profile can't be updated and the business unit can't maintain separate tax content.

  Label

  Uses Legal Entity Tax Subscription

  Properties

  • inherited
• useLegalEntityWithholdingTaxSubscriptionFlag (boolean)

  Indicates whether to use the withholding tax configuration of the associated legal entity. This is an irreversible setting in the business unit party tax profile. Once the business unit is associated with its legal entity, the business unit tax profile can't be updated and the business unit can't maintain separate tax content.

  Label

  Uses Legal Entity Withholding Tax Subscription

  Properties

  • inherited
• useSystemDefaultsFlag (boolean)

  Indicates whether application default values of tax status, rate, recovery rate, taxable basis formula, or tax calculation formula are used in tax calculation when an incomplete or inconsistent configuration is found.

  Label

  Use System Defaults

  Properties

  • inherited
• withholdingDateBasis (string)

  The date used for withholding tax determination and to generate the tax authority invoice. The date may either be the accounting date or the invoice date.

  Label

  Withholding Tax Determination Basis

  Properties

  • inherited
• withholdingRoundingLevelCode (enumeration: RoundingLevelCode)

  The value that specifies the rounding to apply to tax amounts on a transaction. The valid values are Line and Header.

  Label

  Withholding Rounding Level

  Type

  • Module: oraErpCoreTaxSetup

  • Enumeration Type: RoundingLevelCode

  Properties

  • inherited

  Valid Values

  • HEADER
  • LINE
• withholdingRoundingRuleCode (enumeration: RoundingRuleCode)

  The rule that defines how the rounding should be performed on a value involved in a withholding taxable transaction. For example, up to the next highest value, down to the next lowest value, or nearest.

  Label

  Withholding Rounding Rule

  Type

  • Module: oraErpCoreTaxSetup

  • Enumeration Type: RoundingRuleCode

  Properties

  • inherited

  Valid Values

  • DOWN
  • NEAREST
  • UP
• withholdingStartDate (date)

  The withholding start date for the party tax profile.

  Label

  Withholding Start Date

  Properties

  • inherited

Expand all

Collapse all

Reference Objects

• country (object)

  The country code used to validate the tax registration number for the party tax profile.

  Label

  Country

  Cardinality	Target Object
  One to One	Module: oraCommonAppsInfraObjects Business Object: Territory

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  countryCode	territoryCode

  Properties

  • inherited
• taxClassification (object)

  Tax classification code represents a code used to classify taxes into groups for reporting and processing purposes.

  Label

  Tax Classification Code

  Cardinality	Target Object
  One to One	Module: oraErpCoreTaxSetup Business Object: TaxClassificationCode

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  taxClassificationCode	lookupCode

  Properties

  • inherited
• taxRegistration (object)

  The tax registration is the registration of a party with a tax authority that confers tax rights and imposes certain tax obligations.

  Label

  Tax Registrations

  Cardinality	Target Object
  One to One	Module: oraErpCoreTaxSetup Business Object: TaxRegistration

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  id	taxProfileId

  Properties

  • inherited
• thirdParty (object)

  Third party represents the details of the third party which can be a customer or a supplier, such as the name, identifier, address, and so on.

  Label

  Third Party

  Cardinality	Target Object
  One to One	Module: oraErpCoreTaxSetup Business Object: ThirdParty

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  partyId	id

  Properties

  • inherited

Expand all

Collapse all

Business Views

** Available for extracting data

• default

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • id (int64)

    The unique identifier of the party of the tax profile.

    Label

    Party Tax Profile ID

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
  • partyTypeCode (string)

    The code that identifies the type of the party of the tax profile.

    Label

    Party Type

    Properties

    • inherited
    • searchable
    • sortable

Other Properties

Property	Value
Allow Subtype Creation	Yes
Application Package Name	ora_procurement_core_suppliers
Extensible	No

Back to Top