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