Supplierssites
Records supplier site details (for example, operational addresses, payment methods), facilitating transaction-level usage.
Columns
| Name | Type | Description |
| SuppliersSupplierId [KEY] | Long | The unique identifier for the supplier associated with the supplier site. |
| SupplierSiteId [KEY] | Long | A value that uniquely identifies the supplier site. This ID is used to distinguish one supplier site from another. |
| SupplierSite | String | The name of the supplier site, which is the designated location of the supplier. |
| ProcurementBUId | Long | A value that uniquely identifies the procurement business unit where the supplier site resides. This unit is responsible for managing procurement activities for the supplier site. |
| ProcurementBU | String | The procurement business unit that the supplier site belongs to. This unit handles procurement activities such as ordering and sourcing. |
| SupplierAddressId | Long | A value that uniquely identifies the supplier address. This address is associated with the supplier site. |
| SupplierAddressName | String | The name associated with the supplier address, which helps identify or label the address for use in procurement and communications. |
| InactiveDate | Date | The date when the supplier site was marked as inactive, indicating that the site is no longer used for transactions or business activities. |
| Status | String | The current status of the supplier site, such as 'Active,' 'Inactive,' or 'Pending.' This field reflects whether the site is functional. |
| SitePurposeSourcingOnlyFlag | Bool | Indicates whether the supplier site is used solely for sourcing purposes. 'True' means it is restricted to sourcing; 'False' means it has additional uses. Default is 'False.' |
| SitePurposePurchasingFlag | Bool | Indicates whether the supplier site has a purchasing purpose. 'True' means it is used for purchasing; 'False' means it is not. Default value is 'False.' |
| SitePurposeProcurementCardFlag | Bool | Indicates whether the supplier site is enabled for procurement card transactions. 'True' means procurement card usage is allowed; 'False' means it is not. Default is 'False.' |
| SitePurposePayFlag | Bool | Indicates whether the supplier site is used for payment transactions. 'True' means payment transactions are processed through this site; 'False' means they are not. Default value is 'False.' |
| SitePurposePrimaryPayFlag | Bool | Indicates whether the supplier site serves as the primary site for payments. 'True' means it is the main payment site; 'False' means it is not. Default is 'False.' |
| IncomeTaxReportingSiteFlag | Bool | Indicates whether the supplier site is used for income tax reporting. 'True' means it is a tax reporting site; 'False' means it is not. Default value is 'False.' |
| AlternateSiteName | String | An alternate name for the supplier site, often used for different regions or specialized purposes. |
| CustomerNumber | String | A unique identifier assigned to the supplier site by the buying organization. This number helps in tracking and managing supplier relationships. |
| B2BCommunicationMethodCode | String | An abbreviation that identifies the communication method used for B2B transactions with the supplier site. Accepted values are defined in the lookup type ORA_POZ_B2B_COMM_METHOD, which can be reviewed and updated in the Setup and Maintenance work area, under 'Manage Standard Lookups.' |
| B2BCommunicationMethod | String | Indicates whether B2B messaging is enabled for the supplier site. This method allows documents to be exchanged using a common messaging framework in B2B transactions. |
| B2BSupplierSiteCode | String | A unique abbreviation identifying the supplier site used in punchout catalogs for Self-Service Procurement, which facilitates ordering processes from supplier websites. |
| CommunicationMethodCode | String | An abbreviation that identifies the preferred method of communication for the supplier site. Accepted values are defined in the lookup type DOCUMENT_COMMUNICATION_METHOD. These values include options such as 'FAX,' 'EMAIL,' and 'PRINT,' and cannot be modified. |
| CommunicationMethod | String | Indicates the preferred communication method for the supplier site, with values like 'NONE,' 'FAX,' 'EMAIL,' or 'PRINT,' managed through the DOCUMENT_COMMUNICATION_METHOD lookup type. |
| String | The email address used for communication with the supplier site, which may be required for electronic correspondence or document sharing. | |
| FaxCountryCode | String | The country code for the fax number used by the supplier site for fax communication. |
| FaxAreaCode | String | The area code for the fax number used by the supplier site, necessary for dialing the correct region. |
| FaxNumber | String | The actual fax number used for communication at the supplier site. |
| HoldAllNewPurchasingDocumentsFlag | Bool | Indicates whether all new purchasing documents for the supplier site should be placed on hold. 'True' means all new documents are held; 'False' means they are not. Default value is 'False.' |
| PurchasingHoldReason | String | The reason provided for placing a hold on purchasing documents for the supplier site. This field can explain why purchasing is restricted for the site. |
| AllNewPurchasingDocumentsHoldDate | Datetime | The date when the hold was placed on all new purchasing documents for the supplier site. This helps in tracking when restrictions were enforced. |
| AllNewPurchasingDocumentsHoldBy | String | The user or system responsible for placing the hold on new purchasing documents for the supplier site. |
| RequiredAcknowledgmentCode | String | An abbreviation identifying whether acknowledgment is required for purchasing documents created for the supplier site. Valid values include 'D' (Document), 'Y' (Yes), and 'N' (No). These values are used to control acknowledgment workflows. |
| RequiredAcknowledgment | String | The type of acknowledgment required when purchasing documents are created for the supplier site. Possible values include 'Document,' 'Document and Schedule,' and 'None.' This can be configured in the Setup and Maintenance work area. |
| AcknowledgmentWithinDays | Int | The number of days the supplier site has to acknowledge the purchasing document, which can help enforce timelines for document processing. |
| CarrierId | Decimal | A unique identifier for the carrier used by the supplier site for shipping, necessary for tracking shipments and coordinating delivery. |
| Carrier | String | The name of the carrier selected by the supplier site to handle shipping logistics. |
| ModeOfTransportCode | String | An abbreviation identifying the mode of transport used by the supplier site for shipping. Accepted values are defined in the lookup type WSH_MODE_OF_TRANSPORT, and can be reviewed and updated in the Setup and Maintenance work area. |
| ModeOfTransport | String | The mode of transport used by the supplier site for shipping, such as 'Air,' 'Sea,' or 'Road.' These transport options are defined in the WSH_MODE_OF_TRANSPORT lookup type. |
| ServiceLevelCode | String | An abbreviation that identifies the service levels the supplier site uses for shipping. Accepted values are defined in the lookup type WSH_SERVICE_LEVELS and can be reviewed in the Setup and Maintenance work area. |
| ServiceLevel | String | The shipping service level selected by the supplier site, such as 'Standard' or 'Express.' These options are defined in the WSH_SERVICE_LEVELS lookup type. |
| FreightTermsCode | String | An abbreviation identifying the freight terms for shipping from the supplier site. Accepted values are defined in the lookup type FREIGHT_TERMS. Review and update these values in the Setup and Maintenance work area. |
| FreightTerms | String | The freight terms governing shipping from the supplier site, such as 'FOB' or 'CIF.' These terms dictate the responsibility for shipping costs and delivery. |
| PayOnReceiptFlag | Bool | Indicates whether the supplier site allows payment on receipt. 'True' means payments can be made once goods are received; 'False' means payments are made later in the process. Default is 'False.' |
| FOBCode | String | An abbreviation identifying the Free On Board (FOB) value used by the supplier site. Accepted values are defined in the lookup type FOB, which can be updated in the Setup and Maintenance work area. |
| FOB | String | The Free On Board (FOB) shipping terms that determine when ownership of goods transfers to the buyer, which affects payment and delivery responsibility. |
| CountryOfOriginCode | String | An abbreviation identifying the country of origin used by the supplier site for calculating freight costs. |
| CountryOfOrigin | String | The country of origin used by the supplier site to calculate freight, which may affect shipping costs and import/export regulations. |
| BuyerManagedTransportationCode | String | An abbreviation indicating whether the buyer manages transportation for the supplier site. Accepted values are defined in the lookup type YES_NO. These values can be reviewed and updated in the Setup and Maintenance work area. |
| BuyerManagedTransportation | String | Indicates whether the buyer manages transportation for the supplier site. 'Y' means Yes, and 'N' means No. |
| PayOnUseFlag | Bool | Indicates whether the supplier site allows payment on use. 'True' means payment can be made when the goods are used; 'False' means it is not allowed. Default value is 'False.' |
| AgingOnsetPointCode | String | An abbreviation identifying the point where the supplier and the buying organization agree to begin aging consigned material. Accepted values are defined in the lookup type AGING_ONSET_POINT. |
| AgingOnsetPoint | String | The point where the supplier and buying organization agree to start aging consigned materials, which determines the accounting and inventory treatment of consigned stock. |
| AgingPeriodDays | Int | The maximum number of days material can remain on consignment before it is considered aged, which affects inventory valuation. |
| ConsumptionAdviceFrequencyCode | String | An abbreviation identifying how frequently the Create Consumption Advice application runs for consumption transactions. This application tracks the consigned inventory purchased under a single agreement. Accepted values are defined in the lookup type CONSUMPTION_ADVICE_FREQUENCY. |
| ConsumptionAdviceFrequency | String | Indicates the frequency with which the Create Consumption Advice application runs for consumption transactions, such as daily, weekly, or monthly. Values are defined in the CONSUMPTION_ADVICE_FREQUENCY lookup type. |
| ConsumptionAdviceSummaryCode | String | An abbreviation identifying the level of detail to use when creating the consumption advice. Accepted values are defined in the lookup type CONSUMPTION_ADVICE_SUMMARY, which can be updated in the Setup and Maintenance work area. |
| ConsumptionAdviceSummary | String | The level of detail used for consumption advice, such as 'Summary' or 'Detailed.' These values can be configured in the CONSUMPTION_ADVICE_SUMMARY lookup type. |
| AlternatePaySiteId | Long | A unique identifier for the alternate pay site that is associated with the supplier site. This field is used to designate a different location for processing payments. |
| AlternatePaySite | String | The name of the alternate pay site, which may be used for different payment locations other than the primary pay site. |
| InvoiceSummaryLevelCode | String | An abbreviation identifying how invoices should be grouped and summarized for the supplier site. Accepted values are defined in the lookup type POZ_ERS_INVOICE_SUMMARY. |
| InvoiceSummaryLevel | String | The level of invoice detail used for grouping and summarizing invoices for the supplier site. Values may include 'Basic' or 'Detailed' and are defined in the POZ_ERS_INVOICE_SUMMARY lookup type. |
| GaplessInvoiceNumberingFlag | Bool | Indicates whether the supplier site uses gapless invoice numbering. 'True' means invoices are consecutively numbered with no gaps, while 'False' means gaps can occur. Default value is 'False.' |
| SellingCompanyIdentifier | String | A unique identifier for the selling company that is required when the supplier site uses gapless invoice numbering to ensure sequential numbering of invoices. |
| CreateDebitMemoFromReturnFlag | Bool | Indicates whether the supplier site creates a debit memo when a return transaction occurs. 'True' means a debit memo is generated; 'False' means it is not. Default value is 'False.' |
| ShipToExceptionCode | String | An abbreviation identifying the action to take when the receiving location differs from the ship-to location. Accepted values are defined in the lookup type RCV_RECEIVING_OPTION, which can be reviewed and updated in the Setup and Maintenance work area. |
| ShipToException | String | The action to take when the receiving location differs from the ship-to location, such as 'Redirect,' 'Hold,' or 'Notify.' These actions are defined in the RCV_RECEIVING_OPTION lookup type. |
| ReceiptRoutingId | Decimal | A unique identifier for how to route each receipt for the supplier site. Routing methods can vary and are defined based on business requirements. |
| ReceiptRouting | String | Indicates the method for routing receipts at the supplier site, such as 'Manual' or 'Automated.' These values can be configured in the system to determine how receipts are processed. |
| OverReceiptTolerance | Decimal | The tolerance allowed when the receiving location receives more than the requested quantity. This tolerance level ensures proper handling of discrepancies in delivery. |
| OverReceiptActionCode | String | An abbreviation identifying the action to take when the receiving location exceeds the allowable quantity tolerance. Accepted values are defined in the lookup type RCV_RECEIVING_OPTION, such as 'Accept' or 'Reject.' |
| OverReceiptAction | String | The action to take when the receiving location receives more than the tolerated quantity, such as 'Accept,' 'Reject,' or 'Notify.' These actions are defined in the RCV_RECEIVING_OPTION lookup type. |
| EarlyReceiptToleranceInDays | Decimal | The number of days in advance the receiving location can receive goods before the expected receipt date. This value helps prevent premature deliveries from causing issues in the inventory system. |
| LateReceiptToleranceInDays | Decimal | The number of days after the expected receipt date that the receiving location can still accept goods. This ensures flexibility in delivery schedules. |
| AllowSubstituteReceiptsCode | String | An abbreviation identifying whether substitute receipts are allowed for the supplier site. Accepted values are defined in the lookup type YES_NO, such as 'Y' (Yes) or 'N' (No). |
| AllowSubstituteReceipts | String | Indicates whether the supplier site allows substitute receipts, which are alternative deliveries in place of the originally ordered items. Values include 'Y' (Yes) and 'N' (No). These options are defined in the YES_NO lookup type. |
| AllowUnorderedReceiptsFlag | Bool | Indicates whether the supplier site can accept receipts without an associated purchase order. 'True' means unordered receipts are allowed; 'False' means they are not. Default value is 'False.' |
| ReceiptDateExceptionCode | String | An abbreviation identifying the action to take when the supplier site receives an item outside the allowed receipt date range. Accepted values are defined in the lookup type RCV_RECEIVING_OPTION. |
| ReceiptDateException | String | The action to take when the supplier site receives an item before the Early Receipt Tolerance or after the Late Receipt Tolerance period, such as 'Hold,' 'Notify,' or 'Reject.' These actions are defined in the RCV_RECEIVING_OPTION lookup type. |
| InvoiceCurrencyCode | String | An abbreviation identifying the currency used for invoicing at the supplier site. Accepted values are defined in the lookup type CURRENCY_CODE. |
| InvoiceCurrency | String | The currency used for invoicing at the supplier site, such as 'USD' for US Dollars or 'EUR' for Euros. |
| InvoiceAmountLimit | Decimal | Indicates the maximum amount that an invoice can reach before being placed on hold. This amount ensures that large invoices are reviewed before processing. |
| InvoiceMatchOptionCode | String | An abbreviation identifying whether to create a relationship between the invoice and a purchase order, receipt, or consumption advice. Accepted values are defined in the lookup type INVOICE_MATCH_OPTION. |
| InvoiceMatchOption | String | Indicates whether to create a relationship between the invoice and a purchase order, receipt, or consumption advice, such as 'PO' for Purchase Order or 'Receipt' for Goods Receipt. |
| MatchApprovalLevelCode | String | An abbreviation identifying the approval level required when creating a relationship between the invoice and a purchase order, receipt, or consumption advice. Accepted values are defined in the lookup type INVOICE_MATCH. |
| MatchApprovalLevel | String | The level of approval required when matching an invoice to a purchase order, receipt, or consumption advice, such as 'Manager,' 'Director,' or 'VP.' |
| QuantityTolerancesId | Long | A unique identifier for the tolerance applied to quantity when creating an invoice for the supplier site. These tolerances help ensure that small discrepancies in quantities are handled appropriately. |
| QuantityTolerances | String | The quantity tolerance applied when creating an invoice for the supplier site, such as '5%' or '10%.' These values help manage acceptable discrepancies in order quantities. |
| AmountTolerancesId | Long | A unique identifier for the tolerance applied to the amount when creating an invoice for the supplier site. |
| AmountTolerances | String | The amount tolerance applied when creating an invoice for the supplier site, such as '5%' or '10%.' This tolerance ensures small errors in billing are accepted within the set limits. |
| InvoiceChannelCode | String | An abbreviation identifying the channel used to submit invoices from the supplier site. Accepted values are defined in the lookup type ORA_POZ_INVOICE_CHANNEL. |
| InvoiceChannel | String | The channel through which invoices are submitted from the supplier site, such as 'EDI,' 'Fax,' or 'Email.' These options are managed through the ORA_POZ_INVOICE_CHANNEL lookup type. |
| PaymentCurrencyCode | String | An abbreviation identifying the currency used for payments to the supplier site. |
| PaymentCurrency | String | The currency used to make payments to the supplier site, such as 'USD' for US Dollars or 'EUR' for Euros. |
| PaymentPriority | Decimal | The priority assigned to an invoice during payment processing. Higher values indicate higher payment priority. |
| PayGroupCode | String | An abbreviation identifying the withholding tax group for the supplier site. Accepted values are defined in the lookup type PAY_GROUP. |
| PayGroup | String | The withholding tax group associated with the supplier site, which determines how taxes are handled during payment processing. |
| HoldAllInvoicesFlag | Bool | Indicates whether all invoices for the supplier site are placed on hold. 'True' means invoices are held; 'False' means they are processed normally. Default value is 'False.' |
| HoldUnmatchedInvoicesCode | String | An abbreviation identifying whether to place a hold on invoices that do not have a matching purchase order, receipt, or consumption advice. Accepted values are defined in the lookup type POZ_PAYABLES_OPTIONS. |
| HoldUnmatchedInvoices | String | Indicates whether to place a hold on invoices that do not match a purchase order, receipt, or consumption advice. Values include 'Y' for Yes and 'N' for No. |
| HoldUnvalidatedInvoicesFlag | Bool | Indicates whether the supplier site places invoices that cannot be validated on hold. 'True' means they are placed on hold; 'False' means they are not. Default value is 'False.' |
| PaymentHoldDate | Date | The date when the application places payments for the supplier site on hold. |
| PaymentHoldReason | String | The reason why payments to the supplier site are placed on hold, which could be due to various issues such as invoice discrepancies. |
| PaymentTermsId | Long | A unique identifier for the payment terms associated with the supplier site. |
| PaymentTerms | String | The terms of payment for the supplier site, such as 'Net 30' or 'Due on Receipt.' These terms specify the payment deadlines. |
| PaymentTermsDateBasisCode | String | An abbreviation identifying the date the application uses to calculate payment terms for the invoice. Accepted values are defined in the lookup type TERMS_DATE_BASIS. |
| PaymentTermsDateBasis | String | The date basis for calculating payment terms, such as 'Invoice Date' or 'Receipt Date.' This determines when payment terms start. |
| PayDateBasisCode | String | An abbreviation identifying the date the application uses to schedule payment for the invoice. Accepted values are defined in the lookup type POZ_PAY_DATE_BASIS. |
| PayDateBasis | String | The basis for scheduling the payment date for the invoice, such as 'Invoice Date' or 'Due Date.' |
| BankChargeDeductionTypeCode | String | An abbreviation identifying how bank charges are deducted when paying the invoice. Accepted values are defined in the lookup type BANK_CHARGE_DEDUCTION_TYPE. |
| BankChargeDeductionType | String | The method used to deduct bank charges when paying the invoice. Possible values include 'S' for Standard Deduction, 'D' for Default Deduction, and 'N' for Negotiated Deduction. |
| AlwaysTakeDiscountCode | String | An abbreviation that determines whether to apply a discount on the payment. Accepted values are defined in the lookup type POZ_PAYABLES_OPTIONS. |
| AlwaysTakeDiscount | String | Indicates whether to always apply a discount on the payment. Possible values include 'Y' for Yes, 'N' for No, and 'D' for Default. |
| ExcludeFreightFromDiscountCode | String | An abbreviation that determines whether to exclude freight from the discount calculation. Accepted values are defined in the lookup type POZ_PAYABLES_OPTIONS. |
| ExcludeFreightFromDiscount | String | Indicates whether to exclude freight charges from the discount calculation. Possible values include 'Y' (Exclude Freight), 'N' (Include Freight), and 'D' (Default). |
| ExcludeTaxFromDiscountCode | String | An abbreviation that determines whether to exclude tax from the discount calculation. Accepted values are defined in the lookup type POZ_PAYABLES_OPTIONS. |
| ExcludeTaxFromDiscount | String | Indicates whether to exclude tax from the discount calculation. Possible values include 'Y' (Exclude Tax), 'N' (Include Tax), and 'D' (Default). |
| CreateInterestInvoicesCode | String | An abbreviation identifying whether to create an interest invoice for late payments. Accepted values are defined in the lookup type POZ_PAYABLES_OPTIONS. |
| CreateInterestInvoices | String | Indicates whether to create an interest invoice for late payments. Possible values include 'Y' (Create Interest Invoice), 'N' (Do not create), and 'D' (Default). |
| CreationDate | Datetime | The date and time when the supplier site record was created in the system. |
| CreatedBy | String | The user or system responsible for creating the supplier site record. |
| LastUpdateDate | Datetime | The date and time of the most recent update made to the supplier site record. |
| LastUpdatedBy | String | The user or system responsible for the last update made to the supplier site record. |
| OverrideB2BCommunicationforSpecialHandlingOrdersFlag | Bool | Indicates whether the B2B communication configuration is overridden for special handling orders. 'True' means it is overridden; 'False' means it is not. Default is 'True.' |
| BilltoBuId | Long | The unique identifier for the billing business unit associated with the supplier site. |
| BindPurchaseFlag | String | Indicates whether the supplier site is bound to purchasing activities. A value of 'True' means the supplier site is associated with purchasing processes. |
| BindReqBuId | Long | The unique identifier for the business unit required for processing the supplier site. |
| BindSourcingOnlyFlag | String | Indicates whether the supplier site is restricted to sourcing-related activities. 'True' means it is sourcing-only; 'False' means other activities are permitted. |
| BindSysdate | Date | The system date when the binding operation for the supplier site was executed. |
| Finder | String | A reference or search function used for locating or retrieving the supplier site record in the system. |
| SupplierId | Long | The unique identifier for the supplier associated with the supplier site record. |