     AP_VendorListingBalWrk              AP Vendor Listing Balance Work    Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AP_VendorListingBal_rpt
     SQL Def: Y  SysDB: N                         "MAS_"+%C$+"/AP"+%C$+"/AP_VendorListingBalWrk"+%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  VendorName. . . . . . . . . .    30 SNN  Vendor Name . . . . . . . . . .
       6  AddressLine1. . . . . . . . .    30 SNN  Address Line 1. . . . . . . . .
       7  AddressLine2. . . . . . . . .    30 SNN  Address Line 2. . . . . . . . .
       8  AddressLine3. . . . . . . . .    30 SNN  Address Line 3. . . . . . . . .
       9  City. . . . . . . . . . . . .    20 SNN  City. . . . . . . . . . . . . .
      10  State . . . . . . . . . . . .     2 SNN  State . . . . . . . . . . . . .
      11  ZipCode . . . . . . . . . . .    10 SNN  Zip Code. . . . . . . . . . . .
      12  CountryCode . . . . . . . . .     3 SNN  Country Code. . . . . . . . . .
      13  CountryName . . . . . . . . .    30 SNN  Country Name. . . . . . . . . .
      14  PrimaryContact. . . . . . . .    10 SNN  Primary Contact Code. . . . . .
      15  PrimaryContactName. . . . . .    30 SNN  Primary Contact Name. . . . . .
      16  TelephoneNo . . . . . . . . .    17 SNN  Telephone Number. . . . . . . .
      17  TelephoneExt. . . . . . . . .     5 SNN  Telephone Extension . . . . . .
      18  FaxNo . . . . . . . . . . . .    17 SNN  Fax Number. . . . . . . . . . .
      19  EmailAddress. . . . . . . . .   250 SNN  Email Address . . . . . . . . .
      20  URLAddress. . . . . . . . . .    50 SNN  URL Address . . . . . . . . . .
      21  TermsCode . . . . . . . . . .     2 SNN  Terms Code. . . . . . . . . . .
      22  TermsCodeDesc . . . . . . . .    30 SNN  Terms Code Description. . . . .
      23  Reference . . . . . . . . . .    15 SNN  Reference . . . . . . . . . . .
      24  TemporaryVendor . . . . . . .     1 SNN  Temporary Vendor. . . . . . . .
      25  CreditCardVendor. . . . . . .     1 SNN  Credit Card Vendor. . . . . . .
      26  HoldPayment . . . . . . . . .     1 SNN  Hold Payment. . . . . . . . . .
      27  ExemptionNoOnFile . . . . . .     1 SNN  Exemption Number on File. . . .
      28  TaxSchedule . . . . . . . . .     9 SNN  Tax Schedule. . . . . . . . . .
      29  TaxScheduleDesc . . . . . . .    30 SNN  Tax Schedule Description. . . .
      30  TaxClass. . . . . . . . . . .     2 SNN  Tax Class . . . . . . . . . . .
      31  TaxClassDesc. . . . . . . . .    30 SNN  Tax Class Description . . . . .
      32  AccountKey. . . . . . . . . .     9 SNN  Account Key . . . . . . . . . .
      33  Account . . . . . . . . . . .    41 SNN  Fully Formatted Account . . . .
      34  AccountDesc . . . . . . . . .    50 SNN  Account Description . . . . . .
      35  SeparateCheck . . . . . . . .     1 SNN  Separate Check. . . . . . . . .
      36  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .
      37  Sort. . . . . . . . . . . . .    10 SNN  Vendor Sort Field . . . . . . .
      38  BatchFax. . . . . . . . . . .     1 SNN  Batch Fax . . . . . . . . . . .
      39  UsePOReceiptOfInvForVendor. .     1 SNN  Use PO Receipt Of Inv For Vendo
      40  PrimaryPurchaseAddressCode. .     4 SNN  Purchase Address Code . . . . .
      41  VendorType. . . . . . . . . .     1 SNN  Vendor Type . . . . . . . . . .
      42  Form1099. . . . . . . . . . .     1 SNN  Default 1099 Form . . . . . . .
      43  TaxpayerIDSocialSecurityNo. .     9 SNN  Taxpayer ID/Social Security Num
      44  Box1099 . . . . . . . . . . .     3 SNN  Default 1099 Box. . . . . . . .
      45  MiscBox9. . . . . . . . . . .     1 SNN  Mark Misc Box 9 . . . . . . . .
      46  RemitToVendorName . . . . . .    30 SNN  Remit To Vendor Name. . . . . .
      47  RemitToAddressLine1 . . . . .    30 SNN  Remit To Address Line 1 . . . .
      48  RemitToAddressLine2 . . . . .    30 SNN  Remit To Address Line 2 . . . .
      49  RemitToAddressLine3 . . . . .    30 SNN  Remit To Address Line 3 . . . .
      50  RemitToCity . . . . . . . . .    20 SNN  Remit To City . . . . . . . . .
      51  RemitToState. . . . . . . . .     2 SNN  Remit To State. . . . . . . . .
      52  RemitToZipCode. . . . . . . .    10 SNN  Remit To Zip Code . . . . . . .
      53  RemitToCountryCode. . . . . .     3 SNN  Remit To Country Code . . . . .
      54  RemitToCountryName. . . . . .    30 SNN  Remit To Country Name . . . . .
      55  RemitToContactCode. . . . . .    10 SNN  Remit To Contact Code . . . . .
      56  RemitToContactName. . . . . .    30 SNN  Remit To Contact Name . . . . .
      57  RemitToTelephoneNo. . . . . .    17 SNN  Remit To Telephone Number . . .
      58  RemitToTelephoneExt . . . . .     5 SNN  Remit To Telephone Extension. .
      59  LastPurchaseDate. . . . . . .     8 SNN  Last Purchase Date. . . . . . .DATE
      60  LastPaymentDate . . . . . . .     8 SNN  Last Payment Date . . . . . . .DATE
      61  LastCheckNo . . . . . . . . .    10 SNN  Last AP Check Number. . . . . .
      62  FiscalPeriod. . . . . . . . .     2 SNN  Fiscal Period . . . . . . . . .
      63  LastCheckAmt. . . . . . . . . 15.2  NNN  Last Check Amount . . . . . . .
      64  RetentionRate . . . . . . . .  7.2  NNN  Retention Rate. . . . . . . . .
      65  AverageDaysToPay. . . . . . .  3.0  NNN  Average Days To Pay . . . . . .
      66  AverageDaysOverDue. . . . . .  3.0  NNN  Average Days Over Due . . . . .
      67  BalanceDue. . . . . . . . . . 16.2  NNN  Balance Due . . . . . . . . . .
      68  PurchasesPTD. . . . . . . . . 15.2  NNN  Purchases Period To Date. . . .
      69  PurchasesYTD. . . . . . . . . 16.2  NNN  Purchases Year To Date. . . . .
      70  PurchasesPY . . . . . . . . . 16.2  NNN  Purchases Prior Year. . . . . .
      71  PaymentsPTD . . . . . . . . . 15.2  NNN  Payments Period To Date . . . .
      72  PaymentsYTD . . . . . . . . . 16.2  NNN  Payments Year To Date . . . . .
      73  PaymentsPY. . . . . . . . . . 16.2  NNN  Payments Prior Year . . . . . .
      74  DiscountsTakenPTD . . . . . . 15.2  NNN  Discounts Taken Period To Date.
      75  DiscountsTakenYTD . . . . . . 16.2  NNN  Discounts Taken Year To Date. .
      76  DiscountsTakenPY. . . . . . . 16.2  NNN  Discounts Taken Prior Year. . .
      77  DiscountsLostPTD. . . . . . . 15.2  NNN  Discounts Lost Period To Date .
      78  DiscountsLostYTD. . . . . . . 16.2  NNN  Discounts Lost Year To Date . .
      79  DiscountsLostPY . . . . . . . 16.2  NNN  Discounts Lost Prior Year . . .