     AP_Vendor                           AP Vendor Master                  Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AP_Vendor_bus,AP_ARClearingRegister_upd,AP_InvoiceRegister_upd,AP_ManualCheckRegister_upd,AP_C
     SQL Def: N  SysDB: N                                             "MAS_"+%C$+"/AP"+%C$+"/AP_Vendor.M4T"

     KPRIMARY: APDivisionNo+VendorNo
     KNAME: VendorName+APDivisionNo+VendorNo
     KSORT: Sort+APDivisionNo+VendorNo
     KZIPCODE: ZipCode+APDivisionNo+VendorNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  APDivisionNo. . . . . . . . .     2 SNY  AP Division Number. . . . . . .APDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {AP1$(1,2)}
       2  VendorNo. . . . . . . . . . .     7 SYY  Vendor Number . . . . . . . . .VENDORNO
                                                    FmtType:MASTERNUM ChngTag:Rep
                                                    lace1/APDivisionNo$ Notes:
                                                    {AP1$(3,7)}
       3  VendorName. . . . . . . . . .    30 SNN  Vendor Name . . . . . . . . . .NAME
                                                    Notes: {AP1$(10,30)}
       4  AddressLine1. . . . . . . . .    30 SNN  Address Line 1. . . . . . . . .ADDRESSLINE
                                                    Notes: {AP1$(40,30)}
       5  AddressLine2. . . . . . . . .    30 SNN  Address Line 2. . . . . . . . .ADDRESSLINE
                                                    Notes: {AP1$(70,30)}
       6  AddressLine3. . . . . . . . .    30 SNN  Address Line 3. . . . . . . . .ADDRESSLINE
                                                    Notes: {AP1$(306,30)}
       7  City. . . . . . . . . . . . .    20 SNN  City. . . . . . . . . . . . . .CITY
                                                    Notes: {AP1$(100,20)}
       8  State . . . . . . . . . . . .     2 SYN  State . . . . . . . . . . . . .STATE
                                                    Notes: {AP1$(120,2)}
       9  ZipCode . . . . . . . . . . .    10 SYN  Zip Code. . . . . . . . . . . .ZIPCODE
                                                    Notes: {AP1$(122,10)}
      10  CountryCode . . . . . . . . .     3 SYN  Country Code. . . . . . . . . .COUNTRY
                                                    Notes: {AP1$(172,3)}
      11  PrimaryContact. . . . . . . .    10 SYN  Primary Contact Code. . . . . .APCONTACT
                                                    Notes: {AP1$(162,10)}
      12  TelephoneNo . . . . . . . . .    17 SNN  Telephone Number. . . . . . . .TELEPHONENO
                                                    Notes: {AP1$(132,17)}
      13  TelephoneExt. . . . . . . . .     5 SNN  Telephone Extension . . . . . .TELEPHONEEXT
                                                    Notes: {AP1$(149,5)}
      14  FaxNo . . . . . . . . . . . .    17 SNN  Fax Number. . . . . . . . . . .TELEPHONENO
                                                    DepVal:REQUIRED Notes:
                                                    {AP1$(336,17)}
      15  EmailAddress. . . . . . . . .   250 SNN  Email Address . . . . . . . . .EMAILADDRESS
                                                    Notes: {AP1$(353,50)}
      16  URLAddress. . . . . . . . . .    50 SNN  URL Address . . . . . . . . . .URLADDRESS
                                                    Notes: {AP1$(403,50)}
      17  TermsCode . . . . . . . . . .     2 SYY  Terms Code. . . . . . . . . . .APTERMS
                                                    DfltVal:00 Mask:00 FmtType:ZE
                                                    ROFILL Notes: {AP1$(217,2)}
      18  Reference . . . . . . . . . .    15 SNN  Vendor Reference Number . . . .
                                                    Notes: {AP1$(192,15)}
      19  TemporaryVendor . . . . . . .     1 SYN  Temporary Vendor. . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {AP1$(258,1)}
      20  CreditCardVendor. . . . . . .     1 SYN  Credit Card Vendor. . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {AP1$(453,1)}
      21  HoldPayment . . . . . . . . .     1 SYN  Hold Payment. . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {AP1$(259,1)}
      22  ExemptionNoOnFile . . . . . .     1 SYN  Exemption Number On File. . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {AP1$(154,1)}
      23  TaxSchedule . . . . . . . . .     9 SYN  Tax Schedule. . . . . . . . . .TAXSCHEDULE
                                                    Notes: {AP1$(175,9)}
      24  TaxClass. . . . . . . . . . .     2 SYN  Tax Class . . . . . . . . . . .TAXCLASS
                                                    DfltVal:NT Notes: {AP1$(184,
                                                    2)}
      25  AccountKey. . . . . . . . . .     9 SNN  Account Key . . . . . . . . . .ACCOUNT
                                                    Notes: {AP1$(219,9)}
      26  SeparateCheck . . . . . . . .     1 SYN  Separate Check. . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {AP1$(288,1)}
      27  Comment . . . . . . . . . . .    30 SNN  Vendor Comment. . . . . . . . .COMMENT30
                                                    Notes: {AP1$(228,30)}
      28  Sort. . . . . . . . . . . . .    10 SYN  Sort Field. . . . . . . . . . .
                                                    Notes: {AP1$(207,10)}
      29  BatchFax. . . . . . . . . . .     1 SYN  Batch Fax . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {AP1$(188,1)}
      30  UsePOReceiptOfInvForVendor. .     1 SNN  Use PO Receipt Of Inv For VendoYESNO
                                                    DfltVal:N Valid:Y,N
      31  PrimaryPurchaseAddressCode. .     4 SNN  Purchase Address Code . . . . .PURCHASEADDRCODE
      32  VendorType. . . . . . . . . .     1 SYN  Vendor Type . . . . . . . . . .
                                                    DfltVal:N Valid:N,B,I
                                                    ValGroup:TEN99 Notes: N=None,
                                                     B=Business, I=Individual
                                                    {AP1$(260,1)}
      33  Form1099. . . . . . . . . . .     1 SYN  Default 1099 Form . . . . . . .FORM1099
                                                    DfltVal:N Valid:N,M,I,D
                                                    DepVal:REQUIRED ValGroup:TEN9
                                                    9 Notes: N=None, M=Miscellane
                                                    ous, I=Interest, D=Dividend
                                                    {AP1$(303,1)}
      34  TaxpayerIDSocialSecurityNo. .     9 SNN  Taxpayer ID/Social Security Num
                                                    ValGroup:TEN99 Notes:
                                                    {AP1$(261,9)}
      35  Box1099 . . . . . . . . . . .     3 SNN  Default 1099 Box. . . . . . . .BOX1099
                                                    ValGroup:TEN99 Notes:
                                                    {AP1$(304,2)}
      36  MiscBox9. . . . . . . . . . .     1 SYN  Mark Misc Box 9 . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:TEN99 Notes:
                                                    {AP1$(187,1)}
      37  LastPurchaseDate. . . . . . .     8 SNN  Last Purchase Date. . . . . . .DATE
                                                    ValGroup:EDITSTATS ChngTag:Ma
                                                    x Notes: {AP1$(270,6)}
      38  LastPaymentDate . . . . . . .     8 SNN  Last Payment Date . . . . . . .DATE
                                                    ValGroup:EDITSTATS ChngTag:Ma
                                                    x Notes: {AP1$(276,6)}
      39  LastCheckNo . . . . . . . . .    10 SNN  Last AP Check Number. . . . . .APCHECKNO
                                                    FmtType:ALPHANUM ValGroup:EDI
                                                    TSTATS ChngTag:CopyMax/LastPa
                                                    ymentDate$ Notes: {AP1$(282,
                                                    6)}
      40  LastCheckAmt. . . . . . . . . 15.2  NNN  Last Check Amount . . . . . . .
                                                    Mask:##,###,###,###.00-
                                                    ValGroup:EDITSTATS ChngTag:Co
                                                    pyMax/LastPaymentDate$
                                                    Notes: {AP1[13]}
      41  RetentionRate . . . . . . . .  7.2  NNN  Retention Rate. . . . . . . . .
                                                    Mask:###.00- Notes:
                                                    {AP1$(289,6)}
      42  AverageDaysToPay. . . . . . .  3.0  NNN  Average Days To Pay . . . . . .
                                                    Mask:000 ValGroup:EDITSTATS
                                                    Notes: {AP1$(295,3)}
      43  AverageDaysOverDue. . . . . .  3.0  NNN  Average Days Over Due . . . . .
                                                    Mask:000 ValGroup:EDITSTATS
                                                    Notes: {AP1$(298,3)}
      44  BalanceDue. . . . . . . . . . 16.2  NNN  Balance Due . . . . . . . . . .TRANSACTIONAMT
                                                    Mask:########0.00 ValGroup:ED
                                                    ITSTATS ChngTag:Sum Notes:
                                                    {AP1[0]}
      45  NumberOfInvToUseInCalc. . . .  7.0  NNN  Number Of Invoices To Use In Ca
                                                    Notes: Of Avg Days For Pymnt
                                                    & Overdue {AP1$(301,2)}
      46  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                    Read Only:Y ChngTag:Min
                                                    Notes: YYYYMMDD
      47  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                    Read Only:Y ChngTag:CopyMin/D
                                                    ateCreated$
      48  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    ChngTag:CopyMin/DateCreated$
      49  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y ChngTag:Max
                                                    Notes: YYYYMMDD
      50  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y ChngTag:CopyMax/D
                                                    ateUpdated$
      51  UserUpdatedKey. . . . . . . .    10 SNN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    ChngTag:CopyMax/DateUpdated$