Subcontract Progress Payments
- 13 Mar 2024
- 1 Minute to read
- Print
- DarkLight
Subcontract Progress Payments
- Updated on 13 Mar 2024
- 1 Minute to read
- Print
- DarkLight
Article Summary
Share feedback
Thanks for sharing your feedback!
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"
}'