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$