SO_GrossProfitJournalWrk SO Gross Profit Journal Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_SalesJournal_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_GrossProfitJournalWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 2 SNN Group Field . . . . . . . . . . 3 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . .INVOICE 4 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . 5 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 6 BatchNo . . . . . . . . . . . 5 SNN Batch Number. . . . . . . . . . 7 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 8 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . 9 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . . 10 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 11 ARDivisionDesc. . . . . . . . 30 SNN AR Division Description . . . . 12 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO 13 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 14 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . 15 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION Mask:00 FmtType:ZEROFILL 16 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . .SALESPERSONNO 17 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . .NAME Notes: {ARD$(7,30)} 18 SalespersonDivisionNo2. . . . 2 SNN Salesperson Division Number 2 .ARDIVISION Mask:00 FmtType:ZEROFILL 19 SalespersonNo2. . . . . . . . 4 SNN Salesperson Number 2. . . . . .SALESPERSONNO 20 SalespersonNo2Name. . . . . . 30 SNN Salesperson Number 2 Name . . .NAME 21 SalespersonDivisionNo3. . . . 2 SNN Salesperson Division Number 3 .ARDIVISION Mask:00 FmtType:ZEROFILL 22 SalespersonNo3. . . . . . . . 4 SYN Salesperson Number 3. . . . . .SALESPERSONNO FmtType:ALPHANUM 23 SalespersonNo3Name. . . . . . 30 SNN Salesperson Number 3 Name. . .NAME 24 SalespersonDivisionNo4. . . . 2 SNN Salesperson Division Number 4 .ARDIVISION Mask:00 FmtType:ZEROFILL 25 SalespersonNo4. . . . . . . . 4 SYN Salesperson Number 4. . . . . .SALESPERSONNO FmtType:ALPHANUM 26 SalespersonNo4Name. . . . . . 30 SNN Salesperson Number 4 Name . . .NAME 27 SalespersonDivisionNo5. . . . 2 SNN Salesperson Division Number 5 .ARDIVISION Mask:00 FmtType:ZEROFILL 28 SalespersonNo5. . . . . . . . 4 SYN Salesperson Number 5. . . . . .SALESPERSONNO FmtType:ALPHANUM 29 SalespersonNo5Name. . . . . . 30 SNN Salesperson Number 5 Name . . .NAME 30 SplitCommissions. . . . . . . 1 SYN Split Commissions . . . . . . . Valid:Y,N,O Notes: Y=Yes, N=No, O=Override 31 SplitCommRate2. . . . . . . . 9.3 NNN Split Commission Rate 2 . . . . Mask:###0.000 32 SplitCommRate3. . . . . . . . 9.3 NNN Split Commission Rate 3 . . . . Mask:###0.000 33 SplitCommRate4. . . . . . . . 9.3 NNN Split Commission Rate 4 . . . . Mask:###0.000 34 SplitCommRate5. . . . . . . . 9.3 NNN Split Commission Rate 5 . . . . Mask:###0.000 35 PriceOverridden . . . . . . . 1 SYN Price Overridden. . . . . . . .YESNO DfltVal:N Valid:Y,N 36 CostOverridden. . . . . . . . 1 SYN Cost Overridden . . . . . . . .YESNO DfltVal:N Valid:Y,N 37 SalesAccount. . . . . . . . . 41 SNN Sales Account . . . . . . . . . 38 CostOfGoodsSoldAccount. . . . 41 SNN Cost Of Goods Sold Account. . . 39 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . .COSTCODE 40 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . . 41 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . .COSTTYPE 42 CostTypeDesc. . . . . . . . . 15 SNN Cost Type Description . . . . . 43 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . .ITEMCODE 44 Commissionable. . . . . . . . 1 SNN Commissionable. . . . . . . . . 45 ExplodedKitItem . . . . . . . 1 SYN Exploded Kit Item . . . . . . .YESNO DfltVal:N Valid:Y,N 46 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . . 47 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . .AMOUNT Mask:###,###,###.00 48 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . . 49 CostOfGoodsSoldAmt. . . . . . 13.2 NNN Cost Of Goods Sold Amount . . .AMOUNT Mask:###,###,###.00 50 LineSubjectToComm . . . . . . 13.2 NNN Line Subject To Commission. . .AMOUNT Mask:###,###,###.00 51 CommissionAmt . . . . . . . . 13.2 NNN Commission Amount . . . . . . .AMOUNT Mask:###,###,###.00 52 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . . 53 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . . 54 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . . 55 ExtensionAmt. . . . . . . . . 13.2 NNN Extension Amount. . . . . . . .