Address bo
From UG
(Difference between revisions)
(→Fields) |
|||
| (2 intermediate revisions not shown) | |||
| Line 1: | Line 1: | ||
| - | [[Category:Addressbook]] | + | [[Category: Addressbook]] |
== Links == | == Links == | ||
| Line 19: | Line 19: | ||
* ''misc notes:'' | * ''misc notes:'' | ||
| - | === Company === | + | === Company Name === |
=== City === | === City === | ||
Current revision as of 21:38, 11 November 2013
Contents |
[edit] Links
- CRUD: Addressbook (component)
- MySQL:
[edit] Fields
[edit] xxx
- meaning/example:
- type/format:
- misc notes:
[edit] Company Name
[edit] City
[edit] Remark
[edit] Company City Remark
Unique address id that is composed of: #Company - #City - #Remark
Example: "88 LOGISTICS INC. - City of Industry - central location"
[edit] Address 1
[edit] Address 2
[edit] Address 3
[edit] Zip
[edit] Country
[edit] State
[edit] Contact Person
[edit] Phone
[edit] Category
[edit] Transportation
`IsShipper` bit(1) NOT NULL default '\0', `IsConsignee` bit(1) NOT NULL default '\0', `IsNotify` bit(1) NOT NULL default '\0',
[edit] ExportPickUpLocation
T4
[edit] 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',
