The Stock Count tables are referenced/used by:
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| CCH__ID | int | Y | Auto-Generated Primary Key |
| CCH__ACTIVE | bit | Y | Flag indicating if Routine is active |
| CCH__DESCRIPTION | varchar(255) | Y | Description of this routine |
| CCH__SCHEDULE | varchar(255) | Schedule designation (common reference) | |
| CCH__TIME | time(7) | Time | |
| CCH__LASTCYCLE | datetime | The Date Time the last time the Cycle was activated | |
| CCH__NEXTCYCLE | datetime | The Date Time the cycle will next run |
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| CCL__ID | int | Y | Auto-Generated Primary Key |
| CCL__CCH_ID | int | Y | Foreign Key to qx_CycleCountHeader (Linked Cycle count Routine) |
| CCL__DESCRIPTION | varchar(255) | Additional Description of cycle count rule/filter | |
| CCL__ILC_ID | int | Foreign key to qx_Location (Linked Location) | |
| CCL__BIN_FROM | varchar(50) | Bin Range (From) | |
| CCL__BIN_TO | varchar(50) | Bin Range (To) | |
| CCL__BIN_FILTER | varchar(255) | Bin Filter Criteria | |
| CCL__ITM_FROM | varchar(50) | Item Range (From) | |
| CCL__ITM_TO | varchar(50) | Item Range (To) | |
| CCL__ITM_FILTER | varchar(255) | Item Filter Criteria |
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| SKE__ID | int | Y | Auto-Generated Primary Key |
| SKE__DATE_CREATED | datetime | Y | Date/Time Stock Take was Created |
| SKE__DATE_COMPLETED | datetime | Date/Time Stock Take was completed/closed | |
| SKE__STATUS | varchar(50) | Stock Take Status (TEXT) | |
| SKE__NAME | varchar(255) | Y | Stock Take Name (Unique) |
| SKE__WRITEBACK_STATUS | varchar(50) | Stock Take Integration (writeback) status | |
| SKE__WRITEBACK_REFERENCE | varchar(255) | Additional ERP reference after Integration (writeback) |
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| STC__ID | int | Y | Auto-Generated Primary Key |
| STC__DATE_CREATED | datetime | Y | Date/Time Stock Take Line was created |
| STC__SKE_ID | int | Y | Foreign Key to qx_StockTake (Stock Take Link) |
| STC__ITM_ID | int | Y | Foreign Key to qx_Item (Item Link) |
| STC__BIN_ID | int | Y | Foreign Key to qx_Bin (Bin Link) |
| STC__BCH_ID | int | Foreign Key to qx_Batch (Batch Link) | |
| STC__PKG_ID | int | Foreign Key to qx_Package (Package/Pallet Link) | |
| STC__QTY | float | Qty (Snapshot or count) | |
| STC__ICI_ID | int | Foreign Key to qx_InventoryCountInstruction (Link to Count Instruction) | |
| STC__DESC | varchar(30) | Y | Line Type Description |
| STC__NOTES | varchar(50) | Additional Notes | |
| STC__HAS_MATCH | bit | Count Line is matched with another line (discrepancy identification) | |
| STC__IS_FINAL | bit | Count Line is Flagged as the final counted value (the value that will be applied) |
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| ICH__ID | int | Y | Auto-Generated Primary Key |
| ICH__NAME | varchar(200) | Y | Unique Count Header Name |
| ICH__DATE | datetime | Y | Date/Time (Typically the Created Date) |
| ICH__PRIORITY | int | Priority (ranking order of execution) | |
| ICH__STATUS | int | Y | Header Status (0,1,2) |
| ICH__REFERENCE | varchar(255) | Additional Header Reference | |
| ICH__ALLOW_ADHOC | bit | The Header will allow ad-hoc Instruction creation | |
| ICH__SKE_ID | int | Foreign Key to qx_StockTake (Link to applied Stock Take) |
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| ICI__ID | int | Y | Auto-Generated Primary Key |
| ICI__ICH_ID | int | Y | Foreign Key to qx_InventoryCountHeader (Link to Header) |
| ICI__BIN_ID | int | Y | Foreign Key to qx_Bin (Link to Bin) |
| ICI__ITM_ID | int | Foreign Key to qx_Item (Link to Item) | |
| ICI__PKG_ID | int | Foreign Key to qx_Package (Link to Package/Pallet) | |
| ICI__BCH_ID | int | Foreign Key to qx_Batch (Link to Batch) | |
| ICI__DATE_CREATED | datetime | Y | Date/Time Instruction was Created |
| ICI__DATE_COMPLETED | datetime | Date/Time Instruction was Completed | |
| ICI__PRIORITY | int | Priority (Ranking order of execution) | |
| ICI__SERIAL_FLAG | bit | Flag to indicate Instruction requires Serial number capturing | |
| ICI__SCN_ID | int | Foreign Key to qx_Scanner (Assigned Scanner) | |
| ICI__USR_ID | int | Foreign Key to qx_User (User that executed the instruction) | |
| ICI__QTY | float | Qty as scanned | |
| ICI__STATUS | int | Y | Status (0,1,2) |
| ICI__ALLOW_ALT_ITEM | bit | Flag to indicate user may change Item | |
| ICI__ALLOW_ALT_BATCH | bit | Flag to indicate user may change Batch | |
| ICI__ALLOW_ALT_BIN | bit | Flag to indicate user may change Bin | |
| ICI__ALLOW_ALT_PKG | bit | Flag to indicate user may change Package/Pallet | |
| ICI__SCANNER_CREATED | bit | Flag to indicate Instruction was generated on Scanner | |
| ICI__COUNT_APPLIED | bit | Flag to indicate the Instruction has been applied to a Stock Take | |
| ICI__BIN_COMPULSARY | bit | Flag to indicate the Bin has to be scanned | |
| ICI__ITEM_COMPULSARY | bit | Flag to indicate the Item has to be scanned | |
| ICI__BATCH_COMPULSARY | bit | Flag to indicate the Batch must be included in the barcode when scanned | |
| ICI__HIDE_QTY | bit | Flag to Hide the Scanned Qty on device | |
| ICI__HIDE_BIN_QTY | bit | Flag to hide the Bin Qty on device |