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$