Database Table "hyp_Purchase Order"
Table Description
The purchase order table, for the organizations suppliers.Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| PO Number | Integer | 0 | Edit | Read Only Key Field |
PoNumber | |
| Agency | Status | 0 | Select | Read Only | Agency | |
| Supplier Number | Integer | 0 | Edit | Hidden Read Only Mandatory |
SupplierNumber | |
| Supplier Full Name | String | 105 | SelectEdit | Mandatory | SupplierFullName | |
| Contact Person | String | 105 | PopupList | ContactPerson | ||
| Address | String | 300 | Memo | Address | ||
| Phone | Phone | 20 | SelectEdit | Phone | ||
| String | 80 | Edit | ||||
| 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 | Money | 0 | Edit | Read Only | TotalGrossInPc | |
| Round off Amount | Money | 0 | Edit | Read Only | RoundOffAmount | |
| 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 | |
| Origin Production Time | FixDT | 0 | SelectEdit | OriginProductionTime | ||
| Produced By | String | 40 | Edit | Read Only | ProducedBy | |
| Electronic Signed PDF | Values List: 0 = No1 = 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 | |
| Account Country Code | String | 2 | Edit | Read Only | AccountCountryCode |
Database Table "hyp_Purchase Order Items"
Table Description
The purchase order items table.Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| PO Number | Integer | 0 | Edit | Hidden Read Only Key Field |
PoNumber | |
| Item ID | Real | 0 | Edit | Hidden Read Only Key Field |
ItemId | |
| Catalogic Number | String | 30 | Edit | Read Only | CatalogicNumber | |
| Description | String | 120 | Edit | Description | ||
| Quantity | Real | 0 | Edit | Quantity | ||
| Unit of measure | Status | 0 | Select | UnitOfMeasure | ||
| Net Sale Price | Real | 0 | Edit | NetSalePrice | ||
| Gross Sale Price | Money | 0 | Edit | GrossSalePrice | ||
| Sale Currency | String | 5 | Select | SaleCurrency | ||
| Exchange Rate | Real | 0 | Edit | Read Only | ExchangeRate | |
| Discount % | Real | 0 | Edit | Discount_Percent | ||
| Total Net LC | Money | 0 | Edit | Read Only | TotalNetLc | |
| Total Tax LC | Money | 0 | Edit | Read Only | TotalTaxLc | |
| Total Gross LC | Money | 0 | Edit | Read Only | TotalGrossLc | |
| Total Gross in PC | Total Charge in Purchaser currency | Money | 0 | Edit | Read Only | TotalGrossInPc |
| Warranty Period in months | Real | 0 | Edit | WarrantyPeriodInMonths | ||
| Package Conversion Ratio | Real | 0 | Edit | Read Only | PackageConversionRatio | |
| Package Quantity | Real | 0 | Edit | PackageQuantity | ||
| Package Unit | Status | 0 | Select | Read Only | PackageUnit | |
| Unit Weight kg | Real | 0 | Edit | UnitWeightKg | ||
| Package Weight kg | Real | 0 | Edit | Read Only | PackageWeightKg | |
| Tax Class | String | 3 | Select | TaxClass | ||
| Tax Rate Percent | Real | 0 | Edit | Read Only | TaxRatePercent | |
| Sale Price Method | Values List: 0 = Net Price1 = VAT included |
Status | 0 | Select | Hidden Read Only |
SalePriceMethod |
| Sale Quantity Method | Values List: 0 = Real Units1 = Integer Units 2 = Whole Packages (Integer) |
Status | 0 | Select | Hidden Read Only |
SaleQuantityMethod |
| Back to Back Order Number | Real | 0 | Edit | Read Only | BackToBackOrderNumber | |
| Quantity Supplied | Real | 0 | Edit | Read Only | QuantitySupplied | |
| Quantity on Tax Invoice | Real | 0 | Edit | Read Only | QuantityOnTaxInvoice |