Page 224 - Accounting Information Systems
P. 224
CHAPT E R 4 The Revenue Cycle 195
Billing Last Payment Date 1 12/8/07 1 12/12/07 1 12/5/07 8 12/16/07 1 12/9/07 8 12/7/07 15 12/17/07 Billing Last Payment Date 1 12/8/07 1 12/12/07 1 12/5/07 8 12/16/07 1 12/9/07 8 12/7/07 15 12/17/07
Original Account Receivable Master File Credit Current Date Limit Balance 1000 350 1500 600 1500 1000 2000 100 1000 800 2000 700 2000 150 New Account Receivable Master File Credit Current Date Limit Balance 1000 600 1500 600 1500 1000 2000 120 1000 800 2000 700 2000 650
Update Fields Address 123 Elm St., City 35 Main S. 510 Barclay Dr. Beth. 26 Taylo Rd. Alltn. 4 High St., Naz. 850 1st, Beth 78 Market Alltn. Address 123 Elm St., City 35 Main S. 510 Barclay Dr. Beth. 26 Taylo Rd. Alltn. 4 High St., Naz. 850 1st, Beth. 78 Market Alltn.
PK ACCT NUM 1 2 3 4 5 6 7 ACCT NUM 1 2 3 4 5 6 7
Invoice Amount 250 20 500
ORDERS Qnty Unit Sold Price 10 25 2 10 5 100
SALES
FROM Shipping Charges 10 5 20 Transaction File Sorted by Secondary Key to Primary Key of
RECEIVABLE Carrier Code 011 011 011 Master File.
ACCOUNTS Ship Order Date Date 12/24 12/22 12/24 12/22 12/24 12/22
OF Sales Order Transaction File Inven Num 17 14 16
UPDATE SK Acct Num 1 4 7
RE 4-23 Order # 3 1 2
GU PK
FI
