AP_CheckWrk AP Check Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_CheckPrinting_rpt,AP_ManualCheckPrinting_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_CheckWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 3 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 4 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 5 AddressLine1. . . . . . . . . 30 SNN Address Line 1. . . . . . . . . 6 AddressLine2. . . . . . . . . 30 SNN Address Line 2. . . . . . . . . 7 AddressLine3. . . . . . . . . 30 SNN Address Line 3. . . . . . . . . 8 City. . . . . . . . . . . . . 20 SNN City. . . . . . . . . . . . . . 9 State . . . . . . . . . . . . 2 SNN State . . . . . . . . . . . . . 10 ZipCode . . . . . . . . . . . 10 SNN ZipCode . . . . . . . . . . . . 11 CountryCode . . . . . . . . . 3 SNN Country Code. . . . . . . . . . 12 CountryName . . . . . . . . . 30 SNN Country Name. . . . . . . . . . 13 Reference . . . . . . . . . . 15 SNN Vendor Reference Number . . . . 14 CheckEntryNo. . . . . . . . . 3 SNN Check Entry Number. . . . . . . 15 CheckNo . . . . . . . . . . . 10 SNN Check Number. . . . . . . . . . 16 CheckDate . . . . . . . . . . 8 SNN Check Date. . . . . . . . . . .DATE 17 CheckComment. . . . . . . . . 40 SNN Check Comment . . . . . . . . . 18 CheckMessageLine. . . . . . . 50 SNN Check Message Line. . . . . . . 19 StubMessageLine . . . . . . . 50 SNN Stub Message Line . . . . . . . 20 BankCode. . . . . . . . . . . 1 SNN Bank Code . . . . . . . . . . . 21 BankDesc. . . . . . . . . . . 30 SNN Bank Code Description . . . . . 22 CheckPrefix . . . . . . . . . 1 SNN Check Prefix. . . . . . . . . . 23 CheckSuffix . . . . . . . . . 1 SNN Check Suffix. . . . . . . . . . 24 RoutingNo . . . . . . . . . . 11 SNN Routing Number. . . . . . . . . 25 BankAccountNo . . . . . . . . 17 SNN Bank Account Number . . . . . . 26 MICRPrintingEnabled . . . . . 1 SNN Micr Printing Enabled . . . . . 27 RemitToVendorName . . . . . . 30 SNN Remit To Vendor Name. . . . . . 28 RemitToAddressLine1 . . . . . 30 SNN Remit To Address Line 1 . . . . 29 RemitToAddressLine2 . . . . . 30 SNN Remit To Address Line 2 . . . . 30 RemitToAddressLine3 . . . . . 30 SNN Remit To Address Line 3 . . . . 31 RemitToCity . . . . . . . . . 20 SNN Remit To City . . . . . . . . . 32 RemitToState. . . . . . . . . 2 SNN Remit To State. . . . . . . . . 33 RemitToZipCode. . . . . . . . 10 SNN Remit To Zip Code . . . . . . . 34 RemitToCountryCode. . . . . . 3 SNN Remit To Country Code . . . . . 35 RemitToCountryName. . . . . . 30 SNN Remit To Country Name . . . . . 36 RemitToContactCode. . . . . . 10 SNN Remit To Contact Code . . . . . 37 RemitToContactName. . . . . . 30 SNN Remit To Contact Name . . . . . 38 RemitToTelephoneNo. . . . . . 17 SNN Remit To Telephone Number . . . 39 RemitToTelephoneExt . . . . . 5 SNN Remit To Telephone Extension. . 40 CheckAmt. . . . . . . . . . . 13.2 NNN Check Amount. . . . . . . . . . 41 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . . 42 NumberOfDetailLines . . . . . 5.0 NNN Number of Detail Lines. . . . .