Transaction

Transaction

53 columns Fetched February 27, 2026

Related Reports

Time 6 shared Expense 5 shared Invoice Time 5 shared Invoice Expense 4 shared Invoice Header 4 shared

n8n

Columns

GL_Entry_RecID Numeric
Also in 3 reports
Unposted Expense Unposted Invoice Unposted Procurement
GL_BatchID Text nullable
GL_BatchID_RecID Numeric nullable
Billing_Log_RecID Numeric
Also in 12 reports
Agreement Invoice Expense Invoice Agreement Additions Invoice Custom Fields Invoice Expense Invoice Header Invoice Payments Invoice Product Invoice Time Invoices Portal Invoices Time
Invoice_Number Text nullable
Owner_Level_RecID Numeric nullable
Also in 48 reports
Accounts Receivable Aging Agr Type Billing Setup Billing Unit Location Charge Code Company Company Team Company Work Roles Company Work Types Configs Configuration Contacts Expense Invoice Header Invoice Time Invoices Kb Resolution Audit Trail Knowledgebase Category Knowledgebase Sub Category Location Bus Group Marketing Campaign Member Owner Level Portal Agr Type Portal Invoices Portal Project Portal Ticket Types Price Header Pricing Schedule Project Header Purchase Order Purchase Order Template Sales Commission Service Board Service Code Service Item Service Status Service Sub Type Service Team Service Type Time Unposted Expense Unposted Invoice Unposted Procurement User Defined Field Owner Levels Warehouse Warehouse Bin Work Roles Location
Table_Reference Text nullable
GL_Type_ID Text
GL_Description Text nullable
GL_Account Text nullable
DR_Amount Numeric nullable
CR_Amount Numeric nullable
Balance Text nullable
Item_Taxable_Flag Boolean
iv_product_recid Numeric nullable
product_desc Text nullable
Quantity Numeric
Packing_Slip Text nullable
Taxable_Flag Boolean nullable
Taxable2_Flag Boolean nullable
Taxable3_Flag Boolean nullable
Taxable4_Flag Boolean nullable
Taxable5_Flag Boolean nullable
Taxable6_Flag Boolean nullable
SR_Service_RecID Numeric nullable
Also in 21 reports
Document Expense Invoice Expense Invoice Product Invoice Time Project Schedule Screen Connect Session Service Service Custom Fields Service Metrics Aging Service Metrics Counts Service Note Service Task Service Open Service SLA Service Summary Service Summary Open Surveys By Ticket Ticket Audit Time
Service_Summary Text nullable
PM_Project_RecID Numeric nullable
Also in 16 reports
Document Expense Invoice Expense Invoice Header Invoice Product Invoice Time Invoices Portal Invoices Project Project Audit Project Contact Project Custom Fields Project Header Project Note Project Team Member Time
Project_ID Text nullable
PM_Phase_RecID Numeric nullable
Also in 9 reports
Expense Invoice Expense Invoice Header Invoices Project Service Service Open Service Summary Service Summary Open
PM_Phase_Desc Text nullable
EX_Type_RecID Numeric nullable
Also in 1 report
Expense Type
Ex_Type_Desc Text nullable
Time_RecID Numeric nullable
Also in 5 reports
Document Invoice Time Time Time Audit Time Entry Custom Fields
Notes Text nullable
SO_Activity_RecID Numeric nullable
Also in 2 reports
Activity Custom Fields Time
Activity_Summary Text nullable
Segment1 Text nullable
Segment2 Text nullable
Segment3 Text nullable
Segment4 Text nullable
Segment5 Text nullable
Segment6 Text nullable
Segment7 Text nullable
Segment8 Text nullable
Segment9 Text nullable
Segment10 Text nullable
GL_Cost Numeric nullable
GL_Item Text nullable
GL_Inventory Text nullable
GL_SalesCode Text nullable
GL_COGS Text nullable
Updated_By Text
Last_Update DateTime