qbfdecn.inv-combocom

Combo Commodities

Table details

Area	ProdData
Dumpname	inv-combocom
Label	Combo Commodities
Val.exp	?
Val.msg

Fields

Order	Field Name	x	Label	Datatype	Format	Initial	Mand	Description
10	combo-no	X	Combination No	integer	9999999999	0
20	commodity-cde	X	Category	character	X(6)
50	upd-date	X	Updated	date	99/99/9999	?
40	upd-time	X	At	integer	99999	0
30	upd-user-id	X	By	character	x(12)

Indexes

Index name	Flags	Fields	Datatype
upd-date	P	upd-time (+)	integer
combo-no	U	combo-no (+)	integer
		commodity-cde (+)	character
commodity	U	commodity-cde (+)	character
		combo-no (+)	integer

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Related tables

Parent tables
inv-combohdr inv-comboitem inv-commodity

Child tables

acp-apadv-allow acp-clerk acp-devhdr acp-devln acp-recon acp-recur-inv acp-recur-invln acp-remit-allow acp-valacc acp-vend-stmnt acr-acctcard acr-acctcred acr-acctgrp acr-acctstat acr-aralloc acr-arrange acr-clerk-grp acr-clientcard acr-clientcred acr-clientfund acr-clienthist acr-clientmem acr-clientstat acr-clienttype acr-clntacct acr-clntinv acr-clntinv-ln acr-contact acr-credalloc acr-crinsurence acr-debtmth acr-dtcomm acr-elecclnt acr-emptycrn acr-fund acr-funddep acr-fundint acr-fundpmnt acr-linkclients acr-monthdeduct acr-paysched acr-paytrnsfer acr-policy acr-poltar acr-security acr-service acr-valacc acr-web-user asr-deprec-std cbk-atmclerk cbk-atmcontrol cbk-bankclerk cbk-bnkrecon cbk-bnktrn cbk-brnbnk cbk-cheqno cbk-cheqpmnt cbk-chqaud cbk-clerk cbk-coinaud cbk-deposit cbk-elecpmnt cbk-hand-dep cbk-mailaud cbk-mailhdr cbk-paymauth cbk-paymreq cbk-pcclerk cbk-pcinvhdr cbk-pcreq cbk-probrn cbk-prodev cbk-prodtl cbk-profee cbk-protrn cbk-protrnaud cbk-rdcheq cbk-receipt cbk-recon cbk-recondev cbk-shortack cbk-tender coe-comment coe-disphdr coe-ordhdr fra-all-cl-line fra-all-inv-ln fra-all-paid fra-all-pd-line fra-allow-claim fra-allow-run fra-allow-targ fra-grp-ret fra-inv-ln fra-invoice fra-mem-allow fra-mem-grp fra-mem-grpchg fra-member fra-ordhdr fra-pay-run fra-valid-deal fra-vendor glr-accttrn glr-budperc glr-commbudg glr-commbudvend glr-costcode glr-costcom glr-expbudgacct glr-expbudgbase glr-expbudget glr-expbudgincr glr-expbudgnote glr-expbudgperc glr-expbudgreq glr-genjrn glr-ohassign glr-reconacct glr-std-jrnhdr icc-cases icc-cat icc-deal icc-dealitem icc-dealreg icc-dept icc-image icc-item icc-list icc-packmat icc-packtyp icc-prodtyp icc-region icc-seaitem icc-season icc-stat icc-taxtyp icc-uom icc-vendor ins-policy-stat inv-abonusgrp inv-actexpcomp inv-actexppar inv-alloc inv-bonus-item inv-brand inv-brnlt inv-brnpln inv-brnrel inv-budget inv-combobrn inv-combohdr inv-comboitem inv-commbu inv-commodity inv-commsub inv-discgrp inv-discitem inv-discperc inv-discrules inv-disctend inv-dist-item inv-distbrn inv-distgrp inv-excbrn inv-excess inv-excgrp inv-expitem inv-expstruc inv-facing inv-forecast inv-grp-item inv-grptype inv-handperc inv-imcntr inv-impwgt inv-invacct inv-item inv-item-audit inv-item-brnex inv-item-grp inv-item-uplift inv-itemcost inv-itemlot inv-itemmloc inv-itemstd inv-itemtax inv-itemtaxcnty inv-lotstat inv-mandgrp inv-mfr inv-mfritem inv-millcost inv-millitem inv-millpurch inv-model-allow inv-negrel inv-packno inv-plhdr inv-plnrel inv-prccomp inv-prcdef inv-produnit inv-provsls inv-provstd inv-scaleaud inv-scalebrn inv-segmentbu inv-segments inv-serv-audit inv-serv-comrun inv-serv-item inv-serv-itm inv-serv-itmdef inv-serv-itmprt inv-serv-netcom inv-serv-probrn inv-serv-procom inv-serv-prodev inv-serv-prov inv-service inv-slsprc inv-stkprot inv-store inv-trans-claim inv-trans-trn inv-unit-conv inv-validfin inv-volbrk inv-whlsale-mu iuc-grp iuc-grpuser lsc-comp-vendor lsc-competition lsc-exclusion lsc-group lsc-group-rew lsc-member lsc-member-card lsc-msg-member lsc-promo-item lsc-promo-rew lsc-promotion lve-control lve-form lve-grptype lve-pmntadv lve-reason lve-type pmm-comp-master pmm-defcomp pmm-defmach pmm-mach-comp pmm-mach-hist pmm-mach-maint pmm-maint-task pos-apprcheq pos-apprcheqtrn pos-blacklist pos-item pos-slsprc prn-spoolfile prs-applicant prs-apply prs-awards prs-counsel prs-cpa prs-crssched prs-displ-acc prs-displ-mng prs-emp-deduct prs-empappr prs-empcpa prs-empgrp prs-employee prs-empsched prs-emptrain prs-hearing prs-lvcde prs-postcpa prs-vacancy pur-all-cat-typ pur-allow-alloc pur-allow-cat pur-allow-claim pur-allow-inv pur-allow-targ pur-allow-type pur-auto-ord pur-auto-vend pur-buyerresp pur-cal-appaud pur-cal-appdeal pur-cal-appoint pur-cal-vendor pur-contact pur-contract pur-dropship pur-dsbooks pur-edi-log pur-edivendor pur-empty pur-fvbrn pur-fvcat pur-fvordbrn pur-fvordhdr pur-fvpalitem pur-fvpalvend pur-handperc pur-icc-deal pur-intacct pur-intvend pur-item pur-item-vend pur-item-vendbrn pur-itemvendbrn pur-itemvendgrp pur-namecnty pur-ordln pur-pallet pur-palletvend pur-prcchg pur-prln pur-prombr pur-promhdr pur-promhist pur-promln pur-promvol pur-provprc pur-rethdr pur-retln pur-scanex pur-schedhdr pur-schedinv pur-schedln pur-schedpur pur-terminal pur-uplift-type pur-vend-allow pur-vend-uplift pur-vendac pur-vendbrn pur-vendclaim pur-vendcnty pur-vendcomm pur-vendcontr pur-vendgrp pur-vendor pur-vendprc pur-web-comp pur-web-vend sal-deduct sal-earning sal-irpno sal-runaud scl-log-type scl-tech-brn scl-technician scl-type sys-banktype sys-branch sys-branchmng sys-company sys-contact sys-emailhist sys-finmth-aud sys-histctrl sys-policy sys-policy-grp sys-user-menu sys-user-vendor sys-usergrp sys-usergrp-mem sys-usergrp-menu

generated 18-9-2026 10:02