AR_SalesJournalWrk AR Sales Journal Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_SalesJournal_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_SalesJournalWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . .INVOICE 3 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . 4 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 5 ARDivisionDesc. . . . . . . . 30 SNN AR Division Description . . . . 6 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO 7 SoldTo. . . . . . . . . . . . 30 SNN Sold To . . . . . . . . . . . . 8 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 9 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . . 10 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . .TAXSCHEDULE 11 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . . 12 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . .SALESPERSONNO 13 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30 14 Adjustment. . . . . . . . . . 1 SNN Adjustment. . . . . . . . . . . 15 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . .JOBNO 16 TaxCode . . . . . . . . . . . 15 SNN Tax Code. . . . . . . . . . . .TAXCODE 17 InvalidTaxCalc. . . . . . . . 1 SNN Invalid Tax Calculation . . . . 18 CreditLimitExceeded . . . . . 1 SNN Credit Limit Exceeded . . . . . 19 CreditHold. . . . . . . . . . 1 SNN Credit Hold . . . . . . . . . . 20 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . Mask:00000000000000 21 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . .ITEMCODE 22 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 23 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . . 24 SalesAccount. . . . . . . . . 41 SNN Sales Account . . . . . . . . . 25 BatchNo . . . . . . . . . . . 5 SNN Batch Number. . . . . . . . . .BATCHNO 26 ApplyToInvoiceNo. . . . . . . 7 SNN Apply To Invoice Number . . . . 27 ScheduleSeqNo . . . . . . . . 6 SNN Schedule Sequence Number. . . . Mask:000000 28 GroupField. . . . . . . . . . 2 SNN Group Field . . . . . . . . . . 29 Overridden. . . . . . . . . . 1 SNN Overridden. . . . . . . . . . . 30 CommentText . . . . . . . . . 2048 SNN CommentText . . . . . . . . . . 31 TaxableSalesAmt . . . . . . . 13.2 NNN Taxable Sales Amount. . . . . . 32 NonTaxableSalesAmt. . . . . . 13.2 NNN Non-Taxable Sales Amount. . . . 33 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . . 34 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . . 35 RetentionAmt. . . . . . . . . 12.2 NNN Retention Amount. . . . . . . . 36 ExtensionAmt. . . . . . . . . 13.2 NNN Extension Amount. . . . . . . . 37 SalesTaxDetailAmt . . . . . . 12.2 NNN Sales Tax Detail Amount . . . .