ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9175

SupplierRegistrationRequestsaddresses

Manages address information tied to a supplier registration request, capturing physical location details for the supplier.

Columns

Name Type Description
SupplierRegistrationRequestsSupplierRegistrationKey [KEY] String A unique key that links the supplier registration request to a specific supplier's address.
SupplierRegistrationAddressId [KEY] Long A unique identifier for the supplier registration request address, used to track the address within the supplier registration process.
AddressName String The name or label for the supplier address (for example, 'Head Office', 'Warehouse').
CountryCode String The abbreviation for the country where the supplier address is located. Valid values include ISO 3166-1 alpha-2 country codes like 'US', 'IN', 'GB'.
AddressLine1 String The first line of the address, typically containing the street address or building name.
AddressLine2 String The second line of the address, used for apartment numbers or additional address details.
AddressLine3 String The third line of the address, if needed, for further details.
AddressLine4 String The fourth line of the address, if needed, for further details.
City String The city or locality of the supplier's address.
State String The state or province where the supplier address is located.
PostalCode String The postal code of the supplier address.
PostalCodeExtension String An extension to the postal code, if applicable, typically used for more precise delivery details.
Province String The province of the supplier address, applicable for some countries.
County String The county or district where the supplier address is located.
Building String The building number or name for the supplier address, often used in large complexes.
FloorNumber String The floor number within the building where the supplier address is located.
PhoneticAddress String A phonetic representation of the address, typically used for languages like Japanese (kana) or Chinese (kanji).
AddressPurposeOrderingFlag Bool Indicates if the address can be used for ordering. True means it can be used for ordering, false means it cannot. Default is false.
AddressPurposeRemitToFlag Bool Indicates if the address can be used for requesting proposals or bidding. True means it can be used, false means it cannot. Default is false.
AddressPurposeRFQOrBiddingFlag Bool Indicates if the address can be used for sending payments or RFQs. True means it can be used, false means it cannot. Default is false.
PhoneCountryCode String The country code for the phone number. Valid values include ISO 3166-1 alpha-2 country codes.
PhoneAreaCode String The area or region code for the phone number.
PhoneNumber String The main phone number for the supplier address.
PhoneExtension String The phone extension number, if applicable.
FaxCountryCode String The country code for the fax number.
FaxAreaCode String The area or region code for the fax number.
FaxNumber String The main fax number for the supplier address.
Email String The email address for the supplier address, used for communication.
AdditionalAddressAttribute1 String First additional attribute for the flexible supplier address format (can be used for extra address details).
AdditionalAddressAttribute2 String Second additional attribute for the flexible supplier address format (can be used for extra address details).
AdditionalAddressAttribute3 String Third additional attribute for the flexible supplier address format (can be used for extra address details).
AdditionalAddressAttribute4 String Fourth additional attribute for the flexible supplier address format (can be used for extra address details).
AdditionalAddressAttribute5 String Fifth additional attribute for the flexible supplier address format (can be used for extra address details).
Finder String A search keyword or identifier used to locate this address in a broader search context.
SupplierRegistrationKey String A unique key linking the address to the corresponding supplier registration.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175