SO_AutoGenerateInvoices SO Auto Generate Invoices Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_AutoGenerateInvoices_bus SQL Def: N SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_AutoGenerateInvoices.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: {SOP$(1,7)} 2 OrderDate . . . . . . . . . . 8 SNY Order Date. . . . . . . . . . .DATE Read Only:Y Notes: {SOP$(8, 6)} 3 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION Read Only:Y Mask:00 FmtType:ZEROFILL Notes: {SOP$(14,2)} 4 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO Read Only:Y FmtType:MASTERNUM C ChngTag:Replace1/ARDivision No$ Notes: {SOP$(16,7)} 5 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION Read Only:Y Mask:00 FmtType:ZEROFILL Notes: {SOP$(23,2)} 6 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO Read Only:Y FmtType:CHARNUM Notes: {SOP$(25,4)} 7 BatchNo . . . . . . . . . . . 5 SYN Batch Number. . . . . . . . . . FmtType:ALPHANUM Notes: {SOP$(29,5)} 8 OrderType . . . . . . . . . . 1 SYN Order Type. . . . . . . . . . . Read Only:Y Valid:S,B,R Notes: S=Standard, B=Backorde r, R=Repeating {SOP$(34,2)} 9 CycleCode . . . . . . . . . . 2 SNN Cycle Code. . . . . . . . . . . Read Only:Y FmtType:CHARNUM ValGroup:MasterRepeating 10 PromiseDate . . . . . . . . . 8 SNN Promise Date. . . . . . . . . .DATE Read Only:Y 11 ShipDate. . . . . . . . . . . 8 SNN Ship Date . . . . . . . . . . .DATE Read Only:Y 12 SalesOrderAmt . . . . . . . . 13.2 NNN Sales Order Amount. . . . . . .AMOUNT Read Only:Y Mask:###,###, ###.00 Notes: {SOP[0]} 13 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 14 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 15 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL