Table Reference
Use this list in Step 3 of the setup guide to work out which domains your Weld security group needs Get access to. Tables are grouped by the Workday web service they come from.
Domains to grant names the domains to pick in Maintain Permissions for Security Group for each table, as most tenants set them up. Many of the domains that secure an operation are part of a larger domain and cannot be picked on their own. For those, the table names the larger domain to grant, and covers names the domain that View Security for Securable Item shows for the operation. For example, journal_entry is secured by Process: Journals - View, which you grant through Process: Journals (NEW).
Where a table lists domains joined by or, Get access to any one of them is enough. Semicolons separate the domains of different operations, as for ledger, and each operation needs one of its domains. Your tenant can differ: if a domain is not in the list when you grant access, or a table still fails after you activate the changes, look up the domains your tenant uses.
ledger is read with three operations. Workday only returns ledgers that are asked for by name, so Weld first lists your companies and reads one journal from each to find the ledger it posts to. Without access to the company and journal domains, ledger fails even when the ledger domain is granted.
All domains
To sync every table, grant Get access to these domains. Where a line names two, either one is enough. Some are named after Workday tasks, such as Create: Cost Center, because they are the only domains that secure that data. With Get Only, Weld can read through them but cannot create or change anything.
- Create: Cost Center
- Manage: Organization Integration
- Process: Alternate Customer Contract
- Process: Billing
- Process: Customer Contract (NEW)
- Process: Customer Invoice - View
- Process: Customer Invoice Payment
- Process: Goods Delivery
- Process: Inventory
- Process: Inventory Pick List
- Process: Inventory Shipment
- Process: Inventory Stock Request
- Process: Opportunity
- Process: Order Fulfillment
- Process: Purchase Order
- Process: Purchase Order Acknowledgement
- Process: Receipt/Return (NEW)
- Process: Request for Quotes
- Process: Requisition
- Process: Settlement
- Process: Supplier Catalogs
- Process: Supplier Contract
- Process: Supplier Invoice
- Process: Supplier Invoice - View
- Process: Supplier Refund
- Reports: Customer
- Reports: Supplier
- Set Up: Accounts
- Set Up: Audit Tags and Assignments
- Set Up: Commodity Codes
- Set Up: Company
- Set Up: Currency Rates
- Set Up: Customer Accounts
- Set Up: Customer Contracts
- Set Up: Financial Accounting
- Set Up: Procurement
- Set Up: Project Billing
- Set Up: Purchase Item
- Set Up: Revenue
- Set Up: Sale Item
- Set Up: Settlement
- Set Up: Supplier
- Set Up: Supplier Invoice Work Queue
- Set Up: Worktags
- Process: Headcount Planning or Process: Headcount Plan (HCM)
- Process: Journals (NEW) or Reports: Organization Journals Reporting
- Process: Project Billing or Set Up: Customer Milestones
payment and payment_message also need the settlement domain of each payment type you pay out through Workday, for example Process: Supplier Invoice Payment/Settlement for supplier payments:
- Process: Supplier Invoice Payment/Settlement
- Process: Expense Report Payment/Settlement
- Process: Ad Hoc Payment Settlement
- Process: Customer Refund Settlement
- Process: Customer Invoice Payment/Settlement
- Process: Intercompany Payment/Settlement
- Process: Procurement Card Payment/Settlement
- Process: Miscellaneous Payment Request Settlement
- Process: Bank Account Transfer for Settlement/Settlement
- Process: Payroll Settlement
- Process: Payroll Third-Party Payments Settlement
- Process: Student Payment/Settlement
- Process: Pending Student Refund/Settlement
- Process: Student Sponsor Refund/Settlement
Domains by table
Financial Management
| Weld table | Workday operation | Domains to grant |
|---|---|---|
account_set | Get_Account_Sets | Set Up: Accounts |
audit_tag | Get_Audit_Tags | Set Up: Audit Tags and Assignments |
company | Get_Workday_Companies | Set Up: Company (covers Set Up: Company General) |
cost_center | Get_Cost_Centers | Create: Cost Center |
currency | Currency_GetAll | Set Up: Currency Rates |
currency_conversion_rate | Get_Currency_Conversion_Rates | Set Up: Currency Rates |
currency_rate_type | Get_Currency_Rate_Types | Set Up: Currency Rates |
custom_worktag | Get_Custom_Worktags | Set Up: Worktags (covers Set Up: Maintain Custom Worktags) |
headcount_plan | Get_Headcount_Plan | Process: Headcount Planning or Process: Headcount Plan (HCM) |
journal_entry | Get_Journals | Process: Journals (NEW) (covers Process: Journals - View) or Reports: Organization Journals Reporting (covers View: Organization Journals) |
journal_source | Get_Journal_Sources | Set Up: Financial Accounting (covers Set Up: Journal Source) |
ledger | Get_Workday_Companies, Get_Journals, Get_Ledgers | Set Up: Company (covers Set Up: Company General); Process: Journals (NEW) (covers Process: Journals - View) or Reports: Organization Journals Reporting (covers View: Organization Journals); Set Up: Financial Accounting (covers Set Up: Ledger and Book) |
payment | Get_Payments | Process: Settlement, plus the settlement domain of each payment type you pay out |
payment_term | Get_Payment_Terms | Set Up: Customer Accounts or Set Up: Supplier Accounts |
payment_type | Get_Payment_Types | Set Up: Settlement |
revenue_category | Get_Revenue_Categories | Set Up: Financial Accounting (covers Set Up: Revenue Categories) |
revenue_category_hierarchy | Get_Revenue_Category_Hierarchies | Set Up: Financial Accounting (covers Set Up: Revenue Categories) or Set Up: Worktags (covers Set Up: Basic Revenue Category Worktag) |
Resource Management (procurement and supplier accounts)
| Weld table | Workday operation | Domains to grant |
|---|---|---|
business_entity_contact | Get_Business_Entity_Contacts | Set Up: Customer Contacts or Set Up: Supplier (covers Set Up: Supplier Contacts) |
catalog_item | Get_Catalog_Items | Process: Supplier Catalogs |
commodity_code | Get_Commodity_Codes | Set Up: Commodity Codes |
commodity_code_type | Get_Commodity_Code_Types | Set Up: Commodity Codes |
item_identifier_type | Get_Item_Identifier_Types | Set Up: Procurement |
purchase_item | Get_Purchase_Items | Set Up: Purchase Item |
purchase_item_list | Get_Purchase_Item_Lists | Set Up: Procurement |
purchase_order | Get_Purchase_Orders | Process: Purchase Order (covers Process: Purchase Order - View) |
purchase_order_acknowledgement | Get_Purchase_Order_Acknowledgements | Process: Purchase Order Acknowledgement (covers Process: Purchase Order Acknowledgement - View) |
purchase_order_schedule | Get_Purchase_Order_Schedules | Process: Supplier Contract (covers Process: Supplier Contract - Purchase Order) |
receipt | Get_Receipts | Process: Receipt/Return (NEW) (covers Process: Receipt/Return - View) or Process: Purchase Order (covers Process: Purchase Order - View) |
receipt_adjustment | Get_Receipt_Adjustments | Process: Receipt/Return (NEW) (covers Process: Receipt/Return - View) |
request_for_quote | Get_Request_for_Quote | Process: Request for Quotes (covers Process: Request for Quotes - View) |
request_for_quote_award | Get_Request_for_Quote_Awards | Process: Request for Quotes (covers Process: Request for Quotes - View) |
request_for_quote_response | Get_Request_for_Quote_Responses | Process: Request for Quotes (covers Process: Request for Quotes - View) |
requesting_entity | Get_Requesting_Entities | Set Up: Procurement |
requisition | Get_Requisitions | Process: Requisition |
resource_category | Get_Resource_Categories | Set Up: Financial Accounting (covers Set Up: Spend Categories) |
return | Get_Returns | Process: Receipt/Return (NEW) (covers Process: Receipt/Return - View) |
spend_category_hierarchy | Get_Spend_Category_Hierarchies | Set Up: Financial Accounting (covers Set Up: Spend Categories) |
supplier | Get_Suppliers | Reports: Supplier |
supplier_catalog | Get_Supplier_Catalogs | Process: Supplier Catalogs |
supplier_classification | Get_Supplier_Classifications | Set Up: Supplier (covers Set Up: Supplier Maintenance) |
supplier_contract | Get_Supplier_Contracts | Process: Supplier Contract (covers Process: Supplier Contract - View) |
supplier_contract_amendment | Get_Supplier_Contract_Amendments | Process: Supplier Contract (covers Process: Supplier Contract - View) |
supplier_contract_lease_amendment | Get_Supplier_Contract_Lease_Amendments | Process: Supplier Contract (covers Process: Supplier Contract - View) |
supplier_invoice | Get_Supplier_Invoices | Process: Supplier Invoice - View |
supplier_invoice_adjustment | Get_Supplier_Invoice_Adjustments | Process: Supplier Invoice - View |
supplier_invoice_assignment_rule | Get_Supplier_Invoice_Assignment_Rules | Set Up: Supplier Invoice Work Queue |
supplier_invoice_request | Get_Supplier_Invoice_Requests | Process: Supplier Invoice (covers Process: Supplier Invoice - Request) |
supplier_invoice_schedule | Get_Supplier_Invoice_Schedules | Process: Supplier Contract (covers Process: Supplier Contract - Supplier Invoice) |
supplier_item | Get_Supplier_Items | Set Up: Purchase Item |
supplier_refund | Get_Supplier_Refunds | Process: Supplier Refund (covers Process: Supplier Refund - View) |
Revenue Management (customers, contracts, billing and revenue recognition)
| Weld table | Workday operation | Domains to grant |
|---|---|---|
alternate_customer_contract | Get_Alternate_Customer_Contracts | Process: Alternate Customer Contract |
billing_schedule | Get_Billing_Schedules | Process: Billing (covers Process: Billing Schedule - View) |
billing_schedule_template | Get_Billing_Schedule_Templates | Set Up: Customer Accounts |
consolidated_invoice | Get_Consolidated_Invoices | Process: Customer Invoice - View |
customer | Get_Customers | Reports: Customer |
customer_activity | Get_Customer_Activity | Process: Opportunity |
customer_contract | Get_Customer_Contracts | Process: Customer Contract (NEW) (covers Process: Customer Contract - View) |
customer_contract_amendment | Get_Customer_Contract_Amendments | Process: Customer Contract (NEW) (covers Process: Customer Contract - View) |
customer_contract_discount_and_premium | Get_Customer_Contract_Discount_and_Premium | Process: Customer Contract (NEW) (covers Process: Customer Contract - Core) |
customer_contract_renewal_term | Get_Customer_Contract_Renewal_Terms | Process: Customer Contract (NEW) (covers Process: Customer Contract - View) |
customer_contract_template | Get_Customer_Contract_Templates | Set Up: Customer Contracts (covers Set Up: Customer Contracts - Templates and Types) |
customer_contract_type | Get_Customer_Contract_Types | Set Up: Customer Contracts (covers Set Up: Customer Contracts - Templates and Types) |
customer_date_milestone | Get_Customer_Date_Milestones | Process: Project Billing (covers Process: Project Billing - View) or Set Up: Customer Milestones |
customer_invoice | Get_Customer_Invoices | Process: Customer Invoice - View |
customer_invoice_adjustment | Get_Customer_Invoice_Adjustments | Process: Customer Invoice - View |
customer_payment | Get_Customer_Payments | Process: Customer Invoice Payment |
order_fulfillment_transaction | Get_Order_Fulfillment_Transactions | Process: Order Fulfillment |
revenue_adjustment_reason | Get_Revenue_Adjustment_Reasons | Set Up: Project Billing (covers Set Up: Project Billing - Configurations) |
revenue_allocation_configuration | Get_Revenue_Allocation_Configurations | Set Up: Revenue (covers Set Up: Revenue - Allocations) |
revenue_recognition_schedule | Get_Revenue_Recognition_Schedules | Process: Customer Invoice - View or Process: Revenue (covers Process: Revenue Schedule - View) |
sales_item | Get_Sales_Items | Set Up: Sale Item |
sales_item_fair_value_price_list | Get_Sales_Item_Fair_Value_Price_Lists | Set Up: Revenue (covers Set Up: Revenue - Allocations) |
sales_item_group | Get_Sales_Item_Groups | Set Up: Sale Item |
sales_item_price_list | Get_Sales_Item_Price_Lists | Set Up: Sale Item or Set Up: Customer Contracts (covers Set Up: Customer Contracts - Price Lists) |
Inventory
| Weld table | Workday operation | Domains to grant |
|---|---|---|
goods_delivery_ticket | Get_Goods_Delivery_Tickets | Process: Goods Delivery (covers Process: Goods Delivery - View) |
inventory_par_location | Get_Inventory_Par_Locations | Process: Inventory or Manage: Par Inventory |
inventory_picking_list | Get_Inventory_Picking_Lists | Process: Inventory Pick List (covers Process: Inventory Pick List - View) |
inventory_return_order | Get_Inventory_Return_Orders | Process: Inventory |
inventory_shipment | Get_Inventory_Shipments | Process: Inventory Shipment (covers Process: Inventory Shipment - View) |
inventory_stock_request | Get_Inventory_Stock_Requests | Process: Inventory Stock Request (covers Process: Inventory Stock Request - View) |
inventory_transaction | Get_Inventory_Transactions | Process: Inventory |
item_lot | Get_Item_Lots | Set Up: Inventory or Process: Inventory |
manufacturer | Get_Manufacturers | Set Up: Purchase Item |
Cash Management
| Weld table | Workday operation | Domains to grant |
|---|---|---|
payment_message | Get_Payment_Messages | Process: Settlement, plus the settlement domain of each payment type you pay out |
Human Resources (organizations)
| Weld table | Workday operation | Domains to grant |
|---|---|---|
organization | Get_Organizations | Manage: Organization Integration |