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