トップ/TECHS 解説/詳細/Import スキーマ
10-import-schemas.md

Excel 一括取り込み定義

Import-config schemas (tmp/*.xml + *.config)

These were never reverse-engineered from RDLCs because they map CSV columns onto table writes — they reveal the actual underlying table column names (not just Viw* projections).

0802003.xml — TrnIssueIndD (払出指示明細 import) — 払出データ取込

FieldTypeCSV column
IssueYmdstring列2
IssuePersonCdstring列3
IssueIndDNostring列4
HouseCdstringNoData
RackNostringNoData
IssueAmntstring列5
LotNostringNoData
ChargeNostringNoData
MakeYmdstringNoData
ShiftFromSeibanstringNoData
ShiftFromProdNostringNoData
IssueNotesstringNoData
HalfFinishFlgstring列14
IssueIndSlipNostring

0803012.xml — Inventory import — 棚卸 / 入庫? (lookup screen 0803012)

FieldTypeCSV column
InvYmdstring列1
InvPersonCdstring列2
InvPersonNmstringNoData
HouseCdstring列4
HouseNmstringNoData
RackNostring列6
ItemNostring列7
BarCdItemNostringNoData
LotNostringNoData
ChargeNostringNoData
MakeYmdstringNoData
ShiftFromSeibanstringNoData
ShiftFromProdNostringNoData
InvAmntstring列14
InvNotesstringNoData

1201088_ImportSetUp.config — MstDeal (BtoB) — 取引先BtoB一括登録 (ImportSetUp)

SettingValue
CsvFilePathC:\
DelimitSymbolKbn0
DelimitSymbol
TextDelimitSymbolKbn0
TextDelimitSymbol
StartImportRow1
DealCdIdx1
BtoBLinkKbnIdx3
BtoBFaxSendKbnIdx4
BtoBSOrderAttachKbnIdx5
BtoBPictureAttachKbnIdx6
BtoBChangeDealCdIdx7

1203001.xml — MstItemNo (品番) — 品番マスタ取込

FieldTypeCSV column
ItemNostring列1
ItemNoRevstring列2
BarCdItemNostring列3
PictureNostring列4
PictureNoRevstring列5
ItemNmstring列6
TypeSizestring列7
Tolerancestring列8
PartsClassCdstring列9
ProdClassCdstring列10
MakerCdstring列11
QualityCdstring列12
ItemNoGroupCdstring列13
PartsWeightstring列14
ItemNoClassKbnstring列15
StockCtrlKbnstring列16
StdSaleUpstring列17
StdCostUpstring列18
PartsUnitNmstring列19
DueCalcStdDaysstring列20
DispStdSOrderLtMsstring列21
StdSupplierCdstring列22
StdDeliPlaceCdstring列23
SOrderArngCdstring列24
StdSOrderUpstring列25
SOrderUnitNmstring列26
StdAcceptUpstring列27
AcceptUnitNmstring列28
AllocateArngCdstring列29
MaterialArngKbnstring列30
MaterialUnitNmstring列31
LotSOrderFlgstring列32
SOrderStockChangeValuestring列33
StockSOrderChangeValuestring列34
LotUnitAmntstring列35
StockSOrderFractionKbnstring列36
StockDcmlDigitstring列37
StockUnitNmstring列38
SOrderStockFractionKbnstring列39
SOrderDcmlDigitstring列40
StockInvChangeValuestring列41
InvStockChangeValuestring列42
StockInvFractionKbnstring列43
InvDcmlDigitstring列44
InvStockFractionKbnstring列45
InvUnitNmstring列46
PartsStockChangeValuestring列47
StockPartsChangeValuestring列48
StockPartsFractionKbnstring列49
PartsStockFractionKbnstring列50
PartsDcmlDigitstring列51
LotNoCtrlFlgstring列52
ChargeNoCtrlFlgstring列53
MakeYmdCtrlFlgstring列54
SeibanProdNoCtrlFlgstring列55
ItemNoNotesstring列56

1203005.xml — MstItemNo variant

FieldTypeCSV column
BaseCdstring列1
ItemNostring列2
StdHouseCdstring列3
StdRackNostring列4
SOrderPointAmntstring列5
StdStockAmntstring列6
MaxStockAmntstring列7
DeliPlaceCdstring列8

1203008.xml — MstItemNo / parts master variant

FieldTypeCSV column
ParentItemNostring列1
DataSrtstring列2
ChildItemNostring列3
PartsNostring列4
ComposeAmntstring列5
MaterialLengthstringNoData
MaterialLengthUnitNmstringNoData
MaterialWidthstringNoData
MaterialWidthUnitNmstringNoData
MaterialThickstringNoData
MaterialThickUnitNmstringNoData
MaterialWeightstringNoData
MaterialWeightUnitNmstringNoData
MaterialTakeAmntstringNoData
MaterialTakeAmntUnitNmstringNoData
PartsComposeNotesstring列16

1501001_ImportSetUp.config — MstStock (在庫マスタ) — 在庫情報取込 (ImportSetUp)

SettingValue
CsvFilePathC:\
DelimitSymbolKbn0
DelimitSymbol
TextDelimitSymbolKbn0
TextDelimitSymbol
StartImportRow1
ItemNoIdx1
StockUpIdx2
SetConditions0

1501016_ImportSetUp.config — MstStock variant (ImportSetUp)

SettingValue
CsvFilePathC:\
DelimitSymbolKbn0
DelimitSymbol
TextDelimitSymbolKbn0
TextDelimitSymbol
StartImportRow1
ClaimCdIdx1
BalMoneyIdx2
SetConditions1

1501017_ImportSetUp.config — MstStock variant (ImportSetUp)

SettingValue
CsvFilePathC:\
DelimitSymbolKbn0
DelimitSymbol
TextDelimitSymbolKbn0
TextDelimitSymbol
StartImportRow1
PayCdIdx1
BalMoneyIdx2
SetConditions1

BtoBPF.config — ? (ImportSetUp)

SettingValue
← 前へ
SOAP サービス
次へ →
ライセンス / SKU マップ