Database Table "hyp_Stock Journal"
Table Description
Product Inventory - accurate records of every update and change of the inventory.In every night process the server tranferes any record older than 30 days to archive. The opening balance will be calculated in "hyp_Product Inventory" table.
Normal StorageInventory records of the last 30 days |
Archive StorageInventory records that are older than 30 days and were calculated in the opening balance table. |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| Catalogic Number | String | 30 | PopupList | Mandatory Key Field |
CatalogicNumber | |
| Creation Time | FixDT | 0 | Edit | Read Only | CreationTime | |
| Created By | String | 40 | Edit | Read Only | CreatedBy | |
| Description | String | 100 | Edit | Description | ||
| BK Entry Date | FixDT | 0 | SelectEdit | Mandatory | BkEntryDate | |
| Reference Document Issue Date | Date | 0 | SelectEdit | ReferenceDocumentIssueDate | ||
| Reference Document Type | Values List: 00 = Unknown01 = Delivery Note 02 = Tax Invoice 03 = Credit Invoice 04 = Importation Log 05 = Supplier Delivery Note 06 = Supplier Invoice 07 = Production Order 08 = Discard 09 = Return to Supplier 10 = Return of Goods |
Status | 0 | Select | ReferenceDocumentType | |
| Reference Document | Real | 0 | Edit | ReferenceDocument | ||
| From Stockroom | String | 35 | Select | Mandatory /G:1 | FromStockroom | |
| From Section | String | 20 | Select | FromSection | ||
| From Type | Values List: 0 = Small Room1 = Warehouse 2 = Store 3 = Production Floor 4 = Virtual |
Status | 0 | Select | Read Only | FromType |
| From Agency | Status | 0 | Select | Read Only | FromAgency | |
| Into Stockroom | String | 35 | Select | Mandatory /G:1 | IntoStockroom | |
| Into Section | String | 20 | Select | IntoSection | ||
| Into Type | Values List: 0 = Small Room1 = Warehouse 2 = Store 3 = Production Floor 4 = Virtual |
Status | 0 | Select | Read Only | IntoType |
| Into Agency | Status | 0 | Select | Read Only | IntoAgency | |
| Quantity | Real | 0 | Edit | Mandatory | Quantity | |
| Unit of measure | Status | 0 | Select | Read Only | UnitOfMeasure | |
| Batch / Series / Box ID | String | 40 | Edit | BatchSeriesBoxId | ||
| Expiration Date | Date | 0 | SelectEdit | ExpirationDate | ||
| Discard Reason | Values List: 0 = null, Empty1 = Amortization 2 = Theft 3 = Expired 4 = Under Warranty |
Status | 0 | Select | DiscardReason | |
| Client/Supplier Number | Integer | 0 | Edit | Read Only | ClientSupplierNumber | |
| Client/Supplier Full Name | String | 120 | PopupList | ClientSupplierFullName | ||
| Technical Spec | String | 500 | Edit | Hidden | TechnicalSpec |