Full expand

Full collapse

RequisitionDistribution

Jump to

• Fields
• Reference Objects
• Business Views
• Other Properties

The Requisition Distributions view object stores information about the accounting and project data for each distribution associated with each requisition line.

Label, Plural Label

Requisition Distribution, Requisition Distributions

Qualified Label, Qualified Plural Label

Purchase Requisition Distribution, Purchase Requisition Distributions

Module

oraProcurementCorePurchaseRequisitions

Keys

• $primary: requisitionDistributionId (default)

• altKey: distributionNumber, requisitionLineId

Expand all

Collapse all

Fields

* Field can't be null

• accountUserOverrideFlag (boolean)

  Contains one of the following values: true or false. If true, then the user can override the application determined charge account. If false, then the user can't override the application determined charge account. This attribute doesn't have any default value.

  Label

  Charge Account User Override Flag

• budgetDate (date)

  Date to be used for reserving the distribution.

  Label

  Budget Date

• createdBy (string)*

  The user who created the record.

  Label

  Created By

  Properties

  • not nullable
• distributionAmount (big-decimal)

  Amount on the requisition distribution.

  Label

  Amount

• distributionCurrencyAmount (big-decimal)

  Foreign currency amount on the requisition distribution.

  Label

  Amount

• distributionNumber (int64)*

  Number that uniquely identifies the distribution associated with a purchase requisition line.

  Label

  Distribution

  Properties

  • not nullable
• distributionQuantity (big-decimal)

  Quantity on the distribution.

  Label

  Quantity

• fundsStatus (enumeration: RequisitionFundStatus)

  Status of the funds reservation request.

  Label

  Funds Status

  Type

  • Module: oraProcurementCorePurchaseRequisitions

  • Enumeration Type: RequisitionFundStatus

  Valid Values

  • LIQUIDATED
  • NOT_APPLICABLE
  • NOT_RESERVED
  • NOT_RESERVED_FAILED
  • NOT_RESERVED_PASSED
  • NOT_RESERVED_WARNING
  • PARTIALLY_LIQUIDATED
  • RESERVED
  • RESERVED_PARTIAL
• nonrecoverableCurrencyTaxAmount (big-decimal)

  Foreign currency nonrecoverable tax on the requisition distribution.

  Label

  Nonrecoverable Foreign Currency Tax Amount

• nonrecoverableTaxAmount (big-decimal)

  Nonrecoverable tax on the requisition distribution.

  Label

  Nonrecoverable Tax

• percent (big-decimal)

  Allocation split value percent.

  Label

  Percent

• recoverableCurrencyTaxAmount (big-decimal)

  Foreign currency recoverable tax on the requisition distribution.

  Label

  Recoverable Foreign Currency Tax Amount

• recoverableTaxAmount (big-decimal)

  Recoverable tax on the requisition distribution.

  Label

  Recoverable Tax

• requisitionDistributionId (int64)*

  Value that uniquely identifies the requisition distribution.

  Label

  Requisition Distribution ID

  Properties

  • searchable
  • sortable
  • not nullable
• requisitionLineId (int64)*

  Value that uniquely identifies the requisition line.

  Label

  Requisition Line ID

  Properties

  • searchable
  • not nullable
• timeCreated (date-time)*

  The date and time when the record was created.

  Label

  Creation Date

  Properties

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

  The date and time when the record was last updated.

  Label

  Last Updated Date

  Properties

  • searchable
  • sortable
  • not nullable
• updatedBy (string)*

  The user who last updated the record.

  Label

  Last Updated By

  Properties

  • not nullable

Expand all

Collapse all

Reference Objects

• chargeAccount (object)

  Account that the purchase from a requisition is charged to.

  Label

  Charge Account

  Cardinality	Target Object
  One to One	Module: oraErpCoreStructure Business Object: GeneralLedgerAccount

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  chargeAccountId	codeCombinationId

• primaryLedger (object)

  Value of the primary ledger for the charge account.

  Label

  Primary Ledger

  Cardinality	Target Object
  One to One	Module: oraErpCoreStructure Business Object: Ledger

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  primaryLedgerId	ledgerId

• requisitionLine (object)

  The Requisition Lines view object stores information about requisition lines. It manages the items to be purchased, its quantity, unit of measure, price, and deliver-to location information.

  Label

  Requisition Line

  Cardinality	Target Object
  One to One	Module: oraProcurementCorePurchaseRequisitions Business Object: RequisitionLine

  Additional Mapping Details

  Mapped by relationship: requisitionDistributions

• requisitioningBU (object)

  Business unit of the requisition.

  Label

  Requisitioning BU

  Cardinality	Target Object
  One to One	Module: oraErpCoreStructure Business Object: BusinessUnit

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  requisitioningBUId	id

• varianceAccount (object)

  The variance account for a distribution.

  Label

  Variance Account

  Cardinality	Target Object
  One to One	Module: oraErpCoreStructure Business Object: GeneralLedgerAccount

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  varianceAccountId	codeCombinationId

Expand all

Collapse all

Business Views

** Available for extracting data

• default

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • distributionNumber (int64)

    Number that uniquely identifies the distribution associated with a purchase requisition line.

    Label

    Distribution

    Properties

    • not nullable
  • requisitionDistributionId (int64)

    Value that uniquely identifies the requisition distribution.

    Label

    Requisition Distribution ID

    Properties

    • searchable
    • sortable
    • not nullable
  • requisitionLineId (int64)

    Value that uniquely identifies the requisition line.

    Label

    Requisition Line ID

    Properties

    • searchable
    • not nullable
• requisitionDistributionsExtract**

  Label

  Requisition Distributions

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountUserOverrideFlag (boolean)

    Contains one of the following values: true or false. If true, then the user can override the application determined charge account. If false, then the user can't override the application determined charge account. This attribute doesn't have any default value.

    Label

    Charge Account User Override Flag

  • budgetDate (date)

    Date to be used for reserving the distribution.

    Label

    Budget Date

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • distributionAmount (big-decimal)

    Amount on the requisition distribution.

    Label

    Amount

  • distributionCurrencyAmount (big-decimal)

    Foreign currency amount on the requisition distribution.

    Label

    Amount

  • distributionNumber (int64)

    Number that uniquely identifies the distribution associated with a purchase requisition line.

    Label

    Distribution

    Properties

    • not nullable
  • distributionQuantity (big-decimal)

    Quantity on the distribution.

    Label

    Quantity

  • fundsStatus (enumeration: RequisitionFundStatus)

    Status of the funds reservation request.

    Label

    Funds Status

    Type

    • Module: oraProcurementCorePurchaseRequisitions

    • Enumeration Type: RequisitionFundStatus

    Valid Values

    • LIQUIDATED
    • NOT_APPLICABLE
    • NOT_RESERVED
    • NOT_RESERVED_FAILED
    • NOT_RESERVED_PASSED
    • NOT_RESERVED_WARNING
    • PARTIALLY_LIQUIDATED
    • RESERVED
    • RESERVED_PARTIAL
  • nonrecoverableCurrencyTaxAmount (big-decimal)

    Foreign currency nonrecoverable tax on the requisition distribution.

    Label

    Nonrecoverable Foreign Currency Tax Amount

  • nonrecoverableTaxAmount (big-decimal)

    Nonrecoverable tax on the requisition distribution.

    Label

    Nonrecoverable Tax

  • percent (big-decimal)

    Allocation split value percent.

    Label

    Percent

  • recoverableCurrencyTaxAmount (big-decimal)

    Foreign currency recoverable tax on the requisition distribution.

    Label

    Recoverable Foreign Currency Tax Amount

  • recoverableTaxAmount (big-decimal)

    Recoverable tax on the requisition distribution.

    Label

    Recoverable Tax

  • requisitionDistributionId (int64)

    Value that uniquely identifies the requisition distribution.

    Label

    Requisition Distribution ID

    Properties

    • searchable
    • sortable
    • not nullable
  • requisitionLineId (int64)

    Value that uniquely identifies the requisition line.

    Label

    Requisition Line ID

    Properties

    • searchable
    • not nullable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • sortable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • sortable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • chargeAccount (GeneralLedgerAccount)

    Account that the purchase from a requisition is charged to.

    Business Object

    GeneralLedgerAccount

    Expand all

    Collapse all

    Fields

    • chartOfAccountsId (string)

      The unique identifier of the chart of accounts.

      Label

      Chart of Accounts

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
    • codeCombinationId (int64)

      The unique identifier of the account combination.

      Label

      Account ID

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable

  • primaryLedger (Ledger)

    Value of the primary ledger for the charge account.

    Business Object

    Ledger

    Expand all

    Collapse all

    Fields

    • ledgerId (int64)

      The unique identifier of the ledger for which the accounting entry is created.

      Label

      Ledger ID

      Properties

      • searchable
      • sortable
      • not nullable

  • requisitionLine (RequisitionLine)

    The Requisition Lines view object stores information about requisition lines. It manages the items to be purchased, its quantity, unit of measure, price, and deliver-to location information.

    Business Object

    RequisitionLine

    Expand all

    Collapse all

    Fields

    • requisitionLineId (int64)

      Value that uniquely identifies the requisition line.

      Label

      Requisition Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • requisitioningBU (BusinessUnit)

    Business unit of the requisition.

    Business Object

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • varianceAccount (GeneralLedgerAccount)

    The variance account for a distribution.

    Business Object

    GeneralLedgerAccount

    Expand all

    Collapse all

    Fields

    • chartOfAccountsId (string)

      The unique identifier of the chart of accounts.

      Label

      Chart of Accounts

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
    • codeCombinationId (int64)

      The unique identifier of the account combination.

      Label

      Account ID

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable

Other Properties

Property	Value
Application Package Name	ora_procurement_core_purchaseRequisitions
Extensible	Yes

Back to Top