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