Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

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

Endpoints

APInvoiceTrfApi

Get or update AP invoices from transfer table.

/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

Transfer_APInvoiceLineTrfApiModel

ARInvoiceTrfApi

[Description]

/api/ARInvoiceTrfApi

Operation

Logged in User

Parameters

Body

Response

GET
Get ARInvoice with ARInvoiceLines from Trf tables using BatchNo.

 

/batchNo *

 

Inline Model

Inline Model 1

Transfer_ARInvoiceLineTrfApiModel

PUT
Update APInvoice with ARInvoiceLines in ARInvoiceTrf and JobInvoice table.

entity *

Transfer_ARInvoiceTrfApiModel

Transfer_ARInvoiceLineTrfApiModel

BatchTrfApi

Update ExportBatch info.

/api/BatchTrf

Operation

Logged in User

Parameters

Body

Response

GET

 

 

 

Inline Model

Inline Model 1

Transfer_ARInvoiceLineTrfApiModel

POST
Update ExportBatch info.

listOfBatches *
exportUserId *

POST Parameters

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

/api/CompanyTrfApi

Operation

Logged in User

Parameters

Body

Response

GET
Retrieve Company from CompanyTrf table by CompanyCode

 

 companyCode*

 

 

POST
Creates Company record to CompanyTrf tables.

PUT
Updates Company record to CompanyTrf tables

GLJournalTrfApi

/api/GLJournalTrfApi

Operation

Logged in User

Parameters

Body

Response

GET

 

 BatchNo

 

 

PUT

JobReceiptTrfApi

/api/JobReceiptTrfApi

Operation

Logged in User

Parameters

Body

Response

GET
Retrieve Job Receipt from JobReceiptTrf table by id

 

 jobReceiptId

 

 

POST
Creates Job Receipt record to JobReceiptTrf tables.

PUT
Updates Job Receipt record to JobReceiptTrf tables

LogTrfApi

/api/TransferLogTrf and /api/ExportLogTrf

Operation

Logged in User

Parameters

Body

Response

POST
/api/TransferLogTrf

POST
/api/ExportLogTrf

PaymentTrfApi

/api/PaymentTrfApi

Operation

Logged in User

Parameters

Body

Response

GET
Retrieve Payment from PaymentTrf table by id.

paymentId

POST
Creates Payment record to PaymentTrf tables.

PUT
Updates Payment record to PaymentTrf tables.

Models

 

Inline Model

Syntax

Inline Model [ Inline Model 1]

⬆️ Back to top

Inline Model 1

Field

Type

Description

ID

Integer

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

BuyerCreated

Boolean

Details

String

Details

ExternalID

String

ForExport

Boolean

For exporting or not.

APInvoiceLinesTrf

Array [Transfer_APInvoiceLineTrfApiModel]

⬆️ Back to top

Transfer_APInvoiceTrfApiModel

Field

Type

Description

ID

Integer

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

BuyerCreated

Boolean

Details

String

Details

ExternalID

String

ForExport

Boolean

For exporting or not.

APInvoiceLinesTrf

Array [Transfer_APInvoiceLineTrfApiModel]

⬆️ Back to top

Transfer_APInvoiceLineTrfApiModel

Field

Type

Description

ID

Integer

FinCoCode

String

Financial company code.

JobTranID

Integer

APInvoiceID

Integer

AP invoice id.

TranDate

String

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

ID

Integer

FinCoCode

String

Financial company code.

InvoiceNo

Integer

AP invoice id

CompanyCode

String

Company code.

BatchNo

Integer

Batch number.

ClaimNo

Integer

Claim number.

YearNo

Integer

Year number.

ApplyNo

Integer

InvoiceRef

String

YearNo

Integer

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

Details

String

Details

ExternalID

String

ForExport

Boolean

For exporting or not.

AIRnvoiceLinesTrf

Array [Transfer_ARInvoiceLineTrfApiModel]

⬆️ Back to top

Transfer_ARInvoiceLineTrfApiModel

Field

Type

Description

ID

Integer

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

ID

Integer

FinCoCode

String

Financial company code.

CompanyCode

String

Company code.

ClientSupplier

Integer

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

ContactSurname

String

Contact_BusinessPhone

String

Contact_MobilePhone

String

Contact_Fax

String

Contact_EmailAddress

String

PostalAddress1

String

PostalAddress2

String

PostalAddress3

String

PostalAddress4

String

PostalAddress5

String

PostalAddress6

String

PostalPhone

String

PostalFax

String

PostalPostCode

String

PhysicalAddress1

String

PhysicalAddress2

String

PhysicalAddress3

String

PhysicalAddress4

String

PhysicalAddress5

String

PhysicalAddress6

String

PhysicalPhone

String

PhysicalFax

String

PhysicalPostCode

String

EmailAddress

String

BankAccountRef1

String

BankAccountRef2

String

BankAccountRef3

String

UseGST

Boolean

BCIFlag

Boolean

Inactive

Boolean

ExternalID

String

SubContractor

Boolean

 ⬆️ Back to top

Example

APInvoiceTrfApi GET

 Response
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)
}
 Response sample
[
  {
    "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

 Response
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)
}
 Response sample

ARnvoiceTrfApi GET

 Response
Inline Model [
Inline Model 1
]
Inline Model 1 {
ID (integer, optional),
FinCoCode (string, optional),
InvoiceNo (integer, optional),
CompanyCode (string, optional),
BatchNo (integer, optional),
ClaimNo (integer, optional),
ApplyNo (integer, optional),
InvoiceRef (string, optional),
YearNo (integer, optional),
PeriodNo (integer, optional),
JobCode (string, optional),
InvoiceDate (string, optional),
PostingDate (string, optional),
DueDate (string, optional),
CurrencyCode (string, optional),
ExchangeRate (number, optional),
InvoiceCredit (integer, optional),
Details (string, optional),
ExternalID (string, optional),
ForExport (boolean, optional),
ARInvoiceLinesTrf (Array[Transfer_ARInvoiceLineTrfApiModel], optional)
}
Transfer_ARInvoiceLineTrfApiModel {
ID (integer, optional),
FinCoCode (string, optional),
InvoiceNo (integer, optional),
InvoiceLineID (integer, optional),
SalesCode (string, optional),
CrGLAccount (string, optional),
TaxCode (string, optional),
LineDescription (string, optional),
Analysis1 (string, optional),
Analysis2 (string, optional),
JobCode (string, optional),
WorkCentreCode (string, optional),
Quantity (number, optional),
Amount (number, optional),
GST (number, optional),
FCAmount (number, optional),
FCGST (number, optional),
TaxCategory (string, optional)
}
 Response sample

BatchTrfApi GET

 Response
Inline Model [
Inline Model 1
]
Inline Model 1 {
ID (integer, optional),
FinCoCode (string, optional),
InvoiceNo (integer, optional),
CompanyCode (string, optional),
BatchNo (integer, optional),
ClaimNo (integer, optional),
ApplyNo (integer, optional),
InvoiceRef (string, optional),
YearNo (integer, optional),
PeriodNo (integer, optional),
JobCode (string, optional),
InvoiceDate (string, optional),
PostingDate (string, optional),
DueDate (string, optional),
CurrencyCode (string, optional),
ExchangeRate (number, optional),
InvoiceCredit (integer, optional),
Details (string, optional),
ExternalID (string, optional),
ForExport (boolean, optional),
ARInvoiceLinesTrf (Array[Transfer_ARInvoiceLineTrfApiModel], optional)
}
Transfer_ARInvoiceLineTrfApiModel {
ID (integer, optional),
FinCoCode (string, optional),
InvoiceNo (integer, optional),
InvoiceLineID (integer, optional),
SalesCode (string, optional),
CrGLAccount (string, optional),
TaxCode (string, optional),
LineDescription (string, optional),
Analysis1 (string, optional),
Analysis2 (string, optional),
JobCode (string, optional),
WorkCentreCode (string, optional),
Quantity (number, optional),
Amount (number, optional),
GST (number, optional),
FCAmount (number, optional),
FCGST (number, optional),
TaxCategory (string, optional)
}
 Response sample

BatchTrfApi POST

 Response
 Response sample

In this page:

  • No labels