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. . . . . . . . . .