AP_ARClearingRegisterWrk AP AR Clearing Register Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_ARClearingRegister_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_ARClearingRegisterWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 RecordType. . . . . . . . . . 1 SNN Record Type . . . . . . . . . . 3 SystemDate. . . . . . . . . . 8 SNN System Date . . . . . . . . . .DATE 4 Clear . . . . . . . . . . . . 5 SNN Clear . . . . . . . . . . . . . 5 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 6 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 7 CheckNo . . . . . . . . . . . 10 SNN Check Number. . . . . . . . . . 8 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 9 OpenItemCustomer. . . . . . . 1 SNN Open Item Customer. . . . . . . 10 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 11 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . . 12 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . 13 InvoiceDiscountDate . . . . . 8 SNN Invoice Discount Date . . . . .DATE 14 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . 15 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 16 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 17 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 18 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . . 19 AmountPosted. . . . . . . . . 13.2 NNN Amount Posted . . . . . . . . . 20 InvoiceBalance. . . . . . . . 13.2 NNN Invoice Balance . . . . . . . . 21 ClearedAmt. . . . . . . . . . 13.2 NNN Cleared Amount. . . . . . . . . 22 ARBalance . . . . . . . . . . 13.2 NNN AR Balance. . . . . . . . . . . 23 RetentionAppliedAmt . . . . . 13.2 NNN Retention Applied Amount. . . .