AR_AgedInvoiceReportWrk AR Aged Invoice Report Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_AgedInvoiceReport_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_AgedInvoiceReportWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 30 SNN Group Field . . . . . . . . . . 3 GroupFieldDesc. . . . . . . . 30 SNN Group Field Description . . . . 4 GroupField2 . . . . . . . . . 6 SNN Group Field 2 . . . . . . . . . 5 GroupFieldDesc2 . . . . . . . 30 SNN Group Field Description 2 . . . 6 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . Mask:00 7 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 8 Type. . . . . . . . . . . . . 1 SNN Type. . . . . . . . . . . . . . 9 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 10 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . . 11 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . 12 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE 13 SequenceNo. . . . . . . . . . 6 SNN Sequence Number . . . . . . . . 14 TransactionType . . . . . . . 1 SNN Transaction Type. . . . . . . . 15 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE 16 InvoiceDiscountDate . . . . . 8 SNN Invoice Discount Date . . . . .DATE 17 PaymentReference. . . . . . . 10 SNN Payment Reference . . . . . . . 18 PaymentDate . . . . . . . . . 8 SNN Payment Date. . . . . . . . . .DATE 19 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . .JOBNO 20 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . . 21 ARDivisionDesc. . . . . . . . 30 SNN AR Division Description . . . . 22 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . .NAME 23 ContactName . . . . . . . . . 30 SNN Contact Name. . . . . . . . . . 24 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . . 25 TelephoneExt. . . . . . . . . 5 SNN Telephone Extension . . . . . . 26 ZipCode . . . . . . . . . . . 10 SNN Zip Code. . . . . . . . . . . . 27 CustomerType. . . . . . . . . 4 SNN Customer Type . . . . . . . . . 28 CustomerPoNo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO 29 CustomerSortField . . . . . . 10 SNN Customer Sort Field . . . . . . 30 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . . 31 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . . 32 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . .NAME 33 OpenItemCustomer. . . . . . . 1 SYN Open Item Customer. . . . . . .YESNO DfltVal:N Valid:Y,N 34 CreditLimitExceeded . . . . . 1 SYN Credit Limit Exceeded . . . . .YESNO DfltVal:N Valid:Y,N 35 CreditHold. . . . . . . . . . 1 SYN Credit Hold . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 36 DaysDelinquent. . . . . . . . 4 SNN Days Delinquent . . . . . . . . 37 SplitCommissionFlag . . . . . 1 SNN Split Commission Flag . . . . . 38 TransactionAmt. . . . . . . . 13.2 NNN Transaction Amount. . . . . . . 39 DiscountAmt . . . . . . . . . 14.2 NNN Discount Amount . . . . . . . . 40 Balance . . . . . . . . . . . 14.2 NNN Balance . . . . . . . . . . . . 41 CurrentAmt. . . . . . . . . . 14.2 NNN Current Amount. . . . . . . . . 42 AgingAmt1 . . . . . . . . . . 14.2 NNN Aging Amount 1. . . . . . . . . 43 AgingAmt2 . . . . . . . . . . 14.2 NNN Aging Amount 2. . . . . . . . . 44 AgingAmt3 . . . . . . . . . . 14.2 NNN Aging Amount 3. . . . . . . . . 45 AgingAmt4 . . . . . . . . . . 14.2 NNN Aging Amount 4. . . . . . . . . 46 RetentionAmt. . . . . . . . . 14.2 NNN Retention Amount. . . . . . . . 47 CreditLimit . . . . . . . . . 14.2 NNN Credit Limit. . . . . . . . . .