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 Description and Notes Data Type Text Length
Return Note Number The unique number of the Return Note in Hyper. Integer 0
Agency
Status 0
Drawer / Station ID Integer 0
Client Number Integer 0
Client Full Name String 135
Contact Person String 135
Address String 300
Phone Phone 20
Fax Phone 20
Email String 80
ID Number Serial 20
Directed to
Contact Person
Company
Status 0
Language
Status 0
International Document Bool 0
Purchaser Currency String 4
Rounding Off Bool 0
Tax Rate Percent Money 0
Total Tax Free LC Money 0
Total Tax Liable LC Money 0
Total Tax LC Money 0
Total Credit LC Total Goods Value Money 0
Total Credit on P.C. Total Credit in Purchaser currency Money 0
Origin Production Time FixDT 0
Produced By String 40
Notes String 600
Responsible Manager String 40
Old Doc Reference String 20
Old Software Name String 10
Cancellation Time FixDT 0
Cancelled By String 40
Cancellation Reason String 50
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 Description and Notes Data Type Text Length
Return Note Number The unique number of the Return Note. Integer 0
Item ID Real 0
Order Number Real 0
Catalogic Number String 30
Description String 120
Quantity Real 0
Unit of measure
Status 0
Tax-Free Selling Price Real 0
Taxable Selling Price Real 0
Selling Currency String 4
Discount % Real 0
Total Tax Free LC Money 0
Total Tax Liable LC Money 0
Total Tax LC Total VAT/GST Money 0
Total Credit LC Total Goods Value Money 0
Total Credit on P.C. Total Credit in Purchaser currency Money 0
Exchange Rate Real 0
Package Conversion Ratio Real 0
Package Conversion Unit
Status 0
Package Conversion Quantity Real 0
Delivery Note Number Integer 0
Tax Invoice Number Integer 0
Jump to tables index