SCM - Adithya-Karthik - 2015-06-25 - 16728 - SNC-Program to send a WO_PO_LINE file to .Net application #Active
PECIFICATIONS
2015-06-25-Spec-SNC-Program to send a WO_PO_LINE file to .Net Application
Purpose
Create a program to generate a file (WO, PO & PO line) to send it to SNC.
Admin Info
Purpose
|
SNC - Program to send a WO_PO_LINE file to .Net application
|
Requested By
|
Jeffery Mau
|
Spec Created By
|
Adithya
|
Spec Created Date
|
06/29/2012
|
Spec QA by
|
Adithya
|
Objects
|
ZWO_PO_LINE
|
Document Status
|
Complete
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
|
2
|
Documentation
|
02
|
3
|
Development/ Config
|
04
|
4
|
Unit test in DEV
|
02
|
5
|
Unit test in QUA
|
02
|
6
|
Other activity
|
|
|
TOTAL
|
10
|
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]
SCM - Adithya-Venkat-Vamshi - 2015-06-24 - 16728 - SNC - .Net app for uploading work order confirmations (Jeff by 2015-07-06)
Documents
[Attach any document(s) received for the requirement(s)]
Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
Sl.
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]
This program is generate the file which will be sent to the .Net application. the file will facilitate the .Net application to have the data of Purchase Order and Purchase order Item for the Work Order number in the .Net data base.
In Scope:
[List the
activities to be included in scope]
Po number, PO line and Corresponding Work order numbers are triggered in the file.
Out of Scope:
[Out of scope activities]
Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
Write a program with to generate a .csv file with three fields Work Order, PO, Po line item.
Naming convention of the program can be ZWO_PO_LINE
Selection Fields:
Work Order Number: [RANGE] - [Field Name : ORDNO]
Work Order creation date: [RANGE] - [Field Name : CRETST]
Get out put in .CSV Format with fields
ORDNO (Work order Number), POORDNO (Purchase Order), POITMNO(Purchase order item)
Give an option to download the file to Desktop and Application Server.
PO Filtration: Same as Downloaded file.
The Downloaded file ignores all those Pos which are Closed.
Closed POs are termed as all the WOs of that PO are updated with all Phases, open POs are if any WO of that PO is open (left with any of the Phase Confirmation)
Test Plan
[List test scenarios/cases to be executed here]
Test ID
|
Test Scenario
|
Expected Results
|
SNC001
|
Execute the program wide open
|
A file must be generated with all the open POs and its work orders and PO line numbers
|
Solution Details
[Provide complete technical details for configuration or programming here]
Create a Program
ZWO_PO_LINE which shall generate a file with 3 fields.
Logic:
Take Work order number and insert in ORDNO in table /1OM/REWORWOH100
get POORDNO (Purchase Order) & ORDID (GUI of WO number to pass it in item table) & ORDNO (Work order Number)
PASS ORDID in to Table /1OM/REWORWOI100 and get value POITMNO.
Get out put in .CSV Format with fields
ORDNO (Work order Number), POORDNO (Purchase Order), POITMNO(Purchase order item)
Issues
[List Issues / Bugs identified in configuration or development]