Script operations linked to database objects
The objects created through the database tables and the script operations to perform with these objects are shown in the table below.
Object Name | Table Name | Model Name | Record Type No | List | Get | New | Set | Save | Generate | Run | Description |
Address | SysAddress | Address | 126 | x | x | The address-blocking operation will be performed by reservation. | |||||
Address Material Link | AddressItem | AddressItem | 151 | x | x | x | x | x | The delete operation will be performed through the back office. | ||
AR/AP | Arp | Arp | 142 | x | x | ||||||
Carriers | Carrier | Carrier | 140 | x | x | ||||||
Containers | Container | Container | 152 | x | x | x | x | x | |||
Container Types | SysContainer Type | ContainerType | 127 | x | x | ||||||
Auxiliary Codes | SysCustomCode | CustomCode | 102 | x | x | ||||||
User Defined Business Rules | SysCustomRule | CustomRule | 117 | x | |||||||
User Defined Slip Types | SysCustomSlipType | CustomSlipType | 129 | x | x | ||||||
User Defined Slip Status | SysCustomState | CustomState | 120 | x | x | ||||||
Departments | SysDepartment | Department | 112 | x | x | ||||||
Divisions | SysDivision | Division | 113 | x | x | ||||||
Image | Document | Image | 130 | x | It is used as a direct Image command without using Get. | ||||||
Drivers | Driver | Driver | 139 | x | x | ||||||
ERP Company Definitions | SysErpFirm | ErpFirm | 175 | x | x | ||||||
Factories | SysFactory | Factory | 114 | x | x | ||||||
Materials | Item | Item | 145 | x | x | x | x | ||||
Material Content | ItemContent | ItemContent | 149 | x | x | ||||||
Material Parameters | ItemParameter | ItemParameter | 150 | x | x | ||||||
Serial/Lot Information | ItemTracking | 165 | x | x | x | x | x | Operates in the Transaction Detail table. | |||
Material Units | ItemUnit | ItemUnit | 146 | x | x | ||||||
Orders | OrderSlip | OrderSlip | 153 | x | x | x | x | Set and Save are only used to switch to inactive. | |||
Order Lines | OrderSlipLine | OrderSlipLine | 154 | x | x | x | x | Set and Save are only used to switch to inactive. | |||
Parameters | SysParameter | Parameter | 115 | x | x | ||||||
Planning Slips | PlanningSlip | PlanningSlip | 155 | x | x | x | x | x | x | Generate instead of MAKEPLAN | |
Planning Slip Lines | PlanningSlipLine | PlanningSlipLine | 156 | x | x | x | x | x | |||
Printers | SysPrinter | Printer | 101 | x | x | ||||||
Production Orders | ProductionOrder | ProductionOrder | 157 | x | x | x | x | ||||
Production Work Orders | ProductionOrderLine | ProductionOrderLine | 158 | x | x | x | x | ||||
Projects | Project | Project | 133 | x | x | ||||||
Reservation Slips | ReservationSlip | ReservationSlip | 163 | x | x | x | x | x | x | ||
Reservation Slip Line | ReservationSlipLine | ReservationSlipLine | 164 | x | x | x | x | x | |||
Salespersons | SalesPerson | SalesPerson | 135 | x | x | ||||||
Shipment Addresses | ShipmentAddress | ShipmentAddress | 143 | x | x | ||||||
Shipment Days | ShipmentDay | ShipmentDay | 144 | x | x | ||||||
Inventory Slips | Slip | Slip | 161 | x | x | x | x | x | x | Batch generation can be performed with Generate via order slips | |
Inventory Slip Lines | SlipLine | SlipLine | 162 | x | x | x | x | x | |||
Warehouse Inventory Status | StockTotal | x | x | It works through total views. Item/Variant /TrackingNumber can be entered. | |||||||
Material Unit Barcodes | UnitBarcode | UnitBarcode | 147 | x | x | x | x | x | |||
Users | SysUser | User | 106 | x | x | ||||||
Vehicles | Vehicle | Vehicle | 132 | x | x | ||||||
Warehouses | SysWarehouse | Warehouse | 121 | x | x | UserWarehouse control should be performed in background | |||||
Order Slips | WorkOrder | WorkOrder | 159 | x | x | x | x | x | x | Batch generation can be performed with Generate through order and planning. | |
Order Slip Lines | WorkOrderLine | WorkOrderLine | 160 | x | x | x | x | x |