DOO_FS_ADDRESSES

Details

Schema: FUSION
Object owner: DOO
Object type: TABLE
Tablespace: INTERFACE

Primary Key

Name	Columns
DOO_FS_ADDRESSES_INT_PK	ADDRESS_IF_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ADDRESS_IF_ID	NUMBER		18	Yes	Unique internal identifier for an address interface record, generated by sequence.
FULFILLMENT_SYSTEM_RESPONSE_ID	VARCHAR2	50			Unique identifier that fulfillment system may send and can be used to correlate the response relayed back to the fulfillment system.
FULFILL_LINE_INTERFACE_KEY	VARCHAR2	120			An identifier that distinguishes a fulfillment line record from another one for a given fulfillment system response identifier.
USAGE_CONTEXT_CODE	VARCHAR2	30			Denotes the context in which the address and related data are used.
LOAD_REQUEST_ID	NUMBER		18		Unique identifier of a data set pertaining to fulfillment system responses to one or more fulfillment system requests.
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE	TIMESTAMP				Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LOCATION_ID	NUMBER		18		Unique identifier of the location.
ADDRESS_LINE1	VARCHAR2	240			Contains the first line of the address.
ADDRESS_LINE2	VARCHAR2	240			Contains the second line of the address.
ADDRESS_LINE3	VARCHAR2	240			Contains the third line of the address.
ADDRESS_LINE4	VARCHAR2	240			Contains the fourth line of the address.
CITY	VARCHAR2	60			City to which the address belongs.
POSTAL_CODE	VARCHAR2	60			Postal code to which the address belongs.
STATE	VARCHAR2	60			State to which the address belongs.
PROVINCE	VARCHAR2	60			Province to which the address belongs.
COUNTY	VARCHAR2	60			County to which the address belongs.
COUNTRY	VARCHAR2	60			Country to which the address belongs.
SUPPLIER_CODE	VARCHAR2	30			This will hold the value for Supplier on whom Purchase Order is created.
SUPPLIER_NAME	VARCHAR2	1000			Name of the supplier who will ship the goods to the customer.
SUPPLIER_NUMBER	VARCHAR2	154			Supplier number responsible for shipment of the product.
SUPPLIER_SITE_CODE	VARCHAR2	30			This will hold the value for Supplier Site on whom Purchase Order is created.
ORIG_SUPPLIER_CODE	VARCHAR2	30			This holds the value for the original supplier to whom Purchase Order was to be issued.
ORIG_SUPPLIER_SITE_CODE	VARCHAR2	30			This holds the value for the original Supplier Site against which a Purchase Order was to be created.
INTERFACE_SOURCE_CODE	VARCHAR2	30			Identifies the source used to insert data in this interface table. For example, ORA_FS_RESPONSE_FBDI and ORA_FS_RESPONSE_API for data imported using file and API respectively.
FULFILL_LINE_ID	NUMBER		18		Unique Identifier for a fulfillment line

Indexes

Index	Uniqueness	Tablespace	Columns	Status
DOO_FS_ADDRESSES_INT_N1	Non Unique	Default	INTERFACE_SOURCE_CODE, LOAD_REQUEST_ID, FULFILL_LINE_INTERFACE_KEY, USAGE_CONTEXT_CODE	Obsolete
DOO_FS_ADDRESSES_INT_N2	Non Unique	Default	FULFILL_LINE_ID, FULFILL_LINE_INTERFACE_KEY
DOO_FS_ADDRESSES_INT_PK	Unique	Default	ADDRESS_IF_ID