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

     KPRIMARY: DepositNo+ARDivisionNo+CustomerNo+EncryptedCreditCardNo+CheckNo
     KBATCH: BatchNo+DepositNo+ARDivisionNo+CustomerNo+EncryptedCreditCardNo+CheckNo
     KUNENCRYPTED: Last4UnencryptedCreditCardNos+DepositNo+ARDivisionNo+CustomerNo+EncryptedCreditCardNo+Che
                   ckNo
     KCUSTOMER: ARDivisionNo+CustomerNo+DepositNo+EncryptedCreditCardNo+CheckNo
     KCHECKNO: DepositNo+ARDivisionNo+CustomerNo+CheckNo+EncryptedCreditCardNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  DepositNo . . . . . . . . . .     5 SYY  Deposit Number. . . . . . . . .DEPOSITNO
                                                    FmtType:CHARNUM
       2  ARDivisionNo. . . . . . . . .     2 SNY  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
       3  CustomerNo. . . . . . . . . .    20 SYY  Customer Number . . . . . . . .CUSTOMERNO
                                                    FmtType:MASTERNUMC ChngTag:Re
                                                    place1/ARDivisionNo$
       4  EncryptedCreditCardNo . . . .    24 SNN  Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO
                                                    DepVal:REQUIRED
       5  CheckNo . . . . . . . . . . .    10 SYN  Check Number. . . . . . . . . .CHECKNO
                                                    DepVal:REQUIRED
       6  PaymentType . . . . . . . . .     5 SNN  Payment Type. . . . . . . . . .PAYMENTTYPE
                                                    ValGroup:CreditCard
       7  DepositType . . . . . . . . .     1 SYY  Deposit Type. . . . . . . . . .
                                                    Valid:C,R Notes: C=Cash,
                                                    R=cRedit
       8  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .NAME
       9  OpenItemCustomer. . . . . . .     1 SYN  Open Item Customer. . . . . . .YESNO
                                                    Read Only:Y DfltVal:N
                                                    Valid:Y,N
      10  BatchNo . . . . . . . . . . .     5 SYN  Batch Number. . . . . . . . . .BATCHNO
                                                    Read Only:Y Mask:00000
                                                    FmtType:ALPHANUM
      11  CreditCardCVV2No. . . . . . .     5 SNN  Credit Card CVV2 Number . . . .
                                                    ValGroup:CreditCard
      12  Last4UnencryptedCreditCardNos     4 SNN  Last 4 Unencrypted Credit Card
                                                    ValGroup:CreditCard
      13  ExpirationDateYear. . . . . .     4 SNN  Expiration Date Year. . . . . .
                                                    ValGroup:CreditCard
      14  ExpirationDateMonth . . . . .     2 SNN  Fiscal Period . . . . . . . . .FISCALPERIOD
                                                    Mask:00 FmtType:ZEROFILL
                                                    ValGroup:CreditCard
      15  CorporateCustIDPurchOrder . .    25 SNN  Corporate Customer ID / Purchas
                                                    ValGroup:CreditCard
      16  CorporateTaxOverrd. . . . . .     1 SYY  Corporate Tax Overridden. . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:CreditCard
      17  CardholderName. . . . . . . .    30 SNN  Cardholder Name . . . . . . . .
                                                    ValGroup:CreditCard
      18  CreditCardTransactionID . . .    10 SNN  Credit Card Transaction ID. . .
                                                    ValGroup:CreditCard
      19  CreditCardAuthorizationNo . .    16 SNN  Credit Card Authorization Numbe
                                                    ValGroup:CreditCard
      20  AuthorizationDate . . . . . .     8 SNN  Authorization Date. . . . . . .DATE
                                                    ValGroup:CreditCard
      21  AuthorizationTime . . . . . .     8 SNN  Authorization Time. . . . . . .
                                                    ValGroup:CreditCard
      22  AVSAddress. . . . . . . . . .    30 SNN  AVS Address Line. . . . . . . .ADDRESSLINE
                                                    ValGroup:CreditCard
      23  AVSCity . . . . . . . . . . .    20 SNN  AVS City. . . . . . . . . . . .CITY
                                                    ValGroup:CreditCard
      24  AVSState. . . . . . . . . . .     2 SYN  AVS State . . . . . . . . . . .STATE
                                                    ValGroup:CreditCard
      25  AVSZipCode. . . . . . . . . .    10 SYN  AVS Zip Code. . . . . . . . . .ZIPCODE
                                                    ValGroup:CreditCard
      26  CreditCardComment . . . . . .    30 SNN  Credit Card Comment . . . . . .
                                                    ValGroup:CreditCard
      27  PostingAmt. . . . . . . . . . 14.2  NNN  Posting Amount. . . . . . . . .
                                                    Mask:#,###,###,###.00-
                                                    ChngTag:Sum
      28  CustomerBalance . . . . . . . 14.2  NNN  Customer Balance. . . . . . . .
                                                    Mask:#,###,###,###.00-
                                                    ChngTag:Sum
      29  CorporateSalesTax . . . . . . 12.2  NNN  Corporate Sales Tax . . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00-
                                                    ValGroup:CreditCard
                                                    ChngTag:Sum
      30  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                    Read Only:Y ChngTag:Min
                                                    Notes: YYYYMMDD
      31  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                    Read Only:Y ChngTag:CopyMin/D
                                                    ateCreated$
      32  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL ChngTag:Copy
                                                    Min/DateCreated$
      33  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y ChngTag:Max
                                                    Notes: YYYYMMDD
      34  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y ChngTag:CopyMax/D
                                                    ateUpdated$
      35  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL ChngTag:Copy
                                                    Max/DateUpdated$