Database Table "hyp_Tax Invoice"

Table Description

Tax Invoice - Document Title

Normal Storage

All Data Stored Here

Archive Storage

Not In Use

Deleted Storage(Recycle)

Not In Use
Field Name English Title Data Type Text Length Editor Attributes json
Invoice Number Integer 0 Edit Read Only
Key Field		 InvoiceNumber
Agency Status 0 Select Agency
Drawer / Station ID Integer 0 Edit Read Only DrawerStationId
Sales Agent String 40 PopupList SalesAgent
Client Number Integer 0 Edit Hidden
Read Only
Mandatory		 ClientNumber
Client Full Name String 105 SelectEdit Mandatory 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 Class String 3 Select TaxClass
Tax Rate Percent Real 0 Edit 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 Mandatory PurchaserCurrency
Total Gross in PC Total Charge in Purchaser currency Money 0 Edit Read Only TotalGrossInPc
Round off Amount Money 0 Edit Read Only RoundOffAmount
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
Origin Production Time FixDT 0 SelectEdit OriginProductionTime
Produced By String 40 Edit Read Only ProducedBy
Electronic Signed PDF
Values List:
0 = No
1 = Produced & Sent
2 = Waiting in queue		 Status 0 Select Read Only ElectronicSignedPdf
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
Sale Opportunity Integer 0 PopupList SaleOpportunity
Bundled with Receipt Number Integer 0 Edit Hidden
Read Only		 BundledWithReceiptNumber
Authorities Invoice Mode
Values List:
0 = Standard Tax Invoice
1 = Reverse Charge - Mode 1
2 = Reverse Charge - Mode 2		 Status 0 Select AuthoritiesInvoiceMode
Revenue Account Number Integer 0 PopupList RevenueAccountNumber
Assign Journal Entries to Parent Integer 0 Edit Hidden
Read Only		 AssignJournalEntriesToParent
Account Country Code String 2 Edit Read Only AccountCountryCode
Authorities Invoice ID Integer 0 Edit Read Only AuthoritiesInvoiceId
Authorities Invoice API Time UTC FixDT 0 SelectEdit Read Only AuthoritiesInvoiceApiTimeUtc
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_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_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

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