Address bo

From UG

Revision as of 19:07, 11 April 2010 (edit) Alex (Talk | contribs) (→Links) ← Older edit		Current revision as of 21:38, 11 November 2013 (edit) (undo) Alex (Talk | contribs)
(7 intermediate revisions not shown)
Line 1:		Line 1:
-	[[Category:Addressbook]]	+	[[Category: Addressbook]]
	== Links ==		== Links ==
	* ''CRUD:''  [[Addressbook (component)]]		* ''CRUD:''  [[Addressbook (component)]]
-	* ''MySQL:'' [[Office tbl]]	+	* ''MySQL:''
		+	** [[Db#tblAddressCompanyCity]]
		+	** [[Db#tblAddressJaguarVendor]]
		+	** [[Db#tblAddressTransportation]]
		+	** [[Db#tblAddressBillToParty]]
	== Fields ==		== Fields ==
Line 11:		Line 15:
	=== xxx  ===		=== xxx  ===
-	* ''meaning:''	+	* ''meaning/example:''
	* ''type/format:''		* ''type/format:''
-	* ''example:''	+	* ''misc notes:''
-	=== Company ===	+	=== Company Name ===
	=== 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 ===
Line 38:		Line 49:
	=== Category ===		=== 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',

---

Current revision as of 21:38, 11 November 2013

Contents 1 Links 2 Fields 2.1 xxx 2.2 Company Name 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

[edit] Links

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

[edit] Fields

[edit] xxx

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

[edit] Company Name

[edit] City

[edit] Remark

[edit] Company City Remark

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

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

[edit] Address 1

[edit] Address 2

[edit] Address 3

[edit] Zip

[edit] Country

[edit] State

[edit] Contact Person

[edit] Phone

[edit] Category

[edit] Transportation

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

[edit] ExportPickUpLocation

T4

[edit] 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',