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