SY1TAX Tax Sched. To State & Zip Code XRef File (SY1TAX_TaxSchedToStateZipXref) Level: 4.40 Record Type: 1 Tax Sched to State_Zip Code Xref Record 08/28/2009 File Type: Mkeyed Key Size: 21 Rec Len: 45 Min Len: 35 Define: Y
Main Key (KNO=0)TaxSchedule(1,9)+StateCode(10,2)+ZipCode(12,10) 2nd Key (KNO=1) StateCode(10,2)+TaxSchedule(1,9)+ZipCode(12,10) 3rd Key (KNO=2) ZipCode(12,10)+TaxSchedule(1,9)+StateCode(10,2)
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Tax Schedule. . . . . . . . . . . . . . TaxSchedule . . . . . . . . . Uppercase *(1,9) State Code. . . . . . . . . . . . . . . StateCode . . . . . . . . . . Uppercase *(10,2) Zip Code. . . . . . . . . . . . . . . . ZipCode . . . . . . . . . . . Uppercase *(12,10) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (22,14) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. ________ Total Bytes 38