DInvoice


Field Name	Label	Col-Label	Format	Dec
Bill_ID	Link to Bill		9999999999
Company_ID	Link to Company		9999999999
ControlGL_ID	Account		9999999999
CostCentre_ID	Cost Center		9999999999
CustomCombo0	Custom Combo Field		x(20)
CustomCombo1	Custom Combo Field		x(20)
CustomCombo10	Custom Combo Field		x(20)
CustomCombo11	Custom Combo Field		x(20)
CustomCombo12	Custom Combo Field		x(20)
CustomCombo13	Custom Combo Field		x(20)
CustomCombo14	Custom Combo Field		x(20)
CustomCombo2	Custom Combo Field		x(20)
CustomCombo3	Custom Combo Field		x(20)
CustomCombo4	Custom Combo Field		x(20)
CustomCombo5	Custom Combo Field		x(20)
CustomCombo6	Custom Combo Field		x(20)
CustomCombo7	Custom Combo Field		x(20)
CustomCombo8	Custom Combo Field		x(20)
CustomCombo9	Custom Combo Field		x(20)
CustomDate0	Custom Date Field		99/99/9999
CustomDate1	Custom Date Field		99/99/9999
CustomDate2	Custom Date Field		99/99/9999
CustomDate3	Custom Date Field		99/99/9999
CustomDate4	Custom Date Field		99/99/9999
CustomDate5	Custom Date Field		99/99/9999
CustomDate6	Custom Date Field		99/99/9999
CustomDate7	Custom Date Field		99/99/9999
CustomDate8	Custom Date Field		99/99/9999
CustomDate9	Custom Date Field		99/99/9999
CustomDecimal0	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal1	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal10	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal11	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal12	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal13	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal14	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal2	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal3	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal4	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal5	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal6	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal7	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal8	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal9	Custom Decimal Field		->,>>>,>>9.99	4
CustomInteger0	Custom Integer Field		->,>>>,>>9
CustomInteger1	Custom Integer Field		->,>>>,>>9
CustomInteger2	Custom Integer Field		->,>>>,>>9
CustomInteger3	Custom Integer Field		->,>>>,>>9
CustomInteger4	Custom Integer Field		->,>>>,>>9
CustomLong0	Custom Long Field		x(255)
CustomLong1	Custom Long Field		x(255)
CustomNote	Custom Note Field		x(2000)
CustomShort0	Custom Short Field		x(20)
CustomShort1	Custom Short Field		x(20)
CustomShort10	Custom Short Field		x(20)
CustomShort11	Custom Short Field		x(20)
CustomShort12	Custom Short Field		x(20)
CustomShort13	Custom Short Field		x(20)
CustomShort14	Custom Short Field		x(20)
CustomShort15	Custom Short Field		x(20)
CustomShort16	Custom Short Field		x(20)
CustomShort17	Custom Short Field		x(20)
CustomShort18	Custom Short Field		x(20)
CustomShort19	Custom Short Field		x(20)
CustomShort2	Custom Short Field		x(20)
CustomShort3	Custom Short Field		x(20)
CustomShort4	Custom Short Field		x(20)
CustomShort5	Custom Short Field		x(20)
CustomShort6	Custom Short Field		x(20)
CustomShort7	Custom Short Field		x(20)
CustomShort8	Custom Short Field		x(20)
CustomShort9	Custom Short Field		x(20)
Debtor_ID	Link to Debtor		9999999999
DebtorVatNumber_ID	Link to VatNumber		9999999999
DeliveryCond_ID	Link to DeliveryCond		9999999999
DInvoice_ID	Record ID		9999999999
DInvoiceBalanceCC	SC Balance		->>>,>>>,>>>,>>9.99	4
DInvoiceBalanceCreditCC	SC Balance Amount (CR)		->>>,>>>,>>>,>>9.99	4
DInvoiceBalanceCreditLC	BC Balance Amount (CR)		->>>,>>>,>>>,>>9.99	4
DInvoiceBalanceCreditTC	TC Balance Amount (CR)		->>>,>>>,>>>,>>9.99	4
DInvoiceBalanceDebitCC	SC Balance Amount (DR)		->>>,>>>,>>>,>>9.99	4
DInvoiceBalanceDebitLC	BC Balance Amount (DR)		->>>,>>>,>>>,>>9.99	4
DInvoiceBalanceDebitTC	TC Balance Amount (DR)		->>>,>>>,>>>,>>9.99	4
DInvoiceBalanceLC	BC Balance		->>>,>>>,>>>,>>9.99	4
DInvoiceBalanceTC	TC Balance		->>>,>>>,>>>,>>9.99	4
DInvoiceBatch	Batch Number		x(8)
DInvoiceBillDate	Bill Date		99/99/9999
DInvoiceCCRate	SC Rate		->,>>>,>>9.9999999999	10
DInvoiceCCScale	SC Rate Scale		->,>>>,>>9.9999999999	10
DInvoiceClosingDate	Closing Date		99/99/9999
DInvoiceCombinedStatus	Status		x(20)
DInvoiceComm1	% Commission	% Commission 1	>>9.99	2
DInvoiceComm2	% Commission	% Commission 2	>>9.99	2
DInvoiceComm3	% Commission	% Commission 3	>>9.99	2
DInvoiceComm4	% Commission	% Commission 4	>>9.99	2
DInvoiceCommentNote	Comments		x(2000)
DInvoiceContact	Contact		x(40)
DInvoiceCreationDate	Creation Date		99/99/9999
DInvoiceCreationTimeString	Creation Time		x(10)
DInvoiceCurrency_ID	Currency Code	Curr	9999999999
DInvoiceDate	Invoice Date	Inv Date	99/99/9999
DInvoiceDebtorVatNumber	Customer Tax Number		x(40)
DInvoiceDescription	Description		x(40)
DInvoiceDiscountDueDate	Discount Due Date		99/99/9999
DInvoiceDiscPercentage	Discount Percentage		->>9.99	2
DInvoiceDIText	Description		x(40)
DInvoiceDueDate	Due Date		99/99/9999
DInvoiceExchangeRate	Exchange Rate		->,>>>,>>9.9999999999	10
DInvoiceGoldenTaxInvoiceList	Golden Tax Invoices	GT Invoices	x(255)
DInvoiceGraceDays	Grace Days		->,>>>,>>9
DInvoiceInvCertCertificate	Invoice Certificate		x(16)
DInvoiceInvCertKey	Invoice Certification Key		x(128)
DInvoiceInvCertSignatureCurr	Signature Current Invoice		x(256)
DInvoiceInvCertSignaturePrev	Signature Previous Invoice		x(256)
DInvoiceInvCertSignatureShort	Signature		x(4)
DInvoiceInvCertVersion	Version		x(8)
DInvoiceIsDiscTaxAtInv	Discount Tax at Invoice		yes/no
DInvoiceIsDiscTaxAtPaym	Discount Tax at Payment		yes/no
DInvoiceIsExternal	External	External Invoice	yes/no
DInvoiceIsOpen	Open		yes/no
DInvoiceIsPaymentAllowed	CN Payment Allowed		yes/no
DInvoiceIsSelected	Selected	Sel	yes/no
DInvoiceIsTaxable	Taxable		yes/no
DInvoiceIsTaxExcluded	Tax Excluded	Tax Excl	yes/no
DInvoiceIsVatDelay	Tax Delay		yes/no
DInvoiceIsWithBank	With Bank		yes/no
DInvoiceIsWithDeduction	With Deduction		yes/no
DInvoiceLastFinChargeDate	Last Finance Charge Date		99/99/9999
DinvoiceLastReminderDate	Last Reminder Date		99/99/9999
DInvoiceLateInt	Late Interest		->>9.99	2
DInvoiceLegalDocumentList	Legal Documents		x(255)
DInvoiceMarginAmountTC	Margin Amount		->>>,>>>,>>>,>>9.99	4
DInvoiceNonDiscAmtCC	SC Non-disc Amt		->>>,>>>,>>>,>>9.99	4
DInvoiceNonDiscAmtLC	BC Non-disc Amt		->>>,>>>,>>>,>>9.99	4
DInvoiceNonDiscAmtTC	TC Non-disc Amt		->>>,>>>,>>>,>>9.99	4
DInvoiceOriginalCreditCC	SC Invoice Amount (CR)		->>>,>>>,>>>,>>9.99	4
DInvoiceOriginalCreditLC	BC Invoice Amount (CR)		->>>,>>>,>>>,>>9.99	4
DInvoiceOriginalCreditTC	TC Invoice Amount (CR)		->>>,>>>,>>>,>>9.99	4
DInvoiceOriginalDebitCC	SC Invoice Amount (DR)		->>>,>>>,>>>,>>9.99	4
DInvoiceOriginalDebitLC	BC Invoice Amount (DR)		->>>,>>>,>>>,>>9.99	4
DInvoiceOriginalDebitTC	TC Invoice Amount (DR)		->>>,>>>,>>>,>>9.99	4
DInvoiceOwnVatNumber	Own Tax Number		x(40)
DInvoicePaymentDate	Expected Payment Date		99/99/9999
DInvoicePostingDate	Posting Date		99/99/9999
DInvoicePostingPeriod	GL Period		99
DInvoicePostingYear	Year		9999
DInvoicePostingYearPeriod	Year/GL Period	GL Cal Yr/GL Pd	999999
DInvoicePurchaseOrder	Purchase Order		x(22)
DInvoiceRateScale	Scale Factor		->,>>>,>>9.9999999999	10
DInvoiceReminderCount	Reminder Counter		->,>>>,>>9
DInvoiceSalesAmt	Sales Amount		->>>,>>>,>>>,>>9.99	4
DInvoiceSalesOrderList	Sales Orders		x(255)
DInvoiceShipperList	Shippers		x(255)
DInvoiceShipToCode	Ship-To Code		x(8)
DInvoiceSlsPsn1	Salesperson 1		x(8)
DInvoiceSlsPsn2	Salesperson 2		x(8)
DInvoiceSlsPsn3	Salesperson 3		x(8)
DInvoiceSlsPsn4	Salesperson 4		x(8)
DInvoiceTaxPointDate	Tax Point Date		99/99/9999
DInvoiceTSMNumber	Payment Reference		x(40)
DInvoiceType	Type		x(20)
DInvoiceVatBaseCreditCC	SC Tax Base Amount (CR)		->>>,>>>,>>>,>>9.99	4
DInvoiceVatBaseCreditLC	BC Tax Base Amount (CR)		->>>,>>>,>>>,>>9.99	4
DInvoiceVatBaseCreditTC	TC Tax Base Amount (CR)		->>>,>>>,>>>,>>9.99	4
DInvoiceVatBaseDebitCC	SC Tax Base Amount (DR)		->>>,>>>,>>>,>>9.99	4
DInvoiceVatBaseDebitLC	BC Tax Base Amount (DR)		->>>,>>>,>>>,>>9.99	4
DInvoiceVatBaseDebitTC	TC Tax Base Amount (DR)		->>>,>>>,>>>,>>9.99	4
DInvoiceVatCreditCC	SC Tax Amount (CR)		->>>,>>>,>>>,>>9.99	4
DInvoiceVatCreditLC	BC Tax Amount (CR)		->>>,>>>,>>>,>>9.99	4
DInvoiceVatCreditTC	TC Tax Amount (CR)		->>>,>>>,>>>,>>9.99	4
DInvoiceVatDebitCC	SC Tax Amount (DR)		->>>,>>>,>>>,>>9.99	4
DInvoiceVatDebitLC	BC Tax Amount (DR)		->>>,>>>,>>>,>>9.99	4
DInvoiceVatDebitTC	TC Tax Amount (DR)		->>>,>>>,>>>,>>9.99	4
DInvoiceVatExchangeRate	Tax Exchange Rate		->,>>>,>>9.9999999999	10
DInvoiceVatRateScale	Tax Rate Scale		->,>>>,>>9.9999999999	10
DInvoiceVoucher	Voucher		999999999
Division_ID	Sub-Account	Sub-Acct	9999999999
Journal_ID	Daybook Code		9999999999
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
LinkedDInvoice_ID	Voucher		9999999999
NormalPaymentCondition_ID	Credit Terms Code	Cred Trm	9999999999
OwnVatNumber_ID	Link to VatNumber		9999999999
Period_ID	Link to Period		9999999999
Project_ID	Project		9999999999
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Reason_ID	Invoice Status Code		9999999999
ShipFromAddress_ID	Address		9999999999
ShipToAddress_ID	City		9999999999
SoldToDebtor_ID	Customer Code		9999999999
TransactionEndCountry_ID	Country Code	Country	9999999999
TransactionStartCountry_ID	Country Code	Country	9999999999
VatCurrency_ID	Tax Declaration Currency	Tax Currency	9999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
	BillIdx	no	Bill_ID	yes	no
	CCIdx	no	CostCentre_ID	yes	no
	CombinedStatus	no	DInvoiceCombinedStatus	yes	no
	Company	no	Company_ID	yes	no
	CompanyClosingDate	no	Company_ID	yes	no
			DInvoiceClosingDate	yes	no
	ControlGL	no	ControlGL_ID	yes	no
	CyDebInvDate	no	Company_ID	yes	no
			Debtor_ID	yes	no
			DInvoiceDate	yes	no
	CyDebtorClosingDate	no	Company_ID	yes	no
			Debtor_ID	yes	no
			DInvoiceClosingDate	yes	no
	CyJrnlDateIdx	no	Company_ID	yes	no
			Journal_ID	yes	no
			DInvoicePostingDate	yes	no
	CyPeriodYearPeriod	no	Company_ID	yes	no
			DInvoicePostingYearPeriod	yes	no
	Debtor	no	Debtor_ID	yes	no
	DebtorVatNumber	no	DebtorVatNumber_ID	yes	no
	Deduct	no	DInvoiceIsWithDeduction	yes	no
	DelCondIdx	no	DeliveryCond_ID	yes	no
	DInvoiceCurrency	no	DInvoiceCurrency_ID	yes	no
	DInvoiceDITextIdx	no	DInvoiceDIText	yes	no
	DInvoicePostingYear	no	DInvoicePostingYear	yes	no
	Division	no	Division_ID	yes	no
	EndCountryIdx	no	TransactionEndCountry_ID	yes	no
	InvoiceDateIDX	no	DInvoiceDate	yes	no
	IsOpen	no	DInvoiceIsOpen	yes	no
	IsSelected	no	DInvoiceIsSelected	yes	no
	IsWithBank	no	DInvoiceIsWithBank	yes	no
	Journal	no	Journal_ID	yes	no
	LastModIdx	no	LastModifiedDate	yes	no
	LinkedDInvoice	no	LinkedDInvoice_ID	yes	no
	NormPayCondIdx	no	NormalPaymentCondition_ID	yes	no
	OwnVatIdx	no	OwnVatNumber_ID	yes	no
	Period	no	Period_ID	yes	no
	POIdx	no	DInvoicePurchaseOrder	yes	no
	PostingDateIDX	no	DInvoicePostingDate	yes	no
∗	Prim	yes	DInvoice_ID	yes	no
	Project	no	Project_ID	yes	no
	ReasonIdx	no	Reason_ID	yes	no
	ShipFrom	no	ShipFromAddress_ID	yes	no
	ShipTo	no	SoldToDebtor_ID	yes	no
	ShipToIdx	no	ShipToAddress_ID	yes	no
	StartCountryIdx	no	TransactionStartCountry_ID	yes	no
	TSMIdx	no	DInvoiceTSMNumber	yes	no
	UniqueIdx	yes	Company_ID	yes	no
			DInvoicePostingYear	yes	no
			Journal_ID	yes	no
			DInvoiceVoucher	yes	no
	VatCurrency	no	VatCurrency_ID	yes	no
	ViewIndex	no	Company_ID	yes	no
			DInvoicePostingYear	yes	no
			DInvoicePostingPeriod	yes	no
			Journal_ID	yes	no
			DInvoiceVoucher	yes	no
	Voucher	no	DInvoiceVoucher	yes	no