2/16/07 14:30:11 Order header by ship-to cust/order number Page: 1 ================================================================================ File: OCRHX7 Trigger buffer length: 3220 Library: MYLOC Number of fields: 121 Record: OCRHR Record length: 1441 ================================================================================ Key position: 200 Key length: 17 NOT UNIQUE DCSCUS 200 8 Ship-to Customer DCORD# 1 9 Order Number ================================================================================ Field Description Bytes From To Length Type Name ================================================================================ Order Number 9 1 9 9.0 S DCORD# Date Entered 10 10 19 10 L DCODAT Default value: '0001-01-01' Order Type: Blanket/Standard 1 20 20 1 A DCOTYP Order In Use 1 21 21 1 A DCIUSE Bill-to Customer 8 22 29 8 A DCBCUS Bill-to Name 30 30 59 30 A DCBNAM Bill-to Address 35 60 94 35 A DCBAD1 Attention 25 95 119 25 A DCBATT Phone Number 20 120 139 20 A DCBPHO Terms Code 2 140 141 2 A DCTRCD Not used 28 142 169 28 A DCNU28 Ship Via 30 170 199 30 A DCSHVI Ship-to Customer 8 200 207 8 A DCSCUS Ship-to Name 30 208 237 30 A DCSNAM Ship-to Address 1 35 238 272 35 A DCSAD1 Ship-to Address 2 35 273 307 35 A DCSAD2 Ship-to Address 3 35 308 342 35 A DCSAD3 Ship-to Address 4 35 343 377 35 A DCSAD4 Ship-to Address 5 35 378 412 35 A DCSAD5 Ship-to Address 6 35 413 447 35 A DCSAD6 Ship-to Address 7 35 448 482 35 A DCSAD7 Ship-to Address 8 35 483 517 35 A DCSAD8 Ship-to Address 9 35 518 552 35 A DCSAD9 Ship-to Address 10 35 553 587 35 A DCSAD10 Ship-to Postal Code 30 588 617 30 A DCSPOS Purchase Order 30 618 647 30 A DCPO Quote Number 12 648 659 12 A DCQUOT Currency 2 660 661 2 A DCCURR Promise Date 10 662 671 10 L DCMDAT Default value: '0001-01-01' Salesman 5 672 676 5 A DCSLMN Commission percentage 4 677 680 4.2 S DCCPCT Commission rate 5 681 685 5.2 S DCCRAT Reserve 5 686 690 5 A DCRES FST Licence 15 691 705 15 A DCFSTL PST Licence 15 706 720 15 A DCPSTL Prepaid Collect 1 721 721 1 A DCPPCL Global Discount Code 3 722 724 3 A DCGDIS Global Discount Flag 1 725 725 1 A DCGDSF Status New, A, B/o, Comp 1 726 726 1 A DCSTAT Work Order Print Status 1 727 727 1 A DCWOPR Next description line no 3 728 730 3.0 S DCNDL# Net Total 10 731 740 10.2 S DCTOTO Total Discounts 10 741 750 10.2 S DCTDIS Tax Total 10 751 760 10.2 S DCTTAX Freight Total 10 761 770 10.2 S DCTFRT Weight Total 10 771 780 10.2 S DCTWGT Weight Unit 3 781 783 3 A DCTWUN Volume Total 10 784 793 10.2 S DCTVOL Volume Unit 3 794 796 3 A DCTVUN Available for Production 1 797 797 1 A DCAVPR Date Changed 10 798 807 10 L DCUDAT Default value: '0001-01-01' Entered by User 10 808 817 10 A DCUSRE Changed by User 10 818 827 10 A DCUSRC Last Invoice Created 9 828 836 9.0 S DCINV# Order Balance 10 837 846 10.2 S DCOBAL A/R Bank 1 847 847 1 A DCARBK Default Stock Loc 3 848 850 3 A DCSTKL Reference Invoice 9 851 859 9.0 S DCRFNO Reference Date 10 860 869 10 L DCXDAT Default value: '0001-01-01' Territory 4 870 873 4 A DCTERR Pick Slip Print Status 1 874 874 1 A DCSLIP Carrier Code 17 875 891 17 A DCCARC Service Code 3 892 894 3 A DCSERC Shipped Date 10 895 904 10 L DCSDAT Default value: '0001-01-01' Credit Hold Date NOT USE 10 905 914 10 L DCHDAT Default value: '0001-01-01' Don't Ship Before 10 915 924 10 L DCDDAT Default value: '0001-01-01' Confirm Ship Date NOT USE 10 925 934 10 L DCFDAT Default value: '0001-01-01' Reschedule Date NOT USE 10 935 944 10 L DCRDAT Default value: '0001-01-01' Request Date 10 945 954 10 L DCQDAT Default value: '0001-01-01' Cancel Date 10 955 964 10 L DCCDAT Default value: '0001-01-01' Hold Status Reason Code 2 965 966 2 A DCHREA Allow Back Order Code 1 967 967 1 A DCBOFG Auto Pick List Create 1 968 968 1 A DCAPLG FOB Code 3 969 971 3 A DCFOBC Ship Complete 1 972 972 1 A DCSCOM Order Source Man/Edi/Fax 3 973 975 3 A DCOSRC Order Faxed 1 976 976 1 A DCOFXD Sold from Customer 8 977 984 8 A DCSLCS Pay By Credit card 1 985 985 1 A DCCRTY Credit card code 2 986 987 2 A DCCRDT Credit card Number 16 988 1003 16 A DCCRD# Expiry Date 8 1004 1011 8 A DCEXPR Card Holder 30 1012 1041 30 A DCHODR Need Authorized Amount 10 1042 1051 10.2 S DCCRNM Allow ship Before auth. 1 1052 1052 1 A DCSHBF Customer Client# 20 1053 1072 20 A DCCLEN Global Quantity 10 1073 1082 10.2 S DDFTTX Future Field 1 10 1083 1092 10 A DCFUT1 Future Field 2 10 1093 1102 10 A DCFUT2 Future Flag 1 1 1103 1103 1 A DCFLG1 Future Flag 2 1 1104 1104 1 A DCFLG2 Cust. Reference 20 1105 1124 20 A DCREFN Plant Code 3 1125 1127 3 A DCPLNT Future Field 3 10 1128 1137 10 A DCFUT3 Future Field 4 10 1138 1147 10 A DCFUT4 Future Field 5 15 1148 1162 15 A DCFUT5 Future Field 6 15 1163 1177 15 A DCFUT6 Future Field 7 20 1178 1197 20 A DCFUT7 Future Field 8 20 1198 1217 20 A DCFUT8 Future Field 9 30 1218 1247 30 A DCFUT9 Future Date 1 10 1248 1257 10 L DCDAT1 Default value: '0001-01-01' Future Date 2 10 1258 1267 10 L DCDAT2 Default value: '0001-01-01' Future Flag 3 1 1268 1268 1 A DCFLG3 Future Flag 4 1 1269 1269 1 A DCFLG4 Future Flag 5 1 1270 1270 1 A DCFLG5 Future Flag 6 1 1271 1271 1 A DCFLG6 Future Flag 7 1 1272 1272 1 A DCFLG7 Future Field 10 10 1273 1282 10.0 S DCFUT10 Future Field 11 10 1283 1292 10.0 S DCFUT11 Future Field 12 11 1293 1303 11.2 S DCFUT12 Future Field 13 11 1304 1314 11.2 S DCFUT13 Future Field 14 15 1315 1329 15.5 S DCFUT14 Future Field 15 15 1330 1344 15.5 S DCFUT15 Future Field 16 15 1345 1359 15.5 S DCFUT16 Future Field 17 3 1360 1362 3.0 S DCFUT17 Future Field 18 3 1363 1365 3.0 S DCFUT18 Future Field 19 5 1366 1370 5.0 S DCFUT19 Future Field 20 5 1371 1375 5.0 S DCFUT20 Department Number 30 1376 1405 30 A DCDEPT Promotion Number 35 1406 1440 35 A DCPROM Claim Order 1 1441 1441 1 A DCCLMO Default value: '2' ================================================================================