Address bo
From UG
(Difference between revisions)
(→xxx) |
(→Fields) |
||
Line 23: | Line 23: | ||
=== City === | === 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 1 === |
Revision as of 02:46, 12 April 2010
Contents |
Links
- CRUD: Addressbook (component)
- MySQL:
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',