Database Table "hyp_Credit Invoice"
Table Description
Credit invoice tableNormal Storage |
Archive Storage |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| Credit Invoice Number | Integer | 0 | Edit | Read Only Key Field |
CreditInvoiceNumber | |
| Agency | Status | 0 | Select | Agency | ||
| Drawer / Station ID | Integer | 0 | Edit | Read Only | DrawerStationId | |
| 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 | ||
| 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 Rate Percent | Real | 0 | PopupList | 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 Credit in Purchaser currency | 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 | |
| Electronic Signed PDF | Values List: 0 = No1 = Produced & Sent 2 = Waiting in queue |
Status | 0 | Select | Read Only | ElectronicSignedPdf |
| Assign Journal Entries to Parent | Integer | 0 | Edit | Hidden Read Only |
AssignJournalEntriesToParent | |
| 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 | |
| Revenue Account Number | Integer | 0 | PopupList | RevenueAccountNumber | ||
| Account Balance at Production Time | Money | 0 | Edit | Read Only | AccountBalanceAtProductionTime | |
| Credit Line Usage (Risk) LC | Integer | 0 | Edit | Read Only | CreditLineUsageRiskLc |
Database Table "hyp_Credit Invoice Items"
Table Description
This table contains the items for the credit invoice.Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| Credit Invoice Number | Integer | 0 | Edit | Hidden Read Only Key Field |
CreditInvoiceNumber | |
| 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 Credit in Purchaser currency | Money | 0 | Edit | Read Only | TotalGrossInPc |
| 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 | |
| Client P.O. | String | 20 | Edit | ClientPO | ||
| Order Number | Real | 0 | Edit | Read Only | OrderNumber | |
| Delivery Note Number | Integer | 0 | Edit | Read Only | DeliveryNoteNumber | |
| Tax Invoice Number | Original Invoice | Integer | 0 | Edit | Read Only | TaxInvoiceNumber |
| Prepaid ID | Integer | 0 | Edit | Read Only | PrepaidId | |
| Commitment ID | Integer | 0 | Edit | Read Only | CommitmentId | |
| Revenue Account Number | Integer | 0 | PopupList | RevenueAccountNumber | ||
| 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 |