Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

(Design) Purchase Orders #512

Closed
jniles opened this issue Jun 20, 2016 · 0 comments
Closed

(Design) Purchase Orders #512

jniles opened this issue Jun 20, 2016 · 0 comments
Assignees
Labels

Comments

@jniles
Copy link
Contributor

jniles commented Jun 20, 2016

This issue proposes the database schema for purchase orders in 2.x

Schema
The purchase table has a lot information unrelated to the actual purchase order to be sent to the supplier. We should start small with only the necessary information and try to add in more if we need it.

column type description
uuid BINARY
project_id INT
reference INT A generated ID that, combined with project_id, creates a human readable id
cost DECIMAL the total cost of the purchase order
date DATETIME the date of the purchase order
currency_id INT the id of the currency the order is made in
note TEXT some text describing the nature of the purchase order
creditor_uuid BINARY the creditor to be sent the purchase order
created_at TIMESTAMP set at the server time when the record was created

The table purchase_item doesn't need to change.

For the first iteration, this will be all the properties stored in the purchase order table.

HTTP API
The HTTP API will follow the standard API Guidelines. You will not be able to delete a Purchase Order yet, until that case is analyzed.

@jniles jniles added the design label Jun 20, 2016
@jniles jniles self-assigned this Jun 20, 2016
@jniles jniles added this to the Inventory Management Implementation milestone Jun 20, 2016
jniles referenced this issue in jniles/bhima Jun 21, 2016
This commit implements the purchases API described in #512.  The schema
is updated to reflect new concerns and to remove the boolean states from
the database.  The integration tests are updated appropriately.

Closes #512.
jniles referenced this issue in jniles/bhima Jun 22, 2016
This commit implements the purchases API described in #512.  The schema
is updated to reflect new concerns and to remove the boolean states from
the database.  The integration tests are updated appropriately.

Closes #512.
jniles referenced this issue in jniles/bhima Jun 23, 2016
This commit implements the purchases API described in #512.  The schema
is updated to reflect new concerns and to remove the boolean states from
the database.  The integration tests are updated appropriately.

Closes #512.
jniles referenced this issue in jniles/bhima Jun 24, 2016
This commit implements the purchases API described in #512.  The schema
is updated to reflect new concerns and to remove the boolean states from
the database.  The integration tests are updated appropriately.

Closes #512.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant