Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
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 |
| /batchNo * |
| Inline Model |
PUT | entity * |
ARInvoiceTrfApi
[Description]
/api/ARInvoiceTrfApi | ||||
---|---|---|---|---|
Operation | Logged in User | Parameters | Body | Response |
GET |
| /batchNo * |
| |
PUT | entity * |
BatchTrfApi
Update ExportBatch info.
/api/BatchTrf | ||||
---|---|---|---|---|
Operation | Logged in User | Parameters | Body | Response |
GET |
|
|
| |
POST | listOfBatches * |
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 |
| companyCode* |
|
|
POST | ||||
PUT |
GLJournalTrfApi
JobReceiptTrfApi
/api/JobReceiptTrfApi | ||||
---|---|---|---|---|
Operation | Logged in User | Parameters | Body | Response |
GET |
| jobReceiptId* |
|
|
POST | ||||
PUT |
LogTrfApi
/api/TransferLogTrf and /api/ExportLogTrf | ||||
---|---|---|---|---|
Operation | Logged in User | Parameters | Body | Response |
POST /api/TransferLogTrf Update ExportBatch info. | sessionId* | |||
POST /api/ExportLogTrf Update ExportBatch info. | batchNo* |
Parameters /api/TransferLogTrf
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 |
---|---|---|---|---|
batchNo | batchNo | query | integer | |
exportId | id of the object to export | query | integer | |
exportTable | export table of the batch | query | string | |
type | Info, Warning, Error | transfer log type | query | string |
message | success or error message | query | string |
PaymentTrfApi
/api/PaymentTrfApi | ||||
---|---|---|---|---|
Operation | Logged in User | Parameters | Body | Response |
GET | paymentId* | |||
POST | ||||
PUT |
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 | Determine the Invoice is credit or not. |
BuyerCreated | Boolean | |
Details | String | Details |
ExternalID | String | |
ForExport | Boolean | For exporting or not. |
APInvoiceLinesTrf |
⬆️ 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 | Determine the Invoice is credit or not. |
BuyerCreated | Boolean | |
Details | String | Details |
ExternalID | String | |
ForExport | Boolean | For exporting or not. |
APInvoiceLinesTrf |
⬆️ Back to top
Transfer_APInvoiceLineTrfApiModel
Field | Type | Description |
---|---|---|
ID | Integer | |
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 |
---|---|---|
ID | Integer | |
FinCoCode | String | Financial company code. |
InvoiceNo | Integer | AP invoice id |
CompanyCode | String | Company code. |
BatchNo | Integer | Batch number. |
ClaimNo | Integer | Claim number. |
ApplyNo | Integer | |
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 | |
Details | String | Details |
ExternalID | String | |
ForExport | Boolean | For exporting or not. |
AIRnvoiceLinesTrf |
⬆️ 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 | |
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 | |
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 | |
SubContractor | Boolean | The company is a Subcontractor or not. |
⬆️ Back to top
Transfer_GLJournalTrfApiModel
Field | Type | Description |
---|---|---|
ID | Integer | |
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 | |
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 |
---|---|---|
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 |
---|---|---|
ID | Integer | |
FinCoCode | String | Financial company code. |
PaymentID | Integer | Payment id. |
ExternalID | String | |
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
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Expand | ||
---|---|---|
| ||
|
APInvoiceTrfApi PUT
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Expand | ||
---|---|---|
| ||
|
ARnvoiceTrfApi GET
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Expand | ||
---|---|---|
| ||
|
ARnvoiceTrfApi PUT
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Expand | ||
---|---|---|
| ||
|
BatchTrfApi GET
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Expand | ||
---|---|---|
| ||
|
BatchTrfApi POST
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Expand | ||
---|---|---|
| ||
|
CompanyTrfApi GET
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Expand | ||
---|---|---|
| ||
|
CompanyTrfApi POST
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Expand | ||
---|---|---|
| ||
|
CompanyTrfApi PUT
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Expand | ||
---|---|---|
| ||
|
GLJournalTrfApi GET
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Expand | ||
---|---|---|
| ||
|
GLJournalTrfApi PUT
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Expand | ||
---|---|---|
| ||
|
JobReceiptTrfApi GET
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Expand | ||
---|---|---|
| ||
|
JobReceiptTrfApi POST
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Expand | ||
---|---|---|
| ||
|
JobReceiptTrfApi PUT
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Expand | ||
---|---|---|
| ||
|
LogTrfApi POST /api/TransferLogTrf
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Expand | ||
---|---|---|
| ||
|
LogTrfApi POST /api/ExportLogTrf
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Expand | ||
---|---|---|
| ||
|
PaymentTrfApi
Expand | |||||
---|---|---|---|---|---|
| |||||
|
Expand | ||
---|---|---|
| ||
|
⬆️ Back to top
In this page:
Table of Contents | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|