SalesOrders Subroutines

Sales Order processing - SO details, open orders, shipping

Subroutine count: 6

Table of Contents

• VB_DELETESO
• VB_SHIP.REV1
• VB_SODET.REV1
• VB_SODET.REV2
• VB_SODET.REV3
• VB_SODET.REV4

---

VB_DELETESO

Signature: SUBROUTINE VB_DELETESO(INDATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_DELETESO

Property	Value
Status	[+] analyzed
Safety	[WARN] dangerous
Pattern	Process
Args	2
Description	Deletes a sales order and all associated line items, updating credit, credit hold, and cross-reference files

Arguments:

Index	Name	Direction	Description
0	INDATA	in	Packed input: <1>=CO (company), <2>=ORDNO (order number)
1	MESSAGE	out	Result message (e.g. ‘SO DELETED’, error if partially shipped)

Tables Written: OPEN.ORD.HEAD, OPEN.ORD.LINE, OPEN.ORD.HEAD.1287, OPEN.ORD.LINE.1287, CREDIT, CREDIT.HOLD, CREDIT.HOLD.XREF, CREDIT.RELEASE, OPEN.ORD.XREF

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_DELETESO",
    "args":  {
                 "0":  ""
             }
}

---

VB_SHIP.REV1

Signature: SUBROUTINE VB_0312(CO,REQTYPE,CUSTNO,SHIPNO,SHIPREC,SHIPOEREC,ADDFLAG,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_SHIP.REV1

Property	Value
Status	[+] analyzed
Safety	[COND] conditional
Pattern	CRUD
Args	8
Description	Saves or deletes ship-to address records based on REQTYPE; DELETE soft-deletes via flag, ADD/UPDATE writes full record
Dangerous REQTYPE	DELETE, ADD, UPDATE

Arguments:

Index	Name	Direction	Description
0	CO	in	Company number
1	REQTYPE	in	Request type: ‘DELETE’ for soft-delete, otherwise ADD/UPDATE
2	CUSTNO	in	Customer number
3	SHIPNO	in	Ship-to number
4	SHIPREC	in	Ship-to record data (dimensioned array, parsed from AM-delimited string)
5	SHIPOEREC	in	Ship-to OE record data (dimensioned array, parsed from AM-delimited string)
6	ADDFLAG	in	Add flag: true if adding new record, false if updating existing
7	MESSAGE	out	Result message (‘SAVED’ or ‘DELETED’)

Tables Written: SHIPTO, SHIPTO.OE, SHIPTO.1287

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_SHIP.REV1",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "4":  "",
                 "5":  "",
                 "6":  ""
             }
}

---

VB_SODET.REV1

Signature: SUBROUTINE VB_SODET.REV1(BEG.DATE, END.DATE, CUSTNO, DATA, MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_SODET.REV1

Property	Value
Status	[X] deprecated
Args	5
Superseded By	VB_SODET.REV4

Arguments:

Index	Name	Direction	Description
0	BEG.DATE	in
1	END.DATE	in
2	CUSTNO	in
3	DATA	out
4	MESSAGE	out

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_SODET.REV1",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  ""
             }
}

---

VB_SODET.REV2

Signature: SUBROUTINE VB_SODET.REV1(BEG.DATE, END.DATE, CUSTNO, PARTNO, DATA, MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_SODET.REV2

Property	Value
Status	[X] deprecated
Args	6
Superseded By	VB_SODET.REV4

Arguments:

Index	Name	Direction	Description
0	BEG.DATE	in
1	END.DATE	in
2	CUSTNO	in
3	PARTNO	in
4	DATA	out
5	MESSAGE	out

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_SODET.REV2",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  ""
             }
}

---

VB_SODET.REV3

Signature: SUBROUTINE VB_SODET.REV1(BEG.DATE, END.DATE, CUSTNO, PARTNO, DATA, MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_SODET.REV3

Property	Value
Status	[X] deprecated
Args	6
Superseded By	VB_SODET.REV4

Arguments:

Index	Name	Direction	Description
0	BEG.DATE	in
1	END.DATE	in
2	CUSTNO	in
3	PARTNO	in
4	DATA	out
5	MESSAGE	out

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_SODET.REV3",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  ""
             }
}

---

VB_SODET.REV4

Signature: SUBROUTINE VB_SODET.REV1(BEG.DATE, END.DATE, CUSTNO, PARTNO, DATA, MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_SODET.REV4

Property	Value
Status	[+] analyzed
Safety	[SAFE] safe
Pattern	Inquiry
Args	6
Description	Sales order detail inquiry - returns invoice/shipping data by date range, customer, and optional part number with cost, pricing, and ship-to details

Arguments:

Index	Name	Direction	Description
0	BEG.DATE	in	Beginning invoice date (MM/DD/YY format)
1	END.DATE	in	Ending invoice date (MM/DD/YY format)
2	CUSTNO	in	Customer number, or ‘ALL’ for all customers
3	PARTNO	in	Part number filter (optional, empty string for all parts)
4	DATA	out	Multi-valued result: <1>=CustNo, <2>=CustName, <3>=PONo, <4>=SONo, <5>=OrdDate, <6>=InvNo, <7>=InvDate, <8>=PromDate, <9>=ShipDate, <10>=PartNo, <11>=Description, <12>=MRP, <13>=UM, <14>=ShipQty, <15>=UnitPrice, <16>=ExtPrice, <17>=DiscountPct, <18>=MtlCost, <19>=OutCost, <20>=LbrHrs, <21>=ShipCity, <22>=ShipState, <23>=ShipZip, <24>=CustPartNo
5	MESSAGE	out	Error/status message (e.g. ‘NO RECORDS SELECTED.’)

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_SODET.REV4",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  ""
             }
}

---

---

Last updated: 2026-02-05 11:29 PM