     IT_ShoppingCartHeader                  IT Shopping Cart Header        Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: IT_ShoppingCart_bus                                         Mirror: IT_ShoppingCartAutoLogHdr
     SQL Def: Y  SysDB: N                                 "MAS_"+%C$+"/IT"+%C$+"/IT_ShoppingCartHeader.M4T"

     KPRIMARY: UserID+SequenceNo
     KSTATUS: Status+DateSubmitted+TimeSubmitted+UserID+SequenceNo
     KEMAILADDR: EMailAddress+UserID+SequenceNo
     KSTATUSEBM: Status+UserID+SequenceNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  UserID. . . . . . . . . . . .    15 SYY  e Business Manager User ID. . .
                                                    FmtType:CHARNUM Notes:
                                                    {ITA$(1,15)}
       2  SequenceNo. . . . . . . . . .     6 SNY  Sequence Number . . . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Next:SequenceNo$ Notes:
                                                    {ITA$(16,5)}
       3  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                    Read Only:Y Mask:00
       4  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .CUSTOMERNO
                                                    Read Only:Y
       5  Status. . . . . . . . . . . .     1 SYY  Status. . . . . . . . . . . . .
                                                    DfltVal:T Valid:A,M,P,R,T,U,
                                                    E Notes: A=Auto Accept,
                                                    M=Manual Accept, P=Pending,
                                                    R=Rejected, T=Temporary,
                                                    U=Updated {ITA$(21,1)}
       6  ShipToCode. . . . . . . . . .     4 SYN  Ship-To Code. . . . . . . . . .SHIPTO
                                                    DepVal:REQUIRED Notes:
                                                    {ITA$(34,4)}
       7  TaxSchedule . . . . . . . . .     9 SYN  Tax Schedule. . . . . . . . . .TAXSCHEDULE
                                                    ValGroup:ARSalesTax Notes:
                                                    {ITA$(80,9)}
       8  ShipDate. . . . . . . . . . .     8 SYN  Ship Date . . . . . . . . . . .DATE
                                                    Notes: {ITA$(121,6)}
       9  ShipVia . . . . . . . . . . .    15 SYN  Ship Via. . . . . . . . . . . .SHIPCODE
                                                    Notes: {ITA$(58,15)}
      10  ShipZone. . . . . . . . . . .     5 SYN  Ship Zone . . . . . . . . . . .SHIPZONE
                                                    Notes: Maintained {ITA$(106,
                                                    5)}
      11  ShipZoneActual. . . . . . . .     5 SNN  Ship Zone Actual. . . . . . . .SHIPZONE
                                                    Notes: {ITA$(116,5)}
      12  ShipWeight. . . . . . . . . .     5 SYN  Ship Weight . . . . . . . . . .SHIPWEIGHT
                                                    Mask:00000 Notes: {ITA$(111,
                                                    5)}
      13  CustomerPONo. . . . . . . . .    15 SNN  Customer PO Number. . . . . . .CUSTOMERPONO
                                                    Notes: {ITA$(43,15)}
      14  WarehouseCode . . . . . . . .     3 SYY  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM ValGroup:Mult
                                                    iWarehouse Notes: {ITA$(77,
                                                    3)}
      15  FreightCalculationMethod. . .     1 SYN  Freight Calculation Method. . .
                                                    Valid:A,P,W Notes: A=Amount,
                                                    P=Product line, W=Weight
                                                    {ITA$(611,1)}
      16  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .ARDIVISION
                                                    Mask:00
      17  SalespersonNo . . . . . . . .     4 SYN  Salesperson Number. . . . . . .SALESPERSONNO
                                                    ValGroup:SalespersonReporting
                                                     Notes: {ITA$(73,4)}
      18  PaymentType . . . . . . . . .     5 SYY  Payment Type. . . . . . . . . .PAYMENTTYPE
                                                    Notes: {ITA$(612.5)}
      19  OtherPaymentTypeRefNo . . . .    24 SNN  Other Payment Type Reference Nu
                                                    Notes: {ITA$(392,24)}
      20  EmailReasonCode . . . . . . .     5 SYN  Email Reason Code . . . . . . .EMAILREASONCODE
                                                    Notes: {ITA$(38,5)}
      21  SalesOrderNo. . . . . . . . .     7 SYN  Sales Order Number. . . . . . .SALESORDERNO
                                                    Notes: {ITA$(89,7)}
      22  CreditLimitExceededCreditHold     1 SYN  Credit Limit Exceeded Credit HoYESNO
                                                    Read Only:Y DfltVal:N
                                                    Valid:Y,N Notes: {ITA$(127,
                                                    1)}
      23  UserType. . . . . . . . . . .     1 SNN  User Type . . . . . . . . . . .
                                                    Read Only:Y Notes: {ITA$(129,
                                                    1)}
      24  TaxSchedAssignedFrom. . . . .     1 SYY  Tax Schedule Assigned From Xref
                                                    Read Only:Y DfltVal:O
                                                    Valid:O,C,S,X,Z Notes: O =
                                                    IT Options, C = Customer
                                                    (Bill To) ,S = Ship To, X =
                                                    State X-ref, Z = Zip Code
                                                    X-ref
      25  TaxableSubjectToDiscount. . . 13.2  NNN  Taxable Subject To Discount . .AMOUNT
                                                    Read Only:Y Mask:###,###,
                                                    ###.00 Notes: {ITA[0]}
      26  NonTaxableSubjectToDiscount . 13.2  NNN  Non-Taxable Subject To DiscountAMOUNT
                                                    Read Only:Y Mask:###,###,
                                                    ###.00 Notes: {ITA[1]}
      27  TaxSubjToDiscPrcntOfTotSubjTo  7.2  NNN  Tax Subj-To-Disc % Of Total Sub
                                                    Read Only:Y Mask:#0.000
                                                    Notes: {ITA[2]}
      28  DiscountRate. . . . . . . . .  8.3  NNN  Discount Rate . . . . . . . . .
                                                    Mask:##0.000 Notes: {ITA[3]}
      29  DiscountAmt . . . . . . . . . 12.2  NNN  Miscellaneous Amount. . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00- Notes:
                                                    {ITA[4]}
      30  TaxableAmt. . . . . . . . . . 13.2  NNN  Taxable Amount. . . . . . . . .AMOUNT
                                                    Read Only:Y Mask:###,###,
                                                    ###.00 Notes: {ITA[5]}
      31  NonTaxableAmt . . . . . . . . 13.2  NNN  Non-Taxable Amount. . . . . . .AMOUNT
                                                    Read Only:Y Mask:###,###,
                                                    ###.00 Notes: {ITA[6]}
      32  SalesTaxAmt . . . . . . . . . 12.2  NNN  Sales Tax Amount. . . . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00- Notes:
                                                    {ITA[7]}
      33  Weight. . . . . . . . . . . . 12.2  NNN  Weight. . . . . . . . . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00- Notes:
                                                    {ITA[10]}
      34  FreightAmt. . . . . . . . . . 12.2  NNN  Freight Amount. . . . . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00- Notes:
                                                    {ITA[11]}
      35  SaveCreditCardNoInARCustomer.     1 SYN  Save Credit Card Number in AR CYESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:CreditCardPaymentOnl
                                                    y Notes: {ITA$(691,1)}
      36  CardholderName. . . . . . . .    30 SNN  Cardholder Name . . . . . . . .NAME
                                                    ValGroup:CreditCardPaymentOnl
                                                    y
      37  EncryptedCreditCardNo . . . .    24 SNN  Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO
                                                    DepVal:REQUIRED ValGroup:Cred
                                                    itCardPaymentOnly Notes:
                                                    {ITA$(617,24)}
      38  CreditCardCVV2No. . . . . . .     5 SNN  Credit Card CVV2 Number . . . .
                                                    ValGroup:CreditCardPaymentOnl
                                                    y Notes: {ITA$(641,4)}
      39  Last4UnencryptedCreditCardNos     4 SNN  Last 4 Unencrypted Credit Card
                                                    ValGroup:CreditCardPaymentOnl
                                                    y Notes: {ITA$(645,4)}
      40  ExpirationDateYear. . . . . .     4 SNN  Expiration Date Year. . . . . .YEAR
                                                    Mask:0000 ValGroup:CreditCard
                                                    PaymentOnly Notes: {ITA$(687,
                                                    2)}
      41  ExpirationDateMonth . . . . .     2 SNN  Expiration Date Month . . . . .MONTH
                                                    Mask:00 ValGroup:CreditCardPa
                                                    ymentOnly Notes: {ITA$(689,
                                                    2)}
      42  CreditCardPreAuthorizationAmt 13.2  NNN  Credit Card Pre-Authorization AAMOUNT
                                                    Read Only:Y Mask:###,###,
                                                    ###.00 ValGroup:CreditCardPay
                                                    mentOnly Notes: {ITA[8]}
      43  CreditCardAuthorizationNo . .    16 SNN  Credit Card Authorization Numbe
                                                    Read Only:Y ValGroup:CreditCa
                                                    rdPaymentOnly Notes:
                                                    {ITA$(649,16)}
      44  CreditCardTransactionID . . .    10 SNN  Credit Card Transaction ID. . .
                                                    Read Only:Y ValGroup:CreditCa
                                                    rdPaymentOnly Notes:
                                                    {ITA$(665,10)}
      45  AuthorizationDate . . . . . .     8 SNN  Authorization Date. . . . . . .DATE
                                                    Read Only:Y ValGroup:CreditCa
                                                    rdPaymentOnly Notes:
                                                    {ITA$(675,6)}
      46  AuthorizationTime . . . . . .     6 SNN  Authorization Time. . . . . . .
                                                    Read Only:Y ValGroup:CreditCa
                                                    rdPaymentOnly Notes:
                                                    {ITA$(675,6)}
      47  AVSAddress. . . . . . . . . .    30 SNN  AVS Address Line. . . . . . . .ADDRESSLINE
                                                    ValGroup:CreditCardPaymentOnl
                                                    y Notes: {ITA$(746,30)}
      48  AVSCity . . . . . . . . . . .    20 SNN  AVS City. . . . . . . . . . . .CITY
                                                    ValGroup:CreditCardPaymentOnl
                                                    y Notes: {ITA$(776,20)}
      49  AVSState. . . . . . . . . . .     2 SYN  AVS State . . . . . . . . . . .STATE
                                                    ValGroup:CreditCardPaymentOnl
                                                    y Notes: {ITA$(796,2)}
      50  AVSZipCode. . . . . . . . . .    10 SNN  AVS Zip Code. . . . . . . . . .ZIPCODE
                                                    ValGroup:CreditCardPaymentOnl
                                                    y Notes: {ITA$(798,10)}
      51  CorporateCustIDPurchOrder . .    25 SNN  Corporate Customer ID / Purchas
                                                    ValGroup:CreditCardPaymentOnl
                                                    y,OrderSubmissionOnly,
      52  CorporateSalesTax . . . . . . 12.2  NNN  Corporate Sales Tax . . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00-
                                                    ValGroup:CreditCardPaymentOnl
                                                    y,OrderSubmissionOnly,
      53  Password. . . . . . . . . . .    25 SNN  Password. . . . . . . . . . . .
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(586,25)}
      54  EMailAddress. . . . . . . . .    50 SNN  Email Address . . . . . . . . .EMAILADDRESS
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(536,50)}
      55  BillToName. . . . . . . . . .    30 SNN  Bill-To Name. . . . . . . . . .NAME
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(131,30)}
      56  BillToAddress1. . . . . . . .    30 SNN  Bill-To Address 1 . . . . . . .ADDRESSLINE
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(161,30)}
      57  BillToAddress2. . . . . . . .    30 SNN  Bill-To Address 2 . . . . . . .ADDRESSLINE
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(191,30)}
      58  BillToAddress3. . . . . . . .    30 SNN  Bill-To Address 3 . . . . . . .ADDRESSLINE
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(221,30)}
      59  BillToCity. . . . . . . . . .    20 SNN  Bill-To City. . . . . . . . . .CITY
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(251,20)}
      60  BillToState . . . . . . . . .     2 SNN  Bill-To State . . . . . . . . .STATE
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(271,2)}
      61  BillToZipCode . . . . . . . .    10 SNN  Bill-To Zip Code. . . . . . . .ZIPCODE
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(273,10)}
      62  BillToCountryCode . . . . . .     3 SYN  Bill-To Country Code. . . . . .COUNTRY
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(283,3)}
      63  TelephoneNo1. . . . . . . . .    17 SNN  Telephone Number 1. . . . . . .TELEPHONENO
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(286,17)}
      64  TelephoneExt1 . . . . . . . .     5 SNN  Telephone Extension 1 . . . . .
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(303,5)}
      65  TelephoneNo2. . . . . . . . .    17 SNN  Telephone Number 2. . . . . . .TELEPHONENO
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(308,17)}
      66  TelephoneExt2 . . . . . . . .     5 SNN  Telephone Extension 2 . . . . .
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(325,5)}
      67  FaxNo . . . . . . . . . . . .    17 SNN  Fax Number. . . . . . . . . . .TELEPHONENO
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(330,17)}
      68  ShipToName. . . . . . . . . .    30 SNN  Ship-To Name. . . . . . . . . .NAME
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(347,30)}
      69  ShipToAddress1. . . . . . . .    30 SNN  Ship-To Address 1 . . . . . . .ADDRESSLINE
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(377,30)}
      70  ShipToAddress2. . . . . . . .    30 SNN  Ship-To Address 2 . . . . . . .ADDRESSLINE
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(407,30)}
      71  ShipToAddress3. . . . . . . .    30 SNN  Ship-To Address 3 . . . . . . .ADDRESSLINE
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(437,30)}
      72  ShipToCity. . . . . . . . . .    20 SNN  Ship-To City. . . . . . . . . .CITY
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(467,20)}
      73  ShipToState . . . . . . . . .     2 SNN  Ship-To State . . . . . . . . .STATE
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(487,2)}
      74  ShipToZipCode . . . . . . . .    10 SNN  Ship-To Zip Code. . . . . . . .ZIPCODE
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(489,10)}
      75  ShipToCountryCode . . . . . .     3 SYN  Ship-To Country Code. . . . . .COUNTRY
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(499,3)}
      76  ShipToTelephoneNo . . . . . .    17 SNN  Ship-ToTelephone Number . . . .TELEPHONENO
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(502,17)}
      77  ShipToTelephoneExt. . . . . .     5 SNN  Telephone Extension . . . . . .TELEPHONEEXT
                                                    ValGroup:StoreSubmissionOnly
      78  ShipToFaxNo . . . . . . . . .    17 SNN  Ship-To Fax Number. . . . . . .TELEPHONENO
                                                    ValGroup:StoreSubmissionOnly
                                                    Notes: {ITA$(519,17)}
      79  DateSubmitted . . . . . . . .     8 SNY  Date Submitted. . . . . . . . .DATE
                                                    Notes: {ITA$(22,6)}
      80  TimeSubmitted . . . . . . . .     6 SNY  Time Submitted. . . . . . . . .
                                                    Notes: {ITA$(28,6)}
      81  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      82  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                    Read Only:Y
      83  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
      84  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      85  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y
      86  UserUpdatedKey. . . . . . . .    10 SNN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000