General Subroutines

Uncategorized subroutines

Subroutine count: 243

Table of Contents


VB_0304.REV1

Signature: SUBROUTINE VB_0304(CO,REQTYPE,CUSTNO,CREDITREC,ADDFLAG,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternCRUD
Args6
DescriptionSaves customer credit record. Converts the CREDITREC dimensioned array to a dynamic record and writes it to the CREDIT file keyed by company and customer number. Logs the transaction to the audit register via VB_S0910.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type (not branched on; always writes)
2CUSTNOinCustomer number used as part of the CREDIT file key
3CREDITRECinDimensioned credit record array to be written to CREDIT file via MATWRITE
4ADDFLAGinAdd flag (not used in current code)
5MESSAGEoutError or status message returned to caller

Tables Referenced: CREDIT

Tables Written: CREDIT, TRANSREG

API Call Example:

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

VB_0312.REV1

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

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

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternCRUD
Args7
DescriptionSaves or deletes ship-to address records. When REQTYPE is DELETE, removes records from SHIPTO, SHIPTO.OE, and SHIPTO.1287. Otherwise converts the dimensioned SHIPREC and SHIPOEREC arrays and writes them to the corresponding files. Logs changes via VB_S0910.
Dangerous REQTYPEDELETE

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type; DELETE triggers record removal
2CUSTNOinCustomer number for file key construction
3SHIPTOinShip-to sequence number for file key construction
4SHIPRECinDimensioned ship-to record to be written via MATWRITE to SHIPTO file
5SHIPOERECinDimensioned ship-to OE record to be written via MATWRITE to SHIPTO.OE file
6MESSAGEoutError or status message returned to caller

Tables Referenced: SHIPTO, SHIPTO.OE, SHIPTO.1287

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

API Call Example:

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

VB_2402.DEL

Signature: SUBROUTINE DUMMY(CO.STDS,CO.STDS.COST,OPEN.ORD.LINE,OPEN.ORD.CHRGS,OPEN.ORD.NOTES,PRODUCT,ITEMQTY,ITEMCA,LOT,LOTCOST,LOTCOSTXREF,LOTHIST,LOTHIST.AUDIT,LOTXREF,SOREQ,JOBXREF,JOB.BIN,JOB.BINXREF,JOB.PRODUCT,MLOSTSLS,MODELREQ,WBOOKING,UNITCONV,TRANSREG,DTRANSREG,CO,ORDNO,ZLINE,INITS,FILE,PGM,CRTNO,AUDIT,PURGEHEAD,CODE,MAT HREC,CWS,CES,BEL,BIN,BIN.PRODUCT,BINXREF,LOCODE,OPENWO,OPEN.ORD.LINE.1287)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_2402.DEL

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternInternal
Args45
DescriptionDeletes a sales order line item and updates all related files. Removes the line from OPEN.ORD.LINE, OPEN.ORD.NOTES, OPEN.ORD.CHRGS, and their .1287 counterparts. Adjusts ITEMQTY allocations, SOREQ cross-references, MODELREQ, lot allocations in ALLOCXREF, master schedule demand, and recalculates header totals. Logs changes via VB_S0910.

Arguments:

IndexNameDirectionDescription
0CO.STDSin
1CO.STDS.COSTin
2OPEN.ORD.LINEin
3OPEN.ORD.CHRGSin
4OPEN.ORD.NOTESin
5PRODUCTin
6ITEMQTYin
7ITEMCAin
8LOTin
9LOTCOSTin
10LOTCOSTXREFin
11LOTHISTin
12LOTHIST.AUDITin
13LOTXREFin
14SOREQin
15JOBXREFin
16JOB.BINin
17JOB.BINXREFin
18JOB.PRODUCTin
19MLOSTSLSin
20MODELREQin
21WBOOKINGin
22UNITCONVin
23TRANSREGin
24DTRANSREGin
25COin
26ORDNOin
27ZLINEin
28INITSin
29FILEin
30PGMin
31CRTNOin
32AUDITin
33PURGEHEADin
34CODEin
35HRECinoutOrder header record; modified with recalculated totals
36CWSin
37CESin
38BELin
39BINin
40BIN.PRODUCTin
41BINXREFin
42LOCODEin
43OPENWOin
44OPEN.ORD.LINE.1287in

Tables Referenced: ALLOCXREF, CO.STDS.ORD, CUSTOE, ITEMMANF, ITEMORD, ITEMORD.MS, ITEMQTY, JOBXREF, MODELREQ, MS.DEMAND, OPEN.ORD.CHRGS, OPEN.ORD.HEAD, OPEN.ORD.LINE, OPEN.ORD.LINE.1287, OPEN.ORD.NOTES, OPEN.ORD.XREF, PRODUCT, SOREQ, WBOOKING, WORKLOTSUM.MS

Tables Written: ALLOCXREF, ITEMQTY, ITEMORD.MS, JOBXREF, MODELREQ, MS.DEMAND, OPEN.ORD.CHRGS, OPEN.ORD.HEAD, OPEN.ORD.LINE, OPEN.ORD.LINE.1287, OPEN.ORD.NOTES, OPEN.ORD.XREF, SOREQ, TRANSREG, WBOOKING, WORKLOTSUM.MS

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_2402.DEL",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "4":  "",
                 "5":  "",
                 "6":  "",
                 "7":  "",
                 "8":  "",
                 "9":  "",
                 "10":  "",
                 "11":  "",
                 "12":  "",
                 "13":  "",
                 "14":  "",
                 "15":  "",
                 "16":  "",
                 "17":  "",
                 "18":  "",
                 "19":  "",
                 "20":  "",
                 "21":  "",
                 "22":  "",
                 "23":  "",
                 "24":  "",
                 "25":  "",
                 "26":  "",
                 "27":  "",
                 "28":  "",
                 "29":  "",
                 "30":  "",
                 "31":  "",
                 "32":  "",
                 "33":  "",
                 "34":  "",
                 "36":  "",
                 "37":  "",
                 "38":  "",
                 "39":  "",
                 "40":  "",
                 "41":  "",
                 "42":  "",
                 "43":  "",
                 "44":  ""
             }
}

VB_2402L

Signature: SUBROUTINE VB_2402L(INDATA,LREC,LREC2,NREC,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_2402L

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternCRUD
Args5
DescriptionSaves or deletes a sales order line item with department-based security. Checks @LOGNAME against department groups (accounting, parts, planning, shipping, other) to control field-level write access. Updates PRODUCT weight, ITEMQTY allocations, SOREQ cross-references, and JOBXREF. Shipping department users can only update item weight.

Arguments:

IndexNameDirectionDescription
0INDATAinPacked input: CO, SONO, LINENO, FORMATSO flag
1LRECinOPEN.ORD.LINE record from UI
2LREC2inOPEN.ORD.LINE.1287 record from UI
3NRECinOPEN.ORD.NOTES record from UI
4MESSAGEoutError or status message returned to caller

Tables Referenced: OPEN.ORD.HEAD, OPEN.ORD.LINE, OPEN.ORD.LINE.1287, OPEN.ORD.NOTES, PRODUCT, ITEMQTY, SOREQ, JOBXREF

Tables Written: OPEN.ORD.LINE, OPEN.ORD.LINE.1287, OPEN.ORD.NOTES, PRODUCT, ITEMQTY, SOREQ, JOBXREF

API Call Example:

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

VB_2403

Source: S:\LinuxShare\pro3prog\VBBASE\VB_2403

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternInternal
Args0
DescriptionDaily order register report program. Reads open order headers, formats and prints a report of orders not yet marked as printed, then stamps each order as printed. Not a callable subroutine (no SUBROUTINE declaration).

Tables Referenced: CO.STDS.ORD, CUSTOMER, OPEN.ORD.HEAD, OPEN.ORD.LINE, ORDTYPE, SALESMAN, SHIPTO

Tables Written: OPEN.ORD.HEAD

API Call Example:

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

VB_2450

Signature: SUBROUTINE VB_2450(INDATA,OUTDATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_2450

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args4
DescriptionTwo-step invoice entry. Validates the sales order, copies open order header/line/notes/charges to WORK2450 staging files, and calls VB_2452.UPD to perform the actual invoice file updates. Returns the generated invoice number in OUTDATA and any error in MESSAGE.

Arguments:

IndexNameDirectionDescription
0INDATAinPacked input: CO, SONO, INVNO (blank for new), INVDATE, POSTDATE
1INVRECinDimensioned invoice header record from UI (not used in this entry sub)
2OUTDATAoutPacked output: generated invoice number
3MESSAGEoutError or status message

Tables Referenced: CO.STDS.ORD, CUSTOMER, GL-COMPANY, OPEN.ORD.CHRGS, OPEN.ORD.HEAD, OPEN.ORD.LINE, OPEN.ORD.NOTES, ORDTYPE, PRODUCT, SHIPTO, WORK2450.CHRGS, WORK2450.HEAD, WORK2450.LINE, WORK2450.NOTES

Tables Written: WORK2450.CHRGS, WORK2450.HEAD, WORK2450.LINE, WORK2450.NOTES

API Call Example:

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

VB_2452.UPD

Signature: SUBROUTINE DUMMY(CO.STDS,CO.STDS.COST,CREDIT,INVAUDIT,INVAUDPOXREF,INVAUDWOXREF,INVHIST,INVXREF,INVOICE.HEAD,INVOICE.LINE,INVOICE.CHRGS,INVOICE.NOTES,INVOICE.TRAIL,ITEMCA,ITEMHIST,ITEMQTY,JOB.BIN,JOB.BINXREF,JOB.PRODUCT,LOT,LOTCOST,LOTCOSTXREF,LOTHIST,LOTHIST.AUDIT,LOTXREF,MLOSTSLS,MODELREQ,OPEN.ORD.HEAD,OPEN.ORD.LINE,OPEN.ORD.CHRGS,OPEN.ORD.NOTES,PRODUCT,SOREQ,SPECAUDIT,TRANSCRT,TRANSREG,DTRANSREG,UNITCONV,WBOOKING,WORK2450,WORK2450L,WORK2450C,WORK2450N,WOXREF,CES,CEL,BEL,CWS,CO,ORDNO,INVNO,CRTNO,FILE,INITS,SEL,AUDIT,MAT HREC,OLDH15,MAT TREC,BIN,BIN.PRODUCT,BINXREF,LOCODE,OPENWO)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_2452.UPD

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternInternal
Args64
DescriptionInvoice file update engine (called by VB_2450). Copies work file records to INVOICE.HEAD/LINE/NOTES/CHRGS, updates OPEN.ORD allocations and back-orders, adjusts ITEMQTY on-hand and committed quantities, posts to WIPLEDGER.SUM, creates GL transactions via WPOSTGL, updates bookings, and handles lot-tracked and drop-ship items.

Arguments:

IndexNameDirectionDescription
0CO.STDSin
1CO.STDS.COSTin
2CREDITin
3INVAUDITin
4INVAUDPOXREFin
5INVAUDWOXREFin
6INVHISTin
7INVXREFin
8INVOICE.HEADin
9INVOICE.LINEin
10INVOICE.CHRGSin
11INVOICE.NOTESin
12INVOICE.TRAILin
13ITEMCAin
14ITEMHISTin
15ITEMQTYin
16JOB.BINin
17JOB.BINXREFin
18JOB.PRODUCTin
19LOTin
20LOTCOSTin
21LOTCOSTXREFin
22LOTHISTin
23LOTHIST.AUDITin
24LOTXREFin
25MLOSTSLSin
26MODELREQin
27OPEN.ORD.HEADin
28OPEN.ORD.LINEin
29OPEN.ORD.CHRGSin
30OPEN.ORD.NOTESin
31PRODUCTin
32SOREQin
33SPECAUDITin
34TRANSCRTin
35TRANSREGin
36DTRANSREGin
37UNITCONVin
38WBOOKINGin
39WORK2450in
40WORK2450Lin
41WORK2450Cin
42WORK2450Nin
43WOXREFin
44CESin
45CELin
46BELin
47CWSin
48COin
49ORDNOin
50INVNOin
51CRTNOin
52FILEin
53INITSin
54SELin
55AUDITin
56HRECinoutInvoice header record; modified during processing
57OLDH15in
58TRECinoutInvoice transaction record; modified during processing
59BINin
60BIN.PRODUCTin
61BINXREFin
62LOCODEin
63OPENWOin

Tables Referenced: ALLOCXREF, BMF, CO.STDS.COST, CO.STDS.MS, CO.STDS.ORD, CREDIT, CUSTOE, CUSTOMER, DISCOUNT, FREIGHT, GL-COMPANY, INVOICE.CHRGS, INVOICE.HEAD, INVOICE.LINE, INVOICE.NOTES, ITEMMANF, ITEMORD, ITEMORD.MS, ITEMQTY, JOBMASTER, JOBXREF, MISCHG, MODELREQ, MS.DEMAND, OPEN.ORD.CHRGS, OPEN.ORD.HEAD, OPEN.ORD.LINE, OPEN.ORD.NOTES, OPEN.ORD.XREF, ORDTYPE, PCLASS, PRD.PRICE, PRODUCT, SALESMAN, SHIPTO, SOREQ, UNIT, UNITCONV, WBOOKING, WIPLEDGER.SUM, WORK2450.CHRGS, WORK2450.HEAD, WORK2450.LINE, WORK2450.NOTES, WORKLOTSUM.MS, WOSTATUS

Tables Written: ALLOCXREF, CREDIT, CUSTOE, INVOICE.CHRGS, INVOICE.HEAD, INVOICE.LINE, INVOICE.NOTES, ITEMORD.MS, ITEMQTY, JOBXREF, MODELREQ, MS.DEMAND, OPEN.ORD.CHRGS, OPEN.ORD.HEAD, OPEN.ORD.LINE, OPEN.ORD.NOTES, OPEN.ORD.XREF, SOREQ, TRANSREG, WBOOKING, WIPLEDGER.SUM, WORKLOTSUM.MS

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_2452.UPD",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "4":  "",
                 "5":  "",
                 "6":  "",
                 "7":  "",
                 "8":  "",
                 "9":  "",
                 "10":  "",
                 "11":  "",
                 "12":  "",
                 "13":  "",
                 "14":  "",
                 "15":  "",
                 "16":  "",
                 "17":  "",
                 "18":  "",
                 "19":  "",
                 "20":  "",
                 "21":  "",
                 "22":  "",
                 "23":  "",
                 "24":  "",
                 "25":  "",
                 "26":  "",
                 "27":  "",
                 "28":  "",
                 "29":  "",
                 "30":  "",
                 "31":  "",
                 "32":  "",
                 "33":  "",
                 "34":  "",
                 "35":  "",
                 "36":  "",
                 "37":  "",
                 "38":  "",
                 "39":  "",
                 "40":  "",
                 "41":  "",
                 "42":  "",
                 "43":  "",
                 "44":  "",
                 "45":  "",
                 "46":  "",
                 "47":  "",
                 "48":  "",
                 "49":  "",
                 "50":  "",
                 "51":  "",
                 "52":  "",
                 "53":  "",
                 "54":  "",
                 "55":  "",
                 "57":  "",
                 "59":  "",
                 "60":  "",
                 "61":  "",
                 "62":  "",
                 "63":  ""
             }
}

VB_2470

Signature: SUBROUTINE VB_2470(INDATA,HDATA,TDATA,OUTDATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_2470

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args4
DescriptionCredit memo header entry. Validates the customer, generates the next credit memo number from CO.STDS.ORD, creates work file staging records in WORK2470.HEAD, and calls VB_2472.UPD to perform the actual credit memo file updates. Returns the generated credit number in OUTDATA.

Arguments:

IndexNameDirectionDescription
0INDATAinPacked input: CO, CUSTNO, CREDITNO (blank for new), CREDITDATE, POSTDATE, INVNO
1CRDRECinDimensioned credit header record from UI
2OUTDATAoutPacked output: generated credit memo number
3MESSAGEoutError or status message

Tables Referenced: CO.STDS.ORD, CUSTOMER, GL-COMPANY, INVOICE.HEAD, ORDTYPE, SALESMAN, SHIPTO, WORK2470.HEAD

Tables Written: CO.STDS.ORD, WORK2470.HEAD

API Call Example:

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

VB_2470L

Signature: SUBROUTINE VB_2470L(INDATA,LREC,NREC,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_2470L

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternCRUD
Args4
DescriptionSaves a credit memo line item to staging work files. Writes the line record to WORK2470L and optional notes to WORK2470N. Handles note type assignment for multi-line notes.

Arguments:

IndexNameDirectionDescription
0INDATAinPacked input: CO, CREDITNO, LINENO
1LRECinCredit memo line record to write
2NRECinCredit memo notes record to write
3MESSAGEoutError or status message

Tables Referenced: WORK2470L, WORK2470N

Tables Written: WORK2470L, WORK2470N

API Call Example:

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

VB_2472.UPD

Signature: SUBROUTINE DUMMY(CO.STDS,CO.STDS.COST,INVAUDIT,INVAUDPOXREF,INVAUDWOXREF,INVHIST,INVXREF,INVOICE.HEAD,INVOICE.LINE,INVOICE.CHRGS,INVOICE.NOTES,INVOICE.TRAIL,ITEMCA,ITEMHIST,ITEMQTY,JOB.BIN,JOB.BINXREF,JOB.PRODUCT,LOT,LOTCOST,LOTCOSTXREF,LOTHIST,LOTHIST.AUDIT,LOTXREF,PRODUCT,SPECAUDIT,TRANSCRT,TRANSREG,DTRANSREG,WORK2470L,WORK2470C,WORK2470N,WOXREF,CES,CEL,BEL,CWS,CO,ORDNO,CREDNO,CRTNO,FILE,INITS,SEL,AUDIT,MAT HREC,MAT TREC,BIN,BIN.PRODUCT,BINXREF,LOCODE,OPENWO)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_2472.UPD

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternInternal
Args52
DescriptionCredit memo file update engine (called by VB_2470). Copies work file records to INVOICE.HEAD/LINE/NOTES (as credit type), reverses ITEMQTY quantities for returned items, posts GL transactions via WPOSTGL, updates customer credit balance, handles lot-tracked inventory returns, and adjusts bookings and master schedule records.

Arguments:

IndexNameDirectionDescription
0CO.STDSin
1CO.STDS.COSTin
2INVAUDITin
3INVAUDPOXREFin
4INVAUDWOXREFin
5INVHISTin
6INVXREFin
7INVOICE.HEADin
8INVOICE.LINEin
9INVOICE.CHRGSin
10INVOICE.NOTESin
11INVOICE.TRAILin
12ITEMCAin
13ITEMHISTin
14ITEMQTYin
15JOB.BINin
16JOB.BINXREFin
17JOB.PRODUCTin
18LOTin
19LOTCOSTin
20LOTCOSTXREFin
21LOTHISTin
22LOTHIST.AUDITin
23LOTXREFin
24PRODUCTin
25SPECAUDITin
26TRANSCRTin
27TRANSREGin
28DTRANSREGin
29WORK2470Lin
30WORK2470Cin
31WORK2470Nin
32WOXREFin
33CESin
34CELin
35BELin
36CWSin
37COin
38ORDNOin
39CREDNOin
40CRTNOin
41FILEin
42INITSin
43SELin
44AUDITin
45HRECinoutCredit memo header record; modified during processing
46TRECinoutCredit memo transaction record; modified during processing
47BINin
48BIN.PRODUCTin
49BINXREFin
50LOCODEin
51OPENWOin

Tables Referenced: ALLOCXREF, BMF, CO.STDS.COST, CO.STDS.MS, CO.STDS.ORD, CREDIT, CUSTOE, CUSTOMER, DISCOUNT, FREIGHT, GL-COMPANY, INVOICE.CHRGS, INVOICE.HEAD, INVOICE.LINE, INVOICE.NOTES, ITEMMANF, ITEMORD, ITEMORD.MS, ITEMQTY, MISCHG, MODELREQ, MS.DEMAND, OPEN.ORD.HEAD, OPEN.ORD.LINE, ORDTYPE, PCLASS, PRD.PRICE, PRODUCT, SALESMAN, SHIPTO, UNIT, UNITCONV, WBOOKING, WIPLEDGER.SUM, WORK2470.HEAD, WORK2470L, WORK2470N, WORKLOTSUM.MS

Tables Written: ALLOCXREF, CREDIT, CUSTOE, INVOICE.CHRGS, INVOICE.HEAD, INVOICE.LINE, INVOICE.NOTES, ITEMORD.MS, ITEMQTY, MODELREQ, MS.DEMAND, TRANSREG, WBOOKING, WIPLEDGER.SUM, WORKLOTSUM.MS

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_2472.UPD",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "4":  "",
                 "5":  "",
                 "6":  "",
                 "7":  "",
                 "8":  "",
                 "9":  "",
                 "10":  "",
                 "11":  "",
                 "12":  "",
                 "13":  "",
                 "14":  "",
                 "15":  "",
                 "16":  "",
                 "17":  "",
                 "18":  "",
                 "19":  "",
                 "20":  "",
                 "21":  "",
                 "22":  "",
                 "23":  "",
                 "24":  "",
                 "25":  "",
                 "26":  "",
                 "27":  "",
                 "28":  "",
                 "29":  "",
                 "30":  "",
                 "31":  "",
                 "32":  "",
                 "33":  "",
                 "34":  "",
                 "35":  "",
                 "36":  "",
                 "37":  "",
                 "38":  "",
                 "39":  "",
                 "40":  "",
                 "41":  "",
                 "42":  "",
                 "43":  "",
                 "44":  "",
                 "47":  "",
                 "48":  "",
                 "49":  "",
                 "50":  "",
                 "51":  ""
             }
}

VB_A7270

Signature: SUBROUTINE VB_A7270(ASSY.NOTES.XREF,BMF,BMF.ASSY.NOTES,BMF.NOTES,ITEMQTY,ALLOCXREF,ITEMMANF,WIPBMF,WIPBMF.ASSY.NOTES,WIPBMF.NOTES,OPENWO,PRODUCT,WO.ASSY.NOTES.XREF,CO,WONO,ASSY,REV,FCOMP,ORIGORDQTY,WOTYPE,BOMFLAG,MSG)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_A7270

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternInternal
Args22
DescriptionBuilds the WIP bill of material for a work order by exploding the product structure. Recursively walks the BOM tree, copies component records to WIPBMF tables, allocates inventory in ALLOCXREF and ITEMQTY, and handles substitute parts. Returns the first component record and any error message.

Arguments:

IndexNameDirectionDescription
0ASSY.NOTES.XREFin
1BMFin
2BMF.ASSY.NOTESin
3BMF.NOTESin
4ITEMQTYin
5ALLOCXREFin
6ITEMMANFin
7WIPBMFin
8WIPBMF.ASSY.NOTESin
9WIPBMF.NOTESin
10OPENWOin
11PRODUCTin
12WO.ASSY.NOTES.XREFin
13COin
14WONOin
15ASSYin
16REVin
17FCOMPinoutFirst component record returned to caller
18ORIGORDQTYin
19WOTYPEin
20BOMFLAGin
21MSGoutError message returned to caller

Tables Referenced: ALLOCXREF, BMF, BMF.NOTES, CO.STDS.WIP, ITEMMANF, ITEMQTY, OPENWO, PRODUCT, WIPBMF, WIPBMF.NOTES, WIPBMFCOST

Tables Written: ALLOCXREF, ITEMQTY, WIPBMF, WIPBMF.NOTES

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_A7270",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "4":  "",
                 "5":  "",
                 "6":  "",
                 "7":  "",
                 "8":  "",
                 "9":  "",
                 "10":  "",
                 "11":  "",
                 "12":  "",
                 "13":  "",
                 "14":  "",
                 "15":  "",
                 "16":  "",
                 "18":  "",
                 "19":  "",
                 "20":  ""
             }
}

VB_A7280

Signature: SUBROUTINE A7280(ALLOCXREF,BMF.NOTES,ITEMCA,ITEMMANF,ITEMQTY,OPENWO,PRODUCT,WIPBMF,WIPBMFCOST,WIPBMF.NOTES,CO,WONO,WOTYPE,COMP,NEWREC,FUNC,FINSTAT)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_A7280

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternInternal
Args17
DescriptionAdds or deletes a single WIP BOM component for a work order. On add, writes the component to WIPBMF, calculates material cost in WIPBMFCOST, copies notes from BMF.NOTES, and allocates inventory. On delete, reverses allocations and removes records. Updates the parent work order material cost in OPENWO.

Arguments:

IndexNameDirectionDescription
0ALLOCXREFin
1BMF.NOTESin
2ITEMCAin
3ITEMMANFin
4ITEMQTYin
5OPENWOin
6PRODUCTin
7WIPBMFin
8WIPBMFCOSTin
9WIPBMF.NOTESin
10COin
11WONOin
12WOTYPEin
13COMPin
14NEWRECinoutNew component record; modified during processing
15FUNCin
16FINSTATin

Tables Referenced: ALLOCXREF, BMF.NOTES, CO.STDS.WIP, ITEMMANF, ITEMQTY, OPENWO, PRODUCT, WIPBMF, WIPBMFCOST, WIPBMF.NOTES

Tables Written: ALLOCXREF, ITEMMANF, ITEMQTY, OPENWO, WIPBMF, WIPBMFCOST, WIPBMF.NOTES

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_A7280",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "4":  "",
                 "5":  "",
                 "6":  "",
                 "7":  "",
                 "8":  "",
                 "9":  "",
                 "10":  "",
                 "11":  "",
                 "12":  "",
                 "13":  "",
                 "15":  "",
                 "16":  ""
             }
}

VB_ACCOUNT.REV1

Signature: SUBROUTINE VB_ACCOUNT(CO,REQTYPE,ACCTNO,A1287REC,ADDFLAG,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternCRUD
Args6
DescriptionSaves or deletes an account (customer) record. When REQTYPE is DELETE, removes the account from ACCOUNT.1287. Otherwise converts the dimensioned A1287REC array and writes it to ACCOUNT.1287. Logs changes via VB_S0910.
Dangerous REQTYPEDELETE

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type; DELETE triggers record removal
2ACCOUNTNOinAccount number used as part of the file key
3A1287RECinDimensioned account record array to be written via MATWRITE to ACCOUNT.1287
4ADDFLAGinAdd flag (passed to audit subroutine for add vs change tracking)
5MESSAGEoutError or status message returned to caller

Tables Referenced: ACCOUNT.1287

Tables Written: ACCOUNT.1287, TRANSREG

API Call Example:

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

VB_ACCOUNTLIST

Signature: SUBROUTINE VB_ACCOUNTLIST(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_ACCOUNTLIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args4
DescriptionReturns a list of account numbers and names. Executes a SQL SELECT against the ACCOUNT file, then reads each selected record to build a two-column output array (account number and name). Read-only lookup.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1SQLinSQL SELECT statement to filter accounts
2DATAoutMulti-valued result: <1>=account numbers, <2>=account names
3MESSAGEoutError message if file open or read fails

Tables Referenced: ACCOUNT

API Call Example:

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

VB_ACCOUNTLIST.REV1

Signature: SUBROUTINE VB_ACCOUNTLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args5
Superseded ByVB_ACCOUNTLIST.REV3

Arguments:

IndexNameDirectionDescription
0COin
1IDLISTin
2SQLin
3DATAout
4MESSAGEout

API Call Example:

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

VB_ACCOUNTLIST.REV2

Signature: SUBROUTINE VB_ACCOUNTLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args5
Superseded ByVB_ACCOUNTLIST.REV3

Arguments:

IndexNameDirectionDescription
0COin
1IDLISTin
2SQLin
3DATAout
4MESSAGEout

API Call Example:

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

VB_ACCOUNTLIST.REV3

Signature: SUBROUTINE VB_ACCOUNTLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionReturns an extended account list with 14 columns including sector, industry class, location, PTI sales group, account type, and custom fields. Supports both SQL query and pre-built ID list inputs. Joins data from ACCOUNT.1287, INDSECTOR.1287, INDCLASS, EMPLOYEE.PUBLIC.1287, and ACCOUNTTYPE.1287. Read-only lookup.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinPre-built list of account IDs (alternative to SQL)
2SQLinSQL SELECT statement to filter accounts (alternative to IDLIST)
3DATAoutMulti-valued result with 14 attributes: account number, name, sector, industry, location, PTI sales, class, type name, and custom fields
4MESSAGEoutError message if file open or read fails

Tables Referenced: ACCOUNT.1287, ACCOUNTTYPE.1287, EMPLOYEE.PUBLIC.1287, INDCLASS, INDSECTOR.1287

API Call Example:

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

VB_ACTIVITY.REV1

Signature: SUBROUTINE VB_ACTIVITY.REV1(CO,REQTYPE,ACTNO,ACTREC,ADDFLAG,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternCRUD
Args6
DescriptionSaves or deletes an activity log record. When REQTYPE is DELETE, removes the record from ACTIVITY.LOG.1287. Otherwise converts the dimensioned ACTREC array and writes it to ACTIVITY.LOG.1287. Logs changes via VB_S0910.
Dangerous REQTYPEDELETE

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type; DELETE triggers record removal
2ACTIDinActivity log record ID
3ACTRECinDimensioned activity log record array to be written via MATWRITE
4ADDFLAGinAdd flag (passed to audit subroutine for add vs change tracking)
5MESSAGEoutError or status message returned to caller

Tables Referenced: ACTIVITY.LOG.1287

Tables Written: ACTIVITY.LOG.1287, TRANSREG

API Call Example:

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

VB_ACTIVITYLIST

Signature: SUBROUTINE VB_ACTIVITYLIST(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_ACTIVITYLIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args4
DescriptionReturns an activity log list via SQL query. Executes a SQL SELECT against ACTIVITY.LOG.1287, then reads each selected record and joins employee name from EMPLOYEE.PUBLIC.1287, account name from ACCOUNT.1287, and activity type from ACTIVITYTYPE.1287. Returns a 7-column result array. Read-only lookup.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1SQLinSQL SELECT statement to filter activity log records
2DATAoutMulti-valued result with 7 attributes: activity ID, date, employee name, account name, type, subject, and detail
3MESSAGEoutError message if file open or read fails

Tables Referenced: ACCOUNT.1287, ACTIVITY.LOG.1287, ACTIVITYTYPE.1287, EMPLOYEE.PUBLIC.1287

API Call Example:

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

VB_ACTIVITYLIST.REV2

Signature: SUBROUTINE VB_ACTIVITYLIST(SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionReturns an activity log list using BSELECT with support for ID list or SQL input. Reads each selected record and joins employee name, account name, and activity type. Returns a 10-column result array with additional fields (employee number, account number, completed flag) compared to REV1. Read-only lookup.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinPre-built list of activity log IDs (alternative to SQL)
2SQLinSQL SELECT statement to filter activity log records (alternative to IDLIST)
3DATAoutMulti-valued result with 10 attributes: activity ID, date, employee name/number, account name/number, type, subject, detail, completed
4MESSAGEoutError message if file open or read fails

Tables Referenced: ACCOUNT.1287, ACTIVITY.LOG.1287, ACTIVITYTYPE.1287, EMPLOYEE.PUBLIC.1287

API Call Example:

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

VB_AFTECDOC

Signature: SUBROUTINE VB_AFTECDOC(FILENAME,DOCNAME,TEXTFILE,ERRMSG)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_AFTECDOC

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args3
DescriptionReads documentation text files with support for nested .READ directives (up to 3 levels). Opens the named documentation file, reads its contents line by line, and recursively includes referenced files. Returns the assembled text and any error messages. Read-only lookup.

Arguments:

IndexNameDirectionDescription
0DOCNAMEinoutDocumentation file name to read; may be modified during nested .READ processing
1TEXTFILEoutAssembled text content from the documentation file and any nested includes
2ERRMSGoutError message if file cannot be opened or read

Tables Referenced: AFTEC.DOC

API Call Example:

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

VB_BKPLOT.1.REV1

Signature: SUBROUTINE VB_BKPLOT(CO,STOPCOMPONENT,PRN_LAYOUT,DATA)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_BKPLOT.1.REV1

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args5
DescriptionBOM explosion for book plot reports. Reads the product structure recursively to build a flattened bill of material, writes results to WORK.BKPLOTA.1287 staging file, and optionally updates the BK.HDR tracking record. Returns the exploded BOM data for reporting.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1PARTNOinPart number for BOM explosion
2OPTIONSinOptions flags controlling explosion depth and output format
3DATAoutExploded BOM data result
4MESSAGEoutError or status message

Tables Referenced: BMF, CO.STDS.WIP, PRODUCT, WORK.BKPLOTA.1287

Tables Written: BK.HDR, WORK.BKPLOTA.1287

API Call Example:

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

VB_BKPLOTA.REV1

Signature: SUBROUTINE VB_BKPLOTA(PLOTTYPE,DRAWLIST,PLOTINFO,MSG)

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

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args4
DescriptionGenerates CAD book plots by exploding BOM tree, building drawing lists, and sending plot requests. Creates headers for book plot batches.

Arguments:

IndexNameDirectionDescription
0PLOTTYPEinCompany number
1DRAWLISTinTop-level assembly part number
2PLOTINFOinBook plot type or configuration
3MSGoutReturn message (status/error)

Tables Referenced: COACCESS, GL-COMPANY, ITEMMANF, PRODUCT, BMF, PLOT.PARAMS, LOCKFILE, PRODUCT.1287, BMF.1287

Tables Written: WORK.BKPLOTA.1287, BK.HDR, WPDOCS, LOCKFILE

API Call Example:

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

VB_BLIST.REV1

Signature: SUBROUTINE VB_BLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternUtility
Args5
DescriptionExecutes a SQL/UniQuery select statement and returns the resulting list of keys. Used as a generic query executor.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinSQL/UniQuery SELECT statement to execute
2SQLinUnused/reserved
3DATAoutResulting select list of keys
4MESSAGEoutReturn message (status/error)

API Call Example:

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

VB_BMF.REV1

Signature: SUBROUTINE VB_BMF(CO,REQTYPE,ASSYNO,COMPNO,REV,BMFREC,BMF1287REC,NREC,ADDFLAG,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternCRUD
Args10
DescriptionSaves, updates, or deletes BMF (Bill of Material File) records based on REQTYPE. Handles BMF, BMF.1287, and BMF.NOTES records with audit trail support.
Dangerous REQTYPEDELETE, SAVENOTE

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type (DELETE, SAVENOTE, or save)
2ASSYNOinAssembly part number
3COMPNOinComponent part number
4REVinRevision level
5BMFRECinBMF record data to write
6BMF1287RECinBMF.1287 record data to write
7NRECinNotes record data to write
8ADDFLAGinAdd flag (true=add, false=update)
9MESSAGEoutReturn message (status/error)

Tables Referenced: BMF, BMF.1287, BMF.NOTES, CO.STDS.COST, CO.STDS.ENG, CO.STDS.CONF, ECN.DOCHIST, ECN.HEAD, EBATERR, ENG.STAT.MASTER.1287, GL-COMPANY, ITEMMANF, OPERATION, PRODUCT, PRODUCT.1287, PRODXREF, REVXREF, SP.CAT.1287, TRANSREG, PASSWORDS

Tables Written: BMF, BMF.1287, BMF.NOTES, PRODUCT.1287, TRANSREG

API Call Example:

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

VB_BMFUPDT.REV1

Signature: SUBROUTINE VB_BMFUPDT(BMF,BMF.NOTES,EBATERR,DEBATERR,ITEMMANF,PRODUCT,REVXREF,CO,ASSY,COMP,REV,BREC,ACTION,MODE,MSG)

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

PropertyValue
Status[+] analyzed
Safety[INT] internal
PatternInternal
Args15
DescriptionUpdates BMF linked-list pointers (first/next/previous component, first/next/previous where-used) in BMF and ITEMMANF files. Internal routine called by BOM management programs.

Arguments:

IndexNameDirectionDescription
0BMFinBMF file handle
1BMF.NOTESinITEMMANF file handle
2EBATERRinPRODUCT file handle
3DEBATERRinEBATERR file handle
4ITEMMANFinD_EBATERR dict file handle
5PRODUCTinGL-COMPANY file handle
6REVXREFinPRODXREF file handle
7COinCompany number
8ASSYinAssembly part number
9COMPinComponent part number
10REVinAction code (A=add, D=delete)
11BRECinoutBMF record (read/modified in place)
12ACTIONinRevision level
13MODEinMode (B=batch, O=online)
14MSGoutReturn message (status/error)

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_BMFUPDT.REV1",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "4":  "",
                 "5":  "",
                 "6":  "",
                 "7":  "",
                 "8":  "",
                 "9":  "",
                 "10":  "",
                 "12":  "",
                 "13":  ""
             }
}

VB_BOMEXPLORER.1

Signature: SUBROUTINE VB_BOMEXPLORER(TOPPART,PARTDATA,GTCODEDATA)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_BOMEXPLORER.1

PropertyValue
Status[X] deprecated
Args3
Superseded ByVB_BOMEXPLORER.3

Arguments:

IndexNameDirectionDescription
0TOPPARTin
1PARTDATAout
2GTCODEDATAout

API Call Example:

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

VB_BOMEXPLORER.1.REV2

Signature: SUBROUTINE VB_BOMEXPLORER(TOPPART,PARTDATA,GTCODEDATA,SEQDATA,UMDATA,QTYDATA)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_BOMEXPLORER.1.REV2

PropertyValue
Status[X] deprecated
Args6
Superseded ByVB_BOMEXPLORER.1.REV3

Arguments:

IndexNameDirectionDescription
0TOPPARTin
1PARTDATAout
2GTCODEDATAout
3SEQDATAout
4UMDATAout
5QTYDATAout

API Call Example:

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

VB_BOMEXPLORER.1.REV3

Signature: SUBROUTINE VB_BOMEXPLORER(CO,TOPPART,DATA)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_BOMEXPLORER.1.REV3

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args3
DescriptionReturns single-level BOM data for a given assembly. Provides part numbers, GT codes, sequences, units of measure, quantities, and descriptions.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1TOPPARTinAssembly part number
2DATAoutReturned BOM data (parts, GT codes, seq, UM, qty, desc)

Tables Referenced: PRODUCT, ITEMMANF, BMF

API Call Example:

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

VB_BOMEXPLORER.2

Signature: SUBROUTINE VB_BOMEXPLORER.2(SONO,PARTS,GTCODES)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_BOMEXPLORER.2

PropertyValue
Status[X] deprecated
Args3
Superseded ByVB_BOMEXPLORER.3

Arguments:

IndexNameDirectionDescription
0SONOin
1PARTSin
2GTCODESout

API Call Example:

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

VB_BOMEXPLORER.2.REV2

Signature: SUBROUTINE VB_BOMEXPLORER.2(SONO,PARTS,GTCODES,LINES,UMS,QTYS)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_BOMEXPLORER.2.REV2

PropertyValue
Status[X] deprecated
Args6
Superseded ByVB_BOMEXPLORER.2.REV3

Arguments:

IndexNameDirectionDescription
0SONOin
1PARTSin
2GTCODESin
3LINESin
4UMSin
5QTYSout

API Call Example:

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

VB_BOMEXPLORER.2.REV3

Signature: SUBROUTINE VB_BOMEXPLORER.2(CO,SONO,DATA)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_BOMEXPLORER.2.REV3

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args3
DescriptionReturns BOM data for a sales order by reading SO line items and resolving their BOM structures. Includes order quantities and line details.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1SONOinSales order number
2DATAoutReturned BOM data for all SO lines

Tables Referenced: OPEN.ORD.LINE, OPEN.ORD.HEAD, PRODUCT, ITEMMANF, BMF

API Call Example:

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

VB_BOMEXPLORER.3

Signature: SUBROUTINE VB_BOMEXPLORER(TOPPART,PARTDATA,GTCODEDATA,SEQDATA,UMDATA,QTYDATA)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_BOMEXPLORER.3

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args6
DescriptionOlder BOM explorer that resolves product-to-physical part number mappings via PRODUCT.1287. Returns data in 5 separate output arguments.

Arguments:

IndexNameDirectionDescription
0TOPPARTinAssembly part number (company!partno format)
1PARTDATAoutReturned component part numbers
2GTCODEDATAoutReturned GT codes
3SEQDATAoutReturned sequence numbers
4UMDATAoutReturned units of measure
5QTYDATAoutReturned quantities

Tables Referenced: PRODUCT, PRODUCT.1287, ITEMMANF, BMF

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_BOMEXPLORER.3",
    "args":  {
                 "0":  ""
             }
}

VB_BOMEXPLORER.3.REV3

Signature: SUBROUTINE VB_BOMEXPLORER(CO,TOPPART,DATA)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_BOMEXPLORER.3.REV3

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args3
DescriptionCompany-aware BOM explorer that resolves product-to-physical part number mappings via PRODUCT.1287. Returns consolidated data in a single output argument.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1TOPPARTinAssembly part number
2DATAoutReturned BOM data with physical/product resolution

Tables Referenced: PRODUCT, PRODUCT.1287, ITEMMANF, BMF

API Call Example:

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

VB_BOMLIST.REV1

Signature: SUBROUTINE VB_BOMLIST(CO,ASSYNO,BMFDATA,BMFNOTES,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args5
DescriptionReturns single-level BOM with 13 attributes per component (part, seq, desc, status, MRP, qty, UM, MTBF, spare, category, rec qty, in manual, manufacturer) plus line notes. Has sunset date check (09/30/21).

Arguments:

IndexNameDirectionDescription
0COinCompany number
1ASSYNOinAssembly part number
2BMFDATAoutReturned BOM data array (13 attributes per component)
3BMFNOTESoutReturned BOM line notes array
4MESSAGEoutReturn message (status/error)

Tables Referenced: BMF, BMF.1287, BMF.NOTES, GL-COMPANY, ITEMMANF, PRODUCT, PRODUCT.1287, PRODXREF, JOBMASTER.1287, OPENWO

API Call Example:

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

VB_BOMLIST.REV1_DOTNET

Signature: SUBROUTINE VB_BOMLIST(CO,ASSYNO,BMFDATA,BMFNOTES,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_BOMLIST.REV1_DOTNET

PropertyValue
Status[X] deprecated
Args5
Superseded ByVB_BOMLIST.REV1

Arguments:

IndexNameDirectionDescription
0COin
1ASSYNOin
2BMFDATAout
3BMFNOTESin
4MESSAGEout

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_BOMLIST.REV1_DOTNET",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "3":  ""
             }
}

VB_BOMLIST.REV1A

Signature: SUBROUTINE VB_BOMLIST(CO,ASSYNO,BMFDATA,BMFNOTES,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_BOMLIST.REV1A

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args5
DescriptionReturns single-level BOM with 13 attributes per component plus line notes. Same as REV1 but without sunset date check.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1ASSYNOinAssembly part number
2BMFDATAoutReturned BOM data array (13 attributes per component)
3BMFNOTESoutReturned BOM line notes array
4MESSAGEoutReturn message (status/error)

Tables Referenced: BMF, BMF.1287, BMF.NOTES, GL-COMPANY, ITEMMANF, PRODUCT, PRODUCT.1287, PRODXREF, JOBMASTER.1287, OPENWO

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_BOMLIST.REV1A",
    "args":  {
                 "0":  "",
                 "1":  ""
             }
}

VB_BOMNOTROUTED.REV1

Signature: SUBROUTINE VB_BOMNOTROUTED.REV1(CO,REQTYPE,INCL.PARTS,NUMBER,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args6
Superseded ByVB_BOMNOTROUTED.REV3

Arguments:

IndexNameDirectionDescription
0COin
1REQTYPEin
2INCL.PARTSin
3NUMBERin
4DATAout
5MESSAGEout

API Call Example:

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

VB_BOMNOTROUTED.REV2

Signature: SUBROUTINE VB_BOMNOTROUTED.REV1(CO,REQTYPE,INCL.PARTS,NUMBER,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args6
Superseded ByVB_BOMNOTROUTED.REV3

Arguments:

IndexNameDirectionDescription
0COin
1REQTYPEin
2INCL.PARTSin
3NUMBERin
4DATAout
5MESSAGEout

API Call Example:

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

VB_BOMNOTROUTED.REV3

Signature: SUBROUTINE VB_BOMNOTROUTED.REV1(CO,REQTYPE,INCL.PARTS,NUMBER,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternInquiry
Args6
DescriptionExplodes multi-level BOM for non-routed parts. Returns 27 attributes per component including inventory data, costs, and lead times. Supports SO, PART, and PAINT request types. Deletes empty BMF.NOTES records.
Safe REQTYPESO, PART, PAINT

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type (SO, PART, or PAINT)
2INCL.PARTSinPart number or SO number depending on REQTYPE
3NUMBERinRevision level or SO line number
4DATAoutReturned BOM explosion data (27 attributes per component)
5MESSAGEoutReturn message (status/error)

Tables Referenced: BMF, BMF.1287, BMF.NOTES, PRODUCT, PRODUCT.1287, ITEMMANF, ITEMQTY, GL-COMPANY, OPERATION, PRODXREF, OPEN.ORD.LINE, REVXREF, CO.STDS.ENG, JOBMASTER.1287, OPENWO

Tables Written: BMF.NOTES

API Call Example:

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

VB_BOMX.REV1

Signature: SUBROUTINE BOMX(CO,REQTYPE,INCL.PARTS,MLEVEL,LDS,NUMBER,TQTY,TWBS,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args10
DescriptionMulti-level BOM explosion for PART, SO, or JOB request types. Returns 20 attributes per component including inventory quantities, costs, lead times, and where-used data.
Safe REQTYPESO, PART, JOB

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type (SO, PART, or JOB)
2INCL.PARTSinPart number, SO number, or job/WO number
3MLEVELinRevision level or line number
4LDSinUnused/reserved
5NUMBERinUnused/reserved
6TQTYinUnused/reserved
7TWBSinUnused/reserved
8DATAoutReturned BOM explosion data (20 attributes per component)
9MESSAGEoutReturn message (status/error)

Tables Referenced: BMF, BMF.1287, BMF.NOTES, PRODUCT, PRODUCT.1287, ITEMMANF, ITEMQTY, GL-COMPANY, OPERATION, PRODXREF, OPEN.ORD.LINE, REVXREF, CO.STDS.ENG, JOBMASTER.1287, OPENWO, WIPBMF

API Call Example:

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

VB_C7270

Signature: SUBROUTINE C7270(ITEMQTY,ALLOCXREF,ITEMMANF,WIPBMF,OPENWO,PRODUCT,CO,WONO,ASSY,FCOMP,ORIGORDQTY,WOTYPE,OWOTYPE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_C7270

PropertyValue
Status[+] analyzed
Safety[INT] internal
PatternInternal
Args13
DescriptionRecalculates WIP BOM allocation quantities in WIPBMF and ALLOCXREF when work order quantities change. Internal routine that receives file handles as arguments.

Arguments:

IndexNameDirectionDescription
0ITEMQTYinITEMQTY file handle
1ALLOCXREFinALLOCXREF file handle
2ITEMMANFinITEMMANF file handle
3WIPBMFinWIPBMF file handle
4OPENWOinOPENWO file handle
5PRODUCTinPRODUCT file handle
6COinCompany number
7WONOinWork order number
8ASSYinAssembly part number
9FCOMPinFirst component in BOM linked list
10ORIGORDQTYinOriginal order quantity
11WOTYPEinNew work order type
12OWOTYPEinOld work order type

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_C7270",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "4":  "",
                 "5":  "",
                 "6":  "",
                 "7":  "",
                 "8":  "",
                 "9":  "",
                 "10":  "",
                 "11":  "",
                 "12":  ""
             }
}

VB_C7285

Signature: SUBROUTINE VB_C7285(ALLOCXREF,ITEMQTY,PRODUCT,WIPBMF,CO,WONO,FCOMP,WOTYPE,CONAME,BEL,CES)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_C7285

PropertyValue
Status[+] analyzed
Safety[INT] internal
PatternInternal
Args11
DescriptionCloses out WIP BOM allocations when a work order is completed or closed. Internal routine that receives file handles as arguments. Removes allocation records and updates inventory quantities.

Arguments:

IndexNameDirectionDescription
0ALLOCXREFinITEMQTY file handle
1ITEMQTYinALLOCXREF file handle
2PRODUCTinITEMMANF file handle
3WIPBMFinWIPBMF file handle
4COinOPENWO file handle
5WONOinPRODUCT file handle
6FCOMPinCompany number
7WOTYPEinWork order number
8CONAMEinAssembly part number
9BELinFirst component in BOM linked list
10CESinCost element structure data

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_C7285",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "4":  "",
                 "5":  "",
                 "6":  "",
                 "7":  "",
                 "8":  "",
                 "9":  "",
                 "10":  ""
             }
}

VB_CA1768

Signature: SUBROUTINE VB_CA1768(DATAIN,DATAOUT,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_CA1768

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args3
DescriptionGenerates Outside Operation Receipts Register report. Reads vendor receipt transactions and produces a summary report written to WORK1768.

Arguments:

IndexNameDirectionDescription
0DATAINinInput data array (company, fiscal period)
1DATAOUTinUnused/reserved
2MESSAGEoutReturn message (status/error)

Tables Referenced: GL-COMPANY, GL.CHARTS, VENDOR, OPENPO, OPENPO.1287, CLOSEDPO, CLOSEDPO.1287, WORK1768

Tables Written: WORK1768

API Call Example:

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

VB_CA1768C

Source: S:\LinuxShare\pro3prog\VBBASE\VB_CA1768C

PropertyValue
Status[+] analyzed
Safety[INT] internal
PatternInternal
Args0
DescriptionStandalone program fragment (no SUBROUTINE declaration) that reads GL.CHARTS, GL-COMPANY, and WORK1768 data. Appears to be a continuation or include segment for CA1768 processing.

Tables Referenced: GL.CHARTS, GL-COMPANY, WORK1768

API Call Example:

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

VB_CA1803

Signature: SUBROUTINE VB_CA1803(DATAIN,DATAOUT,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_CA1803

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args3
DescriptionGenerates Inventory Valuation Report. Reads product and inventory data, calculates valuations, and writes results to WORKPBS1803.1287.

Arguments:

IndexNameDirectionDescription
0DATAINinInput data array (company, report parameters)
1DATAOUTinUnused/reserved
2MESSAGEoutReturn message (status/error)

Tables Referenced: GL-COMPANY, GL.CHARTS, PRODUCT, ITEMQTY, ITEMMANF, CO.STDS.COST, OPERATION

Tables Written: WORKPBS1803.1287

API Call Example:

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

VB_CA1832

Signature: SUBROUTINE VB_CA1832(DATAIN,DATAOUT,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_CA1832

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args3
DescriptionGenerates Open Work Order Report by G/L account. Reads open work orders and calculates WIP costs by G/L classification. Writes to WIPCOST.1287, JOB.IP.1287, and OPENWO.

Arguments:

IndexNameDirectionDescription
0DATAINinInput data array (company, report parameters)
1DATAOUTinUnused/reserved
2MESSAGEoutReturn message (status/error)

Tables Referenced: GL-COMPANY, GL.CHARTS, OPENWO, WIPBMF, WIPLAB, JOBMASTER, JOBMASTER.1287, PRODUCT, ITEMMANF, OPERATION, CO.STDS.COST

Tables Written: WIPCOST.1287, JOB.IP.1287, OPENWO

API Call Example:

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

VB_CHKCHANGE

Signature: SUBROUTINE VB_ENGCHGLIST(DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_CHKCHANGE

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args2
DescriptionLists engineering change notices. File contains VB_ENGCHGLIST source code. DATA argument is inout: passes search filter criteria in, receives results out. Reads ENG.CHG.1287.

Arguments:

IndexNameDirectionDescription
0DATAinoutSearch filter criteria (in) / result data (out)
1MESSAGEoutReturn message (status/error)

Tables Referenced: ENG.CHG.1287

API Call Example:

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

VB_COCELIST

Signature: SUBROUTINE VB_COCELIST(DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_COCELIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args2
DescriptionReturns a sorted list of cost center (COCE) numbers and descriptions. Reads the COCE table and builds a two-attribute response array.

Arguments:

IndexNameDirectionDescription
0DATAoutReturned cost center data (numbers and descriptions)
1MESSAGEoutReturn message (status/error)

Tables Referenced: COCE

API Call Example:

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

VB_COMPETITORLIST.REV1

Signature: SUBROUTINE VB_COMPETITORLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionReturns a list of competitors with their numbers and names from COMPETITOR.1287, filtered by SQL query or ID list

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinValue-mark delimited list of competitor IDs to retrieve
2SQLinSQL SELECT statement to filter competitors
3DATAoutMulti-valued array: <1>=competitor number, <2>=name
4MESSAGEoutError message if any

Tables Referenced: COMPETITOR.1287

API Call Example:

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

VB_CONTACTLIST

Signature: SUBROUTINE VB_CONTACTLIST(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_CONTACTLIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionReturns a list of contacts from CONTACT.1287 based on an SQL query, including name, company, address, and phone details

Arguments:

IndexNameDirectionDescription
0SQLinSQL SELECT statement to filter contacts
1DATAoutMulti-valued array: contact no, first name, last name, company, address, city, state, country, zip, phone
2MESSAGEoutError message if any

Tables Referenced: CONTACT.1287

API Call Example:

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

VB_CONTACTLIST.REV1

Signature: SUBROUTINE VB_CONTACTLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args5
Superseded ByVB_CONTACTLIST.REV2

Arguments:

IndexNameDirectionDescription
0COin
1IDLISTin
2SQLin
3DATAout
4MESSAGEout

API Call Example:

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

VB_CONTACTLIST.REV2

Signature: SUBROUTINE VB_CONTACTLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionReturns a contact list from CONTACT.1287 using BSELECT for performance, filtered by SQL query or ID list, with department field

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinValue-mark delimited list of contact IDs to retrieve
2SQLinSQL SELECT statement to filter contacts
3DATAoutMulti-valued array: contact no, first name, last name, company, address, city, state, country, zip, dept
4MESSAGEoutError message if any

Tables Referenced: CONTACT.1287

API Call Example:

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

VB_CONTACTS

Signature: SUBROUTINE VB_CONTACTS(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_CONTACTS

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionReturns contact details from CONTACT.1287 based on an SQL query, including name, phone, address, and company information

Arguments:

IndexNameDirectionDescription
0SQLinSQL SELECT statement to filter contacts
1DATAoutMulti-valued array: contact no, first name, last name, phone, address, city, state, country, zip, company
2MESSAGEoutError message if any

Tables Referenced: CONTACT.1287

API Call Example:

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

VB_CONVERTNCN

Signature: SUBROUTINE VB_ENGCHGLIST(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_CONVERTNCN

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionReads NCN records from NCN.1287 based on an SQL query and returns all 53 fields as a data array

Arguments:

IndexNameDirectionDescription
0SQLinSQL SELECT statement to filter NCN records
1DATAinoutInput: search criteria; Output: multi-valued array of NCN fields
2MESSAGEoutError message if any

Tables Referenced: NCN.1287

API Call Example:

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

VB_CUSTOMERLIST

Signature: SUBROUTINE VB_CUSTOMERLIST(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_CUSTOMERLIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionReturns a customer list from CUSTOMER and CREDIT files based on SQL query, including name, phone, fax, contact, class, and credit hold

Arguments:

IndexNameDirectionDescription
0SQLinSQL SELECT statement to filter customers
1DATAoutMulti-valued array: customer no, name, phone, fax, contact, class, credit hold, address, city
2MESSAGEoutError message if any

Tables Referenced: CUSTOMER, CREDIT

API Call Example:

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

VB_CUSTOMERLIST.REV1

Signature: SUBROUTINE VB_CUSTOMERLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionReturns a customer list from CUSTOMER and CREDIT files, filtered by SQL query or ID list, with company-prefixed keys

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinValue-mark delimited list of customer IDs
2SQLinSQL SELECT statement to filter customers
3DATAoutMulti-valued array: customer no, name, phone, fax, contact, class, credit hold, address, city
4MESSAGEoutError message if any

Tables Referenced: CUSTOMER, CREDIT

API Call Example:

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

VB_D7270

Signature: SUBROUTINE D7270 (BMF,ITEMQTY,ALLOCXREF,ITEMMANF,WIPBMF,WIPBMF.NOTES,WIPBMFCOST,OPENWO,CA.XREF,CO,WONO,ASSY,COMP,WOTYPE,JOBNO,CANO,MSG)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_D7270

PropertyValue
Status[+] analyzed
Safety[INT] internal
PatternProcess
Args17
DescriptionInternal subroutine that deletes WIP-BOM links and updates ITEMMANF/ITEMQTY records for work order component removal

Arguments:

IndexNameDirectionDescription
0BMFinFile handle to BMF table
1ITEMQTYinFile handle to ITEMQTY table
2ALLOCXREFinFile handle to ALLOCXREF table
3ITEMMANFinFile handle to ITEMMANF table
4WIPBMFinFile handle to WIPBMF table
5WIPBMF.NOTESinFile handle to WIPBMF.NOTES table
6WIPBMFCOSTinFile handle to WIPBMFCOST table
7OPENWOinFile handle to OPENWO table
8CA.XREFinFile handle to CA.XREF table
9COinCompany number
10WONOinWork order number
11ASSYinAssembly part number
12COMPinComponent part number
13WOTYPEinWork order type
14JOBNOinJob number
15CANOinCA number
16MSGoutError message if any

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_D7270",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "4":  "",
                 "5":  "",
                 "6":  "",
                 "7":  "",
                 "8":  "",
                 "9":  "",
                 "10":  "",
                 "11":  "",
                 "12":  "",
                 "13":  "",
                 "14":  "",
                 "15":  ""
             }
}

VB_DATE.PLAN

Signature: SUBROUTINE DATE.PLAN(CAP.REQ.LAB,CAP.REQ.LAB.XREF,CAP.REQ.MACH,CAP.REQ.MACH.XREF,CAP.SIM.LAB,CAP.SIM.LAB.XREF,CAP.SIM.MACH,CAP.SIM.MACH.XREF,OPENWO,OPENWO.SIM,SF.CAL,SF.CAL.WOCE,ROUTELINEFILE,WOCE,CO,WO.PART,HEADID,SLN,SLREC,SDTE,LASTLINE,FB,CLERICAL,ERRCODE,ERRDATE,ERRDATE2,ERRLN,ERROP,ERRWKCEN,ONESHOT,STD,SQTY,YQFLAG,STDREC,SIMULATION,DUMMY1,DUMMY2)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_DATE.PLAN

PropertyValue
Status[+] analyzed
Safety[INT] internal
PatternProcess
Args37
DescriptionInternal subroutine that performs complex date planning and scheduling for work order route lines, calculating start/due dates based on capacity and calendar

Arguments:

IndexNameDirectionDescription
0ROUTELINEFILEinFile handle to ROUTELINE table
1WORKCENTERFILEinFile handle to WORKCENTER table
2CALENDARFILEinFile handle to CALENDAR table
3OPENWOFILEinFile handle to OPENWO table
4WCCAPFILEinFile handle to WCCAP table
5WCCAPDAYFILEinFile handle to WCCAPDAY table
6PRODUCTFILEinFile handle to PRODUCT table
7SHIFTDEFFILEinFile handle to SHIFTDEF table
8ROUTELINKFILEinFile handle to ROUTELINK table
9WCOVERRIDESFILEinFile handle to WC.OVERRIDES table
10WCSHIFTFILEinFile handle to WC.SHIFT table
11EMPPUBFILEinFile handle to EMPLOYEE.PUBLIC table
12LABORHEADERFILEinFile handle to LABORHEADER table
13WCSUMMARYFILEinFile handle to WCSUMMARY table
14COinCompany number
15WESSIONinWork order number
16KEYinRoute key
17DIRECTIONinSchedule direction (F=Forward, B=Backward)
18STARTDATEinStart or due date
19QTYinQuantity to schedule
20MODEinScheduling mode flags
21OVERLAPinOverlap control
22FINITEinFinite/infinite scheduling flag
23ERRFLAGoutError flag
24ERRMSGoutError message
25CALCSTARToutCalculated start date
26CALCDUEoutCalculated due date
27RESULTSoutSchedule results array
28CAPRESULTSoutCapacity results array
29SETUPHRSinSetup hours override
30RUNHRSinRun hours override
31MOVEDAYSinMove days override
32QUEUEDAYSinQueue days override
33EFFICIENCYinEfficiency override
34UTILIZATIONinUtilization override
35CREWSIZEinCrew size override
36MACHINESinMachines override

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_DATE.PLAN",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "4":  "",
                 "5":  "",
                 "6":  "",
                 "7":  "",
                 "8":  "",
                 "9":  "",
                 "10":  "",
                 "11":  "",
                 "12":  "",
                 "13":  "",
                 "14":  "",
                 "15":  "",
                 "16":  "",
                 "17":  "",
                 "18":  "",
                 "19":  "",
                 "20":  "",
                 "21":  "",
                 "22":  "",
                 "29":  "",
                 "30":  "",
                 "31":  "",
                 "32":  "",
                 "33":  "",
                 "34":  "",
                 "35":  "",
                 "36":  ""
             }
}

VB_DELETE.SIM

Signature: SUBROUTINE VB_DELETE.SIM(INDATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_DELETE.SIM

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternCRUD
Args2
DescriptionDeletes simulated work order data from OPENWO.SIM, WIPROUTE.SIM.HEAD, and WIPROUTE.SIM.LINE tables

Arguments:

IndexNameDirectionDescription
0INDATAinMulti-valued input: <1>=company, <2>=work order list
1MESSAGEoutError message if any

Tables Referenced: OPENWO.SIM, WIPROUTE.SIM.HEAD, WIPROUTE.SIM.LINE

Tables Written: OPENWO.SIM, WIPROUTE.SIM.HEAD, WIPROUTE.SIM.LINE

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_DELETE.SIM",
    "args":  {
                 "0":  ""
             }
}

VB_DELETE_PDM

Signature: SUBROUTINE DELETE_PDM(INREC,OUTREC,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_DELETE_PDM

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternCRUD
Args3
DescriptionDeletes PDM records from PDM.1287 and updates cross-reference via VB_PDMXREF

Arguments:

IndexNameDirectionDescription
0INRECinInput record: <1>=company, <2>=PDM ID to delete
1OUTRECoutOutput record (empty on success)
2MESSAGEoutError message if any

Tables Referenced: PDM.1287

Tables Written: PDM.1287

API Call Example:

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

VB_DELETE0001

Signature: SUBROUTINE VB_DELETE0001(CO,PARTNO,PARTREC,PROBLEM)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_DELETE0001

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternCRUD
Args3
DescriptionDeletes a part number and all related records across 15+ tables with validation checks for open orders, lots, and revisions

Arguments:

IndexNameDirectionDescription
0COinCompany number
1PARTRECinPart record used for audit trail logging
2PROBLEMoutError/problem description if deletion cannot proceed

Tables Referenced: ITEMQTY, LOTXREF, REVXREF, ITEMMANF, REQ, PASSWORDS

Tables Written: PRODUCT.1287, PRODUCT, ITEMCA, ITEMQTY, ITEMORD, ITEMMANF, ITEMHIST, PRODUCT.NOTES, PRD.PRICE, POPRTSPEC, PVXREF, PRODVEND, PRODXREF, XREFINDEX, REFXPROD, TRANSREG

API Call Example:

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

VB_DICTLIST.REV1

Signature: SUBROUTINE VB_DICTLIST(DATA)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args1
DescriptionReturns a list of files from VOC that have associated D_ dictionary files

Arguments:

IndexNameDirectionDescription
0DATAoutMulti-valued list of file names that have D_ dictionaries

Tables Referenced: VOC

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_DICTLIST.REV1",
    "args":  {
 
             }
}

VB_DIRDEPOSITLIST.REV1

Signature: SUBROUTINE VB_DIRDEPOSITLIST(DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args2
DescriptionReturns a list of employee direct deposit accounts from EMPLOYEE and DIRDEP.1287 tables

Arguments:

IndexNameDirectionDescription
0DATAoutMulti-valued array: employee no, name, bank, account, routing, amount, type
1MESSAGEoutError message if any

Tables Referenced: EMPLOYEE, DIRDEP.1287

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_DIRDEPOSITLIST.REV1",
    "args":  {
 
             }
}

VB_E0052A

Signature: SUBROUTINE E0052A(CO,ASSY,COMP,REV,BREC,ACTION,ERRMSG)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_E0052A

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternProcess
Args7
DescriptionAdds or deletes BOM structure links between assembly and component parts, updating BMF, ITEMMANF, and revision cross-references

Arguments:

IndexNameDirectionDescription
0COinCompany number
1ESSIONinAssembly part number
2COMPinComponent part number
3ACTIONinAction: A=Add, D=Delete
4BRECinoutBOM record data (input for delete, output after add/update)
5REVinRevision level
6ERRMSGoutError message if any

Tables Referenced: BMF, BMF.1287, BMF.NOTES, ITEMMANF, PRODUCT, PRODUCT.1287, REVXREF

Tables Written: BMF, BMF.1287, BMF.NOTES, ITEMMANF, PRODUCT.1287, REVXREF, TRANSREG

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_E0052A",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "5":  ""
             }
}

VB_E0052A.REV1

Signature: SUBROUTINE VB_E0052A(CO,ASSY,COMP,REV,BREC,ACTION,MODE,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternProcess
Args8
DescriptionEnhanced BOM structure link manager with batch mode support, adds or deletes BOM links with optional batch error logging

Arguments:

IndexNameDirectionDescription
0COinCompany number
1ESSIONinAssembly part number
2COMPinComponent part number
3ACTIONinAction: A=Add, D=Delete
4BRECinoutBOM record data (input for delete, output after add/update)
5REVinRevision level
6MODEinMode: O=Online, B=Batch
7MESSAGEoutError message if any

Tables Referenced: BMF, BMF.1287, BMF.NOTES, ITEMMANF, PRODUCT, PRODUCT.1287, REVXREF

Tables Written: BMF, BMF.1287, BMF.NOTES, ITEMMANF, PRODUCT.1287, REVXREF, TRANSREG

API Call Example:

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

VB_E0065.REV1

Signature: SUBROUTINE VB_E0065(CO,ASSY,REV,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args4
DescriptionDeletes an entire single-level BOM by iterating all components and calling VB_E0052A.REV1 to remove each link

Arguments:

IndexNameDirectionDescription
0COinCompany number
1ESSIONinAssembly part number whose BOM is being deleted
2REVinRevision level
3MESSAGEoutError message if any

Tables Referenced: BMF, BMF.1287, BMFLOCK, ITEMMANF, PRODUCT.1287, REVXREF

Tables Written: BMF, BMF.1287, BMF.NOTES, BMFLOCK, ITEMMANF, PRODUCT.1287, REVXREF, TRANSREG

API Call Example:

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

VB_EMPLOYEELIST

Signature: SUBROUTINE VB_EMPLOYEELIST(DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_EMPLOYEELIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args2
DescriptionReturns a list of employee titles from EMPLOYEE.PUBLIC.1287 based on search criteria

Arguments:

IndexNameDirectionDescription
0DATAinoutInput: search criteria; Output: multi-valued array of employee data (ID, name, title)
1MESSAGEoutError message if any

Tables Referenced: EMPLOYEE.PUBLIC.1287

API Call Example:

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

VB_EMPLOYEELIST.REV1

Signature: SUBROUTINE VB_EMPLOYEELIST(DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionReturns comprehensive payroll and employee data from EMPLOYEE, EMPLOYEE.401K.1287, and EMPLOYEE.PUBLIC.1287 with security restrictions by login

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinValue-mark delimited list of employee IDs
2SQLinSQL SELECT statement to filter employees
3DATAoutMulti-valued array: 51 fields per employee including pay rates, tax info, deductions, 401K data
4MESSAGEoutError message if any

Tables Referenced: EMPLOYEE, EMPLOYEE.401K.1287, EMPLOYEE.PUBLIC.1287

API Call Example:

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

VB_EMPLOYEEPUBLICLIST.REV1

Signature: SUBROUTINE VB_EMPLOYEEPUBLICLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionReturns a public employee list from EMPLOYEE.PUBLIC.1287, filtered by SQL query or ID list

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinValue-mark delimited list of employee IDs
2SQLinSQL SELECT statement to filter employees
3DATAoutMulti-valued array: employee no, first name, last name, title, department
4MESSAGEoutError message if any

Tables Referenced: EMPLOYEE.PUBLIC.1287

API Call Example:

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

VB_ENGCHGLIST

Signature: SUBROUTINE VB_ENGCHGLIST(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_ENGCHGLIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionRetrieves engineering change list records via SQL select and returns project number, change number, description, completion status, and department
Superseded ByVB_ENGCHGLIST.REV1

Arguments:

IndexNameDirectionDescription
0SQLinSQL select statement to filter engineering change records
1DATAoutMulti-valued array: <1>=project no, <2>=change no, <3>=description, <4>=complete status, <5>=department
2MESSAGEoutError or status message

Tables Referenced: ENG.CHG.1287, EMPLOYEE.PUBLIC.1287

API Call Example:

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

VB_ENGCHGLIST.REV1

Signature: SUBROUTINE VB_ENGCHGLIST(SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionRetrieves engineering change list via SQL select returning project no, change no, description, status, department, and change code

Arguments:

IndexNameDirectionDescription
0SQLinSQL select to filter eng change records
1DATAoutArray: <1>=project, <2>=change no, <3>=desc, <4>=complete, <5>=dept, <6>=change code
2MESSAGEoutError or status message

Tables Referenced: ENG.CHG.1287, EMPLOYEE.PUBLIC.1287

API Call Example:

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

VB_FINSTATCHECK

Signature: SUBROUTINE FINSTATCHECK(CO,BEL,CES,FILE,PGM,WONO,JOBNO,TYPE,CODELIST,COST.ACCOUNT,JOBMASTER,JOBTERMS,JOB.DET.FC,OPENWO,PASSWORDS,WIP.DET.FC,FAIL,ERR)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_FINSTATCHECK

PropertyValue
Status[+] analyzed
Safety[INT] internal
PatternUtility
Args18
DescriptionValidates financial status of work orders and jobs checking open/closed status of jobs, cost accounts, WO financial release, and detail records

Arguments:

IndexNameDirectionDescription
0COinCompany number
1BELinBell char (terminal)
2CESinClear screen char (terminal)
3FILEinFile variable (unused)
4PGMinProgram name (unused)
5WONOinWork order number
6JOBNOinJob number
7TYPEinType: M=material, L=labor, O=overhead, OD=ODC
8CODELISTinCost codes to validate
9COST.ACCOUNTinCOST.ACCOUNT file var (pre-opened)
10JOBMASTERinJOBMASTER file var (pre-opened)
11JOBTERMSinJOBTERMS file var (pre-opened)
12JOB.DET.FCinJOB.DET.FC file var (pre-opened)
13OPENWOinOPENWO file var (pre-opened)
14PASSWORDSinPASSWORDS file var (unused)
15WIP.DET.FCinWIP.DET.FC file var (pre-opened)
16FAILoutFail flag (1=invalid type)
17ERRoutError message

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_FINSTATCHECK",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "4":  "",
                 "5":  "",
                 "6":  "",
                 "7":  "",
                 "8":  "",
                 "9":  "",
                 "10":  "",
                 "11":  "",
                 "12":  "",
                 "13":  "",
                 "14":  "",
                 "15":  ""
             }
}

VB_FIX.ITEMCA

Signature: SUBROUTINE FIX.ITEMCA (CO,CODE,FPER,WONO)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_FIX.ITEMCA

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args4
DescriptionFixes last cost for a work order by clearing outside flag on OPENWO, setting reprocess flag on WIP.CLOSE, and executing CA1776B

Arguments:

IndexNameDirectionDescription
0COinCompany number
1CODEinCost code for CA1776B
2FPERinFiscal period
3WONOinWork order number

Tables Referenced: OPENWO.1287

Tables Written: OPENWO.1287, WIP.CLOSE

API Call Example:

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

VB_FIX.SROUTE.LINE

Signature: SUBROUTINE FIX.ROUTE.LINE(DATAIN,DATAOUT,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_FIX.SROUTE.LINE

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args3
DescriptionAdjusts standard routing lines for a part via ADJUST.ROUTE for outside ops machine parameters, rewrites records, calls VB_SF3081 for MLT

Arguments:

IndexNameDirectionDescription
0DATAINinInput: <1>=part number
1DATAOUToutOutput: <1>=manufacturing lead time
2MESSAGEoutStatus/error message

Tables Referenced: SROUTE.HEAD, SROUTE.LINE, OPERATION, WOCE.1287

Tables Written: SROUTE.LINE

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_FIX.SROUTE.LINE",
    "args":  {
                 "0":  ""
             }
}

VB_FS8040

Signature: SUBROUTINE VB_FS8040(CO,DATA,REPNUM,FMTNUM,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_FS8040

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args5
DescriptionGenerates financial statement report data by reading schedule totals and formatting debit/credit amounts for current and prior year periods

Arguments:

IndexNameDirectionDescription
0COinCompany number
1DATAoutFinancial data array with period amounts by schedule line
2REPNUMinReport number (e.g. 300)
3FMTNUMinFormat number for headings
4MESSAGEoutError or status message

Tables Referenced: FS.REPORT, FS.SCHED.TOTAL, FS.HEADINGS.FMT, FS.HEADINGS, FS.SCHED.REP.HEAD, FS.CALC.SALES, FS.JOB.STREAM

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_FS8040",
    "args":  {
                 "0":  "",
                 "2":  "",
                 "3":  ""
             }
}

VB_GET.EMPLIST

Signature: SUBROUTINE VB_EMPLOYEELIST(DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_GET.EMPLIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args2
DescriptionRetrieves comprehensive list of active employees with personal details, pay, shift/department, contractor status, vendor linkage

Arguments:

IndexNameDirectionDescription
0DATAout27-row employee data array
1MESSAGEoutError or status message

Tables Referenced: EMPLOYEE, EMPLOYEE.1287, EMPLOYEE.SUPP, EMPLOYEE.PUBLIC.1287, VENDOR

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_GET.EMPLIST",
    "args":  {
 
             }
}

VB_GET.INVENTORY

Signature: SUBROUTINE VB_GET.INVENTORY(INDATA,OUTDATA,ERRMSG)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_GET.INVENTORY

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args3
DescriptionRetrieves detailed inventory data including bins, lots, job quantities for a part or bin across MRP locations

Arguments:

IndexNameDirectionDescription
0INDATAinInput: <1>=type (PART/BIN), <2>=part no, <3>=bin no, <4>=location
1OUTDATAout15-row output: location, bin, qty, stk qty, lot, date, lot qty, job, job qty, part, desc, MRP, LCF, part qty, last date
2ERRMSGoutError message

Tables Referenced: ITEMQTY, PRODUCT, PRODUCT.1287, BINXREF, BIN.PRODUCT, LOTHIST, BIN

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_GET.INVENTORY",
    "args":  {
                 "0":  ""
             }
}

VB_GET.ITEMHIST

Signature: SUBROUTINE VB_GET.ITEMHIST(INDATA,OUTDATA,MSG)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_GET.ITEMHIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args3
DescriptionReturns 24-month inventory movement history for a part with balances, receipts, issues, returns, sales, scrap, adjustments

Arguments:

IndexNameDirectionDescription
0INDATAinInput: <1>=part number
1OUTDATAout10x25 array: month, balances, receipts, issues, returns, FS issues, sales, scrap, adjustments
2MSGoutError or status message

Tables Referenced: ITEMHIST, PRODUCT, PRODUCT.1287

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_GET.ITEMHIST",
    "args":  {
                 "0":  ""
             }
}

VB_GET.PARTINFO

Signature: SUBROUTINE VB_GET.PARTINFO(INDATA,PR,PR1287,IM,IM1287,IQ,IH,ERRMSG)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_GET.PARTINFO

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args8
DescriptionTracks PO line receiving progress by updating status, notes, promise dates, and WIP route status for outside processing

Arguments:

IndexNameDirectionDescription
0INDATAinInput: <1>=PO no, <2>=line no, <3>=rcv progress (0/1/2), <4>=pack slip no, <5>=note
1PRinUnused (PR)
2PR1287inUnused (PR1287)
3IMinUnused (IM)
4IM1287inUnused (IM1287)
5IQinUnused (IQ)
6IHinUnused (IH)
7ERRMSGoutError message

Tables Referenced: PRODUCT, BINXREF, LOTHIST, WIPROUTE.LINE, BIN, OPEN.PO.LINES, OPEN.PO.LINES.1287, WIPROUTE.HEAD

Tables Written: OPEN.PO.LINES, OPEN.PO.LINES.1287, WIPROUTE.LINE.1287

API Call Example:

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

VB_GETLOCKNAME

Signature: SUBROUTINE VB_GETLOCKNAME(NAME,FILE,ID)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_GETLOCKNAME

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternUtility
Args3
DescriptionReturns username holding a record lock on a file/record ID via GETREADU() lock table

Arguments:

IndexNameDirectionDescription
0NAMEoutLock holder name (empty if not locked)
1FILEinFile name to check
2IDinRecord ID to check

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_GETLOCKNAME",
    "args":  {
                 "1":  "",
                 "2":  ""
             }
}

VB_GETMFGCODE

Signature: SUBROUTINE VB_GETMFGCODE(LIST)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_GETMFGCODE

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args1
DescriptionRetrieves all manufacturer codes and names from MFG.1287

Tables Referenced: MFG.1287

API Call Example:

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

VB_GETPDMLIST.REV1

Signature: SUBROUTINE VB_BOMLIST(CO,ASSYNO,BMFDATA,BMFNOTES,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionReturns single-level BOM for an assembly with component details and line notes

Arguments:

IndexNameDirectionDescription
0COinCompany number
1ASSYNOinAssembly part number
2BMFDATAoutBOM data: 13 rows (comp, seq, desc, status, MRP, qty, UM, MTBF, spare, cat, rec qty, manual, mfg)
3BMFNOTESoutBOM notes: <1>=component, <2>=notes (SVM)
4MESSAGEoutError or status message

Tables Referenced: BMF, BMF.1287, BMF.NOTES, GL-COMPANY, ITEMMANF, PRODUCT, PRODUCT.1287, PRODXREF, JOBMASTER.1287, OPENWO

API Call Example:

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

VB_GETREADU

Signature: SUBROUTINE VB_GETREADU(INREC,OUTREC,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_GETREADU

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternUtility
Args3
DescriptionChecks if a user holds a lock on a record via GETREADU() lock table

Arguments:

IndexNameDirectionDescription
0INRECinInput: <1>=user ID, <2>=record ID
1OUTRECoutLock holder name if found
2MESSAGEoutMessage (unused)

API Call Example:

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

VB_GETRECPTDATE.REV1

Signature: SUBROUTING GETRECPTDATE(CO,PARTNO,RCPTDATE)

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

PropertyValue
Status[+] analyzed
Safety[INT] internal
PatternInternal
Args3
DescriptionLooks up most recent receipt date for a part by traversing inventory history, skipping adjustments (types 20,21,27,29)

Arguments:

IndexNameDirectionDescription
0COinCompany number
1PARTNOinPart number
2RCPTDATEoutFormatted receipt date

Tables Referenced: INVXREF, INVHIST

API Call Example:

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

VB_GLCATEGORY

Signature: SUBROUTINE VB_GLCATEGORY(DATAIN,DATAOUT,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_GLCATEGORY

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternList
Args3
DescriptionReturns GL category list or rebuilds GL.CHARTS.1287 cross-reference when update flag set

Arguments:

IndexNameDirectionDescription
0DATAINinInput: <1>=GL acct, <2>=cat no, <3>=update flag (Y=rebuild)
1DATAOUToutOutput: <1>=cat no, <2>=type, <3>=description
2MESSAGEoutError or status message

Tables Referenced: GL.CHARTS, GL.CHARTS.1287, CATEGORY, D CATEGORY

Tables Written: GL.CHARTS.1287

API Call Example:

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

VB_GLCHARTS

Signature: SUBROUTINE VB_GLCHARTS(CO,GLNO,FP.CUT,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_GLCHARTS

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args5
DescriptionRetrieves GL chart of accounts with YTD debits/credits/balances for a fiscal period cutoff

Arguments:

IndexNameDirectionDescription
0COinCompany number
1GLNOinGL account number (empty for full list)
2FP.CUTinFiscal period cutoff YY-MM
3DATAoutGL data: acct no, name, type, bal type, FY, YTD deb/crd, balance, period, per deb/crd, activity, beg bal
4MESSAGEoutError or status message

Tables Referenced: GL.CHARTS, COCE

API Call Example:

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

VB_GLCHARTS.BAK

Signature: SUBROUTINE VB_GLCHARTS(CO,GLNO,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_GLCHARTS.BAK

PropertyValue
Status[X] deprecated
Args4
Superseded ByVB_GLCHARTS

Arguments:

IndexNameDirectionDescription
0COin
1GLNOin
2DATAout
3MESSAGEout

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_GLCHARTS.BAK",
    "args":  {
                 "0":  "",
                 "1":  ""
             }
}

VB_GLCHARTS.NEW

Signature: SUBROUTINE VB_GLCHARTS(CO,GLNO,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_GLCHARTS.NEW

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args4
DescriptionEarlier VB_GLCHARTS version hardcoded to FY 15
Superseded ByVB_GLCHARTS

Arguments:

IndexNameDirectionDescription
0COinCompany number
1GLNOinGL account number (empty for full list)
2DATAoutGL data: acct no, name, type, bal type, FY, YTD deb/crd, balance, period, per deb/crd, activity
3MESSAGEoutError or status message

Tables Referenced: GL.CHARTS

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_GLCHARTS.NEW",
    "args":  {
                 "0":  "",
                 "1":  ""
             }
}

VB_GLJOURNAL

Signature: SUBROUTINE VB_GLJOURNAL(CO,JC,FPER,DOCNO,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_GLJOURNAL

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args6
DescriptionRetrieves GL journal transaction details for a journal code, fiscal period, and document number

Arguments:

IndexNameDirectionDescription
0COinCompany number
1JCinJournal code (e.g. GJ)
2FPERinFiscal period YY-MM
3DOCNOinDocument number (or ALL)
4DATAoutArray: doc no, date, acct no, desc, net amount, annotation, debit, credit
5MESSAGEoutError or status message

Tables Referenced: GL.CHARTS, GL.SOURCE.PERIOD, GL.XREF, GL.TRANS, GL.DOCUMENT.AUX

API Call Example:

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

VB_GLRECAP.REV1

Signature: SUBROUTINE VB_GLRECAP(CO,GLDATA,GL.PER,RUN.DATE,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args5
DescriptionSaves ADP payroll GL data to GLRECAP then executes MDSGLUPD to update WORKMDS

Arguments:

IndexNameDirectionDescription
0COinCompany number
1GLDATAinGL data: <1>=GL nos, <2>=debits, <3>=credits, <4>=D/C indicator
2GL.PERinGL fiscal period
3RUN.DATEinRun date for MDSGLUPD
4MESSAGEoutError or status message

Tables Referenced: GLRECAP

Tables Written: GLRECAP

API Call Example:

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

VB_GLTRANS

Signature: SUBROUTINE VB_GLTRANS(CO,GLNO,FPER,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_GLTRANS

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args5
DescriptionGL transaction inquiry. Validates company/GL account, reads GL chart of accounts, then traverses the GL.XREF linked list for the specified fiscal period to collect transaction records from GL.TRANS. Returns document numbers, dates, descriptions, debit/credit amounts, and running balance. Reads auxiliary document data from GL.DOCUMENT.AUX when available.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1GLNOinGL account number
2FPERinFiscal period (1-13)
3DATAoutMulti-valued array: document number, date, description, debit, credit, balance per transaction
4MESSAGEoutError message if company or GL account not found

Tables Referenced: GL.CHARTS, GL.DOCUMENT.AUX, GL.TRANS, GL.XREF, GL-COMPANY, HOLD

API Call Example:

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

VB_I.0026

Signature: SUBROUTINE VB_I.0026(DATAIN, DATAOUT, MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_I.0026

PropertyValue
Status[X] deprecated
Args3
Superseded ByVB_I.1656

Arguments:

IndexNameDirectionDescription
0DATAINout
1DATAOUTout
2MESSAGEout

Tables Referenced: OWNERSHIP, PWD.AUDIT

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_I.0026",
    "args":  {
 
             }
}

VB_I.0028

Signature: SUBROUTINE VB_I.0028(DATAIN, DATAOUT, MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_I.0028

PropertyValue
Status[X] deprecated
Args3
Superseded ByVB_I.1656

Arguments:

IndexNameDirectionDescription
0DATAINout
1DATAOUTout
2MESSAGEout

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_I.0028",
    "args":  {
 
             }
}

VB_I.1280

Signature: SUBROUTINE VB_I.1280(DATAIN, DATAOUT, MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_I.1280

PropertyValue
Status[X] deprecated
Args3
Superseded ByVB_I.1656

Arguments:

IndexNameDirectionDescription
0DATAINout
1DATAOUTout
2MESSAGEout

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_I.1280",
    "args":  {
 
             }
}

VB_I.1281

Signature: SUBROUTINE VB_I.1281(DATAIN, DATAOUT, MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_I.1281

PropertyValue
Status[X] deprecated
Args3
Superseded ByVB_I.1656

Arguments:

IndexNameDirectionDescription
0DATAINout
1DATAOUTout
2MESSAGEout

Tables Referenced: ALLOCXREF, COST.ACCOUNT, GL.CHARTS, GL-COMPANY, GL.ISSUE, ITEMHIST, ITEMQTY, JOB.DET.FC, JOBMASTER, JOBTERMS, OPENWO, PASSWORDS, PWD.AUDIT, WIP.DET.FC, WIPBMF, WIPBMFCOST, WIPLEDGER.AP, WIPLEDGER.LAB, WIPLEDGER.MAT, WIPLEDGER.OUT, WIPLEDGER.SUM

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_I.1281",
    "args":  {
 
             }
}

VB_I.1601

Signature: SUBROUTINE VB_I.1601(DATAIN, DATAOUT, MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_I.1601

PropertyValue
Status[X] deprecated
Args3
Superseded ByVB_I.1656

Arguments:

IndexNameDirectionDescription
0DATAINout
1DATAOUTout
2MESSAGEout

Tables Referenced: PWD.AUDIT

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_I.1601",
    "args":  {
 
             }
}

VB_I.1656

Signature: SUBROUTINE VB_I.1656(DATAIN,DATAOUT,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_I.1656

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args3
DescriptionOrchestrator for the daily inventory audit update process (report 1656). Checks for a LOCKFILE lock, then EXECUTEs sub-programs VB_I.1656B (work file builder), VB_I.1656C (report printer), and VB_I.1656GL (GL recap). Returns status via DATAOUT and MESSAGE.

Arguments:

IndexNameDirectionDescription
0DATAINinInput parameters (currently unused, overridden internally)
1DATAOUToutStatus data returned after processing
2MESSAGEoutError/status message

Tables Referenced: LOCKFILE

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_I.1656",
    "args":  {
                 "0":  ""
             }
}

VB_I.1656B

Source: S:\LinuxShare\pro3prog\VBBASE\VB_I.1656B

PropertyValue
Status[+] analyzed
Safety[INT] internal
PatternInternal
Args0
DescriptionWork file builder for the daily inventory audit update (1656). No SUBROUTINE declaration - this is a code fragment EXECUTEd by VB_I.1656. Iterates inventory history records, calculates material/labor/overhead costs, compares WIP costs against standard costs, and writes variance records to WORK1656 work files. Also updates LOTHIST.GL and corrects INVHIST/OPENWO records.

Tables Referenced: CACLASS, CATEGORY, CO.STDS.COST, CO.STDS.GL, INVHIST, LOCKFILE, LOTHIST, OPENWO, PRODUCT, WIPBMFCOST, WORK1656, WORK1656A, WORK1656B, WORK1656C

Tables Written: INVHIST, LOTHIST.GL, OPENWO, WORK1656, WORK1656A, WORK1656B, WORK1656C, WORK1656D

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_I.1656B",
    "args":  {
 
             }
}

VB_I.1656C

Source: S:\LinuxShare\pro3prog\VBBASE\VB_I.1656C

PropertyValue
Status[+] analyzed
Safety[INT] internal
PatternInternal
Args0
DescriptionReport printer for the daily inventory audit update (1656C). No SUBROUTINE declaration - this is a code fragment EXECUTEd by VB_I.1656. Reads WORK1656A/B work files and prints a detailed variance report with transaction type descriptions, GL account breakdowns, and company totals. Also writes corrected INVHIST records.

Tables Referenced: GL.CHARTS, GL-COMPANY, INVHIST, LOCKFILE, LOTHIST, OPENWO, TRANSTYPE, WORK1656A, WORK1656B

Tables Written: INVHIST

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_I.1656C",
    "args":  {
 
             }
}

VB_I.1656GL

Source: S:\LinuxShare\pro3prog\VBBASE\VB_I.1656GL

PropertyValue
Status[+] analyzed
Safety[INT] internal
PatternInternal
Args0
DescriptionGL recap report for the daily inventory audit update (1656GL). No SUBROUTINE declaration - this is a code fragment EXECUTEd by VB_I.1656. Reads summarized data from WORK1656, looks up GL account descriptions from GL.CHARTS, and prints a GL recap report grouped by company.

Tables Referenced: GL.CHARTS, GL-COMPANY, WORK1656

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_I.1656GL",
    "args":  {
 
             }
}

VB_IMPORTBOM.REV1

Signature: SUBROUTINE IMPORTBOM(CO,TOPPART,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args4
DescriptionBOM hierarchy reader for CAD import integration. Given a top-level part number, recursively explodes the bill of materials through all levels. Returns a flattened array of component parts with level, quantity, unit of measure, description, part type, revision, and manufacturer data from ITEMMANF. Also returns BOM notes. Read-only - does not write any tables.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1TOPPARTinTop-level part number to explode
2DATAoutMulti-valued array of BOM data: level, part, qty, UOM, description, part type, revision, manufacturer info, and BOM notes
3MESSAGEoutError message if company or part not found

Tables Referenced: BMF, BMF.NOTES, GL-COMPANY, ITEMMANF, PRODUCT, PRODUCT.1287

API Call Example:

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

VB_INACT.INVNTY

Signature: SUBROUTINE VB_INACT.INVNTY(DATAIN,DATAOUT,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_INACT.INVNTY

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args3
DescriptionInactive inventory work file builder. Selects all ITEMQTY records with on-hand quantity, traverses INVHIST linked list to find last meaningful activity date (skipping adjustments, transfers, and scrap transactions), then writes detailed lot/bin records to WORK.IAINVNTY.1287 for items inactive before the cut date. Also updates PRODUCT.1287 with last activity date. Uses COMO logging.

Arguments:

IndexNameDirectionDescription
0DATAINinCut date - items with no activity since this date are considered inactive (overridden to DATE() internally)
1DATAOUToutStatus data (set to DATA RECEIVED in test mode)
2MESSAGEoutError/status message

Tables Referenced: BIN, GL-COMPANY, INVHIST, INVXREF, ITEMCA, ITEMQTY, LOTHIST, LOTXREF, POHIST, PRODUCT, PRODUCT.1287, VENDOR

Tables Written: D WORK.IAINVNTY.1287, PRODUCT.1287, WORK.IAINVNTY.1287

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_INACT.INVNTY",
    "args":  {
                 "0":  ""
             }
}

VB_INDSECTORLIST

Signature: SUBROUTINE VB_INDSECTORS(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_INDSECTORLIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionIndustry sector list. Executes a SQL SELECT against INDSECTOR.1287 and returns sector codes and names as a multi-valued array. Read-only lookup.

Arguments:

IndexNameDirectionDescription
0SQLinSQL SELECT statement to filter INDSECTOR.1287 records
1DATAoutMulti-valued array: sector code (attr 1), sector name (attr 2)
2MESSAGEoutError message if file open fails

Tables Referenced: INDSECTOR.1287

API Call Example:

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

VB_INVAUDPOST

Signature: SUBROUTINE INVAUDPOST(INVAUDIT,INVHIST,INVXREF,LOTHIST,OPENWO,TRANSCRT,WOXREF,CO,FILE,PGM,INITS,CRTNO,PARTNO,RDATE,FLD,RQTY,DOCNOS,CODE,COSTPER,LOCS,LOTS,ADJQTYS,CLOTS,CQTYS,OFFLOTS,BINS,BQTYS,MSGFLAG,CEL,BEL,INVAUDPOXREF,INVAUDWOXREF,DUMMY3,DUMMY4,DUMMY5,CUSTDUMMY1,CUSTDUMMY2,CUSTDUMMY3,CUSTDUMMY4,CUSTDUMMY5)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_INVAUDPOST

PropertyValue
Status[+] analyzed
Safety[INT] internal
PatternInternal
Args40
DescriptionInventory audit posting engine. Receives pre-opened file handles and transaction data, then creates INVAUDIT records, updates INVHIST linked lists, writes INVXREF cross-references, posts to TRANSCRT, and maintains WOXREF/INVAUDPOXREF/INVAUDWOXREF cross-reference files. Handles lot-controlled and non-lot parts, bin adjustments, cost calculations, and work order transfers. Returns the assigned audit number via DUMMY3.

Arguments:

IndexNameDirectionDescription
0INVAUDITinPre-opened file handle to INVAUDIT table
1INVHISTinPre-opened file handle to INVHIST table
2INVXREFinPre-opened file handle to INVXREF table
3LOTHISTinPre-opened file handle to LOTHIST table
4OPENWOinPre-opened file handle to OPENWO table
5TRANSCRTinPre-opened file handle to TRANSCRT table
6WOXREFinPre-opened file handle to WOXREF table
7COinCompany number
8FILEinSource file name for audit trail
9PGMinProgram name that initiated the posting
10INITSinUser initials
11CRTNOinTerminal/CRT number
12PARTNOinPart number
13RDATEinTransaction date (internal format)
14FLDinField code array for inventory update type
15RQTYinQuantity array for each transaction
16DOCNOSinDocument number array (PO, WO, etc.)
17CODEinTransaction type code
18COSTPERinCost per unit
19LOCSinLocation codes array
20LOTSinLot numbers array
21ADJQTYSinAdjustment quantities array
22CLOTSinCounter lot numbers for transfers
23CQTYSinCounter quantities for transfers
24OFFLOTSinOffline lot numbers
25BINSinBin numbers array
26BQTYSinBin quantities array
27MSGFLAGoutMessage/error flag returned to caller
28CELinCost element array for lot cost breakdown
29BELinBurden element array for overhead allocation
30INVAUDPOXREFinPre-opened file handle to INVAUDPOXREF table
31INVAUDWOXREFinPre-opened file handle to INVAUDWOXREF table
32DUMMY3outReturns the assigned audit number (AUDNO)
33DUMMY4inReserved for future use
34DUMMY5inReserved for future use
35CUSTDUMMY1inCustomer-reserved dummy parameter 1
36CUSTDUMMY2inCustomer-reserved dummy parameter 2
37CUSTDUMMY3inCustomer-reserved dummy parameter 3
38CUSTDUMMY4inCustomer-reserved dummy parameter 4
39CUSTDUMMY5inCustomer-reserved dummy parameter 5

Tables Referenced: LOTHIST, OPENWO

Tables Written: INVAUDIT, INVAUDPOXREF, INVAUDWOXREF, INVHIST, INVXREF, TRANSCRT, WOXREF

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_INVAUDPOST",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "4":  "",
                 "5":  "",
                 "6":  "",
                 "7":  "",
                 "8":  "",
                 "9":  "",
                 "10":  "",
                 "11":  "",
                 "12":  "",
                 "13":  "",
                 "14":  "",
                 "15":  "",
                 "16":  "",
                 "17":  "",
                 "18":  "",
                 "19":  "",
                 "20":  "",
                 "21":  "",
                 "22":  "",
                 "23":  "",
                 "24":  "",
                 "25":  "",
                 "26":  "",
                 "28":  "",
                 "29":  "",
                 "30":  "",
                 "31":  "",
                 "33":  "",
                 "34":  "",
                 "35":  "",
                 "36":  "",
                 "37":  "",
                 "38":  "",
                 "39":  ""
             }
}

VB_INVINQ.1

Signature: SUBROUTINE VB_INV.INQ.1(PARTNO,LOCATIONS,DATA)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_INVINQ.1

PropertyValue
Status[X] deprecated
Args3
Superseded ByVB_INVINQ.2

Arguments:

IndexNameDirectionDescription
0PARTNOin
1LOCATIONSin
2DATAout

API Call Example:

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

VB_INVINQ.2

Signature: SUBROUTINE VB_INV.INQ.1(PARTNO,LOCATIONS,DATA)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_INVINQ.2

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args3
DescriptionInventory inquiry by location. Given a part number and optional location filter, reads BIN and BINXREF to collect lot/bin/quantity data, then enriches with lot history dates and costs from LOTHIST. Returns product description from PRODUCT. Read-only inquiry with no table writes.

Arguments:

IndexNameDirectionDescription
0PARTNOinPart number (company!partno format)
1LOCATIONSinLocation filter (blank for all locations)
2DATAoutMulti-valued array: lot, bin, qty, date received, job, location, cost elements, part description

Tables Referenced: BIN, BINXREF, LOTHIST, PRODUCT

API Call Example:

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

VB_INVOICELIST.REV1

Signature: SUBROUTINE VB_INVOICELIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args5
Superseded ByVB_INVOICELIST.REV3

Arguments:

IndexNameDirectionDescription
0COin
1IDLISTin
2SQLin
3DATAout
4MESSAGEout

API Call Example:

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

VB_INVOICELIST.REV2

Signature: SUBROUTINE VB_INVOICELIST(CO,IDLIST,SQL,HIST,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args6
Superseded ByVB_INVOICELIST.REV3

Arguments:

IndexNameDirectionDescription
0COin
1IDLISTin
2SQLin
3HISTin
4DATAout
5MESSAGEout

API Call Example:

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

VB_INVOICELIST.REV3

Signature: SUBROUTINE VB_INVOICELIST(INDATA,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionComprehensive invoice list with filtering. Reads INDATA for company, search mode (SQL/IDLIST), and optional filters (date range, customer, job, PO, part, status). Queries INVOICE and joins data from CUSTOMER, EMPLOYEE, JOBMASTER, OPEN.SO.HEAD, PRODUCT, SHIPPER, and other tables. Returns detailed invoice line data including amounts, costs, margins, and shipping info. Read-only.

Arguments:

IndexNameDirectionDescription
0INDATAinInput parameters: company, search mode, SQL/IDLIST, and optional filters (date range, customer, job, PO, part number, status, detail level)
1DATAoutMulti-valued array of invoice data: header and line-level detail with amounts, costs, margins, shipping, and customer info
2MESSAGEoutError message if company validation or file open fails

Tables Referenced: CO.STDS.SO, CUSTOMER, EMPLOYEE, EMPLOYEE.1287, EMPLOYEE.PUBLIC.1287, GL-COMPANY, INVOICE, INVOICE.LINE, INVOICE.SUM, ITEMCA, JOBMASTER, OPEN.SO.HEAD, OPEN.SO.LINES, PRODUCT, SHIPPER, SHIPPER.LINE, SHPVIA, SOLDTO, SOTERMS, TAXCODE, WHSE

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_INVOICELIST.REV3",
    "args":  {
                 "0":  ""
             }
}

VB_ITEMCA.REV1

Signature: SUBROUTINE VB_ITEMCA.REV1(CO,REQTYPE,ITEMCANO,ITEMCAREC,ADDFLAG,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternCRUD
Args6
DescriptionITEMCA (item cost accounting) CRUD. Supports READ, WRITE, and DELETE operations on ITEMCA records. On WRITE, validates the part exists in PRODUCT, applies ADDFLAG logic for new vs existing records, MATWRITEs the ITEMCAREC to ITEMCA, and posts to TRANSREG for audit. On READ, MATREADs and returns the record. On DELETE, removes the record.
Safe REQTYPEREAD
Dangerous REQTYPEWRITE, DELETE

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type: READ, WRITE, or DELETE
2ITEMCANOinItem cost accounting record key (company!partno)
3ITEMCARECinDimensioned array (50) of ITEMCA record fields to be written
4ADDFLAGinAdd flag: 1=new record, 0=existing record update
5MESSAGEoutError/status message

Tables Referenced: GL-COMPANY, ITEMCA, PRODUCT, TRANSREG

Tables Written: ITEMCA, TRANSREG

API Call Example:

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

VB_ITEMMANF.REV1

Signature: SUBROUTINE VB_ITEMMANF(CO,REQTYPE,PARTNO,ITEMREC,ADDFLAG,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternCRUD
Args6
DescriptionITEMMANF (item manufacturer) CRUD with cross-reference maintenance. Supports READ, WRITE, and DELETE on ITEMMANF records. On WRITE, MATWRITEs the ITEMREC, updates PRODXREF/REFXPROD bidirectional cross-references, maintains XREFINDEX, posts to TRANSREG, and logs changes to PART.XREF.AUDIT. On READ, MATREADs and returns the record.
Safe REQTYPEREAD
Dangerous REQTYPEWRITE, DELETE

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type: READ, WRITE, or DELETE
2PARTNOinPart number (company!partno)
3ITEMRECinDimensioned array (75) of ITEMMANF record fields to be written
4ADDFLAGinAdd flag: 1=new record, 0=existing record update
5MESSAGEoutError/status message

Tables Referenced: GL-COMPANY, ITEMMANF, PART.XREF.AUDIT, PRODXREF, REFXPROD, TRANSREG, XREFINDEX

Tables Written: ITEMMANF, PART.XREF.AUDIT, PRODXREF, REFXPROD, TRANSREG, XREFINDEX

API Call Example:

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

VB_ITEMORD.REV1

Signature: SUBROUTINE VB_ITEMORD.REV1(CO,REQTYPE,ITEMORDNO,ITEMORDREC,ADDFLAG,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternCRUD
Args6
DescriptionITEMORD (item ordering parameters) CRUD. Supports READ, WRITE, and DELETE on ITEMORD records. On WRITE, validates the part exists in PRODUCT, applies ADDFLAG logic, MATWRITEs the ITEMORDREC to ITEMORD, and posts to TRANSREG. On READ, MATREADs and returns the record.
Safe REQTYPEREAD
Dangerous REQTYPEWRITE, DELETE

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type: READ, WRITE, or DELETE
2ITEMORDNOinItem ordering record key (company!partno)
3ITEMORDRECinDimensioned array (50) of ITEMORD record fields to be written
4ADDFLAGinAdd flag: 1=new record, 0=existing record update
5MESSAGEoutError/status message

Tables Referenced: GL-COMPANY, ITEMORD, PRODUCT, TRANSREG

Tables Written: ITEMORD, TRANSREG

API Call Example:

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

VB_ITREQUESTLIST.REV1

Signature: SUBROUTINE VB_ITREQUESTLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionIT request list with employee name enrichment. Queries ITREQUESTS.1287 by SQL or IDLIST, joins with EMPLOYEE.PUBLIC.1287 for requester/assignee names and ITREQUESTTYPE.1287 for request type descriptions. Returns request details including status, priority, dates, and resolution info.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinValue-marked list of specific IT request IDs (alternative to SQL)
2SQLinSQL SELECT statement to filter ITREQUESTS.1287
3DATAoutMulti-valued array of IT request data: ID, type, description, requester, assignee, status, priority, dates
4MESSAGEoutError message if file open fails

Tables Referenced: EMPLOYEE.PUBLIC.1287, ITREQUESTS.1287, ITREQUESTTYPE.1287

API Call Example:

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

VB_JOBBOM.REV1

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

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args0
DescriptionCreates job BOM and JOBXREF for all projects by exploding BOM hierarchy, collecting part info (qty, cost, lead times), and writing results to JOBBOM.1287. Also deletes empty BOM notes.

Tables Written: JOBBOM.1287, BMF.NOTES

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_JOBBOM.REV1",
    "args":  {
 
             }
}

VB_JOBLIST

Signature: SUBROUTINE VB_JOBLIST(DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_JOBLIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args2
DescriptionReturns a list of jobs from JOBMASTER (excluding type 40), optionally filtered by customer number. Returns job number, description, and price.

Arguments:

IndexNameDirectionDescription
0DATAinoutInput: customer number search criteria; Output: array of job number, description, price
1MESSAGEoutError message if any

API Call Example:

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

VB_JOBLIST.REV1

Signature: SUBROUTINE VB_JOBLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionReturns a list of projects/jobs from JOBMASTER by SQL query or ID list. Returns job number, description, and price.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinOptional list of job IDs to retrieve
2SQLinSQL SELECT statement to execute against JOBMASTER
3DATAoutArray of job number, description, price
4MESSAGEoutError message if any

API Call Example:

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

VB_JOBLIST2

Signature: SUBROUTINE VB_JOBLIST(DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_JOBLIST2

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args2
DescriptionReturns a list of jobs from JOBMASTER by executing a SQL command passed via DATA. Returns job number, description, and price.

Arguments:

IndexNameDirectionDescription
0DATAinoutInput: SQL command to execute; Output: array of job number, description, price
1MESSAGEoutError message if any

API Call Example:

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

VB_LABORHISTLIST.REV1

Signature: SUBROUTINE VB_LABORHISTLIST(CO,REQ.BY,RPT.LST,WE.DATE,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternList
Args6
DescriptionReturns labor history timesheet data for a pay period. Calculates regular, OT, DT, sick, holiday, vacation hours with salary/hourly/exempt rules. Includes employees with no timesheets and contract vendor info.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQ.BYinEmployee number of the requester
2RPT.LSTinReport-to list filter, or ‘ALL’ for all employees
3WE.DATEinWeek-ending date for the pay period (MM/DD/YY)
4DATAoutArray with dept, empno, name, card details, hours breakdown (reg/OT/DT/sick/hol/vac/misc/total), pay type, shift, exempt status, contract info, errors
5MESSAGEoutError message if any

Tables Written: HOLD

API Call Example:

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

VB_LDS.INDEX.REV1

Signature: SUBROUTINE VB_LDS.INDEX.REV1(INDATA,OUTDATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_LDS.INDEX.REV1

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args3
DescriptionDisplays LDS (Facility/Assembly/Module/Physical) portion of a BOM hierarchy for a given part. Returns BOM level, WBS, part number, description, MRP, UM, quantities, and group tech classification.

Arguments:

IndexNameDirectionDescription
0INDATAinInput: INDATA<1>=company number, INDATA<2>=part number
1OUTDATAoutBOM hierarchy array with level, WBS, part, desc, MRP, UM, qty, group tech
2MESSAGEoutError message if any

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_LDS.INDEX.REV1",
    "args":  {
                 "0":  ""
             }
}

VB_LDSINDX

Signature: SUBROUTINE VB_LDSINDX(JOBNO,DATA)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_LDSINDX

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args2
DescriptionReturns the LDS index for a job by navigating facility/assembly/module/physical hierarchy from JOBMASTER. Returns product number, part number, quantity, description, and LDS position for each component.

Arguments:

IndexNameDirectionDescription
0JOBNOinJob number to look up
1DATAoutArray with product number, part number, quantity, description, LDS position

API Call Example:

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

VB_LOAD.SIM

Signature: SUBROUTINE VB_LOAD.SIM(INDATA,OUTDATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_LOAD.SIM

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args3
DescriptionLoads simulated work orders for a given job from OPENWO.SIM. Returns work order number, part number, and due date for each simulated order.

Arguments:

IndexNameDirectionDescription
0INDATAinInput: INDATA<1>=company number, INDATA<2>=job number
1OUTDATAoutArray of WO number, part number, due date
2MESSAGEoutError message if any

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_LOAD.SIM",
    "args":  {
                 "0":  ""
             }
}

VB_MACHPROCESSTYPELIST.REV1

Signature: SUBROUTINE VB_MACHPROCESSTYPELIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionReturns a list of machine process types from MACHPROCESSTYPE.1287 by SQL query or ID list. Returns process type code and name.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinOptional list of machine process type IDs to retrieve
2SQLinSQL SELECT statement to execute against MACHPROCESSTYPE.1287
3DATAoutArray of machine process type code and name
4MESSAGEoutError message if any

API Call Example:

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

VB_MACHTYPELIST.REV1

Signature: SUBROUTINE VB_MACHTYPELIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionReturns a list of machine types from MACHTYPE.1287 by SQL query or ID list. Returns machine type code and name.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinOptional list of machine type IDs to retrieve
2SQLinSQL SELECT statement to execute against MACHTYPE.1287
3DATAoutArray of machine type code and name
4MESSAGEoutError message if any

API Call Example:

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

VB_MAILCODELIST.REV1

Signature: SUBROUTINE VB_MAILCODELIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionReturns a list of contact mail codes from CONTACT.MAILCODE.1287 by SQL query or ID list. Returns mail code number and name.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinOptional list of mail code IDs to retrieve
2SQLinSQL SELECT statement to execute against CONTACT.MAILCODE.1287
3DATAoutArray of mail code number and name
4MESSAGEoutError message if any

API Call Example:

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

VB_MESPROGLIST.REV1

Signature: SUBROUTINE VB_MESPROGLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionReturns a list of MES programs from MESPROGRAMS.1287 by SQL query or ID list. Returns program number, name, and broadcast types.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinOptional list of MES program IDs to retrieve
2SQLinSQL SELECT statement to execute against MESPROGRAMS.1287
3DATAoutArray of program number, name, broadcast types
4MESSAGEoutError message if any

API Call Example:

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

VB_MYNEWFILES

Signature: SUBROUTINE VB_MYNEWFILES(INDATA,OUTDATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_MYNEWFILES

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternUtility
Args3
DescriptionCompares a list of local PDM file names against PDM.1287 records to identify new files not yet in the system. Returns the difference list with description, MRP, and GT code for each.

Arguments:

IndexNameDirectionDescription
0INDATAinFM-delimited list of local file names with CO! prefix (e.g. 1!000007.SLDPRT)
1OUTDATAoutArray of new file names not in PDM.1287, with description, MRP, and GT code
2MESSAGEoutError message if any

API Call Example:

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

VB_NCNCHGLIST

Signature: SUBROUTINE VB_NCNCHGLIST(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_NCNCHGLIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionReturns a list of NCN (Non-Conformance Notice) change records from NCN.CHG.1287 by SQL query. Returns NCN number, part number, part description, and reason.

Arguments:

IndexNameDirectionDescription
0SQLinSQL SELECT statement to execute against NCN.CHG.1287
1DATAoutArray of NCN number, part number, part description, reason
2MESSAGEoutError message if any

API Call Example:

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

VB_NCNLIST

Signature: SUBROUTINE VB_NCNLIST(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_NCNLIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionReturns a list of NCN records from NCN.CHG.1287 by SQL query. Returns NCN number, part number, completed status, and reason.

Arguments:

IndexNameDirectionDescription
0SQLinSQL SELECT statement to execute against NCN.CHG.1287
1DATAoutArray of NCN number, part number, completed status, reason
2MESSAGEoutError message if any

API Call Example:

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

VB_OPENORDLIST

Signature: SUBROUTINE VB_OPENORDLIST(DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_OPENORDLIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args2
DescriptionReturns a list of open sales orders (non-purchase) from OPEN.ORD.HEAD, optionally filtered by customer number. Returns SO number, date, PO, value, ship value, and type (Spare/Warranty).

Arguments:

IndexNameDirectionDescription
0DATAinoutInput: customer number search criteria; Output: array of SO number, date, PO, value, ship value, type
1MESSAGEoutError message if any

API Call Example:

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

VB_PARTINFO.REV1

Signature: SUBROUTINE VB_PARTINFO(CO,REQTYPE,INDATA,OUTDATA,MSG)

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

PropertyValue
Status[X] deprecated
Args5
Superseded ByVB_PARTINFO.REV2

Arguments:

IndexNameDirectionDescription
0COin
1REQTYPEin
2INDATAout
3OUTDATAout
4MSGout

API Call Example:

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

VB_PARTINFO.REV2

Signature: SUBROUTINE VB_PARTINFO(CO,INDATA,OUTDATA,MSG)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args4
DescriptionReturns detailed part information for a given part number including description, MRP, UM, last cost, on-hand quantity, last activity date, lot control flag, and reserved bin.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1INDATAinINDATA<1>=part number to look up
2OUTDATAoutPart info: partno, desc, desc2, MRP, UM, last cost, last activity date, on-hand qty, lot control flag, reserved bin
3MSGoutError message if part not found

API Call Example:

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

VB_PARTPHOTO.REV1

Signature: SUBROUTINE VB_PARTPHOTO(CO,REQTYPE,PARTPHOTO,P1287REC,ADDFLAG,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternCRUD
Args6
DescriptionSaves, updates, or deletes part photo records in PART.PHOTOS.1287 based on REQTYPE. Supports audit trail logging via TRANSREG.
Dangerous REQTYPEDELETE

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type: ‘DELETE’ to delete, otherwise add/update
2PARTPHOTOinPart photo record ID
3P1287RECinPart photo record data to write (dynamic array)
4ADDFLAGinTrue if adding a new record, false if updating
5MESSAGEoutResult message (DELETE SUCCEEDED or WRITE SUCCEEDED)

Tables Written: PART.PHOTOS.1287

API Call Example:

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

VB_PARTPHOTOLIST.REV1

Signature: SUBROUTINE VB_PARTPHOTOLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionReturns a list of part photos from PART.PHOTOS.1287 by SQL query or ID list. Returns photo number, filename, description, part type, project number, and SPN.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinOptional list of part photo IDs to retrieve
2SQLinSQL SELECT statement to execute against PART.PHOTOS.1287
3DATAoutArray of photo number, filename, description, type description, project number, SPN
4MESSAGEoutError message if any

API Call Example:

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

VB_PARTTYPELIST

Signature: SUBROUTINE VB_PARTTYPELIST(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_PARTTYPELIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionPart type list (simple version). Executes a SQL SELECT against PARTTYPE.1287 and returns part type codes and names as a multi-valued array. Names are title-cased via MCT conversion. Read-only lookup.

Arguments:

IndexNameDirectionDescription
0SQLinSQL SELECT statement to filter PARTTYPE.1287 records
1DATAoutMulti-valued array: part type code (attr 1), part type name (attr 2)
2MESSAGEoutError message if file open fails

Tables Referenced: PARTTYPE.1287

API Call Example:

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

VB_PARTTYPELIST.REV1

Signature: SUBROUTINE VB_PARTTYPELIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionPart type list with industry sector enrichment (REV1). Queries PARTTYPE.1287 by SQL or IDLIST, joins with INDSECTOR.1287 for industry sector names. Returns part type code, name, and associated industry sector. Read-only lookup.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinValue-marked list of specific part type IDs (alternative to SQL)
2SQLinSQL SELECT statement to filter PARTTYPE.1287
3DATAoutMulti-valued array: part type code, name, industry sector code and name
4MESSAGEoutError message if file open fails

Tables Referenced: INDSECTOR.1287, PARTTYPE.1287

API Call Example:

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

VB_PAYMENTS.REV1

Signature: SUBROUTINE VB_PAYMENTS(CO,REQTYPE,MSNO,MSREC,ADDFLAG,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternCRUD
Args6
DescriptionTask/payment milestone CRUD with password-protected DELETE. Supports READ, WRITE, and DELETE on TASK.1287 records. On WRITE, validates the record and MATWRITEs MSREC to TASK.1287, posting to TRANSREG. DELETE requires password verification against PASSWORDS table. On READ, MATREADs and returns the record.
Safe REQTYPEREAD
Dangerous REQTYPEDELETE

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type: READ, WRITE, or DELETE
2MSNOinTask/milestone record key
3MSRECinDimensioned array of task/payment record fields to be written
4ADDFLAGinAdd flag: 1=new record, 0=existing record update
5MESSAGEoutError/status message

Tables Referenced: GL-COMPANY, PASSWORDS, TASK.1287, TRANSREG

Tables Written: TASK.1287, TRANSREG

API Call Example:

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

VB_PAYREGLIST.REV1

Signature: SUBROUTINE VB_PAYREGLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionPayroll register list with hours adjustment logic. Queries PAYREG by SQL or IDLIST, joins with EMPLOYEE, EMPLOYEE.1287, and EMPLOYEE.PUBLIC.1287 for employee details. Adjusts regular/overtime hours based on pay type (deducts overtime from regular for hourly employees). Returns comprehensive payroll data including hours, rates, gross pay, and employee info.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinValue-marked list of specific payroll register IDs (alternative to SQL)
2SQLinSQL SELECT statement to filter PAYREG records
3DATAoutMulti-valued array of payroll data: employee info, hours (regular/OT/DT/holiday), rates, gross pay, check date
4MESSAGEoutError message if file open fails

Tables Referenced: EMPLOYEE, EMPLOYEE.1287, EMPLOYEE.PUBLIC.1287, PAYREG

API Call Example:

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

VB_PDMXREF

Signature: SUBROUTINE VB_PDMXREF(INREC,OUTREC,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_PDMXREF

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternCRUD
Args3
DescriptionPDM (Product Data Management) cross-reference maintenance. Reads the input record (INREC) containing employee ID, part number, and PDM file path, validates against EMPLOYEE.ACCESS.1287 and PDM.1287, then writes or updates the cross-reference in PDMXREF.1287. Returns the current PDMXREF record in OUTREC. Also handles DELETE requests when INREC<4> is set.

Arguments:

IndexNameDirectionDescription
0INRECinInput record: employee ID (attr 1), part number (attr 2), PDM file path (attr 3), delete flag (attr 4)
1OUTRECoutCurrent PDMXREF.1287 record after operation
2MESSAGEoutError/status message

Tables Referenced: EMPLOYEE.ACCESS.1287, PDM.1287, PDMXREF.1287

Tables Written: PDMXREF.1287

API Call Example:

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

VB_PHANTOM

Signature: SUBROUTINE VB_PHANTOM(PROGNAME)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_PHANTOM

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args1
DescriptionRuns a PHANTOM process by name. On weekends (Saturday/Sunday), clears the MRP.INCR.1287 file before executing the named program.

Arguments:

IndexNameDirectionDescription
0PROGNAMEinName of the program to run as a PHANTOM process

Tables Referenced: MRP.INCR.1287

Tables Written: MRP.INCR.1287

API Call Example:

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

VB_PHANTOM.REV2

Signature: SUBROUTINE VB_PHANTOM.REV2(PROGNAME)

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

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args1
DescriptionRuns the full MRP batch sequence as a PHANTOM process when PROGNAME is MRP. Executes MRP, component availability, grouper, planned orders, capacity requirements, and MRP report generation in order. Clears MRP.INCR.1287 on weekends.

Arguments:

IndexNameDirectionDescription
0PROGNAMEinName of program to run; only MRP triggers the full batch sequence

Tables Referenced: MRP.INCR.1287

Tables Written: MRP.INCR.1287

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_PHANTOM.REV2",
    "args":  {
                 "0":  ""
             }
}

VB_PLANORD.REV1

Signature: SUBROUTINE VB_PLANORD.REV1(CO,REQTYPE,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args4
Superseded ByVB_PLANORD.REV6

Arguments:

IndexNameDirectionDescription
0COin
1REQTYPEin
2DATAout
3MESSAGEout

API Call Example:

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

VB_PLANORD.REV2

Signature: SUBROUTINE VB_PLANORD.REV2(CO,REQTYPE,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args4
Superseded ByVB_PLANORD.REV6

Arguments:

IndexNameDirectionDescription
0COin
1REQTYPEin
2DATAout
3MESSAGEout

API Call Example:

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

VB_PLANORD.REV3

Signature: SUBROUTINE VB_PLANORD.REV3(CO,REQTYPE,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args4
Superseded ByVB_PLANORD.REV6

Arguments:

IndexNameDirectionDescription
0COin
1REQTYPEin
2DATAout
3MESSAGEout

API Call Example:

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

VB_PLANORD.REV4

Signature: SUBROUTINE VB_PLANORD.REV4(CO,REQTYPE,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args4
Superseded ByVB_PLANORD.REV6

Arguments:

IndexNameDirectionDescription
0COin
1REQTYPEin
2DATAout
3MESSAGEout

API Call Example:

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

VB_PLANORD.REV5

Signature: SUBROUTINE VB_PLANORD.REV5(CO,REQTYPE,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_PLANORD.REV5

PropertyValue
Status[X] deprecated
Args4
Superseded ByVB_PLANORD.REV6

Arguments:

IndexNameDirectionDescription
0COin
1REQTYPEin
2DATAout
3MESSAGEout

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_PLANORD.REV5",
    "args":  {
                 "0":  "",
                 "1":  ""
             }
}

VB_PLANORD.REV6

Signature: SUBROUTINE VB_PLANORD.REV6(CO,REQTYPE,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_PLANORD.REV6

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternProcess
Args4
DescriptionGenerates or retrieves a planned order report. When REQTYPE is a date string, reads a previously saved report from PLANORD.1287. When REQTYPE is ALL or empty, generates a new report by selecting REQ records, looking up product/routing/supplier data from 20+ tables, and writing results to PLANORD.1287.
Safe REQTYPE(date string)
Dangerous REQTYPEALL,

Arguments:

IndexNameDirectionDescription
0COinCompany number (hardcoded to 1 internally)
1REQTYPEinoutRequest type: date string to read saved report, ALL or empty to generate new report
2DATAoutPlanned order report data array
3MESSAGEoutError or status message

Tables Referenced: ALTROUTE.HEAD, ALTROUTE.LINE, BUYER.XREF.1287, CO.STDS.COST, CO.STDS.MRP, CO.STDS.SF, ITEMCA, ITEMMANF, ITEMORD, ITEMQTY, JOBMASTER, OPEN.PO.HEAD, OPEN.PO.LINES, OPENWO, PLANORD.1287, PRODUCT, PRODXREF, REQ, SF.CAL, SF.CAL.WOCE, SROUTE.HEAD, SROUTE.LINE, VENDOR, WOCE

Tables Written: PLANORD.1287

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_PLANORD.REV6",
    "args":  {
                 "0":  ""
             }
}

VB_PLANORDLIST.REV1

Signature: SUBROUTINE VB_PLANORDLIST.REV1(DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args2
DescriptionLists the dates of previously saved planned order reports by selecting record IDs from PLANORD.1287 and returning them as a delimited list.

Arguments:

IndexNameDirectionDescription
0DATAoutList of saved planned order report date IDs
1MESSAGEoutError or status message

Tables Referenced: PLANORD.1287

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_PLANORDLIST.REV1",
    "args":  {
 
             }
}

VB_POCHECKLOT.REV1

Signature: SUBROUTINE VB_POCHECKLOT.REV1(CO,RECNO,PONO,LINENO,PARTNO,OKFLAG,MSG)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args7
DescriptionValidates a PO receiver lot number by checking it against DTSD, LOTHIST, POHIST, and PO.REC tables. Returns an OK flag and message indicating whether the lot already exists. Uses READU for existence checking but releases locks.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1PARTNOinPart number
2PESSIONinPO number
3PESSION2inPO line number
4RECNOinReceiver lot number to validate
5OKFLAGoutOK flag: 1 if lot is valid/unique, 0 if already exists
6MSGoutError or validation message

Tables Referenced: DTSD, LOTHIST, PO.REC, POHIST

API Call Example:

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

VB_POF.REV1

Signature: SUBROUTINE VB_POF.REV1(ID,REQTYPE,AUTHORIZED,HEADDATA,LINEDATA,LINENOTEDATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternCRUD
Args8
DescriptionReads or writes planned order form data to/from HOLD file. READ retrieves saved PO form data. WRITE saves PO header, line, and note data. When AUTHORIZED is TRUE during a read, deletes the record after reading.
Safe REQTYPEREAD
Dangerous REQTYPEWRITE

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type: READ to retrieve, WRITE to save
2PESSIONinPO form ID (used as key for HOLD record)
3HEADDATAinoutPO header data array
4LINEDATAinoutPO line data array
5LINENOTEDATAinoutPO line note data array
6MESSAGEoutError or status message
7AUTHORIZEDinAuthorization flag: TRUE allows delete after read

Tables Referenced: HOLD

Tables Written: HOLD

API Call Example:

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

VB_POFLIST.REV1

Signature: SUBROUTINE VB_POFLIST.REV1(DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args2
DescriptionLists saved purchase order form IDs from the HOLD file by selecting records matching the pattern POF* and returning them as a delimited list.

Arguments:

IndexNameDirectionDescription
0DATAoutList of saved POF record IDs from HOLD
1MESSAGEoutError or status message

Tables Referenced: HOLD

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_POFLIST.REV1",
    "args":  {
 
             }
}

VB_POHIST.REV1

Signature: SUBROUTINE VB_POHIST(CO,REQTYPE,INDATA,OUTDATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args5
Superseded ByVB_POHIST.REV3

Arguments:

IndexNameDirectionDescription
0COin
1REQTYPEin
2INDATAout
3OUTDATAout
4MESSAGEout

API Call Example:

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

VB_POHIST.REV2

Signature: SUBROUTINE VB_POHIST(CO,REQTYPE,INDATA,OUTDATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args5
Superseded ByVB_POHIST.REV3

Arguments:

IndexNameDirectionDescription
0COin
1REQTYPEin
2INDATAout
3OUTDATAout
4MESSAGEout

API Call Example:

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

VB_POHIST.REV3

Signature: SUBROUTINE VB_POHIST(CO,REQTYPE,INDATA,OUTDATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args5
DescriptionMulti-mode purchase order history inquiry. Supports REQTYPE modes: UNCONFIRMED, APHIST, POHIST-PART, INVHIST, and LOTHIST. Reads from 28+ tables. Returns formatted result data.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type: UNCONFIRMED, APHIST, POHIST-PART, INVHIST, or LOTHIST
2INDATAinInput criteria (part number, PO number, or filter values depending on REQTYPE)
3OUTDATAoutResult data array formatted per REQTYPE
4MESSAGEoutError or status message

Tables Referenced: AP.HEAD, AP.LINE, CATEGORY, CO.STDS.COST, DTSD, FOB, GL-COMPANY, INSPECTION, INVAUDIT, ITEMCA, ITEMMANF, ITEMORD, ITEMQTY, JOBMASTER, LOTHIST, MFG.1287, OPEN.PO.CHRGS, OPEN.PO.HEAD, OPEN.PO.HEAD.1287, OPEN.PO.LINES, OPEN.PO.LINES.1287, OPEN.PO.NOTES, PO.REC, POHIST, PRODUCT, PRODXREF, STOCK.PAR, TERMS, VENDOR, VENDOR.1287

API Call Example:

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

VB_POLINE.NOTE

Signature: SUBROUTINE VB_POLINE.NOTE(INREC, OUTREC, MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_POLINE.NOTE

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternCRUD
Args3
DescriptionReads or saves PO line editor data. TYPE R reads line data from OPEN.PO.LINES and related tables. TYPE S writes updated line and note data to OPEN.PO.LINES, OPEN.PO.LINES.1287, and VENDOR.1287.
Safe REQTYPER
Dangerous REQTYPES

Arguments:

IndexNameDirectionDescription
0INRECinPipe-delimited input: TYPE
1OUTRECoutOutput data: line details on read, status on save
2MESSAGEoutError or status message

Tables Referenced: CATEGORY, CO.STDS.COST, GL-COMPANY, ITEMCA, ITEMMANF, MFG.1287, OPEN.PO.HEAD, OPEN.PO.LINES, OPEN.PO.LINES.1287, OPEN.PO.NOTES, PRODUCT, VENDOR.1287

Tables Written: OPEN.PO.LINES, OPEN.PO.LINES.1287, OPEN.PO.NOTES, VENDOR.1287

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_POLINE.NOTE",
    "args":  {
                 "0":  ""
             }
}

VB_POMAINT.REV1

Signature: SUBROUTINE VB_POMAINT.REV1(CO,PONO,HEADDATA,HEADNOTEDATA,LINEDATA,LINENOTEDATA,MSG)

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

PropertyValue
Status[X] deprecated
Args7
Superseded ByVB_POMAINT.REV3

Arguments:

IndexNameDirectionDescription
0COin
1PONOin
2HEADDATAout
3HEADNOTEDATAout
4LINEDATAout
5LINENOTEDATAout
6MSGout

API Call Example:

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

VB_POMAINT.REV2

Signature: SUBROUTINE VB_POMAINT.REV2(CO,PONO,HEADDATA,HEADNOTEDATA,LINEDATA,LINENOTEDATA,MSG)

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

PropertyValue
Status[X] deprecated
Args7
Superseded ByVB_POMAINT.REV3

Arguments:

IndexNameDirectionDescription
0COin
1PONOin
2HEADDATAout
3HEADNOTEDATAout
4LINEDATAout
5LINENOTEDATAout
6MSGout

API Call Example:

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

VB_POMAINT.REV3

Signature: SUBROUTINE VB_POMAINT.REV3(CO,PONO,HEADDATA,HEADNOTEDATA,LINEDATA,LINENOTEDATA,MSG)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args7
DescriptionReads a purchase order and returns all header and line details. Reads the PO header from OPEN.PO.HEAD, vendor info from VENDOR, and iterates through all PO lines reading from OPEN.PO.LINES and related tables. Returns comprehensive PO data including ship-to, terms, stock paragraphs, and line-level part/cost/schedule details.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1PONOinPurchase order number
2HEADDATAoutPO header data array (vendor, ship-to, terms, dates, etc.)
3HEADNOTEDATAoutPO header notes data
4LINEDATAoutPO line data array (parts, quantities, costs, schedules)
5LINENOTEDATAoutPO line notes data array
6MSGoutError or status message

Tables Referenced: CATEGORY, CO.STDS.COST, FOB, GL-COMPANY, ITEMMANF, ITEMORD, JOBMASTER, MFG.1287, OPEN.PO.HEAD, OPEN.PO.HEAD.1287, OPEN.PO.HEAD.NOTES, OPEN.PO.LINES, OPEN.PO.LINES.1287, OPEN.PO.NOTES, OPEN.RFQ.HEAD.1287, OPENWO, PRODUCT, STOCK.PAR, TERMS, VENDOR, VENDOR.1287

API Call Example:

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

VB_POMAINT2.REV1

Signature: SUBROUTINE VB_POMAINT2(CO,REQTYPE,INDATA,OUTDATA,MSG)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args5
DescriptionValidates purchase order field entries by request type. Supports VENDNO, STKPAR, TERMS, PARTNO, FOB, and GLCATEGORY modes. Returns validated data with descriptions.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type: VENDNO, STKPAR, TERMS, PARTNO, FOB, or GLCATEGORY
2INDATAinInput value to validate (vendor number, part number, etc.)
3OUTDATAoutValidated output data with descriptions and related info
4MSGoutError or status message

Tables Referenced: CATEGORY, FOB, ITEMCA, ITEMMANF, PRODUCT, STOCK.PAR, TERMS, VENDOR, VENDOR.1287

API Call Example:

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

VB_POMAINTWRITE.REV1

Signature: SUBROUTINE VB_POMAINTWRITE.REV1(CO,PONO,REQTYPE,HEADDATA,HEADNOTEDATA,LINEDATA,LINENOTEDATA,LINECHARGEDATA,MSG)

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

PropertyValue
Status[X] deprecated
Args9
Superseded ByVB_POMAINTWRITE.REV5

Arguments:

IndexNameDirectionDescription
0COin
1PONOin
2REQTYPEin
3HEADDATAout
4HEADNOTEDATAout
5LINEDATAout
6LINENOTEDATAout
7LINECHARGEDATAout
8MSGout

API Call Example:

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

VB_POMAINTWRITE.REV2

Signature: SUBROUTINE VB_POMAINTWRITE.REV2(CO,PONO,REQTYPE,HEADDATA,HEADNOTEDATA,LINEDATA,LINENOTEDATA,LINECHARGEDATA,MSG)

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

PropertyValue
Status[X] deprecated
Args9
Superseded ByVB_POMAINTWRITE.REV5

Arguments:

IndexNameDirectionDescription
0COin
1PONOin
2REQTYPEin
3HEADDATAout
4HEADNOTEDATAout
5LINEDATAout
6LINENOTEDATAout
7LINECHARGEDATAout
8MSGout

API Call Example:

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

VB_POMAINTWRITE.REV4

Signature: SUBROUTINE VB_POMAINTWRITE.REV4(CO,PONO,REQTYPE,HEADDATA,HEADNOTEDATA,LINEDATA,LINENOTEDATA,LINECHARGEDATA,MSG)

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

PropertyValue
Status[X] deprecated
Args9
Superseded ByVB_POMAINTWRITE.REV5

Arguments:

IndexNameDirectionDescription
0COin
1PONOin
2REQTYPEin
3HEADDATAout
4HEADNOTEDATAout
5LINEDATAout
6LINENOTEDATAout
7LINECHARGEDATAout
8MSGout

API Call Example:

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

VB_POMAINTWRITE.REV5

Signature: SUBROUTINE VB_POMAINTWRITE.REV5(CO,PONO,REQTYPE,HEADDATA,HEADNOTEDATA,LINEDATA,LINENOTEDATA,LINECHARGEDATA,MSG)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_POMAINTWRITE.REV5

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternCRUD
Args9
DescriptionCreates or updates purchase orders. Supports NEWPO, OLDPO, OLDPO-HEADER, and OLDPO-DELETE modes. Writes to OPEN.PO.HEAD, OPEN.PO.LINES, OPEN.PO.NOTES, and 13+ related tables. Manages PO number allocation, vendor cross-references, transaction registers, and GL postings.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type: NEWPO, OLDPO, OLDPO-HEADER, or OLDPO-DELETE
2PESSIONinoutPO number (input for updates, output with new number for NEWPO)
3HEADDATAinPO header data array
4HEADNOTEDATAinPO header notes data
5LINEDATAinPO line data array
6LINENOTEDATAinPO line notes data array
7AUTHORIZEDinUser initials for audit trail
8MSGoutError or status message

Tables Referenced: BUYER.XREF.1287, CATEGORY, CO.STDS.COST, CO.STDS.MRP, FOB, GL-COMPANY, INSPECTION, INVAUDIT, ITEMCA, ITEMMANF, ITEMORD, ITEMQTY, JOBMASTER, MFG.1287, OPEN.PO.CHRGS, OPEN.PO.HEAD, OPEN.PO.HEAD.1287, OPEN.PO.HEAD.NOTES, OPEN.PO.LINES, OPEN.PO.LINES.1287, OPEN.PO.NOTES, POPART.XREF, PRODUCT, PRODXREF, REQ, STOCK.PAR, TERMS, TRANSREG, VENDOR, VENDOR.1287, VENDXREF

Tables Written: CO.STDS.COST, INVAUDIT, OPEN.PO.HEAD, OPEN.PO.HEAD.1287, OPEN.PO.HEAD.NOTES, OPEN.PO.LINES, OPEN.PO.LINES.1287, OPEN.PO.NOTES, POPART.XREF, PWD.AUDIT, REQ, TRANSREG, VENDOR.1287, VENDXREF

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_POMAINTWRITE.REV5",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "3":  "",
                 "4":  "",
                 "5":  "",
                 "6":  "",
                 "7":  ""
             }
}

VB_PORECEIPT.REV1

Signature: SUBROUTINE VB_PORECEIPT.REV1(CO,LCODE,PONO,DATE.REC,VENO,LINEDATA,ERRMSG)

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

PropertyValue
Status[X] deprecated
Args7
Superseded ByVB_PORECEIPT.REV2

Arguments:

IndexNameDirectionDescription
0COin
1LCODEin
2PONOin
3DATE.RECout
4VENOin
5LINEDATAout
6ERRMSGout

API Call Example:

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

VB_PORECEIPT.REV2

Signature: SUBROUTINE VB_PORECEIPT(HDATA,LINEDATA,RECNO,ERRMSG)

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

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args5
DescriptionProcesses purchase order receipts. Validates receipt data against the PO, updates received quantities on PO lines, writes receiver records to PO.REC, creates inventory audit trail entries in INVAUDIT, and updates item quantity records in ITEMQTY. Handles lot tracking and FIFO cost updates.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1HDATAinReceipt header data (PO number, vendor, dates)
2RECNOoutGenerated receiver number
3ERRMSGoutError message if validation or processing fails
4LINEDATAinReceipt line data array (parts, quantities, lots)

Tables Referenced: CO.STDS.COST, CO.STDS.MRP, INSPECTION, ITEMCA, ITEMORD, ITEMQTY, LOTHIST, OPEN.PO.HEAD, OPEN.PO.LINES, OPEN.PO.LINES.1287, PO.REC, PRODUCT

Tables Written: CO.STDS.COST, INVAUDIT, ITEMQTY, LOTHIST, OPEN.PO.LINES, PO.REC

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_PORECEIPT.REV2",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "4":  ""
             }
}

VB_PROCESSTYPELIST

Signature: SUBROUTINE VB_PROCESSTYPELIST(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_PROCESSTYPELIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionLists all process types by selecting records from PROCESSTYPE.1287 and returning their IDs and descriptions as a delimited list.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1DATAoutList of process type IDs and descriptions
2MESSAGEoutError or status message

Tables Referenced: PROCESSTYPE.1287

API Call Example:

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

VB_PRODUCTCLASS_LIST

Signature: SUBROUTINE VB_PRODUCT_LIST(DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_PRODUCTCLASS_LIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args2
DescriptionLists non-obsolete products with their class and manufacturer data. Selects from PRODUCT where MRP is not O (obsolete), joins with ITEMMANF for manufacturer info.

Arguments:

IndexNameDirectionDescription
0DATAoutProduct list data with part, description, class, and manufacturer
1MESSAGEoutError or status message

Tables Referenced: ITEMMANF, PRODUCT

API Call Example:

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

VB_PRODUCTCLASSLIST.REV1

Signature: SUBROUTINE VB_PRODUCTCLASSLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionLists product classes from PRODUCT.CLASS.1287. Selects all records and returns class IDs and descriptions as a delimited list.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type (unused)
2INDATAinInput data (unused)
3DATAoutList of product class IDs and descriptions
4MESSAGEoutError or status message

Tables Referenced: PRODUCT.CLASS.1287

API Call Example:

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

VB_PRODUCTLDS.REV1

Signature: SUBROUTINE VB_PRODUCTLDS(CO,REQTYPE,PRODNO,P1287REC,ADDFLAG,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternCRUD
Args6
DescriptionCRUD operations for product LDS (Lot/Date/Serial) records in PRODUCT.LDS.1287. Supports READ, WRITE, and DELETE modes. WRITE creates/updates with audit trail. DELETE soft-deletes by setting delete flag. The P1287REC argument contains the record data that gets written via MATWRITE.
Safe REQTYPEREAD
Dangerous REQTYPEWRITE, DELETE

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type: READ, WRITE, or DELETE
2INDATAinProduct LDS record ID
3P1287RECinRecord data array to write (used for WRITE/DELETE)
4AUTHORIZEDinUser initials for audit trail
5MESSAGEoutError or status message

Tables Referenced: PRODUCT.LDS.1287

Tables Written: PRODUCT.LDS.1287

API Call Example:

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

VB_PRODUCTLIST.REV1

Signature: SUBROUTINE VB_PRODUCTLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionLists product LDS records from PRODUCT.LDS.1287. Selects non-deleted records and returns their IDs and key fields as a delimited list.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type (unused)
2INDATAinInput data (unused)
3DATAoutList of product LDS record IDs and data
4MESSAGEoutError or status message

Tables Referenced: PRODUCT.LDS.1287

API Call Example:

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

VB_PRODUCTS.REV1

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

PropertyValue
Status[+] analyzed
Safety[INT] internal
PatternInternal
Args0
DescriptionInternal batch utility that populates PRODUCT.LDS.1287 from PRODUCT data. No SUBROUTINE declaration; not callable via API. Iterates through products and writes LDS records.

Tables Referenced: PRODUCT, PRODUCT.LDS.1287

Tables Written: PRODUCT.LDS.1287

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_PRODUCTS.REV1",
    "args":  {
 
             }
}

VB_PROJECTLIST

Signature: SUBROUTINE VB_JOBLIST(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_PROJECTLIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionLists active projects/jobs from JOBMASTER. Selects records where status indicates active, and returns job numbers, descriptions, and customer information as a delimited list.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1DATAoutList of project/job numbers with descriptions
2MESSAGEoutError or status message

Tables Referenced: JOBMASTER

API Call Example:

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

VB_PROJECTLIST.REV1

Signature: SUBROUTINE VB_PROJECTLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args5
Superseded ByVB_PROJECTLIST.REV2

Arguments:

IndexNameDirectionDescription
0COin
1IDLISTin
2SQLin
3DATAout
4MESSAGEout

API Call Example:

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

VB_PROJECTLIST.REV2

Signature: SUBROUTINE VB_PROJECTLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionLists projects with status, quote counts, and filtering by ID list or SQL criteria

Arguments:

IndexNameDirectionDescription
0COinCompany code
1IDLISTinDelimited list of project IDs to filter (optional)
2SQLinSQL criteria string for project selection (optional)
3DATAoutVM/AM delimited array of project data (12 fields per project)
4MESSAGEoutError or status message

Tables Referenced: PROJECT.1287, SPN.QUOTES.1287, PROJECT.STATUS.1287

API Call Example:

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

VB_PROJECTORDERS.REV1

Signature: SUBROUTINE VB_PROJECTORDERS(CO,REQTYPE,SOIDNO,SOREC,ADDFLAG,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternCRUD
Args6
DescriptionAdds, updates, or deletes project sales order line items with audit trail
Safe REQTYPEADD, UPDATE
Dangerous REQTYPEDELETE

Arguments:

IndexNameDirectionDescription
0COinCompany code
1REQTYPEinRequest type: ADD, UPDATE, or DELETE
2SOIDNOinSales order ID number (CO!ProjectID!LineNo)
3SORECinSales order record data to write (dynamic array)
4ADDFLAGinAdd flag - Y if new record
5MESSAGEoutResult message (SAVED or DELETED)

Tables Referenced: PROJECT.SALESORDERS.1287, PASSWORDS, TRANSREG

Tables Written: PROJECT.SALESORDERS.1287, TRANSREG

API Call Example:

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

VB_PROJECTPAYMENTS.REV1

Signature: SUBROUTINE VB_PROJECTPAYMENTS(CO,REQTYPE,PAYIDNO,PAYREC,ADDFLAG,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternCRUD
Args6
DescriptionAdds, updates, or deletes project payment line items with audit trail
Safe REQTYPEADD, UPDATE
Dangerous REQTYPEDELETE

Arguments:

IndexNameDirectionDescription
0COinCompany code
1REQTYPEinRequest type: ADD, UPDATE, or DELETE
2PAYIDNOinPayment ID number (CO!ProjectID!LineNo)
3PAYRECinPayment record data to write (dynamic array)
4ADDFLAGinAdd flag - Y if new record
5MESSAGEoutResult message (SAVED or DELETED)

Tables Referenced: PROJECT.PAYMENTS.1287, PASSWORDS, TRANSREG

Tables Written: PROJECT.PAYMENTS.1287, TRANSREG

API Call Example:

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

VB_PROJECTTASKS.REV1

Signature: SUBROUTINE VB_PROJECTTASKS(CO,REQTYPE,TASKIDNO,TASKREC,ADDFLAG,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternCRUD
Args6
DescriptionAdds, updates, or deletes project task line items with audit trail
Safe REQTYPEADD, UPDATE
Dangerous REQTYPEDELETE

Arguments:

IndexNameDirectionDescription
0COinCompany code
1REQTYPEinRequest type: ADD, UPDATE, or DELETE
2TASKIDNOinTask ID number (CO!ProjectID!LineNo)
3TASKRECinTask record data to write (dynamic array)
4ADDFLAGinAdd flag - Y if new record
5MESSAGEoutResult message (SAVED or DELETED)

Tables Referenced: PROJECT.TASKS.1287, PASSWORDS, TRANSREG

Tables Written: PROJECT.TASKS.1287, TRANSREG

API Call Example:

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

VB_PRUNEAUTOWO.1

Signature: SUBROUTINE PRUNEAUTOWO.1(AUTOWOS)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_PRUNEAUTOWO.1

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args1
DescriptionReturns list of auto-generated work order numbers from OPENWO.AUTO file

Tables Referenced: OPENWO.AUTO.1287

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_PRUNEAUTOWO.1",
    "args":  {
 
             }
}

VB_PVXREF.REV1

Signature: SUBROUTINE VB_PVXREF(CO,REQTYPE,DATAIN,DATAOUT,MSG)

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

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args5
DescriptionMaintains part-vendor cross-reference records and updates lead times in ITEMORD

Arguments:

IndexNameDirectionDescription
0COinCompany code
1REQTYPEinRequest type (unused in current code)
2DATAINinInput data: <1>=PartNo, <2>=VendorList, <3>=LeadTime
3DATAOUToutOutput data (unused in current code)
4MSGoutError or status message

Tables Referenced: GL-COMPANY, PRODUCT, PVXREF, ITEMORD, VENDOR, VENDXREF, VPXREF, PRODVEND, PASSWORDS, TRANSREG

Tables Written: PVXREF, PRODVEND, ITEMORD, VPXREF

API Call Example:

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

VB_QUOTELIST.REV1

Signature: SUBROUTINE VB_QUOTELIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionLists spare parts quotes with filtering by ID list or SQL criteria

Arguments:

IndexNameDirectionDescription
0COinCompany code
1IDLISTinDelimited list of quote IDs to filter (optional)
2SQLinSQL criteria for quote selection (optional)
3DATAoutVM/AM delimited array of quote data (10 fields per quote)
4MESSAGEoutError or status message

Tables Referenced: SPN.QUOTES.1287

API Call Example:

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

VB_QUOTEPARA.REV1

Signature: SUBROUTINE VB_QUOTEPARA(CO,REQTYPE,PARANO,P1287REC,ADDFLAG,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternCRUD
Args6
DescriptionAdds, updates, or deletes spare parts quote paragraph records with audit trail
Safe REQTYPEADD, UPDATE
Dangerous REQTYPEDELETE

Arguments:

IndexNameDirectionDescription
0COinCompany code
1REQTYPEinRequest type: ADD, UPDATE, or DELETE
2PARANOinParagraph ID (CO!QuoteID!ParaNo)
3P1287RECinParagraph record data to write (dynamic array)
4ADDFLAGinAdd flag - Y if new record
5MESSAGEoutResult message (SAVED or DELETED)

Tables Referenced: SPN.QUOTEPARA.1287, PASSWORDS, TRANSREG

Tables Written: SPN.QUOTEPARA.1287, TRANSREG

API Call Example:

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

VB_QUOTEPARALIST.REV1

Signature: SUBROUTINE VB_QUOTEPARALIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args5
Superseded ByVB_QUOTEPARALIST.REV2

Arguments:

IndexNameDirectionDescription
0COin
1IDLISTin
2SQLin
3DATAout
4MESSAGEout

API Call Example:

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

VB_QUOTEPARALIST.REV2

Signature: SUBROUTINE VB_QUOTEPARALIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionLists spare parts quote paragraphs with item category descriptions

Arguments:

IndexNameDirectionDescription
0COinCompany code
1IDLISTinDelimited list of quote paragraph IDs to filter (optional)
2SQLinSQL criteria for paragraph selection (optional)
3DATAoutVM/AM delimited array of paragraph data (7 fields per record)
4MESSAGEoutError or status message

Tables Referenced: SPN.QUOTEPARA.1287, ITEMCA

API Call Example:

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

VB_R7270

Signature: SUBROUTINE R7270(CO.STDS.COST,FHEADFILE,FLINEFILE,FNOTEFILE,THEADFILE,TLINEFILE,TNOTEFILE,CO,ROUTENO,WONO,ORDQTY,BEL,FPBSFILE,TPBSFILE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_R7270

PropertyValue
Status[+] analyzed
Safety[INT] internal
PatternInternal
Args14
DescriptionCopies a standard routing to a WIP routing for a work order, with quantity adjustments

Arguments:

IndexNameDirectionDescription
0CO.STDS.COSTinPre-opened CO.STDS.COST file handle
1FHEADFILEinPre-opened source routing header file handle
2FLINEFILEinPre-opened source routing line file handle
3FNOTEFILEinPre-opened source routing note file handle
4THEADFILEinPre-opened target routing header file handle
5TLINEFILEinPre-opened target routing line file handle
6TNOTEFILEinPre-opened target routing note file handle
7COinCompany code
8ROUTENOinStandard routing number to copy from
9WONOinWork order number to copy to
10ORDQTYinOrder quantity for route quantity calculations
11BELinBell character for terminal alerts
12FPBSFILEinPre-opened source PBS line file handle
13TPBSFILEinPre-opened target PBS line file handle

Tables Referenced: CO.STDS.COST

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_R7270",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "4":  "",
                 "5":  "",
                 "6":  "",
                 "7":  "",
                 "8":  "",
                 "9":  "",
                 "10":  "",
                 "11":  "",
                 "12":  "",
                 "13":  ""
             }
}

VB_READ.SP.QUOTE.REV1

Signature: SUBROUTINE VB_READ.SP.QUOTE(CO,ASSYNO,SPREC,MSG)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_READ.SP.QUOTE.REV1

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args4
DescriptionReads a spare parts quote and enriches line items with manufacturer, description, UM, lead time, and where-used data

Arguments:

IndexNameDirectionDescription
0COinCompany code
1ASSYNOinAssembly/quote number to read
2SPRECoutSpare parts quote record with enriched line item data
3MSGoutError or status message

Tables Referenced: SP.QUOTE.1287, ITEMMANF, PRODUCT, ITEMORD, BMF

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_READ.SP.QUOTE.REV1",
    "args":  {
                 "0":  "",
                 "1":  ""
             }
}

VB_READDICTID

Signature: SUBROUTINE VB_READDICT(DICTFILE,DATA)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_READDICTID

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternUtility
Args2
DescriptionReads dictionary field IDs from a specified file DICT and returns them as a delimited list

Arguments:

IndexNameDirectionDescription
0DICTFILEinName of the file whose DICT to read
1DATAoutAM-delimited list of dictionary field IDs

API Call Example:

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

VB_READINVOICE.REV1

Signature: SUBROUTINE VB_READINVOICE(CO,INVNO,H.DATA,L.DATA,NOTES,TOTALS,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args7
DescriptionReads a complete invoice with header, lines, notes, totals, and related customer/shipping data from 21 tables

Arguments:

IndexNameDirectionDescription
0COinCompany code
1INVNOinInvoice number to read
2H.DATAoutInvoice header record (dynamic array)
3L.DATAoutInvoice line records (AM-delimited)
4NOTESoutInvoice notes and comments data
5TOTALSoutInvoice totals and tax calculations
6MESSAGEoutError or status message

Tables Referenced: INVOICE.1287, INVLINE.1287, INVNOTES.1287, INVMISC.1287, INVMISC2.1287, INVMEMO.1287, INVCOMMENTS, CUSTOMER, SHIPTO, SHIPTO.OE, COMPANY.STDS, TAXJURIS, SALESREP, SALESTERR, PAYMETH, CONTACT, SHIPVIA, FOB, PRODUCT, HSCODE, COUNTRYCODE

API Call Example:

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

VB_RECEIPTUPD

Signature: SUBROUTINE DUMMY(BIN,BIN.PRODUCT,BINXREF,BINFLAG,BINLIST,CAGE,CATEGORY,CO.STDS,CO.STDS.COST,CONTAINER.TYPE,DTSD,DTSX,GLCOMPANY,ITEMCA,LOCODE,ITEMHIST,ITEMQTY,INVAUDIT,INVAUDPOXREF,INVAUDWOXREF,INVHIST,INVXREF,JOB.BIN,JOB.BINXREF,JOB.PRODUCT,LOT,LOTCOST,LOTCOSTXREF,LOTHIST,LOTHIST.AUDIT,LOTHIST.GL,LOTXREF,OPEN.PO.HEAD,OPEN.PO.LINES,OPENWO,OUTAUDIT,OWNERSHIP,PO.CARRIER,PO.REC,POHIST,POHISTINDX,POHIST.OUTXREF,POHIST.RATING,POXUCAP,PRODUCT,REQ,TRANSCRT,VENDOR,VIXUCAP,WOXREF,BEL,CEL,CES,CO,CO.CONFIRM,CONFIRM,CRTNO,CWS,DATE.REC,DES,EXDATES,EXPDATES,FILE,MAT HEAD,HCARR,HCTNS,HCTYPE,HEXDATE,HOCODE,HPACK,IFLAG,INITS,JOBNO,KEY,LREC,LFLAG,LINE9,LINENO,MARK,MSGFLAG,NIFLAG,OPENQTYS,PONO,PGM,MAT PREC,PRINTSUB,MAT PRODREC,QTYLIST,RECNO,STDRDS,UM,VNAME)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_RECEIPTUPD

PropertyValue
Status[+] analyzed
Safety[INT] internal
PatternInternal
Args92
DescriptionInternal receipt processing engine that updates PO, inventory, vendor, and history records during receipt entry

Arguments:

IndexNameDirectionDescription
0BINin
1BIN.PRODUCTin
2BINXREFin
3BINFLAGin
4BINLISTin
5CAGEin
6CATEGORYin
7CO.STDSin
8CO.STDS.COSTin
9CONTAINER.TYPEin
10DTSDin
11DTSXin
12GLCOMPANYin
13ITEMCAin
14LOCODEin
15ITEMHISTin
16ITEMQTYin
17INVAUDITin
18INVAUDPOXREFin
19INVAUDWOXREFin
20INVHISTin
21INVXREFin
22JOB.BINin
23JOB.BINXREFin
24JOB.PRODUCTin
25LOTin
26LOTCOSTin
27LOTCOSTXREFin
28LOTHISTin
29LOTHIST.AUDITin
30LOTHIST.GLin
31LOTXREFin
32OPEN.PO.HEADin
33OPEN.PO.LINESin
34OPENWOin
35OUTAUDITin
36OWNERSHIPin
37PO.CARRIERin
38PO.RECinPurchase order record (dynamic array)
39POHISTin
40POHISTINDXin
41POHIST.OUTXREFin
42POHIST.RATINGin
43POXUCAPin
44PRODUCTinPre-opened PRODUCT file handle
45REQin
46TRANSCRTin
47VENDORinPre-opened VENDOR file handle
48VIXUCAPin
49WOXREFin
50BELin
51CELin
52CESin
53COinCompany code
54CO.CONFIRMin
55CONFIRMin
56CRTNOin
57CWSin
58DATE.RECinDate record data
59DESin
60EXDATESin
61EXPDATESin
62FILEin
63HEADin
64HCARRin
65HCTNSin
66HCTYPEin
67HEXDATEin
68HOCODEin
69HPACKin
70IFLAGin
71INITSin
72JOBNOin
73KEYin
74LRECinLine record data
75LFLAGin
76LINE9in
77LINENOin
78MARKin
79MSGFLAGinMessage flag indicator
80NIFLAGin
81OPENQTYSin
82PONOin
83PGMin
84PRECinProduct record data
85PRINTSUBin
86PRODRECinProduction record data
87QTYLISTin
88RECNOinReceipt number
89STDRDSin
90UMin
91VNAMEin

Tables Referenced: PASSWORDS, TRANSREG, PRODUCT, ITEMORD, ITEMLOC, VENDOR, COMPANY.STDS, POHIST, POHIST.RATING, GL-COMPANY

Tables Written: POHIST, POHIST.RATING, POHISTINDX, POHIST.OUTXREF, POXUCAP, VENDOR, PRODUCT

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_RECEIPTUPD",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "4":  "",
                 "5":  "",
                 "6":  "",
                 "7":  "",
                 "8":  "",
                 "9":  "",
                 "10":  "",
                 "11":  "",
                 "12":  "",
                 "13":  "",
                 "14":  "",
                 "15":  "",
                 "16":  "",
                 "17":  "",
                 "18":  "",
                 "19":  "",
                 "20":  "",
                 "21":  "",
                 "22":  "",
                 "23":  "",
                 "24":  "",
                 "25":  "",
                 "26":  "",
                 "27":  "",
                 "28":  "",
                 "29":  "",
                 "30":  "",
                 "31":  "",
                 "32":  "",
                 "33":  "",
                 "34":  "",
                 "35":  "",
                 "36":  "",
                 "37":  "",
                 "38":  "",
                 "39":  "",
                 "40":  "",
                 "41":  "",
                 "42":  "",
                 "43":  "",
                 "44":  "",
                 "45":  "",
                 "46":  "",
                 "47":  "",
                 "48":  "",
                 "49":  "",
                 "50":  "",
                 "51":  "",
                 "52":  "",
                 "53":  "",
                 "54":  "",
                 "55":  "",
                 "56":  "",
                 "57":  "",
                 "58":  "",
                 "59":  "",
                 "60":  "",
                 "61":  "",
                 "62":  "",
                 "63":  "",
                 "64":  "",
                 "65":  "",
                 "66":  "",
                 "67":  "",
                 "68":  "",
                 "69":  "",
                 "70":  "",
                 "71":  "",
                 "72":  "",
                 "73":  "",
                 "74":  "",
                 "75":  "",
                 "76":  "",
                 "77":  "",
                 "78":  "",
                 "79":  "",
                 "80":  "",
                 "81":  "",
                 "82":  "",
                 "83":  "",
                 "84":  "",
                 "85":  "",
                 "86":  "",
                 "87":  "",
                 "88":  "",
                 "89":  "",
                 "90":  "",
                 "91":  ""
             }
}

VB_REDBOOKLIST

Signature: SUBROUTINE VB_REDBOOKLIST(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_REDBOOKLIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionLists red book (RFC) entries with filtering by ID list or SQL criteria

Arguments:

IndexNameDirectionDescription
0SQLinSQL criteria or filter for red book selection
1DATAoutVM/AM delimited array of red book data (4 fields per record)
2MESSAGEoutError or status message

Tables Referenced: REDBOOK.1287

API Call Example:

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

VB_REFXLIST.REV1

Signature: SUBROUTINE VB_REFXLIST(SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionLists reference cross-reference product entries with filtering by ID list or SQL criteria

Arguments:

IndexNameDirectionDescription
0SQLinSQL criteria or filter for cross-reference selection
1DATAoutVM/AM delimited array of cross-reference data (2 fields per record)
2MESSAGEoutError or status message

Tables Referenced: REFXPROD

API Call Example:

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

VB_S8040

Signature: SUBROUTINE VB_FS8040(CO,REPNUM,FMTNUM,WORKFILE,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_S8040

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args5
DescriptionReads financial schedule data from FS.* tables and returns amounts and percentages for schedule line items

Arguments:

IndexNameDirectionDescription
0COinCompany code
1REPNUMinReport number
2FMTNUMinFormat number
3WORKFILEinoutSchedule IDs in (AM-delimited), amounts and percentages returned
4MESSAGEoutError or status message

Tables Referenced: FS.SCHED, FS.REVENUE, FS.EXPENSE, FS.ASSETS, FS.LIABILITY, FS.CAPITAL, FS.STATISTIC

API Call Example:

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

VB_SERVICELIST

Signature: SUBROUTINE VB_SERVICELIST(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_SERVICELIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionLists service records with assigned employee names and filtering by ID list or SQL criteria

Arguments:

IndexNameDirectionDescription
0SQLinSQL criteria or filter for service record selection
1DATAoutVM/AM delimited array of service data (4 fields per record)
2MESSAGEoutError or status message

Tables Referenced: SERVICE.1287, EMPLOYEE.PUBLIC.1287

API Call Example:

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

VB_SHIPTO

Signature: SUBROUTINE VB_SHIPTO(INDATA,SHIPREC,SHIPOEREC,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_SHIPTO

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternCRUD
Args4
DescriptionAdds, updates, or deletes ship-to address records with audit trail logging
Safe REQTYPEADD, UPDATE
Dangerous REQTYPEDELETE

Arguments:

IndexNameDirectionDescription
0INDATAinInput data: <1>=CO, <2>=CustNo, <3>=ShipToNo, <4>=ReqType (ADD/DELETE)
1SHIPRECinShip-to address record data to write (dynamic array)
2SHIPOERECinShip-to OE record data to write (dynamic array)
3MESSAGEoutResult message (SAVED or DELETED)

Tables Referenced: PASSWORDS, TRANSREG, SHIPTO, SHIPTO.OE

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

API Call Example:

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

VB_SHIPTOLIST

Signature: SUBROUTINE VB_SHIPTOLIST(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_SHIPTOLIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionLists ship-to addresses for a customer with 10-field address detail data

Arguments:

IndexNameDirectionDescription
0SQLinSQL criteria with customer number filter
1DATAoutVM/AM delimited array of ship-to data (10 fields per address)
2MESSAGEoutError or status message

Tables Referenced: SHIPTO

API Call Example:

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

VB_SHOWREADU

Signature: SUBROUTINE VB_SHOWREADU(ERRMSG)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_SHOWREADU

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternUtility
Args1
DescriptionDisplays who is locking a record. Uses STATUS() and GETREADU() to find the user holding a lock and returns a descriptive error message identifying the lock holder.

Arguments:

IndexNameDirectionDescription
0ERRMSGoutReturns lock holder description or generic lock message

API Call Example:

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

VB_SPNLIST

Signature: SUBROUTINE VB_SPNLIST(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_SPNLIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionReads SPN list. Executes SQL on SPN.1287 and returns SPN numbers and names.

Arguments:

IndexNameDirectionDescription
0SQLinSQL select statement
1DATAoutReturn array: SPN numbers and names
2MESSAGEoutError/status message

Tables Referenced: SPN.1287

API Call Example:

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

VB_SPNLIST.REV1

Signature: SUBROUTINE VB_SPNLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args5
Superseded ByVB_SPNLIST.REV2

Arguments:

IndexNameDirectionDescription
0COin
1IDLISTin
2SQLin
3DATAout
4MESSAGEout

API Call Example:

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

VB_SPNLIST.REV2

Signature: SUBROUTINE VB_SPNLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionExtended SPN list. Returns 22-column array with SPN details including account info, status, order values, dates, quotes, sales rep, last activity, project data, industry class/sector, process/machine types, lost competitor/reason/notes. Supports SQL or ID list.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinValue-marked list of SPN IDs
2SQLinSQL select statement
3DATAoutReturn array with 22 columns
4MESSAGEoutError/status message

Tables Referenced: ACCOUNT.1287, ACTIVITY.LOG.1287, ACTIVITY.XREF.1287, COMPETITOR.1287, EMPLOYEE.PUBLIC.1287, INDCLASS, INDSECTOR.1287, MACHPROCESSTYPE.1287, MACHTYPE.1287, PROJECT.1287, SPN.1287, SPN.QUOTES.1287, SPN.REASON.1287, SPN.STATUS.1287

API Call Example:

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

VB_SPNQUOTELIST.REV1

Signature: SUBROUTINE VB_SPNQUOTELIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionReads SPN quote list. Returns 8-column array with quote ID, quote number, contact, SPN number, author initials, description, create/modify dates. Supports SQL or ID list.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinValue-marked list of SPN quote IDs
2SQLinSQL select statement
3DATAoutReturn array with 8 columns
4MESSAGEoutError/status message

Tables Referenced: CONTACT.1287, EMPLOYEE.PUBLIC.1287, SPN.QUOTES.1287

API Call Example:

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

VB_SPQUOTEMAINT2.REV1

Signature: SUBROUTINE VB_QUOTEMAINT2(CO,REQTYPE,INDATA,OUTDATA,MSG)

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

PropertyValue
Status[X] deprecated
Args5
Superseded ByVB_SPQUOTEMAINT2.REV3

Arguments:

IndexNameDirectionDescription
0COin
1REQTYPEin
2INDATAout
3OUTDATAout
4MSGout

API Call Example:

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

VB_SPQUOTEMAINT2.REV2

Signature: SUBROUTINE VB_QUOTEMAINT2(CO,REQTYPE,INDATA,OUTDATA,MSG)

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

PropertyValue
Status[X] deprecated
Args5
Superseded ByVB_SPQUOTEMAINT2.REV3

Arguments:

IndexNameDirectionDescription
0COin
1REQTYPEin
2INDATAout
3OUTDATAout
4MSGout

API Call Example:

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

VB_SPQUOTEMAINT2.REV3

Signature: SUBROUTINE VB_QUOTEMAINT2(CO,REQTYPE,INDATA,OUTDATA,MSG)

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

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternCRUD
Args5
DescriptionQuote maintenance with REQTYPE-driven operations. Supports CUSTNO, STKPAR, TERMS, PARTNO, FOB, SAVEPRICE (writes to PRD.PRICE.1287), GLCATEGORY, SHIPTONO, FREIGHT, and QUOTELIST.
Safe REQTYPECUSTNO, STKPAR, TERMS, PARTNO, FOB, GLCATEGORY, SHIPTONO, FREIGHT, QUOTELIST
Dangerous REQTYPESAVEPRICE

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type
2INDATAinInput data depending on REQTYPE
3OUTDATAinoutOutput data array; for SAVEPRICE contains price record to write
4MSGoutError/status message

Tables Referenced: CATEGORY, CREDIT, CUSTOMER, CUSTOMER.1287, CUSTOMER.OE, FOB, FREIGHT, ITEMCA, ITEMORD, PRD.PRICE, PRD.PRICE.1287, PRODUCT, PRODUCT.1287, PRODUCT.NOTES, SHIPTO, SHIPTO.OE, SP.VBQUOTE.1287, STOCK.PAR, TMF

Tables Written: PRD.PRICE.1287

API Call Example:

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

VB_SPR.REV1

Signature: SUBROUTINE VB_SPR.REV1(CO,REQTYPE,REQNO,REQREC,ADDFLAG,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternCRUD
Args6
DescriptionSaves or deletes SPR request records. REQTYPE DELETE removes from SPR.1287. Otherwise MATWRITE passed record data to SPR.1287.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type: DELETE or add/update
2REQNOinSPR record key
3REQRECinDynamic array of SPR record data (MATWRITE to SPR.1287)
4ADDFLAGinAdd flag (unused)
5MESSAGEoutStatus: DELETED or SAVED

Tables Referenced: SPR.1287

Tables Written: SPR.1287

API Call Example:

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

VB_TABLE.LOOKUP.REV2OLD

Signature: SUBROUTINE VB_TABLE_LOOKUP(VTABLE,VFIELDNUM,VFIELDNAME,VSQL,VSORT,VLIST,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_TABLE.LOOKUP.REV2OLD

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternUtility
Args8
DescriptionGeneric table lookup utility. Opens any UniData table dynamically, performs SSELECT or BSELECT, returns two-column array of IDs and field values. Supports field number/name, SQL filtering, sort, and ID list.

Arguments:

IndexNameDirectionDescription
0VTABLEinTable name to open and query
1VFIELDNUMinField number(s) to return
2VFIELDNAMEinField name(s) from dictionary
3VSQLinSQL WHERE clause
4VSORTinSort clause
5VLISTinValue-marked list of record IDs
6DATAoutReturn array: IDs and descriptions
7MESSAGEoutError/status message

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_TABLE.LOOKUP.REV2OLD",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "4":  "",
                 "5":  ""
             }
}

VB_TESTCODE

Signature: SUBROUTINE TESTCODE(DATAIN,DATAOUT,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_TESTCODE

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternUtility
Args3
DescriptionTest subroutine returning hardcoded values. Sets DATAOUT<1>=SOME TEXT and DATAOUT<2>=12/31/19, then returns. Dead code after RETURN (routing ops never executed since OPTION is empty).

Arguments:

IndexNameDirectionDescription
0DATAINinInput data array (read but not used in active code)
1DATAOUToutOutput data (hardcoded values)
2MESSAGEoutMessage (not populated)

API Call Example:

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

VB_TIMESHEETINQ

Signature: SUBROUTINE VB_TIMESHEETINQ(INFO,EMPNO,FROMDATE,TODATE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_TIMESHEETINQ

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args4
DescriptionTimesheet inquiry. Retrieves labor history for an employee across a date range. Reads time cards from TS.XREF.1287, iterates labor history lines to build array with date, line#, work center, WO#, hours, rates, part info, WO dates, route completion dates.

Arguments:

IndexNameDirectionDescription
0INFOoutReturn array with labor detail and daily summary lines
1EMPNOinEmployee number
2FROMDATEinFrom date (internal format)
3TODATEinTo date (internal format, upper bound of FOR loop)

Tables Referenced: LABORHIST, LABORHIST.HEAD, LABORHIST.HEAD.1287, OPENWO, PRODUCT, TS.XREF.1287, WIP.CLOSE, WIPROUTE.LINE

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_TIMESHEETINQ",
    "args":  {
                 "1":  "",
                 "2":  "",
                 "3":  ""
             }
}

VB_TIMESHEETINQ.REV2

Signature: SUBROUTINE VB_TIMESHEETINQ(INFO,EMPNO,FROMDATE,TODATE)

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

PropertyValue
Status[X] deprecated
Args4
Superseded ByVB_TIMESHEETINQ.REV3

Arguments:

IndexNameDirectionDescription
0INFOin
1EMPNOin
2FROMDATEin
3TODATEout

API Call Example:

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

VB_TIMESHEETINQ.REV3

Signature: SUBROUTINE VB_TIMESHEETINQ.REV3(INFO,EMPNO,FROMDATE,TODATE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args4
DescriptionEnhanced timesheet inquiry (REV3). Adds date validation, excludes empno 9999, calculates REG+OT+DT summation, includes misc hours and card ID. Returns daily labor detail plus summary with total hours, indirect, OT, off-duty, misc, card date, card ID.

Arguments:

IndexNameDirectionDescription
0INFOoutReturn array with labor detail and daily summary lines
1EMPNOinEmployee number (9999 excluded)
2FROMDATEinFrom date (internal format)
3TODATEinTo date (must be >= FROMDATE)

Tables Referenced: LABORHIST, LABORHIST.HEAD, LABORHIST.HEAD.1287, OPENWO, PRODUCT, TS.XREF.1287, WIP.CLOSE, WIPROUTE.LINE

API Call Example:

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

VB_UPD.WIPCOST

Signature: SUBROUTINE VB_UPD.WIPCOST(DATAIN,DATAOUT,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_UPD.WIPCOST

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args3
DescriptionUpdates WIP cost summary for WOs closed on a given date. Selects from WIP.CLOSE by date, reads OPENWO and WIPLEDGER.SUM to calculate AP/labor/material/outside costs, writes summary to WIPCOST.1287.

Arguments:

IndexNameDirectionDescription
0DATAINinInput data (DATAIN<1>=closing date; cleared after reading)
1DATAOUToutOutput data (cleared, not populated)
2MESSAGEoutError/status message

Tables Referenced: COACCESS, GL-COMPANY, GL.CHARTS, OPENWO, WIP.CLOSE, WIPLEDGER.SUM

Tables Written: WIPCOST.1287

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_UPD.WIPCOST",
    "args":  {
                 "0":  ""
             }
}

VB_UPDATE.ROUTE.LEAD

Source: S:\LinuxShare\pro3prog\VBBASE\VB_UPDATE.ROUTE.LEAD

PropertyValue
Status[+] analyzed
Safety[INT] internal
PatternInternal
Args0
DescriptionBatch script to update standard routing lines with outside ops and recalculate lead times. Selects SROUTE.HEAD, reads PRODUCT for MRP=M, calls VB_FIX.SROUTE.LINE. Not a callable subroutine (no SUBROUTINE declaration).

Tables Referenced: ITEMORD, PRODUCT, SROUTE.HEAD

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_UPDATE.ROUTE.LEAD",
    "args":  {
 
             }
}

VB_UPDATE_ACTIVITY

Signature: SUBROUTINE VB_UPDATE_ACTIVITY(CO,REQTYPE,ACTIVITYID,P1287REC,ADDFLAG,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_UPDATE_ACTIVITY

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternCRUD
Args6
DescriptionSaves or deletes activity log records. DELETE removes from ACTIVITY.LOG.1287. Otherwise MATWRITE DIM(50) to ACTIVITY.LOG.1287. Opens TRANSREG/PASSWORDS for audit (currently commented out).

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type: DELETE or add/update
2ACTIVITYIDinActivity log record ID
3P1287RECinDynamic array of record data (MATWRITE to ACTIVITY.LOG.1287)
4ADDFLAGinAdd flag (unused)
5MESSAGEoutStatus: DELETE SUCCEEDED or WRITE SUCCEEDED

Tables Referenced: ACTIVITY.LOG.1287, PASSWORDS, TRANSREG

Tables Written: ACTIVITY.LOG.1287

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_UPDATE_ACTIVITY",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "2":  "",
                 "3":  "",
                 "4":  ""
             }
}

VB_UPDATECOST

Signature: SUBROUTINE VB_UPDATECOST(INDATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_UPDATECOST

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args2
DescriptionUpdates last cost and vendor for parts. Reads tab-delimited purchase price list from WPDOCS/PURCHASEPRICE.txt, writes new price to ITEMCA (fields 8,38) and vendor to PVXREF (field 1). Sends email via PROCESS.NOTIFY.

Arguments:

IndexNameDirectionDescription
0INDATAinInput data (cleared and reused for notification)
1MESSAGEoutStatus: SUCCESS on completion

Tables Referenced: ITEMCA, PVXREF, WPDOCS

Tables Written: ITEMCA, PVXREF

API Call Example:

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

VB_VENDORLIST

Signature: SUBROUTINE VB_VENDORLIST(SQL,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_VENDORLIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args3
DescriptionReads vendor list. Selects VENDOR sorted by name, excluding deleted and class E. Search text via DATA filters by name pattern. Returns 6-column array: vendor#, name, phone, fax, contact, class.

Arguments:

IndexNameDirectionDescription
0SQLinSQL parameter (search text passed via DATA)
1DATAoutReturn array with 6 columns
2MESSAGEoutError/status message

Tables Referenced: VENDOR

API Call Example:

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

VB_VENDORLIST.REV1

Signature: SUBROUTINE VB_VENDORLIST(CO,IDLIST,SQL,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionExtended vendor list. Returns 8-column array: vendor#, name, phone, fax, contact, class, website, status name. Supports SQL or ID list. Reads VENDOR, VENDOR.1287, VENDORSTATUS.1287, ACCOUNT.1287.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1IDLISTinValue-marked list of vendor IDs
2SQLinSQL select statement
3DATAoutReturn array with 8 columns
4MESSAGEoutError/status message

Tables Referenced: ACCOUNT.1287, VENDOR, VENDOR.1287, VENDORSTATUS.1287

API Call Example:

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

VB_W.7277

Signature: SUBROUTINE VB_W.7277(DATAIN,DATAOUT,ERRMSG)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_W.7277

PropertyValue
Status[X] deprecated
Args3
Superseded ByVB_W.7285

Arguments:

IndexNameDirectionDescription
0DATAINout
1DATAOUTout
2ERRMSGout

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_W.7277",
    "args":  {
 
             }
}

VB_W.7285

Signature: SUBROUTINE VB_W.7285(DATAIN,DATAOUT,ERRMSG)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_W.7285

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args3
DescriptionWork order receipts to stock. Processes WO completion moving material from WIP to lot file, updating on-hand qtys, posting inventory transactions. Single WO or batch from WO.CLOSE.1287. Updates OPENWO, REQ, ITEMQTY, ITEMHIST, ITEMMANF.1287, PRODUCT, lot files, LOTHIST, LOTHIST.GL, ITEMCA. Sends notifications.

Arguments:

IndexNameDirectionDescription
0DATAINinInput data: <1>=CO, <2>=WO#, <3>=date, <4>=P/C, <5>=qty, <6>=bin, <7>=REQTYPE, <8>=WO type, <9>=initials
1DATAOUToutOutput data (not populated)
2ERRMSGoutError message

Tables Referenced: ALLOCXREF, CATEGORY, GL-COMPANY, ITEMHIST, ITEMMANF.1287, ITEMQTY, JOBMASTER, OPENWO, PRODUCT, REQ, TRANSREG, WIPBMF, WIPLEDGER.AP, WIPLEDGER.LAB, WIPLEDGER.MAT, WIPLEDGER.OUT, WIPLEDGER.SUM, WO.CLOSE.1287

Tables Written: ITEMCA, ITEMHIST, ITEMMANF.1287, ITEMQTY, LOTHIST, LOTHIST.GL, OPENWO, PRODUCT, REQ

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_W.7285",
    "args":  {
                 "0":  ""
             }
}

VB_WIPBMF

Signature: SUBROUTINE VB_WIPBMF(CO,WONO,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_WIPBMF

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args4
DescriptionWIP BOM display for single work order. Reads OPENWO header, assembles WO status info, reads/sorts WIPBMF components. Returns multi-row array with WO header (rows 1-11) and BOM lines (rows 15+) with part, desc, MRP, qty, alloc, issued, returned, on-hand, on-order.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1WONOinWork order number
2DATAoutReturn array with WO header and BOM lines
3MESSAGEoutError/status message

Tables Referenced: GL-COMPANY, ITEMQTY, OPENWO, PRODUCT, WIPBMF, WOCE, WOTYPE

API Call Example:

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

VB_WIPBMF.REV2

Signature: SUBROUTINE VB_WIPBMF.REV2(CO,REQTYPE,WONO,JOBNUMBER,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args6
Superseded ByVB_WIPBMF.REV5

Arguments:

IndexNameDirectionDescription
0COin
1REQTYPEin
2WONOin
3JOBNUMBERin
4DATAout
5MESSAGEout

API Call Example:

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

VB_WIPBMF.REV3

Signature: SUBROUTINE VB_WIPBMF.REV3(CO,REQTYPE,WONO,JOBNUMBER,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args6
Superseded ByVB_WIPBMF.REV5

Arguments:

IndexNameDirectionDescription
0COin
1REQTYPEin
2WONOin
3JOBNUMBERin
4DATAout
5MESSAGEout

API Call Example:

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

VB_WIPBMF.REV4

Signature: SUBROUTINE VB_WIPBMF.REV4(CO,REQTYPE,WONO,JOBNUMBER,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args6
Superseded ByVB_WIPBMF.REV5

Arguments:

IndexNameDirectionDescription
0COin
1REQTYPEin
2WONOin
3JOBNUMBERin
4DATAout
5MESSAGEout

API Call Example:

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

VB_WIPBMF.REV5

Signature: SUBROUTINE VB_WIPBMF(CO,REQTYPE,WONO,JOBNUMBER,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_WIPBMF.REV5

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternInquiry
Args6
DescriptionEnhanced WIP BOM (REV5) with WO/WOLIST/JOB/JOBWRITE modes. Includes bin/picking info, paint prefix, component availability (WORKJ7272A/B), hold status from OPENWO.1287, gross requirement allocation via VB_PART_ALLOCATION_INQUIRY.REV5. JOBWRITE writes cache to HOLD.
Safe REQTYPEWO, WOLIST, JOB
Dangerous REQTYPEJOBWRITE

Arguments:

IndexNameDirectionDescription
0COinCompany number
1REQTYPEinRequest type: WO, WOLIST, JOB, JOBWRITE
2WONOinWork order number(s)
3JOBNUMBERinJob number
4DATAoutReturn array with WO header and BOM lines
5MESSAGEoutError/status message

Tables Referenced: BIN, GL-COMPANY, ITEMMANF, ITEMQTY, JOBMASTER, JOBMASTER.1287, JOBXFER.1287, LOTHIST, LOTXREF, OPEN.ORD.LINE, OPENWO, OPENWO.1287, PRODUCT, PRODUCT.1287, WIPBMF, WOCE, WORKJ7272A.1287, WORKJ7272B.1287, WOTYPE

Tables Written: HOLD

API Call Example:

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

VB_WODATA.REV1

Signature: SUBROUTINE VB_WODATA(CO,WOLIST,DATAOUT)

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

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternInquiry
Args3
DescriptionRetrieves WIP route, hours, and issue status for WO list. Assembles detail with part, status, job, qty, dates, routed vs actual hours by cost center, hours-to-go, issue status. Writes HOLD: jobno.WO, jobno.RTE, jobno.AT, jobno.NOT.

Arguments:

IndexNameDirectionDescription
0COinCompany number
1WOLISTinAttribute-marked list of WO IDs (CO!WONO)
2DATAOUToutOutput data (results written to HOLD files)

Tables Referenced: ITEMMANF, NOTROUTED.1287, OPENWO, PRODUCT, SROUTE.LINE, WIP.CLOSE, WIPBMF, WIPLEDGER.HRS.1287, WIPROUTE.LINE

Tables Written: HOLD

API Call Example:

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

VB_WOINQUIRY.1

Signature: SUBROUTINE VB_WOINQUIRY.1(CO,PARTNO,WODATA,ROUTEDATA,EMPDATA,OPENONLY)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_WOINQUIRY.1

PropertyValue
Status[X] deprecated
Args6
Superseded ByVB_WOINQUIRY.2

Arguments:

IndexNameDirectionDescription
0COin
1PARTNOin
2WODATAout
3ROUTEDATAout
4EMPDATAout
5OPENONLYin

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_WOINQUIRY.1",
    "args":  {
                 "0":  "",
                 "1":  "",
                 "5":  ""
             }
}

VB_WOINQUIRY.2

Signature: SUBROUTINE VB_WOINQUIRY.1(CO,WO,WODATA,ROUTEDATA,EMPDATA)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_WOINQUIRY.2

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args5
DescriptionReturns work order details, WIP route operation data, and employee labor history for a given work order

Arguments:

IndexNameDirectionDescription
0COinCompany number
1WOinWork order number
2WODATAoutWork order header: part number, description, status, job, qty, labor/setup/total hours
3ROUTEDATAoutWIP route operations: description, completion date, labor/setup/total hours per operation
4EMPDATAoutEmployee labor details per operation: employee number, name, date, labor/setup/total hours

Tables Referenced: OPENWO, PRODUCT, WIPROUTE.HEAD, WIPROUTE.LINE, LABORHIST, LABORXREF, OPERATION, EMPLOYEE.PUBLIC.1287, LABORHIST.HEAD

API Call Example:

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

VB_WOINQUIRY.REV1

Signature: SUBROUTINE VB_WOINQUIRY(INDATA,WODATA,ROUTEDATA,EMPDATA)

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

PropertyValue
Status[X] deprecated
Args4
Superseded ByVB_WOINQUIRY.2

Arguments:

IndexNameDirectionDescription
0INDATAout
1WODATAout
2ROUTEDATAout
3EMPDATAout

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_WOINQUIRY.REV1",
    "args":  {
 
             }
}

VB_WOOP.HOURS

Signature: SUBROUTINE VB_WOOP.HOURS(CO,WO,WODATA,ROUTEDATA)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_WOOP.HOURS

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternInquiry
Args4
DescriptionReturns labor hours by operation for a work order, including WO header data and per-operation labor/setup totals

Arguments:

IndexNameDirectionDescription
0COinCompany number
1WOinWork order number
2WODATAoutWork order header: part number, description, status, job, qty, labor/setup/total hours
3ROUTEDATAoutRoute operation data: description, completion date, labor/setup/total hours per operation

Tables Referenced: OPENWO, PRODUCT, WIPROUTE.HEAD, WIPROUTE.LINE, LABORHIST, LABORXREF, OPERATION, LABORHIST.HEAD

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_WOOP.HOURS",
    "args":  {
                 "0":  "",
                 "1":  ""
             }
}

VB_WOPLAN.REV1

Signature: SUBROUTINE VB_WOPLAN.REV1(WOLIST,REQTYPE)

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

PropertyValue
Status[+] analyzed
Safety[COND] conditional
PatternProcess
Args2
DescriptionReleases, unreleases, or prints shop floor packets for a list of work orders based on REQTYPE
Safe REQTYPEP
Dangerous REQTYPER, U

Arguments:

IndexNameDirectionDescription
0WOLISTinDelimited list of work order numbers to process
1REQTYPEinRequest type: R=Release, U=Unrelease, P=Print SF packets

Tables Referenced: CO.STDS.WIP, JOBMASTER.1287

Tables Written: OPENWO, OPENWO.1287

API Call Example:

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

VB_WORELEASE.1

Signature: SUBROUTINE VB_WORELEASE.1(WONODATA,JOBNODATA,PARTNODATA,DESCDATA)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_WORELEASE.1

PropertyValue
Status[X] deprecated
Args4
Superseded ByVB_WORELEASE.4

Arguments:

IndexNameDirectionDescription
0WONODATAout
1JOBNODATAout
2PARTNODATAout
3DESCDATAout

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_WORELEASE.1",
    "args":  {
 
             }
}

VB_WORELEASE.2

Signature: SUBROUTINE VB_WORELEASE.2(WONO,PIFLAG)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_WORELEASE.2

PropertyValue
Status[X] deprecated
Args2
Superseded ByVB_WORELEASE.4

Arguments:

IndexNameDirectionDescription
0WONOin
1PIFLAGout

API Call Example:

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

VB_WORELEASE.3

Signature: SUBROUTINE VB_WORELEASE.3(WONO,RELEASABLE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_WORELEASE.3

PropertyValue
Status[X] deprecated
Args2
Superseded ByVB_WORELEASE.4

Arguments:

IndexNameDirectionDescription
0WONOin
1RELEASABLEout

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_WORELEASE.3",
    "args":  {
                 "0":  ""
             }
}

VB_WORELEASE.4

Signature: SUBROUTINE VB_WORELEASE.4(WONODATA,JOBNODATA,PARTNODATA,DESCDATA)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_WORELEASE.4

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args4
DescriptionLists unreleased work orders prepared today that are eligible for release

Arguments:

IndexNameDirectionDescription
0WONODATAoutArray of work order numbers prepared today and not yet released
1JOBNODATAoutArray of job numbers (or STOCK if blank)
2PARTNODATAoutArray of part numbers for each work order
3DESCDATAoutArray of part descriptions in title case

Tables Referenced: OPENWO, PRODUCT

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_WORELEASE.4",
    "args":  {
 
             }
}

VB_WORELEASE.REV3

Signature: SUBROUTINE VB_WORELEASE.REV3(WOLIST,PIFLAG)

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

PropertyValue
Status[X] deprecated
Args2
Superseded ByVB_WORELEASE.4

Arguments:

IndexNameDirectionDescription
0WOLISTin
1PIFLAGout

API Call Example:

POST /api/admin/subroutine/call
{
    "name":  "VB_WORELEASE.REV3",
    "args":  {
                 "0":  ""
             }
}

VB_WORELEASEPLANNING

Signature: SUBROUTINE VB_VB_WORELEASEPLANNING(JOBNO,WONOLIST,PARTNOLIST,DESCLIST,EXCEPTLIST,RELEASABLELIST)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_WORELEASEPLANNING

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args6
DescriptionLists unreleased work orders for a job with part details, exception flags, and releasable flags for release planning

Arguments:

IndexNameDirectionDescription
0JOBNOinJob number to look up (or STOCK for unassigned work orders)
1WONOLISToutArray of unreleased work order numbers
2PARTNOLISToutArray of part numbers for each work order
3DESCLISToutArray of part descriptions in title case
4EXCEPTLISToutArray of exception flags (1=exception, 0=normal) from JOBMASTER.1287
5RELEASABLELISToutArray of releasable flags (1=releasable, 0=not) from JOBMASTER.1287

Tables Referenced: OPENWO, JOB.WO.XREF, JOBMASTER.1287, PRODUCT

API Call Example:

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

VB_WPDOCLIST

Signature: SUBROUTINE VB_WPDOCLIST(DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_WPDOCLIST

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args2
DescriptionReturns a list of all word processing document IDs from the WPDOCS table

Arguments:

IndexNameDirectionDescription
0DATAoutMultivalued array of WPDOCS record IDs
1MESSAGEoutError message if file open fails, empty on success

Tables Referenced: WPDOCS

API Call Example:

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

VB_WPPLOT.REV1

Signature: SUBROUTINE VB_WPPLOT(PLOTTYPE,DRAWLIST,PLOTINFO,MSG)

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

PropertyValue
Status[X] deprecated
Args4
Superseded ByVB_WPPLOT.REV2

Arguments:

IndexNameDirectionDescription
0PLOTTYPEin
1DRAWLISTin
2PLOTINFOin
3MSGout

API Call Example:

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

VB_WPPLOT.REV2

Signature: SUBROUTINE VB_WPPLOT(PLOTTYPE,DRAWLIST,PLOTINFO,MSG)

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

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternProcess
Args4
DescriptionSends CAD drawings from a word processing document to plotters/printers, writing a header sheet and calling SEND.PLOT.INFO.REV1

Arguments:

IndexNameDirectionDescription
0PLOTTYPEinPlot type (e.g. Cad Plot for CAD-specific processing)
1DRAWLISTinList of drawing names/numbers to plot
2PLOTINFOinPlot parameters array: plotter, size, elements, propnote, date, time, doc name, PP flag, auto-sort, CAD dir, options, owner
3MSGoutStatus/error message

Tables Referenced: GL-COMPANY, WPDOCS, PLOT.PARAMS

Tables Written: WP.HDR

API Call Example:

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

VB_WRITEPRODUCT

Signature: SUBROUTINE VB_WRITEPRODUCT(ID,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_WRITEPRODUCT

PropertyValue
Status[+] analyzed
Safety[WARN] dangerous
PatternCRUD
Args3
DescriptionUpdates a product record description fields and engineering status in PRODUCT and PRODUCT.1287 tables

Arguments:

IndexNameDirectionDescription
0IDinProduct record ID (company!partno format)
1DATAinUpdate data: DATA<3>=engineering status, DATA<4>=second description, DATA<5>=first description
2MESSAGEoutError message if file open fails, empty on success

Tables Written: PRODUCT, PRODUCT.1287

API Call Example:

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

VB_XREFLIST.REV1

Signature: SUBROUTINE VB_XREFLIST(CO,XREF,TYPE,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args5
Superseded ByVB_XREFLIST.REV5

Arguments:

IndexNameDirectionDescription
0COin
1XREFin
2TYPEin
3DATAout
4MESSAGEout

API Call Example:

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

VB_XREFLIST.REV2

Signature: SUBROUTINE VB_XREFLIST(CO,XREF,TYPE,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args5
Superseded ByVB_XREFLIST.REV5

Arguments:

IndexNameDirectionDescription
0COin
1XREFin
2TYPEin
3DATAout
4MESSAGEout

API Call Example:

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

VB_XREFLIST.REV3

Signature: SUBROUTINE VB_XREFLIST(CO,XREF,TYPE,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args5
Superseded ByVB_XREFLIST.REV5

Arguments:

IndexNameDirectionDescription
0COin
1XREFin
2TYPEin
3DATAout
4MESSAGEout

API Call Example:

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

VB_XREFLIST.REV4

Signature: SUBROUTINE VB_XREFLIST(CO,XREF,TYPE,DATA,MESSAGE)

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

PropertyValue
Status[X] deprecated
Args5
Superseded ByVB_XREFLIST.REV5

Arguments:

IndexNameDirectionDescription
0COin
1XREFin
2TYPEin
3DATAout
4MESSAGEout

API Call Example:

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

VB_XREFLIST.REV5

Signature: SUBROUTINE VB_XREFLIST(CO,XREF,TYPE,DATA,MESSAGE)

Source: S:\LinuxShare\pro3prog\VBBASE\VB_XREFLIST.REV5

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionLooks up a product cross-reference by company, XREF name, and type, returning part details via BSELECT

Arguments:

IndexNameDirectionDescription
0COinCompany number
1XREFinCross-reference name to look up
2TYPEinCross-reference type (e.g. ENG)
3DATAoutMultivalue array of part data: part no, desc, desc2, MFG, UM, MRP type, last cost, on-hand, last recv date, footprint, GT code, INC/OBS
4MESSAGEoutError message if XREF not found or inputs missing, empty on success

Tables Referenced: PRODXREF, PRODUCT

API Call Example:

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

VB_XREFPRODLIST.REV1

Signature: SUBROUTINE VB_XREFLIST(CO,XREF,TYPE,DATA,MESSAGE)

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

PropertyValue
Status[+] analyzed
Safety[SAFE] safe
PatternList
Args5
DescriptionSearches product cross-references with fuzzy matching (LIKE …XREF…) and returns grouped part data per matching XREF via BSELECT

Arguments:

IndexNameDirectionDescription
0COinCompany number
1XREFinCross-reference search term (exact match first, then fuzzy LIKE match)
2TYPEinCross-reference type (e.g. ENG)
3DATAoutArray per matching XREF with nested part data
4MESSAGEoutError message if no matches found or inputs missing, empty on success

Tables Referenced: PRODXREF, PRODUCT

API Call Example:

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


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