AR_RepetitiveInvoiceListingWrk AR Repetitive Invoice Listing WoRel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_RepetitiveInvoiceListing_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_RepetitiveInvoiceListingWrk"+%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 ReferenceNo . . . . . . . . . 4 SNN Reference Number. . . . . . . .
7 SelectCycleCode . . . . . . . 2 SNN Select Cycle Code . . . . . . .
8 StartBillingDate. . . . . . . 8 SNN Start Billing Date. . . . . . .DATE
9 StopBillingDate . . . . . . . 8 SNN Stop Billing Date . . . . . . .DATE
10 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .
11 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . .TAXSCHEDULE
12 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .
13 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . .SALESPERSONNO
14 PrintInvoice. . . . . . . . . 1 SNN Print Invoice . . . . . . . . .
15 ShipMethod. . . . . . . . . . 15 SNN Ship Method . . . . . . . . . .
16 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO
17 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .
18 LastBilledDate. . . . . . . . 8 SNN Last Billed Date. . . . . . . .DATE
19 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . .
20 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . .ITEMCODE
21 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .
22 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . .
23 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . .
24 SalesAccount. . . . . . . . . 41 SNN Sales Account . . . . . . . . .
25 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .
26 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . .JOBNO
27 TaxableSalesAmt . . . . . . . 13.2 NNN Taxable Sales Amount. . . . . .
28 NonTaxableSalesAmt. . . . . . 13.2 NNN Non-Taxable Sales Amount. . . .
29 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .
30 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .
31 NumberOfTimesBilled . . . . . 7.0 NNN Number of Times Billed. . . . .
32 ExtensionAmt. . . . . . . . . 13.2 NNN Extension Amount. . . . . . . .
33 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . .
34 CRMUserFirstName. . . . . . . 30 SNN CRM User First Name . . . . . .
35 CRMUserLastName . . . . . . . 30 SNN CRM User Last Name. . . . . . .
36 UserKey . . . . . . . . . . . 10 SNN User Key. . . . . . . . . . . .
37 UserLogon . . . . . . . . . . 60 SNN User Logon. . . . . . . . . . .