JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9060

Suppliersaddresses

The Addresses resource manages supplier addresses.

Columns

Name Type Description
SuppliersSupplierId [KEY] Long SuppliersSupplierId of Suppliersaddresses
SupplierAddressId [KEY] Long SupplierAddressId of Suppliersaddresses
AddressName String Name of the supplier address that is associated to the supplier contact.
CountryCode String Abbreviation that identifies the country where the supplier address is located.
Country String Country of the supplier address.
AddressLine1 String First line of the supplier address.
AddressLine2 String Second line of the supplier address.
AddressLine3 String Third line of the supplier address.
AddressLine4 String Fourth line of the supplier address.
City String City of the supplier address.
State String State of the supplier address.
PostalCode String Postal code of the supplier address.
PostalCodeExtension String Four digit extension to the postal code of the supplier address.
Province String Province of the supplier address.
County String County of the supplier address.
Building String Building of the supplier address.
FloorNumber String Floor number of the supplier address.
PhoneticAddress String Phonetic, Japanese kana, or Chinese kanji representation of the address lines.
LanguageCode String Abbreviation that identifies the language of the supplier address.
Language String Language of the supplier address.
Addressee String Addressee of the supplier address.
GlobalLocationNumber String Global location number of the supplier address.
AdditionalAddressAttribute1 String First additional address attribute for the flexible supplier address format.
AdditionalAddressAttribute2 String Second additional address attribute for the flexible supplier address format.
AdditionalAddressAttribute3 String Third additional address attribute for the flexible supplier address format.
AdditionalAddressAttribute4 String Fourth Additional address attribute for the flexible supplier address format.
AdditionalAddressAttribute5 String Fifth additional address attribute for the flexible supplier address format.
AddressPurposeOrderingFlag Bool Contains one of the following values: true or false. If true, then you can use the supplier address for ordering. If false, then you cannot use this address. The default value is false.
AddressPurposeRemitToFlag Bool Contains one of the following values: true or false. If true, then you can use the supplier address to send payment. If false, then you cannot use this address. The default value is false.
AddressPurposeRFQOrBiddingFlag Bool Contains one of the following values: true or false. If true, then you can use the supplier address for request for proposal or bidding. If false, then you cannot use this address. The default value is false.
PhoneCountryCode String Abbreviation that identifies the country for the phone of the supplier address.
PhoneAreaCode String Abbreviation that identifies the area for phone of the supplier address.
PhoneNumber String Phone number of the supplier address.
PhoneExtension String Phone extension of the supplier address.
FaxCountryCode String Abbreviation that identifies the country for the fax of the supplier address.
FaxAreaCode String Abbreviation that identifies the area for the fax of the supplier address.
FaxNumber String Fax of the supplier address.
Email String Email for the supplier address.
InactiveDate Date Date when the supplier address is no longer active.
Status String Status of Suppliersaddresses
CreationDate Datetime CreationDate of Suppliersaddresses
CreatedBy String CreatedBy of Suppliersaddresses
LastUpdateDate Datetime LastUpdateDate of Suppliersaddresses
LastUpdatedBy String LastUpdatedBy of Suppliersaddresses
BilltoBuId Long BilltoBuId of Suppliersaddresses
BindPurchaseFlag String BindPurchaseFlag of Suppliersaddresses
BindReqBuId Long BindReqBuId of Suppliersaddresses
BindSourcingOnlyFlag String BindSourcingOnlyFlag of Suppliersaddresses
BindSysdate Date BindSysdate of Suppliersaddresses
Finder String Finder of Suppliersaddresses
SupplierId Long SupplierId of Suppliersaddresses

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060