Address bo

From UG

(Difference between revisions)
Jump to: navigation, search
(Links)
 
(7 intermediate revisions not shown)
Line 1: Line 1:
-
[[Category:Addressbook]]
+
[[Category: Addressbook]]
== Links ==
== Links ==
* ''CRUD:''  [[Addressbook (component)]]
* ''CRUD:''  [[Addressbook (component)]]
-
* ''MySQL:'' [[Office tbl]]
+
* ''MySQL:''  
 +
** [[Db#tblAddressCompanyCity]]
 +
** [[Db#tblAddressJaguarVendor]]
 +
** [[Db#tblAddressTransportation]]
 +
** [[Db#tblAddressBillToParty]]
== Fields ==
== Fields ==
Line 11: Line 15:
=== xxx  ===
=== xxx  ===
-
* ''meaning:''   
+
* ''meaning/example:''   
* ''type/format:''   
* ''type/format:''   
-
* ''example:''
+
* ''misc notes:''
-
=== Company ===
+
=== Company Name ===
=== City ===
=== City ===
-
=== remark ===
+
=== 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

[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',
Personal tools