Error itgendoc001X
xMsg javascript has not been loaded.
Visma Severa API Data Model|
InvoiceOriginDetailsByInvoiceGUID: Visma Severa Invoice Origin Details by Invoice GUID |
Contents Previous Home Next More |
Catalog: Severa
Schema: API
Label: Invoice Origin Details by Invoice GUID
This is a read-only table function. The Visma Severa API may not support changing the data or the Invantive SQL driver for Visma Severa does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Visma Severa API.
Action: http://soap.severa.com/IInvoice/GetInvoiceOriginDetailsByInvoiceGUID
Topic: GetInvoiceOriginDetailsByInvoiceGUID
Base XPath: /s:Envelope/s:Body/tns:GetInvoiceOriginDetailsByInvoiceGUIDResponse/tns:GetInvoiceOriginDetailsByInvoiceGUIDResult
Filters on API Server: invoiceGUID
Table Function Parameters
The following parameters can be used to control the behaviour of the table function InvoiceOriginDetailsByInvoiceGUID. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be treated using their default values.
Value specification by position is done by listing all values from the first to the last needed value. For example with `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.
Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.
Name |
Data Type |
Required |
Default Value |
Documentation |
|---|---|---|---|---|
invoiceGUID |
string |
☐ |
|
|
Table Function Columns
The columns of the table function InvoiceOriginDetailsByInvoiceGUID are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_ACCOUNTGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_ACCOUNTNAME |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_ACCOUNTNUMBER |
int64 |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_BILLINGADDRESS |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_BILLINGADDRESSGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_BILLINGINTERNALNOTES |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_BILLINGNOTESBEFOREGRID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_BUSINESSUNITGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_BUSINESSUNITNAME |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_BUSINESSUNITNUMBER |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_CASECOMPANYCURRENCYGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_CASENUMBER |
int64 |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_CASEOWNERUSERCODE |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_CASEOWNERUSERGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_CLOSEDDATE |
datetime |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_COMPLETIONESTIMATE |
int32 |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_CONTACTGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_COSTCENTERGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_COSTCENTERNUMBER |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_CURRENCYGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_CURRENCYSHORTFORM |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_CURRENCYSHORTFORMOFCASECOMPANYCURRENCY |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_CURRENTCASESTATUSDESCRIPTION |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_CURRENTCASESTATUSGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_CURRENTCASESTATUSINSERTTS |
datetime |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_DEADLINEDATE |
datetime |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_DESCRIPTION |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_EXPECTEDVALUE |
decimal |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_GUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_INCLUDEEXCEPTIONS |
boolean |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_INCLUDEOVERTIME |
boolean |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_INSERTTS |
datetime |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_INTERNALNAME |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_INVOICETEMPLATEGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_ISCLOSED |
boolean |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_ISDAILYALLOWANCEBILLABLE |
boolean |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_ISINTERNAL |
boolean |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_ISMILEAGEBILLABLE |
boolean |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_ISOTHERTRAVELEXPENSESBILLABLE |
boolean |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_LATESTESTIMATIONDATE |
datetime |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_LEADRATING |
int32 |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_LEADSOURCEGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_NAME |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_ORDERNUMBER |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_OURREFERENCE |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_OVERDUEINTEREST |
decimal |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PAYMENTTERM |
int32 |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_CASEGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_CODE |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_DEADLINE |
datetime |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_DESCRIPTION |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_FLATRATE_ADDITIONALHOURSUNITPRICE |
decimal |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_FLATRATE_AREADDITIONALHOURSBILLABLE |
boolean |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_FLATRATE_HOURS |
decimal |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_FLATRATE_PRICE |
decimal |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_GUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_ISCOMPLETED |
boolean |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_ISLOCKED |
boolean |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_NAME |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_ORIGINALDEADLINE |
datetime |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_ORIGINALPLANNEDSTARTDATE |
datetime |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_ORIGINALWORKESTIMATE |
decimal |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_OWNERUSERGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_PARENTPHASEGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_PLANNEDSTARTDATE |
datetime |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_PRICEPERHOUR |
decimal |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_SORTORDER |
int32 |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_WORKESTIMATE |
decimal |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PHASES_PHASE_WORKTYPEGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PRICELISTGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PRICINGRULE |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PRICINGTYPE |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PRIORITY |
int32 |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_PROBABILITY |
int32 |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_ROOTTASKGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_SALESCLOSEDATE |
datetime |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_SALESPERSONUSERCODE |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_SALESPERSONUSERGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_SALESPROCESSGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_SALESSTATUSGUID |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_SHAREDTOEXTRANET |
boolean |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_STARTDATE |
datetime |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_UPDATEDTS |
datetime |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_URLTOCASE |
string |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_USEDEFAULTPRODUCTSINWORKTIMEENTRY |
boolean |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_USEDEFAULTWORKTYPES |
boolean |
|
|
|
CASES_INVOICEORIGINDETAILS.CASEDETAILS_YOURREFERENCE |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_ACCOUNTGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_CASEBUSINESSUNITCODE |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_CASECOSTCENTERIDENTIFIER |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_CASEGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_CASENAME |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_CASENUMBER |
int64 |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_COSTCURRENCYSHORTFORM |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_COSTCURRENCYSHORTFORMOFINVOICINGCURRENCY |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_COSTCURRENCYSHORTFORMOFORGANIZATIONCURRENCY |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_COSTCURRENCYSHORTFORMOFUSERCOMPANYCURRENCY |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_DESCRIPTION |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_ENDTIME |
datetime |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_EVENTDATE |
datetime |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_GUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_INVOICEDESCRIPTION |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_INVOICEGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_INVOICEQUANTITY |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_INVOICEROWGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_ISAPPROVED |
boolean |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_ISBILLABLE |
boolean |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_ISPRODUCTIVE |
boolean |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_ISREADONLY |
boolean |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_OVERTIMECODE |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_OVERTIMEGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_PHASEGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_PRICECURRENCYSHORTFORMOFCASECOMPANYCURRENCY |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_PRICECURRENCYSHORTFORMOFINVOICINGCURRENCY |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_PRICECURRENCYSHORTFORMOFORGANIZATIONCURRENCY |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_PRICECURRENCYSHORTFORMOFUSERCOMPANYCURRENCY |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_QUANTITY |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_STARTTIME |
datetime |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_TASKGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_UNITCOST |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_UNITCOSTININVOICINGCURRENCY |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_UNITCOSTINORGANIZATIONCURRENCY |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_UNITCOSTINUSERCOMPANYCURRENCY |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_UNITPRICE |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_UNITPRICEINBASECURRENCY |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_UNITPRICEINCASECOMPANYCURRENCY |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_UNITPRICEINUSERCOMPANYCURRENCY |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_USEINVOICEQUANTITY |
boolean |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_USERBUSINESSUNITCODE |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_USERCODE |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_USERFIRSTNAME |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_USERGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_USERLASTNAME |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_WORKTYPECODE |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_HOURENTRIES_HOURENTRY_WORKTYPEGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_INVOICEROWGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_BILLINGDEPENDENCYTASKGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_BILLINGSCHEDULE |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_CASEGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_CASENUMBER |
int64 |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_COSTCENTERGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_COSTCENTERIDENTIFIER |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_COSTCURRENCYSHORTFORM |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_COSTCURRENCYSHORTFORMOFINVOICINGCURRENCY |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_COSTCURRENCYSHORTFORMOFORGANIZATIONCURRENCY |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_COSTCURRENCYSHORTFORMOFUSERCOMPANYCURRENCY |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_DESCRIPTION |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_DISPLAYPERIODSTART |
datetime |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_EVENTDATE |
datetime |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_GUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_INVOICEDESCRIPTION |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_INVOICEGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_INVOICEQUANTITY |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_INVOICEROWGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_ISAPPROVED |
boolean |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_ISBILLABLE |
boolean |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_ISOUTSOURCINGCOST |
boolean |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_ISREADONLY |
boolean |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_ISREALISED |
boolean |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_MEASUREMENTUNIT |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_NAME |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_ORDERDATE |
datetime |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_PLANNEDBILLINGDATE |
datetime |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_PRICECURRENCYSHORTFORMOFCASECOMPANYCURRENCY |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_PRICECURRENCYSHORTFORMOFINVOICINGCURRENCY |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_PRICECURRENCYSHORTFORMOFORGANIZATIONCURRENCY |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_PRICECURRENCYSHORTFORMOFUSERCOMPANYCURRENCY |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_PRODUCTCODE |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_PRODUCTGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_PRODUCTTYPE |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_PURCHASEORDERNUMBER |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_PURCHASEVAT |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_QUANTITY |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_RECURRENCEENDDATE |
datetime |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_RECURRENCEENDTYPE |
int32 |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_RECURRENCEFREQUENCY |
int32 |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_RECURRENCESTARTDATE |
datetime |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_RECURRENCETIMES |
int32 |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_RECURRINGITEMGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_SALESACCOUNTGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_SALESSTATUSGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_TASKGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_TRAVELENDTIME |
datetime |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_TRAVELSTARTTIME |
datetime |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_UNITCOST |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_UNITCOSTININVOICINGCURRENCY |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_UNITCOSTINORGANIZATIONCURRENCY |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_UNITCOSTINUSERCOMPANYCURRENCY |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_UNITCOSTVATINCLUDEDAMOUNT |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_UNITPRICE |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_UNITPRICEINBASECURRENCY |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_UNITPRICEINCASECOMPANYCURRENCY |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_UNITPRICEINUSERCOMPANYCURRENCY |
decimal |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_USERCODE |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_USERGUID |
string |
|
|
|
INVOICEROWORIGINS_INVOICEORIGINDETAILS.INVOICEROWORIGIN_ITEMS_ITEM_VAT |
decimal |
|
|
|
06-04-2021 14:32 Version 20.1.393-BETA+3152
