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. . . . . .