AP_ManualCheckRegisterWrk AP Manual Check Register Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_ManualCheckRegister_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_ManualCheckRegisterWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 BankCode. . . . . . . . . . . 1 SNN Bank Code . . . . . . . . . . . 3 BankDesc. . . . . . . . . . . 30 SNN Bank Code Description . . . . . 4 CheckNo . . . . . . . . . . . 10 SNN Check Number. . . . . . . . . . 5 VoidedCheckNos. . . . . . . . 23 SNN Voided Check Numbers. . . . . . 6 VoidedCheck . . . . . . . . . 1 SNN Voided Check. . . . . . . . . . 7 CheckDate . . . . . . . . . . 8 SNN Check Date. . . . . . . . . . .DATE 8 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 9 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 10 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 11 CheckType . . . . . . . . . . 1 SNN Check Type. . . . . . . . . . . 12 Comment . . . . . . . . . . . 40 SNN Comment . . . . . . . . . . . . 13 BatchNo . . . . . . . . . . . 5 SNN Batch Number. . . . . . . . . . 14 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 15 InvoiceNo . . . . . . . . . . 10 SNN Invoice Number. . . . . . . . . 16 InvoiceType . . . . . . . . . 1 SNN Invoice Type. . . . . . . . . . 17 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 18 Form1099. . . . . . . . . . . 1 SNN 1099 Form . . . . . . . . . . . 19 Box1099 . . . . . . . . . . . 3 SNN 1099 Box. . . . . . . . . . . . 20 InvoiceComment. . . . . . . . 40 SNN Invoice Comment . . . . . . . . 21 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 22 InvalidTaxCalc. . . . . . . . 1 SNN Invalid Tax Calculation . . . . 23 InvoiceLineSeqNo. . . . . . . 14 SNN Invoice Line SequenceNumber . . 24 AccountKey. . . . . . . . . . 9 SNN Account Key . . . . . . . . . . 25 Account . . . . . . . . . . . 41 SNN Fully Formatted Account . . . . 26 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . . 27 JobDetailSeqNo. . . . . . . . 6 SNN Job Detail Sequence Number. . . 28 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . 29 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . . 30 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . . 31 CostType. . . . . . . . . . . 1 SNN CostType. . . . . . . . . . . . 32 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . . 33 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . . 34 TransferAPDivisionNo. . . . . 2 SNN Transfer AP Division Number . . 35 TransferVendorNo. . . . . . . 7 SNN Transfer Vendor Number. . . . . 36 TransferVendorName. . . . . . 30 SNN Transfer Vendor Name. . . . . . 37 TransferInvoiceNo . . . . . . 10 SNN Transfer AP Invoice Number. . . 38 TransferForm1099. . . . . . . 1 SNN Transfer 1099 Form. . . . . . . 39 TransferBox1099 . . . . . . . 3 SNN Transfer 1099 Box . . . . . . . 40 ScheduleSeqNo . . . . . . . . 6 SNN Schedule Sequence Number. . . . 41 TaxCode . . . . . . . . . . . 15 SNN Tax Code. . . . . . . . . . . . 42 Overridden. . . . . . . . . . 1 SNN Overridden. . . . . . . . . . . 43 CheckAmt. . . . . . . . . . . 13.2 NNN Check Amount. . . . . . . . . . 44 Amount. . . . . . . . . . . . 13.2 NNN Amount. . . . . . . . . . . . . 45 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . . 46 FreightAmt. . . . . . . . . . 13.2 NNN Freight Amount. . . . . . . . . 47 TaxAmt. . . . . . . . . . . . 13.2 NNN Tax Amount. . . . . . . . . . . 48 QuantityDistributed . . . . . 16.6 NNN Quantity Distributed. . . . . . 49 DistributionAmt . . . . . . . 13.2 NNN Distribution Amount . . . . . . 50 RetentionAppliedAmt . . . . . 13.2 NNN Retention Applied Amount. . . . 51 TransferDiscount. . . . . . . 13.2 NNN Transfer Discount Amount. . . . 52 TaxCodeTaxAmt . . . . . . . . 13.2 NNN Tax Code Tax Amount . . . . . .