SO_AutoGenerateOrders SO Auto Generate Orders Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: SO_AutoGenerateOrders_bus
SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_AutoGenerateOrders.M4T"
KPRIMARY: SalesOrderNo+OrderDate+ARDivisionNo+CustomerNo+SalespersonDivisionNo+SalespersonNo
Fld Column Name M/L TUR Description/Notes Class
1 SalesOrderNo. . . . . . . . . 7 SYY Sales Order Number. . . . . . .SALESORDERNO
FmtType:CHARNUM Notes:
{SO_10$(1,7)}
2 OrderDate . . . . . . . . . . 8 SNY Order Date. . . . . . . . . . .DATE
Read Only:Y Notes: {SO_10$(8,
6)}
3 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION
Read Only:Y Mask:00
FmtType:ZEROFILL Notes:
{SO_10$(14,2)}
4 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
Read Only:Y FmtType:MASTERNUM
C Notes: {SO_10$(16,7)}
5 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION
Read Only:Y Mask:00
FmtType:ZEROFILL Notes:
{SO_10$(23,2)}
6 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO
Read Only:Y FmtType:CHARNUM
Notes: {SO_10$(25,4)}
7 OrderType . . . . . . . . . . 1 SNN Order Type. . . . . . . . . . .
Read Only:Y
8 CycleCode . . . . . . . . . . 2 SYN Cycle Code. . . . . . . . . . .
Read Only:Y FmtType:CHARNUM
ValGroup:MasterRepeating
9 SalesOrderAmt . . . . . . . . 13.2 NNN Sales Order Amount. . . . . . .AMOUNT
Read Only:Y Mask:###,###,
###.00 Notes: {SO_10[0]}
10 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
11 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
12 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL