SO_DailyJobTransactionWrk SO Daily Job Transaction Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_SalesJournal_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_DailyJobTransactionWrk"+%S$+".M4T"
KPRIMARY: JobNo+InvoiceNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 SourceJournal . . . . . . . . 2 SNN Source Journal. . . . . . . . . 2 PostingDate . . . . . . . . . 8 SNN Posting Date. . . . . . . . . .DATE 3 BatchNo . . . . . . . . . . . 5 SYY Batch Number. . . . . . . . . .BATCHNO Mask:00000 4 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . .JOBNO 5 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE 6 InvoiceType . . . . . . . . . 2 SYN Invoice Type. . . . . . . . . . 7 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION Mask:00 8 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO 9 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . . 10 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . .ITEMCODE 11 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . . 12 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . . 13 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . . 14 CostTypeDesc. . . . . . . . . 15 SNN Cost Type Description . . . . . 15 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . .QUANTITY Mask:##,###,###.000000- 16 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .PRICE Mask:##,###,###.000000- 17 ExtensionAmt. . . . . . . . . 13.2 NNN Extension Amount. . . . . . . .AMOUNT Mask:###,###,###.00 18 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT Mask:###,###,###.00 19 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT Mask:###,###,###.00 20 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . .MISCAMOUNT Mask:##,###,###.00- 21 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . . 22 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT Mask:##,###,###.00- 23 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .