 |
| ||||||||
Support Note KB0393558
Approval Process and Lookup Table Fieldpath Configuration Information
| Common For Many Approvable Documents: Applies to Requisitions, Invoices, Invoice Reconciliations, Contract Requests | ||
| Common Term for Field | Field Name used in Columns to Include in CSV File | Description and Additional Information |
| Header Level Fields | xxxxxxxxxx | Fields That Live at the Header of the Approvable |
| Header Purchasing Unit | ProcurementUnit | The Purchasing Unit at the Header of the Approvable. |
| Total Cost | TotalCost | The Total Cost of the Approvable in the currency of the preparer, stored as a Money field (Example: $500 United States Dollars (USD)). This is useful when the site uses many different currencies, and Currency Conversion must be considered when comparing two values in different currencies. |
| Total Cost | TotalCost.Amount | The Total Cost of the Approvable in the currency of the preparer, stored as a decimal value without any currency unit (Example: 500.0000). This should not be used with Currency Conversion because this is a static decimal value. |
| Total Cost | TotalCost.ApproxAmountInBaseCurrency | The Total Cost of the Approvable converted to the system's default currency, stored as a decimal Value (Example: 500.0000). The .ApproxAmountInBaseCurrency attribute can be useful in setting up Approval Rules because this can be used on any Money field in Ariba. If implemented on all Money fields used in the Approval Process, setting limits for users across multiple currencies can be controlled through the amount at the system's default currency (the system runs the conversion in the background when executing the Approval Rules). |
| Total Cost Currency | TotalCost.Amount.Currency | The currency in which the Total Cost is stored (preparer's default currency). |
| On Behalf Of | Requester.UniqueName | The On Behalf Of individual or Requester chosen during creation of the Approvable. |
| Supervisor of the "On Behalf Of" | Requester.Supervisor.UniqueName | The direct supervisor of the On Behalf Of individual or Requester. If this value is used as the Approver and no direct supervisor is present, then, the Customer Administrator is added to the Approval Flow. |
| Supervisor of the "On Behalf Of" | Requester.FirstActiveSupervisor.UniqueName | The first active supervisor of the On Behalf Of individual or Requester. When using this fieldpath, the system bypasses an inactive supervisor and looks up the Chain of Command for the next active supervisor. |
| Approval Limit of the "On Behalf Of" | Requester.ApprovalLimit | The Approval Limit of the On Behalf Of individual or Requester designated in the user imports into Ariba. This value is stored in the system's default currency. |
| Line Level Fields | LineItems.xxxxxxxxxx | Fields That Live in the Line Items of the Approvable |
| Non-Catalog Item | LineItems.IsNonCatalog | This field value is true if the line item is none of the following: FixedFeeType, ExpenseType, MilestoneType, ContractorExpenseType, PunchOutType, ModifiedCatalogType, CatalogType. |
| Line Item Total | LineItems.Amount | The total line-item amount (price times quantity), stored as a Money field (Example: $500 USD). This is useful when the site uses many different currencies, and Currency Conversion must be considered when comparing two values in different currencies. |
| Line Item Total | LineItems.Amount.Amount | The total line-item amount, stored as a decimal value without any currency unit (Example: 500.0000). This should not be used with Currency Conversion because this is a static decimal value. |
| Line Item Total Currency | LineItems.Amount.Currency | The currency in which the total line-item amount is stored (currency defined for the item in the catalog, or currency selected by the preparer for a non-catalog item). |
| Supplier | LineItems.Supplier.UniqueName | A unique identifier for the partitioned supplier used on the line item, which is the supplier that is used on requisitions, invoices, etc. This supplier data is loaded via the Import Suppliers task (Supplier.csv file). |
| Supplier Location | LineItems.SupplierLocation.UniqueName | A unique identifier for the supplier location used on the line item. This supplier data is loaded via the Import Suppliers task (SupplierLocation.csv file) and Import Supplier Location Contacts task (SupplierLocationSupplement.csv file). |
| Supplier Part Number | LineItems.Description.SupplierPartNumber | The part number assigned to the item by the supplier. |
| Commodity Code | LineItems.Description.CommonCommodityCode.UniqueName | The unique identifier of the Commodity Code used on the line item. |
| Unit Price | ||
Applies To
Core Procurement > Core Administration
Core Procurement > Core Administration > Approval Flows
Core Procurement > Core Administration > Approver lookups
Invoicing
Purchasing > Services Procurement