Attributes for 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