...
...
This API as been Deprecated, use instead Service Order Integration
Short Description
The objective of the Disbursement Account (DA) integration is to transfer port call and port cost data between Dataloy VMS and an agency system in order to correctly assign port costs to the correct port call, vessel and voyage and import this data into the VMS.
Chapter Contents:
Table of Contents | ||||||||
---|---|---|---|---|---|---|---|---|
|
...
Property | Type | Length | Mandatory | Description | Comments | |||
---|---|---|---|---|---|---|---|---|
portCall | /PortCall | Yes | Identifier for DA port call. | Port Call ID is to be transferred in the appointment resource. Port Call ID Testing: Dataloy VMS: Booking and Operations > Right-click a Port Call > Select Row > Audit Log > Copy Port Call Record ID. | ||||
businessPartner | /BusinessPartner | Yes | Code for the business partner/agent. | Dataloy Agent Codes have to be retreived from Dataloy VMS. | ||||
agentTypeCode | /PortAgentType | Code of the agent type. | ||||||
proformaReference | String | 16 | Proforma reference. | |||||
invoiceReference | String | 16 | Yes | Invoice reference/DA reference. | ||||
invoiceDate | Date | Invoice date. | ||||||
currency | /Currency | Yes | Currency of the DA. | |||||
exchangeRate | /ExchangeRate | Exchange rate from the DA currency to the voyage currency. | ||||||
status | /StatusType | Yes | Status of the DA (see DA Status List). | |||||
costItems | Array of /CostItem | Yes |
AnchorcostItemFields costItemFields
Properties
costItemFields | |
costItemFields |
Property | Type | Length | Mandatory | Description | Comments | ||
---|---|---|---|---|---|---|---|
accountCode | /PortCostCode/HandlingCostCode/VariousText | Yes | Account code of the cost. | ||||
amount | Double | Yes | Cost amount in DA currency. | ||||
comment | String | 1024 | Comment related to the cost. | ||||
costItemKey | String | 16 | Yes | Identifier of this cost in the agency system. | A key from the agency system on line level. This is for the API to distinguish the lines and update the correct one in the different phases estimate, revised and final. | ||
isOwnersCost | Boolean | True if this is an owner's cost. | ONLY applicable to costs with port cost account code. | ||||
isCharterersCost | Boolean | True if this is a charterer's cost. | ONLY applicable to costs with port cost account code. |
...
Inserting (or Updating) a Disbursement Account (DA)
- To insert (or update) a disbursement account (DA) into Dataloy VMS post a populated JSON message (see JSON example) to the Dataloy API.
- Fields required to be populated when posting a DA to Dataloy VMS: portCall, businessPartner, invoiceReference, currency, status, accountCode, costItemKey.
Note: When updating an existing DisbursementAccount, unchanged properties (except required fields) need not be updated. The insertion process is shown in Fig. 1 (see Validations).
ValidationsAnchor val1 val1
Prior to inserting/updating the DA in Dataloy VMS, the following validations will be performed on the JSON message:- Are the required fields populated?
- Yes: Continue Insertion.
- No: Nothing is inserted and a HTTP status code is returned.
- Does the Port Call, Business Partner, Agent Type (if populated), Currency and Status exist in Dataloy VMS?
- Yes: Continue Insertion.
- No: Nothing is inserted and a HTTP status code is returned. Also, the status codes are returned in the HTTP header, additional information will be provided in the body in JSON format.
- Does the account code exist in Dataloy and is it unique?
- Yes: Continue Insertion.
- No: Nothing is inserted and a HTTP status code is returned. Also, the status codes are returned in the HTTP header, additional information will be provided in the body in JSON format.
Fig. 1Anchor fig1 fig1 - Are the required fields populated?
- Inserting (or Updating) a Proforma Disbursement Account (PDA)
- Populate the status field in the JSON message with EST (Estimate) and post a DA JSON message to the Dataloy API.
Note: The status field must be populated with EST in order for the VMS to treat it as a PDA. - Validate the JSON message.
- Validated: Insert Disbursement Account (DA).
- Not validated: Return Error.
- Inserting (or Updating) a Revised Disbursement Account (RDA)
- Populate the status field in the JSON message with REV (Revised) and post a DA JSON message to the Dataloy API.
Note: The status field must be populated with REVin order for the VMS to treat it as a RDA. - Validate the JSON message.
- Validated: Insert Disbursement Account (DA).
- Not validated: Return Error
- Inserting (or Updating) a Final Disbursement Account (FDA)
- Populate the status field in the JSON message with FIN (Final) and post a DA JSON message to the Dataloy API.
Note: The status field must be populated with FIN in order for the VMS to treat it as a FDA. - Validate the JSON message.
- Validated: Insert Disbursement Account (DA).
- Not validated: Return Error.
...
Note: Currently the disbursement account (DA) stage (PDA etc.) cannot display in Dataloy VMS. However, if the amounts are estimates, the Amount LC (Estimated) column is populated. If they are revised/final amounts, the Amount LC (Revised)/Amount LC (Actual) column is populated. This ONLY applies to Port Cost and Handling Cost. The Various costs has ONLY a single amount, i.e. NO estimate/revised amounts. The examples of inserted disbursement accounts in Figures 2, 3 and 4 all shows where the DAs in the JSON example are inserted in Dataloy VMS.
...
Fig. 3: DA Handling Costs
Fig 4: DA Various Costs
Related Content
Expand | ||
---|---|---|
| ||
|