JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

Supplierssites

The Supplier Sites resource manages supplier sites.

Columns

Name Type Description
SuppliersSupplierId [KEY] Long SuppliersSupplierId of Supplierssites
SupplierSiteId [KEY] Long Value that uniquely identifies the supplier site.
SupplierSite String Name of the supplier site.
ProcurementBUId Long Value that uniquely identifies the procurement business unit where the supplier site resides.
ProcurementBU String Procurement business unit where the supplier site resides.
SupplierAddressId Long Value that uniquely identifies the supplier address.
SupplierAddressName String Name of the supplier address.
InactiveDate Date Date when the supplier site is no longer active.
Status String Status of Supplierssites
SitePurposeSourcingOnlyFlag Bool Contains one of the following values: true or false. If true, then the supplier has sourcing only purpose. If false, then the supplier site does not have sourcing only purpose. The default value is false.
SitePurposePurchasingFlag Bool Contains one of the following values: true or false. If true, then a purchasing purpose exists for the supplier site. If false, then purpose does not exist. The default value is false.
SitePurposeProcurementCardFlag Bool 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 does not exist. The default value is false.
SitePurposePayFlag Bool 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 does not exist. The default value is false.
SitePurposePrimaryPayFlag Bool 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 does not exist. The default value is false.
IncomeTaxReportingSiteFlag Bool 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 is not a tax reporting site. The default value is false.
AlternateSiteName String Alternate name of the supplier site.
CustomerNumber String Number that identifies the site of the buying organization.
B2BCommunicationMethodCode String Abbreviation that identifies whether the communication of the documents during a business-to-business procurement transaction is enabled for the supplier site. A list of accepted values is defined in the lookup type ORA_POZ_B2B_COMM_METHOD. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
B2BCommunicationMethod String Attribute renamed as Enable B2B Messaging. Indicates if the application should communicate the documents during a business-to-business procurement transaction through common messaging framework for the supplier site.
B2BSupplierSiteCode String Abbreviation that uniquely identifies a specific supplier site, which is used in the punchout for Self Service Procurement.
CommunicationMethodCode String Abbreviation that identifies the preferred method of communication for the supplier site. A list of accepted values is defined in the lookup type DOCUMENT_COMMUNICATION_METHOD. You cannot modify this lookup.
CommunicationMethod String Preferred method of communication for the supplier site. Values include NONE, FAX, EMAIL, or PRINT.
Email String Email that the communication method uses.
FaxCountryCode String Abbreviation that identifies the country for the fax that the communication method uses at the supplier site.
FaxAreaCode String Abbreviation that identifies the area for the fax that the communication method uses at the supplier site.
FaxNumber String Fax number for communication.
HoldAllNewPurchasingDocumentsFlag Bool Contains one of the following values: true or false. If true, then place all new purchasing documents on hold. If false, then do not place them on hold. The default value is false.
PurchasingHoldReason String Reason why the person who placed the hold on purchasing for the supplier site.
AllNewPurchasingDocumentsHoldDate Datetime Date when the person who placed a hold on new purchasing documents for the supplier site.
AllNewPurchasingDocumentsHoldBy String AllNewPurchasingDocumentsHoldBy of Supplierssites
RequiredAcknowledgmentCode String Abbreviation that identifies the acknowledgment. This attribute is used when the purchasing document that the application created for the supplier site requires an acknowledgment. Valid values include D, Y, and N.
RequiredAcknowledgment String Type of acknowledgment. This attribute is used when the purchasing document that the application created for the supplier site requires an acknowledgment. Valid values include Document, Document and Schedule, and None.
AcknowledgmentWithinDays Int Number of days that the supplier site can use to acknowledge the purchasing document.
CarrierId Decimal Value that uniquely identifies the carrier that the supplier site uses for shipping.
Carrier String Carrier that the supplier uses for shipping.
ModeOfTransportCode String Abbreviation that identifies the mode of transport that the supplier site uses for shipping. A list of accepted values is defined in the lookup type WSH_MODE_OF_TRANSPORT. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ModeOfTransport String Mode of transport that the supplier site uses for shipping.
ServiceLevelCode String Abbreviation that identifies the service levels that the supplier site uses for shipping. A list of accepted values is defined in the lookup type WSH_SERVICE_LEVELS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ServiceLevel String Service level that the supplier site uses for shipping.
FreightTermsCode String Agreement that describes terms for shipping from the supplier site. A list of accepted values is defined in the lookup type FREIGHT TERMS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Freight Terms Lookup task.
FreightTerms String Terms for shipping from the supplier site.
PayOnReceiptFlag Bool 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 does not allow pay on receipt. The default value is false.
FOBCode String Abbreviation that identifies the Free On Board (FOM) value for the supplier site. A list of accepted values is defined in the lookup type FOB. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage FOB Lookup task.
FOB String Free on Board (FOB) value for the supplier site.
CountryOfOriginCode String Abbreviation that identifies the country of origin that the supplier site uses to calculate freight.
CountryOfOrigin String Country of origin that the supplier site uses to calculate freight.
BuyerManagedTransportationCode String Abbreviation that identifies whether the buyer manages transportation. A list of accepted values is defined in the lookup type YES_NO. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
BuyerManagedTransportation String Indicates whether the buyer manages transportation. Values include Y for Yes, N for No, or empty.
PayOnUseFlag Bool 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 does not allow pay on use. The default value is false.
AgingOnsetPointCode String Abbreviation that identifies the point where the supplier and the buying organization agree to begin to age consigned material. A list of accepted values is defined in the lookup type AGING_ONSET_POINT. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
AgingOnsetPoint String Point where the supplier and the buying organization agree to begin to age consigned material.
AgingPeriodDays Int Maximum number of days that material can remain on consignment.
ConsumptionAdviceFrequencyCode String Abbreviation that identifies how frequently the Create Consumption Advice application runs for consumption transactions. The application runs for consigned inventory that the customer purchased under one agreement. A list of accepted values is defined in the lookup type CONSUMPTION_ADVICE_FREQUENCY. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ConsumptionAdviceFrequency String How frequently the Create Consumption Advice application runs for consumption transactions. This application runs for consigned inventory that the customer purchased under one agreement.
ConsumptionAdviceSummaryCode String Abbreviation that identifies the level of detail to use when creating the consumption advice. A list of accepted values is defined in the lookup type CONSUMPTION_ADVICE_SUMMARY. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ConsumptionAdviceSummary String Level of detail to use when creating the consumption advice.
AlternatePaySiteId Long Value that uniquely identifies the alternate pay site.
AlternatePaySite String Name of the alternate pay site.
InvoiceSummaryLevelCode String Abbreviation that identifies how to group and summarize invoices for the supplier site. A list of accepted values is defined in the lookup type POZ_ERS_INVOICE_SUMMARY. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
InvoiceSummaryLevel String Determines how to group and summarize invoices for the supplier site.
GaplessInvoiceNumberingFlag Bool Contains one of the following values: true or false. If true, then the supplier site numbers their invoices so they are consecutive and do not include gaps. If false, then the supplier site does not use this numbering. The default value is false.
SellingCompanyIdentifier String Value that uniquely identifies the selling company. This attribute is required when the supplier site uses gapless invoice numbering.
CreateDebitMemoFromReturnFlag Bool 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 does not create this memo. The default value is false.
ShipToExceptionCode String Abbreviation that identifies the action to take when the receiving location is different from the ship-to location. 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.
ShipToException String Action to take when the receiving location is different from the ship-to location.
ReceiptRoutingId Decimal Value that uniquely identifies how to route each receipt for the supplier site.
ReceiptRouting String Indicates how to route each receipt for the supplier site.
OverReceiptTolerance Decimal Tolerance to use when the receiving location receives more than the requested quantity.
OverReceiptActionCode String Abbreviation that identifies the action to take when the receiving location receives quantity that exceeds the tolerance. 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.
OverReceiptAction String Action to take when the receiving location receives quantity that exceeds the tolerance.
EarlyReceiptToleranceInDays Decimal Number of days that the receiving location can receive receipts before the expected receipt date.
LateReceiptToleranceInDays Decimal Number of days that the receiving location can receive receipts after the expected receipt date.
AllowSubstituteReceiptsCode String Abbreviation that identifies whether the supplier site allows a substitute receipt. A list of accepted values is defined in the lookup type YES_NO. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
AllowSubstituteReceipts String Indicates whether the supplier site allows a substitute receipt. Values include Y for Yes or N for No.
AllowUnorderedReceiptsFlag Bool Contains one of the following values: true or false. If true, then the supplier site can receive a receipt that does not include a purchase order. If false, then the supplier site requires a purchase order. The default value is false.
ReceiptDateExceptionCode String 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.
ReceiptDateException String Action to take when the supplier site receives an item before Early Receipt Tolerance in Days or after Late Receipt Tolerance in Days.
InvoiceCurrencyCode String Abbreviation that identifies the currency that the invoice uses.
InvoiceCurrency String Currency that the invoice uses.
InvoiceAmountLimit Decimal Indicates the maximum amount for which an invoice can be created beyond which an invoice will go on hold.
InvoiceMatchOptionCode String Abbreviation that identifies whether to create a relationship between the invoice and a purchase order, receipt, or consumption advice. A list of accepted values is defined in the lookup type INVOICE_MATCH_OPTION. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Payables Lookups task.
InvoiceMatchOption String Indicates whether to create a relationship between the invoice and a purchase order, receipt, or consumption advice.
MatchApprovalLevelCode String Abbreviation that identifies the approval level to use when creating a relationship between the invoice and a purchase order, receipt, or consumption advice. A list of accepted values is defined in the lookup type INVOICE_MATCH. You cannot modify this lookup.
MatchApprovalLevel String Approval level to use when creating a relationship between the invoice and a purchase order, receipt, or consumption advice.
QuantityTolerancesId Long Value that uniquely identifies the tolerance to apply to quantity when creating an invoice for the supplier site.
QuantityTolerances String Tolerance to apply to the quantity when creating an invoice for the supplier site.
AmountTolerancesId Long Value that uniquely identifies the tolerance to apply to the quantity when creating an invoice for the supplier site.
AmountTolerances String Tolerance to apply to the amount when creating an invoice for the supplier site.
InvoiceChannelCode String Abbreviation that identifies the channel that the supplier uses to provide invoices for the supplier site. A list of accepted values is defined in the lookup type ORA_POZ_INVOICE_CHANNEL. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
InvoiceChannel String Channel that the supplier uses to provide invoices for the supplier site.
PaymentCurrencyCode String Abbreviation that identifies the currency that the payment uses to pay the invoice.
PaymentCurrency String Currency that the payment uses to pay the invoice.
PaymentPriority Decimal Priority to assign to an invoice during payment.
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.
PayGroup String Withholding tax group for the site assignment.
HoldAllInvoicesFlag Bool 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.
HoldUnmatchedInvoicesCode String Abbreviation that identifies whether to place a hold on each invoice that does not contain a relationship with a purchase order, receipt, or consumption advice. A list of accepted values is defined in the lookup type POZ_PAYABLES_OPTIONS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
HoldUnmatchedInvoices String Determines whether to place a hold on each invoice that does not contain a relationship with a purchase order, receipt, or consumption advice. Values include Y for Yes, N for No, or empty.
HoldUnvalidatedInvoicesFlag Bool Contains one of the following values: true or false. If true, then the supplier site places all invoices that it cannot validate on hold. If false, then the supplier site does not put them hold. The default value is false.
PaymentHoldDate Date Date when the application places payments to the supplier site on hold.
PaymentHoldReason String Reason why the application placed the invoices that it created for the supplier site on hold.
PaymentTermsId Long Value that uniquely identifies each payment term for the supplier site.
PaymentTerms String Terms of payment for the supplier site.
PaymentTermsDateBasisCode String Abbreviation that identifies the date the application scheduled to run payment terms for the invoice. A list of accepted values is defined in the lookup type TERMS_DATE_BASIS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Payables Lookups task.
PaymentTermsDateBasis String Date when the application scheduled to run payment terms for the invoice.
PayDateBasisCode String 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.
PayDateBasis String Date that the application scheduled to run payment for the invoice.
BankChargeDeductionTypeCode String Abbreviation that identifies whether and how to deduct bank charges when paying the invoice. A list of accepted values is defined in the lookup type BANK_CHARGE_DEDUCTION_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Payables Lookups task.
BankChargeDeductionType String 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, do not use any deduction.
AlwaysTakeDiscountCode String Abbreviation that determines whether to apply a discount on the payment. A list of accepted values is defined in the lookup type POZ_PAYABLES_OPTIONS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
AlwaysTakeDiscount String Determines whether to apply a discount on the payment. Contains one of the following values: Y, apply discount. N, do not apply discount. D, use the default from the payables options to determine whether to apply the discount.
ExcludeFreightFromDiscountCode String Abbreviation that determines whether to exclude freight when calculating discount. A list of accepted values is defined in the lookup type POZ_PAYABLES_OPTIONS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ExcludeFreightFromDiscount String 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.
ExcludeTaxFromDiscountCode String Abbreviation that determines whether to exclude tax when calculating the discount. A list of accepted values is defined in the lookup type POZ_PAYABLES_OPTIONS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ExcludeTaxFromDiscount String 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.
CreateInterestInvoicesCode String Abbreviation that determines whether to create an interest invoice. A list of accepted values is defined in the lookup type POZ_PAYABLES_OPTIONS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
CreateInterestInvoices String Determines whether to create an interest invoice. Contains one of the following values: Y, create an invoice. N, do not create an invoice. D, use the default from the payables options to determine whether to create an invoice.
CreationDate Datetime CreationDate of Supplierssites
CreatedBy String CreatedBy of Supplierssites
LastUpdateDate Datetime LastUpdateDate of Supplierssites
LastUpdatedBy String LastUpdatedBy of Supplierssites
OverrideB2BCommunicationforSpecialHandlingOrdersFlag Bool Contains one of the following values: true or false. If true, the configured B2B communication is overridden for the supplier site's special handling purchase orders. If false, then the B2B configuration for the supplier site is honored. The default value is true.
BilltoBuId Long BilltoBuId of Supplierssites
BindPurchaseFlag String BindPurchaseFlag of Supplierssites
BindReqBuId Long BindReqBuId of Supplierssites
BindSourcingOnlyFlag String BindSourcingOnlyFlag of Supplierssites
BindSysdate Date BindSysdate of Supplierssites
Finder String Finder of Supplierssites
SupplierId Long SupplierId of Supplierssites

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062