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