NetSuite saved-search CSV export
A CSV produced by whatever columns a saved search happened to define, which people treat as a standard report with fixed meaning, when its headers are arbitrary aliases, its amounts depend on which currency field was chosen, and it often asserts no total to reconcile against at all.
The shape, how the file is really laid out
The header row is the search's Results columns, display labels the author can
rename freely, so two searches both titled "GL Detail" can share no columns.
If the search uses Summary types (Group / Sum / Count), rows are pre-aggregated
and may end in a total; a non-summary search returns raw line rows with no
total. Formula(Numeric/Text) columns compute values on the fly. Dates and
timestamps render in the running user's time zone and number-format
preferences (parentheses vs minus, separators). In a OneWorld account the
amount can come from Amount, Amount (Foreign Currency), or a base/consolidated
field, and transaction-type sign conventions apply.
The traps
The column labels tell you nothing reliable, they are human aliases over unstated field IDs, so the same header can mean different fields across exports.
- Every trap in this export, worked through
- The reconciliation anchor, the total the file asserts about itself
- The refusal cases, when to stop and ask instead of guess
Reference: Oracle NetSuite Help Center, "Saved Searches", search Results columns, and Summary types · NetSuite Help, export preferences, time zone and OneWorld currency fields (reference only)