Address bo
From UG
(Difference between revisions)
(→Fields) |
|||
Line 1: | Line 1: | ||
- | [[Category: | + | [[Category: OpsAdmin]] |
== Links == | == Links == |
Revision as of 04:59, 23 December 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',