shipment

Table info.

Title Shipment
Description Shipment

Fields

Name Type Required Index Hidden On form Title Pick list Description
ShipmentID int(11) PRI
TimestampCreated datetime Created The timestamp the record was created.
TimestampModified datetime Last edited The timestamp the record was last modified.
Version int(11) Version version
InsuredForAmount varchar(50) Acknowledged insuredForAmount
Number1 float(20,10) Number1 User definable
Number2 float(20,10) Number2 User definable
NumberOfPackages smallint(6) Number of parcels The number of parcels in the shipment
Remarks text Comments Comments about the shipment
ShipmentDate date MUL Date sent The date the material is ready to be shipped
ShipmentMethod varchar(50) MUL Method ShipmentMethod
  • Air Mail - Customs Non-insured
  • Air Mail - Customs Insured
  • Air Mail
  • Australia Post
  • Express Post
  • Registered Post
  • Courier
  • Hand delivered
  • Sea Mail - Customs Insured
  • Sea Mail - Customs Non-insured
  • Collected from MEL
  • Sea Mail
  • Transfer
  • Pack & Track International
  • Express Post International
  • Parcel Post
  • International Post Standard
 The method of shipment
ShipmentNumber varchar(50) MUL Shipment no. The shipment number
Text1 text Reference no(s). The reference numbers or tracking codes for the shipment
Text2 text Postage The postage cost of the shipment
Weight varchar(50) Weight The weight of the shipment
YesNo1 bit(1) Yes No1 User definable
YesNo2 bit(1) Yes No2 User definable
BorrowID int(11) MUL
ShipperID int(11) MUL
LoanID int(11) MUL
ShippedToID int(11) MUL
DisciplineID int(11) MUL
ShippedByID int(11) MUL
GiftID int(11) MUL
ExchangeOutID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKE139719A4CE675DE DisciplineID
FKE139719A5327F942 ModifiedByAgentID
FKE139719A7699B003 CreatedByAgentID
FKE139719A9890879E GiftID
FKE139719AA16D4F1E LoanID
FKE139719AA542314E ExchangeOutID
FKE139719AB172EEC7 ShippedByID
FKE139719AB17AF7EB ShippedToID
FKE139719ABDA7A97E ShipperID
FKE139719AF8BF6F28 BorrowID
PRIMARY ShipmentID
ShipmentDateIDX ShipmentDate
ShipmentDspMemIDX DisciplineID
ShipmentMethodIDX ShipmentMethod
ShipmentNumberIDX ShipmentNumber

Many-to-one relationships

Name Field Related table Related field
FKE139719A4CE675DE DisciplineID discipline UserGroupScopeId
FKE139719A5327F942 ModifiedByAgentID agent AgentID
FKE139719A7699B003 CreatedByAgentID agent AgentID
FKE139719A9890879E GiftID gift GiftID
FKE139719AA16D4F1E LoanID loan LoanID
FKE139719AA542314E ExchangeOutID exchangeout ExchangeOutID
FKE139719AB172EEC7 ShippedByID agent AgentID
FKE139719AB17AF7EB ShippedToID agent AgentID
FKE139719ABDA7A97E ShipperID agent AgentID
FKE139719AF8BF6F28 BorrowID borrow BorrowID