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