IT_ShoppingCartAutoLogHdr IT Shopping Cart Auto Log Header Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IT_ShoppingCart_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/IT"+%C$+"/IT_ShoppingCartAutoLogHdr.M4T"
KPRIMARY: UserID+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 UserID. . . . . . . . . . . . 15 SYY e Business Manager User ID. . . FmtType:CHARNUM Notes: {ITJ$(1,15)} 2 SequenceNo. . . . . . . . . . 6 SNY Sequence Number . . . . . . . . Mask:000000 FmtType:ZEROFILL Notes: {ITJ$(16,5)} 3 ShipToCode. . . . . . . . . . 4 SYN Ship To Code. . . . . . . . . .SHIPTO Notes: {ITJ$(34,4)} 4 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . .TAXSCHEDULE Notes: {ITJ$(80,9)} 5 ShipDate. . . . . . . . . . . 8 SNN Ship Date . . . . . . . . . . .DATE Notes: {ITJ$(121,6)} 6 ShipVia . . . . . . . . . . . 15 SYY Ship Via. . . . . . . . . . . .SHIPCODE Notes: {ITJ$(58,15)} 7 ShipWeight. . . . . . . . . . 5 SYN Ship Weight . . . . . . . . . .SHIPWEIGHT Mask:0 Notes: {ITJ$(111,5)} 8 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO Notes: {ITJ$(43,15)} 9 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM Notes: {ITJ$(77,3)} 10 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 11 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO 12 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION Mask:00 13 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO Notes: {ITJ$(73,4)} 14 PaymentType . . . . . . . . . 5 SYN Payment Type. . . . . . . . . .PAYMENTTYPE Notes: {ITJ$(612,5)} 15 OtherPaymentTypeRefNo . . . . 24 SNN Other Payment Type Reference Nu Notes: {ITJ$(692,24)} 16 SalesOrderNo. . . . . . . . . 7 SYN Sales Order Number. . . . . . .SALESORDERNO Notes: {ITJ$(89,7)} 17 CreditLimitExceededCreditHold 1 SNN Order On Hold . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {ITJ$(127,1)} 18 TaxSchedAssignedFromXref. . . 1 SYN Tax Sched Assigned From Xref. . 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 19 TaxableSubjectToDiscount. . . 13.2 NNN Taxable Subject To Discount . .AMOUNT Mask:###,###,###.00 Notes: {ITJ[0]} 20 NonTaxableSubjectToDiscount . 13.2 NNN Non-Taxable Subject To DiscountAMOUNT Mask:###,###,###.00 Notes: {ITJ[1]} 21 TaxSubjToDiscPrcntOfTotSubjTo 7.2 NNN Tax-Subj-To-Disc % Of Total-Sub Mask:##0.00 Notes: {ITJ[2]} 22 DiscountRate. . . . . . . . . 8.3 NNN Discount Rate . . . . . . . . . Mask:##0.000 Notes: {ITJ[3]} 23 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ITJ[4]} 24 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {ITJ[5]} 25 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT Mask:###,###,###.00 Notes: {ITJ[6]} 26 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ITJ[7]} 27 Weight. . . . . . . . . . . . 12.2 NNN Weight. . . . . . . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ITJ[7]} 28 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ITJ[10]} 29 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 30 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 31 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 32 DateUpdated . . . . . . . . . 8 SNN Date Updated. . . . . . . . . .DATE Read Only:Y Notes: {ITJ$(22, 6)} 33 TimeUpdated . . . . . . . . . 6 SNN Time Updated. . . . . . . . . . Read Only:Y Notes: {ITJ$(28, 6)} 34 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000