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