Skip to Content

Dynamics GP Connection Details

Introduction

Connector Version

This documentation is based on version 23.0.8663 of the connector.

Get Started

Microsoft Dynamics GP Version Support

The connector leverages the Dynamics GP Web services APIs to access Microsoft Dynamics GP 2010, 2013, and 2015. Web services must be enabled for your instance.

Establish a Connection

Connect to Microsoft Dynamics GP

To connect set URL to the Web services endpoint; for example, http://{servername}:{port}/Dynamics/GPService. Additionally, set CompanyId to the unique identifier of the company you are connecting to. You can obtain this value by querying the Company table and leaving the property empty.

Authenticate to Microsoft Dynamics GP

The Microsoft Dynamics GP data source supports the following authentication methods:

  • Anonymous Authentication
  • WS-Security (WSS) Authentication
  • Basic Authentication
  • NTLM User Authentication
  • Digest
  • Negotiate (Kerberos)
Anonymous Authentication

In some situations, you can connect to Microsoft Dynamics GP without setting any authentication connection properties. To do so, set the AuthScheme to None, and you are ready to connect.

WS-Security (WSS)

Set the User and Password to connect and set AuthScheme to WSS.

Note

WSS Authentication is the default authentication scheme.

Basic

Set the User and Password to connect and set AuthScheme to Basic.

Windows (NTLM)

Set the Windows User and Password to connect and set AuthScheme to NTLM.

Digest

Set the User and Password to connect and set AuthScheme to Digest.

Kerberos

See Using Kerberos for details on how to authenticate with Kerberos.

Fine Tuning Data Access

The connector returns data summaries by default to save performance. Set LookupIds to true to return details such as line items; however, note that entities must be retrieved one at a time.

Use Kerberos

This section shows how to use the connector to authenticate using Kerberos.

Kerberos

To authenticate to Microsoft Dynamics GP using Kerberos, set the following properties:

  • AuthScheme: Set this to NEGOTIATE.
  • KerberosKDC: Set this to the host name or IP Address of your Kerberos KDC machine.
  • KerberosRealm: Set this to the realm of the Microsoft Dynamics GP Kerberos principal. This will be the value after the '@' symbol (for instance, EXAMPLE.COM) of the principal value (for instance, ServiceName/MyHost@EXAMPLE.COM).
  • KerberosSPN: Set this to the service and host of the Microsoft Dynamics GP Kerberos Principal. This is the value prior to the '@' symbol (for instance, ServiceName/MyHost) of the principal value (for instance, ServiceName/MyHost@EXAMPLE.COM).

Retrieve the Kerberos Ticket

You can use one of the following options to retrieve the required Kerberos ticket.

MIT Kerberos Credential Cache File

This option enables you to use the MIT Kerberos Ticket Manager or kinit command to get tickets. Note that you do not need to set the User or Password connection properties with this option.

  1. Ensure that you have an environment variable created called KRB5CCNAME.
  2. Set the KRB5CCNAME environment variable to a path pointing to your credential cache file (for instance, C:\krb_cache\krb5cc_0 or /tmp/krb5cc_0). This file is created when generating your ticket with MIT Kerberos Ticket Manager.
  3. To obtain a ticket, open the MIT Kerberos Ticket Manager application, click Get Ticket, enter your principal name and password, then click OK. If successful, ticket information appears in Kerberos Ticket Manager and is stored in the credential cache file.
  4. Now that you have created the credential cache file, the connector uses the cache file to obtain the Kerberos ticket to connect to Microsoft Dynamics GP.

As an alternative to setting the KRB5CCNAME environment variable, you can directly set the file path using the KerberosTicketCache property. When set, the connector uses the specified cache file to obtain the Kerberos ticket to connect to Microsoft Dynamics GP.

Keytab File

If the KRB5CCNAME environment variable has not been set, you can retrieve a Kerberos ticket using a Keytab File. To do so, set the User property to the desired username and set the KerberosKeytabFile property to a file path pointing to the keytab file associated with the user.

User and Password

If both the KRB5CCNAME environment variable and the KerberosKeytabFile property have not been set, you can retrieve a ticket using a user and password combination. To do this, set the User and Password properties to the user/password combination that you use to authenticate with Microsoft Dynamics GP.

Cross-Realm

More complex Kerberos environments may require cross-realm authentication where multiple realms and KDC servers are used (e.g., where one realm/KDC is used for user authentication and another realm/KDC is used for obtaining the service ticket).

In such an environment, set the KerberosRealm and KerberosKDC properties to the values required for user authentication. Also set the KerberosServiceRealm and KerberosServiceKDC properties to the values required to obtain the service ticket.

Important Notes

Configuration Files and Their Paths

  • All references to adding configuration files and their paths refer to files and locations on the Harmony Agent where the connector is installed. These paths are to be adjusted as appropriate depending on the agent and the operating system. If multiple agents are used in an agent group, identical files will be required on each agent.

Advanced Features

This section details a selection of advanced features of the Microsoft Dynamics GP connector.

User Defined Views

The connector allows you to define virtual tables, called user defined views, whose contents are decided by a pre-configured query. These views are useful when you cannot directly control queries being issued to the drivers. See User Defined Views for an overview of creating and configuring custom views.

SSL Configuration

Use SSL Configuration to adjust how connector handles TLS/SSL certificate negotiations. You can choose from various certificate formats; see the SSLServerCert property under "Connection String Options" for more information.

Proxy

To configure the connector using Private Agent proxy settings, select the Use Proxy Settings checkbox on the connection configuration screen.

Query Processing

The connector offloads as much of the SELECT statement processing as possible to Microsoft Dynamics GP and then processes the rest of the query in memory (client-side).

See Query Processing for more information.

User Defined Views

The Jitterbit Connector for Microsoft Dynamics GP allows you to define a virtual table whose contents are decided by a pre-configured query. These are called User Defined Views, which are useful in situations where you cannot directly control the query being issued to the driver, e.g. when using the driver from Jitterbit. The User Defined Views can be used to define predicates that are always applied. If you specify additional predicates in the query to the view, they are combined with the query already defined as part of the view.

There are two ways to create user defined views:

  • Create a JSON-formatted configuration file defining the views you want.
  • DDL statements.

Define Views Using a Configuration File

User Defined Views are defined in a JSON-formatted configuration file called UserDefinedViews.json. The connector automatically detects the views specified in this file.

You can also have multiple view definitions and control them using the UserDefinedViews connection property. When you use this property, only the specified views are seen by the connector.

This User Defined View configuration file is formatted as follows:

  • Each root element defines the name of a view.
  • Each root element contains a child element, called query, which contains the custom SQL query for the view.

For example:

{
    "MyView": {
        "query": "SELECT * FROM Customer WHERE MyColumn = 'value'"
    },
    "MyView2": {
        "query": "SELECT * FROM MyTable WHERE Id IN (1,2,3)"
    }
}

Use the UserDefinedViews connection property to specify the location of your JSON configuration file. For example:

"UserDefinedViews", "C:\Users\yourusername\Desktop\tmp\UserDefinedViews.json"

Define Views Using DDL Statements

The connector is also capable of creating and altering the schema via DDL Statements such as CREATE LOCAL VIEW, ALTER LOCAL VIEW, and DROP LOCAL VIEW.

Create a View

To create a new view using DDL statements, provide the view name and query as follows:

CREATE LOCAL VIEW [MyViewName] AS SELECT * FROM Customers LIMIT 20;

If no JSON file exists, the above code creates one. The view is then created in the JSON configuration file and is now discoverable. The JSON file location is specified by the UserDefinedViews connection property.

Alter a View

To alter an existing view, provide the name of an existing view alongside the new query you would like to use instead:

ALTER LOCAL VIEW [MyViewName] AS SELECT * FROM Customers WHERE TimeModified > '3/1/2020';

The view is then updated in the JSON configuration file.

Drop a View

To drop an existing view, provide the name of an existing schema alongside the new query you would like to use instead.

DROP LOCAL VIEW [MyViewName]

This removes the view from the JSON configuration file. It can no longer be queried.

Schema for User Defined Views

User Defined Views are exposed in the UserViews schema by default. This is done to avoid the view's name clashing with an actual entity in the data model. You can change the name of the schema used for UserViews by setting the UserViewsSchemaName property.

Work with User Defined Views

For example, a SQL statement with a User Defined View called UserViews.RCustomers only lists customers in Raleigh:

SELECT * FROM Customers WHERE City = 'Raleigh';

An example of a query to the driver:

SELECT * FROM UserViews.RCustomers WHERE Status = 'Active';

Resulting in the effective query to the source:

SELECT * FROM Customers WHERE City = 'Raleigh' AND Status = 'Active';

That is a very simple example of a query to a User Defined View that is effectively a combination of the view query and the view definition. It is possible to compose these queries in much more complex patterns. All SQL operations are allowed in both queries and are combined when appropriate.

SSL Configuration

Customize the SSL Configuration

By default, the connector attempts to negotiate SSL/TLS by checking the server's certificate against the system's trusted certificate store.

To specify another certificate, see the SSLServerCert property for the available formats to do so.

Data Model

The Jitterbit Connector for Microsoft Dynamics GP models Microsoft Dynamics GP entities in relational views, or read-only tables. The tables are determined automatically based on the metadata the connector retrieves when you connect. Any changes that you make to your Microsoft Dynamics GP account, such as creating a custom field or changing its data type, are reflected on reconnection.

Views shows some sample view definitions included in the Microsoft Dynamics GP development environment. The actual views available will depend on your account.

Executing Inserts

Some of the entities which are exposed as tables support insert operations. For example to insert a new Customer into the Customer table we execute the following query:

INSERT INTO Customer (Id, Name, Comment1, Comment2) VALUES ('TEST_CST', 'Name', 'Comment1', 'Comment2')

Executing Inserts using Temporary Tables

While inserting you may encounter columns which end with "Aggregate" keyword. These columns will accept only temporary table values. If using temporary tables, they must be defined and inserted within the same connection. Closing the connection will clear out any temporary tables in memory. For example while inserting a new SalesInvoice the sales lines need to be inserted as well. The sales lines are exposed in SalesInvoice table as the column LinesAggregate. First we have to find the child view that corresponds to the LinesAggregate column. In this case the view is SalesInvoiceLines. Using the view name for our temporary table and its columns as a reference to the sales lines attributes, we will first insert the sales lines to the temporary table. Follow the sql queries below:

INSERT INTO SalesInvoiceLines#TEMP (LinesItemId, LinesWarehouseId, LinesQuantity, LinesUnitPrice, LinesUnitPriceCurrency) VALUES ('100XLG', 'WAREHOUSE', '1', '30', 'USD')
INSERT INTO SalesInvoiceLines#TEMP (LinesItemId, LinesWarehouseId, LinesQuantity, LinesUnitPrice, LinesUnitPriceCurrency) VALUES ('M1700', 'WAREHOUSE', '1', '30', 'USD')
INSERT INTO SalesInvoice (BatchId, CustomerId, DocumentTypeKeyType, DocumentTypeId, LinesAggregate) VALUES ('CONTRACTS', 'PLAZAONE0001', 'Invoice', 'STDINV' , 'SalesInvoiceLines#TEMP')

First we add 2 sales lines into the temporary table with name "SalesInvoiceLines#TEMP". Then we are able to create a new SalesInvoice using the temporary table name as a value for the column LinesAggregate. Note: The columns LinesItemId, LinesWarehouseId, LinesQuantity, LinesUnitPrice, LinesUnitPriceCurrency in the example above have to correspond to real columns in the child table otherwise it will not work.

Below you can find other query examples with or without using temp tables.

INSERT INTO Customer (Id, Name) VALUES ('TEST_CST', 'Name')

INSERT INTO CustomerAddress (SalespersonId, SalesTerritoryId, Id, KeyCustomerId, Line1, Line2, City, State, CountryRegion, Fax, Phone1, Phone2, PostalCode) VALUES ('PAUL W.', 'TERRITORY 1', 'WAREHOUSE', 'TEST_CST', '11403 45 St. South', 'Billing Dept.', 'Chicago', 'IL', 'USA', '31255501010000', '42555501010000', '00000000000000', '98052-6399')

INSERT INTO Vendor (Id, Name, Comment1, Comment2) VALUES ('test11', 'Name', 'Comment1', 'Comment2')

INSERT INTO VendorAddress (SalespersonId, SalesTerritoryId, Id, KeyVendorId, Line1, Line2, City, State, CountryRegion, Fax, Phone1, Phone2, PostalCode) VALUES ('PAUL W.', 'TERRITORY 1', 'PRIMARY', 'test11', '11403 45 St. South', 'Billing Dept.', 'Chicago', 'IL', 'USA', '31255501010000', '42555501010000', '00000000000000', '98052-6399')

INSERT INTO PayablesCreditMemo (BatchId, Id, VendorId, PurchaseAmount, PurchaseAmountCurrency, VendorDocumentNumber) VALUES ('JAN-98', 'DM6502', 'CENTRALC0001',  '100', 'USD', 'DOCUMENT 42')

INSERT INTO ApplicantApplications#TEMP (ApplicationsDateApplied, ApplicationsLastModifiedDate) VALUES ('2021-01-07T00:00:00+01:00','2021-01-07T00:00:00+01:00')
INSERT INTO Applicant (FirstName, LastName, ApplicationsAggregate) VALUES ('Test', 'Applicant', 'ApplicantApplications#TEMP')

INSERT INTO PurchaseOrderLines#TEMP (LinesQuantityOrdered, LinesVendorItemNumber, LinesWarehouseId) VALUES ('1', '100XLG', 'WAREHOUSE')
INSERT INTO PurchaseOrder (LinesAggregate, Id, VendorId) VALUES ('PurchaseOrderLines#TEMP', 'PO4056', 'ACETRAVE0001')

INSERT INTO SalesReturnLines#TEMP (LinesItemId, LinesWarehouseId, LinesQuantity, LinesUnitPrice, LinesUnitPriceCurrency) VALUES ('100XLG', 'WAREHOUSE', '1', '30', 'USD');
INSERT INTO SalesReturnLines#TEMP (LinesItemId, LinesWarehouseId, LinesQuantity, LinesUnitPrice, LinesUnitPriceCurrency) VALUES ('M1700', 'WAREHOUSE', '1', '30', 'USD');
INSERT INTO SalesReturn (BatchId, CustomerId, DocumentTypeKeyType, DocumentTypeId, LinesAggregate) VALUES ('SALES RETURNS', 'PLAZAONE0001', 'Return', 'RTN' , 'SalesReturnLines#TEMP');

Executing Delete

Some of the entities which are exposed as tables support delete operations. For example to delete a Customer from the Customer table we execute the following query:

DELETE FROM Customer WHERE Id='TEST_CST'

Executing Delete using multiple keys

Some delete operations require multiple keys in order for the query to be successful. For example to delete a CustomerAddress from the CustomerAddresses table requires both key columns the ID and the KeyCustomerId values to be set for ex:

DELETE FROM CustomerAddress WHERE Id='WAREHOUSE' AND KeyCustomerId='TEST2'

Below you can find other query examples with or without multiple keys.

DELETE FROM Applicant WHERE ApplicantId='2'

DELETE FROM SalesInvoice WHERE Id='STDINV2262'

DELETE FROM ApplicantApplication WHERE ApplicantApplicationKeyApplicantId='3' AND ApplicantApplicationKeySequenceId='1'

Executing Update

Some of the entities which are exposed as tables support update operations. For example to update a Customer from the Customer table we execute the following query:

UPDATE Customer SET Name='new test name',Comment1='new comment 1', Comment2='new comment 2' WHERE Id='TEST1'

Executing Update using multiple keys

Some update operations require multiple keys in order for the query to be successful. For example to update a CustomerAddress from the CustomerAddresses table requires both key columns the ID and the KeyCustomerId values to be set for ex:

UPDATE CustomerAddress SET Line1='new line 1', Line2='new line 2', City='new city', State='new state', Fax='111111111', Phone1='222222222', Phone2='3333333', PostalCode='235-325' WHERE KeyCustomerId='TEST1234' AND Id='WAREHOUSE'
UPDATE SalesInvoice SET CustomerId='AARONFIT0001', Date='2021-01-07T00:00:00+01:00' WHERE Id='STDINV2300' AND BatchId='CONTRACTS'

Note: When updating the tables SalesInvoice, SalesOrder, SalesQuote, SalesReturn, SalesBackorder, SalesFulfillmentOrder the Date column should be set for a successful query.

Executing Update using temporary tables

As explained in Executing Inserts using Temporary Tables the temporary tables can also be used in update operations. Take a look at the query below which updates the quantity of the existing items in our invoice:

INSERT INTO SalesInvoiceLines#TEMP (LinesItemId, LinesWarehouseId, LinesQuantity, LinesUnitPrice, LinesUnitPriceCurrency) VALUES ('100XLG', 'WAREHOUSE', '2', '30', 'USD')
INSERT INTO SalesInvoiceLines#TEMP (LinesItemId, LinesWarehouseId, LinesQuantity, LinesUnitPrice, LinesUnitPriceCurrency) VALUES ('M1700', 'WAREHOUSE', '2', '30', 'USD')

UPDATE SalesInvoice SET Date='2021-01-07T00:00:00+01:00', LinesAggregate='SalesInvoiceLines#TEMP' WHERE Id='STDINV2300' AND BatchId='CONTRACTS'

Below you can find other query examples.

UPDATE SalesOrder SET CustomerId='AARONFIT0001', Date='2021-01-07T00:00:00+01:00' WHERE Id='ORDST2225' AND BatchId='SOP ORDERS'

INSERT INTO ApplicantApplications#TEMP (ApplicationsDateApplied, ApplicationsLastModifiedDate) VALUES ('2021-01-05T00:00:00+01:00','2021-01-07T00:00:00+01:00')
UPDATE Applicant SET FirstName='New Test Name', LastName='New Applicant Name', ApplicationsAggregate='ApplicantApplications#TEMP' WHERE ApplicantId='3'

UPDATE SalesQuote SET CustomerId='BAKERSEM0001', Date='2021-01-07T00:00:00+01:00' WHERE Id='QTEST1022' AND BatchId='SALES QUOTES'

UPDATE Vendor SET Name='new test name',Comment1='new comment 1', Comment2='new comment 2' WHERE Id='ACETRAVE0001'

UPDATE VendorAddress SET Line1='new line 1', Line2='new line 2', City='new city', State='new state', Fax='111111111', Phone1='222222222', Phone2='3333333', PostalCode='235-325' WHERE KeyVendorId='ACETRAVE0001' AND Id='PRIMARY'

Tables

The connector models the data in Microsoft Dynamics GP into a list of tables that can be queried using standard SQL statements.

Generally, querying Microsoft Dynamics GP tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

Jitterbit Connector for Microsoft Dynamics GP Tables

Name Description
Applicant Return a list of: Applicant
ApplicantEducation Return a list of: ApplicantEducation
ApplicantInterview Return a list of: ApplicantInterview
ApplicantReference Return a list of: ApplicantReference
ApplicantSkill Return a list of: ApplicantSkill
ApplicantTest Return a list of: ApplicantTest
ApplicantWorkHistory Return a list of: ApplicantWorkHistory
BackOfficeRoleAssignment Return a list of: BackOfficeRoleAssignment
BusinessObjectUserAssignment Return a list of: BusinessObjectUserAssignment
CashReceipt Return a list of: CashReceipt
Customer Return a list of: Customer
CustomerAddress Return a list of: CustomerAddress
Employee Return a list of: Employee
EmployeeAddress Return a list of: EmployeeAddress
EmployeePayCode Return a list of: EmployeePayCode
Fee Return a list of: Fee
GLFixedAllocationAccount Return a list of: GLFixedAllocationAccount
GLPostingAccount Return a list of: GLPostingAccount
GLTransaction Return a list of: GLTransaction
GLUnitAccount Return a list of: GLUnitAccount
GLVariableAllocationAccount Return a list of: GLVariableAllocationAccount
HRRequisition Return a list of: HRRequisition
InventoryAdjustment Return a list of: InventoryAdjustment
InventoryTransfer Return a list of: InventoryTransfer
InventoryVariance Return a list of: InventoryVariance
ItemCurrency Return a list of: ItemCurrency
ItemVendor Return a list of: ItemVendor
ItemWarehouse Return a list of: ItemWarehouse
PayablesCreditMemo Return a list of: PayablesCreditMemo
PayablesFinanceCharge Return a list of: PayablesFinanceCharge
PayablesInvoice Return a list of: PayablesInvoice
PayablesMiscellaneousCharge Return a list of: PayablesMiscellaneousCharge
PayablesReturn Return a list of: PayablesReturn
Policy Return a list of: Policy
Pricing Return a list of: Pricing
PurchaseInvoice Return a list of: PurchaseInvoice
PurchaseOrder Return a list of: PurchaseOrder
PurchaseReceipt Return a list of: PurchaseReceipt
ReceivablesCreditMemo Return a list of: ReceivablesCreditMemo
ReceivablesDebitMemo Return a list of: ReceivablesDebitMemo
ReceivablesFinanceCharge Return a list of: ReceivablesFinanceCharge
ReceivablesInvoice Return a list of: ReceivablesInvoice
ReceivablesReturn Return a list of: ReceivablesReturn
ReceivablesServiceRepair Return a list of: ReceivablesServiceRepair
ReceivablesWarranty Return a list of: ReceivablesWarranty
ReturnMaterialAuthorization Return a list of: ReturnMaterialAuthorization
SalesBackorder Return a list of: SalesBackorder
SalesFulfillmentOrder Return a list of: SalesFulfillmentOrder
SalesInvoice Return a list of: SalesInvoice
SalesOrder Return a list of: SalesOrder
SalesProcessHoldSetup Return a list of: SalesProcessHoldSetup
SalesQuote Return a list of: SalesQuote
SalesReturn Return a list of: SalesReturn
Service Return a list of: Service
ServiceCall Return a list of: ServiceCall
ServiceEquipment Return a list of: ServiceEquipment
ServiceQuote Return a list of: ServiceQuote
Skill Return a list of: Skill
SkillSet Return a list of: SkillSet
Vendor Return a list of: Vendor
VendorAddress Return a list of: VendorAddress
Warehouse Return a list of: Warehouse

Applicant

Return a list of: Applicant

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AddressExtensionsExtensionAggregate String False
AddressCity String False
AddressLine1 String False
AddressLine2 String False
AddressLine3 String False
AddressPostalCode String False
AddressState String False
AddressCountryRegion String False
AddressFaxCountryCode String False
AddressFaxExtension String False
AddressFax String False
AddressPhone1CountryCode String False
AddressPhone1Extension String False
AddressPhone1 String False
AddressPhone2CountryCode String False
AddressPhone2Extension String False
AddressPhone2 String False
AddressPhone3CountryCode String False
AddressPhone3Extension String False
AddressPhone3 String False
AgeCode String False
ApplicantId [KEY] Int False
ApplicationColorColorCode String False
ApplicationColorColorName String False
ApplicationStatus String False
ApplicationsAggregate String False
CompanyCode String False
DateApplied Datetime False
DepartmentId String False
DivisionId String False
Ethnicity String False
FirstName String False
Gender String False
HRRequisistionId String False
InterviewsAggregate String False
IsDisabled Bool False
IsDisabledVeteran Bool False
IsOtherVeteran Bool False
IsReplyLetterSent Bool False
IsVeteran Bool False
IsVietnamEraVeteran Bool False
IsWillRelocate Bool False
LastModifiedBy String False
LastModifiedDate Datetime False
LastName String False
Location String False
MiddleName String False
PositionId String False
PreviousEmployersAggregate String False
ReferenceInformationSource String False
ReferenceInformationSourceDescription String False
ReferencesAggregate String False
RejectionInformationComment String False
RejectionInformationReason String False
SchoolsAggregate String False
SequenceId Int False
SkillsAggregate String False
TaxIdentifier String False
TestsAggregate String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ApplicantEducation

Return a list of: ApplicantEducation

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
ApplicantEducationKeyApplicantId [KEY] Int False
ApplicantEducationKeySequenceId [KEY] Int False
Degree String False
DeleteOnUpdate Bool False
GPABase String False
GradePointAverage String False
LastModifiedBy String False
LastModifiedDate Datetime False
Major String False
Notes String False
School String False
YearGraduated String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ApplicantInterview

Return a list of: ApplicantInterview

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
ApplicantInterviewKeyApplicantId [KEY] Int False
ApplicantInterviewKeyApplyDateId [KEY] Datetime False
ApplicantInterviewKeyInterviewTypeId [KEY] String False
CompanyCode String False
DeleteOnUpdate Bool False
DepartmentId String False
DivisionId String False
EffectiveDate Datetime False
InterviewItemsAggregate String False
InterviewTypeCode Int False
Notes String False
PositionId String False
ReviewRange Int False
ReviewRating Decimal False
TotalWeight Int False
WeightedScore Int False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ApplicantReference

Return a list of: ApplicantReference

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AddressExtensionsExtensionAggregate String False
AddressCity String False
AddressLine1 String False
AddressLine2 String False
AddressLine3 String False
AddressPostalCode String False
AddressState String False
AddressCountryRegion String False
AddressFaxCountryCode String False
AddressFaxExtension String False
AddressFax String False
AddressPhone1CountryCode String False
AddressPhone1Extension String False
AddressPhone1 String False
AddressPhone2CountryCode String False
AddressPhone2Extension String False
AddressPhone2 String False
AddressPhone3CountryCode String False
AddressPhone3Extension String False
AddressPhone3 String False
ApplicantReferenceKeyApplicantSequenceKeyApplicantId [KEY] Int False
ApplicantReferenceKeyApplicantSequenceKeySequenceId [KEY] Int False
ApplicantReferenceId [KEY] String False
CompanyName String False
DeleteOnUpdate Bool False
LastModifiedBy String False
LastModifiedDate Datetime False
Notes String False
Relationship String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ApplicantSkill

Return a list of: ApplicantSkill

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
ApplicantSkillKeyApplicantId [KEY] Int False
ApplicantSkillKeySkillId [KEY] String False
Comments String False
DeleteOnUpdate Bool False
Proficiency Int False
SkillNumber Int False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ApplicantTest

Return a list of: ApplicantTest

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
ApplicantTestKeyApplicantSequenceKeyApplicantId [KEY] Int False
ApplicantTestKeyApplicantSequenceKeySequenceId [KEY] Int False
ApplicantTestKeyTestId [KEY] String False
DeleteOnUpdate Bool False
LastModifiedBy String False
LastModifiedDate Datetime False
Notes String False
Score String False
TestDate Datetime False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ApplicantWorkHistory

Return a list of: ApplicantWorkHistory

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
ApplicantWorkHistoryKeyApplicantSequenceKeyApplicantId [KEY] Int False
ApplicantWorkHistoryKeyApplicantSequenceKeySequenceId [KEY] Int False
ApplicantWorkHistoryId [KEY] String False
CompensationPeriod String False
DeleteOnUpdate Bool False
EndDate Datetime False
LastModifiedBy String False
LastModifiedDate Datetime False
Notes String False
PositionId String False
StartDate Datetime False
Wage Decimal False
YearsOfExperience Int False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

BackOfficeRoleAssignment

Return a list of: BackOfficeRoleAssignment

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
KeyRoleId [KEY] String False
KeyUserId [KEY] String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

BusinessObjectUserAssignment

Return a list of: BusinessObjectUserAssignment

Columns
Name Type ReadOnly Description
BusinessObjectKey String False
BusinessObjectTypeId String False
User [KEY] String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

CashReceipt

Return a list of: CashReceipt

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AmountCurrency String False
Amount Decimal False
AuditTrailCode String False
BankAccountId String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
CheckCardNumber String False
CorporateAccountId String False
CurrencyKeyISOCode String False
CustomerId String False
Date Datetime False
Description String False
DistributionsAggregate String False
ExchangeDate Datetime False
ExchangeRate Decimal False
GeneralLedgerPostingDate Datetime False
IsVoided Bool False
Id [KEY] String False
ModifiedBy String False
ModifiedDate Datetime False
PaymentCardTypeId String False
PostedBy String False
PostedDate Datetime False
Type String False
VoidDate Datetime False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Customer

Return a list of: Customer

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AccountsReceivableGLAccountId String False
AccountsReceivableGLAccountKeyIsEncrypted Bool False
AddressesAggregate String False
AllowRevaluation Bool False
BalanceType String False
BankAccountId String False
BankBranch String False
BankName String False
BillToAddressKeyCustomerId String False
BillToAddressId String False
CashGLAccountId String False
CashGLAccountKeyIsEncrypted Bool False
ClassId String False
Comment1 String False
Comment2 String False
CorporateAccountId String False
CostOfGoodsSoldGLAccountId String False
CostOfGoodsSoldGLAccountKeyIsEncrypted Bool False
CreatedDate Datetime False
CreditLimitItem String False
CreditLimitPeriod Int False
CreditLimitPeriodAmountCurrency String False
CreditLimitPeriodAmount Decimal False
CurrencyKeyISOCode String False
DefaultAddressKeyCustomerId String False
DefaultAddressId String False
DefaultCashAccountType String False
DiscountGracePeriod Int False
DueDateGracePeriod Int False
FinanceChargeItem String False
FinanceChargesGLAccountId String False
FinanceChargesGLAccountKeyIsEncrypted Bool False
HistoryOptionsKeepCalendarHistory Bool False
HistoryOptionsKeepDistributionHistory Bool False
HistoryOptionsKeepFiscalHistory Bool False
HistoryOptionsKeepTransactionHistory Bool False
IncludeInDemandPlanning Bool False
InventoryGLAccountId String False
InventoryGLAccountKeyIsEncrypted Bool False
IsActive Bool False
IsOnHold Bool False
Id [KEY] String False
LastModifiedDate Datetime False
MaximumWriteoffItem String False
MinimumPaymentItem String False
ModifiedDate Datetime False
Name String False
Notes String False
OrderFullfillmentShortageDefault String False
OverpaymentWriteoffGLAccountId String False
OverpaymentWriteoffGLAccountKeyIsEncrypted Bool False
PaymentCardAccountExpirationDate Datetime False
PaymentCardAccountKeyNumber String False
PaymentCardAccountKeyPaymentCardTypeId String False
PaymentTermsDiscountAvailableGLAccountId String False
PaymentTermsDiscountAvailableGLAccountKeyIsEncrypted Bool False
PaymentTermsDiscountTakenGLAccountId String False
PaymentTermsDiscountTakenGLAccountKeyIsEncrypted Bool False
PaymentTermsId String False
PostResultsTo String False
PriceLevelId String False
Priority Int False
RateTypeId String False
SalesGLAccountId String False
SalesGLAccountKeyIsEncrypted Bool False
SalesOrderReturnsGLAccountId String False
SalesOrderReturnsGLAccountKeyIsEncrypted Bool False
SendEmailStatements Bool False
ShipCompleteOnly Bool False
ShipToAddressKeyCustomerId String False
ShipToAddressId String False
Shortname String False
StatementCycle String False
StatementName String False
StatementRecipientsBCCAggregate String False
StatementRecipientsCCAggregate String False
StatementRecipientsToAggregate String False
StatementToAddressKeyCustomerId String False
StatementToAddressId String False
TaxExemptNumbersAggregate String False
TaxRegistrationNumber String False
TradeDiscountPercent Decimal False
UserDefined1 String False
UserDefined2 String False
UserLanguageId Int False
WriteoffGLAccountId String False
WriteoffGLAccountKeyIsEncrypted Bool False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

CustomerAddress

Return a list of: CustomerAddress

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
City String False
Line1 String False
Line2 String False
Line3 String False
PostalCode String False
State String False
CountryRegion String False
FaxCountryCode String False
FaxExtension String False
Fax String False
Phone1CountryCode String False
Phone1Extension String False
Phone1 String False
Phone2CountryCode String False
Phone2Extension String False
Phone2 String False
Phone3CountryCode String False
Phone3Extension String False
Phone3 String False
CountryRegionCodeId String False
ContactPerson String False
Name String False
CreatedDate Datetime False
InternetAddressesAdditionalInformation String False
InternetAddressesEmailBccAddress String False
InternetAddressesEmailCcAddress String False
InternetAddressesEmailToAddress String False
InternetAddressesInternetField1 String False
InternetAddressesInternetField2 String False
InternetAddressesInternetField3 String False
InternetAddressesInternetField4 String False
InternetAddressesInternetField5 String False
InternetAddressesInternetField6 String False
InternetAddressesInternetField7 String False
InternetAddressesInternetField8 String False
InternetAddressesMessengerAddress String False
LastModifiedDate Datetime False
ModifiedDate Datetime False
ShippingMethodId String False
TaxScheduleId String False
UPSZone String False
UserDefined1 String False
UserDefined2 String False
DeleteOnUpdate Bool False
KeyCustomerId [KEY] String False
Id [KEY] String False
SalesTerritoryId String False
SalespersonId String False
WarehouseId String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Employee

Return a list of: Employee

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AddressesAggregate String False
BenefitExpiration Datetime False
BenefitStartDate Datetime False
BirthDate Datetime False
ClassId String False
CompanyAddressId String False
DayOfBirth Int False
DefaultAddressKeyEmployeeId String False
DefaultAddressId String False
DefaultCashAccountFromType String False
DepartmentId String False
DivisionId String False
DoesCalculateMinimumWageBalance Bool False
EmployeeInactivatedDate Datetime False
EmployeeId [KEY] String False
EmploymentStartDate Datetime False
EmploymentType String False
Ethnicity String False
FederalClass String False
GLAccountId String False
GLAccountKeyIsEncrypted Bool False
GenderCode String False
HRStatus String False
I9RenewDate Datetime False
IsActive Bool False
IsDisabled Bool False
IsDisabledVeteran Bool False
IsI9Verified Bool False
IsOtherVeteran Bool False
IsSmoker Bool False
IsUnionEmployee Bool False
IsUnitedStatesCitizen Bool False
IsVeteran Bool False
IsVietnamEraVeteran Bool False
LastWorkedDate Datetime False
MaritalStatus String False
MilitaryDischargeDate Datetime False
MinimumNetPayCurrency String False
MinimumNetPay Decimal False
ModifiedBy String False
ModifiedDate Datetime False
MonthOfBirth String False
NameAlternate String False
NameFamily String False
NameGiven String False
NameMiddle String False
NamePreferred String False
NameSuffix String False
PositionId String False
PrimaryPayCodeId String False
RateClass String False
ReasonEmployeeInactivated String False
ReviewLastDate Datetime False
ReviewNextDate Datetime False
SUTAStateId String False
SickTimeAccrualAmount Decimal False
SickTimeAccrualMethod String False
SickTimeDoesAutomaticallyAccrue Bool False
SickTimeHoursAvailable Decimal False
SickTimeHoursPerYear Int False
SickTimeWarnWhenHoursAvailableFallsBelowZero Bool False
SpouseName String False
SpouseTaxIdentifier String False
Status String False
SupervisorId String False
TaxIdentifier String False
UnionId String False
UserDefined1 String False
UserDefined2 String False
VacationAccrualAmount Decimal False
VacationAccrualMethod String False
VacationDoesAutomaticallyAccrue Bool False
VacationHoursAvailable Decimal False
VacationHoursPerYear Int False
VacationWarnWhenHoursAvailableFallsBelowZero Bool False
WorkHoursPerYear Int False
WorkersCompensationId String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

EmployeeAddress

Return a list of: EmployeeAddress

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
City String False
Line1 String False
Line2 String False
Line3 String False
PostalCode String False
State String False
CountryRegion String False
FaxCountryCode String False
FaxExtension String False
Fax String False
Phone1CountryCode String False
Phone1Extension String False
Phone1 String False
Phone2CountryCode String False
Phone2Extension String False
Phone2 String False
Phone3CountryCode String False
Phone3Extension String False
Phone3 String False
CountryRegionCodeId String False
County String False
DeleteOnUpdate Bool False
InternetAddressesAdditionalInformation String False
InternetAddressesEmailBccAddress String False
InternetAddressesEmailCcAddress String False
InternetAddressesEmailToAddress String False
InternetAddressesInternetField1 String False
InternetAddressesInternetField2 String False
InternetAddressesInternetField3 String False
InternetAddressesInternetField4 String False
InternetAddressesInternetField5 String False
InternetAddressesInternetField6 String False
InternetAddressesInternetField7 String False
InternetAddressesInternetField8 String False
InternetAddressesMessengerAddress String False
KeyEmployeeId [KEY] String False
Id [KEY] String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

EmployeePayCode

Return a list of: EmployeePayCode

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
ApplicableTaxesIsFederalTaxApplied Bool False
ApplicableTaxesIsFutaApplied Bool False
ApplicableTaxesIsLocalTaxApplied Bool False
ApplicableTaxesIsMedicareApplied Bool False
ApplicableTaxesIsSocialSecurityApplied Bool False
ApplicableTaxesIsStateTaxApplied Bool False
ApplicableTaxesIsSutaApplied Bool False
ApplicableTaxesSutaState String False
BasePayRecordId String False
BasedOnRate Decimal False
EmployeePayCodeKeyEmployeeId [KEY] String False
EmployeePayCodeKeyPayCodeId [KEY] String False
FlatTaxRatesFederal Decimal False
FlatTaxRatesState Decimal False
IsDataEntry Bool False
IsInactive Bool False
IsPrimaryPayRecord Bool False
IsReportAsWages Bool False
IsSickTimeAccrued Bool False
IsTaxable Bool False
IsVacationAccrued Bool False
MaxPayPerPeriod Decimal False
Notes String False
PayAdvance Decimal False
PayAdvanceTaken Decimal False
PayFactor Decimal False
PayPerPeriod Decimal False
PayPeriod String False
PayRate Decimal False
PayStepBasedOn String False
PayStepEffectiveDate Datetime False
PayStepPayStepId String False
PayStepStep Int False
PayStepStepFTE Decimal False
PayType String False
PayUnit String False
PayUnitPeriod String False
ShiftCode String False
TipType String False
W2BoxesLabelsW2BoxLabel1 String False
W2BoxesLabelsW2BoxLabel2 String False
W2BoxesLabelsW2BoxLabel3 String False
W2BoxesLabelsW2BoxLabel4 String False
W2BoxesLabelsW2BoxNumber1 Int False
W2BoxesLabelsW2BoxNumber2 Int False
W2BoxesLabelsW2BoxNumber3 Int False
W2BoxesLabelsW2BoxNumber4 Int False
WorkersComp String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Fee

Return a list of: Fee

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
ABCCode String False
AllowBackOrder Bool False
AssemblyVarianceGLAccountId String False
AssemblyVarianceGLAccountKeyIsEncrypted Bool False
ClassId String False
CostofGoodsSoldGLAccountId String False
CostofGoodsSoldGLAccountKeyIsEncrypted Bool False
CreatedDate Datetime False
CurrencyDecimalPlaces String False
CurrentCostCurrency String False
CurrentCost Decimal False
DamagedGLAccountId String False
DamagedGLAccountKeyIsEncrypted Bool False
DefaultPriceLevelId String False
DefaultSellingUofM String False
DefaultWarehouseId String False
Description String False
DropShipGLAccountId String False
DropShipGLAccountKeyIsEncrypted Bool False
FunctionalCurrencyDecimalPlaces String False
GenericDescription String False
InServiceGLAccountId String False
InServiceGLAccountKeyIsEncrypted Bool False
InUseGLAccountId String False
InUseGLAccountKeyIsEncrypted Bool False
IncludeInDemandPlanning Bool False
InternetAddressesAdditionalInformation String False
InternetAddressesEmailBccAddress String False
InternetAddressesEmailCcAddress String False
InternetAddressesEmailToAddress String False
InternetAddressesInternetField1 String False
InternetAddressesInternetField2 String False
InternetAddressesInternetField3 String False
InternetAddressesInternetField4 String False
InternetAddressesInternetField5 String False
InternetAddressesInternetField6 String False
InternetAddressesInternetField7 String False
InternetAddressesInternetField8 String False
InternetAddressesMessengerAddress String False
InventoryGLAccountId String False
InventoryGLAccountKeyIsEncrypted Bool False
InventoryOffsetGLAccountId String False
InventoryOffsetGLAccountKeyIsEncrypted Bool False
InventoryReturnGLAccountId String False
InventoryReturnGLAccountKeyIsEncrypted Bool False
IsDiscontinued Bool False
KeepCalendarYearHistory Bool False
KeepDistributionHistory Bool False
KeepFiscalYearHistory Bool False
KeepTransactionHistory Bool False
Id [KEY] String False
LastModifiedDate Datetime False
MarkdownGLAccountId String False
MarkdownGLAccountKeyIsEncrypted Bool False
ModifiedDate Datetime False
PriceMethod String False
PurchasePriceVarianceGLAccountId String False
PurchasePriceVarianceGLAccountKeyIsEncrypted Bool False
PurchaseTaxBasis String False
PurchaseTaxScheduleId String False
PurchaseUofM String False
QuantityDecimalPlaces String False
SalesGLAccountId String False
SalesGLAccountKeyIsEncrypted Bool False
SalesReturnGLAccountId String False
SalesReturnGLAccountKeyIsEncrypted Bool False
SalesTaxBasis String False
SalesTaxScheduleId String False
ShippingWeight Decimal False
ShortDescription String False
StandardCostCurrency String False
StandardCost Decimal False
SubstituteItem1Id String False
SubstituteItem2Id String False
Type String False
UnrealizedPurchasePriceVarianceGLAccountId String False
UnrealizedPurchasePriceVarianceGLAccountKeyIsEncrypted Bool False
UofMScheduleId String False
UserCategoryList1 String False
UserCategoryList2 String False
UserCategoryList3 String False
UserCategoryList4 String False
UserCategoryList5 String False
UserCategoryList6 String False
VarianceGLAccountId String False
VarianceGLAccountKeyIsEncrypted Bool False
WarrantyDays Short False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

GLFixedAllocationAccount

Return a list of: GLFixedAllocationAccount

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
Alias String False
CreatedDate Datetime False
Description String False
IsActive Bool False
Id [KEY] String False
KeyIsEncrypted [KEY] Bool False
ModifiedDate Datetime False
Type String False
PostInventoryIn String False
PostPayrollIn String False
PostPurchasingIn String False
PostSalesIn String False
DistributionsAggregate String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

GLPostingAccount

Return a list of: GLPostingAccount

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
Alias String False
CreatedDate Datetime False
Description String False
IsActive Bool False
Id [KEY] String False
KeyIsEncrypted [KEY] Bool False
ModifiedDate Datetime False
Type String False
PostInventoryIn String False
PostPayrollIn String False
PostPurchasingIn String False
PostSalesIn String False
AllowAccountEntry Bool False
CurrenciesAggregate String False
GLAccountCategoryId String False
IsRevalued Bool False
PostRevaluationResultsTo String False
PostingType String False
RevaluationMethod String False
TypicalBalance String False
UserDefined1 String False
UserDefined2 String False
UserDefined3 String False
UserDefined4 String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

GLTransaction

Return a list of: GLTransaction

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
CurrencyKeyISOCode String False
ExchangeDate Datetime False
ExchangeRate Decimal False
IntercompanyId Int False
IntercompanyOriginalJournalId Int False
IsVoided Bool False
KeyDate [KEY] Datetime False
KeyJournalId [KEY] Int False
LedgerType String False
LinesAggregate String False
ModifiedBy String False
ModifiedDate Datetime False
OriginatingDocumentAuditTrailCode String False
OriginatingDocumentPostedDate Datetime False
OriginatingDocumentSeries String False
PostedBy String False
Reference String False
SourceDocumentId String False
TransactionState String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

GLUnitAccount

Return a list of: GLUnitAccount

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
Alias String False
CreatedDate Datetime False
Description String False
IsActive Bool False
Id [KEY] String False
KeyIsEncrypted [KEY] Bool False
ModifiedDate Datetime False
Type String False
DecimalPlaces String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

GLVariableAllocationAccount

Return a list of: GLVariableAllocationAccount

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
Alias String False
CreatedDate Datetime False
Description String False
IsActive Bool False
Id [KEY] String False
KeyIsEncrypted [KEY] Bool False
ModifiedDate Datetime False
Type String False
PostInventoryIn String False
PostPayrollIn String False
PostPurchasingIn String False
PostSalesIn String False
BalanceForCalculation String False
DistributionsAggregate String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

HRRequisition

Return a list of: HRRequisition

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AdvertisingListLine1 String False
AdvertisingListLine2 String False
AdvertisingListLine3 String False
AdvertisingListLine4 String False
AdvertisingListLine5 String False
ApplicantsApplied Int False
ApplicantsInterviewed Int False
CompanyCode String False
DepartmentId String False
DivisionId String False
InternalCloseDate Datetime False
InternalPostDate Datetime False
JobPostingType String False
LastModifiedBy String False
LastModifiedDate Datetime False
ManagerId String False
OpeningDate Datetime False
PositionId String False
PositionsAvailable Int False
PositionsFilled Int False
Recruiter String False
RequisitionCostsAdvertising Decimal False
RequisitionCostsLodging Decimal False
RequisitionCostsMovingExpenses Decimal False
RequisitionCostsOther Decimal False
RequisitionCostsRecruiterFees Decimal False
RequisitionCostsTravel Decimal False
RequisitionNumberId [KEY] String False
Status String False
SupervisorId String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

InventoryAdjustment

Return a list of: InventoryAdjustment

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
CreatedDate Datetime False
Date Datetime False
GLPostingDate Datetime False
Id [KEY] String False
ModifiedDate Datetime False
TransactionState String False
LinesAggregate String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

InventoryTransfer

Return a list of: InventoryTransfer

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
CreatedDate Datetime False
Date Datetime False
GLPostingDate Datetime False
Id [KEY] String False
ModifiedDate Datetime False
TransactionState String False
LinesAggregate String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

InventoryVariance

Return a list of: InventoryVariance

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
CreatedDate Datetime False
Date Datetime False
GLPostingDate Datetime False
Id [KEY] String False
ModifiedDate Datetime False
TransactionState String False
LinesAggregate String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ItemCurrency

Return a list of: ItemCurrency

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
CurrencyDecimalPlaces String False
KeyCurrencyKeyISOCode [KEY] String False
KeyItemId [KEY] String False
ListPriceCurrency String False
ListPrice Decimal False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ItemVendor

Return a list of: ItemVendor

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AverageLeadTime Decimal False
EconomicOrderQuantity Decimal False
FreeOnBoard String False
KeyItemId [KEY] String False
KeyVendorId [KEY] String False
LastCurrencyKeyISOCode String False
LastOriginatingCostCurrency String False
LastOriginatingCost Decimal False
MaximumOrderQuantity Decimal False
MinimumOrderQuantity Decimal False
NumberOfReceipts Short False
OrderMultipleQuantity Decimal False
PlanningLeadTime Short False
PurchasingUofM String False
RequisitionedQuantity Decimal False
VendorItemDescription String False
VendorItemNumber String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ItemWarehouse

Return a list of: ItemWarehouse

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
Bin String False
BuyerId String False
KeyItemId [KEY] String False
KeyWarehouseId [KEY] String False
LandedCostGroupId String False
PlannerId String False
PlanningFixedOrderQuantity Decimal False
PlanningManufacturingLeadTime Decimal False
PlanningMaximumOrderQuantity Decimal False
PlanningMinimumOrderQuantity Decimal False
PlanningOrderMultipleQuantity Decimal False
PlanningOrderPointQuantity Decimal False
PlanningOrderPolicy String False
PlanningOrderUpToLevelQuantity Decimal False
PlanningPurchasingLeadTime Decimal False
PlanningReorderVarianceQuantity Decimal False
PlanningReplenishmentMethod String False
PlanningSafetyStockQuantity Decimal False
PlanningShrinkageFactor Decimal False
PlanningTimeFence Short False
PrimaryVendorId String False
RequisitionedQuantity Decimal False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

PayablesCreditMemo

Return a list of: PayablesCreditMemo

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AddressId String False
Amount1099Currency String False
Amount1099 Decimal False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
ChargeAmountCurrency String False
ChargeAmount Decimal False
CurrencyKeyISOCode String False
Date Datetime False
Description String False
DistributionsAggregate String False
DocumentAmountCurrency String False
DocumentAmount Decimal False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxScheduleId String False
GeneralLedgerPostingDate Datetime False
HasIntercompanyDistributions Bool False
IsIntercompanyTransaction Bool False
IsVoided Bool False
Id [KEY] String False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxScheduleId String False
ModifiedBy String False
ModifiedDate Datetime False
PONumber String False
PostedBy String False
PostedDate Datetime False
PurchaseTaxScheduleId String False
PurchasesAmountCurrency String False
PurchasesAmount Decimal False
RemitToAddressId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxDate Datetime False
TaxScheduleId String False
TaxesAggregate String False
TradeDiscountAmountCurrency String False
TradeDiscountAmount Decimal False
TransactionState String False
Type String False
VendorDocumentNumber String False
VendorId String False
VendorName String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

PayablesFinanceCharge

Return a list of: PayablesFinanceCharge

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AddressId String False
Amount1099Currency String False
Amount1099 Decimal False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
ChargeAmountCurrency String False
ChargeAmount Decimal False
CurrencyKeyISOCode String False
Date Datetime False
Description String False
DistributionsAggregate String False
DocumentAmountCurrency String False
DocumentAmount Decimal False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxScheduleId String False
GeneralLedgerPostingDate Datetime False
HasIntercompanyDistributions Bool False
IsIntercompanyTransaction Bool False
IsVoided Bool False
Id [KEY] String False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxScheduleId String False
ModifiedBy String False
ModifiedDate Datetime False
PONumber String False
PostedBy String False
PostedDate Datetime False
PurchaseTaxScheduleId String False
PurchasesAmountCurrency String False
PurchasesAmount Decimal False
RemitToAddressId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxDate Datetime False
TaxScheduleId String False
TaxesAggregate String False
TradeDiscountAmountCurrency String False
TradeDiscountAmount Decimal False
TransactionState String False
Type String False
VendorDocumentNumber String False
VendorId String False
VendorName String False
PaymentCashAmountCurrency String False
PaymentCashAmount Decimal False
PaymentCashBankAccountId String False
PaymentCashDate Datetime False
PaymentCashNumber String False
PaymentCashDocumentId String False
PaymentCheckAmountCurrency String False
PaymentCheckAmount Decimal False
PaymentCheckBankAccountId String False
PaymentCheckCheckNumber String False
PaymentCheckDate Datetime False
PaymentCheckNumber String False
PaymentPaymentCardAmountCurrency String False
PaymentPaymentCardAmount Decimal False
PaymentPaymentCardDate Datetime False
PaymentPaymentCardNumber String False
PaymentPaymentCardReceiptNumber String False
PaymentPaymentCardTypeId String False
TermsDiscountItem String False
TermsDiscountAvailableAmountCurrency String False
TermsDiscountAvailableAmount Decimal False
TermsDiscountDate Datetime False
TermsDueDate Datetime False
TermsDiscountAmountAppliedTakenCurrency String False
TermsDiscountAmountAppliedTaken Decimal False
TermsDiscountTakenAmountCurrency String False
TermsDiscountTakenAmount Decimal False
TotalPaymentsCurrency String False
TotalPayments Decimal False
WriteoffAmountCurrency String False
WriteoffAmount Decimal False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

PayablesInvoice

Return a list of: PayablesInvoice

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AddressId String False
Amount1099Currency String False
Amount1099 Decimal False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
ChargeAmountCurrency String False
ChargeAmount Decimal False
CurrencyKeyISOCode String False
Date Datetime False
Description String False
DistributionsAggregate String False
DocumentAmountCurrency String False
DocumentAmount Decimal False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxScheduleId String False
GeneralLedgerPostingDate Datetime False
HasIntercompanyDistributions Bool False
IsIntercompanyTransaction Bool False
IsVoided Bool False
Id [KEY] String False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxScheduleId String False
ModifiedBy String False
ModifiedDate Datetime False
PONumber String False
PostedBy String False
PostedDate Datetime False
PurchaseTaxScheduleId String False
PurchasesAmountCurrency String False
PurchasesAmount Decimal False
RemitToAddressId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxDate Datetime False
TaxScheduleId String False
TaxesAggregate String False
TradeDiscountAmountCurrency String False
TradeDiscountAmount Decimal False
TransactionState String False
Type String False
VendorDocumentNumber String False
VendorId String False
VendorName String False
PaymentCashAmountCurrency String False
PaymentCashAmount Decimal False
PaymentCashBankAccountId String False
PaymentCashDate Datetime False
PaymentCashNumber String False
PaymentCashDocumentId String False
PaymentCheckAmountCurrency String False
PaymentCheckAmount Decimal False
PaymentCheckBankAccountId String False
PaymentCheckCheckNumber String False
PaymentCheckDate Datetime False
PaymentCheckNumber String False
PaymentPaymentCardAmountCurrency String False
PaymentPaymentCardAmount Decimal False
PaymentPaymentCardDate Datetime False
PaymentPaymentCardNumber String False
PaymentPaymentCardReceiptNumber String False
PaymentPaymentCardTypeId String False
TermsDiscountItem String False
TermsDiscountAvailableAmountCurrency String False
TermsDiscountAvailableAmount Decimal False
TermsDiscountDate Datetime False
TermsDueDate Datetime False
TermsDiscountAmountAppliedTakenCurrency String False
TermsDiscountAmountAppliedTaken Decimal False
TermsDiscountTakenAmountCurrency String False
TermsDiscountTakenAmount Decimal False
TotalPaymentsCurrency String False
TotalPayments Decimal False
WriteoffAmountCurrency String False
WriteoffAmount Decimal False
PaymentTermsId String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

PayablesMiscellaneousCharge

Return a list of: PayablesMiscellaneousCharge

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AddressId String False
Amount1099Currency String False
Amount1099 Decimal False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
ChargeAmountCurrency String False
ChargeAmount Decimal False
CurrencyKeyISOCode String False
Date Datetime False
Description String False
DistributionsAggregate String False
DocumentAmountCurrency String False
DocumentAmount Decimal False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxScheduleId String False
GeneralLedgerPostingDate Datetime False
HasIntercompanyDistributions Bool False
IsIntercompanyTransaction Bool False
IsVoided Bool False
Id [KEY] String False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxScheduleId String False
ModifiedBy String False
ModifiedDate Datetime False
PONumber String False
PostedBy String False
PostedDate Datetime False
PurchaseTaxScheduleId String False
PurchasesAmountCurrency String False
PurchasesAmount Decimal False
RemitToAddressId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxDate Datetime False
TaxScheduleId String False
TaxesAggregate String False
TradeDiscountAmountCurrency String False
TradeDiscountAmount Decimal False
TransactionState String False
Type String False
VendorDocumentNumber String False
VendorId String False
VendorName String False
PaymentCashAmountCurrency String False
PaymentCashAmount Decimal False
PaymentCashBankAccountId String False
PaymentCashDate Datetime False
PaymentCashNumber String False
PaymentCashDocumentId String False
PaymentCheckAmountCurrency String False
PaymentCheckAmount Decimal False
PaymentCheckBankAccountId String False
PaymentCheckCheckNumber String False
PaymentCheckDate Datetime False
PaymentCheckNumber String False
PaymentPaymentCardAmountCurrency String False
PaymentPaymentCardAmount Decimal False
PaymentPaymentCardDate Datetime False
PaymentPaymentCardNumber String False
PaymentPaymentCardReceiptNumber String False
PaymentPaymentCardTypeId String False
TermsDiscountItem String False
TermsDiscountAvailableAmountCurrency String False
TermsDiscountAvailableAmount Decimal False
TermsDiscountDate Datetime False
TermsDueDate Datetime False
TermsDiscountAmountAppliedTakenCurrency String False
TermsDiscountAmountAppliedTaken Decimal False
TermsDiscountTakenAmountCurrency String False
TermsDiscountTakenAmount Decimal False
TotalPaymentsCurrency String False
TotalPayments Decimal False
WriteoffAmountCurrency String False
WriteoffAmount Decimal False
PaymentTermsId String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

PayablesReturn

Return a list of: PayablesReturn

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AddressId String False
Amount1099Currency String False
Amount1099 Decimal False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
ChargeAmountCurrency String False
ChargeAmount Decimal False
CurrencyKeyISOCode String False
Date Datetime False
Description String False
DistributionsAggregate String False
DocumentAmountCurrency String False
DocumentAmount Decimal False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxScheduleId String False
GeneralLedgerPostingDate Datetime False
HasIntercompanyDistributions Bool False
IsIntercompanyTransaction Bool False
IsVoided Bool False
Id [KEY] String False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxScheduleId String False
ModifiedBy String False
ModifiedDate Datetime False
PONumber String False
PostedBy String False
PostedDate Datetime False
PurchaseTaxScheduleId String False
PurchasesAmountCurrency String False
PurchasesAmount Decimal False
RemitToAddressId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxDate Datetime False
TaxScheduleId String False
TaxesAggregate String False
TradeDiscountAmountCurrency String False
TradeDiscountAmount Decimal False
TransactionState String False
Type String False
VendorDocumentNumber String False
VendorId String False
VendorName String False
DiscountReturnedAmountCurrency String False
DiscountReturnedAmount Decimal False
PaymentCashAmountCurrency String False
PaymentCashAmount Decimal False
PaymentCashBankAccountId String False
PaymentCashDate Datetime False
PaymentCashNumber String False
PaymentCashDocumentId String False
PaymentCheckAmountCurrency String False
PaymentCheckAmount Decimal False
PaymentCheckBankAccountId String False
PaymentCheckCheckNumber String False
PaymentCheckDate Datetime False
PaymentCheckNumber String False
PaymentPaymentCardAmountCurrency String False
PaymentPaymentCardAmount Decimal False
PaymentPaymentCardDate Datetime False
PaymentPaymentCardNumber String False
PaymentPaymentCardReceiptNumber String False
PaymentPaymentCardTypeId String False
TotalPaymentsCurrency String False
TotalPayments Decimal False
WriteoffAmountCurrency String False
WriteoffAmount Decimal False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Policy

Return a list of: Policy

Columns
Name Type ReadOnly Description
BehaviorsAggregate String False
Id [KEY] String False
Name String False
RootBusinessObjectName String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Pricing

Return a list of: Pricing

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
DetailsAggregate String False
KeyCurrencyKeyISOCode [KEY] String False
KeyItemId [KEY] String False
KeyPriceLevelId [KEY] String False
KeyUofM [KEY] String False
LastModifiedBy String False
LastModifiedDate Datetime False
RoundAmountCurrency String False
RoundAmount Decimal False
RoundOption String False
RoundPolicy String False
UofMSalesOption String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

PurchaseInvoice

Return a list of: PurchaseInvoice

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
Amount1099Currency String False
Amount1099 Decimal False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
CreatedBy String False
CreatedDate Datetime False
CurrencyKeyISOCode String False
Date Datetime False
DistributionsAggregate String False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxAmountCurrency String False
FreightTaxAmount Decimal False
FreightTaxBasis String False
FreightTaxScheduleId String False
FreightTaxesAggregate String False
GeneralLedgerPostingDate Datetime False
Id [KEY] String False
LinesAggregate String False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxAmountCurrency String False
MiscellaneousTaxAmount Decimal False
MiscellaneousTaxBasis String False
MiscellaneousTaxScheduleId String False
MiscellaneousTaxesAggregate String False
ModifiedDate Datetime False
PaymentTermsId String False
PostedBy String False
PostedDate Datetime False
Reference String False
RemitToAddressId String False
SubtotalCurrency String False
Subtotal Decimal False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxScheduleId String False
TaxesAggregate String False
TermsDiscountItem String False
TermsDiscountAvailableAmountCurrency String False
TermsDiscountAvailableAmount Decimal False
TermsDiscountDate Datetime False
TermsDueDate Datetime False
TradeDiscountAmountCurrency String False
TradeDiscountAmount Decimal False
TransactionState String False
VendorDocumentNumber String False
VendorId String False
VendorName String False
VoucherNumber String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

PurchaseOrder

Return a list of: PurchaseOrder

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
BackoutFreightTaxAmountCurrency String False
BackoutFreightTaxAmount Decimal False
BackoutMiscellaneousTaxAmountCurrency String False
BackoutMiscellaneousTaxAmount Decimal False
BackoutTaxAmountCurrency String False
BackoutTaxAmount Decimal False
BillToAddressId String False
BuyerId String False
CanceledSubtotalCurrency String False
CanceledSubtotal Decimal False
Comment String False
CommentId String False
ConfirmWith String False
ContractEndDate Datetime False
ContractNumber String False
CreatedBy String False
CreatedDate Datetime False
CurrencyKeyISOCode String False
CustomerId String False
Date Datetime False
DoesAllowSalesOrderCommitments Bool False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxAmountCurrency String False
FreightTaxAmount Decimal False
FreightTaxBasis String False
FreightTaxScheduleId String False
FreightTaxesAggregate String False
IsOnHold Bool False
Id [KEY] String False
LastEditDate Datetime False
LastPrintedDate Datetime False
LinesAggregate String False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxAmountCurrency String False
MiscellaneousTaxAmount Decimal False
MiscellaneousTaxBasis String False
MiscellaneousTaxScheduleId String False
MiscellaneousTaxesAggregate String False
ModifiedDate Datetime False
PaymentTermsId String False
PromisedDate Datetime False
PromisedShipDate Datetime False
PurchaseAddressExtensionsExtensionAggregate String False
PurchaseAddressCity String False
PurchaseAddressLine1 String False
PurchaseAddressLine2 String False
PurchaseAddressLine3 String False
PurchaseAddressPostalCode String False
PurchaseAddressState String False
PurchaseAddressCountryRegion String False
PurchaseAddressFaxCountryCode String False
PurchaseAddressFaxExtension String False
PurchaseAddressFax String False
PurchaseAddressPhone1CountryCode String False
PurchaseAddressPhone1Extension String False
PurchaseAddressPhone1 String False
PurchaseAddressPhone2CountryCode String False
PurchaseAddressPhone2Extension String False
PurchaseAddressPhone2 String False
PurchaseAddressPhone3CountryCode String False
PurchaseAddressPhone3Extension String False
PurchaseAddressPhone3 String False
PurchaseAddressCountryRegionCodeId String False
PurchaseAddressContactPerson String False
PurchaseAddressName String False
PurchaseAddressId String False
RemainingSubtotalCurrency String False
RemainingSubtotal Decimal False
RequestedDate Datetime False
RequisitionDate Datetime False
RevisionNumber Int False
ShipToAddressExtensionsExtensionAggregate String False
ShipToAddressCity String False
ShipToAddressLine1 String False
ShipToAddressLine2 String False
ShipToAddressLine3 String False
ShipToAddressPostalCode String False
ShipToAddressState String False
ShipToAddressCountryRegion String False
ShipToAddressFaxCountryCode String False
ShipToAddressFaxExtension String False
ShipToAddressFax String False
ShipToAddressPhone1CountryCode String False
ShipToAddressPhone1Extension String False
ShipToAddressPhone1 String False
ShipToAddressPhone2CountryCode String False
ShipToAddressPhone2Extension String False
ShipToAddressPhone2 String False
ShipToAddressPhone3CountryCode String False
ShipToAddressPhone3Extension String False
ShipToAddressPhone3 String False
ShipToAddressCountryRegionCodeId String False
ShipToAddressContactPerson String False
ShipToAddressName String False
ShipToAddressId String False
ShippingMethodId String False
Status String False
StatusGroup String False
SubtotalCurrency String False
Subtotal Decimal False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxRegistrationNumber String False
TaxScheduleId String False
TaxesAggregate String False
TermsDiscountItem String False
TermsDiscountAvailableAmountCurrency String False
TermsDiscountAvailableAmount Decimal False
TermsDiscountDate Datetime False
TermsDueDate Datetime False
TimesPrinted Int False
TotalAmountCurrency String False
TotalAmount Decimal False
TradeDiscountAmountCurrency String False
TradeDiscountAmount Decimal False
TransactionState String False
Type String False
VendorId String False
VendorName String False
WorkflowPriority String False
WorkflowsAggregate String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

PurchaseReceipt

Return a list of: PurchaseReceipt

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
ActualShipDate Datetime False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
CreatedBy String False
CreatedDate Datetime False
CurrencyKeyISOCode String False
Date Datetime False
DistributionsAggregate String False
ExchangeDate Datetime False
ExchangeRate Decimal False
GeneralLedgerPostingDate Datetime False
Id [KEY] String False
LinesAggregate String False
ModifiedDate Datetime False
PostedBy String False
PostedDate Datetime False
Reference String False
RemitToAddressId String False
SubtotalCurrency String False
Subtotal Decimal False
TotalLandedCostAmountCurrency String False
TotalLandedCostAmount Decimal False
TransactionState String False
UserDefinedAggregate String False
VendorDocumentNumber String False
VendorId String False
VendorName String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ReceivablesCreditMemo

Return a list of: ReceivablesCreditMemo

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AddressKeyCustomerId String False
AddressId String False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
CorporateAccountId String False
CostAmountCurrency String False
CostAmount Decimal False
CurrencyKeyISOCode String False
CurrentDocumentAmountCurrency String False
CurrentDocumentAmount Decimal False
CustomerId String False
CustomerName String False
CustomerPONumber String False
Date Datetime False
Description String False
DistributionsAggregate String False
DocumentAmountCurrency String False
DocumentAmount Decimal False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxScheduleId String False
GeneralLedgerPostingDate Datetime False
InvoicePaidOffDate Datetime False
IsDeleted Bool False
IsDirectDebitDocument Bool False
IsElectronic Bool False
IsIntrastatDocument Bool False
IsVoided Bool False
Id [KEY] String False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxScheduleId String False
ModifiedBy String False
ModifiedDate Datetime False
PostedBy String False
PostedDate Datetime False
SalesAmountCurrency String False
SalesAmount Decimal False
SalesTaxScheduleId String False
SalesTerritoryId String False
SalespersonId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxScheduleId String False
TaxesAggregate String False
TradeDiscountAmountCurrency String False
TradeDiscountAmount Decimal False
TransactionState String False
Type String False
VoidDate Datetime False
DiscountReturnedCurrency String False
DiscountReturned Decimal False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ReceivablesDebitMemo

Return a list of: ReceivablesDebitMemo

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AddressKeyCustomerId String False
AddressId String False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
CorporateAccountId String False
CostAmountCurrency String False
CostAmount Decimal False
CurrencyKeyISOCode String False
CurrentDocumentAmountCurrency String False
CurrentDocumentAmount Decimal False
CustomerId String False
CustomerName String False
CustomerPONumber String False
Date Datetime False
Description String False
DistributionsAggregate String False
DocumentAmountCurrency String False
DocumentAmount Decimal False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxScheduleId String False
GeneralLedgerPostingDate Datetime False
InvoicePaidOffDate Datetime False
IsDeleted Bool False
IsDirectDebitDocument Bool False
IsElectronic Bool False
IsIntrastatDocument Bool False
IsVoided Bool False
Id [KEY] String False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxScheduleId String False
ModifiedBy String False
ModifiedDate Datetime False
PostedBy String False
PostedDate Datetime False
SalesAmountCurrency String False
SalesAmount Decimal False
SalesTaxScheduleId String False
SalesTerritoryId String False
SalespersonId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxScheduleId String False
TaxesAggregate String False
TradeDiscountAmountCurrency String False
TradeDiscountAmount Decimal False
TransactionState String False
Type String False
VoidDate Datetime False
GSTDiscountAmountCurrency String False
GSTDiscountAmount Decimal False
PaymentCashAmountCurrency String False
PaymentCashAmount Decimal False
PaymentCashBankAccountId String False
PaymentCashDate Datetime False
PaymentCashNumber String False
PaymentCheckAmountCurrency String False
PaymentCheckAmount Decimal False
PaymentCheckBankAccountId String False
PaymentCheckCheckNumber String False
PaymentCheckDate Datetime False
PaymentCheckNumber String False
PaymentPaymentCardAmountCurrency String False
PaymentPaymentCardAmount Decimal False
PaymentPaymentCardDate Datetime False
PaymentPaymentCardNumber String False
PaymentPaymentCardReceiptNumber String False
PaymentPaymentCardTypeId String False
PaymentPaymentCardBankAccountId String False
PaymentTermsId String False
TermsDiscountItem String False
TermsDiscountAvailableAmountCurrency String False
TermsDiscountAvailableAmount Decimal False
TermsDiscountDate Datetime False
TermsDueDate Datetime False
TermsDiscountAvailableTakenAmountCurrency String False
TermsDiscountAvailableTakenAmount Decimal False
TermsDiscountTakenAmountCurrency String False
TermsDiscountTakenAmount Decimal False
WriteoffAmountCurrency String False
WriteoffAmount Decimal False
CommissionAmountCurrency String False
CommissionAmount Decimal False
CommissionBasedOn String False
CommissionsAggregate String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ReceivablesFinanceCharge

Return a list of: ReceivablesFinanceCharge

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AddressKeyCustomerId String False
AddressId String False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
CorporateAccountId String False
CostAmountCurrency String False
CostAmount Decimal False
CurrencyKeyISOCode String False
CurrentDocumentAmountCurrency String False
CurrentDocumentAmount Decimal False
CustomerId String False
CustomerName String False
CustomerPONumber String False
Date Datetime False
Description String False
DistributionsAggregate String False
DocumentAmountCurrency String False
DocumentAmount Decimal False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxScheduleId String False
GeneralLedgerPostingDate Datetime False
InvoicePaidOffDate Datetime False
IsDeleted Bool False
IsDirectDebitDocument Bool False
IsElectronic Bool False
IsIntrastatDocument Bool False
IsVoided Bool False
Id [KEY] String False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxScheduleId String False
ModifiedBy String False
ModifiedDate Datetime False
PostedBy String False
PostedDate Datetime False
SalesAmountCurrency String False
SalesAmount Decimal False
SalesTaxScheduleId String False
SalesTerritoryId String False
SalespersonId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxScheduleId String False
TaxesAggregate String False
TradeDiscountAmountCurrency String False
TradeDiscountAmount Decimal False
TransactionState String False
Type String False
VoidDate Datetime False
GSTDiscountAmountCurrency String False
GSTDiscountAmount Decimal False
PaymentCashAmountCurrency String False
PaymentCashAmount Decimal False
PaymentCashBankAccountId String False
PaymentCashDate Datetime False
PaymentCashNumber String False
PaymentCheckAmountCurrency String False
PaymentCheckAmount Decimal False
PaymentCheckBankAccountId String False
PaymentCheckCheckNumber String False
PaymentCheckDate Datetime False
PaymentCheckNumber String False
PaymentPaymentCardAmountCurrency String False
PaymentPaymentCardAmount Decimal False
PaymentPaymentCardDate Datetime False
PaymentPaymentCardNumber String False
PaymentPaymentCardReceiptNumber String False
PaymentPaymentCardTypeId String False
PaymentPaymentCardBankAccountId String False
PaymentTermsId String False
TermsDiscountItem String False
TermsDiscountAvailableAmountCurrency String False
TermsDiscountAvailableAmount Decimal False
TermsDiscountDate Datetime False
TermsDueDate Datetime False
TermsDiscountAvailableTakenAmountCurrency String False
TermsDiscountAvailableTakenAmount Decimal False
TermsDiscountTakenAmountCurrency String False
TermsDiscountTakenAmount Decimal False
WriteoffAmountCurrency String False
WriteoffAmount Decimal False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ReceivablesInvoice

Return a list of: ReceivablesInvoice

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AddressKeyCustomerId String False
AddressId String False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
CorporateAccountId String False
CostAmountCurrency String False
CostAmount Decimal False
CurrencyKeyISOCode String False
CurrentDocumentAmountCurrency String False
CurrentDocumentAmount Decimal False
CustomerId String False
CustomerName String False
CustomerPONumber String False
Date Datetime False
Description String False
DistributionsAggregate String False
DocumentAmountCurrency String False
DocumentAmount Decimal False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxScheduleId String False
GeneralLedgerPostingDate Datetime False
InvoicePaidOffDate Datetime False
IsDeleted Bool False
IsDirectDebitDocument Bool False
IsElectronic Bool False
IsIntrastatDocument Bool False
IsVoided Bool False
Id [KEY] String False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxScheduleId String False
ModifiedBy String False
ModifiedDate Datetime False
PostedBy String False
PostedDate Datetime False
SalesAmountCurrency String False
SalesAmount Decimal False
SalesTaxScheduleId String False
SalesTerritoryId String False
SalespersonId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxScheduleId String False
TaxesAggregate String False
TradeDiscountAmountCurrency String False
TradeDiscountAmount Decimal False
TransactionState String False
Type String False
VoidDate Datetime False
GSTDiscountAmountCurrency String False
GSTDiscountAmount Decimal False
PaymentCashAmountCurrency String False
PaymentCashAmount Decimal False
PaymentCashBankAccountId String False
PaymentCashDate Datetime False
PaymentCashNumber String False
PaymentCheckAmountCurrency String False
PaymentCheckAmount Decimal False
PaymentCheckBankAccountId String False
PaymentCheckCheckNumber String False
PaymentCheckDate Datetime False
PaymentCheckNumber String False
PaymentPaymentCardAmountCurrency String False
PaymentPaymentCardAmount Decimal False
PaymentPaymentCardDate Datetime False
PaymentPaymentCardNumber String False
PaymentPaymentCardReceiptNumber String False
PaymentPaymentCardTypeId String False
PaymentPaymentCardBankAccountId String False
PaymentTermsId String False
TermsDiscountItem String False
TermsDiscountAvailableAmountCurrency String False
TermsDiscountAvailableAmount Decimal False
TermsDiscountDate Datetime False
TermsDueDate Datetime False
TermsDiscountAvailableTakenAmountCurrency String False
TermsDiscountAvailableTakenAmount Decimal False
TermsDiscountTakenAmountCurrency String False
TermsDiscountTakenAmount Decimal False
WriteoffAmountCurrency String False
WriteoffAmount Decimal False
CommissionAmountCurrency String False
CommissionAmount Decimal False
CommissionBasedOn String False
CommissionsAggregate String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ReceivablesReturn

Return a list of: ReceivablesReturn

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AddressKeyCustomerId String False
AddressId String False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
CorporateAccountId String False
CostAmountCurrency String False
CostAmount Decimal False
CurrencyKeyISOCode String False
CurrentDocumentAmountCurrency String False
CurrentDocumentAmount Decimal False
CustomerId String False
CustomerName String False
CustomerPONumber String False
Date Datetime False
Description String False
DistributionsAggregate String False
DocumentAmountCurrency String False
DocumentAmount Decimal False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxScheduleId String False
GeneralLedgerPostingDate Datetime False
InvoicePaidOffDate Datetime False
IsDeleted Bool False
IsDirectDebitDocument Bool False
IsElectronic Bool False
IsIntrastatDocument Bool False
IsVoided Bool False
Id [KEY] String False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxScheduleId String False
ModifiedBy String False
ModifiedDate Datetime False
PostedBy String False
PostedDate Datetime False
SalesAmountCurrency String False
SalesAmount Decimal False
SalesTaxScheduleId String False
SalesTerritoryId String False
SalespersonId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxScheduleId String False
TaxesAggregate String False
TradeDiscountAmountCurrency String False
TradeDiscountAmount Decimal False
TransactionState String False
Type String False
VoidDate Datetime False
DiscountReturnedCurrency String False
DiscountReturned Decimal False
CommissionAmountCurrency String False
CommissionAmount Decimal False
CommissionBasedOn String False
CommissionsAggregate String False
PaymentCashAmountCurrency String False
PaymentCashAmount Decimal False
PaymentCashBankAccountId String False
PaymentCashDate Datetime False
PaymentCashNumber String False
PaymentCheckAmountCurrency String False
PaymentCheckAmount Decimal False
PaymentCheckBankAccountId String False
PaymentCheckCheckNumber String False
PaymentCheckDate Datetime False
PaymentCheckNumber String False
PaymentPaymentCardAmountCurrency String False
PaymentPaymentCardAmount Decimal False
PaymentPaymentCardDate Datetime False
PaymentPaymentCardNumber String False
PaymentPaymentCardReceiptNumber String False
PaymentPaymentCardTypeId String False
PaymentPaymentCardBankAccountId String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ReceivablesServiceRepair

Return a list of: ReceivablesServiceRepair

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AddressKeyCustomerId String False
AddressId String False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
CorporateAccountId String False
CostAmountCurrency String False
CostAmount Decimal False
CurrencyKeyISOCode String False
CurrentDocumentAmountCurrency String False
CurrentDocumentAmount Decimal False
CustomerId String False
CustomerName String False
CustomerPONumber String False
Date Datetime False
Description String False
DistributionsAggregate String False
DocumentAmountCurrency String False
DocumentAmount Decimal False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxScheduleId String False
GeneralLedgerPostingDate Datetime False
InvoicePaidOffDate Datetime False
IsDeleted Bool False
IsDirectDebitDocument Bool False
IsElectronic Bool False
IsIntrastatDocument Bool False
IsVoided Bool False
Id [KEY] String False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxScheduleId String False
ModifiedBy String False
ModifiedDate Datetime False
PostedBy String False
PostedDate Datetime False
SalesAmountCurrency String False
SalesAmount Decimal False
SalesTaxScheduleId String False
SalesTerritoryId String False
SalespersonId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxScheduleId String False
TaxesAggregate String False
TradeDiscountAmountCurrency String False
TradeDiscountAmount Decimal False
TransactionState String False
Type String False
VoidDate Datetime False
GSTDiscountAmountCurrency String False
GSTDiscountAmount Decimal False
PaymentCashAmountCurrency String False
PaymentCashAmount Decimal False
PaymentCashBankAccountId String False
PaymentCashDate Datetime False
PaymentCashNumber String False
PaymentCheckAmountCurrency String False
PaymentCheckAmount Decimal False
PaymentCheckBankAccountId String False
PaymentCheckCheckNumber String False
PaymentCheckDate Datetime False
PaymentCheckNumber String False
PaymentPaymentCardAmountCurrency String False
PaymentPaymentCardAmount Decimal False
PaymentPaymentCardDate Datetime False
PaymentPaymentCardNumber String False
PaymentPaymentCardReceiptNumber String False
PaymentPaymentCardTypeId String False
PaymentPaymentCardBankAccountId String False
PaymentTermsId String False
TermsDiscountItem String False
TermsDiscountAvailableAmountCurrency String False
TermsDiscountAvailableAmount Decimal False
TermsDiscountDate Datetime False
TermsDueDate Datetime False
TermsDiscountAvailableTakenAmountCurrency String False
TermsDiscountAvailableTakenAmount Decimal False
TermsDiscountTakenAmountCurrency String False
TermsDiscountTakenAmount Decimal False
WriteoffAmountCurrency String False
WriteoffAmount Decimal False
CommissionAmountCurrency String False
CommissionAmount Decimal False
CommissionBasedOn String False
CommissionsAggregate String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ReceivablesWarranty

Return a list of: ReceivablesWarranty

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AddressKeyCustomerId String False
AddressId String False
AuditTrailCode String False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
CorporateAccountId String False
CostAmountCurrency String False
CostAmount Decimal False
CurrencyKeyISOCode String False
CurrentDocumentAmountCurrency String False
CurrentDocumentAmount Decimal False
CustomerId String False
CustomerName String False
CustomerPONumber String False
Date Datetime False
Description String False
DistributionsAggregate String False
DocumentAmountCurrency String False
DocumentAmount Decimal False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxScheduleId String False
GeneralLedgerPostingDate Datetime False
InvoicePaidOffDate Datetime False
IsDeleted Bool False
IsDirectDebitDocument Bool False
IsElectronic Bool False
IsIntrastatDocument Bool False
IsVoided Bool False
Id [KEY] String False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxScheduleId String False
ModifiedBy String False
ModifiedDate Datetime False
PostedBy String False
PostedDate Datetime False
SalesAmountCurrency String False
SalesAmount Decimal False
SalesTaxScheduleId String False
SalesTerritoryId String False
SalespersonId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxScheduleId String False
TaxesAggregate String False
TradeDiscountAmountCurrency String False
TradeDiscountAmount Decimal False
TransactionState String False
Type String False
VoidDate Datetime False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ReturnMaterialAuthorization

Return a list of: ReturnMaterialAuthorization

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
BillToAddressId String False
BillToCustomerId String False
CurrencyKeyISOCode String False
CustomerId String False
CustomerName String False
CustomerPONumber String False
EntryDateTime Datetime False
EstimatedArrivalDateTime Datetime False
ExchangeDate Datetime False
ExchangeRate Decimal False
FrontOfficeIntegrationId String False
Id [KEY] String False
Note String False
OfficeId String False
RateTypeId String False
ShipToAddressId String False
TransactionState String False
UserDefined01 String False
UserDefined02 String False
UserDefined03 String False
UserDefined04 String False
UserDefined05 String False
AuditsAggregate String False
BillOfLading String False
ClosedDateTime Datetime False
CommitDateTime Datetime False
CreatedBy String False
IsFromServiceCall Bool False
IsReceived Bool False
LinesAggregate String False
OriginatingDocumentId String False
OriginatingDocumentType String False
ReasonCodeDescription String False
ReasonCodeId String False
ReturnDateTime Datetime False
ReturnStatus String False
ReturnStatusCodeId String False
ReturnToAddressExtensionsExtensionAggregate String False
ReturnToAddressCity String False
ReturnToAddressLine1 String False
ReturnToAddressLine2 String False
ReturnToAddressLine3 String False
ReturnToAddressPostalCode String False
ReturnToAddressState String False
ReturnToAddressCountryRegion String False
ReturnToAddressName String False
ReturnTypeId String False
ReturnWarehouseId String False
ShipToAddressExtensionsExtensionAggregate String False
ShipToAddressCity String False
ShipToAddressLine1 String False
ShipToAddressLine2 String False
ShipToAddressLine3 String False
ShipToAddressPostalCode String False
ShipToAddressState String False
ShipToAddressCountryRegion String False
ShipToAddressContactPerson String False
ShippingMethodId String False
Type String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

SalesBackorder

Return a list of: SalesBackorder

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
ActualShipDate Datetime False
AuditTrailCode String False
BackorderDate Datetime False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
BillToAddressKeyCustomerId String False
BillToAddressId String False
Comment String False
CommentId String False
CommissionAmountCurrency String False
CommissionAmount Decimal False
CommissionBasedOn String False
CommissionSaleAmountCurrency String False
CommissionSaleAmount Decimal False
CommissionsAggregate String False
CreatedBy String False
CreatedDate Datetime False
CurrencyKeyISOCode String False
CustomerId String False
CustomerName String False
CustomerPONumber String False
Date Datetime False
DiscountAmountCurrency String False
DiscountAmount Decimal False
DocumentTypeId String False
DocumentTypeKeyType String False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxAmountCurrency String False
FreightTaxAmount Decimal False
FreightTaxBasis String False
FreightTaxScheduleId String False
FreightTaxesAggregate String False
FrontOfficeIntegrationId String False
FulfillDate Datetime False
IntegrationId String False
IntegrationSource Int False
InvoiceDate Datetime False
IsIntrastatDocument Bool False
IsVoided Bool False
Id [KEY] String False
LastModifiedDate Datetime False
LineTotalAmountCurrency String False
LineTotalAmount Decimal False
MasterNumber Int False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxAmountCurrency String False
MiscellaneousTaxAmount Decimal False
MiscellaneousTaxBasis String False
MiscellaneousTaxScheduleId String False
MiscellaneousTaxesAggregate String False
ModifiedDate Datetime False
Note String False
OriginalSalesDocumentId String False
OriginalSalesDocumentType String False
PaymentTermsId String False
PriceLevelId String False
ProcessHoldsAggregate String False
QuoteDate Datetime False
Reference String False
RequestedShipDate Datetime False
ReturnDate Datetime False
SalesTerritoryId String False
SalespersonId String False
ShipCompleteOnly Bool False
ShipToAddressExtensionsExtensionAggregate String False
ShipToAddressCity String False
ShipToAddressLine1 String False
ShipToAddressLine2 String False
ShipToAddressLine3 String False
ShipToAddressPostalCode String False
ShipToAddressState String False
ShipToAddressCountryRegion String False
ShipToAddressFaxCountryCode String False
ShipToAddressFaxExtension String False
ShipToAddressFax String False
ShipToAddressPhone1CountryCode String False
ShipToAddressPhone1Extension String False
ShipToAddressPhone1 String False
ShipToAddressPhone2CountryCode String False
ShipToAddressPhone2Extension String False
ShipToAddressPhone2 String False
ShipToAddressPhone3CountryCode String False
ShipToAddressPhone3Extension String False
ShipToAddressPhone3 String False
ShipToAddressCountryRegionCodeId String False
ShipToAddressContactPerson String False
ShipToAddressName String False
ShipToAddressKeyCustomerId String False
ShipToAddressId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxExemptNumber1 String False
TaxExemptNumber2 String False
TaxRegistrationNumber String False
TaxScheduleId String False
TaxesAggregate String False
TotalAmountCurrency String False
TotalAmount Decimal False
TrackingNumbersAggregate String False
TradeDiscountItem String False
TransactionState String False
Type String False
UPSZone String False
UserDefinedDate01 Datetime False
UserDefinedDate02 Datetime False
UserDefinedList01 String False
UserDefinedList02 String False
UserDefinedList03 String False
UserDefinedText01 String False
UserDefinedText02 String False
UserDefinedText03 String False
UserDefinedText04 String False
UserDefinedText05 String False
WarehouseId String False
DepositAmountCurrency String False
DepositAmount Decimal False
LinesAggregate String False
PaymentAmountCurrency String False
PaymentAmount Decimal False
PaymentsAggregate String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

SalesFulfillmentOrder

Return a list of: SalesFulfillmentOrder

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
ActualShipDate Datetime False
AuditTrailCode String False
BackorderDate Datetime False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
BillToAddressKeyCustomerId String False
BillToAddressId String False
Comment String False
CommentId String False
CommissionAmountCurrency String False
CommissionAmount Decimal False
CommissionBasedOn String False
CommissionSaleAmountCurrency String False
CommissionSaleAmount Decimal False
CommissionsAggregate String False
CreatedBy String False
CreatedDate Datetime False
CurrencyKeyISOCode String False
CustomerId String False
CustomerName String False
CustomerPONumber String False
Date Datetime False
DiscountAmountCurrency String False
DiscountAmount Decimal False
DocumentTypeId String False
DocumentTypeKeyType String False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxAmountCurrency String False
FreightTaxAmount Decimal False
FreightTaxBasis String False
FreightTaxScheduleId String False
FreightTaxesAggregate String False
FrontOfficeIntegrationId String False
FulfillDate Datetime False
IntegrationId String False
IntegrationSource Int False
InvoiceDate Datetime False
IsIntrastatDocument Bool False
IsVoided Bool False
Id [KEY] String False
LastModifiedDate Datetime False
LineTotalAmountCurrency String False
LineTotalAmount Decimal False
MasterNumber Int False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxAmountCurrency String False
MiscellaneousTaxAmount Decimal False
MiscellaneousTaxBasis String False
MiscellaneousTaxScheduleId String False
MiscellaneousTaxesAggregate String False
ModifiedDate Datetime False
Note String False
OriginalSalesDocumentId String False
OriginalSalesDocumentType String False
PaymentTermsId String False
PriceLevelId String False
ProcessHoldsAggregate String False
QuoteDate Datetime False
Reference String False
RequestedShipDate Datetime False
ReturnDate Datetime False
SalesTerritoryId String False
SalespersonId String False
ShipCompleteOnly Bool False
ShipToAddressExtensionsExtensionAggregate String False
ShipToAddressCity String False
ShipToAddressLine1 String False
ShipToAddressLine2 String False
ShipToAddressLine3 String False
ShipToAddressPostalCode String False
ShipToAddressState String False
ShipToAddressCountryRegion String False
ShipToAddressFaxCountryCode String False
ShipToAddressFaxExtension String False
ShipToAddressFax String False
ShipToAddressPhone1CountryCode String False
ShipToAddressPhone1Extension String False
ShipToAddressPhone1 String False
ShipToAddressPhone2CountryCode String False
ShipToAddressPhone2Extension String False
ShipToAddressPhone2 String False
ShipToAddressPhone3CountryCode String False
ShipToAddressPhone3Extension String False
ShipToAddressPhone3 String False
ShipToAddressCountryRegionCodeId String False
ShipToAddressContactPerson String False
ShipToAddressName String False
ShipToAddressKeyCustomerId String False
ShipToAddressId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxExemptNumber1 String False
TaxExemptNumber2 String False
TaxRegistrationNumber String False
TaxScheduleId String False
TaxesAggregate String False
TotalAmountCurrency String False
TotalAmount Decimal False
TrackingNumbersAggregate String False
TradeDiscountItem String False
TransactionState String False
Type String False
UPSZone String False
UserDefinedDate01 Datetime False
UserDefinedDate02 Datetime False
UserDefinedList01 String False
UserDefinedList02 String False
UserDefinedList03 String False
UserDefinedText01 String False
UserDefinedText02 String False
UserDefinedText03 String False
UserDefinedText04 String False
UserDefinedText05 String False
WarehouseId String False
DepositAmountCurrency String False
DepositAmount Decimal False
DistributionsAggregate String False
GeneralLedgerPostingDate Datetime False
IsDirectDebit Bool False
LinesAggregate String False
PaymentAmountCurrency String False
PaymentAmount Decimal False
PaymentsAggregate String False
PostedBy String False
PostedDate Datetime False
ShippingProcessStatus String False
TermsDiscountItem String False
TermsDiscountAvailableAmountCurrency String False
TermsDiscountAvailableAmount Decimal False
TermsDiscountDate Datetime False
TermsDueDate Datetime False
TermsDiscountTakenAmountCurrency String False
TermsDiscountTakenAmount Decimal False
WorkflowPriority String False
WorkflowsAggregate String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

SalesInvoice

Return a list of: SalesInvoice

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
ActualShipDate Datetime False
AuditTrailCode String False
BackorderDate Datetime False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
BillToAddressKeyCustomerId String False
BillToAddressId String False
Comment String False
CommentId String False
CommissionAmountCurrency String False
CommissionAmount Decimal False
CommissionBasedOn String False
CommissionSaleAmountCurrency String False
CommissionSaleAmount Decimal False
CommissionsAggregate String False
CreatedBy String False
CreatedDate Datetime False
CurrencyKeyISOCode String False
CustomerId String False
CustomerName String False
CustomerPONumber String False
Date Datetime False
DiscountAmountCurrency String False
DiscountAmount Decimal False
DocumentTypeId String False
DocumentTypeKeyType String False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxAmountCurrency String False
FreightTaxAmount Decimal False
FreightTaxBasis String False
FreightTaxScheduleId String False
FreightTaxesAggregate String False
FrontOfficeIntegrationId String False
FulfillDate Datetime False
IntegrationId String False
IntegrationSource Int False
InvoiceDate Datetime False
IsIntrastatDocument Bool False
IsVoided Bool False
Id [KEY] String False
LastModifiedDate Datetime False
LineTotalAmountCurrency String False
LineTotalAmount Decimal False
MasterNumber Int False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxAmountCurrency String False
MiscellaneousTaxAmount Decimal False
MiscellaneousTaxBasis String False
MiscellaneousTaxScheduleId String False
MiscellaneousTaxesAggregate String False
ModifiedDate Datetime False
Note String False
OriginalSalesDocumentId String False
OriginalSalesDocumentType String False
PaymentTermsId String False
PriceLevelId String False
ProcessHoldsAggregate String False
QuoteDate Datetime False
Reference String False
RequestedShipDate Datetime False
ReturnDate Datetime False
SalesTerritoryId String False
SalespersonId String False
ShipCompleteOnly Bool False
ShipToAddressExtensionsExtensionAggregate String False
ShipToAddressCity String False
ShipToAddressLine1 String False
ShipToAddressLine2 String False
ShipToAddressLine3 String False
ShipToAddressPostalCode String False
ShipToAddressState String False
ShipToAddressCountryRegion String False
ShipToAddressFaxCountryCode String False
ShipToAddressFaxExtension String False
ShipToAddressFax String False
ShipToAddressPhone1CountryCode String False
ShipToAddressPhone1Extension String False
ShipToAddressPhone1 String False
ShipToAddressPhone2CountryCode String False
ShipToAddressPhone2Extension String False
ShipToAddressPhone2 String False
ShipToAddressPhone3CountryCode String False
ShipToAddressPhone3Extension String False
ShipToAddressPhone3 String False
ShipToAddressCountryRegionCodeId String False
ShipToAddressContactPerson String False
ShipToAddressName String False
ShipToAddressKeyCustomerId String False
ShipToAddressId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxExemptNumber1 String False
TaxExemptNumber2 String False
TaxRegistrationNumber String False
TaxScheduleId String False
TaxesAggregate String False
TotalAmountCurrency String False
TotalAmount Decimal False
TrackingNumbersAggregate String False
TradeDiscountItem String False
TransactionState String False
Type String False
UPSZone String False
UserDefinedDate01 Datetime False
UserDefinedDate02 Datetime False
UserDefinedList01 String False
UserDefinedList02 String False
UserDefinedList03 String False
UserDefinedText01 String False
UserDefinedText02 String False
UserDefinedText03 String False
UserDefinedText04 String False
UserDefinedText05 String False
WarehouseId String False
DepositAmountCurrency String False
DepositAmount Decimal False
DistributionsAggregate String False
GeneralLedgerPostingDate Datetime False
IsDirectDebit Bool False
LinesAggregate String False
PaymentAmountCurrency String False
PaymentAmount Decimal False
PaymentsAggregate String False
PostedBy String False
PostedDate Datetime False
TermsDiscountItem String False
TermsDiscountAvailableAmountCurrency String False
TermsDiscountAvailableAmount Decimal False
TermsDiscountDate Datetime False
TermsDueDate Datetime False
TermsDiscountTakenAmountCurrency String False
TermsDiscountTakenAmount Decimal False
WorkflowPriority String False
WorkflowsAggregate String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

SalesOrder

Return a list of: SalesOrder

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
ActualShipDate Datetime False
AuditTrailCode String False
BackorderDate Datetime False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
BillToAddressKeyCustomerId String False
BillToAddressId String False
Comment String False
CommentId String False
CommissionAmountCurrency String False
CommissionAmount Decimal False
CommissionBasedOn String False
CommissionSaleAmountCurrency String False
CommissionSaleAmount Decimal False
CommissionsAggregate String False
CreatedBy String False
CreatedDate Datetime False
CurrencyKeyISOCode String False
CustomerId String False
CustomerName String False
CustomerPONumber String False
Date Datetime False
DiscountAmountCurrency String False
DiscountAmount Decimal False
DocumentTypeId String False
DocumentTypeKeyType String False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxAmountCurrency String False
FreightTaxAmount Decimal False
FreightTaxBasis String False
FreightTaxScheduleId String False
FreightTaxesAggregate String False
FrontOfficeIntegrationId String False
FulfillDate Datetime False
IntegrationId String False
IntegrationSource Int False
InvoiceDate Datetime False
IsIntrastatDocument Bool False
IsVoided Bool False
Id [KEY] String False
LastModifiedDate Datetime False
LineTotalAmountCurrency String False
LineTotalAmount Decimal False
MasterNumber Int False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxAmountCurrency String False
MiscellaneousTaxAmount Decimal False
MiscellaneousTaxBasis String False
MiscellaneousTaxScheduleId String False
MiscellaneousTaxesAggregate String False
ModifiedDate Datetime False
Note String False
OriginalSalesDocumentId String False
OriginalSalesDocumentType String False
PaymentTermsId String False
PriceLevelId String False
ProcessHoldsAggregate String False
QuoteDate Datetime False
Reference String False
RequestedShipDate Datetime False
ReturnDate Datetime False
SalesTerritoryId String False
SalespersonId String False
ShipCompleteOnly Bool False
ShipToAddressExtensionsExtensionAggregate String False
ShipToAddressCity String False
ShipToAddressLine1 String False
ShipToAddressLine2 String False
ShipToAddressLine3 String False
ShipToAddressPostalCode String False
ShipToAddressState String False
ShipToAddressCountryRegion String False
ShipToAddressFaxCountryCode String False
ShipToAddressFaxExtension String False
ShipToAddressFax String False
ShipToAddressPhone1CountryCode String False
ShipToAddressPhone1Extension String False
ShipToAddressPhone1 String False
ShipToAddressPhone2CountryCode String False
ShipToAddressPhone2Extension String False
ShipToAddressPhone2 String False
ShipToAddressPhone3CountryCode String False
ShipToAddressPhone3Extension String False
ShipToAddressPhone3 String False
ShipToAddressCountryRegionCodeId String False
ShipToAddressContactPerson String False
ShipToAddressName String False
ShipToAddressKeyCustomerId String False
ShipToAddressId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxExemptNumber1 String False
TaxExemptNumber2 String False
TaxRegistrationNumber String False
TaxScheduleId String False
TaxesAggregate String False
TotalAmountCurrency String False
TotalAmount Decimal False
TrackingNumbersAggregate String False
TradeDiscountItem String False
TransactionState String False
Type String False
UPSZone String False
UserDefinedDate01 Datetime False
UserDefinedDate02 Datetime False
UserDefinedList01 String False
UserDefinedList02 String False
UserDefinedList03 String False
UserDefinedText01 String False
UserDefinedText02 String False
UserDefinedText03 String False
UserDefinedText04 String False
UserDefinedText05 String False
WarehouseId String False
DaysToIncrement Int False
DepositAmountCurrency String False
DepositAmount Decimal False
DocumentFrequency String False
IsRepeating Bool False
LinesAggregate String False
PaymentAmountCurrency String False
PaymentAmount Decimal False
PaymentsAggregate String False
ShippingProcessStatus String False
TimesToRepeat Int False
WorkflowPriority String False
WorkflowsAggregate String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

SalesProcessHoldSetup

Return a list of: SalesProcessHoldSetup

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
CreatedBy String False
CreatedDate Datetime False
Description String False
IsFulfillHold Bool False
IsPostHold Bool False
IsPrintHold Bool False
IsTransferHold Bool False
Id [KEY] String False
ModifiedDate Datetime False
Password String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

SalesQuote

Return a list of: SalesQuote

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
ActualShipDate Datetime False
AuditTrailCode String False
BackorderDate Datetime False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
BillToAddressKeyCustomerId String False
BillToAddressId String False
Comment String False
CommentId String False
CommissionAmountCurrency String False
CommissionAmount Decimal False
CommissionBasedOn String False
CommissionSaleAmountCurrency String False
CommissionSaleAmount Decimal False
CommissionsAggregate String False
CreatedBy String False
CreatedDate Datetime False
CurrencyKeyISOCode String False
CustomerId String False
CustomerName String False
CustomerPONumber String False
Date Datetime False
DiscountAmountCurrency String False
DiscountAmount Decimal False
DocumentTypeId String False
DocumentTypeKeyType String False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxAmountCurrency String False
FreightTaxAmount Decimal False
FreightTaxBasis String False
FreightTaxScheduleId String False
FreightTaxesAggregate String False
FrontOfficeIntegrationId String False
FulfillDate Datetime False
IntegrationId String False
IntegrationSource Int False
InvoiceDate Datetime False
IsIntrastatDocument Bool False
IsVoided Bool False
Id [KEY] String False
LastModifiedDate Datetime False
LineTotalAmountCurrency String False
LineTotalAmount Decimal False
MasterNumber Int False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxAmountCurrency String False
MiscellaneousTaxAmount Decimal False
MiscellaneousTaxBasis String False
MiscellaneousTaxScheduleId String False
MiscellaneousTaxesAggregate String False
ModifiedDate Datetime False
Note String False
OriginalSalesDocumentId String False
OriginalSalesDocumentType String False
PaymentTermsId String False
PriceLevelId String False
ProcessHoldsAggregate String False
QuoteDate Datetime False
Reference String False
RequestedShipDate Datetime False
ReturnDate Datetime False
SalesTerritoryId String False
SalespersonId String False
ShipCompleteOnly Bool False
ShipToAddressExtensionsExtensionAggregate String False
ShipToAddressCity String False
ShipToAddressLine1 String False
ShipToAddressLine2 String False
ShipToAddressLine3 String False
ShipToAddressPostalCode String False
ShipToAddressState String False
ShipToAddressCountryRegion String False
ShipToAddressFaxCountryCode String False
ShipToAddressFaxExtension String False
ShipToAddressFax String False
ShipToAddressPhone1CountryCode String False
ShipToAddressPhone1Extension String False
ShipToAddressPhone1 String False
ShipToAddressPhone2CountryCode String False
ShipToAddressPhone2Extension String False
ShipToAddressPhone2 String False
ShipToAddressPhone3CountryCode String False
ShipToAddressPhone3Extension String False
ShipToAddressPhone3 String False
ShipToAddressCountryRegionCodeId String False
ShipToAddressContactPerson String False
ShipToAddressName String False
ShipToAddressKeyCustomerId String False
ShipToAddressId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxExemptNumber1 String False
TaxExemptNumber2 String False
TaxRegistrationNumber String False
TaxScheduleId String False
TaxesAggregate String False
TotalAmountCurrency String False
TotalAmount Decimal False
TrackingNumbersAggregate String False
TradeDiscountItem String False
TransactionState String False
Type String False
UPSZone String False
UserDefinedDate01 Datetime False
UserDefinedDate02 Datetime False
UserDefinedList01 String False
UserDefinedList02 String False
UserDefinedList03 String False
UserDefinedText01 String False
UserDefinedText02 String False
UserDefinedText03 String False
UserDefinedText04 String False
UserDefinedText05 String False
WarehouseId String False
DaysToIncrement Int False
DocumentFrequency String False
ExpirationDate Datetime False
IsProspect Bool False
IsRepeating Bool False
LinesAggregate String False
TimesToRepeat Int False
WorkflowPriority String False
WorkflowsAggregate String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

SalesReturn

Return a list of: SalesReturn

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
ActualShipDate Datetime False
AuditTrailCode String False
BackorderDate Datetime False
BatchKeyCreatedDateTime Datetime False
BatchId String False
BatchKeySource String False
BillToAddressKeyCustomerId String False
BillToAddressId String False
Comment String False
CommentId String False
CommissionAmountCurrency String False
CommissionAmount Decimal False
CommissionBasedOn String False
CommissionSaleAmountCurrency String False
CommissionSaleAmount Decimal False
CommissionsAggregate String False
CreatedBy String False
CreatedDate Datetime False
CurrencyKeyISOCode String False
CustomerId String False
CustomerName String False
CustomerPONumber String False
Date Datetime False
DiscountAmountCurrency String False
DiscountAmount Decimal False
DocumentTypeId String False
DocumentTypeKeyType String False
ExchangeDate Datetime False
ExchangeRate Decimal False
FreightAmountCurrency String False
FreightAmount Decimal False
FreightTaxAmountCurrency String False
FreightTaxAmount Decimal False
FreightTaxBasis String False
FreightTaxScheduleId String False
FreightTaxesAggregate String False
FrontOfficeIntegrationId String False
FulfillDate Datetime False
IntegrationId String False
IntegrationSource Int False
InvoiceDate Datetime False
IsIntrastatDocument Bool False
IsVoided Bool False
Id [KEY] String False
LastModifiedDate Datetime False
LineTotalAmountCurrency String False
LineTotalAmount Decimal False
MasterNumber Int False
MiscellaneousAmountCurrency String False
MiscellaneousAmount Decimal False
MiscellaneousTaxAmountCurrency String False
MiscellaneousTaxAmount Decimal False
MiscellaneousTaxBasis String False
MiscellaneousTaxScheduleId String False
MiscellaneousTaxesAggregate String False
ModifiedDate Datetime False
Note String False
OriginalSalesDocumentId String False
OriginalSalesDocumentType String False
PaymentTermsId String False
PriceLevelId String False
ProcessHoldsAggregate String False
QuoteDate Datetime False
Reference String False
RequestedShipDate Datetime False
ReturnDate Datetime False
SalesTerritoryId String False
SalespersonId String False
ShipCompleteOnly Bool False
ShipToAddressExtensionsExtensionAggregate String False
ShipToAddressCity String False
ShipToAddressLine1 String False
ShipToAddressLine2 String False
ShipToAddressLine3 String False
ShipToAddressPostalCode String False
ShipToAddressState String False
ShipToAddressCountryRegion String False
ShipToAddressFaxCountryCode String False
ShipToAddressFaxExtension String False
ShipToAddressFax String False
ShipToAddressPhone1CountryCode String False
ShipToAddressPhone1Extension String False
ShipToAddressPhone1 String False
ShipToAddressPhone2CountryCode String False
ShipToAddressPhone2Extension String False
ShipToAddressPhone2 String False
ShipToAddressPhone3CountryCode String False
ShipToAddressPhone3Extension String False
ShipToAddressPhone3 String False
ShipToAddressCountryRegionCodeId String False
ShipToAddressContactPerson String False
ShipToAddressName String False
ShipToAddressKeyCustomerId String False
ShipToAddressId String False
ShippingMethodId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxExemptNumber1 String False
TaxExemptNumber2 String False
TaxRegistrationNumber String False
TaxScheduleId String False
TaxesAggregate String False
TotalAmountCurrency String False
TotalAmount Decimal False
TrackingNumbersAggregate String False
TradeDiscountItem String False
TransactionState String False
Type String False
UPSZone String False
UserDefinedDate01 Datetime False
UserDefinedDate02 Datetime False
UserDefinedList01 String False
UserDefinedList02 String False
UserDefinedList03 String False
UserDefinedText01 String False
UserDefinedText02 String False
UserDefinedText03 String False
UserDefinedText04 String False
UserDefinedText05 String False
WarehouseId String False
DistributionsAggregate String False
GeneralLedgerPostingDate Datetime False
LinesAggregate String False
PaymentAmountCurrency String False
PaymentAmount Decimal False
PaymentsAggregate String False
PostedBy String False
PostedDate Datetime False
TermsDiscountReturnedAmountCurrency String False
TermsDiscountReturnedAmount Decimal False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Service

Return a list of: Service

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
ABCCode String False
AllowBackOrder Bool False
AssemblyVarianceGLAccountId String False
AssemblyVarianceGLAccountKeyIsEncrypted Bool False
ClassId String False
CostofGoodsSoldGLAccountId String False
CostofGoodsSoldGLAccountKeyIsEncrypted Bool False
CreatedDate Datetime False
CurrencyDecimalPlaces String False
CurrentCostCurrency String False
CurrentCost Decimal False
DamagedGLAccountId String False
DamagedGLAccountKeyIsEncrypted Bool False
DefaultPriceLevelId String False
DefaultSellingUofM String False
DefaultWarehouseId String False
Description String False
DropShipGLAccountId String False
DropShipGLAccountKeyIsEncrypted Bool False
FunctionalCurrencyDecimalPlaces String False
GenericDescription String False
InServiceGLAccountId String False
InServiceGLAccountKeyIsEncrypted Bool False
InUseGLAccountId String False
InUseGLAccountKeyIsEncrypted Bool False
IncludeInDemandPlanning Bool False
InternetAddressesAdditionalInformation String False
InternetAddressesEmailBccAddress String False
InternetAddressesEmailCcAddress String False
InternetAddressesEmailToAddress String False
InternetAddressesInternetField1 String False
InternetAddressesInternetField2 String False
InternetAddressesInternetField3 String False
InternetAddressesInternetField4 String False
InternetAddressesInternetField5 String False
InternetAddressesInternetField6 String False
InternetAddressesInternetField7 String False
InternetAddressesInternetField8 String False
InternetAddressesMessengerAddress String False
InventoryGLAccountId String False
InventoryGLAccountKeyIsEncrypted Bool False
InventoryOffsetGLAccountId String False
InventoryOffsetGLAccountKeyIsEncrypted Bool False
InventoryReturnGLAccountId String False
InventoryReturnGLAccountKeyIsEncrypted Bool False
IsDiscontinued Bool False
KeepCalendarYearHistory Bool False
KeepDistributionHistory Bool False
KeepFiscalYearHistory Bool False
KeepTransactionHistory Bool False
Id [KEY] String False
LastModifiedDate Datetime False
MarkdownGLAccountId String False
MarkdownGLAccountKeyIsEncrypted Bool False
ModifiedDate Datetime False
PriceMethod String False
PurchasePriceVarianceGLAccountId String False
PurchasePriceVarianceGLAccountKeyIsEncrypted Bool False
PurchaseTaxBasis String False
PurchaseTaxScheduleId String False
PurchaseUofM String False
QuantityDecimalPlaces String False
SalesGLAccountId String False
SalesGLAccountKeyIsEncrypted Bool False
SalesReturnGLAccountId String False
SalesReturnGLAccountKeyIsEncrypted Bool False
SalesTaxBasis String False
SalesTaxScheduleId String False
ShippingWeight Decimal False
ShortDescription String False
StandardCostCurrency String False
StandardCost Decimal False
SubstituteItem1Id String False
SubstituteItem2Id String False
Type String False
UnrealizedPurchasePriceVarianceGLAccountId String False
UnrealizedPurchasePriceVarianceGLAccountKeyIsEncrypted Bool False
UofMScheduleId String False
UserCategoryList1 String False
UserCategoryList2 String False
UserCategoryList3 String False
UserCategoryList4 String False
UserCategoryList5 String False
UserCategoryList6 String False
VarianceGLAccountId String False
VarianceGLAccountKeyIsEncrypted Bool False
WarrantyDays Short False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ServiceCall

Return a list of: ServiceCall

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
BillToAddressId String False
BillToCustomerId String False
CurrencyKeyISOCode String False
CustomerId String False
CustomerName String False
CustomerPONumber String False
EntryDateTime Datetime False
EstimatedArrivalDateTime Datetime False
ExchangeDate Datetime False
ExchangeRate Decimal False
FrontOfficeIntegrationId String False
Id [KEY] String False
Note String False
OfficeId String False
RateTypeId String False
ShipToAddressId String False
TransactionState String False
UserDefined01 String False
UserDefined02 String False
UserDefined03 String False
UserDefined04 String False
UserDefined05 String False
AuditsAggregate String False
CustomerReference String False
Description String False
DistributionsAggregate String False
DocumentTotalCurrency String False
DocumentTotal Decimal False
EstimatedTimeToRepair Decimal False
IsOnHold Bool False
LaborChargesExtensionsExtensionAggregate String False
LaborChargesBillablePercent Decimal False
LaborChargesTotalAmountCurrency String False
LaborChargesTotalAmount Decimal False
LaborChargesTotalCostCurrency String False
LaborChargesTotalCost Decimal False
MiscellaneousChargesExtensionsExtensionAggregate String False
MiscellaneousChargesBillablePercent Decimal False
MiscellaneousChargesTotalAmountCurrency String False
MiscellaneousChargesTotalAmount Decimal False
MiscellaneousChargesTotalCostCurrency String False
MiscellaneousChargesTotalCost Decimal False
PartsChargesExtensionsExtensionAggregate String False
PartsChargesBillablePercent Decimal False
PartsChargesTotalAmountCurrency String False
PartsChargesTotalAmount Decimal False
PartsChargesTotalCostCurrency String False
PartsChargesTotalCost Decimal False
PaymentTermsId String False
PreTaxDocumentAmountCurrency String False
PreTaxDocumentAmount Decimal False
PriceLevelId String False
Priority Int False
ResponseDateTime Datetime False
SalesPersonId String False
ServiceAreaId String False
ServiceContractId String False
ServiceContractLineSequenceNumber Decimal False
ServiceTypeId String False
ShipToAddressExtensionsExtensionAggregate String False
ShipToAddressCity String False
ShipToAddressLine1 String False
ShipToAddressLine2 String False
ShipToAddressLine3 String False
ShipToAddressPostalCode String False
ShipToAddressState String False
ShipToAddressCountryRegion String False
ShipToAddressContactPerson String False
ShipToAddressPhone1CountryCode String False
ShipToAddressPhone1Extension String False
ShipToAddressPhone1 String False
StatusCodeId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxExemptNumber1 String False
TaxExemptNumber2 String False
TaxScheduleId String False
TechnicianId String False
TimeZoneId String False
AdditionalChargesAggregate String False
ArrivalDateTime Datetime False
CompletionDateTime Datetime False
DispatchDateTime Datetime False
EquipmentCodesAggregate String False
EscalationDateTime Datetime False
EscalationLevel Int False
ExpensesAggregate String False
InvoicedAmountCurrency String False
InvoicedAmount Decimal False
IsCallback Bool False
LaborAggregate String False
Meter1ExtensionsExtensionAggregate String False
Meter1CurrentReading Int False
Meter1Replaced Bool False
Meter1InternalUsage Int False
Meter2ExtensionsExtensionAggregate String False
Meter2CurrentReading Int False
Meter2Replaced Bool False
Meter2InternalUsage Int False
Meter3ExtensionsExtensionAggregate String False
Meter3CurrentReading Int False
Meter3Replaced Bool False
Meter3InternalUsage Int False
Meter4ExtensionsExtensionAggregate String False
Meter4CurrentReading Int False
Meter4Replaced Bool False
Meter4InternalUsage Int False
Meter5ExtensionsExtensionAggregate String False
Meter5CurrentReading Int False
Meter5Replaced Bool False
Meter5InternalUsage Int False
NotifyDateTime Datetime False
PartsAggregate String False
Type String False
WasNotified Bool False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ServiceEquipment

Return a list of: ServiceEquipment

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AddressExtensionsExtensionAggregate String False
AddressCity String False
AddressLine1 String False
AddressLine2 String False
AddressLine3 String False
AddressPostalCode String False
AddressState String False
AddressContactPerson String False
AddressCountry String False
AddressId String False
AssetTag String False
CustomerId String False
InstallDate Datetime False
Id [KEY] String False
KeyItemId [KEY] String False
LastCalculatedDate Datetime False
LastPreventiveMaintenanceDate Datetime False
LastServiceDate Datetime False
Note String False
OfficeId String False
PreventiveMaintenanceDay Int False
PreventiveMaintenanceMonth String False
Quantity Decimal False
ReadingsAggregate String False
Reference String False
RegisterDate Datetime False
SellerWarrantyCodeExtensionsExtensionAggregate String False
SellerWarrantyCodeEndDate Datetime False
SellerWarrantyCodeId String False
SellerWarrantyCodeStartDate Datetime False
SerialNumber String False
ServiceAreaId String False
ShippedDate Datetime False
StatusId String False
TechnicianId String False
TimeZoneId String False
UserDefined01 String False
UserDefined02 String False
UserDefined03 String False
UserDefined04 String False
UserDefined05 String False
VendorId String False
VendorWarrantyCodeExtensionsExtensionAggregate String False
VendorWarrantyCodeEndDate Datetime False
VendorWarrantyCodeId String False
VendorWarrantyCodeStartDate Datetime False
Version String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ServiceQuote

Return a list of: ServiceQuote

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
BillToAddressId String False
BillToCustomerId String False
CurrencyKeyISOCode String False
CustomerId String False
CustomerName String False
CustomerPONumber String False
EntryDateTime Datetime False
EstimatedArrivalDateTime Datetime False
ExchangeDate Datetime False
ExchangeRate Decimal False
FrontOfficeIntegrationId String False
Id [KEY] String False
Note String False
OfficeId String False
RateTypeId String False
ShipToAddressId String False
TransactionState String False
UserDefined01 String False
UserDefined02 String False
UserDefined03 String False
UserDefined04 String False
UserDefined05 String False
AuditsAggregate String False
CustomerReference String False
Description String False
DistributionsAggregate String False
DocumentTotalCurrency String False
DocumentTotal Decimal False
EstimatedTimeToRepair Decimal False
IsOnHold Bool False
LaborChargesExtensionsExtensionAggregate String False
LaborChargesBillablePercent Decimal False
LaborChargesTotalAmountCurrency String False
LaborChargesTotalAmount Decimal False
LaborChargesTotalCostCurrency String False
LaborChargesTotalCost Decimal False
MiscellaneousChargesExtensionsExtensionAggregate String False
MiscellaneousChargesBillablePercent Decimal False
MiscellaneousChargesTotalAmountCurrency String False
MiscellaneousChargesTotalAmount Decimal False
MiscellaneousChargesTotalCostCurrency String False
MiscellaneousChargesTotalCost Decimal False
PartsChargesExtensionsExtensionAggregate String False
PartsChargesBillablePercent Decimal False
PartsChargesTotalAmountCurrency String False
PartsChargesTotalAmount Decimal False
PartsChargesTotalCostCurrency String False
PartsChargesTotalCost Decimal False
PaymentTermsId String False
PreTaxDocumentAmountCurrency String False
PreTaxDocumentAmount Decimal False
PriceLevelId String False
Priority Int False
ResponseDateTime Datetime False
SalesPersonId String False
ServiceAreaId String False
ServiceContractId String False
ServiceContractLineSequenceNumber Decimal False
ServiceTypeId String False
ShipToAddressExtensionsExtensionAggregate String False
ShipToAddressCity String False
ShipToAddressLine1 String False
ShipToAddressLine2 String False
ShipToAddressLine3 String False
ShipToAddressPostalCode String False
ShipToAddressState String False
ShipToAddressCountryRegion String False
ShipToAddressContactPerson String False
ShipToAddressPhone1CountryCode String False
ShipToAddressPhone1Extension String False
ShipToAddressPhone1 String False
StatusCodeId String False
TaxAmountCurrency String False
TaxAmount Decimal False
TaxExemptNumber1 String False
TaxExemptNumber2 String False
TaxScheduleId String False
TechnicianId String False
TimeZoneId String False
AdditionalChargesAggregate String False
EquipmentCodesAggregate String False
ExpensesAggregate String False
LaborAggregate String False
PartsAggregate String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Skill

Return a list of: Skill

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
CompensationExtensionsExtensionAggregate String False
CompensationCompensationAmount Decimal False
CompensationCompensationPeriod String False
DeleteOnUpdate Bool False
SkillId [KEY] String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

SkillSet

Return a list of: SkillSet

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AvailableSkills Int False
SkillSetId [KEY] String False
SkillsAggregate String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Vendor

Return a list of: Vendor

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AccountsPayableGLAccountId String False
AccountsPayableGLAccountKeyIsEncrypted Bool False
AccruedPurchasesGLAccountId String False
AccruedPurchasesGLAccountKeyIsEncrypted Bool False
AddressesAggregate String False
AllowRevaluation Bool False
BankAccountId String False
CashGLAccountId String False
CashGLAccountKeyIsEncrypted Bool False
CheckName String False
ClassId String False
Comment1 String False
Comment2 String False
CreatedDate Datetime False
CreditLimitItem String False
CurrencyKeyISOCode String False
DefaultAddressId String False
DefaultAddressKeyVendorId String False
DefaultCashAccountType String False
DiscountGracePeriod Int False
DueDateGracePeriod Int False
FinanceChargesGLAccountId String False
FinanceChargesGLAccountKeyIsEncrypted Bool False
FreeOnBoard String False
FreightGLAccountId String False
FreightGLAccountKeyIsEncrypted Bool False
HistoryOptionsKeepCalendarHistory Bool False
HistoryOptionsKeepDistributionHistory Bool False
HistoryOptionsKeepFiscalHistory Bool False
HistoryOptionsKeepTransactionHistory Bool False
IsActive Bool False
IsOnHold Bool False
IsOneTime Bool False
Id [KEY] String False
Language String False
MaximumInvoiceItem String False
MaximumWriteoffItem String False
MinimumOrderAmountCurrency String False
MinimumOrderAmount Decimal False
MinimumPaymentItem String False
MiscellaneousGLAccountId String False
MiscellaneousGLAccountKeyIsEncrypted Bool False
ModifiedDate Datetime False
Name String False
Notes String False
PaymentPriority String False
PaymentTermsId String False
PostResultsTo String False
ProjectAccountingOptionsDefaultPurchaseOrderFormat String False
ProjectAccountingOptionsUnitCostCurrency String False
ProjectAccountingOptionsUnitCost Decimal False
ProjectAccountingOptionsUnitOfMeasure String False
ProjectAccountingOptionsUserDefined1 String False
ProjectAccountingOptionsUserDefined2 String False
PurchaseAddressId String False
PurchaseAddressKeyVendorId String False
PurchasePriceVarianceGLAccountId String False
PurchasePriceVarianceGLAccountKeyIsEncrypted Bool False
PurchasesGLAccountId String False
PurchasesGLAccountKeyIsEncrypted Bool False
RateTypeId String False
RemitToAddressId String False
RemitToAddressKeyVendorId String False
ShipFromAddressId String False
ShipFromAddressKeyVendorId String False
ShortName String False
Tax1099BoxNumber Int False
Tax1099Type String False
TaxGLAccountId String False
TaxGLAccountKeyIsEncrypted Bool False
TaxIdentificationNumber String False
TaxRegistrationNumber String False
TaxSchedule String False
TermsDiscountAvailableGLAccountId String False
TermsDiscountAvailableGLAccountKeyIsEncrypted Bool False
TermsDiscountTakenGLAccountId String False
TermsDiscountTakenGLAccountKeyIsEncrypted Bool False
TradeDiscountGLAccountId String False
TradeDiscountGLAccountKeyIsEncrypted Bool False
TradeDiscountPercent Decimal False
UserDefined1 String False
UserDefined2 String False
UserLanguageId Int False
VendorAccountNumber String False
WorkflowPriority String False
WorkflowsAggregate String False
WriteoffGLAccountId String False
WriteoffGLAccountKeyIsEncrypted Bool False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

VendorAddress

Return a list of: VendorAddress

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
City String False
Line1 String False
Line2 String False
Line3 String False
PostalCode String False
State String False
CountryRegion String False
FaxCountryCode String False
FaxExtension String False
Fax String False
Phone1CountryCode String False
Phone1Extension String False
Phone1 String False
Phone2CountryCode String False
Phone2Extension String False
Phone2 String False
Phone3CountryCode String False
Phone3Extension String False
Phone3 String False
CountryRegionCodeId String False
ContactPerson String False
Name String False
CreatedDate Datetime False
InternetAddressesAdditionalInformation String False
InternetAddressesEmailBccAddress String False
InternetAddressesEmailCcAddress String False
InternetAddressesEmailToAddress String False
InternetAddressesInternetField1 String False
InternetAddressesInternetField2 String False
InternetAddressesInternetField3 String False
InternetAddressesInternetField4 String False
InternetAddressesInternetField5 String False
InternetAddressesInternetField6 String False
InternetAddressesInternetField7 String False
InternetAddressesInternetField8 String False
InternetAddressesMessengerAddress String False
LastModifiedDate Datetime False
ModifiedDate Datetime False
ShippingMethodId String False
TaxScheduleId String False
UPSZone String False
UserDefined1 String False
UserDefined2 String False
DeleteOnUpdate Bool False
Id [KEY] String False
KeyVendorId [KEY] String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Warehouse

Return a list of: Warehouse

Columns
Name Type ReadOnly Description
ExtensionsExtensionAggregate String False
AddressExtensionsExtensionAggregate String False
AddressCity String False
AddressLine1 String False
AddressLine2 String False
AddressLine3 String False
AddressPostalCode String False
AddressState String False
AddressCountryRegion String False
AddressFaxCountryCode String False
AddressFaxExtension String False
AddressFax String False
AddressPhone1CountryCode String False
AddressPhone1Extension String False
AddressPhone1 String False
AddressPhone2CountryCode String False
AddressPhone2Extension String False
AddressPhone2 String False
AddressPhone3CountryCode String False
AddressPhone3Extension String False
AddressPhone3 String False
AddressCountryRegionCodeId String False
BinsAggregate String False
Description String False
IncludeInPlanning Bool False
Id [KEY] String False
PurchaseTaxScheduleId String False
SalesTaxScheduleId String False
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

Jitterbit Connector for Microsoft Dynamics GP Views

Name Description
ApplicantApplication Return a list of: ApplicantApplication
ApplicantApplications Return a list of: ApplicantApplications
ApplicantInterviewInterviewItems Return a list of: ApplicantInterviewInterviewItems
ApplicantInterviews Return a list of: ApplicantInterviews
ApplicantPreviousEmployers Return a list of: ApplicantPreviousEmployers
ApplicantReferences Return a list of: ApplicantReferences
ApplicantSchools Return a list of: ApplicantSchools
ApplicantSkills Return a list of: ApplicantSkills
ApplicantTests Return a list of: ApplicantTests
BackOfficeRole Return a list of: BackOfficeRole
Bank Return a list of: Bank
CashReceiptDistributions Return a list of: CashReceiptDistributions
ChangedCurrencyKey Return a list of: ChangedCurrencyKey
ChangedCustomerAddressKey Return a list of: ChangedCustomerAddressKey
ChangedCustomerKey Return a list of: ChangedCustomerKey
ChangedInternetAddressKey Return a list of: ChangedInternetAddressKey
ChangedItemKey Return a list of: ChangedItemKey
ChangedPriceLevelKey Return a list of: ChangedPriceLevelKey
ChangedPricingKey Return a list of: ChangedPricingKey
ChangedSalesInvoiceKey Return a list of: ChangedSalesInvoiceKey
ChangedSalesOrderKey Return a list of: ChangedSalesOrderKey
ChangedSalespersonKey Return a list of: ChangedSalespersonKey
ChangedUofMScheduleKey Return a list of: ChangedUofMScheduleKey
Company Return a list of: Company
CompanyAddress Return a list of: CompanyAddress
CountryRegionCode Return a list of: CountryRegionCode
Currency Return a list of: Currency
CurrencyAccess Return a list of: CurrencyAccess
CurrencyPostingAccount Return a list of: CurrencyPostingAccount
CustomerAddresses Return a list of: CustomerAddresses
CustomerReceivablesSummary Return a list of: CustomerReceivablesSummary
EmployeeAddresses Return a list of: EmployeeAddresses
GLAccount Return a list of: GLAccount
GLAccountCategory Return a list of: GLAccountCategory
GLAccountFormat Return a list of: GLAccountFormat
GLFixedAllocationAccountDistributions Return a list of: GLFixedAllocationAccountDistributions
GLPostingAccountCurrencies Return a list of: GLPostingAccountCurrencies
GLTransactionLines Return a list of: GLTransactionLines
GLVariableAllocationAccountDistributions Return a list of: GLVariableAllocationAccountDistributions
InventoriedItem Return a list of: InventoriedItem
InventoryAdjustmentLines Return a list of: InventoryAdjustmentLines
InventoryTransferLines Return a list of: InventoryTransferLines
InventoryVarianceLines Return a list of: InventoryVarianceLines
Item Return a list of: Item
ItemClass Return a list of: ItemClass
ManufacturingOrder Return a list of: ManufacturingOrder
ManufacturingOrderPickList Return a list of: ManufacturingOrderPickList
ManufacturingOrderRoute Return a list of: ManufacturingOrderRoute
MulticurrencySetup Return a list of: MulticurrencySetup
PayablesDocument Return a list of: PayablesDocument
PayablesDocumentDistributions The DynamicsGP table PayablesDocumentDistributions.
PayablesDocumentTaxes The DynamicsGP table PayablesDocumentTaxes.
PaymentCardType Return a list of: PaymentCardType
PaymentTerms Return a list of: PaymentTerms
PlannedOrder Return a list of: PlannedOrder
PlannedOrderItems Return a list of: PlannedOrderItems
PolicyBehaviors Return a list of: PolicyBehaviors
PriceLevel Return a list of: PriceLevel
PricingDetails Return a list of: PricingDetails
Project Return a list of: Project
ProjectAccounts Return a list of: ProjectAccounts
ProjectBillingCycles Return a list of: ProjectBillingCycles
ProjectBudget Return a list of: ProjectBudget
ProjectBudgets Return a list of: ProjectBudgets
ProjectChangeOrder Return a list of: ProjectChangeOrder
ProjectChangeOrderBudgets Return a list of: ProjectChangeOrderBudgets
ProjectChangeOrderFees Return a list of: ProjectChangeOrderFees
ProjectContract Return a list of: ProjectContract
ProjectContractAccounts Return a list of: ProjectContractAccounts
ProjectContractBillingCycles Return a list of: ProjectContractBillingCycles
ProjectEmployeeExpense Return a list of: ProjectEmployeeExpense
ProjectEmployeeExpenseDistributions Return a list of: ProjectEmployeeExpenseDistributions
ProjectEmployeeExpenseLines Return a list of: ProjectEmployeeExpenseLines
ProjectEquipmentList Return a list of: ProjectEquipmentList
ProjectFees Return a list of: ProjectFees
ProjectMiscellaneousLog Return a list of: ProjectMiscellaneousLog
ProjectMiscellaneousLogDistributions Return a list of: ProjectMiscellaneousLogDistributions
ProjectMiscellaneousLogLines Return a list of: ProjectMiscellaneousLogLines
ProjectTimesheet Return a list of: ProjectTimesheet
ProjectTimesheetDistributions Return a list of: ProjectTimesheetDistributions
ProjectTimesheetLines Return a list of: ProjectTimesheetLines
PurchaseInvoiceDistributions Return a list of: PurchaseInvoiceDistributions
PurchaseInvoiceFreightTaxes Return a list of: PurchaseInvoiceFreightTaxes
PurchaseInvoiceLines Return a list of: PurchaseInvoiceLines
PurchaseInvoiceMiscellaneousTaxes Return a list of: PurchaseInvoiceMiscellaneousTaxes
PurchaseInvoiceTaxes Return a list of: PurchaseInvoiceTaxes
PurchaseOrderFreightTaxes Return a list of: PurchaseOrderFreightTaxes
PurchaseOrderLines Return a list of: PurchaseOrderLines
PurchaseOrderMiscellaneousTaxes Return a list of: PurchaseOrderMiscellaneousTaxes
PurchaseOrderTaxes Return a list of: PurchaseOrderTaxes
PurchaseReceiptDistributions Return a list of: PurchaseReceiptDistributions
PurchaseReceiptLines Return a list of: PurchaseReceiptLines
PurchaseReceiptUserDefined Return a list of: PurchaseReceiptUserDefined
ReceivablesDebitMemoCommissions Return a list of: ReceivablesDebitMemoCommissions
ReceivablesDocument Return a list of: ReceivablesDocument
ReceivablesDocumentDistributions The DynamicsGP table ReceivablesDocumentDistributions.
ReceivablesDocumentTaxes The DynamicsGP table ReceivablesDocumentTaxes.
ReceivablesInvoiceCommissions Return a list of: ReceivablesInvoiceCommissions
ReceivablesReturnCommissions Return a list of: ReceivablesReturnCommissions
ReceivablesServiceRepairCommissions Return a list of: ReceivablesServiceRepairCommissions
ReturnMaterialAuthorizationAudits Return a list of: ReturnMaterialAuthorizationAudits
ReturnMaterialAuthorizationLines Return a list of: ReturnMaterialAuthorizationLines
SalesBackorderLines Return a list of: SalesBackorderLines
SalesBackorderPayments Return a list of: SalesBackorderPayments
SalesDocument Return a list of: SalesDocument
SalesDocumentCommissions The DynamicsGP table SalesDocumentCommissions.
SalesDocumentFreightTaxes The DynamicsGP table SalesDocumentFreightTaxes.
SalesDocumentMiscellaneousTaxes The DynamicsGP table SalesDocumentMiscellaneousTaxes.
SalesDocumentProcessHolds The DynamicsGP table SalesDocumentProcessHolds.
SalesDocumentTaxes The DynamicsGP table SalesDocumentTaxes.
SalesDocumentTrackingNumbers The DynamicsGP table SalesDocumentTrackingNumbers.
SalesFulfillmentOrderDistributions Return a list of: SalesFulfillmentOrderDistributions
SalesFulfillmentOrderLines Return a list of: SalesFulfillmentOrderLines
SalesFulfillmentOrderPayments Return a list of: SalesFulfillmentOrderPayments
SalesInvoiceDistributions Return a list of: SalesInvoiceDistributions
SalesInvoiceLines Return a list of: SalesInvoiceLines
SalesInvoicePayments Return a list of: SalesInvoicePayments
SalesOrderLines Return a list of: SalesOrderLines
SalesOrderPayments Return a list of: SalesOrderPayments
Salesperson Return a list of: Salesperson
SalespersonCommissions Return a list of: SalespersonCommissions
SalespersonSalesHistory Return a list of: SalespersonSalesHistory
SalesQuoteLines Return a list of: SalesQuoteLines
SalesReturnDistributions Return a list of: SalesReturnDistributions
SalesReturnLines Return a list of: SalesReturnLines
SalesReturnPayments Return a list of: SalesReturnPayments
SalesTerritory Return a list of: SalesTerritory
SalesTerritorySalesHistory Return a list of: SalesTerritorySalesHistory
ServiceCallAdditionalCharges Return a list of: ServiceCallAdditionalCharges
ServiceCallEquipmentCodes Return a list of: ServiceCallEquipmentCodes
ServiceCallExpenses Return a list of: ServiceCallExpenses
ServiceCallLabor Return a list of: ServiceCallLabor
ServiceCallParts Return a list of: ServiceCallParts
ServiceEquipmentReadings Return a list of: ServiceEquipmentReadings
ServiceQuoteAdditionalCharges Return a list of: ServiceQuoteAdditionalCharges
ServiceQuoteEquipmentCodes Return a list of: ServiceQuoteEquipmentCodes
ServiceQuoteExpenses Return a list of: ServiceQuoteExpenses
ServiceQuoteLabor Return a list of: ServiceQuoteLabor
ServiceQuoteParts Return a list of: ServiceQuoteParts
ShippingMethod Return a list of: ShippingMethod
SkillSetSkills Return a list of: SkillSetSkills
UofMSchedule Return a list of: UofMSchedule
UofMScheduleDetails Return a list of: UofMScheduleDetails
UserAssignableBusinessObject Return a list of: UserAssignableBusinessObject
VendorAddresses Return a list of: VendorAddresses
VendorManufacturingOrder Return a list of: VendorManufacturingOrder
VendorManufacturingOrderRoute Return a list of: VendorManufacturingOrderRoute
VendorPlannedOrder Return a list of: VendorPlannedOrder
WarehouseBins Return a list of: WarehouseBins

ApplicantApplication

Return a list of: ApplicantApplication

Columns
Name Type Description
ExtensionsExtensionAggregate String
ApplicantApplicationKeyApplicantId [KEY] Int
ApplicantApplicationKeySequenceId [KEY] Int
ColorColorCode String
ColorColorName String
CompanyCode String
DateApplied Datetime
DeleteOnUpdate Bool
DepartmentId String
DivisionId String
IsReplyLetterSent Bool
IsWillRelocate Bool
LastModifiedBy String
LastModifiedDate Datetime
Location String
PositionId String
ReferenceInformationSource String
ReferenceInformationSourceDescription String
RejectionInfomationComment String
RejectionInfomationReason String
RequisitionId String
Status String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ApplicantApplications

Return a list of: ApplicantApplications

Columns
Name Type Description
ExtensionsExtensionAggregate String
AddressExtensionsExtensionAggregate String
AddressCity String
AddressLine1 String
AddressLine2 String
AddressLine3 String
AddressPostalCode String
AddressState String
AddressCountryRegion String
AddressFaxCountryCode String
AddressFaxExtension String
AddressFax String
AddressPhone1CountryCode String
AddressPhone1Extension String
AddressPhone1 String
AddressPhone2CountryCode String
AddressPhone2Extension String
AddressPhone2 String
AddressPhone3CountryCode String
AddressPhone3Extension String
AddressPhone3 String
AgeCode String
ApplicantId Int
ApplicationColorColorCode String
ApplicationColorColorName String
ApplicationStatus String
ApplicationsExtensionsExtensionAggregate String
ApplicationsApplicantApplicationKeyApplicantId [KEY] Int
ApplicationsApplicantApplicationKeySequenceId [KEY] Int
ApplicationsColorColorCode String
ApplicationsColorColorName String
ApplicationsCompanyCode String
ApplicationsDateApplied Datetime
ApplicationsDeleteOnUpdate Bool
ApplicationsDepartmentId String
ApplicationsDivisionId String
ApplicationsIsReplyLetterSent Bool
ApplicationsIsWillRelocate Bool
ApplicationsLastModifiedBy String
ApplicationsLastModifiedDate Datetime
ApplicationsLocation String
ApplicationsPositionId String
ApplicationsReferenceInformationSource String
ApplicationsReferenceInformationSourceDescription String
ApplicationsRejectionInfomationComment String
ApplicationsRejectionInfomationReason String
ApplicationsRequisitionId String
ApplicationsStatus String
CompanyCode String
DateApplied Datetime
DepartmentId String
DivisionId String
Ethnicity String
FirstName String
Gender String
HRRequisistionId String
InterviewsAggregate String
IsDisabled Bool
IsDisabledVeteran Bool
IsOtherVeteran Bool
IsReplyLetterSent Bool
IsVeteran Bool
IsVietnamEraVeteran Bool
IsWillRelocate Bool
LastModifiedBy String
LastModifiedDate Datetime
LastName String
Location String
MiddleName String
PositionId String
PreviousEmployersAggregate String
ReferenceInformationSource String
ReferenceInformationSourceDescription String
ReferencesAggregate String
RejectionInformationComment String
RejectionInformationReason String
SchoolsAggregate String
SequenceId Int
SkillsAggregate String
TaxIdentifier String
TestsAggregate String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ApplicantInterviewInterviewItems

Return a list of: ApplicantInterviewInterviewItems

Columns
Name Type Description
ExtensionsExtensionAggregate String
ApplicantInterviewKeyApplicantId Int
ApplicantInterviewKeyApplyDateId Datetime
ApplicantInterviewKeyInterviewTypeId String
CompanyCode String
DeleteOnUpdate Bool
DepartmentId String
DivisionId String
EffectiveDate Datetime
InterviewItemsCategoryCode Int
InterviewItemsCategoryName String
InterviewItemsCategoryWeight Int
InterviewItemsNotes String
InterviewItemsScore Int
InterviewItemsSequenceId [KEY] Int
InterviewTypeCode Int
Notes String
PositionId String
ReviewRange Int
ReviewRating Decimal
TotalWeight Int
WeightedScore Int
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ApplicantInterviews

Return a list of: ApplicantInterviews

Columns
Name Type Description
ExtensionsExtensionAggregate String
AddressExtensionsExtensionAggregate String
AddressCity String
AddressLine1 String
AddressLine2 String
AddressLine3 String
AddressPostalCode String
AddressState String
AddressCountryRegion String
AddressFaxCountryCode String
AddressFaxExtension String
AddressFax String
AddressPhone1CountryCode String
AddressPhone1Extension String
AddressPhone1 String
AddressPhone2CountryCode String
AddressPhone2Extension String
AddressPhone2 String
AddressPhone3CountryCode String
AddressPhone3Extension String
AddressPhone3 String
AgeCode String
ApplicantId Int
ApplicationColorColorCode String
ApplicationColorColorName String
ApplicationStatus String
ApplicationsAggregate String
CompanyCode String
DateApplied Datetime
DepartmentId String
DivisionId String
Ethnicity String
FirstName String
Gender String
HRRequisistionId String
InterviewsExtensionsExtensionAggregate String
InterviewsApplicantInterviewKeyApplicantId [KEY] Int
InterviewsApplicantInterviewKeyApplyDateId [KEY] Datetime
InterviewsApplicantInterviewKeyInterviewTypeId [KEY] String
InterviewsCompanyCode String
InterviewsDeleteOnUpdate Bool
InterviewsDepartmentId String
InterviewsDivisionId String
InterviewsEffectiveDate Datetime
InterviewsInterviewItemsAggregate String
InterviewsInterviewTypeCode Int
InterviewsNotes String
InterviewsPositionId String
InterviewsReviewRange Int
InterviewsReviewRating Decimal
InterviewsTotalWeight Int
InterviewsWeightedScore Int
IsDisabled Bool
IsDisabledVeteran Bool
IsOtherVeteran Bool
IsReplyLetterSent Bool
IsVeteran Bool
IsVietnamEraVeteran Bool
IsWillRelocate Bool
LastModifiedBy String
LastModifiedDate Datetime
LastName String
Location String
MiddleName String
PositionId String
PreviousEmployersAggregate String
ReferenceInformationSource String
ReferenceInformationSourceDescription String
ReferencesAggregate String
RejectionInformationComment String
RejectionInformationReason String
SchoolsAggregate String
SequenceId Int
SkillsAggregate String
TaxIdentifier String
TestsAggregate String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ApplicantPreviousEmployers

Return a list of: ApplicantPreviousEmployers

Columns
Name Type Description
ExtensionsExtensionAggregate String
AddressExtensionsExtensionAggregate String
AddressCity String
AddressLine1 String
AddressLine2 String
AddressLine3 String
AddressPostalCode String
AddressState String
AddressCountryRegion String
AddressFaxCountryCode String
AddressFaxExtension String
AddressFax String
AddressPhone1CountryCode String
AddressPhone1Extension String
AddressPhone1 String
AddressPhone2CountryCode String
AddressPhone2Extension String
AddressPhone2 String
AddressPhone3CountryCode String
AddressPhone3Extension String
AddressPhone3 String
AgeCode String
ApplicantId Int
ApplicationColorColorCode String
ApplicationColorColorName String
ApplicationStatus String
ApplicationsAggregate String
CompanyCode String
DateApplied Datetime
DepartmentId String
DivisionId String
Ethnicity String
FirstName String
Gender String
HRRequisistionId String
InterviewsAggregate String
IsDisabled Bool
IsDisabledVeteran Bool
IsOtherVeteran Bool
IsReplyLetterSent Bool
IsVeteran Bool
IsVietnamEraVeteran Bool
IsWillRelocate Bool
LastModifiedBy String
LastModifiedDate Datetime
LastName String
Location String
MiddleName String
PositionId String
PreviousEmployersExtensionsExtensionAggregate String
PreviousEmployersApplicantWorkHistoryKeyApplicantSequenceKeyApplicantId [KEY] Int
PreviousEmployersApplicantWorkHistoryKeyApplicantSequenceKeySequenceId [KEY] Int
PreviousEmployersApplicantWorkHistoryId [KEY] String
PreviousEmployersCompensationPeriod String
PreviousEmployersDeleteOnUpdate Bool
PreviousEmployersEndDate Datetime
PreviousEmployersLastModifiedBy String
PreviousEmployersLastModifiedDate Datetime
PreviousEmployersNotes String
PreviousEmployersPositionId String
PreviousEmployersStartDate Datetime
PreviousEmployersWage Decimal
PreviousEmployersYearsOfExperience Int
ReferenceInformationSource String
ReferenceInformationSourceDescription String
ReferencesAggregate String
RejectionInformationComment String
RejectionInformationReason String
SchoolsAggregate String
SequenceId Int
SkillsAggregate String
TaxIdentifier String
TestsAggregate String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ApplicantReferences

Return a list of: ApplicantReferences

Columns
Name Type Description
ExtensionsExtensionAggregate String
AddressExtensionsExtensionAggregate String
AddressCity String
AddressLine1 String
AddressLine2 String
AddressLine3 String
AddressPostalCode String
AddressState String
AddressCountryRegion String
AddressFaxCountryCode String
AddressFaxExtension String
AddressFax String
AddressPhone1CountryCode String
AddressPhone1Extension String
AddressPhone1 String
AddressPhone2CountryCode String
AddressPhone2Extension String
AddressPhone2 String
AddressPhone3CountryCode String
AddressPhone3Extension String
AddressPhone3 String
AgeCode String
ApplicantId Int
ApplicationColorColorCode String
ApplicationColorColorName String
ApplicationStatus String
ApplicationsAggregate String
CompanyCode String
DateApplied Datetime
DepartmentId String
DivisionId String
Ethnicity String
FirstName String
Gender String
HRRequisistionId String
InterviewsAggregate String
IsDisabled Bool
IsDisabledVeteran Bool
IsOtherVeteran Bool
IsReplyLetterSent Bool
IsVeteran Bool
IsVietnamEraVeteran Bool
IsWillRelocate Bool
LastModifiedBy String
LastModifiedDate Datetime
LastName String
Location String
MiddleName String
PositionId String
PreviousEmployersAggregate String
ReferenceInformationSource String
ReferenceInformationSourceDescription String
ReferencesExtensionsExtensionAggregate String
ReferencesAddressExtensionsExtensionAggregate String
ReferencesAddressCity String
ReferencesAddressLine1 String
ReferencesAddressLine2 String
ReferencesAddressLine3 String
ReferencesAddressPostalCode String
ReferencesAddressState String
ReferencesAddressCountryRegion String
ReferencesAddressFaxCountryCode String
ReferencesAddressFaxExtension String
ReferencesAddressFax String
ReferencesAddressPhone1CountryCode String
ReferencesAddressPhone1Extension String
ReferencesAddressPhone1 String
ReferencesAddressPhone2CountryCode String
ReferencesAddressPhone2Extension String
ReferencesAddressPhone2 String
ReferencesAddressPhone3CountryCode String
ReferencesAddressPhone3Extension String
ReferencesAddressPhone3 String
ReferencesApplicantReferenceKeyApplicantSequenceKeyApplicantId [KEY] Int
ReferencesApplicantReferenceKeyApplicantSequenceKeySequenceId [KEY] Int
ReferencesApplicantReferenceId [KEY] String
ReferencesCompanyName String
ReferencesDeleteOnUpdate Bool
ReferencesLastModifiedBy String
ReferencesLastModifiedDate Datetime
ReferencesNotes String
ReferencesRelationship String
RejectionInformationComment String
RejectionInformationReason String
SchoolsAggregate String
SequenceId Int
SkillsAggregate String
TaxIdentifier String
TestsAggregate String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ApplicantSchools

Return a list of: ApplicantSchools

Columns
Name Type Description
ExtensionsExtensionAggregate String
AddressExtensionsExtensionAggregate String
AddressCity String
AddressLine1 String
AddressLine2 String
AddressLine3 String
AddressPostalCode String
AddressState String
AddressCountryRegion String
AddressFaxCountryCode String
AddressFaxExtension String
AddressFax String
AddressPhone1CountryCode String
AddressPhone1Extension String
AddressPhone1 String
AddressPhone2CountryCode String
AddressPhone2Extension String
AddressPhone2 String
AddressPhone3CountryCode String
AddressPhone3Extension String
AddressPhone3 String
AgeCode String
ApplicantId Int
ApplicationColorColorCode String
ApplicationColorColorName String
ApplicationStatus String
ApplicationsAggregate String
CompanyCode String
DateApplied Datetime
DepartmentId String
DivisionId String
Ethnicity String
FirstName String
Gender String
HRRequisistionId String
InterviewsAggregate String
IsDisabled Bool
IsDisabledVeteran Bool
IsOtherVeteran Bool
IsReplyLetterSent Bool
IsVeteran Bool
IsVietnamEraVeteran Bool
IsWillRelocate Bool
LastModifiedBy String
LastModifiedDate Datetime
LastName String
Location String
MiddleName String
PositionId String
PreviousEmployersAggregate String
ReferenceInformationSource String
ReferenceInformationSourceDescription String
ReferencesAggregate String
RejectionInformationComment String
RejectionInformationReason String
SchoolsExtensionsExtensionAggregate String
SchoolsApplicantEducationKeyApplicantId [KEY] Int
SchoolsApplicantEducationKeySequenceId [KEY] Int
SchoolsDegree String
SchoolsDeleteOnUpdate Bool
SchoolsGPABase String
SchoolsGradePointAverage String
SchoolsLastModifiedBy String
SchoolsLastModifiedDate Datetime
SchoolsMajor String
SchoolsNotes String
SchoolsSchool String
SchoolsYearGraduated String
SequenceId Int
SkillsAggregate String
TaxIdentifier String
TestsAggregate String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ApplicantSkills

Return a list of: ApplicantSkills

Columns
Name Type Description
ExtensionsExtensionAggregate String
AddressExtensionsExtensionAggregate String
AddressCity String
AddressLine1 String
AddressLine2 String
AddressLine3 String
AddressPostalCode String
AddressState String
AddressCountryRegion String
AddressFaxCountryCode String
AddressFaxExtension String
AddressFax String
AddressPhone1CountryCode String
AddressPhone1Extension String
AddressPhone1 String
AddressPhone2CountryCode String
AddressPhone2Extension String
AddressPhone2 String
AddressPhone3CountryCode String
AddressPhone3Extension String
AddressPhone3 String
AgeCode String
ApplicantId Int
ApplicationColorColorCode String
ApplicationColorColorName String
ApplicationStatus String
ApplicationsAggregate String
CompanyCode String
DateApplied Datetime
DepartmentId String
DivisionId String
Ethnicity String
FirstName String
Gender String
HRRequisistionId String
InterviewsAggregate String
IsDisabled Bool
IsDisabledVeteran Bool
IsOtherVeteran Bool
IsReplyLetterSent Bool
IsVeteran Bool
IsVietnamEraVeteran Bool
IsWillRelocate Bool
LastModifiedBy String
LastModifiedDate Datetime
LastName String
Location String
MiddleName String
PositionId String
PreviousEmployersAggregate String
ReferenceInformationSource String
ReferenceInformationSourceDescription String
ReferencesAggregate String
RejectionInformationComment String
RejectionInformationReason String
SchoolsAggregate String
SequenceId Int
SkillsExtensionsExtensionAggregate String
SkillsApplicantSkillKeyApplicantId [KEY] Int
SkillsApplicantSkillKeySkillId [KEY] String
SkillsComments String
SkillsDeleteOnUpdate Bool
SkillsProficiency Int
SkillsSkillNumber Int
TaxIdentifier String
TestsAggregate String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ApplicantTests

Return a list of: ApplicantTests

Columns
Name Type Description
ExtensionsExtensionAggregate String
AddressExtensionsExtensionAggregate String
AddressCity String
AddressLine1 String
AddressLine2 String
AddressLine3 String
AddressPostalCode String
AddressState String
AddressCountryRegion String
AddressFaxCountryCode String
AddressFaxExtension String
AddressFax String
AddressPhone1CountryCode String
AddressPhone1Extension String
AddressPhone1 String
AddressPhone2CountryCode String
AddressPhone2Extension String
AddressPhone2 String
AddressPhone3CountryCode String
AddressPhone3Extension String
AddressPhone3 String
AgeCode String
ApplicantId Int
ApplicationColorColorCode String
ApplicationColorColorName String
ApplicationStatus String
ApplicationsAggregate String
CompanyCode String
DateApplied Datetime
DepartmentId String
DivisionId String
Ethnicity String
FirstName String
Gender String
HRRequisistionId String
InterviewsAggregate String
IsDisabled Bool
IsDisabledVeteran Bool
IsOtherVeteran Bool
IsReplyLetterSent Bool
IsVeteran Bool
IsVietnamEraVeteran Bool
IsWillRelocate Bool
LastModifiedBy String
LastModifiedDate Datetime
LastName String
Location String
MiddleName String
PositionId String
PreviousEmployersAggregate String
ReferenceInformationSource String
ReferenceInformationSourceDescription String
ReferencesAggregate String
RejectionInformationComment String
RejectionInformationReason String
SchoolsAggregate String
SequenceId Int
SkillsAggregate String
TaxIdentifier String
TestsExtensionsExtensionAggregate String
TestsApplicantTestKeyApplicantSequenceKeyApplicantId [KEY] Int
TestsApplicantTestKeyApplicantSequenceKeySequenceId [KEY] Int
TestsApplicantTestKeyTestId [KEY] String
TestsDeleteOnUpdate Bool
TestsLastModifiedBy String
TestsLastModifiedDate Datetime
TestsNotes String
TestsScore String
TestsTestDate Datetime
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

BackOfficeRole

Return a list of: BackOfficeRole

Columns
Name Type Description
ExtensionsExtensionAggregate String
Description String
Id [KEY] String
Name String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Bank

Return a list of: Bank

Columns
Name Type Description
ExtensionsExtensionAggregate String
AddressExtensionsExtensionAggregate String
AddressCity String
AddressLine1 String
AddressLine2 String
AddressLine3 String
AddressPostalCode String
AddressState String
AddressCountryRegion String
AddressFaxCountryCode String
AddressFaxExtension String
AddressFax String
AddressPhone1CountryCode String
AddressPhone1Extension String
AddressPhone1 String
AddressPhone2CountryCode String
AddressPhone2Extension String
AddressPhone2 String
AddressPhone3CountryCode String
AddressPhone3Extension String
AddressPhone3 String
Branch String
DirectDepositTransitNumber String
Id [KEY] String
Name String
TransitNumber String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

CashReceiptDistributions

Return a list of: CashReceiptDistributions

Columns
Name Type Description
ExtensionsExtensionAggregate String
AmountCurrency String
Amount Decimal
AuditTrailCode String
BankAccountId String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
CheckCardNumber String
CorporateAccountId String
CurrencyKeyISOCode String
CustomerId String
Date Datetime
Description String
DistributionsExtensionsExtensionAggregate String
DistributionsDistributionTypeId Int
DistributionsGLAccountId String
DistributionsGLAccountKeyIsEncrypted Bool
DistributionsReference String
DistributionsKeyReceivablesDocumentId [KEY] String
DistributionsKeySequenceNumber [KEY] Int
ExchangeDate Datetime
ExchangeRate Decimal
GeneralLedgerPostingDate Datetime
IsVoided Bool
Id String
ModifiedBy String
ModifiedDate Datetime
PaymentCardTypeId String
PostedBy String
PostedDate Datetime
Type String
VoidDate Datetime
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ChangedCurrencyKey

Return a list of: ChangedCurrencyKey

Columns
Name Type Description
Action [KEY] String
LastModifiedBy [KEY] String
LastModifiedDate [KEY] Datetime
ISOCode [KEY] String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ChangedCustomerAddressKey

Return a list of: ChangedCustomerAddressKey

Columns
Name Type Description
Action [KEY] String
LastModifiedBy [KEY] String
LastModifiedDate [KEY] Datetime
CustomerId [KEY] String
Id [KEY] String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ChangedCustomerKey

Return a list of: ChangedCustomerKey

Columns
Name Type Description
Action [KEY] String
LastModifiedBy [KEY] String
LastModifiedDate [KEY] Datetime
Id [KEY] String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ChangedInternetAddressKey

Return a list of: ChangedInternetAddressKey

Columns
Name Type Description
Action [KEY] String
LastModifiedBy [KEY] String
LastModifiedDate [KEY] Datetime
AddressId [KEY] String
InternetAddressKey [KEY] String
InternetAddressType [KEY] String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ChangedItemKey

Return a list of: ChangedItemKey

Columns
Name Type Description
Action [KEY] String
LastModifiedBy [KEY] String
LastModifiedDate [KEY] Datetime
Id [KEY] String
ItemType [KEY] String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ChangedPriceLevelKey

Return a list of: ChangedPriceLevelKey

Columns
Name Type Description
Action [KEY] String
LastModifiedBy [KEY] String
LastModifiedDate [KEY] Datetime
Id [KEY] String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ChangedPricingKey

Return a list of: ChangedPricingKey

Columns
Name Type Description
Action [KEY] String
LastModifiedBy [KEY] String
LastModifiedDate [KEY] Datetime
CurrencyKeyISOCode [KEY] String
ItemId [KEY] String
PriceLevelId [KEY] String
UofM [KEY] String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ChangedSalesInvoiceKey

Return a list of: ChangedSalesInvoiceKey

Columns
Name Type Description
Action [KEY] String
LastModifiedBy [KEY] String
LastModifiedDate [KEY] Datetime
SalesDocumentTypeId [KEY] String
SalesDocumentTypeKeyType [KEY] String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ChangedSalesOrderKey

Return a list of: ChangedSalesOrderKey

Columns
Name Type Description
Action [KEY] String
LastModifiedBy [KEY] String
LastModifiedDate [KEY] Datetime
SalesDocumentTypeId [KEY] String
SalesDocumentTypeKeyType [KEY] String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ChangedSalespersonKey

Return a list of: ChangedSalespersonKey

Columns
Name Type Description
Action [KEY] String
LastModifiedBy [KEY] String
LastModifiedDate [KEY] Datetime
Id [KEY] String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ChangedUofMScheduleKey

Return a list of: ChangedUofMScheduleKey

Columns
Name Type Description
Action [KEY] String
LastModifiedBy [KEY] String
LastModifiedDate [KEY] Datetime
Id [KEY] String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Company

Return a list of: Company

Columns
Name Type Description
Id [KEY] Int
ExtensionsExtensionAggregate String
AccountSegmentSeparator String
BusinessType String
CreatedDate Datetime
DUNSNumber String
DefaultAddressExtensionsExtensionAggregate String
DefaultAddressCity String
DefaultAddressLine1 String
DefaultAddressLine2 String
DefaultAddressLine3 String
DefaultAddressPostalCode String
DefaultAddressState String
DefaultAddressCountryRegion String
DefaultAddressFaxCountryCode String
DefaultAddressFaxExtension String
DefaultAddressFax String
DefaultAddressPhone1CountryCode String
DefaultAddressPhone1Extension String
DefaultAddressPhone1 String
DefaultAddressPhone2CountryCode String
DefaultAddressPhone2Extension String
DefaultAddressPhone2 String
DefaultAddressPhone3CountryCode String
DefaultAddressPhone3Extension String
DefaultAddressPhone3 String
DefaultAddressCountryRegionCodeId String
DefaultAddressContactPerson String
DefaultAddressName String
DefaultAddressCounty String
DefaultAddressId String
IsValueAddedTaxReturnEnabled Bool
IsWorkflowEnabled Bool
ModifiedBy String
ModifiedDate Datetime
Name String
Options String
PayablesProcessesTaxDetailId String
PurchasesTaxScheduleId String
ReceivablesProcessesTaxDetailId String
SICNumber String
SalesTaxScheduleId String
TaxExempt1 String
TaxExempt2 String
TaxRegistration String
UserDefined1 String
UserDefined2 String
Vets100Number String
WithholdingVendorId String
WitholdingFileOrReconciliationNumber String
WitholdingTaxRate Int
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

CompanyAddress

Return a list of: CompanyAddress

Columns
Name Type Description
ExtensionsExtensionAggregate String
City String
Line1 String
Line2 String
Line3 String
PostalCode String
State String
CountryRegion String
FaxCountryCode String
FaxExtension String
Fax String
Phone1CountryCode String
Phone1Extension String
Phone1 String
Phone2CountryCode String
Phone2Extension String
Phone2 String
Phone3CountryCode String
Phone3Extension String
Phone3 String
CountryRegionCodeId String
ContactPerson String
Name String
County String
InternetAddressesAdditionalInformation String
InternetAddressesEmailBccAddress String
InternetAddressesEmailCcAddress String
InternetAddressesEmailToAddress String
InternetAddressesInternetField1 String
InternetAddressesInternetField2 String
InternetAddressesInternetField3 String
InternetAddressesInternetField4 String
InternetAddressesInternetField5 String
InternetAddressesInternetField6 String
InternetAddressesInternetField7 String
InternetAddressesInternetField8 String
InternetAddressesMessengerAddress String
Id [KEY] String
ModifiedBy String
ModifiedDate Datetime
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

CountryRegionCode

Return a list of: CountryRegionCode

Columns
Name Type Description
ExtensionsExtensionAggregate String
Description String
IsEuropeanUnionMember Bool
Id [KEY] String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Currency

Return a list of: Currency

Columns
Name Type Description
ExtensionsExtensionAggregate String
DecimalPlaces String
DecimalSymbol String
Description String
Id String
IncludeSpace Bool
Index Int
KeyISOCode [KEY] String
LastModifiedBy String
LastModifiedDate Datetime
NegativeSymbol String
NegativeSymbolCurrencySymbolLocation String
NegativeSymbolLocation String
SubunitText String
Symbol String
SymbolLocation String
ThousandsSymbol String
UnitSubunitConnectorText String
UnitText String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

CurrencyAccess

Return a list of: CurrencyAccess

Columns
Name Type Description
ExtensionsExtensionAggregate String
IsActive Bool
KeyCurrencyKeyISOCode [KEY] String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

CurrencyPostingAccount

Return a list of: CurrencyPostingAccount

Columns
Name Type Description
ExtensionsExtensionAggregate String
FinancialOffsetGLAccountId String
FinancialOffsetGLAccountKeyIsEncrypted Bool
KeyCurrencyKeyISOCode [KEY] String
PurchasingOffsetGLAccountId String
PurchasingOffsetGLAccountKeyIsEncrypted Bool
RealizedGainGLAccountId String
RealizedGainGLAccountKeyIsEncrypted Bool
RealizedLossGLAccountId String
RealizedLossGLAccountKeyIsEncrypted Bool
RoundingDifferenceGLAccountId String
RoundingDifferenceGLAccountKeyIsEncrypted Bool
RoundingWriteOffGLAccountId String
RoundingWriteOffGLAccountKeyIsEncrypted Bool
SalesOffsetGLAccountId String
SalesOffsetGLAccountKeyIsEncrypted Bool
UnrealizedGainGLAccountId String
UnrealizedGainGLAccountKeyIsEncrypted Bool
UnrealizedLossGLAccountId String
UnrealizedLossGLAccountKeyIsEncrypted Bool
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

CustomerAddresses

Return a list of: CustomerAddresses

Columns
Name Type Description
ExtensionsExtensionAggregate String
AccountsReceivableGLAccountId String
AccountsReceivableGLAccountKeyIsEncrypted Bool
AddressesExtensionsExtensionAggregate String
AddressesCity String
AddressesLine1 String
AddressesLine2 String
AddressesLine3 String
AddressesPostalCode String
AddressesState String
AddressesCountryRegion String
AddressesFaxCountryCode String
AddressesFaxExtension String
AddressesFax String
AddressesPhone1CountryCode String
AddressesPhone1Extension String
AddressesPhone1 String
AddressesPhone2CountryCode String
AddressesPhone2Extension String
AddressesPhone2 String
AddressesPhone3CountryCode String
AddressesPhone3Extension String
AddressesPhone3 String
AddressesCountryRegionCodeId String
AddressesContactPerson String
AddressesName String
AddressesCreatedDate Datetime
AddressesInternetAddressesAdditionalInformation String
AddressesInternetAddressesEmailBccAddress String
AddressesInternetAddressesEmailCcAddress String
AddressesInternetAddressesEmailToAddress String
AddressesInternetAddressesInternetField1 String
AddressesInternetAddressesInternetField2 String
AddressesInternetAddressesInternetField3 String
AddressesInternetAddressesInternetField4 String
AddressesInternetAddressesInternetField5 String
AddressesInternetAddressesInternetField6 String
AddressesInternetAddressesInternetField7 String
AddressesInternetAddressesInternetField8 String
AddressesInternetAddressesMessengerAddress String
AddressesLastModifiedDate Datetime
AddressesModifiedDate Datetime
AddressesShippingMethodId String
AddressesTaxScheduleId String
AddressesUPSZone String
AddressesUserDefined1 String
AddressesUserDefined2 String
AddressesDeleteOnUpdate Bool
AddressesKeyCustomerId [KEY] String
AddressesId [KEY] String
AddressesSalesTerritoryId String
AddressesSalespersonId String
AddressesWarehouseId String
AllowRevaluation Bool
BalanceType String
BankAccountId String
BankBranch String
BankName String
BillToAddressKeyCustomerId String
BillToAddressId String
CashGLAccountId String
CashGLAccountKeyIsEncrypted Bool
ClassId String
Comment1 String
Comment2 String
CorporateAccountId String
CostOfGoodsSoldGLAccountId String
CostOfGoodsSoldGLAccountKeyIsEncrypted Bool
CreatedDate Datetime
CreditLimitItem String
CreditLimitPeriod Int
CreditLimitPeriodAmountCurrency String
CreditLimitPeriodAmount Decimal
CurrencyKeyISOCode String
DefaultAddressKeyCustomerId String
DefaultAddressId String
DefaultCashAccountType String
DiscountGracePeriod Int
DueDateGracePeriod Int
FinanceChargeItem String
FinanceChargesGLAccountId String
FinanceChargesGLAccountKeyIsEncrypted Bool
HistoryOptionsKeepCalendarHistory Bool
HistoryOptionsKeepDistributionHistory Bool
HistoryOptionsKeepFiscalHistory Bool
HistoryOptionsKeepTransactionHistory Bool
IncludeInDemandPlanning Bool
InventoryGLAccountId String
InventoryGLAccountKeyIsEncrypted Bool
IsActive Bool
IsOnHold Bool
Id String
LastModifiedDate Datetime
MaximumWriteoffItem String
MinimumPaymentItem String
ModifiedDate Datetime
Name String
Notes String
OrderFullfillmentShortageDefault String
OverpaymentWriteoffGLAccountId String
OverpaymentWriteoffGLAccountKeyIsEncrypted Bool
PaymentCardAccountExpirationDate Datetime
PaymentCardAccountKeyNumber String
PaymentCardAccountKeyPaymentCardTypeId String
PaymentTermsDiscountAvailableGLAccountId String
PaymentTermsDiscountAvailableGLAccountKeyIsEncrypted Bool
PaymentTermsDiscountTakenGLAccountId String
PaymentTermsDiscountTakenGLAccountKeyIsEncrypted Bool
PaymentTermsId String
PostResultsTo String
PriceLevelId String
Priority Int
RateTypeId String
SalesGLAccountId String
SalesGLAccountKeyIsEncrypted Bool
SalesOrderReturnsGLAccountId String
SalesOrderReturnsGLAccountKeyIsEncrypted Bool
SendEmailStatements Bool
ShipCompleteOnly Bool
ShipToAddressKeyCustomerId String
ShipToAddressId String
Shortname String
StatementCycle String
StatementName String
StatementRecipientsBCCAggregate String
StatementRecipientsCCAggregate String
StatementRecipientsToAggregate String
StatementToAddressKeyCustomerId String
StatementToAddressId String
TaxExemptNumbersAggregate String
TaxRegistrationNumber String
TradeDiscountPercent Decimal
UserDefined1 String
UserDefined2 String
UserLanguageId Int
WriteoffGLAccountId String
WriteoffGLAccountKeyIsEncrypted Bool
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

CustomerReceivablesSummary

Return a list of: CustomerReceivablesSummary

Columns
Name Type Description
ExtensionsExtensionAggregate String
AgingBalanceAmountCurrency String
AgingBalanceAmount Decimal
AgingLastAgedDate Datetime
AgingPeriod1AmountCurrency String
AgingPeriod1Amount Decimal
AgingPeriod2AmountCurrency String
AgingPeriod2Amount Decimal
AgingPeriod3AmountCurrency String
AgingPeriod3Amount Decimal
AgingPeriod4AmountCurrency String
AgingPeriod4Amount Decimal
AgingPeriod5AmountCurrency String
AgingPeriod5Amount Decimal
AgingPeriod6AmountCurrency String
AgingPeriod6Amount Decimal
AgingPeriod7AmountCurrency String
AgingPeriod7Amount Decimal
Id [KEY] String
LastPaymentAmountCurrency String
LastPaymentAmount Decimal
LastPaymentDate Datetime
LastStatementAmountCurrency String
LastStatementAmount Decimal
LastStatementDate Datetime
LastTransactionAmountCurrency String
LastTransactionAmount Decimal
LastTransactionDate Datetime
LastYearAverageDaysToPay Int
LastYearHighBalanceCurrency String
LastYearHighBalance Decimal
LastYearNumberOfInvoices Int
LastYearTermsDiscountsTakenCurrency String
LastYearTermsDiscountsTaken Decimal
LastYearTotalCashReceivedCurrency String
LastYearTotalCashReceived Decimal
LastYearTotalCostCurrency String
LastYearTotalCost Decimal
LastYearTotalFinanceChargeCurrency String
LastYearTotalFinanceCharge Decimal
LastYearTotalReturnsCurrency String
LastYearTotalReturns Decimal
LastYearTotalSalesCurrency String
LastYearTotalSales Decimal
LastYearTotalWaivedFinanceChargeCurrency String
LastYearTotalWaivedFinanceCharge Decimal
LastYearTotalWriteoffAmountCurrency String
LastYearTotalWriteoffAmount Decimal
LifeToDateAverageDaysToPay Int
LifeToDateHighBalanceCurrency String
LifeToDateHighBalance Decimal
LifeToDateNumberOfInvoices Int
LifeToDateTermsDiscountsTakenCurrency String
LifeToDateTermsDiscountsTaken Decimal
LifeToDateTotalCashReceivedCurrency String
LifeToDateTotalCashReceived Decimal
LifeToDateTotalCostCurrency String
LifeToDateTotalCost Decimal
LifeToDateTotalFinanceChargeCurrency String
LifeToDateTotalFinanceCharge Decimal
LifeToDateTotalReturnsCurrency String
LifeToDateTotalReturns Decimal
LifeToDateTotalSalesCurrency String
LifeToDateTotalSales Decimal
LifeToDateTotalWaivedFinanceChargeCurrency String
LifeToDateTotalWaivedFinanceCharge Decimal
LifeToDateTotalWriteoffAmountCurrency String
LifeToDateTotalWriteoffAmount Decimal
OnOrderAmountCurrency String
OnOrderAmount Decimal
YearToDateAverageDaysToPay Int
YearToDateHighBalanceCurrency String
YearToDateHighBalance Decimal
YearToDateNumberOfInvoices Int
YearToDateTermsDiscountsTakenCurrency String
YearToDateTermsDiscountsTaken Decimal
YearToDateTotalCashReceivedCurrency String
YearToDateTotalCashReceived Decimal
YearToDateTotalCostCurrency String
YearToDateTotalCost Decimal
YearToDateTotalFinanceChargeCurrency String
YearToDateTotalFinanceCharge Decimal
YearToDateTotalReturnsCurrency String
YearToDateTotalReturns Decimal
YearToDateTotalSalesCurrency String
YearToDateTotalSales Decimal
YearToDateTotalWaivedFinanceChargeCurrency String
YearToDateTotalWaivedFinanceCharge Decimal
YearToDateTotalWriteoffAmountCurrency String
YearToDateTotalWriteoffAmount Decimal
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

EmployeeAddresses

Return a list of: EmployeeAddresses

Columns
Name Type Description
ExtensionsExtensionAggregate String
AddressesExtensionsExtensionAggregate String
AddressesCity String
AddressesLine1 String
AddressesLine2 String
AddressesLine3 String
AddressesPostalCode String
AddressesState String
AddressesCountryRegion String
AddressesFaxCountryCode String
AddressesFaxExtension String
AddressesFax String
AddressesPhone1CountryCode String
AddressesPhone1Extension String
AddressesPhone1 String
AddressesPhone2CountryCode String
AddressesPhone2Extension String
AddressesPhone2 String
AddressesPhone3CountryCode String
AddressesPhone3Extension String
AddressesPhone3 String
AddressesCountryRegionCodeId String
AddressesCounty String
AddressesDeleteOnUpdate Bool
AddressesInternetAddressesAdditionalInformation String
AddressesInternetAddressesEmailBccAddress String
AddressesInternetAddressesEmailCcAddress String
AddressesInternetAddressesEmailToAddress String
AddressesInternetAddressesInternetField1 String
AddressesInternetAddressesInternetField2 String
AddressesInternetAddressesInternetField3 String
AddressesInternetAddressesInternetField4 String
AddressesInternetAddressesInternetField5 String
AddressesInternetAddressesInternetField6 String
AddressesInternetAddressesInternetField7 String
AddressesInternetAddressesInternetField8 String
AddressesInternetAddressesMessengerAddress String
AddressesKeyEmployeeId [KEY] String
AddressesId [KEY] String
BenefitExpiration Datetime
BenefitStartDate Datetime
BirthDate Datetime
ClassId String
CompanyAddressId String
DayOfBirth Int
DefaultAddressKeyEmployeeId String
DefaultAddressId String
DefaultCashAccountFromType String
DepartmentId String
DivisionId String
DoesCalculateMinimumWageBalance Bool
EmployeeInactivatedDate Datetime
EmployeeId String
EmploymentStartDate Datetime
EmploymentType String
Ethnicity String
FederalClass String
GLAccountId String
GLAccountKeyIsEncrypted Bool
GenderCode String
HRStatus String
I9RenewDate Datetime
IsActive Bool
IsDisabled Bool
IsDisabledVeteran Bool
IsI9Verified Bool
IsOtherVeteran Bool
IsSmoker Bool
IsUnionEmployee Bool
IsUnitedStatesCitizen Bool
IsVeteran Bool
IsVietnamEraVeteran Bool
LastWorkedDate Datetime
MaritalStatus String
MilitaryDischargeDate Datetime
MinimumNetPayCurrency String
MinimumNetPay Decimal
ModifiedBy String
ModifiedDate Datetime
MonthOfBirth String
NameAlternate String
NameFamily String
NameGiven String
NameMiddle String
NamePreferred String
NameSuffix String
PositionId String
PrimaryPayCodeId String
RateClass String
ReasonEmployeeInactivated String
ReviewLastDate Datetime
ReviewNextDate Datetime
SUTAStateId String
SickTimeAccrualAmount Decimal
SickTimeAccrualMethod String
SickTimeDoesAutomaticallyAccrue Bool
SickTimeHoursAvailable Decimal
SickTimeHoursPerYear Int
SickTimeWarnWhenHoursAvailableFallsBelowZero Bool
SpouseName String
SpouseTaxIdentifier String
Status String
SupervisorId String
TaxIdentifier String
UnionId String
UserDefined1 String
UserDefined2 String
VacationAccrualAmount Decimal
VacationAccrualMethod String
VacationDoesAutomaticallyAccrue Bool
VacationHoursAvailable Decimal
VacationHoursPerYear Int
VacationWarnWhenHoursAvailableFallsBelowZero Bool
WorkHoursPerYear Int
WorkersCompensationId String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

GLAccount

Return a list of: GLAccount

Columns
Name Type Description
ExtensionsExtensionAggregate String
Alias String
CreatedDate Datetime
Description String
IsActive Bool
Id [KEY] String
KeyIsEncrypted [KEY] Bool
ModifiedDate Datetime
Type String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

GLAccountCategory

Return a list of: GLAccountCategory

Columns
Name Type Description
Id [KEY] String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

GLAccountFormat

Return a list of: GLAccountFormat

Columns
Name Type Description
ExtensionsExtensionAggregate String
IsMainSegment Bool
Id [KEY] Int
MaximumSegmentLength Int
SegmentLength Int
SegmentName String
UserDefinedSegment Int
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

GLFixedAllocationAccountDistributions

Return a list of: GLFixedAllocationAccountDistributions

Columns
Name Type Description
ExtensionsExtensionAggregate String
Alias String
CreatedDate Datetime
Description String
IsActive Bool
Id String
KeyIsEncrypted Bool
ModifiedDate Datetime
Type String
PostInventoryIn String
PostPayrollIn String
PostPurchasingIn String
PostSalesIn String
DistributionsExtensionsExtensionAggregate String
DistributionsKeyAccountId [KEY] String
DistributionsKeyAccountKeyIsEncrypted [KEY] Bool
DistributionsKeyDistributionAccountId [KEY] String
DistributionsKeyDistributionAccountKeyIsEncrypted [KEY] Bool
DistributionsPercentage Decimal
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

GLPostingAccountCurrencies

Return a list of: GLPostingAccountCurrencies

Columns
Name Type Description
ExtensionsExtensionAggregate String
Alias String
CreatedDate Datetime
Description String
IsActive Bool
Id String
KeyIsEncrypted Bool
ModifiedDate Datetime
Type String
PostInventoryIn String
PostPayrollIn String
PostPurchasingIn String
PostSalesIn String
AllowAccountEntry Bool
CurrenciesExtensionsExtensionAggregate String
CurrenciesKeyAccountId [KEY] String
CurrenciesKeyAccountKeyIsEncrypted [KEY] Bool
CurrenciesKeyCurrencyKeyISOCode [KEY] String
GLAccountCategoryId String
IsRevalued Bool
PostRevaluationResultsTo String
PostingType String
RevaluationMethod String
TypicalBalance String
UserDefined1 String
UserDefined2 String
UserDefined3 String
UserDefined4 String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

GLTransactionLines

Return a list of: GLTransactionLines

Columns
Name Type Description
ExtensionsExtensionAggregate String
AuditTrailCode String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
CurrencyKeyISOCode String
ExchangeDate Datetime
ExchangeRate Decimal
IntercompanyId Int
IntercompanyOriginalJournalId Int
IsVoided Bool
KeyDate Datetime
KeyJournalId Int
LedgerType String
LinesExtensionsExtensionAggregate String
LinesDescription String
LinesExchangeDate Datetime
LinesExchangeRate Decimal
LinesGLAccountId String
LinesGLAccountKeyIsEncrypted Bool
LinesIntercompanyId Int
LinesKeySequenceNumber [KEY] Int
LinesKeyTransactionKeyDate [KEY] Datetime
LinesKeyTransactionKeyJournalId [KEY] Int
LinesOriginatingDocumentControlId String
LinesOriginatingDocumentDescription String
LinesOriginatingDocumentId String
LinesOriginatingDocumentMasterId String
LinesOriginatingDocumentMasterName String
LinesOriginatingDocumentSequenceNumber Int
LinesOriginatingDocumentType Int
LinesTaxAmountCurrency String
LinesTaxAmount Decimal
LinesTaxDetailId String
LinesTaxGLAccountId String
LinesTaxGLAccountKeyIsEncrypted Bool
ModifiedBy String
ModifiedDate Datetime
OriginatingDocumentAuditTrailCode String
OriginatingDocumentPostedDate Datetime
OriginatingDocumentSeries String
PostedBy String
Reference String
SourceDocumentId String
TransactionState String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

GLVariableAllocationAccountDistributions

Return a list of: GLVariableAllocationAccountDistributions

Columns
Name Type Description
ExtensionsExtensionAggregate String
Alias String
CreatedDate Datetime
Description String
IsActive Bool
Id String
KeyIsEncrypted Bool
ModifiedDate Datetime
Type String
PostInventoryIn String
PostPayrollIn String
PostPurchasingIn String
PostSalesIn String
BalanceForCalculation String
DistributionsExtensionsExtensionAggregate String
DistributionsBreakdownsAggregate String
DistributionsKeyAccountId [KEY] String
DistributionsKeyAccountKeyIsEncrypted [KEY] Bool
DistributionsKeyDistributionAccountId [KEY] String
DistributionsKeyDistributionAccountKeyIsEncrypted [KEY] Bool
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

InventoriedItem

Return a list of: InventoriedItem

Columns
Name Type Description
ExtensionsExtensionAggregate String
ABCCode String
AllowBackOrder Bool
AssemblyVarianceGLAccountId String
AssemblyVarianceGLAccountKeyIsEncrypted Bool
ClassId String
CostofGoodsSoldGLAccountId String
CostofGoodsSoldGLAccountKeyIsEncrypted Bool
CreatedDate Datetime
CurrencyDecimalPlaces String
CurrentCostCurrency String
CurrentCost Decimal
DamagedGLAccountId String
DamagedGLAccountKeyIsEncrypted Bool
DefaultPriceLevelId String
DefaultSellingUofM String
DefaultWarehouseId String
Description String
DropShipGLAccountId String
DropShipGLAccountKeyIsEncrypted Bool
FunctionalCurrencyDecimalPlaces String
GenericDescription String
InServiceGLAccountId String
InServiceGLAccountKeyIsEncrypted Bool
InUseGLAccountId String
InUseGLAccountKeyIsEncrypted Bool
IncludeInDemandPlanning Bool
InternetAddressesAdditionalInformation String
InternetAddressesEmailBccAddress String
InternetAddressesEmailCcAddress String
InternetAddressesEmailToAddress String
InternetAddressesInternetField1 String
InternetAddressesInternetField2 String
InternetAddressesInternetField3 String
InternetAddressesInternetField4 String
InternetAddressesInternetField5 String
InternetAddressesInternetField6 String
InternetAddressesInternetField7 String
InternetAddressesInternetField8 String
InternetAddressesMessengerAddress String
InventoryGLAccountId String
InventoryGLAccountKeyIsEncrypted Bool
InventoryOffsetGLAccountId String
InventoryOffsetGLAccountKeyIsEncrypted Bool
InventoryReturnGLAccountId String
InventoryReturnGLAccountKeyIsEncrypted Bool
IsDiscontinued Bool
KeepCalendarYearHistory Bool
KeepDistributionHistory Bool
KeepFiscalYearHistory Bool
KeepTransactionHistory Bool
Id [KEY] String
LastModifiedDate Datetime
MarkdownGLAccountId String
MarkdownGLAccountKeyIsEncrypted Bool
ModifiedDate Datetime
PriceMethod String
PurchasePriceVarianceGLAccountId String
PurchasePriceVarianceGLAccountKeyIsEncrypted Bool
PurchaseTaxBasis String
PurchaseTaxScheduleId String
PurchaseUofM String
QuantityDecimalPlaces String
SalesGLAccountId String
SalesGLAccountKeyIsEncrypted Bool
SalesReturnGLAccountId String
SalesReturnGLAccountKeyIsEncrypted Bool
SalesTaxBasis String
SalesTaxScheduleId String
ShippingWeight Decimal
ShortDescription String
StandardCostCurrency String
StandardCost Decimal
SubstituteItem1Id String
SubstituteItem2Id String
Type String
UnrealizedPurchasePriceVarianceGLAccountId String
UnrealizedPurchasePriceVarianceGLAccountKeyIsEncrypted Bool
UofMScheduleId String
UserCategoryList1 String
UserCategoryList2 String
UserCategoryList3 String
UserCategoryList4 String
UserCategoryList5 String
UserCategoryList6 String
VarianceGLAccountId String
VarianceGLAccountKeyIsEncrypted Bool
WarrantyDays Short
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

InventoryAdjustmentLines

Return a list of: InventoryAdjustmentLines

Columns
Name Type Description
ExtensionsExtensionAggregate String
AuditTrailCode String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
CreatedDate Datetime
Date Datetime
GLPostingDate Datetime
Id String
ModifiedDate Datetime
TransactionState String
LinesExtensionsExtensionAggregate String
LinesItemId String
LinesKeyInventoryId [KEY] String
LinesKeySequenceNumber [KEY] Decimal
LinesQuantity Decimal
LinesUnitCostCurrency String
LinesUnitCost Decimal
LinesBinsAggregate String
LinesInventoryGLAccountId String
LinesInventoryGLAccountIsEncrypted Bool
LinesInventoryOffsetGLAccountId String
LinesInventoryOffsetGLAccountIsEncrypted Bool
LinesLotsAggregate String
LinesSerialsAggregate String
LinesUofM String
LinesWarehouseId String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

InventoryTransferLines

Return a list of: InventoryTransferLines

Columns
Name Type Description
ExtensionsExtensionAggregate String
AuditTrailCode String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
CreatedDate Datetime
Date Datetime
GLPostingDate Datetime
Id String
ModifiedDate Datetime
TransactionState String
LinesExtensionsExtensionAggregate String
LinesItemId String
LinesKeyInventoryId [KEY] String
LinesKeySequenceNumber [KEY] Decimal
LinesQuantity Decimal
LinesUnitCostCurrency String
LinesUnitCost Decimal
LinesBinsAggregate String
LinesInventoryFromGLAccountId String
LinesInventoryFromGLAccountIsEncrypted Bool
LinesInventoryToGLAccountId String
LinesInventoryToGLAccountIsEncrypted Bool
LinesLotsAggregate String
LinesQuantityTypeFrom String
LinesQuantityTypeTo String
LinesSerialsAggregate String
LinesWarehouseFromId String
LinesWarehouseToId String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

InventoryVarianceLines

Return a list of: InventoryVarianceLines

Columns
Name Type Description
ExtensionsExtensionAggregate String
AuditTrailCode String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
CreatedDate Datetime
Date Datetime
GLPostingDate Datetime
Id String
ModifiedDate Datetime
TransactionState String
LinesExtensionsExtensionAggregate String
LinesItemId String
LinesKeyInventoryId [KEY] String
LinesKeySequenceNumber [KEY] Decimal
LinesQuantity Decimal
LinesUnitCostCurrency String
LinesUnitCost Decimal
LinesBinsAggregate String
LinesInventoryGLAccountId String
LinesInventoryGLAccountIsEncrypted Bool
LinesInventoryOffsetGLAccountId String
LinesInventoryOffsetGLAccountIsEncrypted Bool
LinesLotsAggregate String
LinesSerialsAggregate String
LinesUofM String
LinesWarehouseId String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Item

Return a list of: Item

Columns
Name Type Description
ExtensionsExtensionAggregate String
ABCCode String
AllowBackOrder Bool
AssemblyVarianceGLAccountId String
AssemblyVarianceGLAccountKeyIsEncrypted Bool
ClassId String
CostofGoodsSoldGLAccountId String
CostofGoodsSoldGLAccountKeyIsEncrypted Bool
CreatedDate Datetime
CurrencyDecimalPlaces String
CurrentCostCurrency String
CurrentCost Decimal
DamagedGLAccountId String
DamagedGLAccountKeyIsEncrypted Bool
DefaultPriceLevelId String
DefaultSellingUofM String
DefaultWarehouseId String
Description String
DropShipGLAccountId String
DropShipGLAccountKeyIsEncrypted Bool
FunctionalCurrencyDecimalPlaces String
GenericDescription String
InServiceGLAccountId String
InServiceGLAccountKeyIsEncrypted Bool
InUseGLAccountId String
InUseGLAccountKeyIsEncrypted Bool
IncludeInDemandPlanning Bool
InternetAddressesAdditionalInformation String
InternetAddressesEmailBccAddress String
InternetAddressesEmailCcAddress String
InternetAddressesEmailToAddress String
InternetAddressesInternetField1 String
InternetAddressesInternetField2 String
InternetAddressesInternetField3 String
InternetAddressesInternetField4 String
InternetAddressesInternetField5 String
InternetAddressesInternetField6 String
InternetAddressesInternetField7 String
InternetAddressesInternetField8 String
InternetAddressesMessengerAddress String
InventoryGLAccountId String
InventoryGLAccountKeyIsEncrypted Bool
InventoryOffsetGLAccountId String
InventoryOffsetGLAccountKeyIsEncrypted Bool
InventoryReturnGLAccountId String
InventoryReturnGLAccountKeyIsEncrypted Bool
IsDiscontinued Bool
KeepCalendarYearHistory Bool
KeepDistributionHistory Bool
KeepFiscalYearHistory Bool
KeepTransactionHistory Bool
Id [KEY] String
LastModifiedDate Datetime
MarkdownGLAccountId String
MarkdownGLAccountKeyIsEncrypted Bool
ModifiedDate Datetime
PriceMethod String
PurchasePriceVarianceGLAccountId String
PurchasePriceVarianceGLAccountKeyIsEncrypted Bool
PurchaseTaxBasis String
PurchaseTaxScheduleId String
PurchaseUofM String
QuantityDecimalPlaces String
SalesGLAccountId String
SalesGLAccountKeyIsEncrypted Bool
SalesReturnGLAccountId String
SalesReturnGLAccountKeyIsEncrypted Bool
SalesTaxBasis String
SalesTaxScheduleId String
ShippingWeight Decimal
ShortDescription String
StandardCostCurrency String
StandardCost Decimal
SubstituteItem1Id String
SubstituteItem2Id String
Type String
UnrealizedPurchasePriceVarianceGLAccountId String
UnrealizedPurchasePriceVarianceGLAccountKeyIsEncrypted Bool
UofMScheduleId String
UserCategoryList1 String
UserCategoryList2 String
UserCategoryList3 String
UserCategoryList4 String
UserCategoryList5 String
UserCategoryList6 String
VarianceGLAccountId String
VarianceGLAccountKeyIsEncrypted Bool
WarrantyDays Short
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ItemClass

Return a list of: ItemClass

Columns
Name Type Description
ExtensionsExtensionAggregate String
Description String
Id [KEY] String
Type String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ManufacturingOrder

Return a list of: ManufacturingOrder

Columns
Name Type Description
ExtensionsExtensionAggregate String
ActualDemand Decimal
BOMCategory String
BOMRevisionLevel String
ComponentCalculation String
DateCompleted Datetime
Description String
DrawFromSite String
EndDate Datetime
EndingQty Decimal
IsArchivedMO Bool
IsQuickMO Bool
ItemId String
LastModifiedDate Datetime
LotNumber String
ManufacturingOrderDocumentId [KEY] String
Notes String
OrderStatus String
OutSourced String
PickNumber String
PlanName String
PostToSite String
Priority String
RoutingName String
RoutingRevisionLevel String
ScheduleMethod String
SchedulingPreference String
StartDate Datetime
StartingQty Decimal
PickListAggregate String
RouteAggregate String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ManufacturingOrderPickList

Return a list of: ManufacturingOrderPickList

Columns
Name Type Description
ExtensionsExtensionAggregate String
ActualDemand Decimal
BOMCategory String
BOMRevisionLevel String
ComponentCalculation String
DateCompleted Datetime
Description String
DrawFromSite String
EndDate Datetime
EndingQty Decimal
IsArchivedMO Bool
IsQuickMO Bool
ItemId String
LastModifiedDate Datetime
LotNumber String
ManufacturingOrderDocumentId String
Notes String
OrderStatus String
OutSourced String
PickNumber String
PlanName String
PostToSite String
Priority String
RoutingName String
RoutingRevisionLevel String
ScheduleMethod String
SchedulingPreference String
StartDate Datetime
StartingQty Decimal
PickListActualConsumedQty Decimal
PickListAllocatedBy String
PickListAllocatedQty Decimal
PickListAllowedQty Decimal
PickListAlternateItemForId String
PickListAlternateItemSequence Int
PickListBOMCategory String
PickListBOMName String
PickListBOMSequence Int
PickListBOMUserDef1 String
PickListBOMUserDef2 String
PickListBackFlushedQty Decimal
PickListBaseUOMQty Decimal
PickListCurrentConsumedQty Decimal
PickListCurrentReturnToStockQty Decimal
PickListCurrentScrappedQty Decimal
PickListDateAllocated Datetime
PickListDateRequired Datetime
PickListDateResourcePlanIssued Datetime
PickListExplodedQty Decimal
PickListFixedQty Decimal
PickListIsActualConsumedChecked Bool
PickListIsAllocated Bool
PickListIsAlternateItem Bool
PickListIsBOMApproved Bool
PickListIsBOMSingleLot Bool
PickListIsBackFlushed Bool
PickListIsBackOrdered Bool
PickListIsFloorStock Bool
PickListIsIssued Bool
PickListIsOptionedItem Bool
PickListIsPhantomItem Bool
PickListIsResourcePlanCalculated Bool
PickListIsSubAssemblyItem Bool
PickListIssuedBy String
PickListIssuedQty Decimal
PickListItemId String
PickListLastModifiedDate Datetime
PickListLeadTimeOffset Decimal
PickListLinkToSequence Int
PickListLocation String
PickListMRPAmountCurrency String
PickListMRPAmount Decimal
PickListMRPAmount2Currency String
PickListMRPAmount2 Decimal
PickListManufacturingNote String
PickListManufacturingOrderDocumentId String
PickListMarkdownAmtCurrency String
PickListMarkdownAmt Decimal
PickListNonInventoryCreditIndex Int
PickListNonInventoryItemDescription String
PickListOffsetFrom Decimal
PickListOrderStatus String
PickListPOLineLineSequenceNumber Int
PickListPOLinePurchaseTransactionId String
PickListParentPartNumberId String
PickListPositionNumber Int
PickListPositionNumber2 Int
PickListPromotion String
PickListRefillCostCurrency String
PickListRefillCost Decimal
PickListReturnToStockQty Decimal
PickListRoutingName String
PickListRoutingSequence String
PickListScrappedQty Decimal
PickListSequence [KEY] Int
PickListSubAssemblyItemForId String
PickListSubAssemblyItemSequence Int
PickListSuggestedQty Decimal
PickListUnitCostCurrency String
PickListUnitCost Decimal
PickListUofM String
PickListVendorId String
PickListVendorName String
PickListWorkCenter String
RouteAggregate String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ManufacturingOrderRoute

Return a list of: ManufacturingOrderRoute

Columns
Name Type Description
ExtensionsExtensionAggregate String
ActualDemand Decimal
BOMCategory String
BOMRevisionLevel String
ComponentCalculation String
DateCompleted Datetime
Description String
DrawFromSite String
EndDate Datetime
EndingQty Decimal
IsArchivedMO Bool
IsQuickMO Bool
ItemId String
LastModifiedDate Datetime
LotNumber String
ManufacturingOrderDocumentId String
Notes String
OrderStatus String
OutSourced String
PickNumber String
PlanName String
PostToSite String
Priority String
RoutingName String
RoutingRevisionLevel String
ScheduleMethod String
SchedulingPreference String
StartDate Datetime
StartingQty Decimal
PickListAggregate String
RouteActualFinishDate Datetime
RouteActualStartDate Datetime
RouteClosedBy String
RouteCycleTime Decimal
RouteDateClosed Datetime
RouteDateCreated Datetime
RouteDrawingNumber String
RouteIsAutoBackFlushLabor Bool
RouteIsAutoBackFlushMachine Bool
RouteIsCapacityRequirementsPlanned Bool
RouteIsDone Bool
RouteIsLastSequenceofTheDay Bool
RouteIsMultiEmployeeOperation Bool
RouteIsPhantomItem Bool
RouteIsQualityAssuranceNeeded Bool
RouteLaborCode1 String
RouteLaborCode2 String
RouteLaborTime Decimal
RouteLastModifiedDate Datetime
RouteMRPAmountCurrency String
RouteMRPAmount Decimal
RouteMachineId String
RouteMachineTime Decimal
RouteManufacturingNote String
RouteManufacturingOrderDocumentId String
RouteMoveTime Decimal
RouteNextRouteNumber String
RouteNotes String
RouteNumberOfCrews Int
RouteNumberOfEmployees Int
RouteNumberOfMachines Int
RouteOperationCode String
RoutePOOffsetDays Int
RoutePercentageComplete Int
RoutePieces Decimal
RouteQuantity Decimal
RouteQueueTime Decimal
RouteRejects Decimal
RouteRouteMachineID String
RouteRoutePartNumber String
RouteRouteSeqDescription String
RouteRouteSequenceNum [KEY] Int
RouteRouteSequenceType String
RouteRouteWorkCenter String
RouteRunTime Decimal
RouteScheduledFinishDate Datetime
RouteScheduledStartDate Datetime
RouteServiceItemDateReleased Datetime
RouteServiceItemManufacturingOrderDocumentId String
RouteServiceItemQtyToOrder Decimal
RouteServiceItemRequiredDate Datetime
RouteServiceItemRouteSequenceNum Int
RouteServiceItemServiceItemId String
RouteServiceItemSuggestedQty Decimal
RouteSetupTime Decimal
RouteUserDef1 String
RouteUserDef2 String
RouteVendorId String
RouteVendorName String
RouteWIPOutputPerMOStartQty Decimal
RouteWaitHours Int
RouteWorkCenter String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

MulticurrencySetup

Return a list of: MulticurrencySetup

Columns
Name Type Description
ExtensionsExtensionAggregate String
AllowModifyRates Bool
AllowNewRates Bool
AllowOverrideExchangeRates Bool
AllowOverrideRateVariance Bool
AllowOverrideReportingRate Bool
AverageExchangeRateCalculationMethodDisplay String
DefaultFinancialRateTypeId String
DefaultPurchasingRateTypeId String
DefaultSalesRateTypeId String
KeepGeneralLedgerAccountHistory Bool
KeyCurrencyKeyISOCode [KEY] String
LastFinancialRevaluationDate Datetime
LastPurchasingRevaluationDate Datetime
LastSalesRevaluationDate Datetime
LastSummaryRemovalDate Datetime
LastTransactionRemovalDate Datetime
ReportingCurrencyExchangeRate Decimal
ReportingCurrencyKeyISOCode String
ReportingCurrencyRateCalculationMethod String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

PayablesDocument

Return a list of: PayablesDocument

Columns
Name Type Description
ExtensionsExtensionAggregate String
AddressId String
Amount1099Currency String
Amount1099 Decimal
AuditTrailCode String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
ChargeAmountCurrency String
ChargeAmount Decimal
CurrencyKeyISOCode String
Date Datetime
Description String
DistributionsAggregate String
DocumentAmountCurrency String
DocumentAmount Decimal
ExchangeDate Datetime
ExchangeRate Decimal
FreightAmountCurrency String
FreightAmount Decimal
FreightTaxScheduleId String
GeneralLedgerPostingDate Datetime
HasIntercompanyDistributions Bool
IsIntercompanyTransaction Bool
IsVoided Bool
Id [KEY] String
MiscellaneousAmountCurrency String
MiscellaneousAmount Decimal
MiscellaneousTaxScheduleId String
ModifiedBy String
ModifiedDate Datetime
PONumber String
PostedBy String
PostedDate Datetime
PurchaseTaxScheduleId String
PurchasesAmountCurrency String
PurchasesAmount Decimal
RemitToAddressId String
ShippingMethodId String
TaxAmountCurrency String
TaxAmount Decimal
TaxDate Datetime
TaxScheduleId String
TaxesAggregate String
TradeDiscountAmountCurrency String
TradeDiscountAmount Decimal
TransactionState String
Type String
VendorDocumentNumber String
VendorId String
VendorName String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

PayablesDocumentDistributions

The DynamicsGP table PayablesDocumentDistributions.

Columns
Name Type Description
DistributionsKeySequenceNumber [KEY] Int32 The DistributionsKeySequenceNumber column for the table PayablesDocumentDistributions.
DistributionsKeyPayablesDocumentId [KEY] String The DistributionsKeyPayablesDocumentId column for the table PayablesDocumentDistributions.
AddressId String The AddressId column for the table PayablesDocumentDistributions.
Amount1099Currency String The Amount1099Currency column for the table PayablesDocumentDistributions.
Amount1099 Decimal The Amount1099 column for the table PayablesDocumentDistributions.
AuditTrailCode String The AuditTrailCode column for the table PayablesDocumentDistributions.
BatchKeyCreatedDateTime Datetime The BatchKeyCreatedDateTime column for the table PayablesDocumentDistributions.
BatchId String The BatchId column for the table PayablesDocumentDistributions.
BatchKeySource String The BatchKeySource column for the table PayablesDocumentDistributions.
ChargeAmountCurrency String The ChargeAmountCurrency column for the table PayablesDocumentDistributions.
ChargeAmount Decimal The ChargeAmount column for the table PayablesDocumentDistributions.
CurrencyKeyISOCode String The CurrencyKeyISOCode column for the table PayablesDocumentDistributions.
Date Datetime The Date column for the table PayablesDocumentDistributions.
Description String The Description column for the table PayablesDocumentDistributions.
DistributionsIsPosted Boolean The DistributionsIsPosted column for the table PayablesDocumentDistributions.
DistributionsPostingDate Datetime The DistributionsPostingDate column for the table PayablesDocumentDistributions.
DistributionsDistributionTypeId Int32 The DistributionsDistributionTypeId column for the table PayablesDocumentDistributions.
DistributionsGLAccountId String The DistributionsGLAccountId column for the table PayablesDocumentDistributions.
DistributionsGLAccountKeyIsEncrypted Boolean The DistributionsGLAccountKeyIsEncrypted column for the table PayablesDocumentDistributions.
DistributionsReference String The DistributionsReference column for the table PayablesDocumentDistributions.
DistributionsExtensionsExtensionAggregate String The DistributionsExtensionsExtensionAggregate column for the table PayablesDocumentDistributions.
DocumentAmountCurrency String The DocumentAmountCurrency column for the table PayablesDocumentDistributions.
DocumentAmount Decimal The DocumentAmount column for the table PayablesDocumentDistributions.
ExchangeDate Datetime The ExchangeDate column for the table PayablesDocumentDistributions.
ExchangeRate Decimal The ExchangeRate column for the table PayablesDocumentDistributions.
FreightAmountCurrency String The FreightAmountCurrency column for the table PayablesDocumentDistributions.
FreightAmount Decimal The FreightAmount column for the table PayablesDocumentDistributions.
FreightTaxScheduleId String The FreightTaxScheduleId column for the table PayablesDocumentDistributions.
GeneralLedgerPostingDate Datetime The GeneralLedgerPostingDate column for the table PayablesDocumentDistributions.
HasIntercompanyDistributions Boolean The HasIntercompanyDistributions column for the table PayablesDocumentDistributions.
IsIntercompanyTransaction Boolean The IsIntercompanyTransaction column for the table PayablesDocumentDistributions.
IsVoided Boolean The IsVoided column for the table PayablesDocumentDistributions.
Id String The ID column for the table PayablesDocumentDistributions.
MiscellaneousAmountCurrency String The MiscellaneousAmountCurrency column for the table PayablesDocumentDistributions.
MiscellaneousAmount Decimal The MiscellaneousAmount column for the table PayablesDocumentDistributions.
MiscellaneousTaxScheduleId String The MiscellaneousTaxScheduleId column for the table PayablesDocumentDistributions.
ModifiedBy String The ModifiedBy column for the table PayablesDocumentDistributions.
ModifiedDate Datetime The ModifiedDate column for the table PayablesDocumentDistributions.
PONumber String The PONumber column for the table PayablesDocumentDistributions.
PostedBy String The PostedBy column for the table PayablesDocumentDistributions.
PostedDate Datetime The PostedDate column for the table PayablesDocumentDistributions.
PurchaseTaxScheduleId String The PurchaseTaxScheduleId column for the table PayablesDocumentDistributions.
PurchasesAmountCurrency String The PurchasesAmountCurrency column for the table PayablesDocumentDistributions.
PurchasesAmount Decimal The PurchasesAmount column for the table PayablesDocumentDistributions.
RemitToAddressId String The RemitToAddressId column for the table PayablesDocumentDistributions.
ShippingMethodId String The ShippingMethodId column for the table PayablesDocumentDistributions.
TaxAmountCurrency String The TaxAmountCurrency column for the table PayablesDocumentDistributions.
TaxAmount Decimal The TaxAmount column for the table PayablesDocumentDistributions.
TaxDate Datetime The TaxDate column for the table PayablesDocumentDistributions.
TaxScheduleId String The TaxScheduleId column for the table PayablesDocumentDistributions.
TaxesPayablesTaxAggregate String The TaxesPayablesTaxAggregate column for the table PayablesDocumentDistributions.
TradeDiscountAmountCurrency String The TradeDiscountAmountCurrency column for the table PayablesDocumentDistributions.
TradeDiscountAmount Decimal The TradeDiscountAmount column for the table PayablesDocumentDistributions.
TransactionState String The TransactionState column for the table PayablesDocumentDistributions.
Type String The Type column for the table PayablesDocumentDistributions.
VendorDocumentNumber String The VendorDocumentNumber column for the table PayablesDocumentDistributions.
VendorId String The VendorId column for the table PayablesDocumentDistributions.
VendorName String The VendorName column for the table PayablesDocumentDistributions.
ExtensionsExtensionAggregate String The ExtensionsExtensionAggregate column for the table PayablesDocumentDistributions.

PayablesDocumentTaxes

The DynamicsGP table PayablesDocumentTaxes.

Columns
Name Type Description
TaxesKeyTaxDetailId [KEY] String The TaxesKeyTaxDetailId column for the table PayablesDocumentTaxes.
TaxesKeyPayablesDocumentId [KEY] String The TaxesKeyPayablesDocumentId column for the table PayablesDocumentTaxes.
AddressId String The AddressId column for the table PayablesDocumentTaxes.
Amount1099Currency String The Amount1099Currency column for the table PayablesDocumentTaxes.
Amount1099 Decimal The Amount1099 column for the table PayablesDocumentTaxes.
AuditTrailCode String The AuditTrailCode column for the table PayablesDocumentTaxes.
BatchKeyCreatedDateTime Datetime The BatchKeyCreatedDateTime column for the table PayablesDocumentTaxes.
BatchId String The BatchId column for the table PayablesDocumentTaxes.
BatchKeySource String The BatchKeySource column for the table PayablesDocumentTaxes.
ChargeAmountCurrency String The ChargeAmountCurrency column for the table PayablesDocumentTaxes.
ChargeAmount Decimal The ChargeAmount column for the table PayablesDocumentTaxes.
CurrencyKeyISOCode String The CurrencyKeyISOCode column for the table PayablesDocumentTaxes.
Date Datetime The Date column for the table PayablesDocumentTaxes.
Description String The Description column for the table PayablesDocumentTaxes.
DistributionsPayablesDistributionAggregate String The DistributionsPayablesDistributionAggregate column for the table PayablesDocumentTaxes.
DocumentAmountCurrency String The DocumentAmountCurrency column for the table PayablesDocumentTaxes.
DocumentAmount Decimal The DocumentAmount column for the table PayablesDocumentTaxes.
ExchangeDate Datetime The ExchangeDate column for the table PayablesDocumentTaxes.
ExchangeRate Decimal The ExchangeRate column for the table PayablesDocumentTaxes.
FreightAmountCurrency String The FreightAmountCurrency column for the table PayablesDocumentTaxes.
FreightAmount Decimal The FreightAmount column for the table PayablesDocumentTaxes.
FreightTaxScheduleId String The FreightTaxScheduleId column for the table PayablesDocumentTaxes.
GeneralLedgerPostingDate Datetime The GeneralLedgerPostingDate column for the table PayablesDocumentTaxes.
HasIntercompanyDistributions Boolean The HasIntercompanyDistributions column for the table PayablesDocumentTaxes.
IsIntercompanyTransaction Boolean The IsIntercompanyTransaction column for the table PayablesDocumentTaxes.
IsVoided Boolean The IsVoided column for the table PayablesDocumentTaxes.
Id String The ID column for the table PayablesDocumentTaxes.
MiscellaneousAmountCurrency String The MiscellaneousAmountCurrency column for the table PayablesDocumentTaxes.
MiscellaneousAmount Decimal The MiscellaneousAmount column for the table PayablesDocumentTaxes.
MiscellaneousTaxScheduleId String The MiscellaneousTaxScheduleId column for the table PayablesDocumentTaxes.
ModifiedBy String The ModifiedBy column for the table PayablesDocumentTaxes.
ModifiedDate Datetime The ModifiedDate column for the table PayablesDocumentTaxes.
PONumber String The PONumber column for the table PayablesDocumentTaxes.
PostedBy String The PostedBy column for the table PayablesDocumentTaxes.
PostedDate Datetime The PostedDate column for the table PayablesDocumentTaxes.
PurchaseTaxScheduleId String The PurchaseTaxScheduleId column for the table PayablesDocumentTaxes.
PurchasesAmountCurrency String The PurchasesAmountCurrency column for the table PayablesDocumentTaxes.
PurchasesAmount Decimal The PurchasesAmount column for the table PayablesDocumentTaxes.
RemitToAddressId String The RemitToAddressId column for the table PayablesDocumentTaxes.
ShippingMethodId String The ShippingMethodId column for the table PayablesDocumentTaxes.
TaxAmountCurrency String The TaxAmountCurrency column for the table PayablesDocumentTaxes.
TaxAmount Decimal The TaxAmount column for the table PayablesDocumentTaxes.
TaxDate Datetime The TaxDate column for the table PayablesDocumentTaxes.
TaxScheduleId String The TaxScheduleId column for the table PayablesDocumentTaxes.
TaxesFreightTaxAmountCurrency String The TaxesFreightTaxAmountCurrency column for the table PayablesDocumentTaxes.
TaxesFreightTaxAmount Decimal The TaxesFreightTaxAmount column for the table PayablesDocumentTaxes.
TaxesGLAccountId String The TaxesGLAccountId column for the table PayablesDocumentTaxes.
TaxesGLAccountKeyIsEncrypted Boolean The TaxesGLAccountKeyIsEncrypted column for the table PayablesDocumentTaxes.
TaxesIsPosted Boolean The TaxesIsPosted column for the table PayablesDocumentTaxes.
TaxesMiscellaneousTaxAmountCurrency String The TaxesMiscellaneousTaxAmountCurrency column for the table PayablesDocumentTaxes.
TaxesMiscellaneousTaxAmount Decimal The TaxesMiscellaneousTaxAmount column for the table PayablesDocumentTaxes.
TaxesPurchasesTaxAmountCurrency String The TaxesPurchasesTaxAmountCurrency column for the table PayablesDocumentTaxes.
TaxesPurchasesTaxAmount Decimal The TaxesPurchasesTaxAmount column for the table PayablesDocumentTaxes.
TaxesIsBackoutTax Boolean The TaxesIsBackoutTax column for the table PayablesDocumentTaxes.
TaxesTaxAmountCurrency String The TaxesTaxAmountCurrency column for the table PayablesDocumentTaxes.
TaxesTaxAmount Decimal The TaxesTaxAmount column for the table PayablesDocumentTaxes.
TaxesTaxableAmountCurrency String The TaxesTaxableAmountCurrency column for the table PayablesDocumentTaxes.
TaxesTaxableAmount Decimal The TaxesTaxableAmount column for the table PayablesDocumentTaxes.
TaxesTotalAmountCurrency String The TaxesTotalAmountCurrency column for the table PayablesDocumentTaxes.
TaxesTotalAmount Decimal The TaxesTotalAmount column for the table PayablesDocumentTaxes.
TaxesExtensionsExtensionAggregate String The TaxesExtensionsExtensionAggregate column for the table PayablesDocumentTaxes.
TradeDiscountAmountCurrency String The TradeDiscountAmountCurrency column for the table PayablesDocumentTaxes.
TradeDiscountAmount Decimal The TradeDiscountAmount column for the table PayablesDocumentTaxes.
TransactionState String The TransactionState column for the table PayablesDocumentTaxes.
Type String The Type column for the table PayablesDocumentTaxes.
VendorDocumentNumber String The VendorDocumentNumber column for the table PayablesDocumentTaxes.
VendorId String The VendorId column for the table PayablesDocumentTaxes.
VendorName String The VendorName column for the table PayablesDocumentTaxes.
ExtensionsExtensionAggregate String The ExtensionsExtensionAggregate column for the table PayablesDocumentTaxes.

PaymentCardType

Return a list of: PaymentCardType

Columns
Name Type Description
ExtensionsExtensionAggregate String
AcceptedFromCustomers Bool
CompanyCardBankAccountId String
CreatedDate Datetime
CustomerCardBankAccountId String
GLAccountId String
GLAccountKeyIsEncrypted Bool
Id [KEY] String
ModifiedBy String
ModifiedDate Datetime
PayableCardType String
ReceivableCardType String
UsedByCompany Bool
VendorId String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

PaymentTerms

Return a list of: PaymentTerms

Columns
Name Type Description
ExtensionsExtensionAggregate String
CreatedDate Datetime
DaysDiscountAvailable Int
DaysUntilDue Int
DiscountCalculationItem String
DiscountDateBasedOn String
DueDateBasedOn String
IsDiscountCalculatedOnFreight Bool
IsDiscountCalculatedOnMiscellaneous Bool
IsDiscountCalculatedOnSalePurchase Bool
IsDiscountCalculatedOnTax Bool
IsDiscountCalculatedOnTradeDiscount Bool
Id [KEY] String
ModifiedBy String
ModifiedDate Datetime
UseGracePeriods Bool
UseValueAddedTax Bool
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

PlannedOrder

Return a list of: PlannedOrder

Columns
Name Type Description
ExtensionsExtensionAggregate String
DueDate Datetime
IsCRPScheduled Bool
ItemId String
ItemsAggregate String
LLC Int
LocationId String
PlannedOrderId [KEY] String
QuantityToOrder Decimal
ReleaseDate Datetime
Replenishment String
RunNumber Int
Transferred Bool
UnitOfMeasure String
VendorId String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

PlannedOrderItems

Return a list of: PlannedOrderItems

Columns
Name Type Description
ExtensionsExtensionAggregate String
DueDate Datetime
IsCRPScheduled Bool
ItemId String
ItemsAllocatedByOpenMO Decimal
ItemsAllocatedByReleasedMO Decimal
ItemsCanceled Bool
ItemsConsumedByOpenMO Decimal
ItemsConsumedByReleasedMO Decimal
ItemsDueDate Datetime
ItemsExceptionsHasException1 Bool
ItemsExceptionsHasException10 Bool
ItemsExceptionsHasException11 Bool
ItemsExceptionsHasException12 Bool
ItemsExceptionsHasException13 Bool
ItemsExceptionsHasException14 Bool
ItemsExceptionsHasException15 Bool
ItemsExceptionsHasException16 Bool
ItemsExceptionsHasException17 Bool
ItemsExceptionsHasException18 Bool
ItemsExceptionsHasException19 Bool
ItemsExceptionsHasException2 Bool
ItemsExceptionsHasException20 Bool
ItemsExceptionsHasException3 Bool
ItemsExceptionsHasException4 Bool
ItemsExceptionsHasException5 Bool
ItemsExceptionsHasException6 Bool
ItemsExceptionsHasException7 Bool
ItemsExceptionsHasException8 Bool
ItemsExceptionsHasException9 Bool
ItemsItemId String
ItemsLocationId String
ItemsMRPParentType String
ItemsMRPType String
ItemsMoveIn Bool
ItemsMoveOut Bool
ItemsOriginalDueDate Datetime
ItemsPhantomParent String
ItemsPlannedOrderId String
ItemsRequiredByOpenMO Decimal
ItemsRequiredByReleasedMO Decimal
ItemsSequenceNumber [KEY] Int
ItemsStatus String
ItemsStatusDescription String
LLC Int
LocationId String
PlannedOrderId String
QuantityToOrder Decimal
ReleaseDate Datetime
Replenishment String
RunNumber Int
Transferred Bool
UnitOfMeasure String
VendorId String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

PolicyBehaviors

Return a list of: PolicyBehaviors

Columns
Name Type Description
BehaviorsDescription String
BehaviorsInternal Bool
BehaviorsId [KEY] String
BehaviorsKeyPolicyId [KEY] String
BehaviorsName String
BehaviorsOptionsAggregate String
BehaviorsSelectedOptionDescription String
BehaviorsSelectedOptionKeyBehaviorId String
BehaviorsSelectedOptionKeyBehaviorKeyPolicyId String
BehaviorsSelectedOptionId Int
BehaviorsSelectedOptionName String
BehaviorsSelectedOptionParametersAggregate String
Id String
Name String
RootBusinessObjectName String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

PriceLevel

Return a list of: PriceLevel

Columns
Name Type Description
ExtensionsExtensionAggregate String
CreatedDate Datetime
Description String
Id [KEY] String
LastModifiedBy String
LastModifiedDate Datetime
ModifiedDate Datetime
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

PricingDetails

Return a list of: PricingDetails

Columns
Name Type Description
ExtensionsExtensionAggregate String
DetailsExtensionsExtensionAggregate String
DetailsKeyPricingKeyCurrencyKeyISOCode [KEY] String
DetailsKeyPricingKeyItemId [KEY] String
DetailsKeyPricingKeyPriceLevelId [KEY] String
DetailsKeyPricingKeyUofM [KEY] String
DetailsKeyToQuantity [KEY] Decimal
DetailsLastModifiedDate Datetime
DetailsLastModifiedyBy String
DetailsUofMPriceItem String
KeyCurrencyKeyISOCode String
KeyItemId String
KeyPriceLevelId String
KeyUofM String
LastModifiedBy String
LastModifiedDate Datetime
RoundAmountCurrency String
RoundAmount Decimal
RoundOption String
RoundPolicy String
UofMSalesOption String
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

Project

Return a list of: Project

Columns
Name Type Description
ExtensionsExtensionAggregate String
AccountAmountCurrency String
AccountAmount Decimal
AccountingMethod String
AccountsAggregate String
ActualAccruedRevenueAmountCurrency String
ActualAccruedRevenueAmount Decimal
ActualBillingAmountCurrency String
ActualBillingAmount Decimal
ActualBillingsInExcessOfEarningsAmountCurrency String
ActualBillingsInExcessOfEarningsAmount Decimal
ActualDiscountAmountCurrency String
ActualDiscountAmount Decimal
ActualEarningsInExcessOfBillingsAmountCurrency String
ActualEarningsInExcessOfBillingsAmount Decimal
ActualOverheadAmountCurrency String
ActualOverheadAmount Decimal
ActualProfitAmountCurrency String
ActualProfitAmount Decimal
ActualQuantity Decimal
ActualRecognizedRevenueAmountCurrency String
ActualRecognizedRevenueAmount Decimal
ActualRetainageAmountCurrency String
ActualRetainageAmount Decimal
ActualSalesTaxAmountCurrency String
ActualSalesTaxAmount Decimal
ActualTaxAmountCurrency String
ActualTaxAmount Decimal
ActualTotalCostCurrency String
ActualTotalCost Decimal
ActualBeginDate Datetime
ActualEndDate Datetime
BaselineBeginDate Datetime
BaselineBillableAmountCurrency String
BaselineBillableAmount Decimal
BaselineEndDate Datetime
BaselineOverheadCostCurrency String
BaselineOverheadCost Decimal
BaselineProfitAmountCurrency String
BaselineProfitAmount Decimal
BaselineQuantity Decimal
BaselineTaxAmountCurrency String
BaselineTaxAmount Decimal
BaselineTotalCostCurrency String
BaselineTotalCost Decimal
BillToAddressId String
BilledAccruedRevenueCurrency String
BilledAccruedRevenue Decimal
BilledCostCurrency String
BilledCost Decimal
BilledQuantity Decimal
BillingCyclesAggregate String
BillingNotReceivableCurrency String
BillingNotReceivable Decimal
BillingType String
BudgetsAggregate String
BusinessManagerId String
CloseToBillings Bool
CloseToProjectCosts Bool
CommissionBasedOn String
CommissionPercent Decimal
ContactPerson String
CostCompletedPercent Decimal
CurrencyKeyISOCode String
CustomerId String
CustomerPONumber String
DefaultBillingFormat String
DepartmentId String
DiscountPercent Decimal
DoesAcceptEquipmentRateTableReplacement Bool
DoesAcceptLaborRateTableReplacement Bool
DoesCombineForRevenueRecognition Bool
EquipmentListAggregate String
EquipmentRateTableId String
EstimatorId String
FeesAggregate String
ForecastBeginDate Datetime
ForecastBillableAmountCurrency String
ForecastBillableAmount Decimal
ForecastEndDate Datetime
ForecastOverheadCostCurrency String
ForecastOverheadCost Decimal
ForecastProfitAmountCurrency String
ForecastProfitAmount Decimal
ForecastQuantity Decimal
ForecastTaxAmountCurrency String
ForecastTaxAmount Decimal
ForecastTotalCostCurrency String
ForecastTotalCost Decimal
Id [KEY] String
LaborRateTableId String
LaborRateTableType String
Name String
POCommittedCostsCurrency String
POCommittedCosts Decimal
POCommittedQuantity Decimal
PostedAccruedRevenueAmountCurrency String
PostedAccruedRevenueAmount Decimal
PostedBillingAmountCurrency String
PostedBillingAmount Decimal
PostedBillingsInExcessOfEarningsAmountCurrency String
PostedBillingsInExcessOfEarningsAmount Decimal
PostedDiscountAmountCurrency String
PostedDiscountAmount Decimal
PostedEarningsInExcessOfBillingsAmountCurrency String
PostedEarningsInExcessOfBillingsAmount Decimal
PostedOverheadAmountCurrency String
PostedOverheadAmount Decimal
PostedProfitAmountCurrency String
PostedProfitAmount Decimal
PostedQuantity Decimal
PostedRecognizedRevenueAmountCurrency String
PostedRecognizedRevenueAmount Decimal
PostedRetainageAmountCurrency String
PostedRetainageAmount Decimal
PostedSalesTaxAmountCurrency String
PostedSalesTaxAmount Decimal
PostedTaxAmountCurrency String
PostedTaxAmount Decimal
PostedTotalCostCurrency String
PostedTotalCost Decimal
PostedEarningsAmountCurrency String
PostedEarningsAmount Decimal
PostedPOCostsCurrency String
PostedPOCosts Decimal
PostedPOQuantity Decimal
PostedBilledRetentionAmountCurrency String
PostedBilledRetentionAmount Decimal
PostedCostOfEarningsAmountCurrency String
PostedCostOfEarningsAmount Decimal
PostedLossAmountCurrency String
PostedLossAmount Decimal
PostedProjectFeeAmountCurrency String
PostedProjectFeeAmount Decimal
PostedReceiptsAmountCurrency String
PostedReceiptsAmount Decimal
PostedRetainerFeeAmountCurrency String
PostedRetainerFeeAmount Decimal
PostedRetentionAmountCurrency String
PostedRetentionAmount Decimal
PostedServiceFeeAmountCurrency String
PostedServiceFeeAmount Decimal
PostedWriteoffAmountCurrency String
PostedWriteoffAmount Decimal
ProjectAmountCurrency String
ProjectAmount Decimal
ProjectClassId String
ProjectContractId String
ProjectContractId String
ProjectFeeAmountCurrency String
ProjectFeeAmount Decimal
ProjectId String
ProjectManagerId String
QuantityCompletedPercent Decimal
RestrictToCustomerList Bool
RetainerAmountCurrency String
RetainerAmount Decimal
RetentionFeeAmountCurrency String
RetentionFeeAmount Decimal
RetentionPercent Decimal
SUTAState String
SalesTerritoryId String
SalespersonId String
ServiceFeeAmountCurrency String
ServiceFeeAmount Decimal
Status String
TransactionalCurrencyCodeKeyISOCode String
Type String
UnpostedAccruedRevenueAmountCurrency String
UnpostedAccruedRevenueAmount Decimal
UnpostedBillingAmountCurrency String
UnpostedBillingAmount Decimal
UnpostedBillingsInExcessOfEarningsAmountCurrency String
UnpostedBillingsInExcessOfEarningsAmount Decimal
UnpostedDiscountAmountCurrency String
UnpostedDiscountAmount Decimal
UnpostedEarningsInExcessOfBillingsAmountCurrency String
UnpostedEarningsInExcessOfBillingsAmount Decimal
UnpostedOverheadAmountCurrency String
UnpostedOverheadAmount Decimal
UnpostedProfitAmountCurrency String
UnpostedProfitAmount Decimal
UnpostedQuantity Decimal
UnpostedRecognizedRevenueAmountCurrency String
UnpostedRecognizedRevenueAmount Decimal
UnpostedRetainageAmountCurrency String
UnpostedRetainageAmount Decimal
UnpostedSalesTaxAmountCurrency String
UnpostedSalesTaxAmount Decimal
UnpostedTaxAmountCurrency String
UnpostedTaxAmount Decimal
UnpostedTotalCostCurrency String
UnpostedTotalCost Decimal
UnpostedLossAmountCurrency String
UnpostedLossAmount Decimal
UnpostedBilledRetentionAmountCurrency String
UnpostedBilledRetentionAmount Decimal
UnpostedCostOfEarningsAmountCurrency String
UnpostedCostOfEarningsAmount Decimal
UnpostedEarningsAmountCurrency String
UnpostedEarningsAmount Decimal
UnpostedPOCostsCurrency String
UnpostedPOCosts Decimal
UnpostedPOQuantity Decimal
UnpostedProjectFeeAmountCurrency String
UnpostedProjectFeeAmount Decimal
UnpostedReceiptsAmountCurrency String
UnpostedReceiptsAmount Decimal
UnpostedRetainerFeeAmountCurrency String
UnpostedRetainerFeeAmount Decimal
UnpostedRetentionAmountCurrency String
UnpostedRetentionAmount Decimal
UnpostedServiceFeeAmountCurrency String
UnpostedServiceFeeAmount Decimal
UserDefinedText1 String
UserDefinedText2 String
WorkersCompensationId String
WriteUpDownAmountCurrency String
WriteUpDownAmount Decimal
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ProjectAccounts

Return a list of: ProjectAccounts

Columns
Name Type Description
ExtensionsExtensionAggregate String
AccountAmountCurrency String
AccountAmount Decimal
AccountingMethod String
AccountsExtensionsExtensionAggregate String
AccountsGLAccountId String
AccountsGLAccountKeyIsEncrypted Bool
AccountsKeyCostTransaction [KEY] String
AccountsKeyDistributionTypeId [KEY] Int
AccountsKeyProjectId [KEY] String
AccountsKeySourceFile [KEY] String
ActualAccruedRevenueAmountCurrency String
ActualAccruedRevenueAmount Decimal
ActualBillingAmountCurrency String
ActualBillingAmount Decimal
ActualBillingsInExcessOfEarningsAmountCurrency String
ActualBillingsInExcessOfEarningsAmount Decimal
ActualDiscountAmountCurrency String
ActualDiscountAmount Decimal
ActualEarningsInExcessOfBillingsAmountCurrency String
ActualEarningsInExcessOfBillingsAmount Decimal
ActualOverheadAmountCurrency String
ActualOverheadAmount Decimal
ActualProfitAmountCurrency String
ActualProfitAmount Decimal
ActualQuantity Decimal
ActualRecognizedRevenueAmountCurrency String
ActualRecognizedRevenueAmount Decimal
ActualRetainageAmountCurrency String
ActualRetainageAmount Decimal
ActualSalesTaxAmountCurrency String
ActualSalesTaxAmount Decimal
ActualTaxAmountCurrency String
ActualTaxAmount Decimal
ActualTotalCostCurrency String
ActualTotalCost Decimal
ActualBeginDate Datetime
ActualEndDate Datetime
BaselineBeginDate Datetime
BaselineBillableAmountCurrency String
BaselineBillableAmount Decimal
BaselineEndDate Datetime
BaselineOverheadCostCurrency String
BaselineOverheadCost Decimal
BaselineProfitAmountCurrency String
BaselineProfitAmount Decimal
BaselineQuantity Decimal
BaselineTaxAmountCurrency String
BaselineTaxAmount Decimal
BaselineTotalCostCurrency String
BaselineTotalCost Decimal
BillToAddressId String
BilledAccruedRevenueCurrency String
BilledAccruedRevenue Decimal
BilledCostCurrency String
BilledCost Decimal
BilledQuantity Decimal
BillingCyclesAggregate String
BillingNotReceivableCurrency String
BillingNotReceivable Decimal
BillingType String
BudgetsAggregate String
BusinessManagerId String
CloseToBillings Bool
CloseToProjectCosts Bool
CommissionBasedOn String
CommissionPercent Decimal
ContactPerson String
CostCompletedPercent Decimal
CurrencyKeyISOCode String
CustomerId String
CustomerPONumber String
DefaultBillingFormat String
DepartmentId String
DiscountPercent Decimal
DoesAcceptEquipmentRateTableReplacement Bool
DoesAcceptLaborRateTableReplacement Bool
DoesCombineForRevenueRecognition Bool
EquipmentListAggregate String
EquipmentRateTableId String
EstimatorId String
FeesAggregate String
ForecastBeginDate Datetime
ForecastBillableAmountCurrency String
ForecastBillableAmount Decimal
ForecastEndDate Datetime
ForecastOverheadCostCurrency String
ForecastOverheadCost Decimal
ForecastProfitAmountCurrency String
ForecastProfitAmount Decimal
ForecastQuantity Decimal
ForecastTaxAmountCurrency String
ForecastTaxAmount Decimal
ForecastTotalCostCurrency String
ForecastTotalCost Decimal
Id String
LaborRateTableId String
LaborRateTableType String
Name String
POCommittedCostsCurrency String
POCommittedCosts Decimal
POCommittedQuantity Decimal
PostedAccruedRevenueAmountCurrency String
PostedAccruedRevenueAmount Decimal
PostedBillingAmountCurrency String
PostedBillingAmount Decimal
PostedBillingsInExcessOfEarningsAmountCurrency String
PostedBillingsInExcessOfEarningsAmount Decimal
PostedDiscountAmountCurrency String
PostedDiscountAmount Decimal
PostedEarningsInExcessOfBillingsAmountCurrency String
PostedEarningsInExcessOfBillingsAmount Decimal
PostedOverheadAmountCurrency String
PostedOverheadAmount Decimal
PostedProfitAmountCurrency String
PostedProfitAmount Decimal
PostedQuantity Decimal
PostedRecognizedRevenueAmountCurrency String
PostedRecognizedRevenueAmount Decimal
PostedRetainageAmountCurrency String
PostedRetainageAmount Decimal
PostedSalesTaxAmountCurrency String
PostedSalesTaxAmount Decimal
PostedTaxAmountCurrency String
PostedTaxAmount Decimal
PostedTotalCostCurrency String
PostedTotalCost Decimal
PostedEarningsAmountCurrency String
PostedEarningsAmount Decimal
PostedPOCostsCurrency String
PostedPOCosts Decimal
PostedPOQuantity Decimal
PostedBilledRetentionAmountCurrency String
PostedBilledRetentionAmount Decimal
PostedCostOfEarningsAmountCurrency String
PostedCostOfEarningsAmount Decimal
PostedLossAmountCurrency String
PostedLossAmount Decimal
PostedProjectFeeAmountCurrency String
PostedProjectFeeAmount Decimal
PostedReceiptsAmountCurrency String
PostedReceiptsAmount Decimal
PostedRetainerFeeAmountCurrency String
PostedRetainerFeeAmount Decimal
PostedRetentionAmountCurrency String
PostedRetentionAmount Decimal
PostedServiceFeeAmountCurrency String
PostedServiceFeeAmount Decimal
PostedWriteoffAmountCurrency String
PostedWriteoffAmount Decimal
ProjectAmountCurrency String
ProjectAmount Decimal
ProjectClassId String
ProjectContractId String
ProjectContractId String
ProjectFeeAmountCurrency String
ProjectFeeAmount Decimal
ProjectId String
ProjectManagerId String
QuantityCompletedPercent Decimal
RestrictToCustomerList Bool
RetainerAmountCurrency String
RetainerAmount Decimal
RetentionFeeAmountCurrency String
RetentionFeeAmount Decimal
RetentionPercent Decimal
SUTAState String
SalesTerritoryId String
SalespersonId String
ServiceFeeAmountCurrency String
ServiceFeeAmount Decimal
Status String
TransactionalCurrencyCodeKeyISOCode String
Type String
UnpostedAccruedRevenueAmountCurrency String
UnpostedAccruedRevenueAmount Decimal
UnpostedBillingAmountCurrency String
UnpostedBillingAmount Decimal
UnpostedBillingsInExcessOfEarningsAmountCurrency String
UnpostedBillingsInExcessOfEarningsAmount Decimal
UnpostedDiscountAmountCurrency String
UnpostedDiscountAmount Decimal
UnpostedEarningsInExcessOfBillingsAmountCurrency String
UnpostedEarningsInExcessOfBillingsAmount Decimal
UnpostedOverheadAmountCurrency String
UnpostedOverheadAmount Decimal
UnpostedProfitAmountCurrency String
UnpostedProfitAmount Decimal
UnpostedQuantity Decimal
UnpostedRecognizedRevenueAmountCurrency String
UnpostedRecognizedRevenueAmount Decimal
UnpostedRetainageAmountCurrency String
UnpostedRetainageAmount Decimal
UnpostedSalesTaxAmountCurrency String
UnpostedSalesTaxAmount Decimal
UnpostedTaxAmountCurrency String
UnpostedTaxAmount Decimal
UnpostedTotalCostCurrency String
UnpostedTotalCost Decimal
UnpostedLossAmountCurrency String
UnpostedLossAmount Decimal
UnpostedBilledRetentionAmountCurrency String
UnpostedBilledRetentionAmount Decimal
UnpostedCostOfEarningsAmountCurrency String
UnpostedCostOfEarningsAmount Decimal
UnpostedEarningsAmountCurrency String
UnpostedEarningsAmount Decimal
UnpostedPOCostsCurrency String
UnpostedPOCosts Decimal
UnpostedPOQuantity Decimal
UnpostedProjectFeeAmountCurrency String
UnpostedProjectFeeAmount Decimal
UnpostedReceiptsAmountCurrency String
UnpostedReceiptsAmount Decimal
UnpostedRetainerFeeAmountCurrency String
UnpostedRetainerFeeAmount Decimal
UnpostedRetentionAmountCurrency String
UnpostedRetentionAmount Decimal
UnpostedServiceFeeAmountCurrency String
UnpostedServiceFeeAmount Decimal
UserDefinedText1 String
UserDefinedText2 String
WorkersCompensationId String
WriteUpDownAmountCurrency String
WriteUpDownAmount Decimal
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ProjectBillingCycles

Return a list of: ProjectBillingCycles

Columns
Name Type Description
ExtensionsExtensionAggregate String
AccountAmountCurrency String
AccountAmount Decimal
AccountingMethod String
AccountsAggregate String
ActualAccruedRevenueAmountCurrency String
ActualAccruedRevenueAmount Decimal
ActualBillingAmountCurrency String
ActualBillingAmount Decimal
ActualBillingsInExcessOfEarningsAmountCurrency String
ActualBillingsInExcessOfEarningsAmount Decimal
ActualDiscountAmountCurrency String
ActualDiscountAmount Decimal
ActualEarningsInExcessOfBillingsAmountCurrency String
ActualEarningsInExcessOfBillingsAmount Decimal
ActualOverheadAmountCurrency String
ActualOverheadAmount Decimal
ActualProfitAmountCurrency String
ActualProfitAmount Decimal
ActualQuantity Decimal
ActualRecognizedRevenueAmountCurrency String
ActualRecognizedRevenueAmount Decimal
ActualRetainageAmountCurrency String
ActualRetainageAmount Decimal
ActualSalesTaxAmountCurrency String
ActualSalesTaxAmount Decimal
ActualTaxAmountCurrency String
ActualTaxAmount Decimal
ActualTotalCostCurrency String
ActualTotalCost Decimal
ActualBeginDate Datetime
ActualEndDate Datetime
BaselineBeginDate Datetime
BaselineBillableAmountCurrency String
BaselineBillableAmount Decimal
BaselineEndDate Datetime
BaselineOverheadCostCurrency String
BaselineOverheadCost Decimal
BaselineProfitAmountCurrency String
BaselineProfitAmount Decimal
BaselineQuantity Decimal
BaselineTaxAmountCurrency String
BaselineTaxAmount Decimal
BaselineTotalCostCurrency String
BaselineTotalCost Decimal
BillToAddressId String
BilledAccruedRevenueCurrency String
BilledAccruedRevenue Decimal
BilledCostCurrency String
BilledCost Decimal
BilledQuantity Decimal
BillingCyclesExtensionsExtensionAggregate String
BillingCyclesBillingFormat String
BillingCyclesId [KEY] String
BillingCyclesKeyProjectId [KEY] String
BillingNotReceivableCurrency String
BillingNotReceivable Decimal
BillingType String
BudgetsAggregate String
BusinessManagerId String
CloseToBillings Bool
CloseToProjectCosts Bool
CommissionBasedOn String
CommissionPercent Decimal
ContactPerson String
CostCompletedPercent Decimal
CurrencyKeyISOCode String
CustomerId String
CustomerPONumber String
DefaultBillingFormat String
DepartmentId String
DiscountPercent Decimal
DoesAcceptEquipmentRateTableReplacement Bool
DoesAcceptLaborRateTableReplacement Bool
DoesCombineForRevenueRecognition Bool
EquipmentListAggregate String
EquipmentRateTableId String
EstimatorId String
FeesAggregate String
ForecastBeginDate Datetime
ForecastBillableAmountCurrency String
ForecastBillableAmount Decimal
ForecastEndDate Datetime
ForecastOverheadCostCurrency String
ForecastOverheadCost Decimal
ForecastProfitAmountCurrency String
ForecastProfitAmount Decimal
ForecastQuantity Decimal
ForecastTaxAmountCurrency String
ForecastTaxAmount Decimal
ForecastTotalCostCurrency String
ForecastTotalCost Decimal
Id String
LaborRateTableId String
LaborRateTableType String
Name String
POCommittedCostsCurrency String
POCommittedCosts Decimal
POCommittedQuantity Decimal
PostedAccruedRevenueAmountCurrency String
PostedAccruedRevenueAmount Decimal
PostedBillingAmountCurrency String
PostedBillingAmount Decimal
PostedBillingsInExcessOfEarningsAmountCurrency String
PostedBillingsInExcessOfEarningsAmount Decimal
PostedDiscountAmountCurrency String
PostedDiscountAmount Decimal
PostedEarningsInExcessOfBillingsAmountCurrency String
PostedEarningsInExcessOfBillingsAmount Decimal
PostedOverheadAmountCurrency String
PostedOverheadAmount Decimal
PostedProfitAmountCurrency String
PostedProfitAmount Decimal
PostedQuantity Decimal
PostedRecognizedRevenueAmountCurrency String
PostedRecognizedRevenueAmount Decimal
PostedRetainageAmountCurrency String
PostedRetainageAmount Decimal
PostedSalesTaxAmountCurrency String
PostedSalesTaxAmount Decimal
PostedTaxAmountCurrency String
PostedTaxAmount Decimal
PostedTotalCostCurrency String
PostedTotalCost Decimal
PostedEarningsAmountCurrency String
PostedEarningsAmount Decimal
PostedPOCostsCurrency String
PostedPOCosts Decimal
PostedPOQuantity Decimal
PostedBilledRetentionAmountCurrency String
PostedBilledRetentionAmount Decimal
PostedCostOfEarningsAmountCurrency String
PostedCostOfEarningsAmount Decimal
PostedLossAmountCurrency String
PostedLossAmount Decimal
PostedProjectFeeAmountCurrency String
PostedProjectFeeAmount Decimal
PostedReceiptsAmountCurrency String
PostedReceiptsAmount Decimal
PostedRetainerFeeAmountCurrency String
PostedRetainerFeeAmount Decimal
PostedRetentionAmountCurrency String
PostedRetentionAmount Decimal
PostedServiceFeeAmountCurrency String
PostedServiceFeeAmount Decimal
PostedWriteoffAmountCurrency String
PostedWriteoffAmount Decimal
ProjectAmountCurrency String
ProjectAmount Decimal
ProjectClassId String
ProjectContractId String
ProjectContractId String
ProjectFeeAmountCurrency String
ProjectFeeAmount Decimal
ProjectId String
ProjectManagerId String
QuantityCompletedPercent Decimal
RestrictToCustomerList Bool
RetainerAmountCurrency String
RetainerAmount Decimal
RetentionFeeAmountCurrency String
RetentionFeeAmount Decimal
RetentionPercent Decimal
SUTAState String
SalesTerritoryId String
SalespersonId String
ServiceFeeAmountCurrency String
ServiceFeeAmount Decimal
Status String
TransactionalCurrencyCodeKeyISOCode String
Type String
UnpostedAccruedRevenueAmountCurrency String
UnpostedAccruedRevenueAmount Decimal
UnpostedBillingAmountCurrency String
UnpostedBillingAmount Decimal
UnpostedBillingsInExcessOfEarningsAmountCurrency String
UnpostedBillingsInExcessOfEarningsAmount Decimal
UnpostedDiscountAmountCurrency String
UnpostedDiscountAmount Decimal
UnpostedEarningsInExcessOfBillingsAmountCurrency String
UnpostedEarningsInExcessOfBillingsAmount Decimal
UnpostedOverheadAmountCurrency String
UnpostedOverheadAmount Decimal
UnpostedProfitAmountCurrency String
UnpostedProfitAmount Decimal
UnpostedQuantity Decimal
UnpostedRecognizedRevenueAmountCurrency String
UnpostedRecognizedRevenueAmount Decimal
UnpostedRetainageAmountCurrency String
UnpostedRetainageAmount Decimal
UnpostedSalesTaxAmountCurrency String
UnpostedSalesTaxAmount Decimal
UnpostedTaxAmountCurrency String
UnpostedTaxAmount Decimal
UnpostedTotalCostCurrency String
UnpostedTotalCost Decimal
UnpostedLossAmountCurrency String
UnpostedLossAmount Decimal
UnpostedBilledRetentionAmountCurrency String
UnpostedBilledRetentionAmount Decimal
UnpostedCostOfEarningsAmountCurrency String
UnpostedCostOfEarningsAmount Decimal
UnpostedEarningsAmountCurrency String
UnpostedEarningsAmount Decimal
UnpostedPOCostsCurrency String
UnpostedPOCosts Decimal
UnpostedPOQuantity Decimal
UnpostedProjectFeeAmountCurrency String
UnpostedProjectFeeAmount Decimal
UnpostedReceiptsAmountCurrency String
UnpostedReceiptsAmount Decimal
UnpostedRetainerFeeAmountCurrency String
UnpostedRetainerFeeAmount Decimal
UnpostedRetentionAmountCurrency String
UnpostedRetentionAmount Decimal
UnpostedServiceFeeAmountCurrency String
UnpostedServiceFeeAmount Decimal
UserDefinedText1 String
UserDefinedText2 String
WorkersCompensationId String
WriteUpDownAmountCurrency String
WriteUpDownAmount Decimal
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ProjectBudget

Return a list of: ProjectBudget

Columns
Name Type Description
ExtensionsExtensionAggregate String
ActualBeginDate Datetime
ActualCostOfEarningsAmountCurrency String
ActualCostOfEarningsAmount Decimal
ActualEndDate Datetime
ActualLossAmountCurrency String
ActualLossAmount Decimal
ActualReceiptsAmountCurrency String
ActualReceiptsAmount Decimal
ActualWriteoffAmountCurrency String
ActualWriteoffAmount Decimal
BaselineBeginDate Datetime
BaselineBillableAmountCurrency String
BaselineBillableAmount Decimal
BaselineEndDate Datetime
BaselineOverheadCostCurrency String
BaselineOverheadCost Decimal
BaselineProfitAmountCurrency String
BaselineProfitAmount Decimal
BaselineQuantity Decimal
BaselineTaxAmountCurrency String
BaselineTaxAmount Decimal
BaselineTotalCostCurrency String
BaselineTotalCost Decimal
BaselineNetProfitAmountCurrency String
BaselineNetProfitAmount Decimal
BaselineOverheadPercent Decimal
BaselineProfitPercent Decimal
BaselinePurchaseTaxBasis String
BaselinePurchaseTaxScheduleId String
BaselineSalesTaxBasis String
BaselineSalesTaxScheduleId String
BaselineUnitCostCurrency String
BaselineUnitCost Decimal
BilledAccruedRevenueCurrency String
BilledAccruedRevenue Decimal
BilledCostCurrency String
BilledCost Decimal
BilledQuantity Decimal
BillingType String
CostCompletedPercent Decimal
CostOfEarningsAmountCurrency String
CostOfEarningsAmount Decimal
DoesAcceptEquipmentRateTableReplacement Bool
DoesAcceptLaborRateTableReplacement Bool
EarningsAmountCurrency String
EarningsAmount Decimal
EquipmentRateTableId String
ForecastBeginDate Datetime
ForecastBillableAmountCurrency String
ForecastBillableAmount Decimal
ForecastEndDate Datetime
ForecastOverheadCostCurrency String
ForecastOverheadCost Decimal
ForecastProfitAmountCurrency String
ForecastProfitAmount Decimal
ForecastQuantity Decimal
ForecastTaxAmountCurrency String
ForecastTaxAmount Decimal
ForecastTotalCostCurrency String
ForecastTotalCost Decimal
ForecastNetProfitAmountCurrency String
ForecastNetProfitAmount Decimal
ForecastOverheadPercent Decimal
ForecastProfitPercent Decimal
ForecastPurchaseTaxBasis String
ForecastPurchaseTaxScheduleId String
ForecastSalesTaxBasis String
ForecastSalesTaxScheduleId String
ForecastUnitCostCurrency String
ForecastUnitCost Decimal
IsInventoryItem Bool
KeyCostCategoryId [KEY] String
KeyProjectId [KEY] String
KeyTransactionUsage [KEY] Int
LaborRateTableId String
LaborRateTableType String
LineSequenceNumber Int
OverheadRateMethod String
POCommittedCostsCurrency String
POCommittedCosts Decimal
POCommittedQuantity Decimal
PayCodeHourlyId String
PayCodeSalaryId String
PostedAccruedRevenueAmountCurrency String
PostedAccruedRevenueAmount Decimal
PostedBillingAmountCurrency String
PostedBillingAmount Decimal
PostedBillingsInExcessOfEarningsAmountCurrency String
PostedBillingsInExcessOfEarningsAmount Decimal
PostedDiscountAmountCurrency String
PostedDiscountAmount Decimal
PostedEarningsInExcessOfBillingsAmountCurrency String
PostedEarningsInExcessOfBillingsAmount Decimal
PostedOverheadAmountCurrency String
PostedOverheadAmount Decimal
PostedProfitAmountCurrency String
PostedProfitAmount Decimal
PostedQuantity Decimal
PostedRecognizedRevenueAmountCurrency String
PostedRecognizedRevenueAmount Decimal
PostedRetainageAmountCurrency String
PostedRetainageAmount Decimal
PostedSalesTaxAmountCurrency String
PostedSalesTaxAmount Decimal
PostedTaxAmountCurrency String
PostedTaxAmount Decimal
PostedTotalCostCurrency String
PostedTotalCost Decimal
PostedEarningsAmountCurrency String
PostedEarningsAmount Decimal
PostedPOCostsCurrency String
PostedPOCosts Decimal
PostedPOQuantity Decimal
PostedBillableAmountCurrency String
PostedBillableAmount Decimal
PostedCommittedCostCurrency String
PostedCommittedCost Decimal
PostedCommittedQuantity Decimal
PostedCommittedTaxAmountCurrency String
PostedCommittedTaxAmount Decimal
PostedTaxPaidAmountCurrency String
PostedTaxPaidAmount Decimal
ProfitType String
ProjectAmountCurrency String
ProjectAmount Decimal
QuantityCompletedPercent Decimal
ReceiptsAmountCurrency String
ReceiptsAmount Decimal
Status String
TaxPaidAmountCurrency String
TaxPaidAmount Decimal
TransactionalCurrencyCodeISOCode String
UncommittedPOCostsCurrency String
UncommittedPOCosts Decimal
UncommittedPOQuantity Decimal
UnpostedAccruedRevenueAmountCurrency String
UnpostedAccruedRevenueAmount Decimal
UnpostedBillingAmountCurrency String
UnpostedBillingAmount Decimal
UnpostedBillingsInExcessOfEarningsAmountCurrency String
UnpostedBillingsInExcessOfEarningsAmount Decimal
UnpostedDiscountAmountCurrency String
UnpostedDiscountAmount Decimal
UnpostedEarningsInExcessOfBillingsAmountCurrency String
UnpostedEarningsInExcessOfBillingsAmount Decimal
UnpostedOverheadAmountCurrency String
UnpostedOverheadAmount Decimal
UnpostedProfitAmountCurrency String
UnpostedProfitAmount Decimal
UnpostedQuantity Decimal
UnpostedRecognizedRevenueAmountCurrency String
UnpostedRecognizedRevenueAmount Decimal
UnpostedRetainageAmountCurrency String
UnpostedRetainageAmount Decimal
UnpostedSalesTaxAmountCurrency String
UnpostedSalesTaxAmount Decimal
UnpostedTaxAmountCurrency String
UnpostedTaxAmount Decimal
UnpostedTotalCostCurrency String
UnpostedTotalCost Decimal
UnpostedLossAmountCurrency String
UnpostedLossAmount Decimal
UnpostedBeginDate Datetime
UnpostedBillableAmountCurrency String
UnpostedBillableAmount Decimal
UnpostedCommittedCostCurrency String
UnpostedCommittedCost Decimal
UnpostedCommittedQuantity Decimal
UnpostedCommittedTaxAmountCurrency String
UnpostedCommittedTaxAmount Decimal
UnpostedEndDate Datetime
UofM String
UofMScheduleId String
WriteUpDownAmountCurrency String
WriteUpDownAmount Decimal
WriteoffAmountCurrency String
WriteoffAmount Decimal
WriteoffTaxAmountCurrency String
WriteoffTaxAmount Decimal
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ProjectBudgets

Return a list of: ProjectBudgets

Columns
Name Type Description
ExtensionsExtensionAggregate String
AccountAmountCurrency String
AccountAmount Decimal
AccountingMethod String
AccountsAggregate String
ActualAccruedRevenueAmountCurrency String
ActualAccruedRevenueAmount Decimal
ActualBillingAmountCurrency String
ActualBillingAmount Decimal
ActualBillingsInExcessOfEarningsAmountCurrency String
ActualBillingsInExcessOfEarningsAmount Decimal
ActualDiscountAmountCurrency String
ActualDiscountAmount Decimal
ActualEarningsInExcessOfBillingsAmountCurrency String
ActualEarningsInExcessOfBillingsAmount Decimal
ActualOverheadAmountCurrency String
ActualOverheadAmount Decimal
ActualProfitAmountCurrency String
ActualProfitAmount Decimal
ActualQuantity Decimal
ActualRecognizedRevenueAmountCurrency String
ActualRecognizedRevenueAmount Decimal
ActualRetainageAmountCurrency String
ActualRetainageAmount Decimal
ActualSalesTaxAmountCurrency String
ActualSalesTaxAmount Decimal
ActualTaxAmountCurrency String
ActualTaxAmount Decimal
ActualTotalCostCurrency String
ActualTotalCost Decimal
ActualBeginDate Datetime
ActualEndDate Datetime
BaselineBeginDate Datetime
BaselineBillableAmountCurrency String
BaselineBillableAmount Decimal
BaselineEndDate Datetime
BaselineOverheadCostCurrency String
BaselineOverheadCost Decimal
BaselineProfitAmountCurrency String
BaselineProfitAmount Decimal
BaselineQuantity Decimal
BaselineTaxAmountCurrency String
BaselineTaxAmount Decimal
BaselineTotalCostCurrency String
BaselineTotalCost Decimal
BillToAddressId String
BilledAccruedRevenueCurrency String
BilledAccruedRevenue Decimal
BilledCostCurrency String
BilledCost Decimal
BilledQuantity Decimal
BillingCyclesAggregate String
BillingNotReceivableCurrency String
BillingNotReceivable Decimal
BillingType String
BudgetsExtensionsExtensionAggregate String
BudgetsActualBeginDate Datetime
BudgetsActualCostOfEarningsAmountCurrency String
BudgetsActualCostOfEarningsAmount Decimal
BudgetsActualEndDate Datetime
BudgetsActualLossAmountCurrency String
BudgetsActualLossAmount Decimal
BudgetsActualReceiptsAmountCurrency String
BudgetsActualReceiptsAmount Decimal
BudgetsActualWriteoffAmountCurrency String
BudgetsActualWriteoffAmount Decimal
BudgetsBaselineBeginDate Datetime
BudgetsBaselineBillableAmountCurrency String
BudgetsBaselineBillableAmount Decimal
BudgetsBaselineEndDate Datetime
BudgetsBaselineOverheadCostCurrency String
BudgetsBaselineOverheadCost Decimal
BudgetsBaselineProfitAmountCurrency String
BudgetsBaselineProfitAmount Decimal
BudgetsBaselineQuantity Decimal
BudgetsBaselineTaxAmountCurrency String
BudgetsBaselineTaxAmount Decimal
BudgetsBaselineTotalCostCurrency String
BudgetsBaselineTotalCost Decimal
BudgetsBaselineNetProfitAmountCurrency String
BudgetsBaselineNetProfitAmount Decimal
BudgetsBaselineOverheadPercent Decimal
BudgetsBaselineProfitPercent Decimal
BudgetsBaselinePurchaseTaxBasis String
BudgetsBaselinePurchaseTaxScheduleId String
BudgetsBaselineSalesTaxBasis String
BudgetsBaselineSalesTaxScheduleId String
BudgetsBaselineUnitCostCurrency String
BudgetsBaselineUnitCost Decimal
BudgetsBilledAccruedRevenueCurrency String
BudgetsBilledAccruedRevenue Decimal
BudgetsBilledCostCurrency String
BudgetsBilledCost Decimal
BudgetsBilledQuantity Decimal
BudgetsBillingType String
BudgetsCostCompletedPercent Decimal
BudgetsCostOfEarningsAmountCurrency String
BudgetsCostOfEarningsAmount Decimal
BudgetsDoesAcceptEquipmentRateTableReplacement Bool
BudgetsDoesAcceptLaborRateTableReplacement Bool
BudgetsEarningsAmountCurrency String
BudgetsEarningsAmount Decimal
BudgetsEquipmentRateTableId String
BudgetsForecastBeginDate Datetime
BudgetsForecastBillableAmountCurrency String
BudgetsForecastBillableAmount Decimal
BudgetsForecastEndDate Datetime
BudgetsForecastOverheadCostCurrency String
BudgetsForecastOverheadCost Decimal
BudgetsForecastProfitAmountCurrency String
BudgetsForecastProfitAmount Decimal
BudgetsForecastQuantity Decimal
BudgetsForecastTaxAmountCurrency String
BudgetsForecastTaxAmount Decimal
BudgetsForecastTotalCostCurrency String
BudgetsForecastTotalCost Decimal
BudgetsForecastNetProfitAmountCurrency String
BudgetsForecastNetProfitAmount Decimal
BudgetsForecastOverheadPercent Decimal
BudgetsForecastProfitPercent Decimal
BudgetsForecastPurchaseTaxBasis String
BudgetsForecastPurchaseTaxScheduleId String
BudgetsForecastSalesTaxBasis String
BudgetsForecastSalesTaxScheduleId String
BudgetsForecastUnitCostCurrency String
BudgetsForecastUnitCost Decimal
BudgetsIsInventoryItem Bool
BudgetsKeyCostCategoryId [KEY] String
BudgetsKeyProjectId [KEY] String
BudgetsKeyTransactionUsage [KEY] Int
BudgetsLaborRateTableId String
BudgetsLaborRateTableType String
BudgetsLineSequenceNumber Int
BudgetsOverheadRateMethod String
BudgetsPOCommittedCostsCurrency String
BudgetsPOCommittedCosts Decimal
BudgetsPOCommittedQuantity Decimal
BudgetsPayCodeHourlyId String
BudgetsPayCodeSalaryId String
BudgetsPostedAccruedRevenueAmountCurrency String
BudgetsPostedAccruedRevenueAmount Decimal
BudgetsPostedBillingAmountCurrency String
BudgetsPostedBillingAmount Decimal
BudgetsPostedBillingsInExcessOfEarningsAmountCurrency String
BudgetsPostedBillingsInExcessOfEarningsAmount Decimal
BudgetsPostedDiscountAmountCurrency String
BudgetsPostedDiscountAmount Decimal
BudgetsPostedEarningsInExcessOfBillingsAmountCurrency String
BudgetsPostedEarningsInExcessOfBillingsAmount Decimal
BudgetsPostedOverheadAmountCurrency String
BudgetsPostedOverheadAmount Decimal
BudgetsPostedProfitAmountCurrency String
BudgetsPostedProfitAmount Decimal
BudgetsPostedQuantity Decimal
BudgetsPostedRecognizedRevenueAmountCurrency String
BudgetsPostedRecognizedRevenueAmount Decimal
BudgetsPostedRetainageAmountCurrency String
BudgetsPostedRetainageAmount Decimal
BudgetsPostedSalesTaxAmountCurrency String
BudgetsPostedSalesTaxAmount Decimal
BudgetsPostedTaxAmountCurrency String
BudgetsPostedTaxAmount Decimal
BudgetsPostedTotalCostCurrency String
BudgetsPostedTotalCost Decimal
BudgetsPostedEarningsAmountCurrency String
BudgetsPostedEarningsAmount Decimal
BudgetsPostedPOCostsCurrency String
BudgetsPostedPOCosts Decimal
BudgetsPostedPOQuantity Decimal
BudgetsPostedBillableAmountCurrency String
BudgetsPostedBillableAmount Decimal
BudgetsPostedCommittedCostCurrency String
BudgetsPostedCommittedCost Decimal
BudgetsPostedCommittedQuantity Decimal
BudgetsPostedCommittedTaxAmountCurrency String
BudgetsPostedCommittedTaxAmount Decimal
BudgetsPostedTaxPaidAmountCurrency String
BudgetsPostedTaxPaidAmount Decimal
BudgetsProfitType String
BudgetsProjectAmountCurrency String
BudgetsProjectAmount Decimal
BudgetsQuantityCompletedPercent Decimal
BudgetsReceiptsAmountCurrency String
BudgetsReceiptsAmount Decimal
BudgetsStatus String
BudgetsTaxPaidAmountCurrency String
BudgetsTaxPaidAmount Decimal
BudgetsTransactionalCurrencyCodeISOCode String
BudgetsUncommittedPOCostsCurrency String
BudgetsUncommittedPOCosts Decimal
BudgetsUncommittedPOQuantity Decimal
BudgetsUnpostedAccruedRevenueAmountCurrency String
BudgetsUnpostedAccruedRevenueAmount Decimal
BudgetsUnpostedBillingAmountCurrency String
BudgetsUnpostedBillingAmount Decimal
BudgetsUnpostedBillingsInExcessOfEarningsAmountCurrency String
BudgetsUnpostedBillingsInExcessOfEarningsAmount Decimal
BudgetsUnpostedDiscountAmountCurrency String
BudgetsUnpostedDiscountAmount Decimal
BudgetsUnpostedEarningsInExcessOfBillingsAmountCurrency String
BudgetsUnpostedEarningsInExcessOfBillingsAmount Decimal
BudgetsUnpostedOverheadAmountCurrency String
BudgetsUnpostedOverheadAmount Decimal
BudgetsUnpostedProfitAmountCurrency String
BudgetsUnpostedProfitAmount Decimal
BudgetsUnpostedQuantity Decimal
BudgetsUnpostedRecognizedRevenueAmountCurrency String
BudgetsUnpostedRecognizedRevenueAmount Decimal
BudgetsUnpostedRetainageAmountCurrency String
BudgetsUnpostedRetainageAmount Decimal
BudgetsUnpostedSalesTaxAmountCurrency String
BudgetsUnpostedSalesTaxAmount Decimal
BudgetsUnpostedTaxAmountCurrency String
BudgetsUnpostedTaxAmount Decimal
BudgetsUnpostedTotalCostCurrency String
BudgetsUnpostedTotalCost Decimal
BudgetsUnpostedLossAmountCurrency String
BudgetsUnpostedLossAmount Decimal
BudgetsUnpostedBeginDate Datetime
BudgetsUnpostedBillableAmountCurrency String
BudgetsUnpostedBillableAmount Decimal
BudgetsUnpostedCommittedCostCurrency String
BudgetsUnpostedCommittedCost Decimal
BudgetsUnpostedCommittedQuantity Decimal
BudgetsUnpostedCommittedTaxAmountCurrency String
BudgetsUnpostedCommittedTaxAmount Decimal
BudgetsUnpostedEndDate Datetime
BudgetsUofM String
BudgetsUofMScheduleId String
BudgetsWriteUpDownAmountCurrency String
BudgetsWriteUpDownAmount Decimal
BudgetsWriteoffAmountCurrency String
BudgetsWriteoffAmount Decimal
BudgetsWriteoffTaxAmountCurrency String
BudgetsWriteoffTaxAmount Decimal
BusinessManagerId String
CloseToBillings Bool
CloseToProjectCosts Bool
CommissionBasedOn String
CommissionPercent Decimal
ContactPerson String
CostCompletedPercent Decimal
CurrencyKeyISOCode String
CustomerId String
CustomerPONumber String
DefaultBillingFormat String
DepartmentId String
DiscountPercent Decimal
DoesAcceptEquipmentRateTableReplacement Bool
DoesAcceptLaborRateTableReplacement Bool
DoesCombineForRevenueRecognition Bool
EquipmentListAggregate String
EquipmentRateTableId String
EstimatorId String
FeesAggregate String
ForecastBeginDate Datetime
ForecastBillableAmountCurrency String
ForecastBillableAmount Decimal
ForecastEndDate Datetime
ForecastOverheadCostCurrency String
ForecastOverheadCost Decimal
ForecastProfitAmountCurrency String
ForecastProfitAmount Decimal
ForecastQuantity Decimal
ForecastTaxAmountCurrency String
ForecastTaxAmount Decimal
ForecastTotalCostCurrency String
ForecastTotalCost Decimal
Id String
LaborRateTableId String
LaborRateTableType String
Name String
POCommittedCostsCurrency String
POCommittedCosts Decimal
POCommittedQuantity Decimal
PostedAccruedRevenueAmountCurrency String
PostedAccruedRevenueAmount Decimal
PostedBillingAmountCurrency String
PostedBillingAmount Decimal
PostedBillingsInExcessOfEarningsAmountCurrency String
PostedBillingsInExcessOfEarningsAmount Decimal
PostedDiscountAmountCurrency String
PostedDiscountAmount Decimal
PostedEarningsInExcessOfBillingsAmountCurrency String
PostedEarningsInExcessOfBillingsAmount Decimal
PostedOverheadAmountCurrency String
PostedOverheadAmount Decimal
PostedProfitAmountCurrency String
PostedProfitAmount Decimal
PostedQuantity Decimal
PostedRecognizedRevenueAmountCurrency String
PostedRecognizedRevenueAmount Decimal
PostedRetainageAmountCurrency String
PostedRetainageAmount Decimal
PostedSalesTaxAmountCurrency String
PostedSalesTaxAmount Decimal
PostedTaxAmountCurrency String
PostedTaxAmount Decimal
PostedTotalCostCurrency String
PostedTotalCost Decimal
PostedEarningsAmountCurrency String
PostedEarningsAmount Decimal
PostedPOCostsCurrency String
PostedPOCosts Decimal
PostedPOQuantity Decimal
PostedBilledRetentionAmountCurrency String
PostedBilledRetentionAmount Decimal
PostedCostOfEarningsAmountCurrency String
PostedCostOfEarningsAmount Decimal
PostedLossAmountCurrency String
PostedLossAmount Decimal
PostedProjectFeeAmountCurrency String
PostedProjectFeeAmount Decimal
PostedReceiptsAmountCurrency String
PostedReceiptsAmount Decimal
PostedRetainerFeeAmountCurrency String
PostedRetainerFeeAmount Decimal
PostedRetentionAmountCurrency String
PostedRetentionAmount Decimal
PostedServiceFeeAmountCurrency String
PostedServiceFeeAmount Decimal
PostedWriteoffAmountCurrency String
PostedWriteoffAmount Decimal
ProjectAmountCurrency String
ProjectAmount Decimal
ProjectClassId String
ProjectContractId String
ProjectContractId String
ProjectFeeAmountCurrency String
ProjectFeeAmount Decimal
ProjectId String
ProjectManagerId String
QuantityCompletedPercent Decimal
RestrictToCustomerList Bool
RetainerAmountCurrency String
RetainerAmount Decimal
RetentionFeeAmountCurrency String
RetentionFeeAmount Decimal
RetentionPercent Decimal
SUTAState String
SalesTerritoryId String
SalespersonId String
ServiceFeeAmountCurrency String
ServiceFeeAmount Decimal
Status String
TransactionalCurrencyCodeKeyISOCode String
Type String
UnpostedAccruedRevenueAmountCurrency String
UnpostedAccruedRevenueAmount Decimal
UnpostedBillingAmountCurrency String
UnpostedBillingAmount Decimal
UnpostedBillingsInExcessOfEarningsAmountCurrency String
UnpostedBillingsInExcessOfEarningsAmount Decimal
UnpostedDiscountAmountCurrency String
UnpostedDiscountAmount Decimal
UnpostedEarningsInExcessOfBillingsAmountCurrency String
UnpostedEarningsInExcessOfBillingsAmount Decimal
UnpostedOverheadAmountCurrency String
UnpostedOverheadAmount Decimal
UnpostedProfitAmountCurrency String
UnpostedProfitAmount Decimal
UnpostedQuantity Decimal
UnpostedRecognizedRevenueAmountCurrency String
UnpostedRecognizedRevenueAmount Decimal
UnpostedRetainageAmountCurrency String
UnpostedRetainageAmount Decimal
UnpostedSalesTaxAmountCurrency String
UnpostedSalesTaxAmount Decimal
UnpostedTaxAmountCurrency String
UnpostedTaxAmount Decimal
UnpostedTotalCostCurrency String
UnpostedTotalCost Decimal
UnpostedLossAmountCurrency String
UnpostedLossAmount Decimal
UnpostedBilledRetentionAmountCurrency String
UnpostedBilledRetentionAmount Decimal
UnpostedCostOfEarningsAmountCurrency String
UnpostedCostOfEarningsAmount Decimal
UnpostedEarningsAmountCurrency String
UnpostedEarningsAmount Decimal
UnpostedPOCostsCurrency String
UnpostedPOCosts Decimal
UnpostedPOQuantity Decimal
UnpostedProjectFeeAmountCurrency String
UnpostedProjectFeeAmount Decimal
UnpostedReceiptsAmountCurrency String
UnpostedReceiptsAmount Decimal
UnpostedRetainerFeeAmountCurrency String
UnpostedRetainerFeeAmount Decimal
UnpostedRetentionAmountCurrency String
UnpostedRetentionAmount Decimal
UnpostedServiceFeeAmountCurrency String
UnpostedServiceFeeAmount Decimal
UserDefinedText1 String
UserDefinedText2 String
WorkersCompensationId String
WriteUpDownAmountCurrency String
WriteUpDownAmount Decimal
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ProjectChangeOrder

Return a list of: ProjectChangeOrder

Columns
Name Type Description
ExtensionsExtensionAggregate String
ApprovalDate Datetime
ApprovedBy String
ApproverPosition String
BudgetsAggregate String
ContractBeginDate Datetime
ContractEndDate Datetime
CustomerChangeOrderNumber String
CustomerId String
Date Datetime
Description String
DocumentStatus String
EstimatedBy String
FeesAggregate String
Id [KEY] String
KeyProjectContractId [KEY] String
LastProcessedDate Datetime
ModifiedBy String
PreviousContractBeginDate Datetime
PreviousContractEndDate Datetime
PreviousProjectAmountCurrency String
PreviousProjectAmount Decimal
ProjectAmountCurrency String
ProjectAmount Decimal
ReasonForRevision String
RequestedBy String
RevisedBudgetTotalAmountCurrency String
RevisedBudgetTotalAmount Decimal
RevisedBy String
RevisedFeeTotalAmountCurrency String
RevisedFeeTotalAmount Decimal
RevisedProjectAmountCurrency String
RevisedProjectAmount Decimal
RevisersPosition String
SequenceNumber Int
Status String
TotalBillingCurrency String
TotalBilling Decimal
TotalChangeOrderAmountCurrency String
TotalChangeOrderAmount Decimal
TotalCostCurrency String
TotalCost Decimal
TotalQuantity Decimal
TrackChangesToType String
Type String
VarianceProjectAmountCurrency String
VarianceProjectAmount Decimal
VarianceTotalBillingCurrency String
VarianceTotalBilling Decimal
VarianceTotalCostCurrency String
VarianceTotalCost Decimal
VarianceTotalQuantity Decimal
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ProjectChangeOrderBudgets

Return a list of: ProjectChangeOrderBudgets

Columns
Name Type Description
ExtensionsExtensionAggregate String
ApprovalDate Datetime
ApprovedBy String
ApproverPosition String
BudgetsExtensionsExtensionAggregate String
BudgetsActualReceiptAmountCurrency String
BudgetsActualReceiptAmount Decimal
BudgetsActualWriteoffAmountCurrency String
BudgetsActualWriteoffAmount Decimal
BudgetsActualWriteoffTaxAmountCurrency String
BudgetsActualWriteoffTaxAmount Decimal
BudgetsApprovalDate Datetime
BudgetsBaselineOverheadCostCurrency String
BudgetsBaselineOverheadCost Decimal
BudgetsBaselineProfitAmountCurrency String
BudgetsBaselineProfitAmount Decimal
BudgetsBaselineQuantity Decimal
BudgetsBaselineUnitCostCurrency String
BudgetsBaselineUnitCost Decimal
BudgetsBillingType String
BudgetsContractBeginDate Datetime
BudgetsContractEndDate Datetime
BudgetsCostCategoryId String
BudgetsFinalQuoteAmountCurrency String
BudgetsFinalQuoteAmount Decimal
BudgetsInitialQuoteAmountCurrency String
BudgetsInitialQuoteAmount Decimal
BudgetsIsClosed Bool
BudgetsKeyLineSequenceNumber [KEY] Int
BudgetsKeyProjectChangeOrderId [KEY] String
BudgetsKeyProjectChangeOrderKeyProjectContractId [KEY] String
BudgetsLineItemSequenceNumber Int
BudgetsOriginalBudgetAmountCurrency String
BudgetsOriginalBudgetAmount Decimal
BudgetsOriginalProjectAmountCurrency String
BudgetsOriginalProjectAmount Decimal
BudgetsOverheadPercent Decimal
BudgetsPayCodeHourlyId String
BudgetsPayCodeSalaryId String
BudgetsPostedAccruedRevenueAmountCurrency String
BudgetsPostedAccruedRevenueAmount Decimal
BudgetsPostedBillingAmountCurrency String
BudgetsPostedBillingAmount Decimal
BudgetsPostedBillingsInExcessOfEarningsAmountCurrency String
BudgetsPostedBillingsInExcessOfEarningsAmount Decimal
BudgetsPostedDiscountAmountCurrency String
BudgetsPostedDiscountAmount Decimal
BudgetsPostedEarningsInExcessOfBillingsAmountCurrency String
BudgetsPostedEarningsInExcessOfBillingsAmount Decimal
BudgetsPostedOverheadAmountCurrency String
BudgetsPostedOverheadAmount Decimal
BudgetsPostedProfitAmountCurrency String
BudgetsPostedProfitAmount Decimal
BudgetsPostedQuantity Decimal
BudgetsPostedRecognizedRevenueAmountCurrency String
BudgetsPostedRecognizedRevenueAmount Decimal
BudgetsPostedRetainageAmountCurrency String
BudgetsPostedRetainageAmount Decimal
BudgetsPostedSalesTaxAmountCurrency String
BudgetsPostedSalesTaxAmount Decimal
BudgetsPostedTaxAmountCurrency String
BudgetsPostedTaxAmount Decimal
BudgetsPostedTotalCostCurrency String
BudgetsPostedTotalCost Decimal
BudgetsPostedTaxPaidAmountCurrency String
BudgetsPostedTaxPaidAmount Decimal
BudgetsPreviousBaselineOverheadCostCurrency String
BudgetsPreviousBaselineOverheadCost Decimal
BudgetsPreviousBaselineProfitAmountCurrency String
BudgetsPreviousBaselineProfitAmount Decimal
BudgetsPreviousBaselineQuantity Decimal
BudgetsPreviousBaselineUnitCostCurrency String
BudgetsPreviousBaselineUnitCost Decimal
BudgetsPreviousContractBeginDate Datetime
BudgetsPreviousContractEndDate Datetime
BudgetsPreviousOverheadPercent Decimal
BudgetsPreviousPayCodeHourlyId String
BudgetsPreviousPayCodeSalaryId String
BudgetsPreviousProfitAmountCurrency String
BudgetsPreviousProfitAmount Decimal
BudgetsPreviousProfitPercent Decimal
BudgetsPreviousProjectAmountCurrency String
BudgetsPreviousProjectAmount Decimal
BudgetsPreviousPurchaseTaxBasis String
BudgetsPreviousQuantity Decimal
BudgetsPreviousSalesTaxBasis String
BudgetsPreviousSalesTaxScheduleId String
BudgetsPreviousTaxScheduleId String
BudgetsPreviousTotalBillingAmountCurrency String
BudgetsPreviousTotalBillingAmount Decimal
BudgetsPreviousTotalCostCurrency String
BudgetsPreviousTotalCost Decimal
BudgetsPreviousTotalOverheadAmountCurrency String
BudgetsPreviousTotalOverheadAmount Decimal
BudgetsPreviousTotalProfitAmountCurrency String
BudgetsPreviousTotalProfitAmount Decimal
BudgetsPreviousUnitCostCurrency String
BudgetsPreviousUnitCost Decimal
BudgetsProfitAmountCurrency String
BudgetsProfitAmount Decimal
BudgetsProfitPercent Decimal
BudgetsProfitType String
BudgetsProjectAmountCurrency String
BudgetsProjectAmount Decimal
BudgetsProjectId String
BudgetsPurchaseTaxBasis String
BudgetsPurchaseTaxScheduleId String
BudgetsQuantity Decimal
BudgetsQuoteApprovedBy String
BudgetsQuotePreparedBy String
BudgetsRevisedBudgetTotalAmountCurrency String
BudgetsRevisedBudgetTotalAmount Decimal
BudgetsRevisedProjectTotalAmountCurrency String
BudgetsRevisedProjectTotalAmount Decimal
BudgetsSalesTaxBasis String
BudgetsSalesTaxScheduleId String
BudgetsSequenceNumber Int
BudgetsTotalBillingAmountCurrency String
BudgetsTotalBillingAmount Decimal
BudgetsTotalCostCurrency String
BudgetsTotalCost Decimal
BudgetsTotalOverheadAmountCurrency String
BudgetsTotalOverheadAmount Decimal
BudgetsTotalProfitAmountCurrency String
BudgetsTotalProfitAmount Decimal
BudgetsUnitCostCurrency String
BudgetsUnitCost Decimal
BudgetsUofM String
BudgetsUofMScheduleId String
BudgetsVarianceMarkupPercent Decimal
BudgetsVarianceOverheadAmountCurrency String
BudgetsVarianceOverheadAmount Decimal
BudgetsVarianceOverheadPercent Decimal
BudgetsVarianceProfitAmountCurrency String
BudgetsVarianceProfitAmount Decimal
BudgetsVarianceProjectAmountCurrency String
BudgetsVarianceProjectAmount Decimal
BudgetsVarianceQuantity Decimal
BudgetsVarianceTotalBillingAmountCurrency String
BudgetsVarianceTotalBillingAmount Decimal
BudgetsVarianceTotalCostCurrency String
BudgetsVarianceTotalCost Decimal
BudgetsVarianceTotalProfitAmountCurrency String
BudgetsVarianceTotalProfitAmount Decimal
BudgetsVarianceUnitCostCurrency String
BudgetsVarianceUnitCost Decimal
ContractBeginDate Datetime
ContractEndDate Datetime
CustomerChangeOrderNumber String
CustomerId String
Date Datetime
Description String
DocumentStatus String
EstimatedBy String
FeesAggregate String
Id String
KeyProjectContractId String
LastProcessedDate Datetime
ModifiedBy String
PreviousContractBeginDate Datetime
PreviousContractEndDate Datetime
PreviousProjectAmountCurrency String
PreviousProjectAmount Decimal
ProjectAmountCurrency String
ProjectAmount Decimal
ReasonForRevision String
RequestedBy String
RevisedBudgetTotalAmountCurrency String
RevisedBudgetTotalAmount Decimal
RevisedBy String
RevisedFeeTotalAmountCurrency String
RevisedFeeTotalAmount Decimal
RevisedProjectAmountCurrency String
RevisedProjectAmount Decimal
RevisersPosition String
SequenceNumber Int
Status String
TotalBillingCurrency String
TotalBilling Decimal
TotalChangeOrderAmountCurrency String
TotalChangeOrderAmount Decimal
TotalCostCurrency String
TotalCost Decimal
TotalQuantity Decimal
TrackChangesToType String
Type String
VarianceProjectAmountCurrency String
VarianceProjectAmount Decimal
VarianceTotalBillingCurrency String
VarianceTotalBilling Decimal
VarianceTotalCostCurrency String
VarianceTotalCost Decimal
VarianceTotalQuantity Decimal
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ProjectChangeOrderFees

Return a list of: ProjectChangeOrderFees

Columns
Name Type Description
ExtensionsExtensionAggregate String
ApprovalDate Datetime
ApprovedBy String
ApproverPosition String
BudgetsAggregate String
ContractBeginDate Datetime
ContractEndDate Datetime
CustomerChangeOrderNumber String
CustomerId String
Date Datetime
Description String
DocumentStatus String
EstimatedBy String
FeesExtensionsExtensionAggregate String
FeesContractBeginDate Datetime
FeesContractEndDate Datetime
FeesKeyProjectChangeOrderId [KEY] String
FeesKeyProjectChangeOrderKeyProjectContractId [KEY] String
FeesKeyProjectId [KEY] String
FeesLinesAggregate String
FeesPostedProjectFeeAmountCurrency String
FeesPostedProjectFeeAmount Decimal
FeesPostedRetainerFeeAmountCurrency String
FeesPostedRetainerFeeAmount Decimal
FeesPostedRetentionFeeAmountCurrency String
FeesPostedRetentionFeeAmount Decimal
FeesPostedServiceFeeAmountCurrency String
FeesPostedServiceFeeAmount Decimal
FeesSequenceNumber Int
FeesTotalProjectFeeAmountCurrency String
FeesTotalProjectFeeAmount Decimal
FeesTotalRetainerFeeAmountCurrency String
FeesTotalRetainerFeeAmount Decimal
FeesTotalRetentionFeeAmountCurrency String
FeesTotalRetentionFeeAmount Decimal
FeesTotalServiceFeeAmountCurrency String
FeesTotalServiceFeeAmount Decimal
FeesVarianceFeeAmountCurrency String
FeesVarianceFeeAmount Decimal
FeesVarianceProjectFeeAmountCurrency String
FeesVarianceProjectFeeAmount Decimal
FeesVarianceRetainerFeeAmountCurrency String
FeesVarianceRetainerFeeAmount Decimal
FeesVarianceRetentionFeeAmountCurrency String
FeesVarianceRetentionFeeAmount Decimal
FeesVarianceServiceFeeAmountCurrency String
FeesVarianceServiceFeeAmount Decimal
Id String
KeyProjectContractId String
LastProcessedDate Datetime
ModifiedBy String
PreviousContractBeginDate Datetime
PreviousContractEndDate Datetime
PreviousProjectAmountCurrency String
PreviousProjectAmount Decimal
ProjectAmountCurrency String
ProjectAmount Decimal
ReasonForRevision String
RequestedBy String
RevisedBudgetTotalAmountCurrency String
RevisedBudgetTotalAmount Decimal
RevisedBy String
RevisedFeeTotalAmountCurrency String
RevisedFeeTotalAmount Decimal
RevisedProjectAmountCurrency String
RevisedProjectAmount Decimal
RevisersPosition String
SequenceNumber Int
Status String
TotalBillingCurrency String
TotalBilling Decimal
TotalChangeOrderAmountCurrency String
TotalChangeOrderAmount Decimal
TotalCostCurrency String
TotalCost Decimal
TotalQuantity Decimal
TrackChangesToType String
Type String
VarianceProjectAmountCurrency String
VarianceProjectAmount Decimal
VarianceTotalBillingCurrency String
VarianceTotalBilling Decimal
VarianceTotalCostCurrency String
VarianceTotalCost Decimal
VarianceTotalQuantity Decimal
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ProjectContract

Return a list of: ProjectContract

Columns
Name Type Description
ExtensionsExtensionAggregate String
AccountingMethod String
AccountsAggregate String
ActualAccruedRevenueAmountCurrency String
ActualAccruedRevenueAmount Decimal
ActualBillingAmountCurrency String
ActualBillingAmount Decimal
ActualBillingsInExcessOfEarningsAmountCurrency String
ActualBillingsInExcessOfEarningsAmount Decimal
ActualDiscountAmountCurrency String
ActualDiscountAmount Decimal
ActualEarningsInExcessOfBillingsAmountCurrency String
ActualEarningsInExcessOfBillingsAmount Decimal
ActualOverheadAmountCurrency String
ActualOverheadAmount Decimal
ActualProfitAmountCurrency String
ActualProfitAmount Decimal
ActualQuantity Decimal
ActualRecognizedRevenueAmountCurrency String
ActualRecognizedRevenueAmount Decimal
ActualRetainageAmountCurrency String
ActualRetainageAmount Decimal
ActualSalesTaxAmountCurrency String
ActualSalesTaxAmount Decimal
ActualTaxAmountCurrency String
ActualTaxAmount Decimal
ActualTotalCostCurrency String
ActualTotalCost Decimal
ActualBeginDate Datetime
ActualBilledRetentionAmountCurrency String
ActualBilledRetentionAmount Decimal
ActualCommittedPOCostCurrency String
ActualCommittedPOCost Decimal
ActualCommittedPOQuantity Decimal
ActualCommittedPOTaxAmountCurrency String
ActualCommittedPOTaxAmount Decimal
ActualCostOfEarningsAmountCurrency String
ActualCostOfEarningsAmount Decimal
ActualEarningsAmountCurrency String
ActualEarningsAmount Decimal
ActualEndDate Datetime
ActualLossAmountCurrency String
ActualLossAmount Decimal
ActualPOCostsCurrency String
ActualPOCosts Decimal
ActualPOQuantity Decimal
ActualProjectFeeAmountCurrency String
ActualProjectFeeAmount Decimal
ActualReceiptsAmountCurrency String
ActualReceiptsAmount Decimal
ActualRetainerFeeAmountCurrency String
ActualRetainerFeeAmount Decimal
ActualRetentionAmountCurrency String
ActualRetentionAmount Decimal
ActualServiceFeeAmountCurrency String
ActualServiceFeeAmount Decimal
AddressId String
BaselineBeginDate Datetime
BaselineBillableAmountCurrency String
BaselineBillableAmount Decimal
BaselineEndDate Datetime
BaselineOverheadCostCurrency String
BaselineOverheadCost Decimal
BaselineProfitAmountCurrency String
BaselineProfitAmount Decimal
BaselineQuantity Decimal
BaselineTaxAmountCurrency String
BaselineTaxAmount Decimal
BaselineTotalCostCurrency String
BaselineTotalCost Decimal
BillToAddressId String
BilledAccruedRevenueCurrency String
BilledAccruedRevenue Decimal
BilledCostCurrency String
BilledCost Decimal
BilledQuantity Decimal
BillingCyclesAggregate String
BusinessManagerId String
ClassId String
CloseToBillings String
CloseToProjectCosts String
CommissionBasedOn String
CommissionPercent Decimal
ContactPerson String
ContractManagerId String
CostCompletedPercent Decimal
CurrencyKeyISOCode String
CustomerId String
CustomerPONumber String
DefaultBillingFormat String
DiscountPercent Decimal
DoesCombineForRevenueRecognition Bool
ForecastBeginDate Datetime
ForecastBillableAmountCurrency String
ForecastBillableAmount Decimal
ForecastEndDate Datetime
ForecastOverheadCostCurrency String
ForecastOverheadCost Decimal
ForecastProfitAmountCurrency String
ForecastProfitAmount Decimal
ForecastQuantity Decimal
ForecastTaxAmountCurrency String
ForecastTaxAmount Decimal
ForecastTotalCostCurrency String
ForecastTotalCost Decimal
Id [KEY] String
Name String
POCommittedCostsCurrency String
POCommittedCosts Decimal
POCommittedQuantity Decimal
ProjectAmountCurrency String
ProjectAmount Decimal
ProjectContractId String
ProjectFeeAmountCurrency String
ProjectFeeAmount Decimal
ProjectType String
QuantityCompletedPercent Decimal
RestrictToCustomerList Bool
RetainerAmountCurrency String
RetainerAmount Decimal
RetentionFeeAmountCurrency String
RetentionFeeAmount Decimal
SalesTerritoryId String
SalespersonId String
ServiceFeeAmountCurrency String
ServiceFeeAmount Decimal
Status String
TransactionalCurrencyKeyISOCode String
UnpostedAccruedRevenueAmountCurrency String
UnpostedAccruedRevenueAmount Decimal
UnpostedBillingAmountCurrency String
UnpostedBillingAmount Decimal
UnpostedBillingsInExcessOfEarningsAmountCurrency String
UnpostedBillingsInExcessOfEarningsAmount Decimal
UnpostedDiscountAmountCurrency String
UnpostedDiscountAmount Decimal
UnpostedEarningsInExcessOfBillingsAmountCurrency String
UnpostedEarningsInExcessOfBillingsAmount Decimal
UnpostedOverheadAmountCurrency String
UnpostedOverheadAmount Decimal
UnpostedProfitAmountCurrency String
UnpostedProfitAmount Decimal
UnpostedQuantity Decimal
UnpostedRecognizedRevenueAmountCurrency String
UnpostedRecognizedRevenueAmount Decimal
UnpostedRetainageAmountCurrency String
UnpostedRetainageAmount Decimal
UnpostedSalesTaxAmountCurrency String
UnpostedSalesTaxAmount Decimal
UnpostedTaxAmountCurrency String
UnpostedTaxAmount Decimal
UnpostedTotalCostCurrency String
UnpostedTotalCost Decimal
UnpostedLossAmountCurrency String
UnpostedLossAmount Decimal
UnpostedBilledRetentionAmountCurrency String
UnpostedBilledRetentionAmount Decimal
UnpostedCostOfEarningsAmountCurrency String
UnpostedCostOfEarningsAmount Decimal
UnpostedEarningsAmountCurrency String
UnpostedEarningsAmount Decimal
UnpostedPOCostsCurrency String
UnpostedPOCosts Decimal
UnpostedPOQuantity Decimal
UnpostedProjectFeeAmountCurrency String
UnpostedProjectFeeAmount Decimal
UnpostedReceiptsAmountCurrency String
UnpostedReceiptsAmount Decimal
UnpostedRetainerFeeAmountCurrency String
UnpostedRetainerFeeAmount Decimal
UnpostedRetentionAmountCurrency String
UnpostedRetentionAmount Decimal
UnpostedServiceFeeAmountCurrency String
UnpostedServiceFeeAmount Decimal
UserDefined1 String
UserDefined2 String
WriteUpDownAmountCurrency String
WriteUpDownAmount Decimal
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ProjectContractAccounts

Return a list of: ProjectContractAccounts

Columns
Name Type Description
ExtensionsExtensionAggregate String
AccountingMethod String
AccountsExtensionsExtensionAggregate String
AccountsGLAccountId String
AccountsGLAccountKeyIsEncrypted Bool
AccountsKeyCostTransaction [KEY] String
AccountsKeyDistributionTypeId [KEY] Int
AccountsKeyProjectContractId [KEY] String
AccountsKeySourceFile [KEY] String
ActualAccruedRevenueAmountCurrency String
ActualAccruedRevenueAmount Decimal
ActualBillingAmountCurrency String
ActualBillingAmount Decimal
ActualBillingsInExcessOfEarningsAmountCurrency String
ActualBillingsInExcessOfEarningsAmount Decimal
ActualDiscountAmountCurrency String
ActualDiscountAmount Decimal
ActualEarningsInExcessOfBillingsAmountCurrency String
ActualEarningsInExcessOfBillingsAmount Decimal
ActualOverheadAmountCurrency String
ActualOverheadAmount Decimal
ActualProfitAmountCurrency String
ActualProfitAmount Decimal
ActualQuantity Decimal
ActualRecognizedRevenueAmountCurrency String
ActualRecognizedRevenueAmount Decimal
ActualRetainageAmountCurrency String
ActualRetainageAmount Decimal
ActualSalesTaxAmountCurrency String
ActualSalesTaxAmount Decimal
ActualTaxAmountCurrency String
ActualTaxAmount Decimal
ActualTotalCostCurrency String
ActualTotalCost Decimal
ActualBeginDate Datetime
ActualBilledRetentionAmountCurrency String
ActualBilledRetentionAmount Decimal
ActualCommittedPOCostCurrency String
ActualCommittedPOCost Decimal
ActualCommittedPOQuantity Decimal
ActualCommittedPOTaxAmountCurrency String
ActualCommittedPOTaxAmount Decimal
ActualCostOfEarningsAmountCurrency String
ActualCostOfEarningsAmount Decimal
ActualEarningsAmountCurrency String
ActualEarningsAmount Decimal
ActualEndDate Datetime
ActualLossAmountCurrency String
ActualLossAmount Decimal
ActualPOCostsCurrency String
ActualPOCosts Decimal
ActualPOQuantity Decimal
ActualProjectFeeAmountCurrency String
ActualProjectFeeAmount Decimal
ActualReceiptsAmountCurrency String
ActualReceiptsAmount Decimal
ActualRetainerFeeAmountCurrency String
ActualRetainerFeeAmount Decimal
ActualRetentionAmountCurrency String
ActualRetentionAmount Decimal
ActualServiceFeeAmountCurrency String
ActualServiceFeeAmount Decimal
AddressId String
BaselineBeginDate Datetime
BaselineBillableAmountCurrency String
BaselineBillableAmount Decimal
BaselineEndDate Datetime
BaselineOverheadCostCurrency String
BaselineOverheadCost Decimal
BaselineProfitAmountCurrency String
BaselineProfitAmount Decimal
BaselineQuantity Decimal
BaselineTaxAmountCurrency String
BaselineTaxAmount Decimal
BaselineTotalCostCurrency String
BaselineTotalCost Decimal
BillToAddressId String
BilledAccruedRevenueCurrency String
BilledAccruedRevenue Decimal
BilledCostCurrency String
BilledCost Decimal
BilledQuantity Decimal
BillingCyclesAggregate String
BusinessManagerId String
ClassId String
CloseToBillings String
CloseToProjectCosts String
CommissionBasedOn String
CommissionPercent Decimal
ContactPerson String
ContractManagerId String
CostCompletedPercent Decimal
CurrencyKeyISOCode String
CustomerId String
CustomerPONumber String
DefaultBillingFormat String
DiscountPercent Decimal
DoesCombineForRevenueRecognition Bool
ForecastBeginDate Datetime
ForecastBillableAmountCurrency String
ForecastBillableAmount Decimal
ForecastEndDate Datetime
ForecastOverheadCostCurrency String
ForecastOverheadCost Decimal
ForecastProfitAmountCurrency String
ForecastProfitAmount Decimal
ForecastQuantity Decimal
ForecastTaxAmountCurrency String
ForecastTaxAmount Decimal
ForecastTotalCostCurrency String
ForecastTotalCost Decimal
Id String
Name String
POCommittedCostsCurrency String
POCommittedCosts Decimal
POCommittedQuantity Decimal
ProjectAmountCurrency String
ProjectAmount Decimal
ProjectContractId String
ProjectFeeAmountCurrency String
ProjectFeeAmount Decimal
ProjectType String
QuantityCompletedPercent Decimal
RestrictToCustomerList Bool
RetainerAmountCurrency String
RetainerAmount Decimal
RetentionFeeAmountCurrency String
RetentionFeeAmount Decimal
SalesTerritoryId String
SalespersonId String
ServiceFeeAmountCurrency String
ServiceFeeAmount Decimal
Status String
TransactionalCurrencyKeyISOCode String
UnpostedAccruedRevenueAmountCurrency String
UnpostedAccruedRevenueAmount Decimal
UnpostedBillingAmountCurrency String
UnpostedBillingAmount Decimal
UnpostedBillingsInExcessOfEarningsAmountCurrency String
UnpostedBillingsInExcessOfEarningsAmount Decimal
UnpostedDiscountAmountCurrency String
UnpostedDiscountAmount Decimal
UnpostedEarningsInExcessOfBillingsAmountCurrency String
UnpostedEarningsInExcessOfBillingsAmount Decimal
UnpostedOverheadAmountCurrency String
UnpostedOverheadAmount Decimal
UnpostedProfitAmountCurrency String
UnpostedProfitAmount Decimal
UnpostedQuantity Decimal
UnpostedRecognizedRevenueAmountCurrency String
UnpostedRecognizedRevenueAmount Decimal
UnpostedRetainageAmountCurrency String
UnpostedRetainageAmount Decimal
UnpostedSalesTaxAmountCurrency String
UnpostedSalesTaxAmount Decimal
UnpostedTaxAmountCurrency String
UnpostedTaxAmount Decimal
UnpostedTotalCostCurrency String
UnpostedTotalCost Decimal
UnpostedLossAmountCurrency String
UnpostedLossAmount Decimal
UnpostedBilledRetentionAmountCurrency String
UnpostedBilledRetentionAmount Decimal
UnpostedCostOfEarningsAmountCurrency String
UnpostedCostOfEarningsAmount Decimal
UnpostedEarningsAmountCurrency String
UnpostedEarningsAmount Decimal
UnpostedPOCostsCurrency String
UnpostedPOCosts Decimal
UnpostedPOQuantity Decimal
UnpostedProjectFeeAmountCurrency String
UnpostedProjectFeeAmount Decimal
UnpostedReceiptsAmountCurrency String
UnpostedReceiptsAmount Decimal
UnpostedRetainerFeeAmountCurrency String
UnpostedRetainerFeeAmount Decimal
UnpostedRetentionAmountCurrency String
UnpostedRetentionAmount Decimal
UnpostedServiceFeeAmountCurrency String
UnpostedServiceFeeAmount Decimal
UserDefined1 String
UserDefined2 String
WriteUpDownAmountCurrency String
WriteUpDownAmount Decimal
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ProjectContractBillingCycles

Return a list of: ProjectContractBillingCycles

Columns
Name Type Description
ExtensionsExtensionAggregate String
AccountingMethod String
AccountsAggregate String
ActualAccruedRevenueAmountCurrency String
ActualAccruedRevenueAmount Decimal
ActualBillingAmountCurrency String
ActualBillingAmount Decimal
ActualBillingsInExcessOfEarningsAmountCurrency String
ActualBillingsInExcessOfEarningsAmount Decimal
ActualDiscountAmountCurrency String
ActualDiscountAmount Decimal
ActualEarningsInExcessOfBillingsAmountCurrency String
ActualEarningsInExcessOfBillingsAmount Decimal
ActualOverheadAmountCurrency String
ActualOverheadAmount Decimal
ActualProfitAmountCurrency String
ActualProfitAmount Decimal
ActualQuantity Decimal
ActualRecognizedRevenueAmountCurrency String
ActualRecognizedRevenueAmount Decimal
ActualRetainageAmountCurrency String
ActualRetainageAmount Decimal
ActualSalesTaxAmountCurrency String
ActualSalesTaxAmount Decimal
ActualTaxAmountCurrency String
ActualTaxAmount Decimal
ActualTotalCostCurrency String
ActualTotalCost Decimal
ActualBeginDate Datetime
ActualBilledRetentionAmountCurrency String
ActualBilledRetentionAmount Decimal
ActualCommittedPOCostCurrency String
ActualCommittedPOCost Decimal
ActualCommittedPOQuantity Decimal
ActualCommittedPOTaxAmountCurrency String
ActualCommittedPOTaxAmount Decimal
ActualCostOfEarningsAmountCurrency String
ActualCostOfEarningsAmount Decimal
ActualEarningsAmountCurrency String
ActualEarningsAmount Decimal
ActualEndDate Datetime
ActualLossAmountCurrency String
ActualLossAmount Decimal
ActualPOCostsCurrency String
ActualPOCosts Decimal
ActualPOQuantity Decimal
ActualProjectFeeAmountCurrency String
ActualProjectFeeAmount Decimal
ActualReceiptsAmountCurrency String
ActualReceiptsAmount Decimal
ActualRetainerFeeAmountCurrency String
ActualRetainerFeeAmount Decimal
ActualRetentionAmountCurrency String
ActualRetentionAmount Decimal
ActualServiceFeeAmountCurrency String
ActualServiceFeeAmount Decimal
AddressId String
BaselineBeginDate Datetime
BaselineBillableAmountCurrency String
BaselineBillableAmount Decimal
BaselineEndDate Datetime
BaselineOverheadCostCurrency String
BaselineOverheadCost Decimal
BaselineProfitAmountCurrency String
BaselineProfitAmount Decimal
BaselineQuantity Decimal
BaselineTaxAmountCurrency String
BaselineTaxAmount Decimal
BaselineTotalCostCurrency String
BaselineTotalCost Decimal
BillToAddressId String
BilledAccruedRevenueCurrency String
BilledAccruedRevenue Decimal
BilledCostCurrency String
BilledCost Decimal
BilledQuantity Decimal
BillingCyclesExtensionsExtensionAggregate String
BillingCyclesBillingFormat String
BillingCyclesId [KEY] String
BillingCyclesKeyProjectContractId [KEY] String
BusinessManagerId String
ClassId String
CloseToBillings String
CloseToProjectCosts String
CommissionBasedOn String
CommissionPercent Decimal
ContactPerson String
ContractManagerId String
CostCompletedPercent Decimal
CurrencyKeyISOCode String
CustomerId String
CustomerPONumber String
DefaultBillingFormat String
DiscountPercent Decimal
DoesCombineForRevenueRecognition Bool
ForecastBeginDate Datetime
ForecastBillableAmountCurrency String
ForecastBillableAmount Decimal
ForecastEndDate Datetime
ForecastOverheadCostCurrency String
ForecastOverheadCost Decimal
ForecastProfitAmountCurrency String
ForecastProfitAmount Decimal
ForecastQuantity Decimal
ForecastTaxAmountCurrency String
ForecastTaxAmount Decimal
ForecastTotalCostCurrency String
ForecastTotalCost Decimal
Id String
Name String
POCommittedCostsCurrency String
POCommittedCosts Decimal
POCommittedQuantity Decimal
ProjectAmountCurrency String
ProjectAmount Decimal
ProjectContractId String
ProjectFeeAmountCurrency String
ProjectFeeAmount Decimal
ProjectType String
QuantityCompletedPercent Decimal
RestrictToCustomerList Bool
RetainerAmountCurrency String
RetainerAmount Decimal
RetentionFeeAmountCurrency String
RetentionFeeAmount Decimal
SalesTerritoryId String
SalespersonId String
ServiceFeeAmountCurrency String
ServiceFeeAmount Decimal
Status String
TransactionalCurrencyKeyISOCode String
UnpostedAccruedRevenueAmountCurrency String
UnpostedAccruedRevenueAmount Decimal
UnpostedBillingAmountCurrency String
UnpostedBillingAmount Decimal
UnpostedBillingsInExcessOfEarningsAmountCurrency String
UnpostedBillingsInExcessOfEarningsAmount Decimal
UnpostedDiscountAmountCurrency String
UnpostedDiscountAmount Decimal
UnpostedEarningsInExcessOfBillingsAmountCurrency String
UnpostedEarningsInExcessOfBillingsAmount Decimal
UnpostedOverheadAmountCurrency String
UnpostedOverheadAmount Decimal
UnpostedProfitAmountCurrency String
UnpostedProfitAmount Decimal
UnpostedQuantity Decimal
UnpostedRecognizedRevenueAmountCurrency String
UnpostedRecognizedRevenueAmount Decimal
UnpostedRetainageAmountCurrency String
UnpostedRetainageAmount Decimal
UnpostedSalesTaxAmountCurrency String
UnpostedSalesTaxAmount Decimal
UnpostedTaxAmountCurrency String
UnpostedTaxAmount Decimal
UnpostedTotalCostCurrency String
UnpostedTotalCost Decimal
UnpostedLossAmountCurrency String
UnpostedLossAmount Decimal
UnpostedBilledRetentionAmountCurrency String
UnpostedBilledRetentionAmount Decimal
UnpostedCostOfEarningsAmountCurrency String
UnpostedCostOfEarningsAmount Decimal
UnpostedEarningsAmountCurrency String
UnpostedEarningsAmount Decimal
UnpostedPOCostsCurrency String
UnpostedPOCosts Decimal
UnpostedPOQuantity Decimal
UnpostedProjectFeeAmountCurrency String
UnpostedProjectFeeAmount Decimal
UnpostedReceiptsAmountCurrency String
UnpostedReceiptsAmount Decimal
UnpostedRetainerFeeAmountCurrency String
UnpostedRetainerFeeAmount Decimal
UnpostedRetentionAmountCurrency String
UnpostedRetentionAmount Decimal
UnpostedServiceFeeAmountCurrency String
UnpostedServiceFeeAmount Decimal
UserDefined1 String
UserDefined2 String
WriteUpDownAmountCurrency String
WriteUpDownAmount Decimal
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ProjectEmployeeExpense

Return a list of: ProjectEmployeeExpense

Columns
Name Type Description
ExtensionsExtensionAggregate String
AuditTrailCode String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
Comment String
CreatedBy String
CreatedDate Datetime
CurrencyKeyISOCode String
Date Datetime
ExchangeDate Datetime
ExchangeRate Decimal
GeneralLedgerPostingDate Datetime
OriginalDocumentId String
PostedBy String
PostedDate Datetime
ReferenceDocumentNumber String
ReportSuffix String
TotalAccruedRevenueCurrency String
TotalAccruedRevenue Decimal
TotalCostCurrency String
TotalCost Decimal
TotalQuantity Decimal
TransactionState String
TransactionType String
UserDefined1 String
UserDefined2 String
UserId String
AddressId String
Amount1099Currency String
Amount1099 Decimal
ChargeAmountCurrency String
ChargeAmount Decimal
DistributionsAggregate String
DocumentAmountCurrency String
DocumentAmount Decimal
DoesPostToPayablesManagement Bool
EmployeeId String
EndDate Datetime
ExtendedCostCurrency String
ExtendedCost Decimal
FreightAmountCurrency String
FreightAmount Decimal
FreightTaxAmountCurrency String
FreightTaxAmount Decimal
FreightTaxBasis String
FreightTaxScheduleId String
IsTaxInvoiceReceived Bool
IsTaxInvoiceRequired Bool
Id [KEY] String
LinesAggregate String
MiscellaneousAmountCurrency String
MiscellaneousAmount Decimal
MiscellaneousTaxAmountCurrency String
MiscellaneousTaxAmount Decimal
MiscellaneousTaxBasis String
MiscellaneousTaxScheduleId String
PaymentCashAmountCurrency String
PaymentCashAmount Decimal
PaymentCashBankAccountId String
PaymentCashDate Datetime
PaymentCashNumber String
PaymentCashDocumentNumber String
PaymentCheckAmountCurrency String
PaymentCheckAmount Decimal
PaymentCheckBankAccountId String
PaymentCheckCheckNumber String
PaymentCheckDate Datetime
PaymentCheckNumber String
PaymentPaymentCardAmountCurrency String
PaymentPaymentCardAmount Decimal
PaymentPaymentCardDate Datetime
PaymentPaymentCardNumber String
PaymentPaymentCardReceiptNumber String
PaymentPaymentCardTypeId String
PaymentTermsId String
PersonalDataKeeperEmployeeId String
ReimbursableAmountCurrency String
ReimbursableAmount Decimal
ReimbursableTaxCurrency String
ReimbursableTax Decimal
ShippingMethodId String
StartDate Datetime
TaxAmountCurrency String
TaxAmount Decimal
TaxDate Datetime
TaxScheduleId String
TradeDiscountAmountCurrency String
TradeDiscountAmount Decimal
Unapplied1099AmountCurrency String
Unapplied1099Amount Decimal
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ProjectEmployeeExpenseDistributions

Return a list of: ProjectEmployeeExpenseDistributions

Columns
Name Type Description
ExtensionsExtensionAggregate String
AuditTrailCode String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
Comment String
CreatedBy String
CreatedDate Datetime
CurrencyKeyISOCode String
Date Datetime
ExchangeDate Datetime
ExchangeRate Decimal
GeneralLedgerPostingDate Datetime
OriginalDocumentId String
PostedBy String
PostedDate Datetime
ReferenceDocumentNumber String
ReportSuffix String
TotalAccruedRevenueCurrency String
TotalAccruedRevenue Decimal
TotalCostCurrency String
TotalCost Decimal
TotalQuantity Decimal
TransactionState String
TransactionType String
UserDefined1 String
UserDefined2 String
UserId String
AddressId String
Amount1099Currency String
Amount1099 Decimal
ChargeAmountCurrency String
ChargeAmount Decimal
DistributionsExtensionsExtensionAggregate String
DistributionsAuditTrailCode String
DistributionsCreditAmountCurrency String
DistributionsCreditAmount Decimal
DistributionsDebitAmountCurrency String
DistributionsDebitAmount Decimal
DistributionsDistributionTypeId Int
DistributionsGLAccountId String
DistributionsGLAccountKeyIsEncrypted Bool
DistributionsReference String
DistributionsKeyControlType [KEY] Int
DistributionsKeyProjectEmployeeExpenseId [KEY] String
DistributionsKeySequenceNumber [KEY] Int
DocumentAmountCurrency String
DocumentAmount Decimal
DoesPostToPayablesManagement Bool
EmployeeId String
EndDate Datetime
ExtendedCostCurrency String
ExtendedCost Decimal
FreightAmountCurrency String
FreightAmount Decimal
FreightTaxAmountCurrency String
FreightTaxAmount Decimal
FreightTaxBasis String
FreightTaxScheduleId String
IsTaxInvoiceReceived Bool
IsTaxInvoiceRequired Bool
Id String
LinesAggregate String
MiscellaneousAmountCurrency String
MiscellaneousAmount Decimal
MiscellaneousTaxAmountCurrency String
MiscellaneousTaxAmount Decimal
MiscellaneousTaxBasis String
MiscellaneousTaxScheduleId String
PaymentCashAmountCurrency String
PaymentCashAmount Decimal
PaymentCashBankAccountId String
PaymentCashDate Datetime
PaymentCashNumber String
PaymentCashDocumentNumber String
PaymentCheckAmountCurrency String
PaymentCheckAmount Decimal
PaymentCheckBankAccountId String
PaymentCheckCheckNumber String
PaymentCheckDate Datetime
PaymentCheckNumber String
PaymentPaymentCardAmountCurrency String
PaymentPaymentCardAmount Decimal
PaymentPaymentCardDate Datetime
PaymentPaymentCardNumber String
PaymentPaymentCardReceiptNumber String
PaymentPaymentCardTypeId String
PaymentTermsId String
PersonalDataKeeperEmployeeId String
ReimbursableAmountCurrency String
ReimbursableAmount Decimal
ReimbursableTaxCurrency String
ReimbursableTax Decimal
ShippingMethodId String
StartDate Datetime
TaxAmountCurrency String
TaxAmount Decimal
TaxDate Datetime
TaxScheduleId String
TradeDiscountAmountCurrency String
TradeDiscountAmount Decimal
Unapplied1099AmountCurrency String
Unapplied1099Amount Decimal
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ProjectEmployeeExpenseLines

Return a list of: ProjectEmployeeExpenseLines

Columns
Name Type Description
ExtensionsExtensionAggregate String
AuditTrailCode String
BatchKeyCreatedDateTime Datetime
BatchId String
BatchKeySource String
Comment String
CreatedBy String
CreatedDate Datetime
CurrencyKeyISOCode String
Date Datetime
ExchangeDate Datetime
ExchangeRate Decimal
GeneralLedgerPostingDate Datetime
OriginalDocumentId String
PostedBy String
PostedDate Datetime
ReferenceDocumentNumber String
ReportSuffix String
TotalAccruedRevenueCurrency String
TotalAccruedRevenue Decimal
TotalCostCurrency String
TotalCost Decimal
TotalQuantity Decimal
TransactionState String
TransactionType String
UserDefined1 String
UserDefined2 String
UserId String
AddressId String
Amount1099Currency String
Amount1099 Decimal
ChargeAmountCurrency String
ChargeAmount Decimal
DistributionsAggregate String
DocumentAmountCurrency String
DocumentAmount Decimal
DoesPostToPayablesManagement Bool
EmployeeId String
EndDate Datetime
ExtendedCostCurrency String
ExtendedCost Decimal
FreightAmountCurrency String
FreightAmount Decimal
FreightTaxAmountCurrency String
FreightTaxAmount Decimal
FreightTaxBasis String
FreightTaxScheduleId String
IsTaxInvoiceReceived Bool
IsTaxInvoiceRequired Bool
Id String
LinesExtensionsExtensionAggregate String
LinesAccruedRevenueCurrency String
LinesAccruedRevenue Decimal
LinesContraGLAccountId String
LinesContraGLAccountKeyIsEncrypted Bool
LinesCostCategoryId String
LinesCostOfGoodsSoldGLAccountId String
LinesCostOfGoodsSoldGLAccountKeyIsEncrypted Bool
LinesDate Datetime
LinesExtendedCostCurrency String
LinesExtendedCost Decimal
LinesMarkupPercent Decimal
LinesOriginalDocumentSequenceNumber Int
LinesOverheadAmountCurrency String
LinesOverheadAmount Decimal
LinesOverheadGLAccountId String
LinesOverheadGLAccountKeyIsEncrypted Bool
LinesOverheadPercent Decimal
LinesProfitAmountCurrency String
LinesProfitAmount Decimal
LinesProfitType String
LinesProjectContractId String
LinesProjectId String
LinesQuantity Decimal
LinesReferenceDocumentSequenceNumber Int
LinesRoundAmountCurrency String
LinesRoundAmount Decimal
LinesRoundingGLAccountId String
LinesRoundingGLAccountKeyIsEncrypted Bool
LinesTotalCostCurrency String
LinesTotalCost Decimal
LinesTotalOverheadAmountCurrency String
LinesTotalOverheadAmount Decimal
LinesTotalProfitAmountCurrency String
LinesTotalProfitAmount Decimal
LinesUnbilledAccountReceivableGLAccountId String
LinesUnbilledAccountReceivableGLAccountKeyIsEncrypted Bool
LinesUnbilledProjectRevenueGLAccountId String
LinesUnbilledProjectRevenueGLAccountKeyIsEncrypted Bool
LinesUnitCostCurrency String
LinesUnitCost Decimal
LinesUofM String
LinesWorkInProgressGLAccountId String
LinesWorkInProgressGLAccountKeyIsEncrypted Bool
LinesBackoutTaxAmountCurrency String
LinesBackoutTaxAmount Decimal
LinesBillingAmountCurrency String
LinesBillingAmount Decimal
LinesBillingProfitAmountCurrency String
LinesBillingProfitAmount Decimal
LinesBillingProfitPercent Decimal
LinesBillingQuantity Decimal
LinesBillingRateCurrency String
LinesBillingRate Decimal
LinesBillingStatus String
LinesBillingTaxAmountCurrency String
LinesBillingTaxAmount Decimal
LinesBillingType String
LinesDescription String
LinesExpenseType String
LinesKeyProjectEmployeeExpenseId [KEY] String
LinesKeySequenceNumber [KEY] Int
LinesPaymentMethodType String
LinesReimbursableAmountCurrency String
LinesReimbursableAmount Decimal
LinesTaxAmountCurrency String
LinesTaxAmount Decimal
LinesTaxBasis String
LinesTaxScheduleId String
LinesTaxesAggregate String
MiscellaneousAmountCurrency String
MiscellaneousAmount Decimal
MiscellaneousTaxAmountCurrency String
MiscellaneousTaxAmount Decimal
MiscellaneousTaxBasis String
MiscellaneousTaxScheduleId String
PaymentCashAmountCurrency String
PaymentCashAmount Decimal
PaymentCashBankAccountId String
PaymentCashDate Datetime
PaymentCashNumber String
PaymentCashDocumentNumber String
PaymentCheckAmountCurrency String
PaymentCheckAmount Decimal
PaymentCheckBankAccountId String
PaymentCheckCheckNumber String
PaymentCheckDate Datetime
PaymentCheckNumber String
PaymentPaymentCardAmountCurrency String
PaymentPaymentCardAmount Decimal
PaymentPaymentCardDate Datetime
PaymentPaymentCardNumber String
PaymentPaymentCardReceiptNumber String
PaymentPaymentCardTypeId String
PaymentTermsId String
PersonalDataKeeperEmployeeId String
ReimbursableAmountCurrency String
ReimbursableAmount Decimal
ReimbursableTaxCurrency String
ReimbursableTax Decimal
ShippingMethodId String
StartDate Datetime
TaxAmountCurrency String
TaxAmount Decimal
TaxDate Datetime
TaxScheduleId String
TradeDiscountAmountCurrency String
TradeDiscountAmount Decimal
Unapplied1099AmountCurrency String
Unapplied1099Amount Decimal
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ProjectEquipmentList

Return a list of: ProjectEquipmentList

Columns
Name Type Description
ExtensionsExtensionAggregate String
AccountAmountCurrency String
AccountAmount Decimal
AccountingMethod String
AccountsAggregate String
ActualAccruedRevenueAmountCurrency String
ActualAccruedRevenueAmount Decimal
ActualBillingAmountCurrency String
ActualBillingAmount Decimal
ActualBillingsInExcessOfEarningsAmountCurrency String
ActualBillingsInExcessOfEarningsAmount Decimal
ActualDiscountAmountCurrency String
ActualDiscountAmount Decimal
ActualEarningsInExcessOfBillingsAmountCurrency String
ActualEarningsInExcessOfBillingsAmount Decimal
ActualOverheadAmountCurrency String
ActualOverheadAmount Decimal
ActualProfitAmountCurrency String
ActualProfitAmount Decimal
ActualQuantity Decimal
ActualRecognizedRevenueAmountCurrency String
ActualRecognizedRevenueAmount Decimal
ActualRetainageAmountCurrency String
ActualRetainageAmount Decimal
ActualSalesTaxAmountCurrency String
ActualSalesTaxAmount Decimal
ActualTaxAmountCurrency String
ActualTaxAmount Decimal
ActualTotalCostCurrency String
ActualTotalCost Decimal
ActualBeginDate Datetime
ActualEndDate Datetime
BaselineBeginDate Datetime
BaselineBillableAmountCurrency String
BaselineBillableAmount Decimal
BaselineEndDate Datetime
BaselineOverheadCostCurrency String
BaselineOverheadCost Decimal
BaselineProfitAmountCurrency String
BaselineProfitAmount Decimal
BaselineQuantity Decimal
BaselineTaxAmountCurrency String
BaselineTaxAmount Decimal
BaselineTotalCostCurrency String
BaselineTotalCost Decimal
BillToAddressId String
BilledAccruedRevenueCurrency String
BilledAccruedRevenue Decimal
BilledCostCurrency String
BilledCost Decimal
BilledQuantity Decimal
BillingCyclesAggregate String
BillingNotReceivableCurrency String
BillingNotReceivable Decimal
BillingType String
BudgetsAggregate String
BusinessManagerId String
CloseToBillings Bool
CloseToProjectCosts Bool
CommissionBasedOn String
CommissionPercent Decimal
ContactPerson String
CostCompletedPercent Decimal
CurrencyKeyISOCode String
CustomerId String
CustomerPONumber String
DefaultBillingFormat String
DepartmentId String
DiscountPercent Decimal
DoesAcceptEquipmentRateTableReplacement Bool
DoesAcceptLaborRateTableReplacement Bool
DoesCombineForRevenueRecognition Bool
EquipmentListExtensionsExtensionAggregate String
EquipmentListKeyProjectEquipmentId [KEY] String
EquipmentListKeyProjectId [KEY] String
EquipmentRateTableId String
EstimatorId String
FeesAggregate String
ForecastBeginDate Datetime
ForecastBillableAmountCurrency String
ForecastBillableAmount Decimal
ForecastEndDate Datetime
ForecastOverheadCostCurrency String
ForecastOverheadCost Decimal
ForecastProfitAmountCurrency String
ForecastProfitAmount Decimal
ForecastQuantity Decimal
ForecastTaxAmountCurrency String
ForecastTaxAmount Decimal
ForecastTotalCostCurrency String
ForecastTotalCost Decimal
Id String
LaborRateTableId String
LaborRateTableType String
Name String
POCommittedCostsCurrency String
POCommittedCosts Decimal
POCommittedQuantity Decimal
PostedAccruedRevenueAmountCurrency String
PostedAccruedRevenueAmount Decimal
PostedBillingAmountCurrency String
PostedBillingAmount Decimal
PostedBillingsInExcessOfEarningsAmountCurrency String
PostedBillingsInExcessOfEarningsAmount Decimal
PostedDiscountAmountCurrency String
PostedDiscountAmount Decimal
PostedEarningsInExcessOfBillingsAmountCurrency String
PostedEarningsInExcessOfBillingsAmount Decimal
PostedOverheadAmountCurrency String
PostedOverheadAmount Decimal
PostedProfitAmountCurrency String
PostedProfitAmount Decimal
PostedQuantity Decimal
PostedRecognizedRevenueAmountCurrency String
PostedRecognizedRevenueAmount Decimal
PostedRetainageAmountCurrency String
PostedRetainageAmount Decimal
PostedSalesTaxAmountCurrency String
PostedSalesTaxAmount Decimal
PostedTaxAmountCurrency String
PostedTaxAmount Decimal
PostedTotalCostCurrency String
PostedTotalCost Decimal
PostedEarningsAmountCurrency String
PostedEarningsAmount Decimal
PostedPOCostsCurrency String
PostedPOCosts Decimal
PostedPOQuantity Decimal
PostedBilledRetentionAmountCurrency String
PostedBilledRetentionAmount Decimal
PostedCostOfEarningsAmountCurrency String
PostedCostOfEarningsAmount Decimal
PostedLossAmountCurrency String
PostedLossAmount Decimal
PostedProjectFeeAmountCurrency String
PostedProjectFeeAmount Decimal
PostedReceiptsAmountCurrency String
PostedReceiptsAmount Decimal
PostedRetainerFeeAmountCurrency String
PostedRetainerFeeAmount Decimal
PostedRetentionAmountCurrency String
PostedRetentionAmount Decimal
PostedServiceFeeAmountCurrency String
PostedServiceFeeAmount Decimal
PostedWriteoffAmountCurrency String
PostedWriteoffAmount Decimal
ProjectAmountCurrency String
ProjectAmount Decimal
ProjectClassId String
ProjectContractId String
ProjectContractId String
ProjectFeeAmountCurrency String
ProjectFeeAmount Decimal
ProjectId String
ProjectManagerId String
QuantityCompletedPercent Decimal
RestrictToCustomerList Bool
RetainerAmountCurrency String
RetainerAmount Decimal
RetentionFeeAmountCurrency String
RetentionFeeAmount Decimal
RetentionPercent Decimal
SUTAState String
SalesTerritoryId String
SalespersonId String
ServiceFeeAmountCurrency String
ServiceFeeAmount Decimal
Status String
TransactionalCurrencyCodeKeyISOCode String
Type String
UnpostedAccruedRevenueAmountCurrency String
UnpostedAccruedRevenueAmount Decimal
UnpostedBillingAmountCurrency String
UnpostedBillingAmount Decimal
UnpostedBillingsInExcessOfEarningsAmountCurrency String
UnpostedBillingsInExcessOfEarningsAmount Decimal
UnpostedDiscountAmountCurrency String
UnpostedDiscountAmount Decimal
UnpostedEarningsInExcessOfBillingsAmountCurrency String
UnpostedEarningsInExcessOfBillingsAmount Decimal
UnpostedOverheadAmountCurrency String
UnpostedOverheadAmount Decimal
UnpostedProfitAmountCurrency String
UnpostedProfitAmount Decimal
UnpostedQuantity Decimal
UnpostedRecognizedRevenueAmountCurrency String
UnpostedRecognizedRevenueAmount Decimal
UnpostedRetainageAmountCurrency String
UnpostedRetainageAmount Decimal
UnpostedSalesTaxAmountCurrency String
UnpostedSalesTaxAmount Decimal
UnpostedTaxAmountCurrency String
UnpostedTaxAmount Decimal
UnpostedTotalCostCurrency String
UnpostedTotalCost Decimal
UnpostedLossAmountCurrency String
UnpostedLossAmount Decimal
UnpostedBilledRetentionAmountCurrency String
UnpostedBilledRetentionAmount Decimal
UnpostedCostOfEarningsAmountCurrency String
UnpostedCostOfEarningsAmount Decimal
UnpostedEarningsAmountCurrency String
UnpostedEarningsAmount Decimal
UnpostedPOCostsCurrency String
UnpostedPOCosts Decimal
UnpostedPOQuantity Decimal
UnpostedProjectFeeAmountCurrency String
UnpostedProjectFeeAmount Decimal
UnpostedReceiptsAmountCurrency String
UnpostedReceiptsAmount Decimal
UnpostedRetainerFeeAmountCurrency String
UnpostedRetainerFeeAmount Decimal
UnpostedRetentionAmountCurrency String
UnpostedRetentionAmount Decimal
UnpostedServiceFeeAmountCurrency String
UnpostedServiceFeeAmount Decimal
UserDefinedText1 String
UserDefinedText2 String
WorkersCompensationId String
WriteUpDownAmountCurrency String
WriteUpDownAmount Decimal
Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

ProjectFees

Return a list of: ProjectFees

Columns
Name Type Description
ExtensionsExtensionAggregate String
AccountAmountCurrency String
AccountAmount Decimal
AccountingMethod String
AccountsAggregate String
ActualAccruedRevenueAmountCurrency String
ActualAccruedRevenueAmount Decimal
ActualBillingAmountCurrency String
ActualBillingAmount Decimal
ActualBillingsInExcessOfEarningsAmountCurrency String
ActualBillingsInExcessOfEarningsAmount Decimal
ActualDiscountAmountCurrency String
ActualDiscountAmount Decimal
ActualEarningsInExcessOfBillingsAmountCurrency String
ActualEarningsInExcessOfBillingsAmount Decimal
ActualOverheadAmountCurrency String
ActualOverheadAmount Decimal
ActualProfitAmountCurrency String
ActualProfitAmount Decimal
ActualQuantity Decimal
ActualRecognizedRevenueAmountCurrency String
ActualRecognizedRevenueAmount Decimal
ActualRetainageAmountCurrency String
ActualRetainageAmount Decimal
ActualSalesTaxAmountCurrency String
ActualSalesTaxAmount Decimal
ActualTaxAmountCurrency String
ActualTaxAmount Decimal
ActualTotalCostCurrency String
ActualTotalCost Decimal
ActualBeginDate Datetime
ActualEndDate Datetime
BaselineBeginDate Datetime
BaselineBillableAmountCurrency String
BaselineBillableAmount Decimal
BaselineEndDate Datetime
BaselineOverheadCostCurrency String
BaselineOverheadCost Decimal
BaselineProfitAmountCurrency String
BaselineProfitAmount Decimal
BaselineQuantity Decimal
BaselineTaxAmountCurrency String
BaselineTaxAmount Decimal
BaselineTotalCostCurrency String
BaselineTotalCost Decimal
BillToAddressId String
BilledAccruedRevenueCurrency String
BilledAccruedRevenue Decimal
BilledCostCurrency String
BilledCost Decimal
BilledQuantity Decimal
BillingCyclesAggregate String
BillingNotReceivableCurrency String
BillingNotReceivable Decimal
BillingType String
BudgetsAggregate String
BusinessManagerId String
CloseToBillings Bool
CloseToProjectCosts Bool
CommissionBasedOn String
CommissionPercent Decimal
ContactPerson String
CostC