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.
Item/Variant/Lot groups return the related fields. The lot information is entered with the New method of this object.

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