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