     AR_CashReceiptsJournalWrk             AR Cash Receipts Journal Work   Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AR_CashReceiptsJournal_upd
     SQL Def: Y  SysDB: N                      "MAS_"+%C$+"/AR"+%C$+"/AR_CashReceiptsJournalWrk"+%S$+".M4T"

     KPRIMARY: SortField

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
       2  DepositType . . . . . . . . .     1 SNN  Deposit Type. . . . . . . . . .
       3  BankCode. . . . . . . . . . .     1 SNN  Bank Code . . . . . . . . . . .
       4  BankDesc. . . . . . . . . . .    30 SNN  Bank Description. . . . . . . .
       5  DepositDate . . . . . . . . .     8 SNN  Deposit Date. . . . . . . . . .DATE
       6  BatchNo . . . . . . . . . . .     5 SNN  Batch Number. . . . . . . . . .
       7  DepositNo . . . . . . . . . .     5 SNN  Deposit Number. . . . . . . . .
       8  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .
       9  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .
      10  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .
      11  Last4UnencryptedCreditCardNos     4 SNN  Last 4 Unencrypted Credit Card
      12  CheckNo . . . . . . . . . . .    10 SNN  Check Number. . . . . . . . . .
      13  CreditCardAuthorizationNo . .    16 SNN  Credit Card Authorization Numbe
      14  LineSeqNo . . . . . . . . . .    14 SNN  Line Sequence Number. . . . . .
      15  LineType. . . . . . . . . . .     1 SNN  Line Type . . . . . . . . . . .
      16  InvoiceNo . . . . . . . . . .     7 SNN  Invoice Number. . . . . . . . .
      17  InvoiceType . . . . . . . . .     2 SNN  Invoice Type. . . . . . . . . .
      18  DiscountDate. . . . . . . . .     8 SNN  Discount Date . . . . . . . . .DATE
      19  JobNo . . . . . . . . . . . .     7 SNN  Job Number. . . . . . . . . . .
      20  AccountKey. . . . . . . . . .     9 SNN  Account Key . . . . . . . . . .
      21  Account . . . . . . . . . . .    41 SNN  Account . . . . . . . . . . . .
      22  PaymentType . . . . . . . . .     5 SNN  Payment Type. . . . . . . . . .
      23  FullCreditCardNo. . . . . . .    24 SNN  Full Credit Card Number . . . .
      24  Comment . . . . . . . . . . .  2048 SNN  Comment . . . . . . . . . . . .
      25  CashDepositAmt. . . . . . . . 13.2  NNN  Cash Deposit Amount . . . . . .
      26  CashBalanceAmt. . . . . . . . 13.2  NNN  Cash Balance Amount . . . . . .
      27  CreditDepositAmt. . . . . . . 13.2  NNN  Credit Deposit Amount . . . . .
      28  CreditBalanceAmt. . . . . . . 13.2  NNN  Credit Balance Amount . . . . .
      29  DiscountAmt . . . . . . . . . 13.2  NNN  Discount Amount . . . . . . . .
      30  AmountPosted. . . . . . . . . 13.2  NNN  Amount Posted . . . . . . . . .
      31  InvoiceBalance. . . . . . . . 13.2  NNN  Invoice Balance . . . . . . . .
      32  RetentionAmt. . . . . . . . . 14.2  NNN  Retention Amount. . . . . . . .