Subcontract Progress Payments
  • 13 Mar 2024
  • 1 Minute to read
  • Dark
    Light

Subcontract Progress Payments

  • Dark
    Light

Article summary

Managing lien waivers payments and release in CMiC
Vendor payments and supporting documentation reflected in CMiC Financial system.

Step 1: Retrieve a specific PM Project via company and project code

Retrieve project details for a specific project code using finder e.g.

finder=selectByCompProj;companyCode=001,projectCode=16-001

Request

curl --location --request GET 'https://mobtest.cmiccloudr12.com/cmictestrti/pm-rest-api/rest/1/pmproject?finder=selectByCompProj;companyCode=001,projectCode=16-001' \
--header 'Authorization: Basic Your-User:Pass'

Step 2: Retrieve vendor records

Request

curl --location --request GET 'https://mobtest.cmiccloudr12.com/cmictestrti/sys-rest-api/rest/1/businesspartner?finder=selectBusinessPartner;businessPartner=AGO' \
--header 'Authorization: Basic Your-User:Pass'

Step 3: Retrieve Subcontracts and Schedule of Values

Request

curl --location --request GET 'https://mobtest.cmiccloudr12.com/cmictestrti/pm-rest-api/rest/1/scmast?finder=selectByCompany; CompCodeVar=001' \
--header 'Authorization: Basic Your-User:Pass'

Step 4: Retrieve Subcontract Schedules

Request

curl --location --request GET 'https://mobtest.cmiccloudr12.com/cmictestrti/pm-rest-api/rest/1/scsched?finder=selectSOV;CreateDateGTEQ=2015-08-17T16:45:22-04:00, VenCodeVar=10TILE, JobCodeSOV=15-001, ContCodeVar=15-001.001, CompCodeVar=001' \
--header 'Authorization: Basic Your-User:Pass'

Step 5: Retrieve Vendor Compliance

Retrieve vendor compliance using finder e.g.

finder=selectByCompJobCMCode; companyCode=001, cmCode=EXT0001, jobCode=01JOB, typeCode=EXT

Request

curl --location --request GET 'https://mobtest.cmiccloudr12.com/cmictestrti/cm-rest-api/rest/1/cmmast?finder=selectByCompJobCMCode; companyCode=001, cmCode=EXT0001, jobCode=01JOB, typeCode=EXT' \
--header 'Authorization: Basic Your-User:Pass'

Step 6: Retrieve owner change orders

Retrieve owner change orders filtered by company, change, job, phase, master job, and category codes.

finder=selectByCodes; companyCode=001, changeCode=EXT0001, jobCode=01JOB, phaseCode=01, mastJobCode=01JOB, categoryCode=L

Request

curl --location --request GET 'https://mobtest.cmiccloudr12.com/cmictestrti/cm-rest-api/rest/1/cmdetail?finder=selectByCodes; companyCode=001, changeCode=EXT0001, jobCode=01JOB, phaseCode=01, mastJobCode=01JOB, categoryCode=L' \
--header 'Authorization: Basic Your-User:Pass'

Step 7: Retrieve AP Open Periods By Codes

Request

curl --location --request GET 'https://mobtest.cmiccloudr12.com/cmictestrti/ap-rest-api/rest/1/openperiods/?finder=OpenPeriodFinder;CompCodeVar=001' \
--header 'Authorization: Basic Your-User:Pass'

Step 8: Create signed lien waivers (documents)

Request

curl --location --request POST 'https://mobtest.cmiccloudr12.com/cmictestrti/ap-rest-api/rest/1/apinsurance' \
--header 'Content-Type: application/vnd.oracle.adf.resourceItem+json' \
--header 'Authorization: Basic Your-User:Pass' \
--data-raw '{
    "InsComplType": "VEN",
    "InsCompCode": "001",
    "InsInscompCode": "ALTIM",
    "InsVenCode": "1031006",
    "InsCoverTypeCode": "INS",
    "InsVouNum": null,
    "InsCertNum": "1236181821PP",
    "InsAmt": 220000,
    "InsVUuid": ""
}'

Step 9: Create AP invoices

Request

curl --location --request POST 'https://mobtest.cmiccloudr12.com/cmictestrti/ap-rest-api/rest/1/apvoucher' \
--header 'Content-Type: application/vnd.oracle.adf.resourceItem+json' \
--header 'Authorization: Basic Your-User:Pass' \
--data-raw '{
    "VouBchPost": "N",
    "VouCompCode": "001",
    "VouJobCode": "16-001",
    "VouVenCode": "0415",
    "VouContCode": "16-001.001",
    "VouChgCode": "000",
    "VouInvCode": "LZTEST1234",
    "VouInvSeriesCode": "SUBS",
    "VouCurrCode": "USD",
    "VouNum": 1,
    "VouInvAmt": 1,
    "VouInvDate": "2020-10-07",
    "VouDueDate": "2020-11-06",
    "VouPostDate": null,
    "VouFinalRfpFlag": "N",
    "VouPayByManualChqFlag": "N"
}'

Step 10: Create AP manual checks

Request

curl --location --request POST 'https://mobtest.cmiccloudr12.com/cmictestrti/ap-rest-api/rest/1/apvoucher' \
--header 'Content-Type: application/vnd.oracle.adf.resourceItem+json' \
--header 'Authorization: Basic Your-User:Pass' \
--data-raw '{
      
      "ChqAccCode": "1000.100",
      "ChqAmt": 3461,
      "ChqBankCompCode": "ZZ",
      "ChqCompCode": "ZZ",
      "ChqDate": "2022-05-06",
      "ChqDeptCode": "00",
      "ChqDesc": "test",
      "ChqDraftCode": "M",
      "ChqJobCode": "01-UNIQUE1",
      "ChqJointVenName": null,
      "ChqNum": 12371,
      "ChqPayeeAddr1": "1408 sokak",
      "ChqPayeeAddr2": "1",
      "ChqPayeeAddr3": "New York",
      "ChqPayeeCountry": "US",
      "ChqPayeeName1": "Test",
      "ChqPayeeName2": null,
      "ChqPayeePostalCode": "20198",
      "ChqPayeeRegCode": "NY",
      "ChqSeqNum": 5083,
      "ChqVenCode": "10",
      "ChqVouCode": "Y"
}'