     SO_SalesJournalWrk                    SO Sales 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_SalesJournalWrk"+%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 SYY  Invoice Number. . . . . . . . .INVOICE
                                                    FmtType:MASTERNUM
       4  ScheduleSeqNo . . . . . . . .     6 SNY  Schedule Sequence Number. . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: {SO_18$(8,2)}
       5  BatchNo . . . . . . . . . . .     5 SYN  Batch Number. . . . . . . . . .BATCHNO
                                                    FmtType:ALPHANUM
       6  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
       7  InvoiceType . . . . . . . . .     2 SYN  Invoice Type. . . . . . . . . .
                                                    Valid:CM,DM,IN,AD,FC,CA,XD
                                                    Notes: CM=Credit Memo,
                                                    DM=Debit Memo, IN=Invoice,
                                                    AD=Adjustment., FC=Finance
                                                    Charge, CA=Cash, XD=Deleted
       8  SalesOrderNo. . . . . . . . .     7 SNN  Sales Order Number. . . . . . .
       9  ApplyToInvoiceNo. . . . . . .     7 SYN  Apply To Invoice Number . . . .
                                                    FmtType:CHARNUM ValGroup:Cust
                                                    omerRequired Notes: (For CM
                                                    & Dm Types) {SO5$(470,7)}
      10  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    DepVal:REQUIRED
      11  ARDivisionDesc. . . . . . . .    30 SNN  AR Division Description . . . .DESCRIPTION
      12  CustomerNo. . . . . . . . . .    20 SYN  Customer Number . . . . . . . .CUSTOMERNO
                                                    DepVal:REQUIRED
      13  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .
      14  TermsCode . . . . . . . . . .     2 SNY  AR Terms Code . . . . . . . . .ARTERMS
                                                    FmtType:ZEROFILL Notes:
                                                    {ARF$(1,2)}
      15  CreditHold. . . . . . . . . .     1 SYN  Credit Hold . . . . . . . . . .YESNO
                                                    DfltVal:N
      16  CreditLimitExceeded . . . . .     1 SYN  Credit Limit Exceeded . . . . .YESNO
                                                    DfltVal:N
      17  WithinCreditMargin. . . . . .     1 SYN  Within Credit Margin. . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      18  TaxSchedule . . . . . . . . .     9 SYN  Tax Schedule. . . . . . . . . .TAXSCHEDULE
                                                    FmtType:ALPHANUM
      19  TaxCode . . . . . . . . . . .    15 SYY  Tax Code. . . . . . . . . . . .TAXCODE
                                                    Notes: {SY_03$(1,15)}
      20  InvalidTaxCalc. . . . . . . .     1 SYN  Invalid Tax Calculation . . . .YESNO
                                                    DfltVal:N
      21  SalespersonNo . . . . . . . .     4 SYN  Salesperson Number. . . . . . .SALESPERSONNO
                                                    FmtType:ALPHANUM
      22  JobNo . . . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .JOBNO
                                                    FmtType:ALPHANUM
      23  JobDesc . . . . . . . . . . .    30 SNN  Job Description . . . . . . . .DESCRIPTION
      24  RMANo . . . . . . . . . . . .     7 SYN  RMA Number. . . . . . . . . . .RMANO
                                                    FmtType:ALPHANUM
      25  Overridden. . . . . . . . . .     1 SNN  Overridden. . . . . . . . . . .
      26  TaxableAmt. . . . . . . . . . 13.2  NNN  Taxable Amount. . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00
      27  NonTaxableAmt . . . . . . . . 13.2  NNN  Non-Taxable Amount. . . . . . .AMOUNT
                                                    Mask:###,###,###.00
      28  SalesTaxAmt . . . . . . . . . 12.2  NNN  Sales Tax Amount. . . . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00-
      29  DiscountAmt . . . . . . . . . 12.2  NNN  Discount Amount . . . . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00-
      30  FreightAmt. . . . . . . . . . 12.2  NNN  Freight Amount. . . . . . . . .
                                                    Mask:##,###,###.00-
      31  DepositAmt. . . . . . . . . . 13.2  NNN  Deposit Amount. . . . . . . . .
                                                    Mask:###,###,###.00-
      32  RetentionAmt. . . . . . . . . 13.2  NNN  Retention Amount. . . . . . . .AMOUNT
                                                    Mask:###,###,###.00