AP_CheckRegisterWrk AP Check Register Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_CheckRegister_upd,PO_ReceiptRegister_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_CheckRegisterWrk"+%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 APDivisionDesc. . . . . . . . 30 SNN AP Division Description . . . . 4 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 5 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 6 CheckEntryNo. . . . . . . . . 3 SNN Check Entry Number. . . . . . . 7 CheckNo . . . . . . . . . . . 10 SNN Check Number. . . . . . . . . . 8 CheckDate . . . . . . . . . . 8 SNN Check Date. . . . . . . . . . .DATE 9 CheckComment. . . . . . . . . 40 SNN Check Comment . . . . . . . . . 10 VoidedCheckNos. . . . . . . . 23 SNN Voided Check Numbers. . . . . . 11 VoidedCheck . . . . . . . . . 1 SNN Voided Check. . . . . . . . . . 12 BankCode. . . . . . . . . . . 1 SNN Bank Code . . . . . . . . . . . 13 BankDesc. . . . . . . . . . . 30 SNN Bank Code Description . . . . . 14 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 15 InvoiceNo . . . . . . . . . . 10 SNN Invoice Number. . . . . . . . . 16 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 17 Comment . . . . . . . . . . . 40 SNN Comment . . . . . . . . . . . . 18 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . . 19 DetailSeqNo . . . . . . . . . 6 SNN Detail Sequence Number. . . . . 20 AccountKey. . . . . . . . . . 9 SNN Account Key . . . . . . . . . . 21 Account . . . . . . . . . . . 41 SNN Fully Formatted Account . . . . 22 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . . 23 JobDetailSeqNo. . . . . . . . 6 SNN Job Detail Sequence Number. . . 24 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . 25 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . . 26 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . . 27 CostType. . . . . . . . . . . 1 SNN CostType. . . . . . . . . . . . 28 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . . 29 PaymentAmt. . . . . . . . . . 13.2 NNN Payment Amount. . . . . . . . . 30 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . . 31 InvoiceAmt. . . . . . . . . . 13.2 NNN Invoice Amount. . . . . . . . . 32 ExtensionAmt. . . . . . . . . 13.2 NNN Extension Amount. . . . . . . . 33 RetentionAppliedAmt . . . . . 13.2 NNN Retention Applied Amount. . . . 34 DistributionAmt . . . . . . . 13.2 NNN Distribution Amount . . . . . .