CInvoice


Field Name	Label	Col-Label	Format	Dec
BLWIGroup_ID	BLWI Group Code	BLWI Group	9999999999
CInvoice_ID	Record ID		9999999999
CInvoiceAllocationStatus	Allocation Status		x(20)
CInvoiceBalanceCC	SC Balance		->>>,>>>,>>>,>>9.99	4
CInvoiceBalanceCreditCC	SC Balance Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceBalanceCreditLC	BC Balance Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceBalanceCreditTC	TC Balance Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceBalanceDebitCC	SC Balance Amount (DR)		->>>,>>>,>>>,>>9.99	4
CInvoiceBalanceDebitLC	BC Balance Amount (DR)		->>>,>>>,>>>,>>9.99	4
CInvoiceBalanceDebitTC	TC Balance Amount (DR)		->>>,>>>,>>>,>>9.99	4
CInvoiceBalanceLC	BC Balance		->>>,>>>,>>>,>>9.99	4
CInvoiceBalanceTC	TC Balance		->>>,>>>,>>>,>>9.99	4
CInvoiceBatchNumber	Batch Number		x(8)
CInvoiceCCRate	SC Rate		->,>>>,>>9.9999999999	10
CInvoiceCCScale	SC Rate Scale		->,>>>,>>9.9999999999	10
CInvoiceCirecClosingDate	SIREC Closing Date		99/99/9999
CInvoiceCIText	Description		x(40)
CInvoiceClosingDate	Closing Date		99/99/9999
CInvoiceCommentNote	Comment		x(2000)
CInvoiceContact	Contact		x(40)
CInvoiceCreationDate	Creation Date		99/99/9999
CInvoiceCreationTimeString	Creation Time		x(10)
CInvoiceCreditorVatNumber	Supplier Tax Number		x(40)
CInvoiceCurrency_ID	Currency Code	Curr	9999999999
CInvoiceDate	Invoice Date	Inv Date	99/99/9999
CInvoiceDayBookSetCode	Supplier Daybook Set Code	Supplier Dybk Set Code	x(8)
CInvoiceDescription	Description		x(40)
CInvoiceDiscountDueDate	Discount Due Date		99/99/9999
CInvoiceDueDate	Due Date		99/99/9999
CInvoiceExchangeRate	Exchange Rate		->,>>>,>>9.9999999999	10
CInvoiceHoldAmountTC	TC Hold Amount		->>>,>>>,>>>,>>9.99	4
CInvoiceInvCertCertificate	Invoice Certificate		x(16)
CInvoiceInvCertKey	Invoice Certification Key		x(128)
CInvoiceInvCertSignatureCurr	Signature Current Invoice		x(256)
CInvoiceInvCertSignaturePrev	Signature Previous Invoice		x(256)
CInvoiceInvCertSignatureShort	Signature		x(4)
CInvoiceInvCertVersion	Version		x(8)
CInvoiceIsDiscTaxAtInv	Discount Tax at Invoice	Disc Tax at Inv	yes/no
CInvoiceIsDiscTaxAtPaym	Discount Tax at Payment	Disc Tax at Paym	yes/no
CInvoiceIsERS	ERS		yes/no
CInvoiceIsExternal	External	External Invoice	yes/no
CInvoiceIsInitialStatus	Initial Status		yes/no
CInvoiceIsInvoiceApproved	Approved		yes/no
CInvoiceIsLockPayment	Lock Payment	Lock Paym	yes/no
CInvoiceIsLogisticMatching	Receiver Matching		yes/no
CInvoiceIsOpen	Open		yes/no
CInvoiceIsSelected	Selected	Sel	yes/no
CInvoiceIsTaxable	Taxable	Tax	yes/no
CInvoiceIsTaxConfirmed	Tax Confirmed		yes/no
CInvoiceIsTaxExcluded	Tax Excluded	Tax Excl	yes/no
CInvoiceIsVatDelay	Tax Delay		yes/no
CInvoiceIsWHT	Withholding Tax		yes/no
CInvoiceIsWithBank	With Bank		yes/no
CInvoiceMFText	Description		x(40)
CInvoiceNonDiscAmtCC	SC Non-discount Amount		->>>,>>>,>>>,>>9.99	4
CInvoiceNonDiscAmtLC	BC Non-discount Amount		->>>,>>>,>>>,>>9.99	4
CInvoiceNonDiscAmtTC	TC Non-discount Amount		->>>,>>>,>>>,>>9.99	4
CInvoiceNonRecTaxAmtTC	Non-Recoverable Tax Amount	Non-Recov Tax Amt	->>>,>>>,>>>,>>9.99	4
CInvoiceOriginalCreditCC	SC Invoice Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceOriginalCreditLC	BC Invoice Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceOriginalCreditTC	TC Invoice Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceOriginalDebitCC	SC Invoice Amount (DR)		->>>,>>>,>>>,>>9.99	4
CInvoiceOriginalDebitLC	BC Invoice Amount (DR)		->>>,>>>,>>>,>>9.99	4
CInvoiceOriginalDebitTC	TC AP Amount		->>>,>>>,>>>,>>9.99	4
CInvoiceOwnVatNumber	Own Tax Number		x(40)
CInvoicePoDomain	PO Domain		x(8)
CInvoicePoNbr	PO Number		x(8)
CInvoicePostingDate	Posting Date		99/99/9999
CInvoicePostingPeriod	GL Period		99
CInvoicePostingYear	Year		9999
CInvoicePostingYearPeriod	Year/GL Period	GL Cal Yr/GL Pd	999999
CinvoiceRateScale	Scale Factor		->,>>>,>>9.9999999999	10
CInvoiceReference	Reference		x(22)
CInvoiceRegistrationNr	Registration Number		9999999999
CInvoiceSiteCode	Site		x(8)
CInvoiceTaxPointDate	Tax Point Date		99/99/9999
CInvoiceTSMNumber	Payment Reference		x(60)
CInvoiceType	Invoice Type		x(20)
CInvoiceVatBaseCreditCC	SC Tax Base Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceVatBaseCreditLC	BC Tax Base Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceVatBaseCreditTC	TC Tax Base Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceVatBaseDebitCC	SC Tax Base Amount (DR)		->>>,>>>,>>>,>>9.99	4
CInvoiceVatBaseDebitLC	BC Tax Base Amount (DR)		->>>,>>>,>>>,>>9.99	4
CInvoiceVatBaseDebitTC	TC Tax Base Amount (DR)		->>>,>>>,>>>,>>9.99	4
CInvoiceVatCreditCC	SC Tax Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceVatCreditLC	BC Tax Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceVatCreditTC	TC Tax Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceVatDebitCC	SC Tax Amount (DR)		->>>,>>>,>>>,>>9.99	4
CInvoiceVatDebitLC	BC Tax Amount (DR)		->>>,>>>,>>>,>>9.99	4
CInvoiceVatDebitTC	TC Tax Amount (DR)		->>>,>>>,>>>,>>9.99	4
CInvoiceVatExchangeRate	Tax Exchange Rate		->,>>>,>>9.9999999999	10
CInvoiceVatRateScale	Tax Rate Scale		->,>>>,>>9.9999999999	10
CInvoiceVoucher	Voucher		999999999
CInvoiceWHTBaseAmtCreditCC	SC WHT Base Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceWHTBaseAmtCreditLC	BC WHT Base Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceWHTBaseAmtCreditTC	TC WHT Base Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceWHTBaseAmtDebitCC	SC WHT Base Amount (DR)		->>>,>>>,>>>,>>9.99	4
CInvoiceWHTBaseAmtDebitLC	BC WHT Base Amount (DR)		->>>,>>>,>>>,>>9.99	4
CInvoiceWHTBaseAmtDebitTC	TC WHT Base Amount (DR)		->>>,>>>,>>>,>>9.99	4
CInvoiceWHTTotAmtCreditCC	SC WHT Total Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceWHTTotAmtCreditLC	BC WHT Total Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceWHTTotAmtCreditTC	TC WHT Total Amount (CR)		->>>,>>>,>>>,>>9.99	4
CInvoiceWHTTotAmtDebitCC	SC WHT Total Amount (DR)		->>>,>>>,>>>,>>9.99	4
CInvoiceWHTTotAmtDebitLC	BC WHT Total Amount (DR)		->>>,>>>,>>>,>>9.99	4
CInvoiceWHTTotAmtDebitTC	TC WHT Total Amount (DR)		->>>,>>>,>>>,>>9.99	4
Company_ID	Link to Company		9999999999
ControlGL_ID	Account		9999999999
CostCentre_ID	Cost Center		9999999999
Creditor_ID	Link to Creditor		9999999999
CreditorVatNumber_ID	Link to VatNumber		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)
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)
LinkedCInvoice_ID	Reference		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
PurchaseType_ID	Purchase Type		9999999999
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Reason_ID	Invoice Status Code		9999999999
ReplacedCInvoice_ID	Link to CInvoice		9999999999
Role_ID	Role Name		9999999999
ShipToAddress_ID	City		9999999999
TransactionEndCountry_ID	Country Code	Country	9999999999
TransactionStartCountry_ID	Country Code	Country	9999999999
VatCurrency_ID	Currency Code	Curr	9999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
	AllocStatus	no	CInvoiceAllocationStatus	yes	no
	CCidx	no	CostCentre_ID	yes	no
	CInvoiceCurrency	no	CInvoiceCurrency_ID	yes	no
	CInvoiceIsInvAppr	no	CInvoiceIsInvoiceApproved	yes	no
	CInvoiceIsLockPaym	no	CInvoiceIsLockPayment	yes	no
	CirecClosingDate	no	Company_ID	yes	no
			CInvoiceCirecClosingDate	yes	no
	Company	no	Company_ID	yes	no
	CompanyClosingDate	no	Company_ID	yes	no
			CInvoiceClosingDate	yes	no
	ControlGL	no	ControlGL_ID	yes	no
	CreationDate	no	CInvoiceCreationDate	yes	no
	Creditor	no	Creditor_ID	yes	no
	CyCredClosingDate	no	Company_ID	yes	no
			Creditor_ID	yes	no
			CInvoiceClosingDate	yes	no
	CyCredInvDate	no	Company_ID	yes	no
			Creditor_ID	yes	no
			CInvoiceDate	yes	no
	CyJrnlDateIdx	no	Company_ID	yes	no
			Journal_ID	yes	no
			CInvoicePostingDate	yes	no
	CyPeriodYearPeriod	no	Company_ID	yes	no
			CInvoicePostingYearPeriod	yes	no
	CyYearJrnlVoucher	no	Company_ID	yes	no
			CInvoicePostingYear	yes	no
			Journal_ID	yes	no
			CInvoiceVoucher	yes	no
	Division	no	Division_ID	yes	no
	EndCountryIdx	no	TransactionEndCountry_ID	yes	no
	InvoiceDateIDX	no	CInvoiceDate	yes	no
	IsInitialStatus	no	CInvoiceIsInitialStatus	yes	no
	IsLogisticMatching	no	CInvoiceIsLogisticMatching	yes	no
	IsOpen	no	CInvoiceIsOpen	yes	no
	IsSelected	no	CInvoiceIsSelected	yes	no
	IsWithBank	no	CInvoiceIsWithBank	yes	no
	Journal	no	Journal_ID	yes	no
	LastModIdx	no	LastModifiedDate	yes	no
	LinkedCIIdx	no	LinkedCInvoice_ID	yes	no
	NormPayCondIdx	no	NormalPaymentCondition_ID	yes	no
	Period	no	Period_ID	yes	no
	PostingDateIDX	no	CInvoicePostingDate	yes	no
	PostingYear	no	CInvoicePostingYear	yes	no
∗	Prim	yes	CInvoice_ID	yes	no
	Project	no	Project_ID	yes	no
	PurchaseType	no	PurchaseType_ID	yes	no
	ReasonIdx	no	Reason_ID	yes	no
	ReferenceIdx	no	CInvoiceReference	yes	no
	RegistrationNr	no	CInvoiceRegistrationNr	yes	no
	ReplacedCI	no	ReplacedCInvoice_ID	yes	no
	RoleIdx	no	Role_ID	yes	no
	ShipTo	no	ShipToAddress_ID	yes	no
	StartCountryIdx	no	TransactionStartCountry_ID	yes	no
	TSMIdx	no	CInvoiceTSMNumber	yes	no
	UniqueIdx	yes	Company_ID	yes	no
			CInvoiceRegistrationNr	yes	no
	VatCurrency	no	VatCurrency_ID	yes	no
	VatNumber	no	OwnVatNumber_ID	yes	no
	VatNumIdx	no	CreditorVatNumber_ID	yes	no
	ViewIndex	no	Company_ID	yes	no
			CInvoicePostingYear	yes	no
			CInvoicePostingPeriod	yes	no
			Journal_ID	yes	no
			CInvoiceVoucher	yes	no
	Voucher	no	CInvoiceVoucher	yes	no