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 = Cash1 = 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 Sale1 = 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 Quotation1 = 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 |