Custom Project - Part1 Apr 11 2013 11:06:10

When opening page, popup must appear with request to enter user sopic ID

That info is entered into a db table and used later in xml export.

Quote Number - Load

when user inputs quote number and clicks load, main quote view loads info from:

database: PQDB, table: quotes.

showing dxf filenames in a quote page as well.

columns mapping:

Quote# = QuoteID

Customer ID = ClientID

Description = QuoteLineItems\Description

Spec = QuoteLineItems\Spec

Thick = QuoteLineItems\Thick

Total =

Settings:

Original by date = Today + Laser lead time

Original ETA Date = Today + Laser lead time + Urgency

Freight Charges (dropdown list)- Store Freight Charge, fixed freight charge,freight forward, pickup , FIS.

Urgency (dropdown list) - Normal, In hurry - 1day, desperate - 2 days.

Delivery Area (dropdown list) - in town +1day, local courier + 1day, overnight + 2 days, Interstate + 6 days.

Warehouse (dropdown list) - Aucland, Christchurch.

Comments: user can input comment.

When customer entered all details, clicks “submit” gets popup confirmation screen.

Confirmation Popup.

Quote# - quote number that user loaded

Order Number# PO that user input on first page

Customer # - If customerID not = format, then load from sopicqecustomers.

Customer name - If customerID not = format, then load from sopicqecustomers.

customer address - If customerID not = format, then load from sopicqecustomers.

By Date = by date + eta date + Urgency

Job Items - loaded from psql

Jobs comments from user input on first page

Salesman - sopic id (that user enters at the beginning)

After verification user clicks confirm and all information entered into database and ready to be exported to xml.

Backend XML export Script.

automatic script that will export data from sql table to xml

XML Mapping

a. Customer number - Customer Number

b. Customer Reference - PO

c. Delivering stock Id -

d. Staff Id - sopc ID

e. Issuer Id -

f. Product code -

g. Quantity -

h. Header comment 1

i. Header comment 2

j. Header comment 3

k. Line comment 1

l. Line comment 2

m. Line comment 3

n. Include on Sopic documents

Beceriler: .NET, ASP, SQL, XML

Daha fazlasını görün: warehouse jobs, store salesman, quantity verification, part time sql jobs, overnight jobs, n.j. jobs, mapping jobs, local part time jobs, local part-time courier jobs, local delivery jobs, local delivery courier, local courier jobs, local courier job, local courier delivery jobs, local courier charges, local courier, lead to quotes, l.a. jobs, k jobs, jobs salesman, jobs in xml, jobs in warehouse, jobs in the local area, jobs courier, jobs as courier

Proje NO: #4418211