AR_StatementWrk AR Statement Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_StatementPrinting_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_StatementWrk"+%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 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 4 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 5 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 6 AddressLine1. . . . . . . . . 30 SNN Address Line 1. . . . . . . . . 7 AddressLine2. . . . . . . . . 30 SNN Address Line 2. . . . . . . . . 8 AddressLine3. . . . . . . . . 30 SNN Address Line 3. . . . . . . . . 9 City. . . . . . . . . . . . . 20 SNN City. . . . . . . . . . . . . . 10 State . . . . . . . . . . . . 2 SNN State . . . . . . . . . . . . . 11 ZipCode . . . . . . . . . . . 10 SNN Zip Code. . . . . . . . . . . . 12 CountryCode . . . . . . . . . 3 SNN Country Code. . . . . . . . . . 13 CountryName . . . . . . . . . 30 SNN Country Name. . . . . . . . . . 14 ContactName . . . . . . . . . 30 SNN Contact Name. . . . . . . . . . 15 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . . 16 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . . 17 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . . 18 OpenItemCustomer. . . . . . . 1 SNN Open Item Customer. . . . . . . DfltVal:Y 19 TermsCode . . . . . . . . . . 2 SNN Terme Code. . . . . . . . . . . 20 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . . 21 PrintDunningMessage . . . . . 1 SNN Print Dunning Message . . . . . DfltVal:Y 22 DunningMessageLine1 . . . . . 50 SNN Dunning Message Line 1. . . . . 23 DunningMessageLine2 . . . . . 50 SNN Dunning Message Line 2. . . . . 24 CustomerType. . . . . . . . . 4 SNN Customer Type . . . . . . . . . 25 CustomerSortField . . . . . . 10 SNN Customer Sort Field . . . . . . 26 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 27 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE 28 SequenceNo. . . . . . . . . . 6 SNN Sequence Number . . . . . . . . 29 LineNumber. . . . . . . . . . 14 SNN Line Number . . . . . . . . . . 30 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . . 31 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . 32 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 33 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE 34 InvoiceDiscountDate . . . . . 8 SNN Invoice Discount Date . . . . .DATE 35 CustomerPONo. . . . . . . . . 15 SNN CustomerPONo. . . . . . . . . . 36 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30 37 TransactionType . . . . . . . 1 SNN Transaction Type. . . . . . . . DfltVal:I 38 PaymentReference. . . . . . . 10 SNN Payment Reference . . . . . . . 39 CheckNo . . . . . . . . . . . 10 SNN Check Number. . . . . . . . . . 40 PaymentType . . . . . . . . . 5 SNN Payment Type. . . . . . . . . . 41 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS 42 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO 43 Print . . . . . . . . . . . . 1 SYN Print Document. . . . . . . . .YESNO DfltVal:N Valid:Y,N 44 PDF . . . . . . . . . . . . . 1 SNN PDF Document. . . . . . . . . .YESNO DfltVal:N Valid:Y,N 45 MessageLine1. . . . . . . . . 50 SNN Message Line 1. . . . . . . . . 46 MessageLine2. . . . . . . . . 50 SNN Message Line 2. . . . . . . . . 47 FaxSendToCompany. . . . . . . 30 SNN Fax Send To Company . . . . . . 48 FaxSendToName . . . . . . . . 30 SNN Fax Send To Name. . . . . . . . 49 BatchFax. . . . . . . . . . . 1 SYN Batch Fax . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 50 PLPrint . . . . . . . . . . . 1 SYN Paperless Office Print CustomerYESNO DfltVal:N Valid:Y,N 51 PLEmail . . . . . . . . . . . 1 SYN Paperless Office E-Mail CustomeYESNO DfltVal:N Valid:Y,N 52 PLFax . . . . . . . . . . . . 1 SYN Paperless Office Fax Customer .YESNO DfltVal:N Valid:Y,N 53 PLPDF . . . . . . . . . . . . 1 SYN Paperless Office Create PDF . .YESNO DfltVal:N Valid:Y,N 54 DiscountAmt . . . . . . . . . 14.2 NNN Discount Amount . . . . . . . . 55 Balance . . . . . . . . . . . 14.2 NNN Balance . . . . . . . . . . . . 56 TransactionAmt. . . . . . . . 13.2 NNN Transaction Amount. . . . . . . 57 RetentionAmt. . . . . . . . . 14.2 NNN Retention Amount. . . . . . . . 58 CreditLimit . . . . . . . . . 14.2 NNN Credit Limit. . . . . . . . . . 59 BalanceForward. . . . . . . . 14.2 NNN Balance Forward . . . . . . . . 60 CurrentBalance. . . . . . . . 14.2 NNN Current Balance . . . . . . . . 61 AgingCategory1. . . . . . . . 14.2 NNN Aging Category 1. . . . . . . . 62 AgingCategory2. . . . . . . . 14.2 NNN Aging Category 2. . . . . . . . 63 AgingCategory3. . . . . . . . 14.2 NNN Aging Category 3. . . . . . . . 64 AgingCategory4. . . . . . . . 14.2 NNN Aging Category 4. . . . . . . . 65 RetentionCurrent. . . . . . . 14.2 NNN Retention Current . . . . . . . 66 RetentionAging1 . . . . . . . 14.2 NNN Retention Aging 1 . . . . . . . 67 RetentionAging2 . . . . . . . 14.2 NNN Retention Aging 2 . . . . . . . 68 RetentionAging3 . . . . . . . 14.2 NNN Retention Aging 3 . . . . . . . 69 RetentionAging4 . . . . . . . 14.2 NNN Retention Aging 4 . . . . . . . 70 OpenOrderAmt. . . . . . . . . 14.2 NNN Open Order Amount . . . . . . .