AQL012 のバックアップ(No.7)

Customer-item checklist batch entry †

Order control
- Customer-item checklist batch entry

The combination (Conversioninformation) of Customer, Customer item, and Plant item is edited in Excel (CSV), Read-in [ the Customer itemConversioninformation / in a number screen ] collectively.
Since the file after CSV output becomes origin by 【Customer-item checklist】, it becomes the format which the upload file also united there.

Query item name	Explanation
Register type	Entry or Delete is specified.
File name	The full path of the storing place and File name of a file which perform Batch processing is specified.

Input item name	Character	Number of bits	Mandatory	Explanation
Customer	alphabet/number	6	○	Customer code Entr(ied) by Customer master is inputted.
Customer name				It is the reference Item after CSV output at 【Customer-item checklist】.
Customer item	alphabet/number/symbol	30	○	ItemCode of Customer is inputted.
Revision	alphabet/number	4
Customer item name	Character	40	○	It is the reference Item after CSV output at 【Customer-item checklist】. It is used for automatic Entry of Primary table for customer item change information.
Plant item	alphabet/number/symbol	20	○	Item Entr(ied) by Item master is inputted.
Item name				It is the reference Item after CSV output at 【Customer-item checklist】
Material mark				It is the reference Item after CSV output at 【Customer-item checklist】
Diameter				Reference Item at the time of CSV output 【Customer-item checklist】
Diameter unit				It is the reference Item after CSV output at 【Customer-item checklist】
Length				It is the reference Item after CSV output at 【Customer-item checklist】
Length unit				It is the reference Item after CSV output at 【Customer-item checklist】
Weight				It is the reference Item after CSV output at 【Customer-item checklist】
Weight unit				It is the reference Item after CSV output at 【Customer-item checklist】
Plant				It is the reference Item after CSV output at 【Customer-item checklist】
得意先品目汎用項目1	文字	40		導入会社で自由に定義できる項目
得意先品目汎用項目2	文字	40		導入会社で自由に定義できる項目
得意先品目汎用項目3	文字	40		導入会社で自由に定義できる項目
得意先品目汎用項目4	文字	40		導入会社で自由に定義できる項目
得意先品目汎用項目5	文字	40		導入会社で自由に定義できる項目
所要量種類	文字	40		ヤンマーEDI機能で使用する項目
***				(参考項目)今後のバージョンアップで使用するシステム予約項目
***				(参考項目)今後のバージョンアップで使用するシステム予約項目
***				(参考項目)今後のバージョンアップで使用するシステム予約項目
***				(参考項目)今後のバージョンアップで使用するシステム予約項目

↑

Confirm of Customer-item checklist batch entry †

Before Batch entry, it is Confirm(ed) whether there is any error in the contents of a file.

A Confirm procedure becomes as follows.
①【Customer-item checklist batch entry 】 is started, One of Entry and the Delete(s) is specified by Register type, the 〔Reference〕button of File name is click(ed) and the file which uploads is specified.
②If the Confirm button is click(ed), Confirm processing will start.
③Since a List indication of the Confirm result will be given if the 〔Result confirmation〕 button is click(ed) after processing, Confirm that it is errorless.

↑

Entry of Customer-item checklist batch entry †

The 〔Entry〕 button will be click(ed) and there is Batch entry [ with the 〔Confirm〕 button / Sales unit price information ] if there is no error in the file [ Batch entry / file ].

When Customer item is not Entr(ied) by Primary table for customer item change information, It Entr(ies) automatically to Primary table for customer item change information by Customer of a file, and Customer item.

An Entry procedure becomes as follows.
①【Customer-item checklist batch entry 】 is started, One of Entry and the Delete(s) is specified by Register type, the 〔Reference〕button of File name is click(ed) and the file which uploads is specified.
②If the Entry button is click(ed), Batch entry /Delete processing will start.
③Since a List indication of the Entry /Delete result will be given if the 〔Result confirmation〕button is click(ed) after processing, Confirm that it is errorless.
※When an error exists, Entry /Delete of the Customer itemConversioninformation used as an error is not carried out. Entry /Delete of the Customer itemConversioninformation used as an error is carried out.

↑

Result confirmation of Customer-item checklist batch entry †

The result processed with the 〔Confirm〕 button and the 〔Entry〕 button is indicated by List.

↑

Resuluting output of Customer-item checklist batch entry †

The contents of List of Result confirmation are downloaded by All pieces and CSV.