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