PDA

View Full Version : Trapping a variable row



Guy Chowning
December 23rd, 2009, 12:13 PM
A sample page from the report is shown below.




SHIPDATE VEHICLE ID SHIPMENT Y INVENTRY P.CONTRACT LN FOB SHIPPER PURCHASE ACCRUED ACCRUED ACCRUED ACCRUAL
TICKET NO FRT CARRIER SHIPMENT BR D CODE S.CONTRACT LN FOB CUSTOMER - COST - -FREIGHT- -INVCOST- - SALES - -CODES-

11/11/09 INO 96029 504426 NP F 100 RS09574FNP 01 M1 .00 .00 .00
MACHLO INGR90 01 504426 HQ RS09574FNP 01 S1 GALGHR 0 LBS 8500.00 0 0
11/18/09 INO 71056 508265 NP F 100 RS09574FNP 01 M1 .00 .00 336732.15
MADTYK INGR90 01 508265 HQ RS09574FNP 01 S1 GALGHR 0 LBS 8500.00 0 3017120
G/L ACCOUNT SRC D/C
PRODUCT CLASS TOTALS F100 NP 420-024-5701.00 f/a D 17000.00 .00 17000.00 .00 336732.15
400-002-1040.00 f/a C 17000.00 0 LBS 0 3017120
400-001-2020.00 s/a D 336732.15 .00 TNS .00 1346.93
420-024-5111.00 s/a C 336732.15

11/06/09 TKNP TABDAD 502150 NP F 110 NP-028837Z 01 M1 .00 .00 24847.20
TABDAD CLAR70 01 502150 HQ RMR028837Z 01 S1 ALLCHM 0 LBS 726.00 0 42840
11/10/09 TKNP MABWPK 503454 NP F 110 NP-9110632 01 M3 .00 .00 23446.08
MABWPK 503454 HQ RMR9110632 01 S3 AUDHEM 0 LBS .00 0 41868
11/09/09 TKNP TABOCN 503493 NP F 110 NP-028870Z 01 M1 .00 .00 26232.80
TABOCN STMSHP 02 503493 HQ RMR028870Z 01 S1 CHOCHM 0 LBS 2100.00 0 43360
CCIC50 03 503493 150.00
BOHA50 04 503493 150.00

11/10/09 TKNP TABWMF 503693 NP F 110 NP-028870Z 01 M1 .00 .00 26196.50
TABWMF STMSHP 02 503693 HQ RMR028870Z 01 S1 CHOCHM 0 LBS 2100.00 0 43300
CCIC50 03 503693 150.00
BOHA50 04 503693 150.00

11/13/09 TKNP TACUPL 505911 NP F 110 NP-0029562 01 M1 .00 .00 24194.88
TACUPL CLAR70 01 505911 HQ RMR0029562 01 S1 OMNISOURC 0 LBS 565.00 0 39024
11/17/09 TKNP TADNYV 507619 NP F 110 NP-0029562 01 M1 .00 .00 25121.16
TADNYV CLAR70 01 507619 HQ RMR0029562 01 S1 OMNISOURC 0 LBS 565.00 0 40518
11/20/09 TKNP TAEDHC 509663 NP F 110 NP-0029562 01 M1 .00 .00 24920.28
TAEDHC CLAR70 01 509663 HQ RMR0029562 01 S1 OMNISOURC 0 LBS 565.00 0 40194
11/23/09 TKNP TAENDR 510558 NP F 110 NP-0029562 01 M1 .00 .00 24161.40
TAENDR CLAR70 01 510558 HQ RMR0029562 01 S1 OMNISOURC 0 LBS 565.00 0 38970
11/23/09 TKNP TAESLN 510930 NP F 110 NP-0029562 01 M1 .00 .00 25701.48
TAESLN CLAR70 01 510930 HQ RMR0029562 01 S1 OMNISOURC 0 LBS 565.00 0 41454
11/23/09 TKNP TAESWP 510975 NP F 110 NP-0029562 01 M1 .00 .00 25065.36
TAESWP CLAR70 01 510975 HQ RMR0029562 01 S1 OMNISOURC 0 LBS 565.00 0 40428
11/24/09 TKNP TAEUZY 511325 NP F 110 NP-0029562 01 M1 .00 .00 25489.44
TAEUZY CLAR70 01 511325 HQ RMR0029562 01 S1 OMNISOURC 0 LBS 565.00 0 41112
11/25/09 TKNP TAFFXG 512808 NP F 110 NP-9110632 01 M3 .00 .00 23284.80