Database Table "hyp_Orders"

Table Description

All of the orders details, that also include the clients details, payment methods, delivery details, etc.

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name	English Title	Data Type	Text Length	Editor	Attributes	json
Order Number		Real	0	Edit	Read Only Key Field	OrderNumber
Agency		Status	0	Select		Agency
Sales Agent		String	40	PopupList		SalesAgent
Client Number		Integer	0	Edit	Read Only	ClientNumber
Client Full Name		String	105	PopupList	Read Only Mandatory	ClientFullName
Contact Person		String	105	PopupList		ContactPerson
Language		Status	0	Select		Language
International Document		Bool	0	Select		InternationalDocument
Price List		String	50	Select		PriceList
Rounding Off		Bool	0	Select		RoundingOff
Total Net LC		Money	0	Edit	Read Only	TotalNetLc
Tax Rate Percent		Real	0	PopupList	Read Only	TaxRatePercent
Total Tax LC		Money	0	Edit	Read Only	TotalTaxLc
Total Gross LC		Money	0	Edit	Read Only	TotalGrossLc
Purchaser Currency		String	5	Select		PurchaserCurrency
Total Gross in PC		Money	0	Edit	Read Only	TotalGrossInPc
Payment Terms	Values List: 0 = Cash 1 = Standard Credit 2 = Extra Credit 3 = Monthly Payments 4 = Consignation 5 = None	Status	0	Select		PaymentTerms
Credit Months		Integer	0	Edit		CreditMonths
Credit Days		Integer	0	Edit		CreditDays
Due Date		Date	0	Edit	Read Only	DueDate
This offer is Valid for # Days		Integer	0	Edit		ThisOfferIsValidForDays
Don't Print SubTotal		Bool	0	Select		DonTPrintSubtotal
Print Order Contract		String	30	Select		PrintOrderContract
Subject		String	60	SelectEdit		Subject
Software Module	Values List: 0 = New Sale 1 = Service Order 2 = MRP Order 3 = Website 4 = POS Module 5 = Web API	Status	0	Select	Read Only	SoftwareModule
Client P.O.		String	20	Edit		ClientPO
Created On		FixDT	0	Edit	Read Only	CreatedOn
Created By		String	40	Edit	Read Only	CreatedBy
Last Update		FixDT	0	Edit	Read Only	LastUpdate
Updated By		String	40	Edit	Read Only	UpdatedBy
Status	Values List: 0 = Price Quotation 1 = Approved Quotation 2 = Cancelled while Negotiating 3 = Cancelled after Approval 4 = Sent to Production 5 = Cancelled - Alternative Offer Approved	Status	0	Select	Read Only	Status
Order Approved On		FixDT	0	SelectEdit	Read Only	OrderApprovedOn
Offer/Order Cancelled On		FixDT	0	SelectEdit	Read Only	OfferOrderCancelledOn
Order Sent to Production On		FixDT	0	SelectEdit	Read Only	OrderSentToProductionOn
Last Confirmation Step		String	30	Edit	Read Only	LastConfirmationStep
Next Confirmation Step		String	30	Edit	Read Only	NextConfirmationStep
Next Confirmation Step Deadline		Date	0	SelectEdit	Read Only	NextConfirmationStepDeadline
Middleman Account		Integer	0	Edit	Read Only	MiddlemanAccount
Middleman Name		String	105	PopupList		MiddlemanName
Gross Profit LC		Money	0	Edit	Read Only	GrossProfitLc
Requested Delivery Date		FixDT	0	SelectEdit		RequestedDeliveryDate
Final Delivery Date		FixDT	0	SelectEdit	Read Only	FinalDeliveryDate
Delivery Address		String	100	PopupEdit		DeliveryAddress
City		String	40	PopupEdit		City
Region		String	40	PopupEdit		Region
Country		String	40	Select		Country
Distribution Area		String	40	Edit	Read Only	DistributionArea
Need Crane to Floor Number		Integer	0	Edit		NeedCraneToFloorNumber
Delivery Channel		String	20	Edit	Read Only	DeliveryChannel
Delivery Channel Attrib		String	1	Edit	Hidden Read Only	DeliveryChannelAttrib
Unloading Order		Integer	0	Edit	Read Only	UnloadingOrder
Project Number		Integer	0	Edit	Read Only	ProjectNumber
Project Title		String	100	Edit	Read Only	ProjectTitle
Project Entrepreneur		String	100	Edit	Read Only	ProjectEntrepreneur
Location in Project Map		String	100	Edit	Read Only	LocationInProjectMap
Credit Client due to Project		Money	0	Edit	Read Only	CreditClientDueToProject
Order Header		String	800	Memo		OrderHeader
Order Footer		String	1500	Memo		OrderFooter
Inhouse Operational Notes		String	1500	Memo		InhouseOperationalNotes
Responsible Manager		String	40	PopupList	Read Only	ResponsibleManager
Old Doc Reference		String	20	Edit	Read Only	OldDocReference
Old Software Name		String	10	Edit	Read Only	OldSoftwareName
Spare Agent 1		String	40	PopupList		SpareAgent1
Spare Agent 2		String	40	PopupList		SpareAgent2
CAD File Extention		String	5	Edit	Hidden Read Only	CadFileExtention
CAD File Name		String	20	Edit	Hidden Read Only	CadFileName

Jump to tables index

Database Table "hyp_Order Items"

Table Description

The Order Items and their details.

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name	English Title	Data Type	Text Length	Editor	Attributes	json
Order Number		Real	0	Edit	Hidden Read Only Key Field	OrderNumber
Item ID		Real	0	Edit	Hidden Read Only Key Field	ItemId
Catalogic Number		String	30	Edit	Read Only	CatalogicNumber
Product Name		String	120	Edit		ProductName
Quantity		Real	0	Edit		Quantity
Unit of measure		Status	0	Select		UnitOfMeasure
Net Sale Price		Real	0	Edit		NetSalePrice
Gross Sale Price		Money	0	Edit		GrossSalePrice
Sale Currency		String	5	Select		SaleCurrency
Sale Price Method	Values List: 0 = Net Price 1 = VAT included	Status	0	Select	Hidden Read Only	SalePriceMethod
Exchange Rate		Real	0	Edit	Read Only	ExchangeRate
Discount %		Real	0	Edit		Discount_Percent
Total Net LC		Money	0	Edit	Read Only	TotalNetLc
Total Tax LC		Money	0	Edit	Read Only	TotalTaxLc
Total Gross LC		Money	0	Edit	Read Only	TotalGrossLc
Total Gross in PC	Total Charge in Purchaser currency	Money	0	Edit	Read Only	TotalGrossInPc
Warranty Period in months		Real	0	Edit		WarrantyPeriodInMonths
Package Conversion Ratio		Real	0	Edit	Read Only	PackageConversionRatio
Package Quantity		Real	0	Edit	Read Only	PackageQuantity
Package Unit		Status	0	Select	Read Only	PackageUnit
Unit Weight kg		Real	0	Edit		UnitWeightKg
Package Weight kg		Real	0	Edit	Read Only	PackageWeightKg
Commitment ID		Integer	0	Edit	Read Only	CommitmentId
Discount Note		String	50	Edit		DiscountNote
Discount Type		String	1	Edit	Hidden Read Only	DiscountType
Unit Width mm		Real	0	Edit		UnitWidthMm
Unit Height mm		Real	0	Edit		UnitHeightMm
Unit Depth mm		Real	0	Edit		UnitDepthMm
Net Cost Price		Real	0	Edit		NetCostPrice
Cost Currency		String	5	Select		CostCurrency
Manual Product Name		String	1	Edit	Hidden Read Only	ManualProductName

Jump to tables index

Database Table "hyp_Client Open Billing or Supply"

Table Description

Tracking production, supply and customer billing according to orders. Delivered and charged records, will be archived.

Normal Storage

Relevant Tracking records for supply and billing

Archive Storage

Tracking records that were fully delivered and charged.

Deleted Storage(Recycle)

Field Name	English Title	Data Type	Text Length	Editor	Attributes	json
Client Number		Integer	0	Edit	Hidden Read Only Key Field	ClientNumber
SubRecord ID		Real	0	Edit	Hidden Read Only Key Field	SubrecordId
Sale Source	Values List: 0 = None 1 = Order 2 = Delivery Note 3 = Transaction Invoice 4 = Tax Invoice	Status	0	Select	Read Only	SaleSource
Client P.O.		String	20	Edit	Read Only	ClientPO
Order Number		Real	0	Edit	Read Only	OrderNumber
Item ID		Real	0	Edit	Hidden Read Only	ItemId
Catalogic Number		String	30	Edit	Read Only	CatalogicNumber
Description		String	120	Edit	Read Only	Description
Quantity		Real	0	Edit	Read Only	Quantity
Unit of measure		Status	0	Select	Read Only	UnitOfMeasure
Deadline		FixDT	0	SelectEdit		Deadline
Quantity Ready to Supply		Real	0	Edit	Read Only	QuantityReadyToSupply
Quantity on Delivery Note		Real	0	Edit	Read Only	QuantityOnDeliveryNote
Quantity on Tax Invoice		Real	0	Edit	Read Only	QuantityOnTaxInvoice
Production Order On		FixDT	0	SelectEdit	Read Only	ProductionOrderOn
Production Order By		String	40	Edit	Read Only	ProductionOrderBy
Commitment ID		Integer	0	Edit	Read Only	CommitmentId
Prepaid		Bool	0	Select	Read Only	Prepaid
Integer Unit Quantity		Bool	0	Select	Hidden Read Only	IntegerUnitQuantity
PP&C Handling		Bool	0	Select	Hidden Read Only	PpCHandling
Delivery Notes Reference		String	80	Edit	Read Only	DeliveryNotesReference

Jump to tables index

Database Table "hyp_Client Contract"

Table Description

This table contains the prepaid products of the client as well as their details and the amount of supplied units. The fields of this table are displayed in the "Committed Prepaid Products" in the Clients sales rules, and according to the definitions of the pre-paid Tax Invoice.

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name	English Title	Data Type	Text Length	Editor	Attributes	json
Client Number		Integer	0	Edit	Hidden Read Only Key Field	ClientNumber
Commitment ID		Integer	0	Edit	Read Only Key Field	CommitmentId
Catalogic Number		String	30	PopupList	Mandatory	CatalogicNumber
Product Name		String	120	Edit	Read Only	ProductName
Prepaid		Bool	0	Select	Read Only	Prepaid
Committed Until Date		Date	0	SelectEdit	Mandatory /G:1	CommittedUntilDate
Committed Units		Real	0	Edit	Mandatory /G:1	CommittedUnits
Net Sale Price		Real	0	Edit		NetSalePrice
Gross Sale Price		Money	0	Edit		GrossSalePrice
Sale Price Method	Values List: 0 = Net Price 1 = VAT included	Status	0	Select	Read Only	SalePriceMethod
Sale Currency		String	5	Select	Mandatory	SaleCurrency
Units Supplied		Real	0	Edit	Read Only	UnitsSupplied
Tax Class		String	3	Select		TaxClass

Jump to tables index