Difference between revisions of "VbzCart/tables/ord pkgs"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(extracted from VbzCart/tables)
 
(Added ChgShipItm, ChgShipPkg)
Line 5: Line 5:
 
** The field "ArrivalNotes" should be added to the message log; leaving it out of the migration for this table.
 
** The field "ArrivalNotes" should be added to the message log; leaving it out of the migration for this table.
 
** '''WhenVoided''': We're not deleting packages anymore. Instead, we mark an emptied, unsent package as "VOID", and log it in the container record. Voided package records can be re-used if they aren't assigned to a closed shipment; log the un-voiding prior to re-use. (Should there be a "WhenLocked" field to represent the shipment being closed? Maybe WhenFinished does this...) A package should never be voided without first zeroing stock in all line items.
 
** '''WhenVoided''': We're not deleting packages anymore. Instead, we mark an emptied, unsent package as "VOID", and log it in the container record. Voided package records can be re-used if they aren't assigned to a closed shipment; log the un-voiding prior to re-use. (Should there be a "WhenLocked" field to represent the shipment being closed? Maybe WhenFinished does this...) A package should never be voided without first zeroing stock in all line items.
 +
* '''History''':
 +
** '''2010-10-19''' Added '''ChgShipItm''', '''ChgShipPkg''' to complete the record of what was charged for the package.
 
==SQL==
 
==SQL==
 
<section begin=sql /><mysql>CREATE TABLE `ord_pkgs` (
 
<section begin=sql /><mysql>CREATE TABLE `ord_pkgs` (
Line 16: Line 18:
 
   `isReturn`      BOOL COMMENT "TRUE = this package is being returned, not shipped out",
 
   `isReturn`      BOOL COMMENT "TRUE = this package is being returned, not shipped out",
 
   `ID_Shipment`    INT COMMENT "ord_shipmt.ID",
 
   `ID_Shipment`    INT COMMENT "ord_shipmt.ID",
   `ShipCost`      DECIMAL(9,2) COMMENT "cost of shipping (postage)",
+
  `ChgShipItm`    DECIMAL(9,2) COMMENT "total amount charged for per-item shipping",
   `PkgCost`        DECIMAL(9,2) COMMENT "cost of packaging / insurance",
+
  `ChgShipPkg`    DECIMAL(9,2) COMMENT "amount charged for per-package shipping",
 +
   `ShipCost`      DECIMAL(9,2) COMMENT "actual cost of shipping (postage)",
 +
   `PkgCost`        DECIMAL(9,2) COMMENT "actual cost of packaging / insurance",
 
   `ShipPounds`    FLOAT COMMENT "shipping weight in pounds (whole or fractional)",
 
   `ShipPounds`    FLOAT COMMENT "shipping weight in pounds (whole or fractional)",
 
   `ShipOunces`    FLOAT COMMENT "shipping weight in ounces, less ShipPounds",
 
   `ShipOunces`    FLOAT COMMENT "shipping weight in ounces, less ShipPounds",

Revision as of 22:39, 19 October 2010

About

  • Purpose: Packages shipped in response to a customer order (
  1. REDIRECT Template:l/vc/table)
  • Refers to: core_orders (parent), ord_shipmt
  • Notes:
    • The field "ArrivalNotes" should be added to the message log; leaving it out of the migration for this table.
    • WhenVoided: We're not deleting packages anymore. Instead, we mark an emptied, unsent package as "VOID", and log it in the container record. Voided package records can be re-used if they aren't assigned to a closed shipment; log the un-voiding prior to re-use. (Should there be a "WhenLocked" field to represent the shipment being closed? Maybe WhenFinished does this...) A package should never be voided without first zeroing stock in all line items.
  • History:
    • 2010-10-19 Added ChgShipItm, ChgShipPkg to complete the record of what was charged for the package.

SQL

<mysql>CREATE TABLE `ord_pkgs` (

 `ID`             INT NOT NULL AUTO_INCREMENT,
 `Seq`            INT COMMENT "number used to make user-friendly pkg #",
 `ID_Order`       INT NOT NULL COMMENT "core_orders.ID",
 `WhenStarted`    DATETIME COMMENT "when package record was created",
 `WhenFinished`   DATETIME, /* need to check code for actual purpose of field */
 `WhenChecked`    DATETIME, /* need to check code for actual purpose of field */
 `WhenVoided`     DATETIME COMMENT "when package was emptied; can be reused later",
 `isReturn`       BOOL COMMENT "TRUE = this package is being returned, not shipped out",
 `ID_Shipment`    INT COMMENT "ord_shipmt.ID",
 `ChgShipItm`     DECIMAL(9,2) COMMENT "total amount charged for per-item shipping",
 `ChgShipPkg`     DECIMAL(9,2) COMMENT "amount charged for per-package shipping",
 `ShipCost`       DECIMAL(9,2) COMMENT "actual cost of shipping (postage)",
 `PkgCost`        DECIMAL(9,2) COMMENT "actual cost of packaging / insurance",
 `ShipPounds`     FLOAT COMMENT "shipping weight in pounds (whole or fractional)",
 `ShipOunces`     FLOAT COMMENT "shipping weight in ounces, less ShipPounds",
 `ShipNotes`      VARCHAR(255) COMMENT "human-entered notes about this pkg",
 `ShipTracking`   VARCHAR(127) COMMENT "shipper's tracking number for pkg",
 `WhenArrived`    DATETIME COMMENT "when arrived at customer, if known",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>