Full expand

Full collapse

SupplierSite

Jump to

• Fields
• Reference Objects
• Business Views
• Other Properties

A supplier site contains the details about the terms, controls, and policies that govern how procure to pay transactions are executed between the buying organization and the supplier. You can have multiple sites for a supplier. For example, a purchasing site or a pay site.

Label, Plural Label

Site, Sites

Qualified Label, Qualified Plural Label

Supplier Site, Supplier Sites

Module

oraProcurementCoreSuppliers

Keys

• $primary: id

Expand all

Collapse all

Fields

* Field can't be null

• agingOnsetPoint (enumeration: AgingOnsetPoint)

  Point where the supplier and the buying organization agree to begin to age consigned material.

  Label

  Aging Onset Point

  Type

  • Module: oraProcurementCorePurchasingSetup

  • Enumeration Type: AgingOnsetPoint

  Valid Values

  • NONE
  • RECEIPT
  • SHIPMENT
• agingPeriodDays (int64)

  Maximum number of days that material can remain on consignment.

  Label

  Aging Period Days

• allowSubstituteReceiptsFlag (boolean)

  Indicates whether the supplier site allows a substitute receipt. Values include Y for Yes or N for No.

  Label

  Allow Substitute Receipts

• allowUnorderedReceiptsFlag (boolean)

  Contains one of the following values: true or false. If true, then the supplier site can receive a receipt that doesn't include a purchase order. If false, then the supplier site requires a purchase order. The default value is false.

  Label

  Allow unordered receipts

• alternateName (string)*

  Alternate name of the supplier site.

  Label

  Alternate Site Name

  Properties

  • searchable
  • sortable
  • not nullable
• alwaysTakeDiscount (enumeration: PayablesOption)

  Determines whether to apply a discount on the payment. Contains one of the following values: Y, apply discount. N, don't apply discount. D, use the default from the payables options to determine whether to apply the discount.

  Label

  Always Take Discount

  Type

  • Module: oraProcurementCoreSuppliers

  • Enumeration Type: PayablesOption

  Valid Values

  • D
  • N
  • Y
• autoCalculateInterest (enumeration: PayablesOption)

  Determines whether to exclude tax when calculating the discount. Contains one of the following values: Y, exclude tax. N, include tax. D, use the default from the payables options to determine whether to exclude tax.

  Label

  Exclude Tax from Discount

  Type

  • Module: oraProcurementCoreSuppliers

  • Enumeration Type: PayablesOption

  Valid Values

  • D
  • N
  • Y
• bankChargeBearer (string)

  Indicate whether the deploying company or your supplier pays the bank charges for electronic payments. The lookup codes and their respective descriptions are as follows: BEN Payee pays all costs. OUR:Payer pays all costs. SHA Payer pays the domestic cost and payee pays the foreign cost. PAYEE_PAYS_EXPRESS Payee pays express charges.

  Label

  Bank Charge Bearer

• businessToBusinessCommunicationMethodCode (enumeration: B2BCommunicationMethod)

  Abbreviation that identifies the communication method the application uses for documents during a business to business procurement transaction. Use the ORA_POZ_B2B_COMM_METHOD lookup on the Manage Standard Lookups page in the Setup and Maintenance work area to manage the values you can use with this attribute.

  Label

  B2B Communication Method

  Type

  • Module: oraProcurementCoreSuppliers

  • Enumeration Type: B2BCommunicationMethod

  Valid Values

  • B2B
  • CMK
  • NONE
• businessToBusinessSiteCode (string)

  Abbreviation that identifies the supplier site during a business- to-business document communication.

  Label

  B2B Supplier Site Code

• buyerManagedTransportFlag (boolean)

  Indicates whether the buyer manages transportation. Values include Y for Yes, N for No, or empty.

  Label

  Buyer Managed Transportation

• consumptionAdviceFrequency (enumeration: ConsumptionAdviceFrequency)

  How frequently the Create Consumption Advice application runs for consumption transactions. This application runs for consigned inventory that the customer purchased under one agreement.

  Label

  Consumption Advice Frequency

  Type

  • Module: oraProcurementCorePurchasingSetup

  • Enumeration Type: ConsumptionAdviceFrequency

  Properties

  • not readable

  Valid Values

  • DAILY
  • MONTHLY
  • WEEKLY
• consumptionAdviceSummary (enumeration: ConsumptionAdviceSummary)

  Level of detail to use when creating the consumption advice.

  Label

  Consumption Advice Summary

  Type

  • Module: oraProcurementCorePurchasingSetup

  • Enumeration Type: ConsumptionAdviceSummary

  Properties

  • not readable

  Valid Values

  • ALL_INVENTORY_ORGS
  • INVENTORY_ORG
  • INVENTORY_ORG_ITEM
  • INVENTORY_ORG_ITEM_TXNDATE
• createDebitMemoFlag (boolean)

  Contains one of the following values: true or false. If true, then the supplier site creates a debit memo from the return transaction. If false, then the supplier site doesn't create this memo. The default value is false.

  Label

  Create debit memo from return

• createdBy (string)*

  The user who created the record.

  Label

  Created By

  Properties

  • not nullable
• customerNumber (string)

  Number that identifies the site of the buying organization.

  Label

  Customer Number

• daysEarlyReceiptAllowed (int64)

  Number of days that the receiving location can receive receipts before the expected receipt date.

  Label

  Early Receipt Tolerance in Days

• daysLateReceiptAllowed (int64)

  Number of days that the receiving location can receive receipts after the expected receipt date.

  Label

  Late Receipt Tolerance in Days

• emailAddress (email)

  Email that the communication method uses.

  Label

  Email

• enforceShipToLocationCode (enumeration: ReceivingOption)

  Abbreviation that identifies the action to take when the receiving location is different from the ship-to location. Use the RCV_RECEIVING_OPTION lookup on the Manage Standard Lookups page in the Setup and Maintenance work area to manage the values you can use with this attribute.

  Label

  Ship-to Exception Action

  Type

  • Module: oraScmCoreReceivingTransaction

  • Enumeration Type: ReceivingOption

  Properties

  • not readable

  Valid Values

  • NONE
  • REJECT
  • WARNING
• excludeFreightFromDiscount (enumeration: PayablesOption)

  Determines whether to exclude freight when calculating discount. Contains one of the following values: Y, exclude freight. N, include freight. D, use the default from the payables options to determine whether to exclude freight.

  Label

  Exclude Freight from Discount

  Type

  • Module: oraProcurementCoreSuppliers

  • Enumeration Type: PayablesOption

  Valid Values

  • D
  • N
  • Y
• excludeTaxFromDiscount (enumeration: PayablesOption)

  Determines whether to exclude tax when calculating the discount. Contains one of the following values: Y, exclude tax. N, include tax. D, use the default from the payables options to determine whether to exclude tax.

  Label

  Exclude Tax from Discount

  Type

  • Module: oraProcurementCoreSuppliers

  • Enumeration Type: PayablesOption

  Valid Values

  • D
  • N
  • Y
• fax (string)

  Fax that the communication method uses.

  Label

  Fax

• faxAreaCode (string)

  Area Code for the fax that the communication method uses.

  Label

  Fax Area Code

• faxCountryCode (string)
• gaplessInvoiceNumberingFlag (boolean)

  Value that uniquely identifies the selling company. This attribute is required when the supplier site uses gapless invoice numbering.

  Label

  Gapless invoice numbering

• holdAllInvoicesFlag (boolean)

  Contains one of the following values: true or false. If true, then the supplier site puts a hold on all invoices. If false, then the site does put them on hold. The default value is false.

  Label

  Hold All Invoices

• holdUnmatchedInvoices (enumeration: PayablesOption)

  Determines whether to place a hold on each invoice that doesn't contain a relationship with a purchase order, receipt, or consumption advice. Values include Y for Yes, N for No, or empty.

  Label

  Hold Unmatched Invoices

  Type

  • Module: oraProcurementCoreSuppliers

  • Enumeration Type: PayablesOption

  Valid Values

  • D
  • N
  • Y
• holdUnvalidatedInvoicesFlag (boolean)

  Indicates whether Oracle Payables should place unapproved invoices for this supplier on hold.

  Label

  Hold Unvalidated Invoices

• id (int64)*

  Value that uniquely identifies the supplier site.

  Label

  Supplier Site ID

  Properties

  • searchable
  • sortable
  • not nullable
• inactiveDate (date)

  Date when the supplier site is no longer active.

  Label

  Inactive Date

• inspectionRequiredFlag (boolean)

  Value indicates whether inspection is required.

  Label

  Inspection Required

• invoiceAmountLimit (int64)

  Indicates the maximum amount for which an invoice can be created beyond which an invoice will go on hold.

  Label

  Invoice Amount Limit

• matchOption (enumeration: InvoiceMatch)

  Indicates whether to create a relationship between the invoice and a purchase order, receipt, or consumption advice.

  Label

  Invoice Match Option

  Type

  • Module: oraProcurementCorePurchasingCommon

  • Enumeration Type: InvoiceMatch

  Properties

  • searchable
  • sortable
  • not readable

  Valid Values

  • FOUR
  • THREE
  • TWO
• modeOfTransport (string)

  Mode of transport that the supplier site uses for shipping.

  Label

  Mode of Transport

• name (string)*

  Name of the supplier site.

  Label

  Site

  Properties

  • searchable
  • sortable
  • not nullable
• payDateBasisCode (enumeration: PayDateBasis)

  Abbreviation that identifies the date the application scheduled to run payment for the invoice. A list of accepted values is defined in the lookup type POZ_PAY_DATE_BASIS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Payables Lookups task.

  Label

  Pay Date Basis

  Type

  • Module: oraProcurementCoreSuppliers

  • Enumeration Type: PayDateBasis

  Valid Values

  • DISCOUNT
  • DUE
• payGroupCode (string)

  Abbreviation that identifies the withholding tax group for the site assignment. A list of accepted values is defined in the lookup type PAY_GROUP. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Payables Lookups task.

  Label

  Pay Group

• payOnCode (string)

  Indicates when to create an invoice.

  Label

  Pay on receipt

• payOnReceiptSummaryCode (enumeration: InvoiceSummary)

  Contains one of the following values: true or false. If true, then the supplier site allows pay on receipt. If false, then the supplier site doesn't allow pay on receipt. The default value is false.

  Label

  Pay on receipt

  Type

  • Module: oraProcurementCoreSuppliers

  • Enumeration Type: InvoiceSummary

  Properties

  • not readable

  Valid Values

  • PACKING_SLIP
  • PAY_SITE
  • RECEIPT
• payOnUseFlag (boolean)

  Contains one of the following values: true or false. If true, then the supplier site allows pay on use. If false, then the supplier site doesn't allow pay on use. The default value is false.

  Label

  Pay on use

• payPurposeFlag (boolean)

  Contains one of the following values: true or false. If true, then a pay purpose exists for the supplier site. If false, then pay purpose doesn't exist. The default value is false.

  Label

  Pay

• paymentHoldDate (date)

  Date when the application places payments to the supplier site on hold.

  Label

  Payment Hold Date

• paymentHoldReason (string)

  Reason why the application placed the invoices that it created for the supplier site on hold.

  Label

  Payment Hold Reason

• paymentPriority (int64)

  Priority to assign to an invoice during payment.

  Label

  Payment Priority

• phone (string)

  Phone that the communication method uses.

  Label

  Phone

• phoneCountryCode (string)

  Abbreviation that identifies the country for the phone that the communication method uses.

  Label

  Phone Country Code

• phoneExtension (string)

  Extension for the phone that the communication method uses.

  Label

  Phone Extension

• poRequiredAcknowledgmentCode (enumeration: AcceptanceRequiredLevel)

  Abbreviation that identifies the acknowledgment. Applies when the purchasing document that the application created for the supplier site requires an acknowledgment. A list of accepted values is defined in the lookup type ACCEPTANCE_REQUIRED. You can't modify this lookup.

  Label

  Required Acknowledgment

  Type

  • Module: oraProcurementCorePurchasingCommon

  • Enumeration Type: AcceptanceRequiredLevel

  Properties

  • not readable

  Valid Values

  • D
  • L
  • N
  • Y
• poRequiredAcknowledgmentDays (int64)

  Number of days that the supplier site can use to acknowledge the purchasing document.

  Label

  Acknowledge Within Days

• primaryPayPurposeFlag (boolean)

  Contains one of the following values: true or false. If true, then primary pay purpose exists for the supplier site. If false, then primary pay purpose doesn't exist. The default value is false.

  Label

  Primary pay

• procurementCardPurposeFlag (boolean)

  Contains one of the following values: true or false. If true, then a procurement card exists for the supplier site. If false, then procurement card doesn't exist. The default value is false.

  Label

  Procurement card

• purchasingHoldFlag (boolean)

  Contains one of the following values: true or false. If true, then place all new purchasing documents on hold. If false, then don't place them on hold. The default value is false.

  Label

  Hold all new purchasing documents

• purchasingHoldReason (string)

  Reason why the person who placed the hold on purchasing for the supplier site.

  Label

  Hold Reason

• purchasingPurposeFlag (boolean)

  Contains one of the following values: true or false. If true, then a purchasing purpose exists for the supplier site. If false, then purpose doesn't exist. The default value is false.

  Label

  Purchasing

• receiptDaysExceptionCode (enumeration: ReceivingOption)

  Abbreviation that identifies the action to taken when the supplier site receives an item before Early Receipt Tolerance in Days or after Late Receipt Tolerance in Days. A list of accepted values is defined in the lookup type RCV_RECEIVING_OPTION. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.

  Label

  Receipt Date Exception

  Type

  • Module: oraScmCoreReceivingTransaction

  • Enumeration Type: ReceivingOption

  Properties

  • not readable

  Valid Values

  • NONE
  • REJECT
  • WARNING
• receiptRequiredFlag (boolean)

  Indicates whether supplier site requires a receipt.

  Label

  Receipt Required

• sellingCompanyIdentifier (string)

  Value that uniquely identifies the selling company. This attribute is required when the supplier site uses gapless invoice numbering.

  Label

  Selling Company Identifier

• serviceLevel (enumeration: ServiceLevelCode)

  Service level that the supplier site uses for shipping.

  Label

  Service Level

  Type

  • Module: oraScmCoreCarrier

  • Enumeration Type: ServiceLevelCode

  Valid Values

  • 1DA
  • 1DM
  • 1DP
  • 2DA
  • 2DAY
  • 2DM
  • 2FX
  • 3DAY
  • 3DS
  • AIR

  For a complete list of valid values, see the ServiceLevelCode enumeration type.

• sourcingOnlyPurposeFlag (boolean)

  Contains one of the following values: true or false. If true, then the supplier has sourcing only purpose. If false, then the supplier site doesn't have sourcing only purpose. The default value is false.

  Label

  Sourcing only

• status (enumeration: Status)

  Status of the supplier site.

  Label

  Status

  Type

  • Module: oraProcurementCoreSuppliers

  • Enumeration Type: Status

  Valid Values

  • ACTIVE
  • ALL
  • INACTIVE
• supplierNotificationMethod (enumeration: DocumentCommunicationMethod)

  Preferred method of communication for the supplier site. Values include NONE, FAX, EMAIL, or PRINT.

  Label

  Communication Method

  Type

  • Module: oraProcurementCorePurchasingCommon

  • Enumeration Type: DocumentCommunicationMethod

  Properties

  • not readable

  Valid Values

  • EMAIL
  • FAX
  • NONE
  • PRINT
• taxReportingSiteFlag (boolean)

  Contains one of the following values: true or false. If true, then the supplier site is a tax reporting site. If false, then supplier site isn't a tax reporting site. The default value is false.

  Label

  Income tax reporting site

• timeCreated (date-time)*

  The date and time when the record was created.

  Label

  Creation Date

  Properties

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

  The date and time when the record was last updated.

  Label

  Last Updated Date

  Properties

  • searchable
  • not nullable
• updatedBy (string)*

  The user who last updated the record.

  Label

  Last Updated By

  Properties

  • not nullable
• vendorSitePrimaryIdentifier (int64)*

  Value that uniquely identifies the supplier site.

  Label

  Supplier Site ID

  Properties

  • not nullable

Expand all

Collapse all

Reference Objects

• address (object)

  A supplier is a person or company that the deploying organization uses to procure items or services. For example, an office supplies provider or a consulting service provider.

  Label

  Address

  Cardinality	Target Object
  One to One	Module: oraProcurementCoreSuppliers Business Object: Address

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  partySiteId	id

• bankChargeDeductionType (object)

  Determines how to deduct bank charges when paying the invoice. Contains one of the following values: S, use the standard deduction. D, use the default value from payables options. N, use the negotiated deduction. X, don't use any deduction.

  Label

  Bank Charge Deduction Type

  Cardinality	Target Object
  One to One	Module: oraErpCoreCommonObjects Business Object: ERPLookupCode

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  bankChargeDeductionTypeCode	lookupCode

• businessUnit (object)

  Procurement business unit where the supplier site resides.

  Label

  Procurement BU

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

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  businessUnitId	id

• carrier (object)

  A carrier represents a business organization that fulfills the shipment of products. Each carrier may model a variety of shipping methods, optional contacts, and inbound tracking rules. For example, FedEx Corporation, or DHL Express.

  Label

  Carrier

  Cardinality	Target Object
  One to One	Module: oraScmCoreCarrier Business Object: Carrier

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  carrierId	carrierId

• fob (object)

  Abbreviation that identifies the Free On Board value for the supplier site. Use the FOB lookup on the Manage FOB Lookup page in the Setup and Maintenance work area to manage the values you can use with this attribute.

  Label

  FOB

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

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  fobCode	lookupCode

• freightTerm (object)

  Agreement that describes terms for shipping from the supplier site. Use the FREIGHT TERMS lookup on the Manage Freight Terms Lookup page in the Setup and Maintenance work area to manage the values you can use with this attribute.

  Label

  Freight Terms

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

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  freightTermCode	lookupCode

• invoiceChannel (object)

  Channel that the supplier uses to provide invoices for the supplier site.

  Label

  Invoice Channel

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

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  invoiceChannelCode	lookupCode

• invoiceCurrency (object)

  Abbreviation that identifies the currency that the invoice uses.

  Label

  Invoice Currency

  Cardinality	Target Object
  One to One	Module: oraErpCoreCurrencySetup Business Object: Currency

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  invoiceCurrencyCode	currencyCode

• parentSupplierSite (object)

  A supplier site contains the details about the terms, controls, and policies that govern how procure to pay transactions are executed between the buying organization and the supplier. You can have multiple sites for a supplier. For example, a purchasing site or a pay site.

  Label

  Site

  Cardinality	Target Object
  One to One	Module: oraProcurementCoreSuppliers Business Object: SupplierSite

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  defaultPaySiteId	id

• payablesAmountToleranceOption (object)

  The invoice tolerance option represents the parameters defined for matching and invoice variance to apply a hold on an invoice during validation if it exceeds the tolerance.

  Label

  Amount Tolerances

  Cardinality	Target Object
  One to One	Module: oraErpCorePayablesSetup Business Object: PayablesInvoiceToleranceOption

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  amountTolerancesId	toleranceId

• payablesPaymentTerm (object)

  The payment terms specify the timing of payments, including due dates and discount periods. They're assigned to suppliers and invoices, automatically creating payment installments when an invoice is generated. Each payment term consists of one or more lines, with each line corresponding to a separate installment and specifying a due date or discount date. Payment terms are predefined and selected when entering suppliers or invoices to ensure scheduled payments are generated accordingly.

  Label

  Payment Terms

  Cardinality	Target Object
  One to One	Module: oraErpCorePayablesSetup Business Object: PayablesPaymentTerm

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  paymentTermsId	termId

• payablesQuantityToleranceOption (object)

  The invoice tolerance option represents the parameters defined for matching and invoice variance to apply a hold on an invoice during validation if it exceeds the tolerance.

  Label

  Quantity Tolerances

  Cardinality	Target Object
  One to One	Module: oraErpCorePayablesSetup Business Object: PayablesInvoiceToleranceOption

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  toleranceId	toleranceId

• paymentCurrency (object)

  Abbreviation that identifies the currency that the payment uses to pay the invoice.

  Label

  Payment Currency

  Cardinality	Target Object
  One to One	Module: oraErpCoreCurrencySetup Business Object: Currency

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  paymentCurrencyCode	currencyCode

• procurementAgentAccesses (object-collection)

  Cardinality	Target Object
  One to many	Module: oraProcurementCorePurchasingSetup Business Object: ProcurementAgentAccess

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  businessUnitId	procurementBUId

• receivingRoutingHeader (object)

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

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  receivingRoutingId	lookupCode

• supplier (object)

  A supplier address represents the location information of a supplier. You can have multiple addresses for a supplier, each with different address purposes. For example, a supplier address with purposes for ordering and remit-to, or a supplier address with purpose a for bidding or RFQ.

  Label

  Supplier

  Cardinality	Target Object
  One to One	Module: oraProcurementCoreSuppliers Business Object: Supplier

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  supplierId	supplierId

• taxCountry (object)

  Abbreviation that identifies the tax country associated to the supplier site.

  Label

  Tax Country

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

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  taxCountryCode	territoryCode

• termsDateBasis (object)

  Date when the application scheduled to run payment terms for the invoice.

  Label

  Terms Date Basis

  Cardinality	Target Object
  One to One	Module: oraErpCoreCommonObjects Business Object: ERPLookupCode

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  termsDateBasisCode	lookupCode

• territory (object)

  The list of values for the issuing territory, such as United States.

  Label

  Territory Name

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

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  countryOfOriginCode	territoryCode

• worker (object)

  The user who has put a payment hold on the invoices.

  Label

  Worker

  Cardinality	Target Object
  One to One	Module: oraHcmHrCoreEmployment Business Object: Worker

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  paymentHoldByPersonId	id

Expand all

Collapse all

Business Views

** Available for extracting data

• default

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • alternateName (string)

    Alternate name of the supplier site.

    Label

    Alternate Site Name

    Properties

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

    Value that uniquely identifies the supplier site.

    Label

    Supplier Site ID

    Properties

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

    Name of the supplier site.

    Label

    Site

    Properties

    • searchable
    • sortable
    • not nullable
  • status (enumeration: Status)

    Status of the supplier site.

    Label

    Status

    Type

    • Module: oraProcurementCoreSuppliers

    • Enumeration Type: Status

    Valid Values

    • ACTIVE
    • ALL
    • INACTIVE
• supplierSiteListReplica

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • id (int64)

    Value that uniquely identifies the supplier site.

    Label

    Supplier Site ID

    Properties

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

    Name of the supplier site.

    Label

    Site

    Properties

    • searchable
    • sortable
    • not nullable

  Expand all

  Collapse all

  Reference Object

  • address (Address)

    A supplier is a person or company that the deploying organization uses to procure items or services. For example, an office supplies provider or a consulting service provider.

    Business Object

    Address

    Expand all

    Collapse all

    Fields

    • address1 (string)

      The first line of the address.

      Label

      Address Line 1

      Properties

      • inherited
      • creatable
      • overridable
      • updatable
    • address2 (string)

      The second line of the address.

      Label

      Address Line 2

      Properties

      • inherited
      • creatable
      • overridable
      • updatable
    • address3 (string)

      The third line of the address.

      Label

      Address Line 3

      Properties

      • inherited
      • creatable
      • overridable
      • updatable
    • address4 (string)

      The fourth line of the address.

      Label

      Address Line 4

      Properties

      • inherited
      • creatable
      • overridable
      • updatable
    • city (string)

      The name of the city.

      Label

      City

      Properties

      • inherited
      • creatable
      • overridable
      • updatable
    • county (string)

      The name of the county.

      Label

      County

      Properties

      • inherited
      • creatable
      • overridable
      • updatable
    • id (int64)

      The unique identifier for an address.

      Label

      Site ID

      Properties

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

      Name of the supplier address.

      Label

      Address Name

      Properties

      • inherited
      • creatable
      • overridable
      • updatable
    • postalCode (string)

      The postal code as defined by the countrywide postal system.

      Label

      Postal Code

      Properties

      • inherited
      • creatable
      • overridable
      • updatable
    • province (string)

      The name of the province.

      Label

      Province

      Properties

      • inherited
      • creatable
      • overridable
      • updatable
    • state (string)

      The name of the state.

      Label

      State

      Properties

      • inherited
      • creatable
      • overridable
      • updatable

    Expand all

    Collapse all

    Reference Object

    • country (Territory)

      The country code of the address.

      Business Object

      Territory

      Expand all

      Collapse all

      Fields

      • territoryCode (string)

        The unique code of the territory.

        Label

        Territory Code

        Properties

        • searchable
        • sortable
        • not nullable

    • email (Email)

      An email address represents an email box to which messages are delivered for a person or business. For example, an email address for a supplier contact, or an email address for a supplier address location.

      Business Object

      Email

      Expand all

      Collapse all

      Fields

      • emailAddress (email)

        Email address of the supplier.

        Label

        Email

        Properties

        • inherited
        • creatable
        • overridable
        • updatable
      • id (int64)

        The unique identifier of the contact point.

        Label

        Contact Point ID

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable

    • phone (Phone)

      A phone represents a number that you can call to reach a particular person or business. For example, a phone number for a supplier contact or a phone number for a supplier address location.

      Business Object

      Phone

      Expand all

      Collapse all

      Fields

      • id (int64)

        The unique identifier of the contact point.

        Label

        Contact Point ID

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable

  • payablesPaymentTerm (PayablesPaymentTerm)

    The payment terms specify the timing of payments, including due dates and discount periods. They're assigned to suppliers and invoices, automatically creating payment installments when an invoice is generated. Each payment term consists of one or more lines, with each line corresponding to a separate installment and specifying a due date or discount date. Payment terms are predefined and selected when entering suppliers or invoices to ensure scheduled payments are generated accordingly.

    Business Object

    PayablesPaymentTerm

    Expand all

    Collapse all

    Fields

    • paymentTerm (string)

      Name of the payment term that's associated with the invoice.

      Label

      Name

      Properties

      • translatable
      • not nullable
    • termId (int64)

      The unique identifier of the payment term line. This attribute is a part of the composite key of the payment terms details view object.

      Label

      Payment Terms

      Properties

      • searchable
      • sortable
      • not nullable

  • supplier (Supplier)

    A supplier address represents the location information of a supplier. You can have multiple addresses for a supplier, each with different address purposes. For example, a supplier address with purposes for ordering and remit-to, or a supplier address with purpose a for bidding or RFQ.

    Business Object

    Supplier

    Expand all

    Collapse all

    Fields

    • dunsNumber (string)

      Data Universal Numbering System (D-U-N-S) that identifies the supplier business.

      Label

      D-U-N-S Number

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • overridable
      • updatable
    • id (int64)

      The unique identifier of the organization profile.

      Label

      Organization ID

      Properties

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

      The name of the organization.

      Label

      Name

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
      • overridable
      • updatable
    • oneTimeFlag (boolean)

      Classification number that the industry uses.

      Label

      One-time supplier

    • registryId (string)

      The unique alternate identifier for the account party. You can update the value if the profile option HZ_GENERATE_PARTY_NUMBER is set to True. The default value is a concatenation of the value specified in the profile option ZCA_PUID_PREFIX and a unique system generated sequence number.

      Label

      Registry ID

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
      • overridable
      • updatable
    • standardIndustryClass (string)

      Contains one of the following values: true or false. If true, then the supplier is a one-time supplier. If false, then the supplier isn't a one-time supplier. The default value is false.

      Label

      SIC

    • supplierId (int64)

      Value that uniquely identifies the supplier.

      Label

      Supplier ID

      Properties

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

      Number that identifies the supplier.

      Label

      Supplier Number

      Properties

      • creatable
      • searchable
      • sortable
      • not nullable
    • taxOrganizationType (string)

      Abbreviation that identifies the type of tax organization for the supplier. A list of accepted values is defined in the lookup type POZ_ORGANIZATION_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Tax Organization Type Lookup task.

      Label

      Tax Organization Type

    Expand all

    Collapse all

    Reference Object

    • supplierType (StandardLookupCode)

      Abbreviation that identifies the type of supplier. A list of accepted values is defined in the lookup type POZ_VENDOR_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Supplier Type Lookup task.

      Business Object

      StandardLookupCode

      Expand all

      Collapse all

      Fields

      • lookupCode (string)

        The unique identifier of the Lookup Code.

        Label

        Lookup Code ID

        Properties

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

        The unique identifier of the Lookup Type.

        Label

        Lookup Type ID

        Properties

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

        The translated meaning of the Lookup Code.

        Label

        Lookup Code Meaning

        Properties

        • inherited
        • translatable
        • not nullable

• supplierSitesExtract**

  A supplier site contains the details about the terms, controls, and policies that govern how procure to pay transactions are executed between the buying organization and the supplier. You can have multiple sites for a supplier. For example, a purchasing site or a pay site.

  Label, Plural Label

  Supplier Sites, Supplier Sites

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • agingOnsetPoint (enumeration: AgingOnsetPoint)

    Point where the supplier and the buying organization agree to begin to age consigned material.

    Label

    Aging Onset Point

    Type

    • Module: oraProcurementCorePurchasingSetup

    • Enumeration Type: AgingOnsetPoint

    Valid Values

    • NONE
    • RECEIPT
    • SHIPMENT
  • agingPeriodDays (int64)

    Maximum number of days that material can remain on consignment.

    Label

    Aging Period Days

  • allowSubstituteReceiptsFlag (boolean)

    Indicates whether the supplier site allows a substitute receipt. Values include Y for Yes or N for No.

    Label

    Allow Substitute Receipts

  • allowUnorderedReceiptsFlag (boolean)

    Contains one of the following values: true or false. If true, then the supplier site can receive a receipt that doesn't include a purchase order. If false, then the supplier site requires a purchase order. The default value is false.

    Label

    Allow unordered receipts

  • alternateName (string)

    Alternate name of the supplier site.

    Label

    Alternate Site Name

    Properties

    • searchable
    • sortable
    • not nullable
  • alwaysTakeDiscount (enumeration: PayablesOption)

    Determines whether to apply a discount on the payment. Contains one of the following values: Y, apply discount. N, don't apply discount. D, use the default from the payables options to determine whether to apply the discount.

    Label

    Always Take Discount

    Type

    • Module: oraProcurementCoreSuppliers

    • Enumeration Type: PayablesOption

    Valid Values

    • D
    • N
    • Y
  • autoCalculateInterest (enumeration: PayablesOption)

    Determines whether to exclude tax when calculating the discount. Contains one of the following values: Y, exclude tax. N, include tax. D, use the default from the payables options to determine whether to exclude tax.

    Label

    Exclude Tax from Discount

    Type

    • Module: oraProcurementCoreSuppliers

    • Enumeration Type: PayablesOption

    Valid Values

    • D
    • N
    • Y
  • bankChargeBearer (string)

    Indicate whether the deploying company or your supplier pays the bank charges for electronic payments. The lookup codes and their respective descriptions are as follows: BEN Payee pays all costs. OUR:Payer pays all costs. SHA Payer pays the domestic cost and payee pays the foreign cost. PAYEE_PAYS_EXPRESS Payee pays express charges.

    Label

    Bank Charge Bearer

  • businessToBusinessCommunicationMethodCode (enumeration: B2BCommunicationMethod)

    Abbreviation that identifies the communication method the application uses for documents during a business to business procurement transaction. Use the ORA_POZ_B2B_COMM_METHOD lookup on the Manage Standard Lookups page in the Setup and Maintenance work area to manage the values you can use with this attribute.

    Label

    B2B Communication Method

    Type

    • Module: oraProcurementCoreSuppliers

    • Enumeration Type: B2BCommunicationMethod

    Valid Values

    • B2B
    • CMK
    • NONE
  • businessToBusinessSiteCode (string)

    Abbreviation that identifies the supplier site during a business- to-business document communication.

    Label

    B2B Supplier Site Code

  • buyerManagedTransportFlag (boolean)

    Indicates whether the buyer manages transportation. Values include Y for Yes, N for No, or empty.

    Label

    Buyer Managed Transportation

  • consumptionAdviceFrequency (enumeration: ConsumptionAdviceFrequency)

    How frequently the Create Consumption Advice application runs for consumption transactions. This application runs for consigned inventory that the customer purchased under one agreement.

    Label

    Consumption Advice Frequency

    Type

    • Module: oraProcurementCorePurchasingSetup

    • Enumeration Type: ConsumptionAdviceFrequency

    Properties

    • not readable

    Valid Values

    • DAILY
    • MONTHLY
    • WEEKLY
  • consumptionAdviceSummary (enumeration: ConsumptionAdviceSummary)

    Level of detail to use when creating the consumption advice.

    Label

    Consumption Advice Summary

    Type

    • Module: oraProcurementCorePurchasingSetup

    • Enumeration Type: ConsumptionAdviceSummary

    Properties

    • not readable

    Valid Values

    • ALL_INVENTORY_ORGS
    • INVENTORY_ORG
    • INVENTORY_ORG_ITEM
    • INVENTORY_ORG_ITEM_TXNDATE
  • createDebitMemoFlag (boolean)

    Contains one of the following values: true or false. If true, then the supplier site creates a debit memo from the return transaction. If false, then the supplier site doesn't create this memo. The default value is false.

    Label

    Create debit memo from return

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • customerNumber (string)

    Number that identifies the site of the buying organization.

    Label

    Customer Number

  • daysEarlyReceiptAllowed (int64)

    Number of days that the receiving location can receive receipts before the expected receipt date.

    Label

    Early Receipt Tolerance in Days

  • daysLateReceiptAllowed (int64)

    Number of days that the receiving location can receive receipts after the expected receipt date.

    Label

    Late Receipt Tolerance in Days

  • emailAddress (email)

    Email that the communication method uses.

    Label

    Email

  • enforceShipToLocationCode (enumeration: ReceivingOption)

    Abbreviation that identifies the action to take when the receiving location is different from the ship-to location. Use the RCV_RECEIVING_OPTION lookup on the Manage Standard Lookups page in the Setup and Maintenance work area to manage the values you can use with this attribute.

    Label

    Ship-to Exception Action

    Type

    • Module: oraScmCoreReceivingTransaction

    • Enumeration Type: ReceivingOption

    Properties

    • not readable

    Valid Values

    • NONE
    • REJECT
    • WARNING
  • excludeFreightFromDiscount (enumeration: PayablesOption)

    Determines whether to exclude freight when calculating discount. Contains one of the following values: Y, exclude freight. N, include freight. D, use the default from the payables options to determine whether to exclude freight.

    Label

    Exclude Freight from Discount

    Type

    • Module: oraProcurementCoreSuppliers

    • Enumeration Type: PayablesOption

    Valid Values

    • D
    • N
    • Y
  • excludeTaxFromDiscount (enumeration: PayablesOption)

    Determines whether to exclude tax when calculating the discount. Contains one of the following values: Y, exclude tax. N, include tax. D, use the default from the payables options to determine whether to exclude tax.

    Label

    Exclude Tax from Discount

    Type

    • Module: oraProcurementCoreSuppliers

    • Enumeration Type: PayablesOption

    Valid Values

    • D
    • N
    • Y
  • fax (string)

    Fax that the communication method uses.

    Label

    Fax

  • faxAreaCode (string)

    Area Code for the fax that the communication method uses.

    Label

    Fax Area Code

  • faxCountryCode (string)
  • gaplessInvoiceNumberingFlag (boolean)

    Value that uniquely identifies the selling company. This attribute is required when the supplier site uses gapless invoice numbering.

    Label

    Gapless invoice numbering

  • holdAllInvoicesFlag (boolean)

    Contains one of the following values: true or false. If true, then the supplier site puts a hold on all invoices. If false, then the site does put them on hold. The default value is false.

    Label

    Hold All Invoices

  • holdUnmatchedInvoices (enumeration: PayablesOption)

    Determines whether to place a hold on each invoice that doesn't contain a relationship with a purchase order, receipt, or consumption advice. Values include Y for Yes, N for No, or empty.

    Label

    Hold Unmatched Invoices

    Type

    • Module: oraProcurementCoreSuppliers

    • Enumeration Type: PayablesOption

    Valid Values

    • D
    • N
    • Y
  • holdUnvalidatedInvoicesFlag (boolean)

    Indicates whether Oracle Payables should place unapproved invoices for this supplier on hold.

    Label

    Hold Unvalidated Invoices

  • id (int64)

    Value that uniquely identifies the supplier site.

    Label

    Supplier Site ID

    Properties

    • searchable
    • sortable
    • not nullable
  • inactiveDate (date)

    Date when the supplier site is no longer active.

    Label

    Inactive Date

  • inspectionRequiredFlag (boolean)

    Value indicates whether inspection is required.

    Label

    Inspection Required

  • invoiceAmountLimit (int64)

    Indicates the maximum amount for which an invoice can be created beyond which an invoice will go on hold.

    Label

    Invoice Amount Limit

  • matchOption (enumeration: InvoiceMatch)

    Indicates whether to create a relationship between the invoice and a purchase order, receipt, or consumption advice.

    Label

    Invoice Match Option

    Type

    • Module: oraProcurementCorePurchasingCommon

    • Enumeration Type: InvoiceMatch

    Properties

    • searchable
    • sortable
    • not readable

    Valid Values

    • FOUR
    • THREE
    • TWO
  • modeOfTransport (string)

    Mode of transport that the supplier site uses for shipping.

    Label

    Mode of Transport

  • name (string)

    Name of the supplier site.

    Label

    Site

    Properties

    • searchable
    • sortable
    • not nullable
  • payDateBasisCode (enumeration: PayDateBasis)

    Abbreviation that identifies the date the application scheduled to run payment for the invoice. A list of accepted values is defined in the lookup type POZ_PAY_DATE_BASIS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Payables Lookups task.

    Label

    Pay Date Basis

    Type

    • Module: oraProcurementCoreSuppliers

    • Enumeration Type: PayDateBasis

    Valid Values

    • DISCOUNT
    • DUE
  • payGroupCode (string)

    Abbreviation that identifies the withholding tax group for the site assignment. A list of accepted values is defined in the lookup type PAY_GROUP. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Payables Lookups task.

    Label

    Pay Group

  • payOnCode (string)

    Indicates when to create an invoice.

    Label

    Pay on receipt

  • payOnReceiptSummaryCode (enumeration: InvoiceSummary)

    Contains one of the following values: true or false. If true, then the supplier site allows pay on receipt. If false, then the supplier site doesn't allow pay on receipt. The default value is false.

    Label

    Pay on receipt

    Type

    • Module: oraProcurementCoreSuppliers

    • Enumeration Type: InvoiceSummary

    Properties

    • not readable

    Valid Values

    • PACKING_SLIP
    • PAY_SITE
    • RECEIPT
  • payOnUseFlag (boolean)

    Contains one of the following values: true or false. If true, then the supplier site allows pay on use. If false, then the supplier site doesn't allow pay on use. The default value is false.

    Label

    Pay on use

  • payPurposeFlag (boolean)

    Contains one of the following values: true or false. If true, then a pay purpose exists for the supplier site. If false, then pay purpose doesn't exist. The default value is false.

    Label

    Pay

  • paymentHoldDate (date)

    Date when the application places payments to the supplier site on hold.

    Label

    Payment Hold Date

  • paymentHoldReason (string)

    Reason why the application placed the invoices that it created for the supplier site on hold.

    Label

    Payment Hold Reason

  • paymentPriority (int64)

    Priority to assign to an invoice during payment.

    Label

    Payment Priority

  • phone (string)

    Phone that the communication method uses.

    Label

    Phone

  • phoneCountryCode (string)

    Abbreviation that identifies the country for the phone that the communication method uses.

    Label

    Phone Country Code

  • phoneExtension (string)

    Extension for the phone that the communication method uses.

    Label

    Phone Extension

  • poRequiredAcknowledgmentCode (enumeration: AcceptanceRequiredLevel)

    Abbreviation that identifies the acknowledgment. Applies when the purchasing document that the application created for the supplier site requires an acknowledgment. A list of accepted values is defined in the lookup type ACCEPTANCE_REQUIRED. You can't modify this lookup.

    Label

    Required Acknowledgment

    Type

    • Module: oraProcurementCorePurchasingCommon

    • Enumeration Type: AcceptanceRequiredLevel

    Properties

    • not readable

    Valid Values

    • D
    • L
    • N
    • Y
  • poRequiredAcknowledgmentDays (int64)

    Number of days that the supplier site can use to acknowledge the purchasing document.

    Label

    Acknowledge Within Days

  • primaryPayPurposeFlag (boolean)

    Contains one of the following values: true or false. If true, then primary pay purpose exists for the supplier site. If false, then primary pay purpose doesn't exist. The default value is false.

    Label

    Primary pay

  • procurementCardPurposeFlag (boolean)

    Contains one of the following values: true or false. If true, then a procurement card exists for the supplier site. If false, then procurement card doesn't exist. The default value is false.

    Label

    Procurement card

  • purchasingHoldFlag (boolean)

    Contains one of the following values: true or false. If true, then place all new purchasing documents on hold. If false, then don't place them on hold. The default value is false.

    Label

    Hold all new purchasing documents

  • purchasingHoldReason (string)

    Reason why the person who placed the hold on purchasing for the supplier site.

    Label

    Hold Reason

  • purchasingPurposeFlag (boolean)

    Contains one of the following values: true or false. If true, then a purchasing purpose exists for the supplier site. If false, then purpose doesn't exist. The default value is false.

    Label

    Purchasing

  • receiptDaysExceptionCode (enumeration: ReceivingOption)

    Abbreviation that identifies the action to taken when the supplier site receives an item before Early Receipt Tolerance in Days or after Late Receipt Tolerance in Days. A list of accepted values is defined in the lookup type RCV_RECEIVING_OPTION. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.

    Label

    Receipt Date Exception

    Type

    • Module: oraScmCoreReceivingTransaction

    • Enumeration Type: ReceivingOption

    Properties

    • not readable

    Valid Values

    • NONE
    • REJECT
    • WARNING
  • receiptRequiredFlag (boolean)

    Indicates whether supplier site requires a receipt.

    Label

    Receipt Required

  • sellingCompanyIdentifier (string)

    Value that uniquely identifies the selling company. This attribute is required when the supplier site uses gapless invoice numbering.

    Label

    Selling Company Identifier

  • serviceLevel (enumeration: ServiceLevelCode)

    Service level that the supplier site uses for shipping.

    Label

    Service Level

    Type

    • Module: oraScmCoreCarrier

    • Enumeration Type: ServiceLevelCode

    Valid Values

    • 1DA
    • 1DM
    • 1DP
    • 2DA
    • 2DAY
    • 2DM
    • 2FX
    • 3DAY
    • 3DS
    • AIR

    For a complete list of valid values, see the ServiceLevelCode enumeration type.

  • sourcingOnlyPurposeFlag (boolean)

    Contains one of the following values: true or false. If true, then the supplier has sourcing only purpose. If false, then the supplier site doesn't have sourcing only purpose. The default value is false.

    Label

    Sourcing only

  • supplierNotificationMethod (enumeration: DocumentCommunicationMethod)

    Preferred method of communication for the supplier site. Values include NONE, FAX, EMAIL, or PRINT.

    Label

    Communication Method

    Type

    • Module: oraProcurementCorePurchasingCommon

    • Enumeration Type: DocumentCommunicationMethod

    Properties

    • not readable

    Valid Values

    • EMAIL
    • FAX
    • NONE
    • PRINT
  • taxReportingSiteFlag (boolean)

    Contains one of the following values: true or false. If true, then the supplier site is a tax reporting site. If false, then supplier site isn't a tax reporting site. The default value is false.

    Label

    Income tax reporting site

  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

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

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable
  • vendorSitePrimaryIdentifier (int64)

    Value that uniquely identifies the supplier site.

    Label

    Supplier Site ID

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • address (Address)

    A supplier is a person or company that the deploying organization uses to procure items or services. For example, an office supplies provider or a consulting service provider.

    Business Object

    Address

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier for an address.

      Label

      Site ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • bankChargeDeductionType (ERPLookupCode)

    Determines how to deduct bank charges when paying the invoice. Contains one of the following values: S, use the standard deduction. D, use the default value from payables options. N, use the negotiated deduction. X, don't use any deduction.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • businessUnit (BusinessUnit)

    Procurement business unit where the supplier site resides.

    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

  • carrier (Carrier)

    A carrier represents a business organization that fulfills the shipment of products. Each carrier may model a variety of shipping methods, optional contacts, and inbound tracking rules. For example, FedEx Corporation, or DHL Express.

    Business Object

    Carrier

    Expand all

    Collapse all

    Fields

    • carrierId (int64)

      Value that uniquely identifies the carrier. It's a primary key that the application generates when it creates a carrier.

      Label

      Carrier ID

      Properties

      • searchable
      • sortable
      • not nullable

  • fob (StandardLookupCode)

    Abbreviation that identifies the Free On Board value for the supplier site. Use the FOB lookup on the Manage FOB Lookup page in the Setup and Maintenance work area to manage the values you can use with this attribute.

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • freightTerm (StandardLookupCode)

    Agreement that describes terms for shipping from the supplier site. Use the FREIGHT TERMS lookup on the Manage Freight Terms Lookup page in the Setup and Maintenance work area to manage the values you can use with this attribute.

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • invoiceChannel (StandardLookupCode)

    Channel that the supplier uses to provide invoices for the supplier site.

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • invoiceCurrency (Currency)

    Abbreviation that identifies the currency that the invoice uses.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • parentSupplierSite (SupplierSite)

    A supplier site contains the details about the terms, controls, and policies that govern how procure to pay transactions are executed between the buying organization and the supplier. You can have multiple sites for a supplier. For example, a purchasing site or a pay site.

    Business Object

    SupplierSite

    Expand all

    Collapse all

    Fields

    • id (int64)

      Value that uniquely identifies the supplier site.

      Label

      Supplier Site ID

      Properties

      • searchable
      • sortable
      • not nullable

  • payablesAmountToleranceOption (PayablesInvoiceToleranceOption)

    The invoice tolerance option represents the parameters defined for matching and invoice variance to apply a hold on an invoice during validation if it exceeds the tolerance.

    Business Object

    PayablesInvoiceToleranceOption

    Expand all

    Collapse all

    Fields

    • toleranceId (int64)

      The unique identifier of the tolerance option.

      Label

      Tolerance ID

      Properties

      • searchable
      • sortable
      • not nullable

  • payablesPaymentTerm (PayablesPaymentTerm)

    The payment terms specify the timing of payments, including due dates and discount periods. They're assigned to suppliers and invoices, automatically creating payment installments when an invoice is generated. Each payment term consists of one or more lines, with each line corresponding to a separate installment and specifying a due date or discount date. Payment terms are predefined and selected when entering suppliers or invoices to ensure scheduled payments are generated accordingly.

    Business Object

    PayablesPaymentTerm

    Expand all

    Collapse all

    Fields

    • termId (int64)

      The unique identifier of the payment term line. This attribute is a part of the composite key of the payment terms details view object.

      Label

      Payment Terms

      Properties

      • searchable
      • sortable
      • not nullable

  • payablesQuantityToleranceOption (PayablesInvoiceToleranceOption)

    The invoice tolerance option represents the parameters defined for matching and invoice variance to apply a hold on an invoice during validation if it exceeds the tolerance.

    Business Object

    PayablesInvoiceToleranceOption

    Expand all

    Collapse all

    Fields

    • toleranceId (int64)

      The unique identifier of the tolerance option.

      Label

      Tolerance ID

      Properties

      • searchable
      • sortable
      • not nullable

  • paymentCurrency (Currency)

    Abbreviation that identifies the currency that the payment uses to pay the invoice.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • receivingRoutingHeader (StandardLookupCode)

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • supplier (Supplier)

    A supplier address represents the location information of a supplier. You can have multiple addresses for a supplier, each with different address purposes. For example, a supplier address with purposes for ordering and remit-to, or a supplier address with purpose a for bidding or RFQ.

    Business Object

    Supplier

    Expand all

    Collapse all

    Fields

    • supplierId (int64)

      Value that uniquely identifies the supplier.

      Label

      Supplier ID

      Properties

      • searchable
      • sortable
      • not nullable

  • taxCountry (Territory)

    Abbreviation that identifies the tax country associated to the supplier site.

    Business Object

    Territory

    Expand all

    Collapse all

    Fields

    • territoryCode (string)

      The unique code of the territory.

      Label

      Territory Code

      Properties

      • searchable
      • sortable
      • not nullable

  • termsDateBasis (ERPLookupCode)

    Date when the application scheduled to run payment terms for the invoice.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • territory (Territory)

    The list of values for the issuing territory, such as United States.

    Business Object

    Territory

    Expand all

    Collapse all

    Fields

    • territoryCode (string)

      The unique code of the territory.

      Label

      Territory Code

      Properties

      • searchable
      • sortable
      • not nullable

  • worker (Worker)

    The user who has put a payment hold on the invoices.

    Business Object

    Worker

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier of person business object.

      Label

      Id

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

Other Properties

Property	Value
Application Package Name	ora_procurement_core_suppliers
Extensible	Yes

Back to Top