Attributes for Invoice Approval Rules
This is an exhaustive list of all the attributes you need to create Invoice Approval rules.
Invoice Header
Attribute Name | Attribute Type |
---|---|
Account Coding Status | String |
Amount Applicable for Discount Calculation | Big Decimal |
Amount Due to Credit Card Company | Big Decimal |
Amount Due to Employee | Big Decimal |
Approval Description | String |
Approval Iteration | Integer |
Approval Status | String |
Approval Status Lookup Code | String |
Approved Amount | Big Decimal |
Attribute Category | String |
Automatic Numbering | String |
Available Prepayments | String |
Bank Charge Bearer | String |
Base Amount | Big Decimal |
Batch Name | String |
Business Unit ID | Long |
Business Unit Name | String |
Canceled Amount | Big Decimal |
Canceled By | String |
Canceled Date | XML Gregorian Calendar |
Check Vat Amount Paid | String |
Control Amount | Big Decimal |
Conversion Date | XML Gregorian Calendar |
Conversion Rate | Big Decimal |
Conversion Rate Name | Big Decimal |
Conversion Rate Type | String |
Correction Period | String |
Correction Year | Integer |
Created By | String |
Creation Date | XML Gregorian Calendar |
Creator ID | Big Decimal |
Customer Registration Code | String |
Customer Registration Number | String |
Delivery Channel Code | String |
Description | String |
Descriptive Flexfield Attribute 1-15 | String |
Discount Amount Taken | Big Decimal |
Displayed Voucher Number | String |
Distribution Set Name | String |
Document Category Code | String |
Document Category Name | String |
Document Sequence Value | Long |
Document Sub Type | String |
Document Sub Type Name | String |
Earliest Settlement Date | XML Gregorian Calendar |
Encumbered Indicator | String |
Exclude Freight from Discount | String |
First Party Tax Registration Number | String |
Force Revalidation Indicator | String |
Freight Amount | Big Decimal |
GL Date | XML Gregorian Calendar |
Global Attribute Category | String |
Global Descriptive Flexfield 1-20 | String |
Goods Received Date | XML Gregorian Calendar |
Import Document Date | XML Gregorian Calendar |
Import Document Number | String |
Intercompany Indicator | String |
Internal Contact Email | String |
Inverse Conversion Rate | Big Decimal |
Invoice Amount | Big Decimal |
Invoice Amount Limit | Big Decimal |
Invoice Canceled | String |
Invoice Currency Code | String |
Invoice Date | XML Gregorian Calendar |
Invoice Line Total | Big Decimal |
Invoice Number | String |
Invoice Received Date | XML Gregorian Calendar |
Invoice Saved In Database | Boolean |
Invoice Type Lookup Code | String |
Is Line Updatable | String |
Is Matched | Boolean |
Last Updated By | String |
Last Updated Date | XML Gregorian Calendar |
Last Updated Login | String |
Ledger ID | Long |
Legal Entity ID | Long |
Legal Entity Name | String |
MRC Base Amount | String |
MRC Exchange Date | String |
MRC Exchange Rate | String |
MRC Exchange Rate Type | String |
MRC Posting Status | String |
Need Tax Synchronization | String |
Net of Retainage Account Indicator | String |
Notes Source Type | String |
Old GL Date | XML Gregorian Calendar |
Party Name | String |
Party Number | String |
Party Site | String |
Pay Date Basis Lookup Code | String |
Pay Group Lookup Code | String |
Payment Amount Total | Big Decimal |
Payment Cross Currency Conversion Rate | Big Decimal |
Payment Cross Currency Conversion Rate Date | XML Gregorian Calendar |
Payment Cross Currency Conversion Rate Type | String |
Payment Currency Code | String |
Payment Currency Invoice Amount | Big Decimal |
Payment Function | String |
Payment Method Code | String |
Payment Method Lookup Code | String |
Payment Priority | Big Decimal |
Payment Processing Transaction Type Code | String |
Payment Reason Code | String |
Payment Status Indicator | String |
Payment Terms | String |
PO Buyer | String |
PO Header ID | Long |
PO Number | String |
Port of Entry Code | String |
Posting Indicator | String |
Posting Status | String |
Prepayment Amount Applied | Big Decimal |
Prepayment Type Lookup Code | String |
Prepayment Withholding Amount | Big Decimal |
Quick Credit | String |
Quick PO Number | String |
Recalculate Payment Schedules | String |
Reference Key 1-5 | String |
Reference 1-2 | String |
Release Amount net of Tax | Big Decimal |
Remittance Message 1-3 | String |
Requester ID | Long |
Requester Name | String |
Routing Attribute 1-5 | String |
Selected for Payment Indicator | String |
Self Assessed Tax Amount | Big Decimal |
Sequence Number | String |
Settlement Priority | String |
Source | String |
Supplier Name | String |
Supplier Number | String |
Supplier Site Code | String |
Supplier Tax Invoice Conversion Rate | Big Decimal |
Supplier Tax Invoice Date | XML Gregorian Calendar |
Supplier Tax Invoice Number | String |
Supplier Type | String |
Tax Effective Date | XML Gregorian Calendar |
Tax Invoice Internal Sequence | String |
Tax Invoice Recording Date | XML Gregorian Calendar |
Taxation Country | String |
Taxation Country Name | String |
Temporary Canceled Amount | Big Decimal |
Temporary Supplier Name | String |
Terms Date | XML Gregorian Calendar |
Terms Date Basis | String |
Total Tax Amount | Big Decimal |
Transaction Business Category | String |
Unique Remittance Identifier Check Digit | String |
Unposted Distributions | String |
Unposted Void Payment Indicator | String |
US Standard General Ledger Transaction Code | String |
US Standard General Ledger Transaction Code Context | String |
User Conversion Type | String |
User-Defined Fiscal Classification | String |
Validated Tax Amount | Big Decimal |
Voucher Number | String |
Withholding Tax Amount | Big Decimal |
Workflow Approval Status | String |
Invoice Line
Attribute Name | Attribute Type |
---|---|
Account Segment | String |
Accounting Date | XML Gregorian Calendar |
Adjustment Reason | String |
Amount | Big Decimal |
Assessable Value | Big Decimal |
Asset Book Type Code | String |
Assets Tracking Indicator | String |
Attribute Category | String |
Balancing Segment | String |
Base Amount | Big Decimal |
Canceled Indicator | String |
Control Amount | Big Decimal |
Corrected Line Number | Integer |
Cost Center Segment | String |
Country of Supply | String |
Created By | String |
Creation Date | XML Gregorian Calendar |
Daily Amount | Big Decimal |
Deferred Accounting Indicator | String |
Deferred Accounting Period Type | String |
Deferred Expense Period End Date | XML Gregorian Calendar |
Deferred Expense Period Start Date | XML Gregorian Calendar |
Deferred Expenses Number of Periods | Integer |
Description | String |
Descriptive Flexfield Attribute 1-15 | String |
Discarded Status Indicator | String |
Distribution Set Name | String |
Expenditure Item Date | XML Gregorian Calendar |
Expenditure Organization ID | Long |
Expenditure Type | String |
Expense End Date | XML Gregorian Calendar |
Expense Group | String |
Expense Start Date | XML Gregorian Calendar |
Final Match Indicator | String |
Global Attribute Category | String |
Global Descriptive Flexfield 1-20 | String |
Included Tax Amount | Big Decimal |
Income Tax Region | String |
Income Tax Type 1099 | String |
Item Description | String |
Justification | String |
Last Updated By | String |
Last Updated Date | XML Gregorian Calendar |
Last Updated Login | String |
Line Group Number | Integer |
Line Number | Integer |
Line Source | String |
Line Type Lookup Code | String |
Manufacturer | String |
Match Type | String |
Merchant Document Number | String |
Merchant Name | String |
Merchant Reference | String |
Merchant Tax Registration Number | String |
Model Number | String |
Original Amount | Big Decimal |
Original Base Amount | Big Decimal |
Original Rounding Amount | Big Decimal |
Period Name | String |
Person Name of Project Manager | String |
Person Number of the Project Manager | String |
PO Buyer | String |
PO Distribution ID | Long |
PO Header ID | Long |
PO Line ID | Long |
Prepayment Line Number | Integer |
Primary Intended Use | String |
Product Category | String |
Product Fiscal Classification | String |
Product Type | String |
Program Update Date | XML Gregorian Calendar |
Project ID | Big Decimal |
Project Item Quantity | Big Decimal |
Projects Invoice Processed Status | String |
Projects Receivable Intercompany Invoice Line Number | Long |
Prorate Across All Items | String |
Purchasing Category ID | Long |
Quantity Invoiced | Big Decimal |
Receipt Conversion Rate | Big Decimal |
Receipt Currency Amount | Big Decimal |
Receipt Currency Code | String |
Receiving Transaction ID | Long |
Reference Key 1-5 | String |
Reference1-2 | String |
Requester ID | Long |
Requester Name | String |
Retained Amount | Big Decimal |
Retained Amount Remaining | Big Decimal |
Retained Line Number | Integer |
Rounding Amount | Big Decimal |
Serial Number | String |
Source Entity Code | String |
Source Event Class Code | String |
Source Transaction Level Type | String |
Statistical Amount | Big Decimal |
Tax Already Calculated Indicator | String |
Tax Classification Code | String |
Tax Jurisdiction Code | String |
Tax Name | String |
Tax Rate | Big Decimal |
Tax Rate Code | String |
Tax Regime Code | String |
Tax Status Code | String |
Total Nonrecoverable Tax Amount | Big Decimal |
Total Nonrecoverable Tax Amount Functional Currency | Big Decimal |
Total Recoverable Tax Amount | Big Decimal |
Total Recoverable Tax Amount Functional Currency | Big Decimal |
Transaction Business Category | String |
Unit of Measure Lookup Code | String |
Unit Price | Big Decimal |
US Standard General Ledger Transaction Code | String |
User-Defined Fiscal Classification | String |
Warranty Number | String |
Workflow Approval Status | String |
Invoice Installments
Attribute Name | Attribute Type |
---|---|
Amount Remaining | Big Decimal |
Attribute Category | String |
Attribute Date 1-5 | XML Gregorian Calendar |
Attribute Number 1-5 | Big Decimal |
Created By | String |
Creation Date | XML Gregorian Calendar |
Database Events Complete Indicator | String |
Descriptive Flexfield Attribute 1-15 | String |
Discount Amount Remaining | Big Decimal |
Discount Date | XML Gregorian Calendar |
Due Date | XML Gregorian Calendar |
First Discount Amount Available | Big Decimal |
First Installment Payment Method Name | String |
Global Attribute Category | String |
Global Attribute Date 1-5 | XML Gregorian Calendar |
Global Attribute Number 1-5 | Big Decimal |
Global Descriptive Flexfield 1-20 | String |
Gross Amount | Big Decimal |
Held By | String |
Hold Date | XML Gregorian Calendar |
Hold Indicator | String |
Invoice Currency Gross Amount | Big Decimal |
Last Updated By | String |
Last Updated Date | XML Gregorian Calendar |
Last Updated Login | String |
Object Version Number | Integer |
Payment Cross Currency Conversion Rate | Big Decimal |
Payment Hold Reason | String |
Payment Method Code | String |
Payment Method Lookup Code | String |
Payment Number | Long |
Payment Priority | Integer |
Payment Status Indicator | String |
Remittance Message 1-3 | String |
Remit-to Address Name | String |
Remit-to Supplier Name | String |
Second Discount Amount Available | Big Decimal |
Second Discount Date | XML Gregorian Calendar |
Third Discount Amount Available | Big Decimal |
Third Discount Date | XML Gregorian Calendar |
Invoice Distribution
Attribute Name | Attribute Type |
---|---|
Account Segment | String |
Account Type | String |
Accounting Date | XML Gregorian Calendar |
Adjustment Reason | String |
Already Reversed | String |
Amount | Big Decimal |
Amount at Prepayment Invoice Exchange Rate | Big Decimal |
Amount at Prepayment Payment Exchange Rate | Big Decimal |
Asset Book Type Code | String |
Asset Book Type Name | String |
Assets Addition Indicator | String |
Assets Tracking Indicator | String |
Attribute Category | String |
Award Owning Business Unit Name | String |
Award Purpose Name | String |
Award Type Name | String |
Balancing Segment | String |
Base Amount | Big Decimal |
Base Amount Includes Rounding | String |
Base Amount Variance | Big Decimal |
Base Quantity Variance | Big Decimal |
Business Unit ID | Long |
Cancellation Indicator | String |
Cash Basis Final Application Rounding | Big Decimal |
Charge Applicable To Distribution Number | Integer |
Charge Applicable to Line Number | Integer |
Contract Name | String |
Contract Number | String |
Conversion Date | XML Gregorian Calendar |
Conversion Rate | Big Decimal |
Conversion Rate Type | String |
Corrected Quantity | Big Decimal |
Cost Center Segment | String |
Country of Supply | String |
Created By | String |
Creation Date | XML Gregorian Calendar |
Credit Card Reversal Indicator | String |
Daily Amount | Big Decimal |
Description | String |
Descriptive Flexfield Attribute 1-15 | String |
Destination Type Code | String |
Distribution Class | String |
Distribution Line Number | Long |
Distribution Match Type | String |
Distribution Transferred to Projects Indicator | String |
Encumbered | String |
Encumbered Indicator | String |
Encumbered Tax Line Exists | String |
Expenditure Item Date | XML Gregorian Calendar |
Expenditure Organization ID | Long |
Expenditure Organization Name | String |
Expenditure Type | String |
Expenditure Type Name | String |
Expense End Date | XML Gregorian Calendar |
Expense Group | String |
Expense Start Date | XML Gregorian Calendar |
Extra Purchase Order Conversion Rate Variance | Big Decimal |
Final Application Rounding | Big Decimal |
Final Match Indicator | String |
Final Matched | String |
Final Payment Rounding | Big Decimal |
Final Release Rounding | Big Decimal |
Fully Paid and Accounted Indicator | String |
Funding Source Name | String |
Funding Source Number | String |
Global Attribute Category | String |
Global Descriptive Flexfield 1-20 | String |
GMS Burdened Raw Cost | Big Decimal |
Historical Indicator | String |
Income Tax Region | String |
Income Tax Type 1099 | String |
Intended Use | String |
Inventory Transfer Status | String |
Invoice Distribution ID | Long |
Invoice Includes Prepayment Indicator | String |
Invoice Line Number | Integer |
Justification | String |
Last Updated By | String |
Last Updated Date | XML Gregorian Calendar |
Last Updated Login | String |
Line Type Lookup Code | String |
Match Status Indicator | String |
Matched UOM Lookup Code | String |
Merchant Document Number | String |
Merchant Name | String |
Merchant Reference | String |
Merchant Tax Registration Number | String |
Multiple Tax Allocation Exist | String |
Object Version Number | Integer |
Old Accounting Date | XML Gregorian Calendar |
Old Distribution Number | Long |
Overall Posted Indicator | String |
Period Name | String |
Person Name of Principal Investigator | String |
Person Name of Project Manager | String |
Person Number of Principal Investigator | String |
Person Number of the Project Manager | String |
PO Accrue On Receipt Indicator | String |
PO Distribution ID | Long |
PO Matched | String |
Posted Indicator | String |
Posted Status | String |
Program Update Date | XML Gregorian Calendar |
Project Billable Indicator | String |
Project Capitalizable Indicator | String |
Project Context Category | String |
Project Expenditure Item Date | XML Gregorian Calendar |
Project Expenditure Type ID | Big Decimal |
Project ID | Big Decimal |
Project Item Quantity | Big Decimal |
Project Name | String |
Project Number | String |
Project Organization ID | Big Decimal |
Project Owning Business Unit Name | String |
Project Type Name | String |
Project User Defined Attribute 1-10 | String |
Projects Committed Cost Transfer Indicator | String |
Projects Reserved Attribute 1-9 | String |
Quantity Invoiced | Big Decimal |
Quantity Variance | Big Decimal |
Receipt Conversion Rate | Big Decimal |
Receipt Currency Amount | Big Decimal |
Receipt Currency Code | String |
Receipt Nonrecoverable Rate | Big Decimal |
Receiving Charge Addition Indicator | String |
Receiving Transaction ID | Long |
Recovery Rate Code | String |
Recovery Rate Name | String |
Recovery Type Code | String |
Reference 1-2 | String |
Retainage Release Invoice Distributions | Long |
Retained Amount Remaining | Big Decimal |
Reversal Indicator | String |
Rounding Amount | Big Decimal |
Statistical Amount | Big Decimal |
Status | String |
Task Name | String |
Task Number | String |
Tax Already Distributed Indicator | String |
Tax Line Encumbered PO Matched | String |
Tax Recoverable Indicator | String |
Taxable Amount | Big Decimal |
Taxable Base Amount | Big Decimal |
Total Distribution Amount | Big Decimal |
Total Distribution Base Amount | Big Decimal |
Unit Price | Big Decimal |
Update Projects Indicator | String |
Upgrade Base Posted Amount | Big Decimal |
Upgrade Posted Amount | Big Decimal |
Variance Amount | Big Decimal |
Withholding Tax Gross Amount | Big Decimal |
Withholding Tax Indicator | String |
Invoice Holds
Attribute Name | Attribute Type |
---|---|
Attribute Category | String |
Created By | String |
Creation Date | XML Gregorian Calendar |
Days Before Reminding | String |
Descriptive Flexfield Attribute 1-15 | String |
Held By | String |
Hold Date | XML Gregorian Calendar |
Hold Details | String |
Hold Lookup Code | String |
Hold Name | String |
Hold Notification Assignment Name | String |
Hold Reason | String |
Last Updated By | String |
Last Updated Date | XML Gregorian Calendar |
Last Updated Login | String |
Line Number | Integer |
Object Version Number | Integer |
PO Line Type for Hold | String |
PO Ordered Amount for Hold | Big Decimal |
PO Received Amount for Hold | Big Decimal |
Release Lookup Code | String |
Release Reason | String |
Release Reason for Notification | String |
Wait Days Before Notifying | String |
Workflow Status | String |
Invoice Creator
Attribute Name | Attribute Type |
---|---|
Assignment Name | String |
Assignment Number | String |
Assignment Type | String |
Grade Code | String |
Grade Name | String |
HR Organization Name | String |
Job Code | String |
Job Level | Big Decimal |
Job Name | String |
Manager Job Code | String |
Manager Job Level | Big Decimal |
Manager Type | String |
Manager User Name | String |
Position Name | String |
Invoice Requester
Attribute Name | Attribute Type |
---|---|
Assignment Name | String |
Assignment Number | String |
Assignment Type | String |
Grade Code | String |
Grade Name | String |
HR Organization Name | String |
Job Code | String |
Job Level | Big Decimal |
Job Name | String |
Manager Job Code | String |
Manager Job Level | Big Decimal |
Manager Type | String |
Manager User Name | String |
Position Name | String |
Purchase Order Header Additional Attributes
Attribute Name | Attribute Type |
---|---|
Freight Terms | String |
Total Purchase Order Matched Amount | Big Decimal |
Purchase Order Line Additional Attributes
Attribute Name | Attribute Type |
---|---|
PO Line ID | Long |
Purchase Basis | String |
Purchase Order Line Category Name | String |
Purchase Order Schedule Additional Attributes
Attribute Name | Attribute Type |
---|---|
Match Approval Level | String |
PO Line Location ID | Long |
Purchase Order Destination Type | String |
Purchase Order Destination Type Lookup Code | String |
Purchase Order Matched Amount | Big Decimal |
Cost Center Total
Attribute Name | Attribute Type |
---|---|
Cost Center | String |
Cost Center Manager ID | String |
Cost Center Manager Name | String |
Cost Center Name | String |
Invoice Number | String |
Total Amount | Big Decimal |
Total Base Amount | Big Decimal |
Supplier Descriptive Flexfields
Attribute Name | Attribute Type |
---|---|
Supplier Descriptive Flexfield 1-20 | String |
Supplier Descriptive Flexfield Number 1-10 | Big Decimal |
Supplier Site Descriptive Flexfields
Attribute Name | Attribute Type |
---|---|
Supplier Site Descriptive Flexfield 1-20 | String |
Supplier Site Descriptive Flexfield Number 1-10 | Big Decimal |
Task
Attribute Name | Attribute Type |
---|---|
Workflow Submitter | String |
Workflow Submitter Display Name | String |
Project Classification
Attribute Name | Attribute Type |
---|---|
Class Code Percentage | Double |
Project Class Category | String |
Project Class Code | String |
Project ID | Long |
Project Task
Attribute Name | Attribute Type |
---|---|
Business Unit Name | String |
Legal Entity Name | String |
Project Currency Code | String |
Project ID | Long |
Project ledger Currency Code | String |
Project Manager | String |
Project Name | String |
Project Number | String |
Project Organization Name | String |
Project Task ID | Long |
Project Type ID | Long |
Project Type Name | String |
Project Unit Name | String |
Sponsored Indicator | String |
Task Manager | String |
Task Name | String |
Task Number | String |
Task Organization | String |
Work Type Name | String |
Project Team Member
Attribute Name | Attribute Type |
---|---|
Project ID | Long |
Project Party ID | Long |
Projects Track Time | String |
Team Member Email Address | String |
Team Member End Date | XML Gregorian Calendar |
Team Member Role Name | String |
Team Member Start Date | XML Gregorian Calendar |
Team Member User Name | String |
Advanced Configuration
Attribute Name | Attribute Type |
---|---|
Absolute | Big Decimal |
Average | Big Decimal |
Count | Integer |
Index Of Character | String |
Maximum | Big Decimal |
Minimum | Big Decimal |
Negate | Big Decimal |
Replace All | String |
Sub String | String |
Sum | Big Decimal |
Transform To Lower Case | String |
Transform To Upper Case | String |
Trim White Space | String |