AR_CashExpectationReportWrk AR Cash Expectation Report Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_CashExpectationReport_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CashExpectationReportWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 3 ARDivisionDesc. . . . . . . . 30 SNN AR Division Description . . . . 4 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO 5 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 6 OpenItemCustomer. . . . . . . 1 SNN Open Item Customer. . . . . . . 7 ContactName . . . . . . . . . 30 SNN Contact Name. . . . . . . . . . 8 TelephoneNo . . . . . . . . . 17 SNN Telephone No. . . . . . . . . .TELEPHONENO 9 InvoiceDate . . . . . . . . . 8 SNN InvoiceDate . . . . . . . . . .DATE 10 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . .INVOICE 11 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . 12 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE 13 InvoiceDiscountDate . . . . . 8 SNN Invoice Discount Date . . . . .DATE 14 CreditLimitExceeded . . . . . 1 SNN Credit Limit Exceeded . . . . . 15 CreditHold. . . . . . . . . . 1 SNN Credit Hold . . . . . . . . . . 16 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . .JOBNO 17 PaymentAmt1 . . . . . . . . . 14.2 NNN Payment Amount 1. . . . . . . . 18 PaymentAmt2 . . . . . . . . . 14.2 NNN Payment Amount 2. . . . . . . . 19 PaymentAmt3 . . . . . . . . . 14.2 NNN Payment Amount 3. . . . . . . . 20 PaymentAmt4 . . . . . . . . . 14.2 NNN Payment Amount 4. . . . . . . . 21 FuturePaymentAmt. . . . . . . 14.2 NNN Future Payment Amount . . . . . 22 DiscountAmt . . . . . . . . . 14.2 NNN Discount Amount . . . . . . . . 23 Balance . . . . . . . . . . . 14.2 NNN Balance . . . . . . . . . . . . 24 RetentionAmt. . . . . . . . . 14.2 NNN Retention Amount. . . . . . . . 25 CreditLimit . . . . . . . . . 14.2 NNN Credit Limit. . . . . . . . . .