Sales order batch entry

Query item nameExplanation
File nameSpecify the full path of the storing place and File name of a file which perform Batch processing.
Register typeIt is Selection about any of AddEntry or Change they are.
Query item nameExplanation
Customer
Place of delivery
Billing
Customer purchase No...
Customer item
Plant item
Delivery dateFROM - TO is specified.

Upload file layout

Input item nameCharacterNumber of bitsMandatoryExplanation
Customeralphabet/number6Customer code Entr(ied) by Customer master is inputted.
Place of deliveryalphabet/number8Place of delivery code Entr(ied) by Place of receipt master is inputted.
CustomerOrderNOalphabet/number/symbol20A customer's order number is inputted.
CustomerOrderLine numbernumber5Brunch number in case two or more Order information exists in Customer purchase No. In a No.t input, 0 is set.
Customer item-30Customer item Entr(ied) by Primary table for customer item change information is inputted.
Customer revisionalphabet/number4Revision of Customer item is inputted. In a No.t input, Revision of Primary table for customer item change information is set.
Item name-40Item name of Plant item
Unit pricenumber22,10At the time of a No.t input, when cannot set Sale Unit price and it cannot be acquired and acquired from Sales unit price master, 0 is set.
Delivery dateyear/month/date-Customer Delivery date is inputted. Time can also be No.t inputted.
Order quantitynumber12,4Order quantity is inputted.
Production numberalphabet/number/symbol10Production number Entr(ied) by Production number ledgermaster is inputted.
※It becomes possible to change to automatic numbers in a system parameter.
 As an automatic numbers system, they are two kinds, the Production number management No and Order No.
Place of delivery (EDI)Code-10It inputs as Details of Place of delivery.
※Code-Master table management is not carried out within a system.
Delivery destination-3It inputs as Delivery destination of Place of delivery. It is displayed on Shipping instruction sheet and Shipping details and advanced shipping notice.※Code-Master table management is not carried out within a system.
ShippingInspection classification-2It inputs by setting the contents of an inspection at the time of Shipping to Classification.
※Code-Master table management is not carried out within a system.
Direct deliverynumber1In SupplierDirect delivery, '1' is inputted.
Remarks-100The supplement of Correct reason, etc. are inputted at the time of the special affairs to Order information, or Change.
Billingalphabet/number6-Customer code Entr(ied) by Customer master is inputted.
Billing item namealphabet/number30-Item of Billing is inputted.
BillingOrderNOalphabet/number/symbol30-The order number of Billing is inputted.
Customer serial numberalphabet/number/symbol19-Production number of customer is inputted.
Order STSalphabet/number/symbol1-受注ステータス X:内示、0:注文、1:確定を入力
※各ステータスの説明は【受注一覧】を参照下さい
無償出荷
受注種別
便半角英数字2-
得意先発注形態-10-得意先の発注形態を入力
受注汎用項目1-40-導入会社で自由に定義できる項目
受注汎用項目2-40-導入会社で自由に定義できる項目
受注汎用項目3-40-導入会社で自由に定義できる項目
受注汎用項目4-40-導入会社で自由に定義できる項目
受注汎用項目5-40-導入会社で自由に定義できる項目
***-40-今後のバージョンアップで使用するシステム予約項目
***-40-今後のバージョンアップで使用するシステム予約項目
***-40-今後のバージョンアップで使用するシステム予約項目
***-40-今後のバージョンアップで使用するシステム予約項目
***-40-今後のバージョンアップで使用するシステム予約項目
 
No..Input item nameCharacterNumber of bitsMandatoryUpdate is possibleExplanation
1OrderNOalphabet/number14-OrderNO (form of OrderNO-Order details No) Entr(ied) by Sales order list is inputted.
2Customeralphabet/number6--Customer code Entr(ied) by master is inputted.
3Customer itemalphabet/number30--Customer item Entr(ied) by Primary table for customer item change information is inputted.
4CustomerOrderNOalphabet/number/symbol30A customer's order number is inputted.
5Customer line numbernumber5-Brunch number in case two or more Order information exists in Customer purchase No.
6Salespersonalphabet/number6-Salesperson is inputted.
7Order dateyear/month/date-Order date is inputted.
8Place of deliveryalphabet/number8-Place of delivery code Entr(ied) by master is inputted.
9Revisionalphabet/number4-Revision of Customer item is inputted.
10Production numberalphabet/number/symbol10-Production number Entr(ied) by Production number ledgermaster is inputted.
※It becomes possible to change to automatic numbers in a system parameter.
 As an automatic numbers system, they are two kinds, the Production number management No and Order No.
11Sales unit pricenumber22,10-At the time of a No.t input, when cannot set Sale Unit price and it cannot be acquired and acquired from Sales unit price master, 0 is set.
12Unit price classificationalphabet/number1-
13Correct reasonalphabet/number2Correct reason set up in the introductory company is inputted.
14Inspection classificationalphabet/number2-
15Place of delivery (EDI)alphabet/number10-It inputs as Details of Place of delivery.
※Code-Master table management is not carried out within a system.
16Delivery destinationalphabet/number10-It inputs as Delivery destination of Place of delivery.
It is displayed on Shipping instruction sheet and Shipping details and advanced shipping notice.
※Code-Master table management is not carried out within a system.
17Remarks-100-The supplement of Correct reason, etc. are inputted at the time of the special affairs to Order information, or Change.
18Billingalphabet/number6-BillingCode Entr(ied) by Customer master is inputted.
19Billing item namealphabet/number30-Item of Billing is inputted.
20BillingOrderNOalphabet/number/symbol30-The order number of Billing is inputted.
21Customer serial numberalphabet/number/symbol19-Production number of customer is inputted.
22Order quantitynumber12,4Order quantity is inputted.
23Delivery dateyear/month/date-Delivery date is inputted.
24Scheduled shipping dateyear/month/date--Scheduled shipping date is inputted.
※In a No.t input, Date which pulled Delivery date to Transportation leadtime is set.
25Order STSnumber-受注ステータス X:内示、0:注文、1:確定、2:完了、9:取消を入力
※各ステータスの説明は【受注一覧】を参照下さい
26Direct deliverynumber-In SupplierDirect delivery, '1' is inputted.
27無償出荷
28受注種別
29便半角英数字2-
30得意先発注形態-10-得意先の発注形態を入力
31受注汎用項目1-40-導入会社で自由に定義できる項目
32受注汎用項目2-40-導入会社で自由に定義できる項目
33受注汎用項目3-40-導入会社で自由に定義できる項目
34受注汎用項目4-40-導入会社で自由に定義できる項目
35受注汎用項目5-40-導入会社で自由に定義できる項目
36***-40-今後のバージョンアップで使用するシステム予約項目
37***-40-今後のバージョンアップで使用するシステム予約項目
38***-40-今後のバージョンアップで使用するシステム予約項目
39***-40-今後のバージョンアップで使用するシステム予約項目
40***-40-今後のバージョンアップで使用するシステム予約項目


CSV download for package Change


Confirm of Sales order batch entry


Entry of Sales order batch entry


Result confirmation of Sales order batch entry


Resuluting output of Sales order batch entry



top   new list search recent   help   rss