qbfdebr.sys-branch

Branch Details

Table details

Order	Field Name	x	Label	Datatype	Format	Initial
110	apu-days	X	APU Days	integer	>9	0
20	branch-name	X	Branch Name	character	x(30)
10	branch-no	X	Branch	integer	999	0
190	branch-type	X	Branch Type	character	X
100	cal-cde	X	Calendar Code	character	!!!
210	comp-id	X	Company Id	character	x(6)
120	ctrl-area-cde	X	Ctrl Area	character	x(3)
130	ctrl-cost-cde	X	Ctrl Cost	character	x(4)
150	e-mail	X	E-Mail	character	x(24)
80	fax-no	X	Fax No	character	x(15)
60	laser-printer	X	Laser Printer	character	x(10)
50	Line-printer	X	Line Printer	character	x(10)
140	link-area-cde	X	Link Area	character	x(3)
40	post-addr	X	Postal Address	character [3]	x(25)
200	prc-grp	X	Prc Grp	integer	99	0
180	region-cde	X	Region Code	integer	99	0
170	repl-ind	X	Replicate	logical	Yes/No	Yes
30	st-addr	X	Street Address	character [3]	x(30)
160	sysadm	X	Sys Admin	character	x(12)
90	tax-reg-no	X	Tax Registr No	character	X(15)
70	tel-no	X	Tel No	character	x(15)
230	upd-date	X	Updated	date	99/99/9999	?
240	upd-time	X	At	integer	99999	0
220	upd-user-id	X	By	character	x(12)

Order	Field Name	x	Label	Datatype	Format	Initial
10	branch-no	X	Branch	integer	999	0
20	branch-name	X	Branch Name	character	x(30)
30	st-addr	X	Street Address	character [3]	x(30)
40	post-addr	X	Postal Address	character [3]	x(25)
50	Line-printer	X	Line Printer	character	x(10)
60	laser-printer	X	Laser Printer	character	x(10)
70	tel-no	X	Tel No	character	x(15)
80	fax-no	X	Fax No	character	x(15)
90	tax-reg-no	X	Tax Registr No	character	X(15)
100	cal-cde	X	Calendar Code	character	!!!
110	apu-days	X	APU Days	integer	>9	0
120	ctrl-area-cde	X	Ctrl Area	character	x(3)
130	ctrl-cost-cde	X	Ctrl Cost	character	x(4)
140	link-area-cde	X	Link Area	character	x(3)
150	e-mail	X	E-Mail	character	x(24)
160	sysadm	X	Sys Admin	character	x(12)
170	repl-ind	X	Replicate	logical	Yes/No	Yes
180	region-cde	X	Region Code	integer	99	0
190	branch-type	X	Branch Type	character	X
200	prc-grp	X	Prc Grp	integer	99	0
210	comp-id	X	Company Id	character	x(6)
220	upd-user-id	X	By	character	x(12)
230	upd-date	X	Updated	date	99/99/9999	?
240	upd-time	X	At	integer	99999	0

Index name	Flags	Fields	Datatype
branch-no	P U	branch-no (+)	integer
branch-name		branch-name (+)	character

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Parent tables
inv-combocom inv-comboitem sys-calendar sys-company sys-region

Child tables
acr-client coe-ordhdr coe-ordline coe-scale inv-actexpcomp inv-brnpln inv-brnrel inv-chicky-file inv-combobrn inv-dist-item inv-excbrn inv-excess inv-handperc inv-int-claim inv-pdt-issue inv-pdt-reg inv-produnit inv-serv-probrn inv-stktake-brn inv-store inv-whlsale-mu job-control mfr-calendar mfr-control mfr-costdist mfr-ecp mfr-mrptrig mfr-proddate mfr-resrc mfr-wccal pos-blacklist pos-compentry pos-ctrl pos-driver pos-item pos-ordhdr pos-rounding pos-till pos-voucher pos-waiter pos-wifi-vouch pos-yardreq-hdr prd-item prd-sheet prn-printer pur-edihdr pur-handperc pur-intacct pur-intvend pur-item pur-recvlog pur-scanex-brn rpl-ctrl rpl-srv sca-card sca-emp-move sca-terminal sys-branchctrl sys-branchgln sys-branchmng sys-section sys-user-log

Child tables

generated 18-9-2026 09:33