{"success":true,"message":"./application/models/tables/ap_data_stock_transaction.js","body":{},"params":{"tbl_name":"ap_data_stock_transaction"},"queries":{},"data":[{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"trans_id","ORDINAL_POSITION":1,"COLUMN_DEFAULT":null,"IS_NULLABLE":"NO","DATA_TYPE":"int","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":10,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"PRI","EXTRA":"auto_increment","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"department_id","ORDINAL_POSITION":2,"COLUMN_DEFAULT":"1","IS_NULLABLE":"NO","DATA_TYPE":"int","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":10,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"inbound_item_id","ORDINAL_POSITION":3,"COLUMN_DEFAULT":null,"IS_NULLABLE":"NO","DATA_TYPE":"int","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":10,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"outbound_item_id","ORDINAL_POSITION":4,"COLUMN_DEFAULT":null,"IS_NULLABLE":"NO","DATA_TYPE":"int","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":10,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"trans_date","ORDINAL_POSITION":5,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"date","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"date","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"trans_time","ORDINAL_POSITION":6,"COLUMN_DEFAULT":null,"IS_NULLABLE":"NO","DATA_TYPE":"time","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":0,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"time","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"item_id","ORDINAL_POSITION":7,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"int","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":10,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"request_by","ORDINAL_POSITION":8,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":50,"CHARACTER_OCTET_LENGTH":200,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(50)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"reference_no","ORDINAL_POSITION":9,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":30,"CHARACTER_OCTET_LENGTH":120,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(30)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"plate_no","ORDINAL_POSITION":10,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":10,"CHARACTER_OCTET_LENGTH":40,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(10)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"trans_type","ORDINAL_POSITION":11,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"smallint","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":5,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"smallint(6)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"qty_in","ORDINAL_POSITION":12,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"double","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":22,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"double","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"qty_out","ORDINAL_POSITION":13,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"double","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":22,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"double","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"qty_retur","ORDINAL_POSITION":14,"COLUMN_DEFAULT":"0","IS_NULLABLE":"NO","DATA_TYPE":"double","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":22,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"double","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"price","ORDINAL_POSITION":15,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"double","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":22,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"double","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"notes","ORDINAL_POSITION":16,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":255,"CHARACTER_OCTET_LENGTH":1020,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"utf8mb4","COLLATION_NAME":"utf8mb4_unicode_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"posted","ORDINAL_POSITION":17,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"bit","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":1,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"bit(1)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"user_id","ORDINAL_POSITION":18,"COLUMN_DEFAULT":null,"IS_NULLABLE":"NO","DATA_TYPE":"int","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":10,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_data_stock_transaction","COLUMN_NAME":"storage_id","ORDINAL_POSITION":19,"COLUMN_DEFAULT":"0","IS_NULLABLE":"NO","DATA_TYPE":"smallint","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":5,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"smallint(6)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null}]}