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