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