     AR_CashReceiptsDetail                  AR Cash Receipts Detail        Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AR_CashReceiptsDetail_bus,BC_CommonImport
     SQL Def: N  SysDB: N                                 "MAS_"+%C$+"/AR"+%C$+"/AR_CashReceiptsDetail.M4T"

     KPRIMARY: DepositNo+ARDivisionNo+CustomerNo+EncryptedCreditCardNo+CheckNo+LineKey
     KDISPLAY: DepositNo+ARDivisionNo+CustomerNo+EncryptedCreditCardNo+CheckNo+LineSeqNo+LineKey

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  DepositNo . . . . . . . . . .     5 SYY  Deposit Number. . . . . . . . .DEPOSITNO
                                                    Read Only:Y FmtType:CHARNUM
       2  ARDivisionNo. . . . . . . . .     2 SNY  AR Division Number. . . . . . .ARDIVISION
                                                    Read Only:Y Mask:00
                                                    FmtType:ZEROFILL
       3  CustomerNo. . . . . . . . . .    20 SYY  Customer Number . . . . . . . .CUSTOMERNO
                                                    Read Only:Y FmtType:MASTERNUM
                                                    C ChngTag:Replace1/ARDivision
                                                    No$
       4  EncryptedCreditCardNo . . . .    24 SNN  Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO
                                                    Read Only:Y
       5  CheckNo . . . . . . . . . . .    10 SYN  Check Number. . . . . . . . . .CHECKNO
                                                    Read Only:Y
       6  LineKey . . . . . . . . . . .     6 SNY  Line Key. . . . . . . . . . . .
                                                    Read Only:Y Mask:000000
                                                    FmtType:ZEROFILL
       7  LineSeqNo . . . . . . . . . .    14 SNN  Line Sequence Number. . . . . .
                                                    Read Only:Y Mask:000000000000
                                                    00 FmtType:ZEROFILL
       8  LineType. . . . . . . . . . .     1 SYN  Line Type . . . . . . . . . . .
                                                    DfltVal:I Valid:I,G Notes:
                                                    I=Invoice, G=G/L distribution
       9  InvoiceNo . . . . . . . . . .     7 SYN  Invoice Number. . . . . . . . .INVOICE
                                                    FmtType:MASTERNUM DepVal:REQU
                                                    IRED
      10  InvoiceType . . . . . . . . .     2 SYN  Invoice Type. . . . . . . . . .
                                                    Valid:CM,DM,IN,AD,FC,CA,XD,
                                                    PP Notes: CM=Credit Memo,
                                                    DM=Debit Memo, IN=INvoice,
                                                    AD=ADjustment., FC=Finance
                                                    Charge, CA=CAsh, XD=Deleted,
                                                    PP=PrePayment
      11  NewPrepayment . . . . . . . .     1 SYN  New Prepayment. . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      12  Comment . . . . . . . . . . .  2048 SNN  Comment . . . . . . . . . . . .COMMENT
      13  AccountKey. . . . . . . . . .     9 SYN  Account Key . . . . . . . . . .ACCOUNT
                                                    DepVal:REQUIRED
      14  DiscountAmt . . . . . . . . . 13.2  NNN  Discount Amount . . . . . . . .
                                                    Mask:###,###,###.00-
      15  AmountPosted. . . . . . . . . 13.2  NNN  Amount Posted . . . . . . . . .
                                                    Mask:###,###,###.00-
      16  InvoiceBalance. . . . . . . . 13.2  NNN  Invoice Balance . . . . . . . .
                                                    Mask:###,###,###.00- Notes:
                                                    (After Posting)