Database Table "hyp_Return of Goods Note"
Table DescriptionThe 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 | |
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 |
Database Table "hyp_Return of Goods Note Items"
Table DescriptionThe 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 |