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