qbfdecn.pur-schedadv

Buying Schedule Claim Line

Table details

Order	Field Name	x	Label	Datatype	Format	Initial
150	acct-cde	X	Account Code	character	x(4)
110	adv-amt	X	Advised Amount	decimal-2	>>>,>>>,>>9.99-	0
70	adv-date	X	Advised Date	date	99/99/9999	?
170	area-cde	X	Area Code	character	x(3)
2	claim-no	X	Claim No	character	x(12)
145	claimable-ind	X	Claimable Tax	logical	Yes/No	NO
180	cost-cde	X	Cost Code	character	x(4)
7	doc-type	X	Document Type	logical	Invoice/Creditnote	TRUE
95	due-date	X	Due Date	date	99/99/9999	?
15	inv-ln	X	Invoice Line	integer	999	0
17	item-no	X	Item No	character	x(15)
20	ln-desc	X	Line Description	character	x(30)
190	oh-qty	X	Qty on Hand	decimal-2	>>>>>9.99-	0
140	tax-amt	X	Tax Amount	decimal-2	>,>>>,>>9.99-	0
133	tax-cat	X	Tax Category	character	X(2)
130	tax-cde	X	Tax Code	character	x(2)
200	tot-cost	X	Total Cost	decimal-2	>>,>>>,>>9.99-	0
1	trn-type	X	Transaction Type	character	x(3)
210	unit-prc	X	Unit Price	decimal-2	>,>>>,>>9.99	0
10	vendor-inv-no	X	Vendor Invoice No	character	x(12)
5	vendor-no	X	Vendor No	character	x(6)

Order	Field Name	x	Label	Datatype	Format	Initial
1	trn-type	X	Transaction Type	character	x(3)
2	claim-no	X	Claim No	character	x(12)
5	vendor-no	X	Vendor No	character	x(6)
7	doc-type	X	Document Type	logical	Invoice/Creditnote	TRUE
10	vendor-inv-no	X	Vendor Invoice No	character	x(12)
15	inv-ln	X	Invoice Line	integer	999	0
17	item-no	X	Item No	character	x(15)
20	ln-desc	X	Line Description	character	x(30)
70	adv-date	X	Advised Date	date	99/99/9999	?
95	due-date	X	Due Date	date	99/99/9999	?
110	adv-amt	X	Advised Amount	decimal-2	>>>,>>>,>>9.99-	0
130	tax-cde	X	Tax Code	character	x(2)
133	tax-cat	X	Tax Category	character	X(2)
140	tax-amt	X	Tax Amount	decimal-2	>,>>>,>>9.99-	0
145	claimable-ind	X	Claimable Tax	logical	Yes/No	NO
150	acct-cde	X	Account Code	character	x(4)
170	area-cde	X	Area Code	character	x(3)
180	cost-cde	X	Cost Code	character	x(4)
190	oh-qty	X	Qty on Hand	decimal-2	>>>>>9.99-	0
200	tot-cost	X	Total Cost	decimal-2	>>,>>>,>>9.99-	0
210	unit-prc	X	Unit Price	decimal-2	>,>>>,>>9.99	0

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

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Parent tables
acp-apadv icc-taxtyp inv-itemvar lsc-bp-acct sys-trntype

generated 24-6-2026 08:27