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

 
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-Order status is inputted.
0:Unofficial order, 1:Determine, 2:Complete, 9:Cancel
26Direct deliverynumber-In SupplierDirect delivery, '1' is inputted.


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