uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

sto_gs1_gcp

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	gcp_cd	VarChar(12)				GCP Code : first digits of the GTIN Code assigned to a manufacturer by GS1
	gcp_gln_cd	VarChar(13)				GLN Code of the GEPIR
	gcp_gln_nm	VarChar(255)				GLN Name (compagny belonging the GCP)
	gcp_gln_addr_02	VarChar(38)				Address ligne 2
	gcp_gln_addr_03	VarChar(38)				Address ligne 3
	gcp_gln_addr_04	VarChar(38)				Address ligne 4
	gcp_gln_addr_postal_code	VarChar(38)				CP
	gcp_gln_addr_city	VarChar(38)				City
	gcp_gln_country_iso_cd	VarChar(2)				Country ISO Code
	gcp_contact_name	VarChar(255)				Name of the contact
	gcp_contact_tel	VarChar(255)				Telephone
	gcp_contact_hotline	VarChar(255)				Hot Line
	gcp_contact_fax	VarChar(255)				Fax
	gcp_contact_mail	VarChar(255)				Email address
	gcp_contact_web	VarChar(255)				Website address
	gcp_gln_last_change	VarChar(10)				Date of last change
	gcp_gln_provider	VarChar(13)				GLN of the GS1 organization providing the GLN
	gcp_search_gtin_cd	VarChar(13)				GTIN used to search into the GEPIR
	gcp_gepir_gcp_cd	VarChar(13)				GCP returned by the GEPIR
	gcp_add_party_id	VarChar(13)
	gcp_return_code	VarChar(3)				Return Code
	gcp_source	VarChar(100)				Source of the data
	gcp_sync_dt	Date

Indexes (none)

Foreign Keys (none)

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_sto_gtin_gcp	URX_GTIN.sto_gs1_gcp	URX_GTIN.sto_gtin	gcp_cd	gcp_cd

Triggers (none)

Used in Diagrams (none)