Address bo
From UG
(Difference between revisions)
(→Links) |
|||
(8 intermediate revisions not shown) | |||
Line 1: | Line 1: | ||
- | [[Category:Addressbook]] | + | [[Category: Addressbook]] |
== Links == | == Links == | ||
- | * | + | * ''CRUD:'' [[Addressbook (component)]] |
- | * ''MySQL:'' [[ | + | * ''MySQL:'' |
+ | ** [[Db#tblAddressCompanyCity]] | ||
+ | ** [[Db#tblAddressJaguarVendor]] | ||
+ | ** [[Db#tblAddressTransportation]] | ||
+ | ** [[Db#tblAddressBillToParty]] | ||
== Fields == | == Fields == | ||
Line 11: | Line 15: | ||
=== xxx === | === xxx === | ||
- | * ''meaning:'' | + | * ''meaning/example:'' |
* ''type/format:'' | * ''type/format:'' | ||
- | * '' | + | * ''misc notes:'' |
- | === Company === | + | === Company Name === |
=== 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 === | ||
Line 38: | Line 49: | ||
=== 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 ===== | ||
+ | |||
+ | 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', |
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',