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. |