Supplier Site Details

The Supplier Site Details view object stores details of a supplier site and contains information related to terms, controls, and policies which govern how procure to pay transactions are executed between the buying organization and the supplier.

Data Store Key : FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierSiteExtractPVO

Primary Keys : VendorSiteId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
AgingOnsetPoint Point where the supplier and the buying organization agree to begin to age consigned material.
AgingPeriodDays Maximum number of days that material can remain on consignment.
AllowSubstituteReceiptsFlag Indicates whether the supplier site allows a substitute receipt. Values include Y for Yes or N for No.
AllowUnorderedReceiptsFlag 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.
AlwaysTakeDiscFlag 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.
AmountIncludesTaxFlag Indicates whether amounts include tax from this supplier.
ApTaxRoundingRule Indicates the rounding rule for tax values.
AreaCode Abbreviation that identifies the area for the phone that the communication method uses.
AttentionArFlag Indicates whether the payments should be sent to the Accounts Receivable department.
Attribute1 Segment for the Supplier Sites descriptive flexfield.
Attribute10 Segment for the Supplier Sites descriptive flexfield.
Attribute11 Segment for the Supplier Sites descriptive flexfield.
Attribute12 Segment for the Supplier Sites descriptive flexfield.
Attribute13 Segment for the Supplier Sites descriptive flexfield.
Attribute14 Segment for the Supplier Sites descriptive flexfield.
Attribute15 Segment for the Supplier Sites descriptive flexfield.
Attribute16 Segment for the Supplier Sites descriptive flexfield.
Attribute17 Segment for the Supplier Sites descriptive flexfield.
Attribute18 Segment for the Supplier Sites descriptive flexfield.
Attribute19 Segment for the Supplier Sites descriptive flexfield.
Attribute2 Segment for the Supplier Sites descriptive flexfield.
Attribute20 Segment for the Supplier Sites descriptive flexfield.
Attribute3 Segment for the Supplier Sites descriptive flexfield.
Attribute4 Segment for the Supplier Sites descriptive flexfield.
Attribute5 Segment for the Supplier Sites descriptive flexfield.
Attribute6 Segment for the Supplier Sites descriptive flexfield.
Attribute7 Segment for the Supplier Sites descriptive flexfield.
Attribute8 Segment for the Supplier Sites descriptive flexfield.
Attribute9 Segment for the Supplier Sites descriptive flexfield.
AttributeCategory Context name for the Supplier Sites descriptive flexfield.
AttributeDate1 Segment for the Supplier Sites descriptive flexfield.
AttributeDate10 Segment for the Supplier Sites descriptive flexfield.
AttributeDate2 Segment for the Supplier Sites descriptive flexfield.
AttributeDate3 Segment for the Supplier Sites descriptive flexfield.
AttributeDate4 Segment for the Supplier Sites descriptive flexfield.
AttributeDate5 Segment for the Supplier Sites descriptive flexfield.
AttributeDate6 Segment for the Supplier Sites descriptive flexfield.
AttributeDate7 Segment for the Supplier Sites descriptive flexfield.
AttributeDate8 Segment for the Supplier Sites descriptive flexfield.
AttributeDate9 Segment for the Supplier Sites descriptive flexfield.
AttributeNumber1 Segment for the Supplier Sites descriptive flexfield.
AttributeNumber10 Segment for the Supplier Sites descriptive flexfield.
AttributeNumber2 Segment for the Supplier Sites descriptive flexfield.
AttributeNumber3 Segment for the Supplier Sites descriptive flexfield.
AttributeNumber4 Segment for the Supplier Sites descriptive flexfield.
AttributeNumber5 Segment for the Supplier Sites descriptive flexfield.
AttributeNumber6 Segment for the Supplier Sites descriptive flexfield.
AttributeNumber7 Segment for the Supplier Sites descriptive flexfield.
AttributeNumber8 Segment for the Supplier Sites descriptive flexfield.
AttributeNumber9 Segment for the Supplier Sites descriptive flexfield.
AttributeTimestamp1 Segment for the Supplier Sites descriptive flexfield.
AttributeTimestamp10 Segment for the Supplier Sites descriptive flexfield.
AttributeTimestamp2 Segment for the Supplier Sites descriptive flexfield.
AttributeTimestamp3 Segment for the Supplier Sites descriptive flexfield.
AttributeTimestamp4 Segment for the Supplier Sites descriptive flexfield.
AttributeTimestamp5 Segment for the Supplier Sites descriptive flexfield.
AttributeTimestamp6 Segment for the Supplier Sites descriptive flexfield.
AttributeTimestamp7 Segment for the Supplier Sites descriptive flexfield.
AttributeTimestamp8 Segment for the Supplier Sites descriptive flexfield.
AttributeTimestamp9 Segment for the Supplier Sites descriptive flexfield.
AutoCalculateInterestFlag Determines whether to create an interest invoice. Contains one of the following values: Y, create an invoice. N, don't create an invoice. D, use the default from the payables options to determine whether to create an invoice.
AutoTaxCalcFlag Level for automatic tax calculation for supplier. Valid values are Y or N.
AutoTaxCalcOverride Allows override of tax calculation at supplier site level.
B2bCommMethodCode 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.
B2bSiteCode Abbreviation that identifies the supplier site during a business- to-business document communication.
BankChargeBearer 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.
BankChargeDeductionType 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.
BuyerManagedTransportFlag Indicates whether the buyer manages transportation. Values include Y for Yes, N for No, or empty.
CarrierId Value that uniquely identifies the carrier that the supplier site uses for shipping.
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.
ConsumptionAdviceSummary Level of detail to use when creating the consumption advice.
CountryOfOriginCode Abbreviation that identifies the country of origin that the supplier site uses to calculate freight.
CreateDebitMemoFlag 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.
CreatedBy User who created the supplier site.
CreationDate Date and time when the application created the supplier site.
CustomerNum Number that identifies the site of the buying organization.
DaysEarlyReceiptAllowed Number of days that the receiving location can receive receipts before the expected receipt date.
DaysLateReceiptAllowed Number of days that the receiving location can receive receipts after the expected receipt date.
DefaultPaySiteId Payment site for the site in which the receipt was entered.
EceTpLocationCode Trading partner location code for e-Commerce Gateway
EmailAddress Email that the communication method uses.
EnforceShipToLocationCode 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.
ExcludeFreightFromDiscount 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.
ExcludeTaxFromDiscount 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.
Fax Fax that the communication method uses.
FaxAreaCode Area Code for the fax that the communication method uses.
FaxCountryCode Abbreviation that identifies the country for the fax that the communication method uses.
FobLookupCode 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.
FreightTermsLookupCode 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.
GaplessInvNumFlag Contains one of the following values: true or false. If true, then the supplier site numbers their invoices so they're consecutive and don't include gaps. If false, then the supplier site doesn't use this numbering. The default value is false.
GlobalAttribute1 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute10 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute11 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute12 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute13 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute14 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute15 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute16 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute17 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute18 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute19 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute2 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute20 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute3 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute4 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute5 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute6 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute7 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute8 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttribute9 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeCategory Context name for the Supplier Sites Regional Information global descriptive flexfield.
GlobalAttributeDate1 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeDate10 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeDate2 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeDate3 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeDate4 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeDate5 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeDate6 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeDate7 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeDate8 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeDate9 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeNumber1 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeNumber10 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeNumber2 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeNumber3 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeNumber4 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeNumber5 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeNumber6 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeNumber7 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeNumber8 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeNumber9 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeTimestamp1 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeTimestamp10 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeTimestamp2 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeTimestamp3 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeTimestamp4 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeTimestamp5 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeTimestamp6 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeTimestamp7 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeTimestamp8 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
GlobalAttributeTimestamp9 Segment for the Suppliers Sites Regional Information global descriptive flexfield.
HoldAllPaymentsFlag 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.
HoldBy User who put a hold on new purchasing documents.
HoldDate Date when the user placed a hold on new purchasing documents for the supplier site.
HoldFlag 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.
HoldFuturePaymentsFlag Indicates whether Oracle Payables should place unapproved invoices for this supplier on hold.
HoldReason Reason why the application placed the invoices that it created for the supplier site on hold.
HoldUnmatchedInvoicesFlag 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.
InactiveDate Date when the supplier site is no longer active.
InspectionRequiredFlag Value indicates whether inspection is required.
InvoiceAmountLimit Indicates the maximum amount for which an invoice can be created beyond which an invoice will go on hold.
InvoiceChannel Channel that the supplier uses to provide invoices for the supplier site.
InvoiceCurrencyCode Abbreviation that identifies the currency that the invoice uses.
LastUpdateDate Date when the supplier site row was last updated.
LastUpdateLogin Session login associated to the user who last updated the supplier site.
LastUpdatedBy User who last updated the supplier site row.
LocationId Value that uniquely identifies the supplier address associated to the supplier site.
MatchOption Indicates whether to create a relationship between the invoice and a purchase order, receipt, or consumption advice.
ModeOfTransport Mode of transport that the supplier site uses for shipping.
ObjectVersionNumber Number of times the supplier site row has been updated.
OffsetTaxFlag Indicates whether offset tax is used.
OffsetVatCode VAT Code for the offset tax used.
PartySiteId Value that uniquely identifies the supplier address.
PayDateBasisLookupCode 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.
PayGroupLookupCode 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.
PayOnCode Indicates when to create an invoice.
PayOnReceiptSummaryCode 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.
PayOnUseFlag 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.
PaySiteFlag 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.
PaymentCurrencyCode Abbreviation that identifies the currency that the payment uses to pay the invoice.
PaymentHoldDate Date when the application places payments to the supplier site on hold.
PaymentPriority Priority to assign to an invoice during payment.
PcardSiteFlag 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.
Phone Phone that the communication method uses.
PhoneCountryCode Abbreviation that identifies the country for the phone that the communication method uses.
PhoneExtension Extension for the phone that the communication method uses.
PoAckReqdCode 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.
PoAckReqdDays Number of days that the supplier site can use to acknowledge the purchasing document.
PrcBuId Value that uniquely identifies the procurement business unit where the supplier site resides.
PrimaryPaySiteFlag 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.
PurchasingHoldReason Reason why the person who placed the hold on purchasing for the supplier site.
PurchasingSiteFlag 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.
QtyRcvExceptionCode 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.
QtyRcvTolerance Tolerance to use when the receiving location receives more than the requested quantity.
ReceiptDaysExceptionCode 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.
ReceiptRequiredFlag Indicates whether supplier site requires a receipt.
ReceivingRoutingId Value that uniquely identifies how to route each receipt for the supplier site.
RetainageRate Maximum percentage that can be withheld from an invoice as Retainage
RfqOnlySiteFlag 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.
SellingCompanyIdentifier Value that uniquely identifies the selling company. This attribute is required when the supplier site uses gapless invoice numbering.
ServiceLevel Service level that the supplier site uses for shipping.
ServicesToleranceId Value that uniquely identifies the tolerance to apply to the services amount when creating an invoice for the supplier site.
ShipViaLookupCode Value that uniquely identifies the default carrier used for shipping.
ShippingControl Indicates of who's responsible for arranging transportation.
ShippingNetworkLocation Identifies the shipping network location.
SupplierNotifMethod Preferred method of communication for the supplier site. Values include NONE, FAX, EMAIL, or PRINT.
TaxCountryCode Abbreviation that identifies the tax country associated to the supplier site.
TaxReportingSiteFlag 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.
Telex Telex Number that the communication method uses.
TermsDateBasis Date when the application scheduled to run payment terms for the invoice.
TermsId Value that uniquely identifies each payment term for the supplier site.
ToleranceId Value that uniquely identifies the tolerance to apply to quantity when creating an invoice for the supplier site.
TpHeaderId Value that uniquely identifies the EDI transaction header.
VatCode Value-added tax code associated to the supplier site.
VatRegistrationNum Value-added tax registration number of the supplier site.
VendorId Value that identifies a supplier record uniquely.
VendorSiteCode Name of the supplier site.
VendorSiteCodeAlt Alternate name of the supplier site.
VendorSiteId Value that uniquely identifies the supplier site.