COMET - DDUMP Data File Dump [12.02/2011.457] 03/14/12 09:27 Page 1
File: ^COO1A on S32 Type: KEY Beginning at 1 for 94 Record: 94 Key: 7 Key Position:
1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234
! ! ! 100
!===========================> ^COO1A <=============================! ! 200
! ! ! 300
! File Format & Length Declaratives ! ! 400
! ! ! 500
! File Name: WWO1A OPEN ORDER HEADER ! ! 600
! ! ! 700
! Type: K Record: 999 Key: 9 Image: N ! ! 800
! ! ! 900
! #FILES File Name: ORDER.OPEN.H Date: 01/06/06 ! ! 1000
! ! ! 1100
!--------------------------------------------------------------------! ! 1200
! ! ! 1300
! ! ! 1400
LENGTH 2.0 & LOCAL OHNDPCT ! ! 1500
LENGTH 3.0 & LOCAL OPKGS,OPCT,OWGHT ! ! 1600
LENGTH 4.2 & LOCAL ODISCPCT,OPCKCHG,OTAXPCT ! ! 1700
LENGTH 6.2 & LOCAL OFRT,OHANDAMT ! ! 1800
LENGTH 6.4 & LOCAL OTAXPCL ! ! 1900
LENGTH 7.2 & LOCAL ODEPOSIT,ODISCAMT,OMISC1 ! ! 2000
LENGTH 7.2 & LOCAL OUNITS,OTAXAMT ! ! 2100
LENGTH 8.2 & LOCAL OCOMMRME,OCOMMPD1,OCOMMPD2 ! ! 2200
LENGTH 8.2 & LOCAL OCOMPAID ! ! 2300
LENGTH 9.2 & LOCAL OCOST,OCRPAYREQ,ODEPOSIL ! ! 2400
LENGTH 9.2 & LOCAL ODISCAML,OHOLDAMT,OGROSS ! ! 2500
LENGTH 9.2 & LOCAL OMISC,ONET,OTXBASIS ! ! 2600
LENGTH 1 & LOCAL OCFAFLG$,OCFASTK$,OCLRCD1$ ! ! 2700
LENGTH 1 & LOCAL OCLRCD2$,OCAFLGH$,OCOMMRES$ ! ! 2800
LENGTH 1 & LOCAL OCRDSC$,OCRLIM$,OCRMSC$ ! ! 2900
LENGTH 1 & LOCAL OCRPST$,OCRPAY$,OCRSLE$ ! ! 3000
LENGTH 1 & LOCAL OCUTYRD$,OCUTARVD$,ODSCFLG$ ! ! 3100
LENGTH 1 & LOCAL OEMLFI$,OEMLOPA$,OEMLSA$ ! ! 3200
LENGTH 1 & LOCAL OFRFLAG$,OFOFLG$,OFRTCODE$ ! ! 3300
LENGTH 1 & LOCAL OFURNOP$,OFURNOPA$ ! ! 3400
LENGTH 1 & LOCAL OIBMFLAG$,OLATE$,OMILLSTK$ ! ! 3500
LENGTH 1 & LOCAL ONEWORD$,OORIGCFA$,OPUFLG$ ! ! 3600
LENGTH 1 & LOCAL OPROFLG$,OREPRNT$,ORESFLG$ ! ! 3700
LENGTH 1 & LOCAL ORETURN$,ORUSHOMO$,ORUSHOP$ ! ! 3800
LENGTH 1 & LOCAL OSAMPFLG$,OPKGSAMP$ ! ! 3900
LENGTH 1 & LOCAL OSTATUS$,OXMLFLAG$ ! ! 4000
LENGTH 2 & LOCAL OBTCNTRY$,OCANCEL$ ! ! 4100
LENGTH 2 & LOCAL OINNOFLG$,OSLSTYP$,OSTATE$ ! ! 4200
LENGTH 2 & LOCAL OSTCNTRY$,OTERMCDE$,CUPS$ ! ! 4300
LENGTH 3 & LOCAL OBOFLAG$,OEMLSEQ1$ ! ! 4400
LENGTH 3 & LOCAL OEMLSEQ2$,OEMLSEQ3$,OHOLD1$ ! ! 4500
LENGTH 3 & LOCAL OHOLD2$,OLRFROM$,OMSGCD1$ ! ! 4600
LENGTH 3 & LOCAL OMSGCD2$,OINIT$,OINITL$ ! ! 4700
LENGTH 3 & LOCAL OINITR$,OEMLREP$,OSNBR1$ ! ! 4800
LENGTH 3 & LOCAL OSNBR2$ ! ! 4900
LENGTH 4 & LOCAL OEOFLAG$,OPTDATE$ ! ! 5000
LENGTH 5 & LOCAL OCYVEND$ ! ! 5100
LENGTH 6 & LOCAL OBILLPER$,OCOMMPER$,CNBR$ ! ! 5200
LENGTH 6 & LOCAL OAPCP1$,OAPCP2$,OFAPCR$ ! ! 5300
COMET - DDUMP Data File Dump [12.02/2011.457] 03/14/12 09:27 Page 2
File: ^COO1A on S32 Type: KEY Beginning at 1 for 94 Record: 94 Key: 7 Key Position:
1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234
LENGTH 6 & LOCAL OFINNBR$,OOMORFLG$,OSPNBR$ ! ! 5400
LENGTH 8 & LOCAL OOCSRTDT$,OOCSRTTM$ ! ! 5500
LENGTH 9 & LOCAL INVCNBR$,ORNBR$ ! ! 5600
LENGTH 10 & LOCAL OBORELDT$,OCOMPDTE$,ODEPDT$ ! ! 5700
LENGTH 10 & LOCAL OFREE10$,OINVDTE$,OLRELDT$ ! ! 5800
LENGTH 10 & LOCAL ORDATE$,ORESCDTE$,OSHIPDTE$ ! ! 5900
LENGTH 10 & LOCAL OZIP$ ! ! 6000
LENGTH 15 & LOCAL OCORNBR$,OFOB$,OFRTTRM$ ! ! 6100
LENGTH 15 & LOCAL OGUARBY$,ORORNBR$,OSHIPVIA$ ! ! 6200
LENGTH 18 & LOCAL OCLIENT$ ! ! 6300
LENGTH 21 & LOCAL OCITY$ ! ! 6400
LENGTH 35 & LOCAL OBATTN$,OATTN$,OADR1$ ! ! 6500
LENGTH 35 & LOCAL OADR2$,ONAME$,OSM1$,OSM2$ ! ! 6600
LENGTH 79 & LOCAL OFIL0060$ ! ! 6700
! ! ! 6800
! ! ! 6900
! Description Type Len Pos ! ! 7000
! ------------------------------------------! ! 7100
0060 FORMAT _ ! ! 7200
ORNBR$;_ ! ORDER # S 9 0 ! ! 7300
CNBR$;_ ! CUST # S 6 9 ! ! 7400
OBATTN$;_ ! BILL TO ATTENTION S 35 15 ! ! 7500
ONAME$;_ ! SHIP TO NAME S 35 50 ! ! 7600
OADR1$;_ ! SHIP TO ADDRESS 1 S 35 85 ! ! 7700
OADR2$;_ ! SHIP TO ADDRESS 2 S 35 120 ! ! 7800
OCITY$;_ ! SHIP TO CITY S 21 155 ! ! 7900
OSTATE$;_ ! SHIP ST S 2 176 ! ! 8000
OZIP$;_ ! SHIP TO ZIP CODE S 10 178 ! ! 8100
OATTN$;_ ! SHIP ATTENTION S 35 188 ! ! 8200
OSM1$;_ ! SIDE MARK S 35 223 ! ! 8300
OSM2$;_ ! SIDE MARK S 35 258 ! ! 8400
OCFAFLG$;_ ! CFA FLG S 1 293 ! ! 8500
ORESFLG$;_ ! RES FLG S 1 294 ! ! 8600
OSHIPVIA$;_ ! SHIP VIA S 15 295 ! ! 8700
OCORNBR$;_ ! CUSTOMER ORDER NUMBER S 15 310 ! ! 8800
ORORNBR$;_ ! REP ORDER NUMBER S 15 325 ! ! 8900
OHOLD1$;_ ! HLD FLG1 S 3 340 ! ! 9000
OHOLDAMT;_ ! HOLD FOR AMOUNT N 9.2 343 ! ! 9100
OHOLD2$;_ ! HLD FLG2 S 3 354 ! ! 9200
OFRTTRM$;_ ! FREIGHT TERMS S 15 357 ! ! 9300
OFREE10$;_ ! FREE 10 S 10 372 ! ! 9400
OCLIENT$;_ ! CLIENT S 18 382 ! ! 9500
ODEPOSIT;_ ! DEPOSIT N 7.2 400 ! ! 9600
ODISCPCT;_ ! DISC PCT N 4.2 409 ! ! 9700
ODSCFLG$;_ ! D F S 1 415 ! ! 9800
OPROFLG$;_ ! PRO FLG S 1 416 ! ! 9900
OTERMCDE$;_ ! TRMS CDE S 2 417 ! ! 10000
OGUARBY$;_ ! GUARANTEED BY S 15 419 ! ! 10100
ORDATE$;_ ! ORDER DATE S 10 434 ! ! 10200
OSPNBR$;_ ! SPECIFIER NUMBER S 6 444 ! ! 10300
OFINNBR$;_ ! FINISHER S 6 450 ! ! 10400
OBORELDT$;_ ! BACK ORDER REL DATE S 10 456 ! ! 10500
OLRELDT$;_ ! LAST RELEASE DATE S 10 466 ! ! 10600
COMET - DDUMP Data File Dump [12.02/2011.457] 03/14/12 09:27 Page 3
File: ^COO1A on S32 Type: KEY Beginning at 1 for 94 Record: 94 Key: 7 Key Position:
1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234
OLRFROM$;_ ! LAST REL FROM S 3 476 ! ! 10700
OINIT$;_ ! OPERATOR ENTER ORDR S 3 479 ! ! 10800
OINITR$;_ ! OPER LAST RELEASE S 3 482 ! ! 10900
OINITL$;_ ! OPER LAST MAINTAIN S 3 485 ! ! 11000
OBOFLAG$;_ ! BACK ORDER FLAG S 3 488 ! ! 11100
OGROSS;_ ! MATERIAL AMOUNT N 9.2 491 ! ! 11200
ODISCAMT;_ ! DISCOUNT AMOUNT N 7.2 502 ! ! 11300
OMISC;_ ! MISCEL- LANEOUS N 9.2 511 ! ! 11400
OMISC1;_ ! MISCEL- LANEOUS1 N 7.2 522 ! ! 11500
OPKGS;_ ! # OF PCK N 3.0 531 ! ! 11600
OWGHT;_ ! WGHT N 3.0 536 ! ! 11700
OFRT;_ ! FREIGHT N 6.2 541 ! ! 11800
OTAXPCT;_ ! TAX PCT N 4.2 549 ! ! 11900
OTAXAMT;_ ! TAX AMOUNT N 7.2 555 ! ! 12000
ONET;_ ! NET N 9.2 564 ! ! 12100
INVCNBR$;_ ! INVOICE NUMBER S 9 575 ! ! 12200
OINVDTE$;_ ! INVOICE DATE S 10 584 ! ! 12300
OSHIPDTE$;_ ! SHIP DATE S 10 594 ! ! 12400
CUPS$;_ ! ZONE S 2 604 ! ! 12500
OCOST;_ ! COST OF ORDER N 9.2 606 ! ! 12600
OUNITS;_ ! ORDER UNITS N 7.2 617 ! ! 12700
OPCKCHG;_ ! PACK CHG N 4.2 626 ! ! 12800
OHNDPCT;_ ! HAND PCT N 2.0 632 ! ! 12900
OHANDAMT;_ ! HANDLING AMOUNT N 6.2 636 ! ! 13000
OSNBR1$;_ ! SALES REP 1 S 3 644 ! ! 13100
OSNBR2$;_ ! SALES REP 2 S 3 647 ! ! 13200
OPCT;_ ! PCT OF SALE TO REP1 N 3.0 650 ! ! 13300
OCRPAYREQ;_ ! PAY FOR CREDIT REAL N 9.2 655 ! ! 13400
OCRSLE$;_ ! CREDIT SALE S 1 666 ! ! 13500
OCRPST$;_ ! CREDIT PAST S 1 667 ! ! 13600
OCRLIM$;_ ! CREDIT LIMIT S 1 668 ! ! 13700
OCRDSC$;_ ! CREDIT DISCOUNT S 1 669 ! ! 13800
OCRPAY$;_ ! CREDIT PAYMENT S 1 670 ! ! 13900
OCRMSC$;_ ! CREDIT MISC S 1 671 ! ! 14000
OSTATUS$;_ ! DELETE CONFIRMED S 1 672 ! ! 14100
ONEWORD$;_ ! NEW ORDER FLAG S 1 673 ! ! 14200
OREPRNT$;_ ! REPRINT FLAG S 1 674 ! ! 14300
OLATE$;_ ! LATE CODE S 1 675 ! ! 14400
OFRFLAG$;_ ! FAX RPT FLG S 1 676 ! ! 14500
OMILLSTK$;_ ! MILL STK FLG S 1 677 ! ! 14600
OCUTYRD$;_ ! CUT YARDAGE ORDER S 1 678 ! ! 14700
OPUFLG$;_ ! PER USE FLG S 1 679 ! ! 14800
OFOFLG$;_ ! 1ST ORD FLG S 1 680 ! ! 14900
ORETURN$;_ ! RETURN CODE S 1 681 ! ! 15000
OSAMPFLG$;_ ! SAMPLE FLAG S 1 682 ! ! 15100
OCANCEL$;_ ! ORDER CANCEL REASON S 2 683 ! ! 15200
OBILLPER$;_ ! BILL PER. S 6 685 ! ! 15300
OCOMMPER$;_ ! COMM PERIOD S 6 691 ! ! 15400
OPTDATE$;_ ! PICK TICK DATE S 4 697 ! ! 15500
OEOFLAG$;_ ! ELIG ORD FLAG S 4 701 ! ! 15600
ORESCDTE$;_ ! RESERVE CANCEL DATE S 10 705 ! ! 15700
OFOB$;_ ! FOB S 15 715 ! ! 15800
OCAFLGH$;_ ! COMM ADJ FLG HDR S 1 730 ! ! 15900
COMET - DDUMP Data File Dump [12.02/2011.457] 03/14/12 09:27 Page 4
File: ^COO1A on S32 Type: KEY Beginning at 1 for 94 Record: 94 Key: 7 Key Position:
1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234
OPKGSAMP$;_ ! SAMPLE PKG FLG S 1 731 ! ! 16000
OTXBASIS;_ ! TAXABLE BASIS N 9.2 732 ! ! 16100
OORIGCFA$;_ ! ORIGINAL CFA FLAG S 1 743 ! ! 16200
OSLSTYP$;_ ! SALES TYPE S 2 744 ! ! 16300
ODEPDT$;_ ! DEPOSIT DATE S 10 746 ! ! 16400
OCYVEND$;_ ! CUT YARDAGE VENDOR # S 5 756 ! ! 16500
OCUTARVD$;_ ! CUTTING ARRIVED FLAG S 1 761 ! ! 16600
OCFASTK$;_ ! CFA FROM STOCK S 1 762 ! ! 16700
OOCSRTDT$;_ ! OC SORT DATE S 8 763 ! ! 16800
OOCSRTTM$;_ ! OC SORT TIME S 8 771 ! ! 16900
OOMORFLG$;_ ! OMOR FLAG S 6 779 ! ! 17000
OCOMPDTE$;_ ! COMM PAID DATE S 10 785 ! ! 17100
OCOMPAID;_ ! COMM PAID AMT N 8.2 795 ! ! 17200
OFAPCR$;_ ! FAP COMM RECORDED S 6 805 ! ! 17300
OAPCP1$;_ ! FAP COMM PAID 1 S 6 811 ! ! 17400
OCOMMPD1;_ ! AMT COMM PAID 1 N 8.2 817 ! ! 17500
OAPCP2$;_ ! FAP COMM PAID 2 S 6 827 ! ! 17600
OCOMMPD2;_ ! AMT COMM PAID 2 N 8.2 833 ! ! 17700
OCOMMRME;_ ! AMT COMM MONTH END N 8.2 843 ! ! 17800
OFRTCODE$;_ ! FREIGHT CODE S 1 853 ! ! 17900
OFURNOP$;_ ! FURN OP FLAG S 1 854 ! ! 18000
OXMLFLAG$;_ ! XML FLAG S 1 855 ! ! 18100
OMSGCD1$;_ ! MSG CD 1 S 3 856 ! ! 18200
OMSGCD2$;_ ! MSG CD 2 S 3 859 ! ! 18300
OCLRCD1$;_ ! CLEAR CD 1 S 1 862 ! ! 18400
OCLRCD2$;_ ! CLEAR CD 2 S 1 863 ! ! 18500
OFURNOPA$;_ ! FURN OPA FLAG S 1 864 ! ! 18600
OIBMFLAG$;_ ! INVOICED BY MILL FLAG S 1 865 ! ! 18700
OBTCNTRY$;_ ! BILL-TO COUNTRY CD S 2 866 ! ! 18800
OSTCNTRY$;_ ! SHIP-TO COUNTRY CD S 2 868 ! ! 18900
OCOMMRES$;_ ! COMMERCIAL/RESIDENTIAL S 1 870 ! ! 19000
ORUSHOMO$;_ ! RUSH ORDER OMOX FLAG S 1 871 ! ! 19100
ORUSHOP$;_ ! RUSH ORDER OP FLAG S 1 872 ! ! 19200
OEMLSEQ1$;_ ! EMAIL SEQ # 1 S 3 873 ! ! 19300
OEMLSEQ2$;_ ! EMAIL SEQ # 2 S 3 876 ! ! 19400
OEMLSEQ3$;_ ! EMAIL SEQ # 3 S 3 879 ! ! 19500
OEMLOPA$;_ ! EMAIL OPA FLAG S 1 882 ! ! 19600
OEMLSA$;_ ! EMAIL SHIP ACK FLAG S 1 883 ! ! 19700
OEMLFI$;_ ! EMAIL FINAL INVC FLAG S 1 884 ! ! 19800
OINNOFLG$;_ ! INNOVATIONS ORDER FLAG S 2 885 ! ! 19900
OEMLREP$;_ ! REP EMAIL SEQ # S 3 887 ! ! 20000
ODEPOSIL;_ ! DEPOSIT AMT (LONG) N 9.2 890 ! ! 20100
ODISCAML;_ ! DISCOUNT AMT (LONG) N 9.2 901 ! ! 20200
OTAXPCL;_ ! TAX PCT (LONG) N 6.4 912 ! ! 20300
OFIL0060$ ! FILLER 0060 S 79 920 ! ! 20400
! ! ! 20500
!====================================================================! ! 20600
End of listing - 206 Records