Address bo
From UG
(Difference between revisions)
(→Links) |
(→Category) |
||
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 |
Links
- CRUD: Addressbook (component)
- MySQL:
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',