     AP_VendorListingWrk                   AP Vendor Listing Work          Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AP_VendorListing_rpt
     SQL Def: Y  SysDB: N                            "MAS_"+%C$+"/AP"+%C$+"/AP_VendorListingWrk"+%S$+".M4T"

     KPRIMARY: SortField

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
       2  GroupField. . . . . . . . . .    30 SNN  Group Field . . . . . . . . . .
       3  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .
       4  VendorNo. . . . . . . . . . .     7 SNN  Vendor Number . . . . . . . . .
       5  ReportSection . . . . . . . .     1 SNN  Report Section. . . . . . . . .
       6  SequenceNo. . . . . . . . . .    14 SNN  Sequence Number . . . . . . . .
       7  VendorName. . . . . . . . . .    30 SNN  Vendor Name . . . . . . . . . .
       8  AddressLine1. . . . . . . . .    30 SNN  Address Line 1. . . . . . . . .
       9  AddressLine2. . . . . . . . .    30 SNN  Address Line 2. . . . . . . . .
      10  AddressLine3. . . . . . . . .    30 SNN  Address Line 3. . . . . . . . .
      11  City. . . . . . . . . . . . .    20 SNN  City. . . . . . . . . . . . . .
      12  State . . . . . . . . . . . .     2 SNN  State . . . . . . . . . . . . .
      13  ZipCode . . . . . . . . . . .    10 SNN  Zip Code. . . . . . . . . . . .
      14  CountryCode . . . . . . . . .     3 SNN  Country Code. . . . . . . . . .
      15  CountryName . . . . . . . . .    30 SNN  Country Name. . . . . . . . . .
      16  PrimaryContact. . . . . . . .    10 SNN  Primary Contact Code. . . . . .
      17  PrimaryContactName. . . . . .    30 SNN  Primary Contact Name. . . . . .
      18  TelephoneNo . . . . . . . . .    17 SNN  Telephone Number. . . . . . . .
      19  TelephoneExt. . . . . . . . .     5 SNN  Telephone Extension . . . . . .
      20  TelephoneNo2. . . . . . . . .    17 SNN  Contact Telephone Number 2. . .
      21  TelephoneExt2 . . . . . . . .     5 SNN  Contact Telephone Extension 1 .
      22  FaxNo . . . . . . . . . . . .    17 SNN  Fax Number. . . . . . . . . . .
      23  EmailAddress. . . . . . . . .   250 SNN  Email Address . . . . . . . . .
      24  URLAddress. . . . . . . . . .    50 SNN  URL Address . . . . . . . . . .
      25  TermsCode . . . . . . . . . .     2 SNN  Terms Code. . . . . . . . . . .
      26  TermsCodeDesc . . . . . . . .    30 SNN  Terms Code Description. . . . .
      27  Reference . . . . . . . . . .    15 SNN  Reference . . . . . . . . . . .
      28  TemporaryVendor . . . . . . .     1 SNN  Temporary Vendor. . . . . . . .
      29  CreditCardVendor. . . . . . .     1 SNN  Credit Card Vendor. . . . . . .
      30  HoldPayment . . . . . . . . .     1 SNN  Hold Payment. . . . . . . . . .
      31  ExemptionNoOnFile . . . . . .     1 SNN  Exemption Number on File. . . .
      32  TaxSchedule . . . . . . . . .     9 SNN  Tax Schedule. . . . . . . . . .
      33  TaxScheduleDesc . . . . . . .    30 SNN  Tax Schedule Description. . . .
      34  TaxClass. . . . . . . . . . .     2 SNN  Tax Class . . . . . . . . . . .
      35  TaxClassDesc. . . . . . . . .    30 SNN  Tax Class Description . . . . .
      36  AccountKey. . . . . . . . . .     9 SNN  Account Key . . . . . . . . . .
      37  Account . . . . . . . . . . .    41 SNN  Fully Formatted Account . . . .
      38  AccountDesc . . . . . . . . .    50 SNN  Account Description . . . . . .
      39  SeparateCheck . . . . . . . .     1 SNN  Separate Check. . . . . . . . .
      40  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .
      41  Sort. . . . . . . . . . . . .    10 SNN  Vendor Sort Field . . . . . . .
      42  BatchFax. . . . . . . . . . .     1 SNN  Batch Fax . . . . . . . . . . .
      43  UsePOReceiptOfInvForVendor. .     1 SNN  Use PO Receipt Of Inv For Vendo
      44  PrimaryPurchaseAddressCode. .     4 SNN  Purchase Address Code . . . . .
      45  VendorType. . . . . . . . . .     1 SNN  Vendor Type . . . . . . . . . .
      46  Form1099. . . . . . . . . . .     1 SNN  Default 1099 Form . . . . . . .
      47  TaxpayerIDSocialSecurityNo. .     9 SNN  Taxpayer ID/Social Security Num
      48  Box1099 . . . . . . . . . . .     3 SNN  Default 1099 Box. . . . . . . .
      49  MiscBox9. . . . . . . . . . .     1 SNN  Mark Misc Box 9 . . . . . . . .
      50  RemitToVendorName . . . . . .    30 SNN  Remit To Vendor Name. . . . . .
      51  RemitToAddressLine1 . . . . .    30 SNN  Remit To Address Line 1 . . . .
      52  RemitToAddressLine2 . . . . .    30 SNN  Remit To Address Line 2 . . . .
      53  RemitToAddressLine3 . . . . .    30 SNN  Remit To Address Line 3 . . . .
      54  RemitToCity . . . . . . . . .    20 SNN  Remit To City . . . . . . . . .
      55  RemitToState. . . . . . . . .     2 SNN  Remit To State. . . . . . . . .
      56  RemitToZipCode. . . . . . . .    10 SNN  Remit To Zip Code . . . . . . .
      57  RemitToCountryCode. . . . . .     3 SNN  Remit To Country Code . . . . .
      58  RemitToCountryName. . . . . .    30 SNN  Remit To Country Name . . . . .
      59  RemitToContactCode. . . . . .    10 SNN  Remit To Contact Code . . . . .
      60  RemitToContactName. . . . . .    30 SNN  Remit To Contact Name . . . . .
      61  RemitToTelephoneNo. . . . . .    17 SNN  Remit To Telephone Number . . .
      62  RemitToTelephoneExt . . . . .     5 SNN  Remit To Telephone Extension. .
      63  MemoCode. . . . . . . . . . .    10 SNN  Memo Code . . . . . . . . . . .
      64  MemoDate. . . . . . . . . . .     8 SNN  Memo Date . . . . . . . . . . .DATE
      65  MemoDesc. . . . . . . . . . .    30 SNN  Memo Description. . . . . . . .
      66  ExpirationDate. . . . . . . .     8 SNN  Expiration Date . . . . . . . .DATE
      67  ReminderStartDate . . . . . .     8 SNN  Reminder Start Date . . . . . .DATE
      68  ReminderEndDate . . . . . . .     8 SNN  Reminder End Date . . . . . . .DATE
      69  AutoDisplaySetting. . . . . .     1 SNN  Auto Display Setting. . . . . .
      70  MemoText. . . . . . . . . . .  7168 SNN  Memo Text . . . . . . . . . . .
      71  Attachment. . . . . . . . . .   128 SNN  Attachment. . . . . . . . . . .
      72  ContactCode . . . . . . . . .    10 SNN  Contact Code. . . . . . . . . .
      73  ContactName . . . . . . . . .    30 SNN  Contact Name. . . . . . . . . .
      74  Salutation. . . . . . . . . .    10 SNN  Salutation. . . . . . . . . . .
      75  ContactTitle. . . . . . . . .    15 SNN  Contact Title . . . . . . . . .
      76  ContactNotes. . . . . . . . .   256 SNN  Contact Notes . . . . . . . . .
      77  FormType1099. . . . . . . . .     1 SNN  1099 Form Type. . . . . . . . .
      78  CalendarYr. . . . . . . . . .     4 SNN  Calendar Year . . . . . . . . .
      79  BoxIDSeqNo. . . . . . . . . .     6 SNN  Box ID Sequence Number. . . . .
      80  BoxID . . . . . . . . . . . .     3 SNN  BoxID . . . . . . . . . . . . .
      81  BoxDesc . . . . . . . . . . .    50 SNN  Box Description . . . . . . . .
      82  TextData. . . . . . . . . . .     1 SNN  Is This A Text Field. . . . . .
      83  BoxText . . . . . . . . . . .    15 SNN  Text For Text Boxes . . . . . .
      84  PurchaseAddressCode . . . . .     4 SNN  Purchase Address Code . . . . .
      85  PurchaseName. . . . . . . . .    30 SNN  Purchase Name . . . . . . . . .
      86  PrimaryLocation . . . . . . .     1 SNN  Primary Location. . . . . . . .
      87  Document. . . . . . . . . . .    30 SNN  Document Name . . . . . . . . .
      88  PrintDocument . . . . . . . .     1 SNN  Print Document. . . . . . . . .
      89  EmailDocument . . . . . . . .     1 SNN  Email Document. . . . . . . . .
      90  FaxDocument . . . . . . . . .     1 SNN  Fax Document. . . . . . . . . .
      91  UseVendorEmailAddress . . . .     1 SNN  Use Vendor Email Address. . . .
      92  UseFaxNoInDataEntry . . . . .     1 SNN  Use Fax Number In Data Entry. .
      93  UseVendorFaxNo. . . . . . . .     1 SNN  Use Vendor Fax Number . . . . .
      94  RecordType. . . . . . . . . .     1 SNN  Record Type . . . . . . . . . .
      95  ToContactCode . . . . . . . .    10 SNN  Contact Code. . . . . . . . . .
      96  ContactEmailAddress . . . . .    50 SNN  Contact Email Address . . . . .
      97  ContactFaxNo. . . . . . . . .    17 SNN  Contact Fax Number. . . . . . .
      98  ToAdditionalEmailAddress. . .    50 SNN  To Additional Email Address . .
      99  ToAdditionalFaxNo . . . . . .    17 SNN  To Additional Fax Number. . . .
     100  ToAdditionalFaxRecipientName.    30 SNN  To Additional Fax Recipient Nam
     101  RetentionRate . . . . . . . .  7.2  NNN  Retention Rate. . . . . . . . .
     102  BoxAmt. . . . . . . . . . . . 14.2  NNN  Box Amount. . . . . . . . . . .
     103  BoxAmtNextYear. . . . . . . . 14.2  NNN  Box Amount Next Year. . . . . .