Address bo

From UG

Revision as of 02:25, 12 April 2010 (edit) Alex (Talk | contribs) (→xxx) ← Older edit		Revision as of 02:46, 12 April 2010 (edit) (undo) Alex (Talk | contribs) (→Fields) Newer edit →
Line 23:		Line 23:
	=== City ===		=== City ===
-	=== remark ===	+	=== Remark ===
		+
		+	=== Company City Remark ===
		+
		+	Unique address id that is composed of: [[#Company]] - [[#City]] - [[#Remark]]
		+
		+	Example: "88 LOGISTICS INC. - City of Industry - central location"
		+
	=== Address 1 ===		=== Address 1 ===

---

Revision as of 02:46, 12 April 2010

Contents 1 Links 2 Fields 2.1 xxx 2.2 Company 2.3 City 2.4 Remark 2.5 Company City Remark 2.6 Address 1 2.7 Address 2 2.8 Address 3 2.9 Zip 2.10 Country 2.11 State 2.12 Contact Person 2.13 Phone 2.14 Category 2.14.1 Transportation 2.14.1.1 ExportPickUpLocation 2.14.1.2 ExportDeliveryLocation

Links

• CRUD: Addressbook (component)
• MySQL:
  • Db#tblAddressCompanyCity
  • Db#tblAddressJaguarVendor
  • Db#tblAddressTransportation
  • Db#tblAddressBillToParty

Fields

xxx

• meaning/example:
• type/format:
• misc notes:

Company

City

Remark

Company City Remark

Unique address id that is composed of: #Company - #City - #Remark

Example: "88 LOGISTICS INC. - City of Industry - central location"

Address 1

Address 2

Address 3

Zip

Country

State

Contact Person

Phone

Category

Transportation

 `IsShipper` bit(1) NOT NULL default '\0',
 `IsConsignee` bit(1) NOT NULL default '\0',
 `IsNotify` bit(1) NOT NULL default '\0',

ExportPickUpLocation

T4

ExportDeliveryLocation

T5

 `ImportPickUpLocation` bit(1) NOT NULL default '\0',
 `ImportDeliveryLocation` bit(1) NOT NULL default '\0',
 `IsDestinationReceivingAgent` bit(1) NOT NULL default '\0',
 `MasterPickUp` bit(1) NOT NULL default '\0',
 `MasterDeliveryAddress` bit(1) NOT NULL default '\0',
 `MasterShipper` bit(1) NOT NULL default '\0',
 `MasterConsignee` bit(1) NOT NULL default '\0',
 `MasterNotify` bit(1) NOT NULL default '\0',