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_Tax Invoice Items"

Table Description

The Tax Invoice items detalis.

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name	English Title	Data Type	Text Length	Editor	Attributes	json
Invoice Number		Integer	0	Edit	Hidden Read Only Key Field	InvoiceNumber
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
Client P.O.		String	20	Edit		ClientPO
Sale Source	Values List: 0 = None 1 = Started Here 2 = Order 3 = Delivery Note 4 = Transaction Invoice	Status	0	Select	Read Only	SaleSource
Order Number		Real	0	Edit	Read Only	OrderNumber
Trace SubRecord ID		Real	0	Edit	Hidden Read Only	TraceSubrecordId
Delivery Notes Reference		String	80	Edit	Read Only	DeliveryNotesReference
Manufacture / Delivery Date		Date	0	Edit	Read Only	ManufactureDeliveryDate
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 Price 1 = VAT included	Status	0	Select	Hidden Read Only	SalePriceMethod
Sale Quantity Method	Values List: 0 = Real Units 1 = Integer Units 2 = Whole Packages (Integer)	Status	0	Select	Hidden Read Only	SaleQuantityMethod

Jump to tables index