SO_ShippingRateDetail SO Shipping Rate Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_ShippingRateDetail_bus
SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_ShippingRateDetail.M4T"
KPRIMARY: ShippingCode+ShipZone+GroupSort
Fld Column Name M/L TUR Description/Notes Class
1 ShippingCode. . . . . . . . . 15 SYY Shipping Code . . . . . . . . .SHIPCODE
Notes: {SO8$(1,15)}
2 ShipZone. . . . . . . . . . . 5 SYY Ship Zone . . . . . . . . . . .SHIPZONE
Notes: (Inverse if Zip Code)
{SO8_2$(17,5)}
3 GroupSort . . . . . . . . . . 15 SNN Group Sort. . . . . . . . . . .
Notes: (Depending upon
Header Type: Ship Weight,
Product Line or Amount Up To)
4 ShipWeight. . . . . . . . . . 5 SYN Ship Weight . . . . . . . . . .
FmtType:CHARNUM Notes:
{SO8_2$(22,5)}
5 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE
FmtType:CHARNUM Notes:
{SO8_3$(17,4)}
6 AmountUpTo. . . . . . . . . . 12.2 NNN Amount Up To. . . . . . . . . .MISCAMOUNT
Mask:##,###,###.00-
7 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .MISCAMOUNT
Mask:##,###,###.00- Notes:
{SO8_2[0]} {SO8_3[0]}
8 AdditionalChargePerIM . . . . 12.2 NNN Additional Charge Per InventoryMISCAMOUNT
Mask:##,###,###.00- Notes:
{SO8_3[2]}
9 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
10 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
11 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
12 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
13 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
14 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL