TECHS Reverse-Engineered Data Model (ERD)

Reconstructed from RDLC report metadata, view/table identifiers, all_sql.txt JOIN patterns, and decompiled C# in analysis/decomp/. TECHS is a make-to-order manufacturing PMS by Technoa. Schema names follow strict Hungarian-style suffixes; the same field name appearing in multiple reports consistently identifies the owning entity.

Sources cited inline as [rdlc:NNNNNNNN <Name>.rdlc], [sql:all_sql.txt], [decomp:<dll>/<file>.cs], [strings:possible_tables_classes.txt].

---

1. Naming Convention Legend

1.1 Entity prefixes (table-level)

Within a domain table, entity sub-prefixes carry meaning:

1.2 Field-level suffixes

1.3 Audit columns (present on essentially every table)

InsApCd, InsDt, InsUserCd, UpdApCd, UpdDt, UpdUserCd, DelFlg, TmStamp, DisplaySrt, Reserve1..Reserve5.

Confirmed as universal pattern across every Mst* rdlc, e.g. [rdlc:12021001 MstDealList.rdlc], [rdlc:12021004 MstPersonList.rdlc].

---

2. Entity Inventory

2.1 Master entities (parties & catalog)

Sales / parties: MstDeal (取引先 — common party row, [rdlc:12021001 MstDealList]), MstCustomer (得意先, [strings]), MstClaim (請求先, [rdlc:12021002 MstClaimList]), MstSupplier (仕入先, [strings] + [rdlc:12021025 MstSupplierBuyUpList]), MstPay (支払先, [rdlc:12021003 MstPayList]), MstCustomerUpGroup / MstCustomerUpGroupUp (得意先単価グループ, [rdlc:12021024]), MstSupplierBuyUp (仕入単価, [rdlc:12021025]), MstSupplierOutopeUp (外注単価, [rdlc:12021026]), MstClaimSight, MstPaySight (請求/支払サイト, [strings]), MstBuyLink [strings].

Organization: MstPerson (担当者, [rdlc:12021004 MstPersonList]), MstSec (部門, [rdlc:12021005 MstSecList]), MstDept (部署, [rdlc:12021006 MstDeptList]), MstBase (拠点, [rdlc:12021007 MstBaseList]), MstCompanyInfo [strings], MstCalendar [strings], MstWorkSystem / MstWorkSystemCompose (作業体系, [rdlc:12021014]), MstWorkTime, MstApCtrl, MstSystemCtrl [strings].

Items / engineering: MstItem / MstItemNo (品番, [rdlc:12021021 MstItemNoList], [strings]), MstItemNoInfo (extra item attrs, [strings]), MstPictureNo (図面, [rdlc:12021022 MstPictureNoList]), MstMaker (メーカー, [rdlc:12021019]), MstQuality (材質, [rdlc:12021020]), MstUnit (単位, [strings]), MstPartsClass, MstProdClass, MstSeibanClass, MstOrderClass ([rdlc:12021015..18]), MstPartsCompose (BOM, [rdlc:12021029]), MstProcessCompose (工程表, [rdlc:12021030]), MstProcessPtrn (工程パターン, [rdlc:12021031]), MstArng / MstArngCompose (手配区分・体系, [rdlc:12021008/09]).

Process / resources: MstProcess (工程, [rdlc:12021011]), MstOpe (作業, [rdlc:12021012]), MstMachine ([rdlc:12021028]), MstProcessTimeUp (個人差時間単価, [rdlc:12021013]), MstProcessBarCode, MstMachineBarCode ([rdlc:12021033/34]), MstHouse (倉庫, [rdlc:12021027]), MstHouseInfo ([strings]), MstBaseItemNoStockCtrl (拠点品番在庫管理, [rdlc:12021023]).

Accounting catalog: MstSubject / MstSubSubject (科目・補助, [rdlc:12021010]), MstExpense (経費, [rdlc:12021032]).

2.2 Transaction entities

Sales / order: TrnOrderH / TrnOrderD (受注ヘッダ／明細, [sql] ViwTrnOrder, [rdlc:02011001 OrderResultList], [rdlc:02015001 OrderList]), TrnSeiban (製番, [decomp:OrderCommonLibrary/SeibanInfo.cs], [rdlc:02013002 SeibanLedger]), TrnProd (製品, [sql] ViwTrnProd, [rdlc:02013003 ProdLedger]), TrnQuoH/D (見積, [sql] ViwRptSOrderQuoSlip*), TrnBomH/D (BOM rows, [sql] ViwTrnBom, [rdlc:04011001 Bom]), TrnPsH/D (生産計画, [sql] ViwTrnPs, [rdlc:04021001 Ps]), TrnShipH/D (出荷, [rdlc:02021002 ShipList]), TrnSalesH/D (売上, [rdlc:02031001 SalesList]).

Receivables: TrnClaimH/D (請求, [rdlc:02041001 ClaimList], [rdlc:02043001 ClaimDList]), TrnReceiptH/D (入金, [rdlc:02051001 ReceiptList]), TrnTarMH/D (売掛元帳, [rdlc:02052001 TarMoneyLedger]), TrnAdvanceH/D (前受金元帳, [sql] ViwRptAdvanceMoneyLedger*).

Procurement: TrnSOrderH/D (購買発注, [sql] ViwTrnSOrderInfo, [rdlc:05016001 SOrderList]), TrnSOrderRec (発注訂正履歴, [rdlc:05016004 SOrderRecList]), TrnSOrderQuoH/D (見積依頼, [sql] ViwRptSOrderQuoSlip*), TrnAllocate (引当, [rdlc:05011001 AllocateInfoList]), TrnIssueIndH/D (払出指示, [rdlc:05012001 IssueIndSlip], [rdlc:05013001 IssueIndList]), TrnOutsrcIndH/D (外注指示, [rdlc:05021001 OutOpeIndSlipSingle1], [rdlc:05022002 OutsrcIndList]), TrnOutsrcAccept (外注検収, [rdlc:05024001 OutsrcAcceptList]), TrnBuyDeli (購買納品, [rdlc:05031001 BuyDeliList]), TrnBuyAccept (購買検収, [rdlc:05032001 BuyAcceptList]).

Payables: TrnAcceptH/D (検収, [strings] + [rdlc:06014001 AcceptDList]), TrnPay (支払, [rdlc:06011001 PayList]), TrnPayPlan (支払予定, [rdlc:06013001 PayPlanList]), TrnTapMH/D (買掛元帳, [rdlc:06021001 TapMoneyLedger]), TrnCloseAccept (検収締め, [rdlc:06011002 AcceptList]).

Production / shop floor: TrnOpeIndH/D (作業指示, [rdlc:07011001 OpeIndSheet], [rdlc:07012001 OpeIndList]), TrnOpeDayRept (日報, [rdlc:07021001 OpeDayReptList]), TrnOpeFinish / TrnOpeResult (作業実績, [rdlc:07021006 OpeResultList]), TrnOpeFinishD (失敗・歩留, see FailReason* fields in [rdlc:07021001 OpeDayReptList]), TrnOpeMr (材料消費, [sql] ViwRptOpeMrResultListInfo), TrnOpeResultPop (POSデータ, [rdlc:07031001/02]).

Inventory / stock ledger: TrnStockInOut (入出庫履歴, [rdlc:08011001 InList], [rdlc:08011002 OutList], [rdlc:08011003 StockInOutRecList]), TrnIssue (払出実績, [rdlc:08021001 IssueResultList]), TrnInvStdH/D (棚卸基準, [rdlc:08031001 InvStdList]), TrnInvResult (棚卸結果, [rdlc:08031003 InvResultList]), TrnInvStock (在庫元帳, [rdlc:08031004 InvStockList], [rdlc:08031005 InvStockRInPOutLedger]), TrnMStock (会社一括在庫元帳, [rdlc:08032001 MStockList]), TrnHouseStock / TrnLotCtrlStock ([sql] ViwRptLotCtrlStockConditionListInfo).

Cost / budget: TrnBudgetH/D (予算, [rdlc:09011001 ExecBudgetList], [rdlc:09011002 SeibanBudgetSlip]), TrnCost (原価実績明細, [rdlc:09021001 CostList], [rdlc:09021002 CostDList], [rdlc:09021008 SeibanPartsCostList]), TrnExpense (経費実績, [rdlc:09022001 SeibanExpenseList]), TrnCostShift (原価振替, [rdlc:09021006 CostShiftRecList]), TrnConversion ([rdlc:09021007 ConversionRecList]).

Accounting / journal: TrnJournal (仕訳, [rdlc:10011001 JournalList], [rdlc:10011002 JournalRecList]).

Generic / system: TrnAttachFile, TrnExtraIn, TrnMailBox, TrnSendMailBox, TrnReceiveMailBox, TrnPersonSchedule, TrnRelationApInfo, TrnBtoBTokenInfo (all [strings]).

Work / scratch (rebuilt per session): WrkPartsCompose ([rdlc:tables_and_views WRKPARTSCOMPOSE]), WrkBomExpandBom, WrkBomProgress, WrkPsExpandBom, WrkPsExpandInopeInfo, WrkPsExpandOutopeInfo, WrkPsExpandPs, WrkRptOpeInd, WrkRptSOrderH/D, WrkRptSeibanPartsCost, WrkBaseItemNoStockInOut, WrkSchedulePlanLink, WrkScheduleRelateLink, WrkLock, WrkLockCtrl, WrkKeyInfo* (all [strings]).

2.3 Domain group counts

• Master parties / accounting catalog: 18 entities
• Master organization: 8 entities
• Master items / engineering: 11 entities
• Master process / resources: 9 entities
• Sales / order: 9 transaction entities
• Receivables: 4
• Procurement: 9
• Payables: 5
• Production: 6
• Inventory: 6
• Cost / budget: 5
• Accounting: 1
• System / generic: 8
• Work / scratch: 12

Total distinct entities catalogued: ≈ 110 (see relationship section for the core 30+ that this document fully attributes).

---

3. Entity Attribute Tables

Attribute lists below are a minimum confirmed set: every column shown is directly observed in an RDLC field-name list. There may be more columns in the live DB; treat the list as a reliable lower bound and the FK columns as authoritative.

3.1 MstDeal — 取引先 (party master superset)

Source: [rdlc:12021001 MstDealList.rdlc]

3.2 MstCustomer — 得意先

Inferred role-projection of MstDeal where CustomerSetFlg='Y'. Confirmed as a distinct table by [strings] MstCustomer, [sql] ViwRptMstCustomer, and by Customer* fields cohabiting with both Deal* and StdCustomerCd in [rdlc:12021001]. Columns: CustomerCd PK, CustomerAbbr, CustomerFormalNm, contact block (Customer{Address1,Address2,Zip,Tel,Fax,MainTel,Person,Dept,MailAddress}), CustomerGroupCd/Nm, CustomerUpGroupCd/Nm, default ClaimCd, default delivery DeliCd (FK → MstDeal), OrderClassCd, plus audit. [rdlc:02011001 OrderResultList], [rdlc:02015001 OrderList].

3.3 MstClaim — 請求先

Source: [rdlc:12021002 MstClaimList.rdlc]

ClaimCd PK, ClaimAbbr, ClaimFormalNm, ClaimKana, Claim{Zip,Address1,Address2,Tel,Fax,MainTel,Person,Dept,MailAddress}, ClaimCompanyPersonCd/Nm, ClaimUnitKbn/Nm (slip aggregation unit), SalesUnitKbn/Nm, TaxationKbn/Nm, TaxationUnitKbn/Nm, TaxFractionKbn/Nm, MoneyFractionKbn/Nm, CloseDd, Callback{Mm,Dd,BorderUpperKbn,BorderLowerKbn,BorderMoney,BorderRate1,BorderRate2,Notes1..3}, ReceiptDenomCd1..3 + Nm1..3, ReceiptSightKbn1..3 + Sight1..3, FinanceLinkKbn/Nm, audit, Reserve1..5.

3.4 MstPay — 支払先

Source: [rdlc:12021003 MstPayList.rdlc]

PayCd PK, PayAbbr, PayFormalNm, PayKana, contact block, PayCompanyPersonCd/Nm, PayDealKbn/Nm, CloseDd, PayMm, PayDd, PayBorder{UpperKbn,LowerKbn,Money,Rate1,Rate2}, PayDenomCd1..3 + Nm, PaySightKbn1..3 + Sight1..3, PayNotes1..3, Bank{Cd,Nm,BoCd,BoNm,AcKbn,AcKbnNm,AcNo,AcHolder} (×2 for secondary), TaxationKbn/Nm, TaxationUnitKbn/Nm, TaxFractionKbn/Nm, MoneyFractionKbn/Nm, FinanceLinkKbn/Nm, audit.

3.5 MstPerson — 担当者

Source: [rdlc:12021004 MstPersonList.rdlc]

PersonCd PK, PersonNm, PersonKana, PersonMailAddress, SecCd (FK → MstSec), DeptCd (FK → MstDept), BaseCd (FK → MstBase), StaffKbn/Nm, UserAuthorityKbn/Nm, WorkSystemCd/Nm (FK → MstWorkSystem), StdProcessCd/Nm (FK → MstProcess), BarCdImage, BarCdKey, audit.

3.6 MstSec — 部門

[rdlc:12021005] — SecCd PK, SecNm, SecMailAddress, DeptCd (FK → MstDept), StdUserGroupCd/Nm, audit.

3.7 MstDept — 部署

[rdlc:12021006] — DeptCd PK, DeptNm, DeptMailAddress, audit.

3.8 MstBase — 拠点

[rdlc:12021007] — BaseCd PK, BaseAbbr, BaseFormalNm, Base{Zip,Address1,Address2,Tel,Fax,MainTel,MailAddress,Sign}, two Bank* blocks (for billing on issued slips), audit.

3.9 MstArng / MstArngCompose — 手配区分・体系

[rdlc:12021008]/[rdlc:12021009]

MstArng: ArngCd PK, ArngNm, DirectIndirectKbn/Nm, SubjectCd/SubSubjectCd (FK → MstSubject), CostItemCd/Nm, CostExpenseItemCd/Nm, TapUnPayKbn, audit.

MstArngCompose: composite (ArngCd, ArngComposeSeq) → ArngTreatCd/Nm, SeibanScheduleCd/Nm, accounting columns inherited from MstArng.

3.10 MstSubject — 科目

[rdlc:12021010] — SubjectCd PK + SubSubjectCd, SubjectNm, SubSubjectNm, Explain, audit.

3.11 MstProcess — 工程

[rdlc:12021011] — ProcessCd PK, ProcessNm, ProcessGroupCd/ProcessGroupNm, StdInOutopeKbn/Nm, InopeArngCd/OutopeArngCd (FK → MstArng), InopeStdDays, OutopeStdDays, OneDayAbilityTime{,FigKbn}, SeibanScheduleCd/Nm, audit.

3.12 MstOpe — 作業

[rdlc:12021012] — OpeCd PK, OpeNm, ProcessCd/Nm (FK), audit.

3.13 MstProcessTimeUp — 個人差時間単価

[rdlc:12021013] — composite (ProcessCd, PersonCd, ProcessTimeUpSeq) PK; ProcessTimeUp{,FigKbn}, SearchGroupFlg{,Nm}, audit.

3.14 MstWorkSystemCompose — 作業体系

[rdlc:12021014] — composite (WorkSystemCd, WorkSystemComposeSeq), WorkTimeCd/Nm, StartTime, EndTime, HolidayKbn/Nm, PremiumRate, audit.

3.15 MstOrderClass / MstSeibanClass / MstProdClass / MstPartsClass

[rdlc:12021015..18] — Each: <Class>Cd PK, <Class>Nm, OrderClassSign (only for OrderClass), DisplaySrt, audit.

3.16 MstMaker — メーカー

[rdlc:12021019] — MakerCd PK, MakerNm, audit.

3.17 MstQuality — 材質

[rdlc:12021020] — QualityCd PK, QualityNm, Gravity{,FigKbn} (specific gravity for weight calc), StdWeightUp{,FigKbn}, audit.

3.18 MstItem / MstItemNo — 品番

[rdlc:12021021 MstItemNoList.rdlc] (≈100 columns; the cardinal master)

PK: ItemNo (+ ItemNoRev revision). Identification: ItemNm, PictureNo/PictureNoRev (FK → MstPictureNo), TypeSize, Tolerance.

Classification & FK fan-out: ItemNoClassKbn/Nm (購買品/製品/部品/材料), ItemNoGroupCd/Nm, PartsClassCd/Nm (FK), ProdClassCd/Nm (FK), MakerCd/Nm (FK), QualityCd/Nm (FK).

Stock control: StockCtrlKbn/Nm, StockUnitCd/Nm, StockDcmlDigit, StockUpApplyKbn/Nm, LotNoCtrlFlg/Nm, LotSOrderFlg/Nm, LotUnitAmnt{,FigKbn}, MakeYmdCtrlFlg/Nm, ChargeNoCtrlFlg/Nm, SeibanProdNoCtrlFlg/Nm.

Unit conversions (between four parallel unit systems): InvUnitCd/Nm, SOrderUnitCd/Nm, AcceptUnitCd/Nm, PartsUnitCd/Nm, MaterialUnitCd/Nm, MaterialArngKbn/Nm, each with *DcmlDigit, *StockChangeValue, *FractionKbn/Nm.

Pricing / lead-time defaults: StdSaleUp{,FigKbn}, StdSOrderUp{,FigKbn}, StdAcceptUp{,FigKbn}, StdCostUp{,FigKbn}, StdSOrderLtMs, StdFixLtMs, StdFloatLtMs, StdSupplierCd/Abbr/FormalNm (FK → MstSupplier), StdDeliPlaceCd/Nm.

Arrangement defaults: SOrderArngCd/Nm, AllocateArngCd/Nm, ArngDcmlDigit.

Audit & reserved fields as universal pattern.

3.19 MstPictureNo — 図面

[rdlc:12021022] — PictureNo PK + PictureNoRev, NewPictureNoKbn, OutputPicYmd, RevYmd, PictureImageFile (Byte[]), audit.

3.20 MstBaseItemNoStockCtrl — 拠点・品番別在庫管理

[rdlc:12021023] — composite PK (BaseCd, ItemNo); flags & defaults that override MstItemNo per base: HouseKbn/Nm, StdHouseCd/Nm, StdRackNo, MaxStockAmnt{,FigKbn}, StdStockAmnt{,FigKbn}, SOrderPointAmnt{,FigKbn}, SOrderFixVol, FixTermSOrderDd, FixTermSOrderSpan, StockSOrderAmntKbn/Nm, StockSOrderMethodKbn/Nm, DeliPlaceCd/Nm, audit.

3.21 MstCustomerUpGroupUp — 得意先別単価

[rdlc:12021024] — composite (CustomerUpGroupCd, CustomerUpGroupUpSeq); ItemNo, MakerCd, PartsClassCd, ProdClassCd, QualityCd, SalesAmntFrom..To, SaleUp{,FigKbn}, SalesUnitCd/Nm, audit. Quantity-bracket pricing.

3.22 MstSupplierBuyUp — 仕入単価

[rdlc:12021025] — composite (SupplierCd, SupplierBuyUpSeq); same shape as MstCustomerUpGroupUp but with SOrderAmntFrom..To, SOrderUp{,FigKbn}, SOrderUnitCd/Nm. The buying counterpart.

3.23 MstSupplierOutopeUp — 外注単価

[rdlc:12021026] — same as above but keyed on (SupplierCd, SupplierOutopeUpSeq) + ProcessCd (because outsourcing prices vary by process). SupplyKbn/Nm (有償/無償), SearchGroupFlg/Nm.

3.24 MstHouse — 倉庫

[rdlc:12021027] — HouseCd PK, HouseNm, HouseKbn/Nm, BaseCd/Abbr/FormalNm (FK → MstBase), audit.

3.25 MstMachine — 機械

[rdlc:12021028] — MachineCd PK, MachineNm, MachineGroupCd/Nm, MachineUp{,FigKbn,ApplyFlg,ApplyFlgNm}, OneDayAbilityTime{,FigKbn}, StdProcessCd/Nm (FK), audit.

3.26 MstPartsCompose — 部品表 (BOM master)

[rdlc:12021029] — composite (ParentItemNo, PartsComposeSeq); parent: ParentItemNo, ParentItemNoRev, ParentItemNm, ParentPictureNo/Rev, ParentTypeSize; child: ChildItemNo, ChildItemNoRev, ChildItemNm, ChildPictureNo/Rev, ChildTypeSize, ChildPartsUnitNm; qty & material: ComposeAmnt{,FigKbn}, MaterialLength{,FigKbn,UnitCd,UnitNm}, MaterialThick, MaterialWeight, MaterialWidth, MaterialTakeAmnt (each with FigKbn/UnitCd/UnitNm); lead-time: FixLtMs{,FigKbn}, FloatLtMs{,FigKbn}, PartsLt, PartsLtMs; PartsNo, PartsComposeNotes, DataSrt, audit.

3.27 MstProcessCompose — 工程表

[rdlc:12021030] — composite (ItemNo, ProcessComposeSeq); InOutopeKbn/Nm, ProcessCd/Nm (FK), MachineCd/Nm (FK), PersonCd/Nm, SupplierCd/Abbr + SupplyKbn/Nm for outsourced steps, times: PlanSgTime{,FigKbn,Ms}, FixPrepTime{,FigKbn,Ms}, FloatPrepSgTime{,FigKbn,Ms}, AfterTime{,FigKbn,Ms}; lead times: FixLt{,Day,DayFigKbn,Ms}, FloatLt{,Day,DayFigKbn,Ms}; SOrderUp{,FigKbn} (outsource price), YieldRate, DeliPlaceCd/Nm, ProcessComposeNotes, audit.

3.28 MstProcessPtrn — 工程パターン

[rdlc:12021031] — composite (ProcessPtrnCd, ProcessComposePtrnSeq). Same shape as MstProcessCompose but keyed by pattern code instead of item.

3.29 MstExpense — 経費

[rdlc:12021032] — ExpenseCd PK, ExpenseNm, ArngCd/Nm (FK), SubjectCd/Nm, SubSubjectCd/Nm, CostItemCd/Nm, CostExpenseItemCd/Nm, DirectIndirectKbn, audit.

3.30 TrnOrderH / TrnOrderD — 受注 (header / detail)

Sources: [rdlc:02011001 OrderResultList], [rdlc:02015001 OrderList], [rdlc:02012001 EquipOrderSlip], [rdlc:02012002 PartsOrderSlip], [sql] ViwTrnOrder

TrnOrderH PK: OrderNo. Columns: OrderYmd, OrderClassCd/Nm (FK → MstOrderClass), OrderKindKbn/Nm, OrderTypeCd/Nm/TypeSize, OrderItemNo/Rev/Nm, OrderPictureNo/Rev, OrderUnitNm, OrderAmnt{,FigKbn}, OrderUp{,FigKbn,Kbn,KbnNm}, OrderBodyMoney, OrderAddMoney, OrderSumMoney, OrderAddupYm, OrderAddupYmd, OrderAddKbn/Nm, OrderDueYmd, OrderAnswerDueYmd, OrderDecideDueYmd, AcceptPlanYmd, CarryPlace, OrderNotes, OrderSummary1/2, CustomerCd (FK → MstCustomer), CustomerOrderNo, ClaimCd/ClaimUnitKbn/Nm (FK → MstClaim), DeliCd (FK → MstDeal), TradeBaseCd (FK → MstBase), TradeDeptCd, TradeSecCd, TradePersonCd, InqNo (inquiry no), QuoNo (quote no), status: SalesFinishKbn/Nm, ShipFinishKbn/Nm, ShipFinishYmd, CompleteFinishKbn/Nm, CompleteFinishYmd, AdjFlg/Nm, RedBlackKbn/Nm, GenerationCtrlNo, TreatYmd, SalesUnitKbn/Nm, InputPersonCd/Nm, InputYmd, audit.

TrnOrderD (per [rdlc:02021001 UnShipList] + Parts/Equip slips): PK (OrderNo, OrderLineNo, DKbn); per-line Prod* block: ProdNo, ProdItemNo/Rev/Nm, ProdPictureNo/Rev, ProdAmnt{,FigKbn}, ProdUp{,FigKbn}, ProdMoney, ProdUnitNm, ProdTypeSize, ProdTolerance, ProdNotes/Notes1/2, ProdBaseCd/Abbr, ProdDeptCd/Nm, ProdSecCd/Nm, ProdPersonCd/Nm, ProdClassCd/Nm, ShipPlanYmd, CompletePlanYmd, Seiban (FK → TrnSeiban), OrderAddLineNo, AddItemCd/Nm, AddAmnt, AddUp{,FigKbn}, AddMoney, AddUnitNm.

3.31 TrnSeiban — 製番

Sources: [strings] TrnSeiban, [decomp:OrderCommonLibrary/SeibanInfo.cs] (literally builds SELECT ... FROM TrnSeiban WHERE TrnSeiban.Seiban = @Seiban AND TrnSeiban.DelFlg = 'S0'), [rdlc:02013002 SeibanLedger], [rdlc:02015002 SeibanList], [rdlc:02014001 MakeIndSlip]

PK: Seiban. Columns: OrderNo (FK → TrnOrderH), SeibanItemNo/Rev/Nm, SeibanPictureNo/Rev, SeibanTypeSize, SeibanUnitNm, SeibanAmnt{,FigKbn}, SeibanUp{,FigKbn}, SeibanMoney, SeibanClassCd/Nm (FK → MstSeibanClass), SeibanNotes, SeibanPersonCd/Nm (FK → MstPerson), SeibanDeptCd/Nm, SeibanSecCd/Nm, SeibanBaseCd/Abbr, SeibanDueYmd, SeibanAnswerDueYmd, SeibanDecideDueYmd, StartPlanYmd, FinishPlanYmd, LockYmd, SeibanStatusKbn/Nm, SeibanScheduleCd/Nm and a child TrnSeibanSchedule referenced by SeibanScheduleLineNo,SeibanScheduleBaseCd/Abbr, SeibanScheduleDeptCd/Nm, SeibanScheduleSecCd/Nm, SeibanSchedulePersonCd/Nm, SeibanScheduleNotes/1/2, ShipFinishKbn/Nm/Ymd, CompleteFinishKbn/Nm/Ymd, CumuSalesBodyAmnt, CumuSalesBodyMoney, CumuSalesAddMoney, CumuSalesSumMoney (rollup totals).

3.32 TrnProd — 製品

Sources: [rdlc:02013003 ProdLedger], [sql] ViwTrnProd

PK: ProdNo. Columns: OrderNo (FK), Seiban (FK), ProdSeq, ProdItemNo/Rev/Nm, ProdPictureNo/Rev, ProdAmnt{,FigKbn}, ProdUp{,FigKbn}, ProdMoney, ProdUnitNm, ProdTypeSize, ProdTolerance, ProdNotes, ProdClassCd/Nm, ProdBaseCd/Abbr, ProdDeptCd/Nm, ProdSecCd/Nm, ProdPersonCd/Nm, ShipPlanYmd, CompletePlanYmd.

3.33 TrnBomH / TrnBomD — BOM rows (live job BOM)

Sources: [rdlc:04011001 Bom], [sql] ViwTrnBom

TrnBomH: header (Seiban, ProdNo) — same shape as TrnSeiban/TrnProd join.

TrnBomD: composite key (Seiban, ProdNo, PartsSeq); columns: PartsNo, PartsLineNo, AssyUnitNo (sub-assembly identifier), PartsCtrlNo, ProdLevel, item: ItemNo/Rev/Nm, PictureNo/Rev, TypeSize, Tolerance, MakerCd/Nm, QualityCd/Nm, PartsClassCd/Nm, ItemNoClassKbn/Nm, ItemNoGroupCd/Nm, ItemNoKindKbn/Nm, qty: Number{,FigKbn}, PartsNeedAmnt, PartsUnneedAmnt, PartsYieldExpectAmnt, PartsSumAmnt{,FigKbn}, PartsUnitNm, material: full Material{ArngAmnt,Length,Thick,Weight,Width,TakeAmnt} block (each + UnitNm), MaterialArngKbn/Nm, MaterialArngUnitNm, arrangement: ArngAmnt, ArngUnitNm, AllocateConditionKbn/Nm, SOrderConditionKbn/Nm, ProcessConditionKbn/Nm, ScheduleLinkKbn/Nm, StockCtrlKbn/Nm, revision: PartsRevCtrlKbn, PartsRevNo, PartsRevNotes, PartsRevUpdYmd, flags: CancelFlg/Nm, InputFinishFlg/Nm, PlsOpFlg, TempKbn/Nm, schedule: StartPlanDt, StartPlanYmd, EndPlanDt, EndPlanYmd, AcceptPlanYmd, CompletePlanYmd, ShipPlanYmd, authoring: BomPersonCd/Nm, BomNotes, PartsFixLt, PartsFloatLt, PartsLt, PartsWeight{,FigKbn}, InOutOccurNo (linkage to in/out movement).

3.34 TrnPsH / TrnPsD — Process schedule (live job process plan)

Source: [rdlc:04021001 Ps]

TrnPsD composite (Seiban,ProdNo,PartsSeq,ProcessSeq); inherits parts identity from TrnBomD, adds: ProcessCd/Nm (FK), ProcessGroupCd/Nm, ProcessLineNo, MachineCd/Nm/GroupCd/GroupNm, SupplierCd/Abbr/FormalNm (FK → MstSupplier), SupplyKbn/Nm, InOutopeKbn/Nm, LastProcessFlg/Nm, PlanOpeTime, PlanSgTime, FixPrepTime, FloatPrepSgTime, AfterTime, ProcessFixLt{,Day}, ProcessFloatLt{,Day}, ProcessLt{,Day}, ProcessNeedAmnt, ProcessUnneedAmnt, ProcessYieldExpectAmnt, ProcessSumAmnt, schedule windows: ProcessStartPlanDt/Ymd, ProcessEndPlanDt/Ymd, ProcessAnswerDueYmd, ProcessDecideDueYmd, ProcessDueYmd, pricing: ProcessUp, ProcessMoney, SOrderUp, SOrderUpKbn/Nm, SOrderMoney, BfTaxMoney, TaxMoney, flag: IndFlg/Nm, IndPlanAmnt, IndUnitNm, IndFinishFlg/Nm, UndecidedReason, DecidePlan, DecidePlanYmd, authoring: PsPersonNm, PsBaseAbbr, PsDeptNm, PsSecNm, PsNotes.

3.35 TrnAllocate — 引当

[rdlc:05011001 AllocateInfoList]

Composite key implied (Seiban,ProdNo,PartsSeq,allocation sequence); columns: full parts identity (as in TrnBomD), allocation: AllocateAmnt{,FigKbn}, AllocateUp{,FigKbn}, AllocateUnitNm, AllocateConditionKbn/Nm, AllocateInfoNotes, arrangement: ArngCd/Nm, ArngAmnt, ArngUnitNm, ArngUnitAllocateAmnt, plus ArngTreatKbn/Nm, linkage: InOutOccurNo (FK → stock movement), HouseCd/Nm (FK → MstHouse), RackNo, StockBaseCd/Abbr (FK → MstBase), issue: IssueAnswerDueYmd, IssueDecideDueYmd, IssueDueYmd, IssueIndFlg/Nm, InputFinishFlg/Nm, audit.

3.36 TrnIssueIndH / TrnIssueIndD — 払出指示

[rdlc:05012001 IssueIndSlip], [rdlc:05013001 IssueIndList]

TrnIssueIndH: PK IssueIndSlipNo, IssueIndYmd, Ind{Base,Dept,Sec,Person}{Cd,Nm} (issuer ind), IssueAnswerDueYmd, IssueDecideDueYmd, IssueDueYmd, SlipDueYmd, IssueSheetPrintFlg/Nm, IssueIndPrintNoCd, InputPersonCd/Nm, InputYmd, audit.

TrnIssueIndD: composite (IssueIndSlipNo, IssueIndDNo, IssueIndLineNo); parts identity, ArngCd/Nm, AllocateUnitNm, AssyUnitNo, Seiban/ProdNo, HouseCd/Nm (FK), RackNo, StockBaseCd/Abbr/FormalNm, StockArngKbn/Nm, StockCtrlKbn/Nm, DeliPlaceCd/Nm, IssueIndAmnt{,FigKbn}, IssueIndUp, IssueIndMoney, CumuIssueAmnt{,FigKbn}, UnIssueAmnt{,FigKbn}, IssueBalAmnt, IssueFinishKbn/Nm, IssueFinishYmd, CommonProdFlg/Nm, CancelYmd, IssueIndDNotes, IssueIndNotes.

3.37 TrnIssue (issue results) — 払出実績

[rdlc:08021001 IssueResultList]

Composite (IssueIndSlipNo,IssueIndDNo,IssueSeq); identifies the source indication. Columns: full parts identity, LotNo, MakeYmd, ChargeNo, HouseCd/Nm, RackNo, Issue{Amnt,FigKbn,Up,Money,UpKbn,UpKbnNm,UpFigKbn,Notes,Yymd,Seq,UnitNm}, IssueCalcMoney/Up, IssueFormalMoney/Up, IssueTempMoney/Up, Issue{Base,Dept,Sec,Person}{Cd,Nm}, IssueReturnFlg/Nm, StockBaseCd/Abbr/FormalNm, StockArngKbn/Nm, StockCtrlKbn/Nm, ShiftFromSeiban, ShiftFromProdNo, ShipNo, ShipDSeq (linkage when an issue is consumed by a ship).

3.38 TrnSOrderH / TrnSOrderD — 購買発注

[rdlc:05014001 SOrderInfoList] (planning), [rdlc:05016001 SOrderList] (decided), [rdlc:05016003 SOrderBalList] (balance), [rdlc:05016004 SOrderRecList] (history), [sql] ViwTrnSOrderInfo, ViwTrnSOrderHInDel, ViwTrnSOrderDInDel

TrnSOrderH: PK SOrderSlipNo, SOrderYmd, SOrder{Base,Dept,Sec,Person}{Cd,Nm}, SOrderApprovalPersonCd/Nm, SOrderApprovalStatusKbn/Nm, SOrderApprovalYmd, SOrderPrintNoCd, SOrderSlipPrintFlg/Nm, SupplierCd/Abbr/FormalNm, PayCd/Abbr/FormalNm, PrintTypeKbn/Nm, SlipDueYmd, SlipSOrderMoney, SlipExcTaxMoney, SlipIncTaxMoney, SlipTaxRate, MoneyFractionKbn/Nm, TaxFractionKbn/Nm, TaxationKbn/Nm, TaxationUnitKbn/Nm, audit.

TrnSOrderD: composite (SOrderSlipNo, SOrderDNo, SOrderLineNo); columns: parts identity, Seiban/ProdNo/AssyUnitNo/PartsNo, ItemNo/Rev/Nm, PictureNo/Rev, TypeSize, Tolerance, QualityCd/Nm, MakerCd/Nm, PartsClassCd/Nm, ProcessCd/Nm/GroupCd/GroupNm (when outsource per process), ArngCd/Nm, ArngTreatKbn/Nm, SupplyKbn/Nm, CommonProdFlg/Nm, SOrderAmnt{,FigKbn}, SOrderUp{,FigKbn,Kbn,KbnNm}, SOrderMoney, SOrderUnitNm, delivery: SOrderDueYmd, SOrderAnswerDueYmd, SOrderDecideDueYmd, UndecidedReason, UpDecideYmd, DecidePlan/Ymd, status & accumulators: DeliFinishKbn/Nm/Ymd, AcceptFinishKbn/Nm/Ymd, CumuDeliAmnt, DeliBalAmnt{,FigKbn}, CumuDeliUnitAcceptAmnt, DeliUnitAcceptBalAmnt{,FigKbn}, AcceptBalMoney, CumuStockUnitDeliAmnt, StockUnitDeliBalAmnt, StockUnitSOrderAmnt, StockArngKbn/Nm, StockCtrlKbn/Nm, StockBaseCd/Abbr/FormalNm, HouseCd/Nm, RackNo, DeliPlaceCd/Nm, CancelYmd, AdjDKbn/Nm, TempKbn/Nm, SOrderDNotes, InOutOccurNo (linkage to stock movement when accepted), InputPersonCd/Nm, InputYmd, audit.

3.39 TrnOutsrcIndH / TrnOutsrcIndD — 外注指示

[rdlc:05021001 OutOpeIndSlipSingle1], [rdlc:05022002 OutsrcIndList]

Same shape as TrnSOrderH/D but distinguished by OutsrcInd* keys (OutsrcIndSlipNo, OutsrcIndDNo, OutsrcIndLineNo, OutsrcIndPagingNo, OutsrcIndPrintNoCd); plus outsource-specific: Outope{Answer,Decide,Due,EndPlan,StartPlan}Ymd, OutopeFixLt{,Day}, OutopeFloatLt{,Day}, OutopeLt{,Day}, Ind{Base,Dept,Sec,Person}{Cd,Nm}, IndYmd, IndAmnt{,FigKbn}, IndUnitNm, NextProcessNm, OutsrcSheetPrintFlg/Nm.

3.40 TrnOutsrcAccept / TrnBuyAccept (検収)

[rdlc:05024001 OutsrcAcceptList], [rdlc:05032001 BuyAcceptList], [rdlc:06014001 AcceptDList]

Composite (AcceptNo or OutsrcAcceptNo, AcceptDSeq/OutsrcAcceptDSeq, AcceptLineNo); columns: AcceptYmd, Accept{Base,Dept,Sec,Person}{Cd,Nm}, AcceptAmnt{,FigKbn}, AcceptUp{,FigKbn}, AcceptMoney, AcceptUnitNm, DeliUnitAcceptAmnt, DeliUnitNm, DeliSeq, SOrderSlipNo, SOrderDNo (FK → TrnSOrderD or TrnOutsrcIndD), parts identity, LotNo, MakeYmd, ChargeNo, HouseCd/Nm, RackNo, StockBaseCd/Abbr/FormalNm, StockArngKbn/Nm, StockCtrlKbn/Nm, PayCd/Abbr/FormalNm, PayDealKbn/Nm, tax: ExcTaxMoney, IncTaxMoney, TaxRate, TaxationKbn/Nm, TaxationUnitKbn/Nm, TaxFractionKbn/Nm, slip rollup: SlipAcceptMoney, SlipExcTaxMoney, SlipIncTaxMoney, SlipTaxRate, RedFlg/Nm, RedFromAcceptNo/RedFromOutsrcAcceptNo, ImmediateAcceptFlg/Nm, CloseAcceptPlanYmd, Cost{Dept,Sec}{Cd,Nm}, CostAddupYmd, MKbn/Nm/MYmd (month-close marks), audit.

3.41 TrnShipH / TrnShipD — 出荷

[rdlc:02021002 ShipList]

TrnShipH: PK ShipNo, ShipYmd, ShipBaseCd/Abbr, ShipDeptCd/Nm, ShipSecCd/Nm, ShipPersonCd/Nm, TransportCd/Nm, OutFinishKbn/Nm, OutTargetFlg/Nm, InputPersonCd, InputYmd, audit.

TrnShipD: composite (ShipNo, ShipDSeq, ShipLineNo); OrderNo (FK), ProdNo (FK), Seiban (FK), ShipItemNo/Rev/Nm, ShipPictureNo/Rev, ShipTypeSize, ShipTolerance, ShipAmnt{,FigKbn}, ShipUnitNm, ShipDNotes, ShipNotes, SmallSumAmnt{,FigKbn}, CarryPlace, customer/deli embedded for slip print.

3.42 TrnSalesD — 売上明細 (no separate H — slip-on-the-fly per close)

[rdlc:02031001 SalesList]

PK (SalesNo,SalesLineNo); SalesYmd, Sales{Base,Dept,Sec,Person}{Cd,Nm}, SalesItemNo/Rev/Nm, SalesPictureNo/Rev, SalesTypeSize, SalesTolerance, SalesAmnt{,FigKbn}, SalesUp{,FigKbn}, SalesMoney, SalesUnitNm, SalesDKbn/Nm, SalesDNotes, SalesNotes, SalesSummary1/2, SalesUnitKbn/Nm, OrderNo (FK), Seiban, ProdNo, OrderClassCd/Nm, SeibanClassCd/Nm, ProdClassCd/Nm, customer/deli/claim embedded blocks (FKs above), ClaimPlanYmd, MKbn/Nm/MYmd (month close), CloseKbn/Nm, CloseYmd, FinanceLinkTreatKbn/Nm, RefCostMoney, RefCostUp, Tax{ationKbn,FractionKbn}/Nm, TaxationUnitKbn/Nm, InputPersonCd/Nm, InputYmd, audit.

3.43 TrnClaimH / TrnClaimD — 請求

[rdlc:02041001 ClaimList] (header summary), [rdlc:02043001 ClaimDList] (detail)

TrnClaimH: PK (ClaimCd,ClaimYmd); aggregation by claim party at a given close: LastClaimMoney, ThisClaimMoney, ThisExcTaxMoney, ThisIncTaxMoney, ThisTaxMoney, ThisTaxAdjMoney, ThisRegSalesMoney, ThisRegReceiptMoney, ThisReceiptAdjMoney, ThisCOverMoney (carry-over), ThisReturnDiscountMoney, LastEachClaimMoney, LastPkgClaimMoney, TaxRate, TaxationKbn/Nm.

TrnClaimD: PK (ClaimNo,ClaimDSeq); per-row breakout of constituent sales/receipts: BillPrintFlg/Nm, ClaimItemNo/Nm, ClaimPictureNo/Rev, ClaimTolerance, ClaimTypeSize, ClaimMoney, ClaimNotes, ClaimDNotes, ClaimUnitKbn/Nm, OrderNo, Seiban, ProdNo, CustomerOrderNo/DNo, SlipNo, SlipDseq (FK → TrnSalesD / TrnReceiptD), TarDataKbn/Nm (sales/receipt/adjustment), LedgerMoney, SalesAmnt{,FigKbn}, SalesMoney, SalesUp{,FigKbn}, SalesUnitNm, SalesDKbn/Nm, ReceiptDenomCd/Nm, ReceiptDenomSettleYmd, ReceiptMoney, ExcTaxMoney, IncTaxMoney, TaxMoney, TaxRate, rollup: ThisSalesMoney, ThisRegReceiptMoney, ThisReceiptAdjMoney, ThisTaxMoney, ThisCOverMoney, ThisClaimMoney, CloseAddupYmd.

3.44 TrnReceiptH / TrnReceiptD — 入金

[rdlc:02051001 ReceiptList]

PK (ReceiptNo,ReceiptLineNo); ReceiptYmd, Receipt{Base,Dept,Sec,Person}{Cd,Nm}, ReceiptDenomCd/Nm, ReceiptDenomSettleYmd, ReceiptMoney, ReceiptRegMoney, ReceiptAdjFlg/Nm, ReceiptAdjMoney, SlipReceiptMoney, ClaimCd/Abbr/FormalNm, CheckDecideFlg/Nm, LedgerKbn/Nm, ReceiptDNotes, InputPersonCd/Nm, InputYmd.

3.45 TrnTarMH / TrnTarMD — 売掛元帳 (AR ledger)

[rdlc:02052001 TarMoneyLedger]

TrnTarMH: composite key derived (TarMNo,TarMLineNo); month context MAddupYmd, MCloseYm, MCloseYmd, LastTarBalMoney, CumuTarBalMoney, ThisTarBalMoney.

TrnTarMD: composite (TarMNo,TarMDSeq); links to source slip via SlipNo/SlipDseq/TarDataKbn. Columns include TarItemNo/Nm, TarPictureNo/Rev, TarTypeSize, TarTolerance, TarMNotes, TarMDNotes, TarLedgerPrintFlg/Nm, plus the same sales/receipt money columns as TrnClaimD (this view is essentially the unified ledger view).

3.46 TrnAdvanceMH/D — 前受金元帳

[sql] ViwRptAdvanceMoneyLedger* — analogous to TrnTar* but for advance receipts.

3.47 TrnAcceptH / TrnAcceptD — 検収 (master accept records)

[strings] TrnAcceptH, TrnAcceptD; combined view in [rdlc:06014001 AcceptDList] — see 3.40 above; this is the underlying table set for both BuyAccept and OutsrcAccept (kind discriminated by AdjDKbn/ArngTreatKbn).

3.48 TrnPay — 支払

[rdlc:06011001 PayList]

PK (PayNo,PayLineNo); PayYmd, Pay{Base,Dept,Sec,Person}{Cd,Nm}, PayDenomCd/Nm, PayDenomSettleYmd, PayMoney, PayRegMoney, PayAdjFlg/Nm, PayAdjMoney, PayDealKbn/Nm, SlipPayMoney, PayCd/Abbr/FormalNm (FK → MstPay), PayDNotes.

3.49 TrnPayPlan — 支払予定

[rdlc:06013001 PayPlanList]

PK (CloseAcceptNo,PayPlanSeq); CloseAcceptYmd, PayPlanYmd, PayPlanMoney, PayPlanNotes, PaySight{,KbnNm}, PayDenomNm, PayDenomSettleYmd, PayCd/Abbr/FormalNm.

3.50 TrnTapMH / TrnTapMD — 買掛元帳 (AP ledger)

[rdlc:06021001 TapMoneyLedger] — symmetric to TrnTarM*: TapMNo/TapMLineNo/TapMDSeq, LastTapBalMoney, CumuTapBalMoney, ThisTapBalMoney, etc.

3.51 TrnOpeIndH / TrnOpeIndD — 作業指示

[rdlc:07011001 OpeIndSheet], [rdlc:07012001 OpeIndList]

TrnOpeIndH: PK OpeIndSlipNo, IndYmd, MinIndYmd, Ind{Base,Dept,Sec,Person}{Cd,Nm}, OpeIndPrintNoCd, audit.

TrnOpeIndD: composite (OpeIndSlipNo,OpeIndDNo,OpeIndLineNo); parts identity + (Seiban,ProdNo,PartsSeq,ProcessSeq), AssyUnitNo, OrderNo (FK), ProcessCd/Nm, ProcessGroupCd/Nm, MachineCd/Nm/GroupCd/GroupNm, OpeFinishKbn/Nm/Ymd, SOrderDNo, SOrderSlipNo (linkage when outsourced), SOrderSlipKbn, SupplierCd/Abbr (when outsourced), InOutopeKbn, InOutOpeFinishKbn, OutopeDecideDueYmd, inope timing block: Inope{AfterTime,FixLtMs,FixPrepTime,FloatLtMs, FloatPrepTime,LtMs,PlanOpeTime,ProcessTime,StartPlanYmd,EndPlanYmd, AnswerDueYmd,DecideDueYmd,DueYmd} (Ms variants for sub-day), IndAmnt{,FigKbn}, IndUnitCd/Nm, ProcessUp, ProcessMoney, ArngCd/Nm, ArngAmnt{,FigKbn}, ArngUnitNm, OpeIndDNotes/1/2, OpeIndNotes, OpeSheetPrintFlg/Nm, CancelYmd, PrintTypeKbn/Nm, PsPersonCd/Nm, BomNotes/1/2, StockArngKbn/Nm, StockCtrlKbn/Nm, BarCdImage, BarCdKey, audit.

3.52 TrnOpeDayRept — 日報

[rdlc:07021001 OpeDayReptList]

PK (OpeIndSlipNo,OpeIndDNo,OpeDayReptSeq); OpeYmd, StartDt, EndDt, Ope{Base,Dept,Sec,Person}{Cd,Nm}, OpeCd/Nm (FK → MstOpe), MachineCd/Nm/GroupCd/GroupNm (FK), WorkSystemCd/Nm, WorkTimeCd/Nm, HolidayKbn/Nm, PremiumRate, times: PracticOpeTime, AddUpOpeTime{,FigKbn}, ResultOpeTime, SlipResultOpeTime, SumResultOpeTime, FixPrepTime, FloatPrepTime, AfterTime, money: AddUpUp, AddUpResultMoney, ResultMoney, SlipResultMoney, SumResultMoney, StdTimeUp, TimeUp, production: FinishAmnt{,FigKbn}, FinishUnitNm, FailAmnt{,FigKbn}, FailUnitNm, FailReason{,Cd,ClassCd,ClassNm}, FailDNotes, OpeFinishDNotes, OpeMrLineNo, OpeMrDLineNo, OpeMrDNotes, OpeMrDBNotes, MachineUpApplyFlg, OpeDayReptNotes, Cost{Dept,Sec}{Cd,Nm}, CostAddupYmd, inherits parts/process identity from TrnOpeIndD.

3.53 TrnOpeMr — 材料消費 (material consumption per work)

[sql] ViwRptOpeMrResultListInfo — referenced by OpeMrLineNo/OpeMrDLineNo/OpeMrDNotes in TrnOpeDayRept. Columns inferred from [rdlc:07021004 OpeMrResultList].

3.54 TrnStockInOut — 入出庫履歴

[rdlc:08011001 InList], [rdlc:08011002 OutList], [rdlc:08011003 StockInOutRecList]

PK (InOutOccurNo,InOutSeq); InOutKbn/Nm (in/out), InOutYmd, InOutAmnt, InOutUp{,FigKbn,Kbn,KbnNm}, InOutMoney{,FigKbn}, InOutFormalUp/Money, InOutTempUp/Money, InOutUnitNm, InOutOccurCd/Nm, InOutNotes, InOutUpCalcKbn/Nm, In{,Out}{Base,Dept,Sec,Person}{Cd,Nm} (movement parties), HouseCd/Nm, RackNo, StockBaseCd, parts identity, LotNo, MakeYmd, ChargeNo, MakerCd/Nm, ShiftFromSeiban, ShiftFromProdNo (when shifting cost across jobs), AdjDataKbn/Nm, MKbn/Nm, CancelYmd.

3.55 TrnInvStdH/D — 棚卸基準

[rdlc:08031001 InvStdList] — PlanCloseYmd, InvUnitNm/InvUnitStockAmnt{,FigKbn}, StockUnitStockAmnt, full parts/lot identity, HouseCd/Nm, RackNo, StockBaseCd/Abbr/FormalNm, AddKbn.

3.56 TrnInvResult / TrnInvStock / TrnMStock — 棚卸結果・在庫元帳

[rdlc:08031003..04], [rdlc:08032001 MStockList]

TrnInvResult PK InvMNo+HouseStockMNo; StockCloseYm, StockCloseYmd, ItemNo/Rev, HouseCd/Nm, StockBaseCd/Abbr/FormalNm, balances: This{COverAmnt,COverMoney,CalcInvAmnt,CalcInvMoney, InvAdjAmnt,InvAdjMoney,StockEvalUp} (each with FigKbn), plus Dcml... decimal-mirror columns for high-precision rollups.

TrnInvStock (InvMNo per house) and TrnMStock (StockMNo, company unified) carry the same balance columns + month transitions Last{StockAmnt,StockMoney,StockEvalUp}, This{In,Out,Adj,Calc,...}, AdjPlMoney, AutoAdjLossMoney, AutoAdjProfitMoney, InvLedgerPrintFlg/Nm, StockLedgerPrintFlg/Nm.

3.57 TrnBudgetH / TrnBudgetD — 予算

[rdlc:09011001 ExecBudgetList], [rdlc:09011002 SeibanBudgetSlip]

TrnBudgetH: PK derived from (Seiban,BudgetKindKbn); links via Seiban/OrderNo.

TrnBudgetD: composite (Seiban,BudgetSeq,BudgetLineNo); BudgetMoney, BudgetMoney1, BudgetUp{,FigKbn}, BudgetAmnt, BudgetUnitNm, BudgetNotes, BudgetDNotes/1/2, BudgetKindKbn, BudgetDAdjFlg, Budget{Base,Dept,Sec,Person}{Cd,Nm}, ArngCd/Nm, CostItemCd/Nm, CostExpenseItemCd/Nm, DirectIndirectKbn/Nm, CommonProdFlg, SumBudgetMoney, InputPersonCd/Nm, InputYmd.

3.58 TrnCost — 原価実績

[rdlc:09021002 CostDList], [rdlc:09021008 SeibanPartsCostList]

PK (CostSeq within Seiban/ProdNo/PartsSeq/ProcessSeq context); CostKindKbn/Nm (issue/in-house ope/outsource/other), CostOccurCd/Nm, CostOccurYmd, CostDecideYmd, CostAddupYmd, CostAmnt{,FigKbn}, CostUp, CostMoney, CostUnitNm, CostUpKbn/Nm, CostItemCd/Nm, CostExpenseItemCd/Nm, Cost{Dept,Sec}{Cd,Nm}, AdjDKbn/Nm, RedBlackKbn/Nm, ShiftRedBlackKbn/Nm, StaffKbn/Nm, DirectIndirectKbn/Nm, SlipNo/SlipDNo (FK to source — issue/accept/dayrept/etc.), parts/lot identity, ArngCd/Nm, OpeCd/Nm, OpePersonCd/Nm, OpeTime{,FigKbn}, TimeUp, TimeUpKbn/Nm, PremiumRate, MachineCd/Nm, WorkSystemCd/Nm, WorkTimeCd/Nm, ChargeNo, ExpenseCd/Nm, HouseCd/Nm, RackNo, SupplierCd/Abbr/FormalNm, SupplierORStockBase (computed alias).

3.59 TrnExpense — 経費実績

[rdlc:09022001 SeibanExpenseList]

PK ExpenseNo; Seiban/ProdNo linkage, ExpenseAmnt{,FigKbn}, ExpenseUp{,FigKbn}, ExpenseMoney, Expense{Base,Dept,Sec,Person}{Cd,Nm}, ExpenseCd/Nm (FK), ArngCd/Nm, CostItemCd/Nm, CostExpenseItemCd/Nm, Cost{Dept,Sec}{Cd,Nm}, CostAddupYmd, CommonProdFlg, ExpenseDNotes, ExpenseNotes, ExpenseLineNo, SumExpenseMoney, TreatYmd.

3.60 TrnJournal — 仕訳

[rdlc:10011001 JournalList]

PK (JournalSlipNo,JournalSlipLineNo); SlipYmd, MCloseYmd, TreatYm, debit / credit pair with full denormalization: Dr{SubjectCd,SubjectNm,SubSubjectCd,SubSubjectNm,DCd,DNm, DeptCd,DeptNm,Money,IncTaxMoney,ExcTaxMoney,TaxKbn,TaxKbnNm, TaxationKbn,TaxationKbnNm,SummaryCd,SummaryNm} and the analogous Cr* block. Source linkage: SlipNo/SlipDseq (FK → source TrnSales/Receipt/Pay/...), OrderNo, Seiban, ProdNo, ClaimPayCd/Abbr/FormalNm (FK → MstClaim/MstPay), DealCd/Abbr/FormalNm, DeliFormalNm, CustomerOrderNo, FinanceKindKbn/Nm, FinanceOutputKbn/Nm, FinanceRedFlg/Nm, FinanceNotes, FinanceSeq, parts identity (ItemNo/Nm, PictureNo/Rev, PartsClassNm, TypeSize, ItemNoGroupNm), InsDt, InsUserCd/Nm.

---

4. Relationships

Notation: A —(<col>)→ B means A.<col> is FK to B's primary key. A ◇—— B means composition / detail-of relationship. A ⇉—— B means many-to-many resolved via a join table.

4.1 Master party graph

MstDeal —(StdCustomerCd)→ MstCustomer
MstDeal —(ClaimCd)→ MstClaim
MstDeal —(PayCd)→ MstPay
MstDeal —(CustomerUpGroupCd)→ MstCustomerUpGroup
MstDeal —(SupplierUpGroupCd)→ MstSupplierUpGroup
MstDeal —(CompanyPersonCd)→ MstPerson

Note: MstCustomer/MstSupplier are role projections of MstDeal. The *SetFlg flags on MstDeal mark which roles a party plays. [rdlc:12021001].

4.2 Master organisation graph

MstPerson —(SecCd)→ MstSec —(DeptCd)→ MstDept
MstPerson —(BaseCd)→ MstBase
MstPerson —(WorkSystemCd)→ MstWorkSystem ◇—— MstWorkSystemCompose
MstPerson —(StdProcessCd)→ MstProcess

4.3 Item graph

MstItem ◇—— MstItemNo (Rev)
MstItemNo —(PictureNo,PictureNoRev)→ MstPictureNo
MstItemNo —(MakerCd)→ MstMaker
MstItemNo —(QualityCd)→ MstQuality
MstItemNo —(PartsClassCd)→ MstPartsClass
MstItemNo —(ProdClassCd)→ MstProdClass
MstItemNo —(StdSupplierCd)→ MstSupplier
MstItemNo —(StdDeliPlaceCd)→ MstDeal
MstItemNo —(SOrderArngCd)→ MstArng
MstItemNo —(AllocateArngCd)→ MstArng
MstItemNo —(InvUnitCd / SOrderUnitCd / AcceptUnitCd / PartsUnitCd / MaterialUnitCd / StockUnitCd)→ MstUnit  (× multiple unit FKs)

MstBaseItemNoStockCtrl: composite key (BaseCd,ItemNo) overrides MstItemNo per base
MstBaseItemNoStockCtrl —(StdHouseCd)→ MstHouse
MstHouse —(BaseCd)→ MstBase

4.4 BOM / process master graph

MstPartsCompose: parent-child self-ref on MstItemNo
   (ParentItemNo,PartsComposeSeq) PK,
   ParentItemNo —→ MstItemNo,
   ChildItemNo  —→ MstItemNo
   (recursive — defines BOM tree)

MstProcessCompose: per-item routing
   PK (ItemNo, ProcessComposeSeq)
   —(ItemNo)→ MstItemNo
   —(ProcessCd)→ MstProcess
   —(MachineCd)→ MstMachine
   —(SupplierCd)→ MstSupplier   [for outsourced steps]
   —(PersonCd)→ MstPerson
   —(DeliPlaceCd)→ MstDeal

MstProcessPtrn: re-usable routing template
   PK (ProcessPtrnCd, ProcessComposePtrnSeq) — same FKs as MstProcessCompose

MstArngCompose: routing for arrangement type
   PK (ArngCd, ArngComposeSeq) — links MstArng to MstArng (treatment chain)
   —(SeibanScheduleCd)→ MstProcess (schedule-event process)

MstProcess —(InopeArngCd / OutopeArngCd)→ MstArng
MstOpe —(ProcessCd)→ MstProcess
MstMachine —(StdProcessCd)→ MstProcess
MstProcessTimeUp —(ProcessCd, PersonCd)→ MstProcess, MstPerson  (composite)

4.5 Pricing graph

MstCustomerUpGroupUp: bracket pricing for customer group × item attrs
   PK (CustomerUpGroupCd, CustomerUpGroupUpSeq)
   —(CustomerUpGroupCd)→ MstCustomerUpGroup
   —(ItemNo)→ MstItemNo (optional row predicate)
   —(MakerCd / PartsClassCd / ProdClassCd / QualityCd)→ master classifications

MstSupplierBuyUp: same shape, keyed on SupplierCd
MstSupplierOutopeUp: same shape, +ProcessCd
   PK (SupplierCd, SupplierOutopeUpSeq)

4.6 Sales / AR transaction graph

TrnOrderH ◇—(OrderNo)— TrnOrderD
TrnOrderH —(CustomerCd)→ MstCustomer
TrnOrderH —(ClaimCd)→ MstClaim
TrnOrderH —(DeliCd)→ MstDeal
TrnOrderH —(OrderClassCd)→ MstOrderClass
TrnOrderH —(TradeBaseCd / TradeDeptCd / TradeSecCd / TradePersonCd)→ org masters
TrnOrderH —(QuoNo)→ TrnQuoH

TrnSeiban —(OrderNo)→ TrnOrderH       (1 order has ≥1 seiban via TrnSeiban)
TrnSeiban —(SeibanClassCd)→ MstSeibanClass
TrnSeiban —(SeibanItemNo)→ MstItemNo
TrnSeiban —(SeibanPersonCd / SeibanSecCd / SeibanDeptCd / SeibanBaseCd)→ org

TrnProd —(OrderNo)→ TrnOrderH   (alt: directly from OrderD line)
TrnProd —(Seiban)→ TrnSeiban
TrnProd —(ProdItemNo)→ MstItemNo

TrnShipH ◇—(ShipNo)— TrnShipD
TrnShipD —(OrderNo)→ TrnOrderH
TrnShipD —(ProdNo)→ TrnProd
TrnShipD —(Seiban)→ TrnSeiban
TrnShipH —(ShipBaseCd / ShipDeptCd / ShipSecCd / ShipPersonCd)→ org
TrnShipH —(TransportCd)→ MstDeal     (transport vendor)

TrnSalesD —(OrderNo)→ TrnOrderH
TrnSalesD —(Seiban)→ TrnSeiban
TrnSalesD —(ProdNo)→ TrnProd
TrnSalesD —(CustomerCd / ClaimCd / DeliCd)→ MstCustomer / MstClaim / MstDeal
TrnSalesD —(SalesBaseCd / SalesDeptCd / SalesSecCd / SalesPersonCd)→ org

TrnClaimH ◇—(ClaimNo)— TrnClaimD
TrnClaimH —(ClaimCd)→ MstClaim
TrnClaimD —(SlipNo, SlipDseq, TarDataKbn)→ TrnSalesD or TrnReceiptD
TrnClaimD —(OrderNo / Seiban / ProdNo)→ … (denormalized)
TrnClaimD —(CustomerCd / DeliCd)→ MstCustomer / MstDeal

TrnReceiptH ◇—(ReceiptNo)— TrnReceiptD
TrnReceiptH —(ClaimCd)→ MstClaim
TrnReceiptD —(ReceiptDenomCd)→ MstReceiptDenom (a code list)
TrnReceiptH —(ReceiptBaseCd / ReceiptDeptCd / ReceiptSecCd / ReceiptPersonCd)→ org

TrnTarMH ◇—(TarMNo)— TrnTarMD
TrnTarMD —(SlipNo, SlipDseq, TarDataKbn)→ TrnSalesD / TrnReceiptD / adj
TrnAdvanceMH/D — same shape

4.7 Production graph

TrnSeiban ◇—— TrnBomD  (a seiban is a tree of parts)
TrnBomD —(ItemNo)→ MstItemNo
TrnBomD —(ParentRef via AssyUnitNo + PartsSeq, ChildRef via PartsNo)
        → recursive on TrnBomD (the live BOM mirrors MstPartsCompose)

TrnPsD ◇—(Seiban,ProdNo,PartsSeq)— TrnBomD
TrnPsD —(ProcessCd)→ MstProcess
TrnPsD —(MachineCd)→ MstMachine
TrnPsD —(SupplierCd)→ MstSupplier   (when InOutopeKbn=outsource)

TrnAllocate —(Seiban,ProdNo,PartsSeq)→ TrnBomD
TrnAllocate —(HouseCd)→ MstHouse
TrnAllocate —(InOutOccurNo)→ TrnStockInOut    (resolved on issue)
TrnAllocate —(IssueIndSlipNo,IssueIndDNo)→ TrnIssueIndD (when materialized)

TrnIssueIndH ◇—— TrnIssueIndD
TrnIssueIndD —(Seiban,ProdNo,PartsSeq)→ TrnBomD
TrnIssueIndD —(HouseCd)→ MstHouse
TrnIssueIndD —(StockBaseCd)→ MstBase
TrnIssue —(IssueIndSlipNo,IssueIndDNo)→ TrnIssueIndD
TrnIssue —(InOutOccurNo)→ TrnStockInOut
TrnIssue —(ShipNo,ShipDSeq)→ TrnShipD       (when issuing for ship)
TrnIssue —(ShiftFromSeiban,ShiftFromProdNo)→ TrnSeiban/TrnProd

TrnOutsrcIndH ◇—— TrnOutsrcIndD
TrnOutsrcIndD —(Seiban,ProdNo,PartsSeq,ProcessSeq)→ TrnPsD
TrnOutsrcIndD —(SupplierCd)→ MstSupplier
TrnOutsrcAccept —(OutsrcIndSlipNo,OutsrcIndDNo)→ TrnOutsrcIndD
TrnOutsrcAccept —(InOutOccurNo)→ TrnStockInOut

TrnOpeIndH ◇—— TrnOpeIndD
TrnOpeIndD —(Seiban,ProdNo,PartsSeq,ProcessSeq)→ TrnPsD
TrnOpeIndD —(MachineCd)→ MstMachine
TrnOpeIndD —(SOrderSlipNo,SOrderDNo)→ TrnSOrderD   (outsource linkage)

TrnOpeDayRept —(OpeIndSlipNo,OpeIndDNo)→ TrnOpeIndD
TrnOpeDayRept —(OpeCd)→ MstOpe
TrnOpeDayRept —(OpePersonCd)→ MstPerson
TrnOpeDayRept —(MachineCd)→ MstMachine
TrnOpeDayRept —(WorkSystemCd, WorkTimeCd)→ MstWorkSystem(Compose)
TrnOpeMr     —(OpeIndSlipNo,OpeIndDNo,OpeMrLineNo,OpeMrDLineNo)→ TrnOpeDayRept

4.8 Procurement & Inventory graph

TrnSOrderH ◇—— TrnSOrderD
TrnSOrderH —(SupplierCd)→ MstSupplier
TrnSOrderH —(PayCd)→ MstPay
TrnSOrderH —(SOrderBaseCd / SOrderDeptCd / SOrderSecCd / SOrderPersonCd)→ org
TrnSOrderD —(Seiban,ProdNo,PartsSeq)→ TrnBomD     (seiban-anchored buy)
TrnSOrderD —(ItemNo)→ MstItemNo
TrnSOrderD —(ArngCd)→ MstArng
TrnSOrderD —(HouseCd)→ MstHouse
TrnSOrderD —(InOutOccurNo)→ TrnStockInOut         (when accepted)
TrnSOrderD —(SOrderQuoHNo,SOrderQuoReqNo,SOrderQuoReqDNo)→ TrnSOrderQuoH/D

TrnBuyDeli —(SOrderSlipNo,SOrderDNo)→ TrnSOrderD
TrnBuyDeli —(HouseCd)→ MstHouse
TrnBuyAccept (= TrnAcceptH/D filtered ArngTreatKbn=Buy)
  —(SOrderSlipNo,SOrderDNo)→ TrnSOrderD
  —(InOutOccurNo)→ TrnStockInOut
  —(PayCd)→ MstPay

TrnAcceptH ◇—— TrnAcceptD
TrnCloseAccept (close-accept) —(AcceptNo)→ TrnAcceptH

TrnPay —(PayCd)→ MstPay
TrnPay —(PayBaseCd / PayDeptCd / PaySecCd / PayPersonCd)→ org
TrnPayPlan —(CloseAcceptNo)→ TrnCloseAccept
TrnTapMH ◇—(TapMNo)— TrnTapMD
TrnTapMD —(SlipNo,SlipDseq,TapDataKbn)→ TrnAcceptD or TrnPay or adj

TrnStockInOut —(ItemNo)→ MstItemNo
TrnStockInOut —(HouseCd)→ MstHouse
TrnStockInOut —(StockBaseCd)→ MstBase
TrnStockInOut —(InOutOccurCd)→ enum (issue/accept/ship/in/out/adj/...)
TrnStockInOut —(ShiftFromSeiban,ShiftFromProdNo)→ TrnSeiban/TrnProd

TrnInvStdH/D —(ItemNo,HouseCd,StockBaseCd)→ MstItemNo,MstHouse,MstBase
TrnInvResult —(InvMNo)→ TrnInvStock
TrnInvStock — house-level monthly evaluation
TrnMStock — company-level monthly evaluation

4.9 Cost & accounting graph

TrnBudgetH ◇—— TrnBudgetD
TrnBudgetH —(Seiban / OrderNo)→ TrnSeiban / TrnOrderH
TrnBudgetD —(ArngCd)→ MstArng
TrnBudgetD —(CostItemCd / CostExpenseItemCd)→ MstSubject (sub) / MstExpense
TrnBudgetD —(BudgetBaseCd / BudgetDeptCd / BudgetSecCd / BudgetPersonCd)→ org

TrnCost —(Seiban,ProdNo,PartsSeq,ProcessSeq)→ TrnBomD/TrnPsD
TrnCost —(SlipNo,SlipDNo)→ TrnIssue / TrnOutsrcAccept / TrnBuyAccept /
                            TrnOpeDayRept / TrnExpense
TrnCost —(CostItemCd / CostExpenseItemCd / ExpenseCd)→ MstSubject(sub)/MstExpense
TrnCost —(ArngCd)→ MstArng
TrnCost —(SupplierCd)→ MstSupplier
TrnCost —(MachineCd, OpeCd, OpePersonCd, WorkSystemCd, WorkTimeCd)→ resource masters
TrnCost —(HouseCd, StockBaseCd)→ MstHouse, MstBase

TrnExpense —(Seiban / ProdNo)→ TrnSeiban / TrnProd
TrnExpense —(ExpenseCd)→ MstExpense
TrnExpense —(ArngCd)→ MstArng

TrnJournal —(SlipNo,SlipDseq,FinanceKindKbn)→ source slip (sales/receipt/pay/accept)
TrnJournal —(DrSubjectCd / CrSubjectCd)→ MstSubject
TrnJournal —(DrSubSubjectCd / CrSubSubjectCd)→ MstSubject (sub)
TrnJournal —(DrDeptCd / CrDeptCd)→ MstDept
TrnJournal —(ClaimPayCd)→ MstClaim or MstPay  (polymorphic via FinanceKindKbn)
TrnJournal —(DealCd)→ MstDeal
TrnJournal —(OrderNo / Seiban / ProdNo / ItemNo)→ tx/master

4.10 SQL-confirmed JOIN evidence (representative)

From [sql:all_sql.txt] (ViwTrnSOrderInfo + ViwTrnBom join, SOrder-based parts arrange):

ViwTrnSOrderInfo JOIN ViwTrnBom
   ON Seiban=Seiban AND ProdNo=ProdNo AND AssyUnitNo=AssyUnitNo
       AND PartsNo=PartsNo

This confirms (Seiban,ProdNo,AssyUnitNo,PartsNo) as the natural key of the live BOM line.

[sql] ViwTrnOrder joins SubQ on OrderNo. [sql] ViwRptModelOrderCostGraphOrderInfo joins on Seiban,ProdNo, confirming the production hierarchy Order ⟶ Seiban ⟶ Prod ⟶ Bom-line ⟶ Process-line.

[decomp:OrderCommonLibrary/SeibanInfo.cs] directly issues: SELECT TrnSeiban.Seiban, TrnSeiban.SeibanStatusKbn FROM TrnSeiban WHERE TrnSeiban.Seiban=@Seiban AND TrnSeiban.DelFlg='S0', confirming TrnSeiban.Seiban PK and DelFlg semantics.

---

5. Mermaid ER Diagrams

5.1 Master party & item core

5.2 Sales / AR transaction flow

5.3 Production: Seiban / Parts / Process / BOM / Work / DayRept

5.4 Procurement & Inventory

---

6. Open Questions & Inferences Flagged

1. MstCustomer vs MstDeal — true distinct table or view? [strings] MstCustomer, [sql] ViwRptMstCustomer, and [strings] MstSupplier are present, but [rdlc:12021001 MstDealList.rdlc] exposes Customer*Flg / Supplier*Flg columns directly on the deal row, hinting that MstCustomer may be a view over MstDeal rather than a separate physical table. The StdCustomerCd column is also self-referential into the same domain. The ERD models them as separate to capture the FKs cleanly; a future schema inspection should confirm.

2. MstItem vs MstItemNo. Both names appear ([strings] MstItem, [strings] MstItemNo*). Likely MstItem is the master row keyed on the item identity while MstItemNo carries revision-level attributes (ItemNoRev). Where the live RDLC always uses ItemNo+ItemNoRev as a pair, treating them as one logical entity is safer.

3. TrnSalesH not directly observed. [rdlc:02031001 SalesList] exposes only SalesNo/SalesLineNo; no obvious header-only attributes are visible (close-Kbn / close-Ymd / customer embedded per row). Likely there is a thin TrnSalesH keyed on SalesNo — modelled here implicitly.

4. Quote (TrnQuoH/D). OrderH.QuoNo, OrderH.InqNo, and [sql] ViwRptSOrderQuoSlipH/DInfo plus [rdlc:05017001 SOrderQuoSlipMulti1] show that quotes (sales-side and purchase-side) exist as TrnQuoH/D and TrnSOrderQuoH/D. Columns inferred but not enumerated here — see those rdlcs for full attribute lists if required.

5. Polymorphic FK TrnJournal.ClaimPayCd. The single column ClaimPayCd references either MstClaim or MstPay discriminated by FinanceKindKbn. Modelled as polymorphic in §4.9.

6. AssyUnitNo semantics. Appears in all production entities (TrnBomD, TrnPsD, TrnAllocate, TrnIssueIndD, TrnSOrderD, TrnOpeIndD, ...). Behaves as an identifier for sub-assemblies within a Seiban; effectively a self-reference within a Seiban's BOM tree. Treat it as a non-FK structural id, not as an entity of its own.

7. InOutOccurNo is the cross-domain stock event ID. It appears across allocate / SOrder / IssueInd / Accept / StockInOut. Acts as the join key threading reservation → procurement → receipt → ledger. Modelled on TrnStockInOut as PK and as FK on the sources.

8. Lot / make-date / charge-no controls. Per-base toggles LotNoCtrlFlg, MakeYmdCtrlFlg, ChargeNoCtrlFlg on MstItemNo mean rows in TrnStockInOut, TrnBuyAccept, etc., conditionally carry LotNo, MakeYmd, ChargeNo. They are kept on those tables but their nullability depends on the item.

9. Decimal-mirror columns (Dcml*). TrnInvStock, TrnMStock, TrnInvResult carry both Money and DcmlMoney variants. The Dcml* form is the high-precision authoritative value; Money is the rounded display value. Inferred from [rdlc:08031004 InvStockList].

10. Wrk tables are not part of the persistent ERD.* They are session/scratch tables used by reports & expansions (e.g. WrkBomExpandBom, WrkPsExpandPs). They appear here in the inventory but are excluded from the relationship section.

---

Report

• Distinct entities catalogued: ~110 across master/transaction/work domains; 30 key entities fully attributed in §3 (3.1–3.60).
• Relationships documented: ~95 relationship statements across §4.1–§4.10 (parties, organisation, item, BOM/process, pricing, sales/AR, procurement/inventory, production, cost/accounting), backed by RDLC field-name co-occurrence and SQL JOIN evidence.
• Mermaid ER diagrams: 4 (§5.1 master core, §5.2 sales/AR, §5.3 production, §5.4 procurement/inventory).