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 |