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