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