qbfdecn.pur-schedinv

Buying Schedule Claim

Table details

Area	ProdData
Dumpname	schedinv
Label	Buying Schedule Claim
Val.exp	?
Val.msg

Fields

Order	Field Name	x	Label	Datatype	Format	Initial	Mand	Description
2	claim-no	X	claim-no	character	x(12)
320	date-capt	X	Date Captured	date	99/99/9999	?
300	doc-type	X	Document Type	logical	Invoice/Creditnote	TRUE
110	inv-amt	X	Invoice Amount	decimal-2	>>,>>>,>>9.99-	0
70	inv-date	X	Invoice Date	date	99/99/9999	?
250	inv-stat	X	Invoice Status	integer	9	0
20	inv-type	X	Invoice Type	character	!
3	sched-no	X	Schedule	character	X(8)	0
120	tax-amt	X	Tax Amount	decimal-2	>,>>>,>>9.99-	0
340	tax-incl-excl	X	Tax Incl/Excl	logical	Incl/Excl	Incl
330	tax-ind	X	Tax Ind	logical	Yes/No	Yes
1	trn-type	X	Transaction Type	character	x(3)
460	upd-date	X	Updated	date	99/99/9999	?
470	upd-time	X	At	integer	99999	0
450	upd-user-id	X	By	character	x(12)
10	vendor-inv-no	X	Vendor Invoice No	character	x(12)
5	vendor-no	X	Vendor No	character	x(6)

Indexes

Index name	Flags	Fields	Datatype
vendor-inv	P U	vendor-no (+)	character
		vendor-inv-no (+)	character
		doc-type (+)	logical
claim-no		trn-type (+)	character
		claim-no (+)	character
vendor-doc-inv		vendor-no (+)	character
		doc-type (+)	logical
		vendor-inv-no (+)	character
vendor-inv-no		vendor-inv-no (+)	character

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Related tables

Parent tables
acp-apinv inv-combocom inv-comboitem sys-trntype

generated 18-9-2026 10:03