Address bo

From UG

Revision as of 19:09, 11 April 2010 (edit) Alex (Talk | contribs) (→Links) ← Older edit		Revision as of 02:18, 12 April 2010 (edit) (undo) Alex (Talk | contribs) (→Category) Newer edit →
Line 42:		Line 42:
	=== 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` bit(1) NOT NULL default '\0',
		+	`ExportDeliveryLocation` bit(1) NOT NULL default '\0',
		+	`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',

---

Revision as of 02:18, 12 April 2010

Contents 1 Links 2 Fields 2.1 xxx 2.2 Company 2.3 City 2.4 remark 2.5 Address 1 2.6 Address 2 2.7 Address 3 2.8 Zip 2.9 Country 2.10 State 2.11 Contact Person 2.12 Phone 2.13 Category 2.13.1 Transportation

Links

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

Fields

xxx

• meaning:
• type/format:
• example:

Company

City

remark

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` bit(1) NOT NULL default '\0',
 `ExportDeliveryLocation` bit(1) NOT NULL default '\0',
 `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',