Database Table "hyp_Return of Goods Note"

Table Description

The Return of Goods Note main table of Hyper.

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name	English Title	Data Type	Text Length	Editor	Attributes	json
Return Note Number		Integer	0	Edit	Read Only Key Field	ReturnNoteNumber
Agency		Status	0	Select		Agency
Client Number		Integer	0	Edit	Hidden Read Only	ClientNumber
Client Full Name		String	105	SelectEdit		ClientFullName
Contact Person		String	105	PopupList		ContactPerson
Address		String	300	Memo		Address
Phone		Phone	20	SelectEdit		Phone
Email		String	80	Edit		Email
ID Number		Serial	20	Edit		IdNumber
Language		Status	0	Select		Language
International Document		Bool	0	Select		InternationalDocument
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	Total Goods Value in P.C.	Money	0	Edit	Read Only	TotalGrossInPc
Round off Amount		Money	0	Edit	Read Only	RoundOffAmount
Origin Production Time		FixDT	0	SelectEdit		OriginProductionTime
Produced By		String	40	Edit	Read Only	ProducedBy
Notes		String	600	Memo		Notes
Internal Notes		String	100	Edit		InternalNotes
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
Cancellation Time		FixDT	0	SelectEdit	Read Only	CancellationTime
Cancelled By		String	40	Edit	Read Only	CancelledBy
Cancellation Reason		String	50	Edit	Read Only	CancellationReason
Account Balance at Production Time		Money	0	Edit	Read Only	AccountBalanceAtProductionTime
Credit Line Usage (Risk) LC		Integer	0	Edit	Read Only	CreditLineUsageRiskLc

Jump to tables index

Database Table "hyp_Return of Goods Note Items"

Table Description

The list of items for the Return of Goods Note.

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name	English Title	Data Type	Text Length	Editor	Attributes	json
Return Note Number		Integer	0	Edit	Hidden Read Only Key Field	ReturnNoteNumber
Item ID		Real	0	Edit	Hidden Read Only Key Field	ItemId
Catalogic Number		String	30	Edit	Read Only	CatalogicNumber
Description		String	120	Edit		Description
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
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 Credit in Purchaser currency	Money	0	Edit	Read Only	TotalGrossInPc
Package Conversion Ratio		Real	0	Edit	Read Only	PackageConversionRatio
Package Quantity		Real	0	Edit		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
Client P.O.		String	20	Edit		ClientPO
Order Number		Real	0	Edit	Read Only	OrderNumber
Delivery Note Number		Integer	0	Edit	Read Only	DeliveryNoteNumber
Tax Invoice Number	Original Invoice	Integer	0	Edit	Read Only	TaxInvoiceNumber
Commitment ID		Integer	0	Edit	Read Only	CommitmentId
Tax Class		String	3	Select		TaxClass
Tax Rate Percent		Real	0	Edit	Read Only	TaxRatePercent
Sale Price Method	Values List: 0 = Net Price 1 = VAT included	Status	0	Select	Hidden Read Only	SalePriceMethod
Sale Quantity Method	Values List: 0 = Real Units 1 = Integer Units 2 = Whole Packages (Integer)	Status	0	Select	Hidden Read Only	SaleQuantityMethod

Jump to tables index