Address bo
From UG
(Difference between revisions)
(→Category) |
(→Transportation) |
||
Line 48: | Line 48: | ||
`IsConsignee` bit(1) NOT NULL default '\0', | `IsConsignee` bit(1) NOT NULL default '\0', | ||
`IsNotify` bit(1) NOT NULL default '\0', | `IsNotify` bit(1) NOT NULL default '\0', | ||
- | + | ||
- | + | ===== ExportPickUpLocation ===== | |
+ | |||
+ | T4 | ||
+ | |||
+ | ===== ExportDeliveryLocation ===== | ||
+ | |||
+ | T5 | ||
+ | |||
`ImportPickUpLocation` bit(1) NOT NULL default '\0', | `ImportPickUpLocation` bit(1) NOT NULL default '\0', | ||
`ImportDeliveryLocation` bit(1) NOT NULL default '\0', | `ImportDeliveryLocation` bit(1) NOT NULL default '\0', |
Revision as of 02:20, 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
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',