Posts in: SQL
EFF - Flexfield Context Details
Retrieve context-level details for the descriptive flexfield 'DOO_FULFILL_LINES_ADD_INFO', including context codes, identifiers, and enabled flags.
Read More →GL - Journal Entry Line Details
Retrieve detailed GL journal entry line information, including ledger, currency, subledger, and accounting class data, filtered by ledger name, journal source, date range, and status code.
Read More →INV - Inventory Item Details
Retrieve detailed inventory item information including organization, item attributes, planning codes, quantities, dimensions, weight, volume, and reservations for a specific item and organization.
Read More →INV - Employee Name From Cycle Count
Retrieve employee names who performed cycle counts along with cycle count and inventory item IDs.
Read More →INV - Inventory Item Details
Retrieve detailed information about inventory items, including control codes, planning flags, and transactional flags for items starting with AS54%.
Read More →