Customer Account Processing

Input:

1. NameLast
2. AccountNumber

Output:

1. Display Customer Account information

Assumptions:

All inputs are syntactically correct.

Errors:

AccountNumber does not exist

NameLast does not exist

Process Description:

Query the Customer account data store for the AccountNumber given and return information on NewCharges,OverdueAmount and CurrentBalance.

Process Name:Generate Customer Invoice (1.6.3)

Input:

1. AccountNumber
2. NameLast
3. Consignment Agreements
4. Subscription Agreements
5. Retail Delivery
6. Household Delivery

Output:

1. An Invoice for the Customer including InvoiceNumber,InvoiceDate,AccountNumber,InvoiceAmount,GST,PaymentReceived/LI>

Assumptions:

All inputs are syntactically correct.

Errors:

AccountNumber does not exist

NameLast does not exist

Process Description:

For the give account number, if it refers to a household customer,

Find all newspaper subscriptions and using the subscription number locate all records in household delivery table. Tally up all the quantities delivered for each newspaper product, and multiply by the price of the respective product and calculate total for the invoice; adding a record in the invoice table

Summarize sales all the household delivery records (referred to by the subscripton numbers) and create record in the product sales history table. Then remove all entries in the household delivery records (referred to by the subscripton numbers).

Display and print invoice

if it refers to a retail outlet,

Find all newspaper consignments and using the agreement number locate all records in the retail consignment table. Tally up all the quantities delivered for each newspaper and magazine product, and multiply by the price of the respective product and calculate total for the invoice; adding a record in the invoice table.

Summarize sales all the retail consignment records (referred to by the subscripton numbers) and create record in the product sales history table. Then remove all entries in the household delivery records (referred to by the subscripton numbers).

Dispaly and print invoice.

Process Name:Generate all invoices (1.6.4)

Input:

1. AccountNumbers

Output:

An Invoice for all Customers including

Assumptions:

All inputs are syntactically correct.

Errors:

AccountNumber does not exist

Process Description:

For all household and retail accounts call Generate Customer Invoice (1.6.3)

Back To Top
Back to Process Spec Menu