Data Transfer APIs

These APIs are for data transferring between Workbench and other systems.

 

Endpoints

APInvoiceTrfApi

Get or update AP records for export from AP transfer table.

/api/APInvoiceTrfApi

/api/APInvoiceTrfApi

Operation

Logged in User

Parameters

Body

Response

GET
Get APInvoice with APInvoiceLines from Trf tables using BatchNo

Sample

 

/batchNo *

 

Inline Model

Inline Model 1

Transfer_APInvoiceLineTrfApiModel

 

PUT
Update APInvoice with APInvoiceLines in APInvoiceTrf and APInvoice table

Sample

 

entity *

Transfer_APInvoiceTrfApiModel

boolean

 

ARInvoiceTrfApi

Get or update AR records for export from AR transfer table.

/api/ARInvoiceTrfApi

/api/ARInvoiceTrfApi

Operation

Logged in User

Parameters

Body

Response

GET
Get ARInvoice with ARInvoiceLines from Trf tables using BatchNo.

Sample

 

/batchNo *

 

Inline Model

Inline Model 1

Transfer_ARInvoiceLineTrfApiModel

PUT
Update APInvoice with ARInvoiceLines in ARInvoiceTrf and JobInvoice table.

Sample

 

entity *

Transfer_ARInvoiceTrfApiModel

boolean

 

BatchTrfApi

Update Batch Status. This API calls a stored procedure that checks the logs as the basis for the status associated to each batch number in the call.

/api/BatchTrf

/api/BatchTrf

Operation

Logged in User

Parameters

Body

Response

POST
Update ExportBatch info.

Sample

 

listOfBatches *
exportUserId *

 

boolean

POST Parameters

Parameter

Value

Description

Parameter Type

Data Type

Parameter

Value

Description

Parameter Type

Data Type

listOfBatches

Required

comma separated list of batches

query

string

exportUserId

Required

userid of user who initiated export

query

integer

 

CompanyTrfApi

Create or Update records in CompanyTrf table. Any records created/updated using this API will be reflected in the Company table and will be available in Web Workbench list of companies

/api/CompanyTrfApi

/api/CompanyTrfApi

Operation

Logged in User

Parameters

Body

Response

GET
Retrieve Company from CompanyTrf table by CompanyCode

Sample

 

 companyCode*

 

Transfer_CompanyTrfApiModel

POST
Creates Company records to CompanyTrf table.

Sample

 

 

Transfer_CompanyTrfApiModel

boolean

PUT
Updates Company records to CompanyTrf table.

Sample

 

 

Transfer_CompanyTrfApiModel

boolean

 

GLJournalTrfApi

Get Journal entry details for exporting.

/api/GLJournalTrfApi

/api/GLJournalTrfApi

Operation

Logged in User

Parameters

Body

Response

GET

Sample

 

 BatchNo *

 

Transfer_GLJournalTrfApiModel

PUT

Sample

 

 

Transfer_GLJournalTrfApiModel

boolean

 

JobReceiptTrfApi

Use to import Job Receipts to Workbench. Create or Update records in JobReceiptTrf table. Any records created/updated using this API will be reflected in the Job Receipts table and will be available in Web Workbench list of receipts when InvoiceNumber matches Job Invoice.

/api/JobReceiptTrfApi

/api/JobReceiptTrfApi

Operation

Logged in User

Parameters

Request Body

Response

GET
Retrieve Job Receipt from JobReceiptTrf table by id

Sample

 

 jobReceiptId*

 

Transfer_JobReceiptTrfApiModel

POST
Creates Job Receipt record to JobReceiptTrf tables.

Sample

 

 

Transfer_JobReceiptTrfApiModel

boolean

PUT
Updates Job Receipt record to JobReceiptTrf tables

Sample

 

 

Transfer_JobReceiptTrfApiModel

boolean

 

LogTrfApi

/api/TransferLogTrf and /api/ExportLogTrf

/api/TransferLogTrf and /api/ExportLogTrf

Operation

Logged in User

Parameters

Body

Response

POST /api/TransferLogTrf

Update ExportBatch info.

Sample

 

sessionId*
description*
batchNo
type (info, warning,error)

 

boolean

POST /api/ExportLogTrf

Update ExportBatch info.

Sample

 

batchNo*
exportId
exportable
message (text)
type (info, warning,error)

 

boolean

 

Parameters /api/TransferLogTrf

Parameter

Value

Description

Parameter Type

Data Type

Parameter

Value

Description

Parameter Type

Data Type

sessionId

 

export session id

query

string

description

 

description

query

string

batchNo

 

batch number

query

integer

type

Info, Warning,  Error       

transfer log type

query

string

 

Parameters /api/ExportLogTrf

Parameter

Value

Description

Parameter Type

Data Type

Parameter

Value

Description

Parameter Type

Data Type

batchNo

 

batchNo

query

integer

exportId

 

id of the object to export

query

integer

exportTable

  1. APInvoices – for both AP Invoice and Credit batches

  2. ARInvoices - for both AR Invoice and Credit batches

  3. GLJournals – for all Journal type batches

export table of the batch

query

string

type

Info, Warning, Error       

transfer log type

query

string

message

 

success or error message

query

string

 

PaymentTrfApi

Use to import Payments to Workbench. Create or Update records in PaymenttTrf table. Any records created/updated using this API will be reflected in the Payments table and will be available in the Web Workbench list of payments when APInvoiceID matches an AP Invoice.

/api/PaymentTrfApi

/api/PaymentTrfApi

Operation

Logged in User

Parameters

Body

Response

GET
Retrieve Payment from PaymentTrf table by id.

Sample

 

paymentId*

 

Transfer_PaymentTrfApiModel

POST
Creates Payment record to PaymentTrf tables.

Sample

 

 

Transfer_PaymentTrfApiModel

boolean

PUT
Updates Payment record to PaymentTrf tables.

Sample

 

 

Transfer_PaymentTrfApiModel

boolean

 

Models

 

Inline Model

Syntax

Syntax

Inline Model [ Inline Model 1]

Back to top

 

Inline Model 1

Field

Type

Description

Field

Type

Description

ID

Integer

Record unique identifier

FinCoCode

String

Financial company code.

APInvoiceID

Integer

AP invoice id.

CompanyCode

String

Company code.

SubcontractCode

String

Subcontract code.

ClaimNo

Integer

Claim number.

BatchNo

Integer

Batch number.

YearNo

Integer

Year number.

PeriodNo

Integer

Financial period number.

JobCode

String

Job code.

InvoiceRef

String

Invoice reference.

InvoiceDate

String

Invoice date.

PostingDate

String

Posting date.

DueDate

String

Due date.

CurrencyCode

String

Currency code.

ExchangeRate

Number

Currency exchange rate.

InvoiceCredit

Integer

Determine whether the Invoice is a Credit or not.
if the value is 1 = invoice
if the value is -1 =  credit

BuyerCreated

Boolean

 

Details

String

Details

ExternalID

String

Record unique identifier from third-party system

ForExport

Boolean

For exporting or not.

APInvoiceLinesTrf

Array [Transfer_APInvoiceLineTrfApiModel]

 

Back to top

 

 

Transfer_APInvoiceTrfApiModel

Field

Type

Description

Field

Type

Description

ID

Integer

Record unique identifier

FinCoCode

String

Financial company code.

APInvoiceID

Integer

AP invoice id

CompanyCode

String

Company code.

SubcontractCode

String

Subcontract code.

ClaimNo

Integer

Claim number.

BatchNo

Integer

Batch number.

YearNo

Integer

Year number.

PeriodNo

Integer

Financial period number.

JobCode

String

Job code.

InvoiceRef

String

Invoice reference.

InvoiceDate

String

Invoice date,

PostingDate

String

Invoice posting date.

DueDate

String

Due date.

CurrencyCode

String

Currency code.

ExchangeRate

Number

Currency exchange rate.

InvoiceCredit

Integer

Determine whether the Invoice is a Credit or not.
if the value is 1 = invoice
if the value is -1 =  credit

BuyerCreated

Boolean

Buyer Created

Details

String

Details

ExternalID

String

Record unique identifier from third-party system

ForExport

Boolean

For exporting or not.

APInvoiceLinesTrf

Array [Transfer_APInvoiceLineTrfApiModel]

 

Back to top

 

Transfer_APInvoiceLineTrfApiModel

Field

Type

Description

Field

Type

Description

ID

Integer

Record unique identifier

FinCoCode

String

Financial company code.

JobTranID

Integer

Job transaction id.

APInvoiceID

Integer

AP invoice id.

TranDate

String

Transaction date.

YearNo

Integer

Year number.

PeriodNo

Integer

Financial period number.

JobCode

String

Job code.

ActivityCode

String

Activity code.

WorkCentreCode

String

Work Centre code.

DrGLAccount

String

Debit Account General Ledger.

TaxCode

String

Tax code.

LineDescription

String

Description of line.

Analysis1

String

 

Analysis2

String

 

Quantity

Number

Quantity.

Cost

Number

Cost.

GST

Number

Tax amount

FCCost

Number

Cost in foreign currency.

FCGST

Number

Foreign currency tax.

TaxCategory

String

Tax category.

Back to top

 

Transfer_ARInvoiceTrfApiModel

Field

Type

Description

Field

Type

Description

ID

Integer

Record unique identifier

FinCoCode

String

Financial company code.

InvoiceNo

Integer

AP invoice id

CompanyCode

String

Company code.

BatchNo

Integer

Batch number.

ClaimNo

Integer

Claim number.

ApplyNo

Integer

Invoice No of the Credit is applied to

InvoiceRef

String

Invoice reference

YearNo

Integer

Year number.

PeriodNo

Integer

Financial period number.

JobCode

String

Job code.

InvoiceDate

String

Invoice date,

PostingDate

String

Invoice posting date.

DueDate

String

Due date.

CurrencyCode

String

Currency code.

ExchangeRate

Number

Currency exchange rate.

InvoiceCredit

Integer

Determine whether the Invoice is a Credit or not.
if the value is 1 = invoice
if the value is -1 =  credit

Details

String

Details

ExternalID

String

Record unique identifier from third-party system

ForExport

Boolean

For exporting or not.

AIRnvoiceLinesTrf

Array [Transfer_ARInvoiceLineTrfApiModel]

 

Back to top

 

Transfer_ARInvoiceLineTrfApiModel

Field

Type

Description

Field

Type

Description

ID

Integer

Record unique identifier

FinCoCode

String

Financial company code.

InvoiceNo

Integer

AR invoice number.

InvoiceLineID

Integer

Invoice line id.

SalesCode

String

Sales code.

CrGLAccount

String

Credit Account General Ledger.

TaxCode

String

Tax code.

LineDescription

String

Line description.

Analysis1

String

 

Analysis2

String

 

JobCode

String

Job code.

WorkCentreCode

String

Work Centre code.

Quantity

Number

Quantity.

Amount

Number

Amount.

GST

Number

Tax amount

FCAmount

Number

Amount in foreign currency.

FCGST

Number

Foreign currency tax.

TaxCategory

String

Tax category.

Back to top

 

Transfer_CompanyTrfApiModel

Field

Type

Description

Field

Type

Description

ID

Integer

Record unique identifier

FinCoCode

String

Financial company code.

CompanyCode

String

Company code.

ClientSupplier

Integer

Use to identify if the Company is a client or supplier

1 = Client

0 = Supplier

CompanyName

String

Company name.

AlphaCode

String

The company shorthand code.

CurrencyCode

String

Currency code.

PaymentTermsDays

Integer

The numerical value for days.

PaymentTermsType

Integer

The payment terms for Job Sales Invoices to this company.

GSTNumber

String

Tax number

ContactFirstName

String

Contact first name.

ContactSurname

String

Contact Surname.

Contact_BusinessPhone

String

Contact business phone.

Contact_MobilePhone

String

Contact mobile number.

Contact_Fax

String

Contact fax number.

Contact_EmailAddress

String

Contact email address.

PostalAddress1

String

Postal address fields

PostalAddress2

String

PostalAddress3

String

PostalAddress4

String

PostalAddress5

String

PostalAddress6

String

PostalPhone

String

Postal phone number.

PostalFax

String

Postal fax number.

PostalPostCode

String

Postal Post code.

PhysicalAddress1

String

Physical address fields.

PhysicalAddress2

String

PhysicalAddress3

String

PhysicalAddress4

String

PhysicalAddress5

String

PhysicalAddress6

String

PhysicalPhone

String

Physical address phone

PhysicalFax

String

Physical address fax.

PhysicalPostCode

String

Physical address Post code.

EmailAddress

String

Email address

BankAccountRef1

String

Reference fields if needed to store account details. More

BankAccountRef2

String

BankAccountRef3

String

UseGST

Boolean

Include tax on any sales to this company or not.

BCIFlag

Boolean

Use Buyer Created Invoice or not.

Inactive

Boolean

The company is inactive or not.

ExternalID

String

Record unique identifier from third-party system

SubContractor

Boolean

The company is a Subcontractor or not.

  Back to top

 

Transfer_GLJournalTrfApiModel

Field

Type

Description

Field

Type

Description

ID

Integer

Record unique identifier

FinCoCode

String

Financial company code.

JobTranID

Integer

Job transaction id.

BatchNo

Integer

Batch number.

BatchType

String

Batch type.

YearNo

Integer

Year number.

PeriodNo

Integer

Financial period number.

BatchReference

String

Batch reference.

TranDate

String

Transaction date.

PostingDate

String

Posting date.

GLCode

String

GL Account Code

LineDescription

String

Line description.

Analysis1

String

 

Analysis2

String

 

Quantity

Number

Quantity.

Amount

Number

Amount

GST

Number

Tax.

GSTTypeCode

String

Taxe type code.

Back to top

 

Transfer_JobReceiptTrfApiModel

Field

Type

Description

Field

Type

Description

ID

Integer

 

FinCoCode

String

Financial company code.

JobReceiptID

Integer

Job receipt id.

ExternalID

String

 

InvoiceNumber

Integer

Invoice number.

ReceiptNumber

String

Receipt number.

ReceiptReference

String

Receipt reference.

ReceiptDate

String

Receipt date.

BatchNo

Integer

Batch number.

YearNo

Integer

Year number.

PeriodNo

Integer

Financial period number.

Amount

Number

Amount.

LineDescription

String

Line description.

Back to top

 

Transfer_PaymentTrfApiModel

Field

Type

Description

Field

Type

Description

ID

Integer

Record unique identifier

FinCoCode

String

Financial company code.

PaymentID

Integer

Payment id.

ExternalID

String

Record unique identifier from third-party system

APInvoiceID

Integer

AP invoices id.

PaymentReference

String

Payment reference.

PaymentDate

String

Payment date.

Amount

Number

Amount.

LineDescription

String

Line description.

Back to top

 

 

Example

APInvoiceTrfApi GET

Inline Model [ Inline Model 1 ] Inline Model 1 { ID (integer, optional), FinCoCode (string, optional), APInvoiceID (integer, optional), CompanyCode (string, optional), SubcontractCode (string, optional), ClaimNo (integer, optional), BatchNo (integer, optional), YearNo (integer, optional), PeriodNo (integer, optional), JobCode (string, optional), InvoiceRef (string, optional), InvoiceDate (string, optional), PostingDate (string, optional), DueDate (string, optional), CurrencyCode (string, optional), ExchangeRate (number, optional), InvoiceCredit (integer, optional), BuyerCreated (boolean, optional), Details (string, optional), ExternalID (string, optional), ForExport (boolean, optional), APInvoiceLinesTrf (Array[Transfer_APInvoiceLineTrfApiModel], optional) } Transfer_APInvoiceLineTrfApiModel { ID (integer, optional), FinCoCode (string, optional), JobTranID (integer, optional), APInvoiceID (integer, optional), TranDate (string, optional), YearNo (integer, optional), PeriodNo (integer, optional), JobCode (string, optional), ActivityCode (string, optional), WorkCentreCode (string, optional), DrGLAccount (string, optional), TaxCode (string, optional), LineDescription (string, optional), Analysis1 (string, optional), Analysis2 (string, optional), Quantity (number, optional), CostRate (number, optional), Cost (number, optional), GST (number, optional), FCCost (number, optional), FCGST (number, optional), TaxCategory (string, optional) }
[ { "ID": 162, "FinCoCode": "01", "APInvoiceID": 1501, "CompanyCode": "20010", "SubcontractCode": "6126002", "ClaimNo": 1, "BatchNo": 224030, "YearNo": 2024, "PeriodNo": 2, "JobCode": "6126", "InvoiceRef": "6126002-1", "InvoiceDate": "2023-08-31T00:00:00", "PostingDate": "2023-08-31T00:00:00", "DueDate": "2023-09-28T00:00:00", "CurrencyCode": "AUD", "ExchangeRate": 1, "InvoiceCredit": 1, "BuyerCreated": false, "Details": "BOC LIMITED2345678921234567893123456789412345678951 - Batch: 224030", "ForExport": false, "APInvoiceLinesTrf": [ { "ID": 183, "FinCoCode": "01", "JobTranID": 26399, "APInvoiceID": 1501, "TranDate": "2023-08-31T00:00:00", "YearNo": 2024, "PeriodNo": 2, "JobCode": "6126", "ActivityCode": "6-1000", "WorkCentreCode": "LAB", "DrGLAccount": "6-1100", "TaxCode": "GST", "LineDescription": "BOC LIMITED2345678921234567893123456789412345678951; 6126/6-1000/LAB;224030", "Analysis2": "6126", "Quantity": 5, "CostRate": 20, "Cost": 100, "GST": 10, "FCCost": 100, "FCGST": 10 }, { "ID": 184, "FinCoCode": "01", "JobTranID": 26400, "APInvoiceID": 1501, "TranDate": "2023-08-31T00:00:00", "YearNo": 2024, "PeriodNo": 2, "JobCode": "ZRET", "ActivityCode": "ZRET", "WorkCentreCode": "ZRET", "DrGLAccount": "1-0000", "TaxCode": "INPUT", "LineDescription": "BOC LIMITED2345678921234567893123456789412345678951; ZRET/ZRET/ZRET;224030", "Analysis2": "6126", "Quantity": 1, "CostRate": -10, "Cost": -10, "GST": -1, "FCCost": -10, "FCGST": -1 } ] }, { "ID": 163, "FinCoCode": "01", "APInvoiceID": 1502, "CompanyCode": "20010", "SubcontractCode": "6126002", "ClaimNo": 2, "BatchNo": 224030, "YearNo": 2024, "PeriodNo": 2, "JobCode": "6126", "InvoiceRef": "6126002-2", "InvoiceDate": "2023-08-31T00:00:00", "PostingDate": "2023-08-31T00:00:00", "DueDate": "2023-09-28T00:00:00", "CurrencyCode": "AUD", "ExchangeRate": 1, "InvoiceCredit": 1, "BuyerCreated": false, "Details": "BOC LIMITED2345678921234567893123456789412345678951 - Batch: 224030", "ForExport": false, "APInvoiceLinesTrf": [ { "ID": 185, "FinCoCode": "01", "JobTranID": 26401, "APInvoiceID": 1502, "TranDate": "2023-08-31T00:00:00", "YearNo": 2024, "PeriodNo": 2, "JobCode": "ZRET", "ActivityCode": "ZRET", "WorkCentreCode": "ZRET", "DrGLAccount": "1-0000", "TaxCode": "GST", "LineDescription": "BOC LIMITED2345678921234567893123456789412345678951; ZRET/ZRET/ZRET;224030", "Analysis2": "6126", "Quantity": 1, "CostRate": 8, "Cost": 8, "GST": 0.8, "FCCost": 8, "FCGST": 0.8 } ] } ]

APInvoiceTrfApi PUT

Transfer_APInvoiceTrfApiModel { ID (integer, optional), FinCoCode (string, optional), APInvoiceID (integer, optional), CompanyCode (string, optional), SubcontractCode (string, optional), ClaimNo (integer, optional), BatchNo (integer, optional), YearNo (integer, optional), PeriodNo (integer, optional), JobCode (string, optional), InvoiceRef (string, optional), InvoiceDate (string, optional), PostingDate (string, optional), DueDate (string, optional), CurrencyCode (string, optional), ExchangeRate (number, optional), InvoiceCredit (integer, optional), BuyerCreated (boolean, optional), Details (string, optional), ExternalID (string, optional), ForExport (boolean, optional), APInvoiceLinesTrf (Array[Transfer_APInvoiceLineTrfApiModel], optional) } Transfer_APInvoiceLineTrfApiModel { ID (integer, optional), FinCoCode (string, optional), JobTranID (integer, optional), APInvoiceID (integer, optional), TranDate (string, optional), YearNo (integer, optional), PeriodNo (integer, optional), JobCode (string, optional), ActivityCode (string, optional), WorkCentreCode (string, optional), DrGLAccount (string, optional), TaxCode (string, optional), LineDescription (string, optional), Analysis1 (string, optional), Analysis2 (string, optional), Quantity (number, optional), CostRate (number, optional), Cost (number, optional), GST (number, optional), FCCost (number, optional), FCGST (number, optional), TaxCategory (string, optional) }

 

ARnvoiceTrfApi GET

ARnvoiceTrfApi PUT

BatchTrfApi POST

CompanyTrfApi GET

CompanyTrfApi POST

CompanyTrfApi PUT

GLJournalTrfApi GET

GLJournalTrfApi PUT

JobReceiptTrfApi GET

 

JobReceiptTrfApi POST

 

JobReceiptTrfApi PUT

 

LogTrfApi POST /api/TransferLogTrf

 

LogTrfApi POST /api/ExportLogTrf

 

PaymentTrfApi

 

 

Back to top

 

Mapping

Mapping of batch types and the corresponding transfer API endpoint to consume. 

Batch Types

Transfer API endpoint

ApInvoice

APInvoiceTrfApi

ApCredit

SubClaim

ArInvoice

ARInvoiceTrfApi

ArCredit

Adjustment

GLJournalTrfApi

WipAccrual

CccAccrual

PoAccrual

Disbursement

PlantIssue

Docket

Timesheet

StockReturn

StockIssue

StockTrf

StockAdjust

StockQty

StockValue

 

Back to top

 

Diagram

Exporting batches to third-party system via Data transfer API